Daniel,

Drupal stores the basic node info in the node table. The content for page is stored in the node_revisions table.

Let's suppose I create a new page, called "testtest", looking at the bottom of the node table, I see I have nid "114" with vid "117".  The vid value is the current revision for that node.

Going to the node_revisions table, I will see the exact same entries for the nid and vid fields, but in this table I will see the body and teaser content also.

So node_revisions is for all versions of a node, including the current one!

Victor Kane
http://awebfactory.com.ar

On Tue, Dec 16, 2008 at 9:20 AM, Daniel Carrera <daniel.carrera@zmsl.com> wrote:
I looked in 'nodes' and even 'node_revisions'. But I couldn't find the
current text of the page. What I saw in node_revisions looked like
previous copies of the pages.

Ultimately, what I'm trying to do is search a particular text string in
all current pages.

I migrated a site to a different domain and I want to make sure that
there are no links or images that point to the old domain. So I want to
do a text search for the old domain in all current pages.

Daniel.


Victor Kane wrote:
> Pages are stored as nodes in the database.
>
> However, there are several tables involved since revisions for each node
> are involved also.
>
> On Tue, Dec 16, 2008 at 8:42 AM, Daniel Carrera <daniel.carrera@zmsl.com
> <mailto:daniel.carrera@zmsl.com>> wrote:
>
>     Hello,
>
>     I'm looking at the DB and I can't figure out where the page content is
>     stored. Does anyone know?
>
>     Daniel.
>     --
>     [ Drupal support list | http://lists.drupal.org/ ]
>
>

--
[ Drupal support list | http://lists.drupal.org/ ]