I had to transfer a typo3 website to a new hoster and we had some issues. One of our issue was that the maximum file size for the SQL Dump was limited to 2048 KiB. Our compressed SQL Dump file had about 9 MiB. We also had no access to the MySQL command line.

At first we tried to create a dump file for each single table. The problem was that also the dump file of some tables were larger than 2048 KiB. So we tried to manually split these large dump files into smaller files and finally we managed to import all our data.

The typo3 frontend worked, but the backend was a mess. We could not create new content, got exceptions and error messages. Something went wrong in splitting the large dump files into smaller one.

Luckily my co-worker found a tool called SQLDumpFileSplitter 2 and with this masterpiece we could import all data and everything worked like a charm - frontend and backend! You just have to follow these two steps

1. import DataStructure.sql first
2. import every other SQL file in the correct order

Happy splitting!