After database migration, posts not showing up in dashboard
Transferring domains, I migrated a WordPress database using the export/import functions in phpmyadmin.
Everything worked as intended, until I tried to change permalink appearance in the WP dashboard. Since then, all posts have disappeared from the Posts tab in the WP dashboard. The posts still exist in the DB.
Measures I have tried already:
- Reimporting the DB from my backed up version.
- Changing permalink structure back to what it was originally.
- Running the WordPress database table repair protocol. (It reported no issues).
- Disabling all plugins.
- Changing the theme to twentyseventeen.
I even tried importing the DB on a fresh install of WP to see if the posts would show up. Even without modifying the permalinks, they do not.
I can create new posts and they show up in the dashboard without any problems. The permalinks also display properly. I can also visit the old permalink-style URIs of the existing posts and they display properly.
Any further ideas on what to try would be great. My client has existing content they do not wish to lose editing privileges to in the dashboard. Thank you!