Posted by psioni on November 21, 2008 at 11:51pm
Is there a solution for this in 6.x? ceardach's Database Scripts does this for 5.x, but has not yet been ported.
Basically my situation: I sold the domain name an existing production site was running on, and retained the content (Database A). I have a site in the same niche on another domain (Database B), into which I want to merge the old database, without losing any of the old site's data. I do not have shell access to the database server, only phpMyAdmin to work with.
Anyone have any ideas on how best to approach this?
Comments
OK, let's assume for now
OK, let's assume for now there is no automated script to accomplish this. (merging two existing websites/databases)
There is a function in phpMyAdmin which allows for global search and replace within a database. Can anyone tell me which variables I would need to edit in order to avoid wiping out existing content nodes (Page nodes)?
Node ID would be the obvious one- I figure I could just add 10,000 or something to the node ids to avoid duplicate NIDs. (Since my 1st database is about 150 nodes and the 2nd is about 2500). Would Menu Link ID's also need this treatment? Anything else?
There are no comments, and no users other than admin on either database.
Using contrib modules Nodewords and Page Title, nothing else