Can anyone recommend a good MySQL tool or script which will split databases into multiple smaller portions? I have a large database on my CMS which times out when uploading through phpMyAdmin. My host does not allow shell acess, and when I have requested them to do restores in the past it has been less than successful and timely. So I am looking for some kind of tool which will easily let me split the database file into smaller, uploadable portions. Anyone?
I may be showing my ignorance here. Can't you just dump several different dumps by tables? Break it up by parts and then import it the same way?
Instead of break into pieces your database I would suggest upload it via bigdump. This script can handle very long databases being a handy alternative to phpmyadmin, just follow the direction at the top, within the file. www.ozerov.de/bigdump.php
BigDump requires shell access, I believe, which I don't have. This is actually the method I hit upon, too. (Sort of a duh! moment for me)This works works for now, as all of the tables are under 25MB, which is the timeout limit on my host's phpMyadmin. But what will happen when one of my tables grows larger? Then I will need to edit manually to split it up into several files. Anyway, thanks for the suggestions. For now I have a good workaround.
25mb seemsa little low. I thought most shared hosting was more like 50. I think the actual timeout is timed so maybe the size varies with cpu usage.