How to split large SQL file to import database easily?

Today, when I was doing the local WordPress setup of my blog, I had faced one problem while importing the database. To make a local setup of live WordPress blog, you need to import the SQL file of all your live database to local PhpMyAdmin. The size of my database file is around 9 MB. PhpMyAdmin allows the only maximum 2 MB file to import. I was confused, and finally, I got a solution to import the large SQL files.

Either you can make a zip file of SQL or use the SQL DUMP SPLITTER tool to split the large file into small SQL files.

If you are using a WordPress blog, then you must be aware of the PhpMyAdmin database. WordPress stores all the information about your blog in this database.

If you want to make database size small, then we can easily optimise the WordPress database by using WP Sweep and WP-optimize plugins. To make it smaller size, we used to sweep the SQL database.

However, if you need to migrate your blog to another WordPress hosting, then you will have to move your SQL database to another hosting along with the other data. If your blog is old, then the size of the database would be bigger. Then sometimes we will face the issue while importing the database to new hosting.

What other bloggers do to compress the database size?

  • Use a plugin to compress the database size.
  • Split the database SQL file into smaller parts and import all the files one by one.
  • Manually breaking of the SQL file is dangerous as we don’t know how much queries to include in the single file.

In this short tutorial, I am going to tell you about the useful tool that will split your database SQL file into small parts so that you can import all the files one by one.

SQL Dump Splitter

SQL Dump Splitter is the free tool by which you can split your large SQL file into smaller files. The UI of this little utility is straightforward as anyone will get understood.

When you opened this utility, you have to provide them. SQL file path and destination folder. It will create smaller parts within a few seconds.

sql dump splitter

The wow factor of this tool is that you can set the maximum size for each output files. So that the size of the files will not be exceeded your threshold, once all the chunks created, you can import it into your WordPress blog or other use.

If you like the above tutorial, then share it with your friends and if you have any queries then write to us.

The following two tabs change content below.

Amit Kharbade

Editor/Writer at ScrollBucks
Engineer, Blogger, Writer, and the man behind ScrollBucks. Amit has been contributing to ScrollBucks since 2014. He is writing about Blogging, Adsense Guide, WordPress tutorials, Affiliate marketing, and reviews.

Leave a Comment