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?
This textbox defaults to using Markdown to format your answer.
You can type !ref in this text area to quickly search our full set of tutorials, documentation & marketplace offerings and insert the link!
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.
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:
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
Become a contributor for community
Get paid to write technical tutorials and select a tech-focused charity to receive a matching donation.
DigitalOcean Documentation
Full documentation for every DigitalOcean product.
Resources for startups and AI-native businesses
The Wave has everything you need to know about building a business, from raising funding to marketing your product.
The developer cloud
Scale up as you grow — whether you're running one virtual machine or ten thousand.
Get started for free
Sign up and get $200 in credit for your first 60 days with DigitalOcean.*
*This promotional offer applies to new accounts only.