Import big (My)SQL file

I got a crappy connection so I can't use apps like BigDump, that would stop if I can't stay in the page.

What can I do? I'm looking fo开发者_如何转开发r a way to import without the necessity of keep connected all the time...

If you have SSH access, you could gzip/bzip2 your dump file and then upload it, and then run the import via commandline on the server itself.

use rsync to transfer the files then load it from the cli in a screen session.

That way if your connection fails you can resume