How To Split Large SQL Files To Import Databases Easily?

Split SQL File with SQL Dump Splitter

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 a live WordPress blog, you need to import the SQL file of all your live databases 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 optimize 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 the SQL file is dangerous as we don’t know how many 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

c 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 file. 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 and his practical blogging experiences. You can connect with him at amit@scrollbucks.com

Leave a Comment