SQL file imported without errors but I don't see any new post in my WordPress site

Migrate to WordPress

You followed these instructions to import the SQL file and no errors were reported during the import process (typically you’d see a green message saying something like “X commands were successfuly executed”). Still, when you refresh your WordPress site you don’t see any new post/page/… there.

wp_custom_prefixMost likely this is due one of the two following reasons:

  • You imported the file in the wrong database. This can only happen if you are using the “from outside” option to import the file and you didn’t check which database was hosting your WordPress site. So please get back to the import instructions and repeat the process.
  • Your WordPress installation is not using the standard WordPress prefix (“wp_”) and you forgot to tell us your prefix (maybe you didn’t even know) so you end up with two sets of WordPress tables: the ones your WordPress site is actually using and the ones created during the import which are blissfully ignored (as in the image on the left, the “wp_” ones are the tables generated during the migration, the rest are the WordPress tables in use). In this case, you’ll need to drop the “wp_” tables and we’ll need to rerun the migration process to generate a new SQL file that matches your custom prefix.

Posted in: Content export / import migratetowpSQL file imported without errors but I don’t see any new post in my WordPress site