Take the 2-minute tour ×
Server Fault is a question and answer site for professional system and network administrators. It's 100% free, no registration required.

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

share|improve this question
    
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
add comment

3 Answers

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.

share|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
add comment

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.

share|improve this answer
add comment

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.

share|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
add comment

Your Answer

 
discard

By posting your answer, you agree to the privacy policy and terms of service.

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