Database Table node_revisions
igorjava - August 14, 2009 - 14:27
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.
Merging into a database is
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
hi
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
So you're using Organic Groups? This could complicate things. Do you have identical groups set up on both databases?
- Corey
hi
no .....the fields are not same.in what sense you mean identical.
I meant: do the groups that
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
oh
no they dont......old site has 40 groups ...new one has one...
I am using back up and migrate module
hi
i have basically 40 groups.....is there any way to do this by views....like manually...i wouldn't mind doing that