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.