0

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

2
  • 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, 2011 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, 2011 at 18:01

3 Answers 3

5

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.

2
  • the hosting company uses linux, and where can I find this utility on my server ?
    – Peter
    Apr 27, 2011 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, 2011 at 18:31
3

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.

0

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.

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

You must log in to answer this question.

Not the answer you're looking for? Browse other questions tagged .