This whole process should be made more intuitive. Basically, we are talking about simple, standard database usage, and for this process to be fraught with problems makes the use of some sort of admin GUI not as usable as it should be.
Image the situation as I experienced. With decades of usage experience, I was totally a newbie in how to properly handle the export of my web site cms database from my old host to the import on my new host. There are issues that may have to do with passwords and users, with database/table format changes, and what-have-you. So much is unknown, and too many times the user is left to trying to figure out some cryptic error message from MySQL. Any admin interface should have taken care of that, and yet we find that phpMyAdmin is not as intuitive as it should be.
This export/import process needs to be made automated and goof-proof. It offers too many confusing and non-basic options. Perhaps a simple wizard would be the most useful. The program need to be tuned up with less geek-speak, and particularly in any wizard design.
That's my two cents' worth. Thanks for the fine efforts.