Need to transfer videos (25 GB) from one server to an other

Question

Need to transfer videos (25 GB) from one server to an other

designerkm

SSC Rookie

Points: 45
More actions
January 27, 2009 at 10:29 am

#200522

Hi all,
Pls. help me out with this one:
What is the fastest way to transfer this much data from one server to an other?
Thanks a lot!

Viewing 11 posts - 1 through 10 (of 10 total)

You must be logged in to reply to this topic. Login to reply

Lowell SSC Guru Points: 323518 More actions · Answer 1

back up the database, zip, transfer to the new server, unzip and restore is sure to be the fastest way as well as the most dependable;

transfering over the wire, for some connection that might time out or recevie an intermittent network issue, just not worth trying to do I'd think.

Lowell

--help us help you! If you post a question, make sure you include a CREATE TABLE... statement and INSERT INTO... statement into that table to give the volunteers here representative data. with your description of the problem, we can provide a tested, verifiable solution to your question! asking the question the right way gets you a tested answer the fastest way possible!

designerkm SSC Rookie Points: 45 More actions · Answer 2

I have tried zipping and wget through SSH but I'm getting a '403 error

forbidden'...

Lowell SSC Guru Points: 323518 More actions · Answer 3

403 is web page permissions....

maybe you can FTP or SFTP to your server? since it's a web page error, i assume your other server is remote over the internet and not over a LAN;

if you have direct access, you could create a linked server and insert into a table on the remote server....slow for sure but it'd work as well.

you don't want the whole thing rolling back the transaction do to a netwoirk error 14 gig into a 25 gig transfer....

INSERT INTO Remoteserver.dbname.dbo.imagetable

SELECT ALL25GIGIMAGES FROM MyImageTable

I might make a loop/cursor insert image-by-image so i could follow up afterwards and insert any individual images that failed.

Lowell

--help us help you! If you post a question, make sure you include a CREATE TABLE... statement and INSERT INTO... statement into that table to give the volunteers here representative data. with your description of the problem, we can provide a tested, verifiable solution to your question! asking the question the right way gets you a tested answer the fastest way possible!

designerkm SSC Rookie Points: 45 More actions · Answer 4

Thanks Lowell!

One more thing..

I transfered a larger folder with images but I can not transfer the folder with the videos in it...

I have tried to transfer only one video from that folder but still the same error message!

I have tried as well to moove a video from that folder in to an other folder and transfer it from there but I got the same error message...

What do you think?

ravikanth. Hall of Fame Points: 3472 More actions · Answer 5

ravikanth.

Hall of Fame

Points: 3472

January 29, 2009 at 5:36 pm

#935182

why dont you try mapping the servers?

designerkm SSC Rookie Points: 45 More actions · Answer 6

designerkm

SSC Rookie

Points: 45

January 29, 2009 at 6:14 pm

#935207

Hi,

Can you pls. explain that?

ThankYou!

Mayank Khatri SSCertifiable Points: 7984 More actions · Answer 7

Even Microsoft is offering 25 GB of free online storage called windows Sky Drive. You just have to go to their website, http://www.microsoft.com and open up your account.

ravikanth. Hall of Fame Points: 3472 More actions · Answer 8

Windows Explorer --> tools --> Map Network Drive --> //server IP/drive letter$/

Lowell SSC Guru Points: 323518 More actions · Answer 9

you guys missed his previous post...I;m thinking this is a shared hosting server, and not anything on his own LAN or that he has Admin access to at the OS level:

he was trying to upload a 25 gig database via an http interface which failed; and he mentions trying to create a folder which fails as well, which leads me to believe he was using some web based-File Manager to create and upload files.

Sounds like this doesn't have anything to do with SQL yet...

especially the part where he could transfer a folder full of images, but was prevented from uploading videos...most hosts prevent people from hosting videos and mp3s without paying extra for bandwidth.

my shared host doesn't give give me 25+gig of space, i think we need more information on his destination server.

where is the server? is it on your network?

do you have full access? only some web access?

can you actually query the SQL Server, or only via code on the host web pages?

Lowell

--help us help you! If you post a question, make sure you include a CREATE TABLE... statement and INSERT INTO... statement into that table to give the volunteers here representative data. with your description of the problem, we can provide a tested, verifiable solution to your question! asking the question the right way gets you a tested answer the fastest way possible!

designerkm SSC Rookie Points: 45 More actions · Answer 10

Hi all,

First of all I'm a 'she' and unfortunately a beginner in this subject.

So, I have a 40Gb VPS hosting and the place I want to transfer my videos is a lot bigger Dedicated server.

The normal way would be a backup of public_html, downloading it and uploading it to the other server but that takes a lot of time and I have to repeat this with many servers, not only Dedicated ones.

So, I have Cpanel, Sql and SSH.

Any advice?

Thanks!

Kate