Missing latest posts and options after DB migration via phpMyAdmin

The latest posts and options are not appearing after importing the database. I'm missing all the latest posts and the latest Advanced Custom Fields.

The export is from the remote server and import to my localhost – using phpMyAdmin on both ends. The database is quite big, 50MB unzipped, but it's under 8MG bzipped, which is how I'm handling it, so I don't think that's the problem.

There are no error messages, and I get a success message after import. Nothing on the sites breaks or shows in Debug. I've tried a number of time.

I have exported and imported Wordpress databases hundreds of times in the past and have no idea why I'm experiencing this problem.

Any ideas? Thanks in advance

Topic phpmyadmin mysql database Wordpress

Category Web

1
answered at

I reviewed Wordpress' advice on phpMyAdmin and it seems I was adding one extra step which was causing the problem – ticking Add CREATE DATABASE / USE statement.

Exporting without checking this box and results in SQL that imports without any problems.

About

Geeks Mental is a community that publishes articles and tutorials about Web, Android, Data Science, new techniques and Linux security.