Why does phpmyadmin only allow 2 MB files. I mean, I know there's an upload timeout limit, but shouldn't their api just be able to do like a javascript redirect after a couple minutes or something? Like moving a 200 mb db 2 mb at a time is just ridiculous. And then on mb 198, you find out that some format is wrong or something... whoops!
the 2MB limit is set by php's max input limit which in your case is 2MB there is no javascript work around for this. Some shared hosts allow you to increase this by placing a php.ini file in your home directory. for a 200mb file even if the max input was 200MB or more the script would still time out. If you don't have access to telnet or ssh try emailing your host to see if they can update the database for you.
if php.ini is server wide (and it's hosting company) I don't think they will allow you to change that.
Are you moving hosts? If your old host and new host have the same version of MySQL simply have your old host zip up your database and put it in your web folder so you can download it. Then have your new host simply extract the table files into a new database set up on your account. The same could be done with the "mysqldump" command-line utility on the source host and "mysql" utility on the target host - unfortunately again both likely require administrator access. Regards