I have about 20 databases on a shared remote mySQL server. Each database has about 20 tables. The largest of the databases is 135 MB.
I am moving my site to a new, dedicated remote server. Is there an easy way to mirror all of my databases on the new server?
I tried using phpMyAdmin 2.2.3 on the databases and trying to move them one at a time but it keeps crashing when I try to download my largest database. It is also a pain to have to move all 20 databases.
Is there a program or code to move all of my databases directly to the new server?
Thank you for any help you can give me.
Brian