By pramudya81 on

Hi,

I browsed through my database. Now I wonder which table is my node content?

I have suspect on cache_node but it is blob type and I cannot read it. How to view this table?

Regards

⋅ Categories: Drupal 6.x

Comments

ayesh’s picture

ayesh commented

It's node table.

What's new and changing in PHP 8.4

pramudya81’s picture

pramudya81 commented

I looked through the node table. But it seems does not cotain ALL my website content....Why?
cache_node is more complete.

pramudya81’s picture

pramudya81 commented

Anyone on this?

Thx

steeph’s picture

steeph commented

What do you mean exactly with content? The node table contains all nodes on your site. If it's not in the table, it's not there or not a node. If you have nodes in your cache that aren't in the node table that would mean some nodes got deleted in an incorrect way I think.

nevets’s picture

nevets commented

cache_node contains the cached node and is really about site performance. The actual node data is in 'node', 'node_revisions' and additional tables. If you want to load a complete node, you can use node_load().

hananc’s picture

hananc commented

Go to PhpMyAdmin and export all the database to your computer as an SQL file.

Open the SQL file and search for a string that's in one of your nodes.

See what table it is in.

If you want, you can do a "search and replace" on the exported SQL file but be VERY careful. You can easily break your site.