Question

Can't migrate wordpress website

I moved to DO from shared hosting. lemp Nginx Ubuntu 14/04 I uploaded all the wordpress files using winspc to /usr/share/nginx/html i created a database and imported the older DB to it using terminal: mysql -u root -p wordpress < /usr/share/nginx/html/olddatabase.sql I changed The wp-config file. now I’m getting almost an empty wordpress website. i can find all the plugins and themes but there are no posts, pages or pictures. What can be the problem?

Subscribe
Share

Submit an answer
You can type!ref in this text area to quickly search our full set of tutorials, documentation & marketplace offerings and insert the link!

These answers are provided by our Community. If you find them useful, show some love by clicking the heart. If you run into issues leave a comment, or add your own answer to help others.

Hello, there

I will recommend to re-upload the database again as it seems some vital data is indeed missing. You can attempt a new MySQL restore on the current host and then import the database on your new droplet.

We have a series of tutorials that cover the process of migrating from one Linux server to another which you can check here:

https://www.digitalocean.com/community/tutorial_series/how-to-migrate-to-a-new-linux-server

Another option is to use the All-in-One WP Migration plugin. The plugin can handle the migration process on your behalf.

https://wordpress.org/plugins/all-in-one-wp-migration/

This article also covers the process, although it is outdated:

https://www.digitalocean.com/community/tutorials/how-to-migrate-wordpress-from-shared-hosting-to-a-cloud-server-with-zero-downtime

The final step will be to test everything and make sure it is working fine and then switch the DNS settings and push your site live from DigitalOcean.

Hope that this helps! Regards, Alex

Hello,

This error seems to suggest there was an error with the database export or import. Did you receive any errors? I would suggest trying again. You can also find a nice helpful guide for migrating your WordPress over here

I would suggest reviewing and following along with that as it should get your WordPress migrated.