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 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.
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.
- Effective ways to drive traffic from Facebook
- How to transfer a domain from GoDaddy to Google?
- How to start a free blog on Blogger?
- What skills required for the professional Blogger?
Latest posts by Amit Kharbade (see all)
- How To Set Up Author Tracking in Google Analytics by MonsterInsights? - December 21, 2019
- How To Track File Downloads in WordPress Site? - November 3, 2019
- How to configure the WP Mail SMTP plugin with Amazon SES? - October 20, 2019