Welcome to WebmasterWorld Guest from 23.22.206.103

Forum Moderators: phranque

Message Too Old, No Replies

Whats The Best Way To Send A Large File?

Need to get a large sql dump to my developer.

     
2:20 pm on Feb 22, 2008 (gmt 0)

Senior Member

WebmasterWorld Senior Member 10+ Year Member

joined:Mar 30, 2004
posts:1148
votes: 0


Hey All,

I have a sql dump of around 1million records that I need to get into my developers hands to work with.

I have a few ideas:

* Upload it all to my php admin and give him login details?

* Open with textpad and split it into 5 smaller files upload them to my host and give him a link to download them?

Can anyone pitch in with an idea or the best way to do this?

RJ

3:55 pm on Feb 22, 2008 (gmt 0)

Preferred Member

5+ Year Member

joined:Dec 10, 2007
posts:507
votes: 0


How big is the file?

If you live near each other, surely its better to stick it on a cd or usb pen drive and mail it or hand it over to him.

If you can upload the file to the server via ftp in a folder no-one can guess the name of, and send him the link. Once he d/l's it, you can delete it.

At the moment, the phpmyadmin is probably the better idea at the moment...

:)

5:23 pm on Feb 22, 2008 (gmt 0)

Senior Member

WebmasterWorld Senior Member 10+ Year Member

joined:Mar 30, 2004
posts:1148
votes: 0


Thanks surrealillusions,

Do you have any experience with phpmyadmin? Can you tell me if I am best to try open the file and cut it up via textpad or will it upload all in the one go (im sure phpmyadmin has a limit).

8:28 pm on Feb 22, 2008 (gmt 0)

Full Member

10+ Year Member

joined:Sept 7, 2005
posts:242
votes: 0


If you are using mysql, the database is essentially a folder in your data directory. All you'd need to do is to tar and zip the the folder, then give the developer ftp access to the zipped file.
9:50 pm on Feb 22, 2008 (gmt 0)

Senior Member

WebmasterWorld Senior Member 10+ Year Member

joined:Mar 30, 2004
posts:1148
votes: 0


Cheers for your replies.

I tried doing it on my local host but it is too much for me, i even tried some php scripts to insert the data however had no luck.

Decided that the best way forward was to zip the dump and give the developer access to it and get can deal with it.

Thanks again for your replies.

RJ

 

Join The Conversation

Moderators and Top Contributors

Hot Threads This Week

Featured Threads

Free SEO Tools

Hire Expert Members