Splitting MySQL Database?


Political Access
3 Nov 2003
I recently switched hosts for my website. So now I'm trying to upload MySQL database for my blog through phpMyAdmin but I can't as the upload limit is only 2MB. My file is around 5MB. I emailed the hosting company about it and this is what I got:

As of the moment the maximum file that can be uploaded at one time on our database is around 2 MB only. The only workaround that we can suggest on this is to slit the files into smaller pieces so that you can upload it one at a time and then just merge it back once its uploaded.

Now how do I do the italicized part? :p
Ehm, sure, chop the file into little bits, won't work though, since MySQL dumps are sensitive as to where you chop them. If you chop an INSERT in half MySQL WILL complain.

Put the file in a folder on your webhost, then contact your webhost and tell them to run this command:

mysql -u [your MySQL username] -p [database here] < file.sql

Then also give them a password, and they can import the database on the server itself. If they can't do this for you, consider switching to another host.

Bert JW Regeer
you can chop and reassemble once it is uploaded no need to insert a half anywhere .
just FTP it to the server and tell phpmyadmin to use a server based file or login via ssh and upload it to mysql that way.

If you need an ssh enabled hosting account drop me a note.
you can chop and reassemble once it is uploaded no need to insert a half anywhere .

phpMyAdmin takes an upload, and immediatly tries to put it into the database, it does not store it intermediately somewhere while you upload the second half.
Thanks guys. I'll see what I can do. :)

Members online

No members online now.

Latest profile posts

Also Hi EP and people. I found this place again while looking through a oooollllllldddd backup. I have filled over 10TB and was looking at my collection of antiques. Any bids on the 500Mhz Win 95 fix?
Any of the SP crew still out there?
Xie wrote on Electronic Punk's profile.
Impressed you have kept this alive this long EP! So many sites have come and gone. :(

Just did some crude math and I apparently joined almost 18yrs ago, how is that possible???
hello peeps... is been some time since i last came here.
Electronic Punk wrote on Sazar's profile.
Rest in peace my friend, been trying to find you and finally did in the worst way imaginable.

Forum statistics

Latest member