Home > other >  wordpress Database tables missing after exporting/importing them on phpMyAdmin
wordpress Database tables missing after exporting/importing them on phpMyAdmin

Time:07-01

Ok so this is the situation, i have a database that i exported from localhost, there are like 30 or more tables, but when i import them on my live site, there are only 10 tables and worst of all is that the user tables didn't make the cut so i cannot login into the dashboard and continue working, so i wonder what am i missing??? I've followed the steps of this tutorial, which is quoted or shared by so many tutorials on the internet.

here is the db on the localhost

and this is what got imported.

and this is what got imported.

CodePudding user response:

On the import screen, There is a checkbox under Partial Import stating Allow the interruption of an import in case the script detects it is close to the PHP timeout limit., make sure you have that checkbox unchecked.

CodePudding user response:

Have you tried getting into the DB via SSH? If you can do that, you can import using source path/to/import.sql.

  • Related