I have a 250 MB backup SQL file but the limit on the new hosting is only 100 MB …
Is there a program that let's you split an SQL file into multiple SQL files?
It seems like people are answering the wrong question … so I will clarify more:
I ONLY have the 250 MB file and only have the new hosting using phpMyAdmin which currently has no data in the database. I need to take the 250 MB file and upload it to the new host but there is a 100 MB SQL backup file upload size limit. I simply need to take one file that is too large and split it out into multiple files each containing only full valid SQL statements (no statements can be split between two files).