Import data in table into existing table
-
Hi, I’ve got a quite delicate MySQL/PHPMyAdmin vs. WordPress problem.
I have the data from an old site, that was running WP 2.2.3, I’ve managed to import the old data into my database. All of the tables are using another name. I’m currently running WP 2.6 on the site, and I would like to import the data within the tables (posts, comments, users etc) into the current installation of the site running 2.6.
I ran this query in PHPMyAdmin:
INSERT IGNORE INTO new_tbl SELECT * FROM orig_tbl;On the old posts table, which successfully imported all of the data within the table to the ‘new’ (2.6) posts table. However, as some of the tables in the old installation is different, and tagging is different, it didn’t quite end up the exact same way (of course).
I was now wondering what I should do in order to make this work? Is there a work around this? Is there an easier way even though the tables are formatted differently?
I guess the one thing I could do is install a fresh 2.6, run it off the old DB (2.2.3), upgrade the DB/e.g. posts to 2.6 and then import this data into the ‘old’ 2.6 currently running. Would this work? Is there an easier way?
Any help is appreciated.
Thanks
- The topic ‘Import data in table into existing table’ is closed to new replies.