Daniel,<br><br>Drupal stores the basic node info in the node table. The content for page is stored in the node_revisions table.<br><br>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.<br>
<br>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.<br><br>So node_revisions is for all versions of a node, including the current one!<br>
<br>Victor Kane<br><a href="http://awebfactory.com.ar">http://awebfactory.com.ar</a><br><br><div class="gmail_quote">On Tue, Dec 16, 2008 at 9:20 AM, Daniel Carrera <span dir="ltr"><<a href="mailto:daniel.carrera@zmsl.com">daniel.carrera@zmsl.com</a>></span> wrote:<br>
<blockquote class="gmail_quote" style="border-left: 1px solid rgb(204, 204, 204); margin: 0pt 0pt 0pt 0.8ex; padding-left: 1ex;">I looked in 'nodes' and even 'node_revisions'. But I couldn't find the<br>
current text of the page. What I saw in node_revisions looked like<br>
previous copies of the pages.<br>
<br>
Ultimately, what I'm trying to do is search a particular text string in<br>
all current pages.<br>
<br>
I migrated a site to a different domain and I want to make sure that<br>
there are no links or images that point to the old domain. So I want to<br>
do a text search for the old domain in all current pages.<br>
<font color="#888888"><br>
Daniel.<br>
</font><div class="Ih2E3d"><br>
<br>
Victor Kane wrote:<br>
> Pages are stored as nodes in the database.<br>
><br>
> However, there are several tables involved since revisions for each node<br>
> are involved also.<br>
><br>
> On Tue, Dec 16, 2008 at 8:42 AM, Daniel Carrera <<a href="mailto:daniel.carrera@zmsl.com">daniel.carrera@zmsl.com</a><br>
</div><div class="Ih2E3d">> <mailto:<a href="mailto:daniel.carrera@zmsl.com">daniel.carrera@zmsl.com</a>>> wrote:<br>
><br>
> Hello,<br>
><br>
> I'm looking at the DB and I can't figure out where the page content is<br>
> stored. Does anyone know?<br>
><br>
> Daniel.<br>
> --<br>
> [ Drupal support list | <a href="http://lists.drupal.org/" target="_blank">http://lists.drupal.org/</a> ]<br>
><br>
><br>
<br>
</div>--<br>
<div><div></div><div class="Wj3C7c">[ Drupal support list | <a href="http://lists.drupal.org/" target="_blank">http://lists.drupal.org/</a> ]<br>
</div></div></blockquote></div><br>