Database Table node_revisions

Posted by igorjava on August 14, 2009 at 2:27pm

Hi,
I want to import the content data from one site to another.By browsing the database tables I found out that node_revisions table hold the data that I need . I want to import this table into the new site but I dont know if any other tables are related to this one and if so which one.
Can anyone help me with this please.

Comments

Merging into a database is

Posted by coreyp_1 on August 14, 2009 at 3:23pm

Merging into a database is not an easy task, and there are many considerations.

I will use curly braces {} when referring to database table names.

{node} is the main table for storing node info, which is linked to {node_revisions} by a common nid (node ID) and vid (version ID, for revisions). That is not the end of the story, though.

If you are using CCK, then each node type may have an additional table, again linked by nid and vid. In Addition, CCK fields may also have a separate table, especially if they are set to allow for more than one value.

If you allow uploads (the upload module or a CCK filefield derivative) then you must also include the appropriate rows from {files}, but it is linked via fid (file ID), which in turn could be linked to {node_revisions} in several different ways, depending on the module setup.

Taxonomy has its own complications, using various {term_*} tables.

Comments are their own beast, using the {comments} table, linked to {node} via nid.

And there may be other tables, too, depending on your setup. I'm not trying to discourage you, I'm just trying to provide as much info as possible so that you will be successful in your attempt.

Standard warnings apply: back up your database first!!!

-Corey

- Corey
http://www.thefreecollege.com

hi

Posted by igorjava on August 14, 2009 at 3:37pm

hi thanks for reply....I need only groups and group posts. This are screenshots of the fields i have.If you can give me any directions it would be greatly appreciated.
http://www.picupine.com/22dec01x

So you're using Organic

Posted by coreyp_1 on August 14, 2009 at 3:54pm

So you're using Organic Groups? This could complicate things. Do you have identical groups set up on both databases?

- Corey
http://www.thefreecollege.com

hi

Posted by igorjava on August 14, 2009 at 3:58pm

no .....the fields are not same.in what sense you mean identical.

I meant: do the groups that

Posted by coreyp_1 on August 14, 2009 at 4:03pm

I meant: do the groups that exist in the source database also exist in the target database?

Either way, you're up for a difficult migration. Have you tried any of the pre-existing import/export modules?

http://drupal.org/project/node_export
http://drupal.org/project/node_import

-Corey

- Corey
http://www.thefreecollege.com

oh

Posted by igorjava on August 14, 2009 at 4:07pm

no they dont......old site has 40 groups ...new one has one...
I am using back up and migrate module

hi

Posted by igorjava on August 14, 2009 at 4:04pm

i have basically 40 groups.....is there any way to do this by views....like manually...i wouldn't mind doing that