Uploading MySQL database

[daveway]

I've got a MySQL database of around 20MB that I need to upload to an account, but everytime I use the PHPMyAdmin interface it times out and gives an error saying something like "the 300 second connection time exceeded" or some such. I've tried piecing out the tables into different files, but even a 5MB file times out. Is there some way I could just FTP the files to the server and then upload them from their into the database? Or is there another way I can get my data into the db?

Thanks

-DaveWay

[jafler]

Maybe this'll help? Be sure you have created the db then in cPanel go to "backup" and restore the database. (upload it from your harddrive) I really don't know if it'll work at all, it's just a suggestion. . . .

[daveway]

That's a good suggestion - but I'm trying to move the database from another server. And I believe the restore backup function is for backups created via Cpanel. I'm using MySQL front to generate an export file, which I have succeded in importing using Cpanel but only with a very small file. So I have an external db that I want to move to Cpanel.

Thanks

[Joshhighland]

I had the same problem when i moved hosts. I found the solution by useing a php script called bigdump. it rules

http://www.ozerov.de/bigdump.php

check it out, its what you are looking for

--Josh Highland
notPopular.com

[daveway]

Wow - that would have been great. I ended up using MySQL Front to connect and upload. It keeps a connection open for as long as you need which was great. But this little script will come in handy later on.

Thanks

-DaveWay

[NewGuy]

Josh, that script is a godsend. Thanks for sharing!

[Joshhighland]

Originally Posted by NewGuy

Josh, that script is a godsend. Thanks for sharing!

im glad that it helped someone out. I was having the same problem the last time i moved servers. I was pulling my hair out and i started to write a script to do something like this when i stumbled across someone that had already written one!