However, my site has a large MySQL database (200 megabytes) and it's impossible to backup or restore via phpMyadmin. Godaddy has a feature on their control panel, where you can restore/backup your MySQL database to a special diretory on your web http file space, which you can upload/download vis FTP. I use this alot.
Is there any other web hosting company that offers such a feature? I haven't seen this anywhere except on Godaddy.
As to why I need to get away from Godaddy:
Basically what they did was, my site was getting too much traffic (even though it's still well under Godaddy's advertised limits for that plan)... so they sent me an email that says:
"Your site is using too much server resources. We have moved you to a new server to protect our other customers. Please identify steps to reduce your site traffic and contact us."
They moved my site to what is, apparently, a punishment area (Godaddy Hell) where all the high volume sites go. It is so extremely slow, my site might as well not exist... it is inaccessible to my visitors for all intents and purposes.
Like tcstatic said, I think any host would be happy to import it for you if you uploaded it to your home directory. And honestly, if you uploaded it via FTP, you could probably import it then using PHPmyadmin. I think most of the problems stem from trying to upload 200MB through phpmyadmin, and usually PHP upload limits aren't set that high.
Correct me if I'm wrong, I'm low on caffeine at the moment
█ Bobby - PreciselyManaged.com - Precision Hosting Solutions
█ Enterprise Shared, Reseller, VPS, Hybrid, and Dedicated Hosting
█ SpamExperts | CloudLinux | cPanel | Bacula + R1soft | and more!
█ Full proactively managed, and we specialize in hosting small web hosts
Navicat has a very slick feature with a PHP script they provide that allows for HTTP tunnel access to MySQL through your website even if the host doesn't allow remote MySQL connections. I've used this to backup and restore DB's over 600MB.
I recently just used it to help a friend restore his 400MB phpbb database to GoDaddy because their automated tool was having an error on his DB.
If you work with MySQL and do any sort of backup or restore tasks the app pays for itself easily.
Good luck -
Applied Innovations (www.appliedi.net)
Microsoft Gold Certified Hosting Partner, ASP.net Featured Host.
Specializing in Windows Hosting since 1999.
I just tried Navicat, seems like a good piece of software....... but unfortunately even Navicat timed out while trying to transfer 220megs of table records. (I have this one huge table that holds 150meg of data)
What I ended up doing is, sadly, using phpMYadmin. Yes I had to break up the dump file into 22 little text files, and then zip them all up (because php upload limit is 8meg), and import into phpMyadmin.
I got it working after much labor. But I hope i never have to do that again!