[support] Where are pages stored?

[Victor Kane]

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 at 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 at zmsl.com
> > <mailto:daniel.carrera at 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/ ]
>
-------------- next part --------------
An HTML attachment was scrubbed...
URL: http://lists.drupal.org/pipermail/support/attachments/20081216/8da98b61/attachment.htm