Today, when I was doing the local setup for 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 something like 9MB. PhpMyAdmin allows the only maximum 2MB file to import. I was confused, and finally, I got a solution to import the large 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 WordPress blog, then you must be aware of the PhpMyAdmin database. WordPress stores the 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.
Some bloggers use a plugin to compress the database. Some blogger delete the unnecessary items from the blog to make the size of the database smaller. Some bloggers 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 units. The UI of this small utility is very simple as anyone will get understood.
Simply one you opened this utility you have to provide the file path and destination folder. It will create the smaller parts within 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.
If you like the above tutorial then share it with your friends.
Latest posts by Amit Kharbade (see all)
- How to set up WordPress locally using DesktopServer in 10 minutes? - December 10, 2017
- Kinsta Affiliate Program- Earn upto $500 per referral - December 3, 2017
- Fastest loading SEO WordPress Theme- Schema (Review and Offer) - November 26, 2017