I was doing the local WordPress setup of my blog, I had faced a problem while importing the database. To make a local setup of a 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 only a maximum of 2 MB file to import. I was confused, and finally, I got a solution to import the large SQL files.
If you need to migrate your blog to another WordPress hosting, then you will have to move the 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.
How to compress the database SQL file size in WordPress?
- 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 large database SQL file into small files 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 large SQL files into smaller files. The UI of this utility is simple as anyone will get understood.
Steps to split large SQL files
- First, open the SQL Dump Splitter.
- Choose the large SQL file from your local machine.
- Provide the target location to download the smaller files.
- Click on the execute button, it will create smaller parts within a few seconds.
- You can also use this utility by using the command line interface.
The UI of the utility might get changed, the below screenshot was taken when I have written this tutorial.
The bonus feature of this utility is 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 them into your WordPress blog or other use.
NOTE- The developer of this utility has released the new version for all three platforms Linux, Windows, macOS. Also, this utility is completely free.
If you like the above tutorial, then share it with your friends and if you have any queries then write to us.
You’ll love to read
- How to transfer a domain from GoDaddy to Google?
- How to start a blog and earn money from blogging?
- How to start a free blog on Blogger?
- What skills required for a professional Blogger?
- How to earn money from Affiliate Marketing?
Amit Kharbade
Latest posts by Amit Kharbade (see all)
- How To Track Enhanced eCommerce in Restricted Content Pro and GiveWP? - March 27, 2021
- How to Use Smart Tags for Dynamic Text Replacement in OptinMonster? - March 20, 2021
- How to Easily Use Lead Source Tracking in Google Analytics? - March 15, 2021