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
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