I'm exporting my database from one host so I can move to another. I successfully exported the database and all it's tables. I then import it to my new host. A successful message appears but not every table is imported for some strange reason.
Any suggestions?
obviously you have to drop the imported database and re-import!
comparing the databases and importing missing tables could be a complex task.
(2013-04-17, 04:47 PM).m. Wrote: [ -> ]obviously you have to drop the imported database and re-import!
comparing the databases and importing missing tables could be a complex task.
I've tried that. 
What table is missing? Also, did you check config.php for any prefix mistakes?
(2013-04-17, 05:32 PM)Jimmy. Wrote: [ -> ]What table is missing? Also, did you check config.php for any prefix mistakes?
It's nothing to do with any of my core files. Various tables become missing every time I import a new copy.
Well, that means that your phpMyAdmin is not able to export properly. Try individually exporting the missing tables and import them to your new database.
I used the built in database backup feature on MyBB. Works perfectly now, thank god for that feature!