Upload large database SQL file

Posted by Devy on Server Fault See other posts from Server Fault or by Devy
Published on 2012-11-23T09:59:45Z Indexed on 2012/11/23 11:02 UTC
Read the original article Hit count: 230

Filed under:
|
|

I've a database of more than 20Gb of size on my hard disk. What is the best way to upload it with the least (money) load possible on the server?
- I'm on Windows 7.
- I have FTP and SSH access on the server.

I avoid using FTP because my connection cuts off a lot, I can't imagine I re-upload again the file after failing on 99%.

I found some tools that split the large .sql file to small .sql files, but they didn't mention how to gather these files again into one file.

Another way is to archive the big .sql file to .rar with -v option, upload them through FTP then unpack them. But unpacking will also cost, right?

I know it will cost in any cases, but any best practice will be strongly appreciated.

© Server Fault or respective owner

Related posts about mysql

Related posts about ssh