Splitting MySQL Database?

[~bk]

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?

 

[Shamus MacNoob]

File Chopper

 

[X-Istence]

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

 

[Shamus MacNoob]

you can chop and reassemble once it is uploaded no need to insert a half anywhere .

 

[LordOfLA]

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.

 

[X-Istence]

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.

 

[~bk]

Thanks guys. I'll see what I can do.