I wanted move database MySql - PhPmyAdmin from fatcow hosting. They don't allow ssh . Hence I have to download via PhpMyAdmin. I compressed version is 2.69MB. To import the database to a new server, the max. size is 2MB. So how to move ? I will have SSH login to the new host,
Try using something like navicat. You may need to decompress and run the sql file, but it shouldn't have any problem with file restrictions as long as you can allow remote access to the DB. They offer a free 30 day trial, and a lite version for personal / non-business usage at no charge. http://www.navicat.com/download/download.html By far the best database administration software anywhere.
May not be a bad idea to run a virtual private server to get away from foolish shared hosting limits on MySQL databases. It's not that hard and I do not know why people freak out at the idea of running a VPS. For $4 - 5 per month, you get 20 gigabytes of space and 1 TB of bandwidth - I have a site with 15,000 hits and it has a large background in the design. I haven't even exceeded 2 - 3gb of bandwidth! Oh wait.. shared hosting. Unlimited disk space.. unlimited bandwidth but a limit on MySQL database size? I'll pass!
On that topic, it makes no sense to have unlimited bandwidth when there are so many sites on the server that throughput it limited to a few Kbps. More than once I've been on an unlimited host and through testing we couldn't get better than 10Kbps... No thank you. Sure in theory we could push hundreds of Gb per month, but in reality the throughput limits us to a fraction of that even if running 100% 24/7.
I would prefer bigdump as stated above (its a free script and works successfully most of the time) It will insert each sql query one by one so, it doesn't matter how large the database file is or whatever the database size limitation is You would be able to successfully dump your data into your new sql database using this handy script I have tried it to import databases as big as 3.5GB and it worked well (however, that tool a lot of time and the server was about to crash )
I love it when Wordpress tries to update on 1and1 shared hosting and it fails. I guess that's why so many people run old copies of WP on shared hosting or one click installing it but have PHP memory limitation so it fails. That was the final straw for me. If I had the money, I would transfer the 100+ domains I have on 1and1 to another provider. I think when I get a good lump sum coming in, I'll transfer them little by little after I sell a few.