If you have a large database phpmyadmin usually like to "time out"
when restoring large databases.
If you gonna restore the whole database (and it's not to large) you
have to click the "sql query window" up in the left corner.
After that (in the pop-up window) click import files.
That's the only way to import databases that has the
"CREATE DATABASE" statement.
It would be a better idea though to backup each database separately.
You do that by clicking the database name in the left drop down, then
choose export. (Be sure to select all tables).
Restoring of large databases are best done with bigdump.
3000 lines at a time. (doesn't time out).
You simply upload your database (uncompressed) and run the script
on the server.
Bigdump can be found here: