I want to restore a big database, and don't have SSH, so I'm going to have to split the databases into small pieces and upload them in order. The question is, where can I find a site/tool to split my database into small databases?
Splitting a MySQL load file into multiple pieces can be tricky to say the least, especially if the new INSERT syntax was used in the dump. I'm not aware of any tools that could handle this situation. Here's an alternative that I've used successfully: upload the (compressed) file via FTP, and then open a support ticket with your hosting company asking them to load the file using mysql.
Use BigDump save splitting I used it for the first time moving my forum. Althought not huge it made very short work of the job .