Come together with the global Drupal community in Rotterdam, 28 Sept – 1 Oct 2026. Sessions, contribution, connection, and Early Bird savings until 8 June.
By michelle on
I have a live site running in 4.6. I am working on a revamped site in 4.7B4 using a copy of the database from the 4.6 site. When I have the 4.7 site ready, I want to merge them into a live 4.7 site.
I can't just copy over the entire database because there is structure as well as content stored in there. I just want to bring over the content from the live site.
Any suggestions on how to do this?
Thanks,
Michelle
Comments
suggestion
this could be totally wrong since im fairly new to drupal but i would consider the following two approaches:
SUGGESTION ONE
back up your first site's database
create two databases in the new site called drupal and drupal2
(drupal will be the one you keep)
(drupal2 is a temporary working database)
restore the first site's backup to drupal2
copy the structure from drupal2 to drupal
copy the content-related table(s) from drupal2 to drupal with a loop procedure
(how to do this i'll leave to others because i'm new to mysql)
SUGGESTION TWO
use rss and aggregator2 to move the content from the first site to the second--even on a regular basis
again i'm new so take these suggestions with a grain of salt.
i'm sure other more experienced users will chime in. i'm getting ready to launch a few sites myself that will closely resemble my original so i'll be following this thread closely.
hope these ideas help or don't hurt to bad, lol....
good luck!
___
Warren County, Virginia News & Networking: http://warrencountyreport.com
.
I already have the database in the new site, so I'm thinking I could just upgrade the old site to 4.7 and copy over the node, etc tables. The trouble is making sure I have all the tables I need plus making sure any sequence tables are updated.
The RSS feed sounds like an interesting idea. I haven't looked at RSS, so maybe someone will chime in on that.
Thanks,
Michelle