am trying to migrate my old site to a new site, by only copying database tables. the reason doing this way is the old site is out of date with plugins etc and i have WooCommerce installed which i dont have translated only post/pages are in 2 languages.

After iv copied over the tables when i went to pages/post it shows 0, yet WooCommerce shows all. iv ran through your WPML troubleshooting to fix any errors etc… this seems to work! but it now shows all pages but not under any lang!

How can i can copy this correctly ?

1 Answer 1


Export your tables using phpmyadmin interface. Just select those tables only that you want to export from the old database and import those tables in the new database

or you can run the command(query) in mysql to copy one table

create table newdbname.newtablename like olddbname.oldtablename;
INSERT INTO  newdbname.newtablename SELECT * FROM olddbname.oldtablename;

Repeat the same command to copy other tables


Your Answer

By clicking “Post Your Answer”, you agree to our terms of service and acknowledge you have read our privacy policy.

Not the answer you're looking for? Browse other questions tagged or ask your own question.