How can upload a large SQL dump file it's 1GB, is there any software that uploads the file and resumes it later or just cut it into pieces and then join them back on the server ?
because ftp upload is not an option (slow connection).
and thanks

  • You need to give more information. SQL yes, but what platform. If FTP is not an option, what is? (ie. what upload mechanisms are available to you.) – Orbling Apr 27 '11 at 17:56
  • Why's wrong with FTP over a slow connection? Any other transfer protocol is still going to be limited by the slow connection. – Chris S Apr 27 '11 at 18:01

You don't mention your operating systems. I'm assuming you use a flavor of Linux.

Linux systems have a CLI utility called 'split' that is expressly intended to break a file into pieces. To reassemble, you just 'cat' the files together.

| improve this answer | |
  • the hosting company uses linux, and where can I find this utility on my server ? – Peter Apr 27 '11 at 18:16
  • Should be just 'split' - it's a "standard" piece of software. On CentOS, it's explicit location is /usr/bin/split. For usage, do "man split" to merge files, use cat. eg "cat sourcefile >> destfile" – draeath Apr 27 '11 at 18:31

This is rsync's bread and butter.

rsync's --partial argument will cause it to resume a partially transmitted file. SQL will probably compress well (if it's not already gzipped, or similar), so you may want to consider the -z option as well.

| improve this answer | |

Create a rar file with the option -v and split it up into several files. Load them up and unpack the rar files.

In addition: If you are uploading a mysql dump. Zip it upfront, it will be way smaller than and mysql can handle zipped files.

| improve this answer | |
  • if I use the first option how can extract them n my server that the question, I thought about that. – Peter Apr 27 '11 at 18:17
  • just unrar the first file. rest should follow. – David Apr 28 '11 at 7:51

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

Not the answer you're looking for? Browse other questions tagged or ask your own question.