Uploading split sql file through php?

arshutterbug

Joined: 2009-12-01
Posts: 25
Posted: Sun, 2012-10-07 23:38

I have a somewhat large (250 MB) sql database for Gallery that I'm trying to import to a new database server that I don't own. The host uses phpMyAdmin and it has a 20 MB upload limit. They want me to split the sql file, which I did using the split command on my local machine. The problem is that phpMyAdmin runs a syntax check on the split uploads, and refuses to continue when it finds something that it doesn't understand, instead of letting me continue uploading the rest of the split files. Other than manually editing each of the split files and trying to trick my way around the syntax checker, what else can I do to upload the Gallery database to the server?
 
suprsidr
suprsidr's picture

Joined: 2005-04-17
Posts: 8339
Posted: Mon, 2012-10-08 00:18

why don't you zip it up instead

-s
________________________________
All New jQuery Minislideshow for G2/G3
 
arshutterbug

Joined: 2009-12-01
Posts: 25
Posted: Mon, 2012-10-08 00:35

I've already used gzip as required (it doesn't like regular ZIP) but the 250 MB only goes down to 80 MB, which is still four times bigger than what the server is allowing.
 
suprsidr
suprsidr's picture

Joined: 2005-04-17
Posts: 8339
Posted: Mon, 2012-10-08 01:32

http://www.sqldumpsplitter.com/

-s
________________________________
All New jQuery Minislideshow for G2/G3
 
arshutterbug

Joined: 2009-12-01
Posts: 25
Posted: Mon, 2012-10-08 01:46

Thanks, I'll try it, but I'll have to wait until I can get a Microsoft system to use it.
 
arshutterbug

Joined: 2009-12-01
Posts: 25
Posted: Wed, 2012-10-17 05:41

I decided to move to dedicated hosting for my gallery. Shared hosting, even at the best ISPs, just isn't good enough. I now have much faster image retrieval, storage copy and move commands are nearly instantaneous, and I have a dedicated URL for the gallery. I haven't seen a single latent storage I/O error. Thumbnails are generated within seconds of the upload being received by the server, as opposed to the many minutes I'd sit and wait for thumbnail generation and representative thumbnails to be accepted on shared hosting. I also don't have to think about turning off EXIF information displays, nor is optimizing the database and running other maintenance tasks a major chore. I guess if you want to run a large image database, dump shared hosting and get dedicated hosting.