How do I split a large MySQL backup file into multiple files?

mysql database-backups splitter
Brian T Hannan picture Brian T Hannan · Oct 1, 2010 · Viewed 20.3k times · Source

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?

Answer

Alisa picture Alisa · Jun 22, 2015

You can split a large file in Eclipse. I have tried a 105GB file in Windows successfully:

Just add the MySQLDumpSplitter library to your project: http://dl.bintray.com/verace/MySQLDumpSplitter/jar/

Quick note on how to import:

  • In Eclipse, Right click on your project --> Import
  • Select File System and then Next
  • Browse the path of the jar file and press Ok
  • Select (thick) the MySQLDumpSplitter.jar file and then Finish
  • It will be added to your project and shown in the project folder in Package Explorer in Eclipse
  • Double click on the jar file in Eclipse (in Package Explorer)
  • The MySQL Dump file splitter window opens which you can specify the address of your dump file and proceed with split.

Related questions

Export and Import all MySQL databases at one time

I want to keep a backup of all my MySQL databases. I have more than 100 MySQL databases. I want to export all of them at the same time and again import all of them into my MySQL server at one …

Read More
How to take MySQL database backup using MySQL Workbench?

How to take database backup using MySQL Workbench? Can we take backup in the following ways- Backup file(.sql) contains both Create Table statements and Insert into Table Statements Backup file(.sql) contains only Create Table Statements, not Insert into …

Read More
Minimum GRANTs needed by mysqldump for dumping a full schema? (TRIGGERs are missing!!)

I have a MySQL user called dump with the following perms: GRANT USAGE ON *.* TO 'dump'@'%' IDENTIFIED BY ... GRANT SELECT, LOCK TABLES ON `mysql`.* TO 'dump'@'%' GRANT SELECT, LOCK TABLES ON `myschema`.* TO 'dump'@'%' …

Read More