In this part of our mini tutorial series on database management, we will show how to dump a WordPress blog database to a file in .sql format using Navicat. This is one way to export the entire database in a matter of minutes.
No web-based control panels, and no phpMyAdmin or any tedious work, but right from within one application where you manage all your databases if you are using a powerful yet easy-to-use tool like Navicat. The only one-time pre-requisite to this simple tutorial is that you need to have defined the connection settings your web host’s database server from within Navicat. If you haven’t already done so, check out this tutorial first on how to do so.
While in Navicat, start by connecting to the server where your database is located, by double-clicking the name of the server you had previously defined in Navicat. Expand the database listing in the tree-view by switching the tiny triangle-shaped icon, and right-click the name of the database. In our case, we want to back up our company blog database to a local file on a Mac.
From the contextual menu(s), select
Dump SQL file... > Structure + Data, and Navicat will prompt you to provide a name and location for the .sql file in which it will dump the entire database.
For this one, I type in “WordPress Database Dump”, leave the location to save, as Desktop, and click Save. A modal dialog box with a progress bar comes up indicating the state of dumping the data to the sql file. Initial gathering of information takes a while in the beginning, yet I’m in Europe, and the database server is in the United States.
In such a short time as 3 minutes, we have obtained an SQL dump of our entire company blog database (~ 50 MB) to a local file system on a laptop computer, directly from the MySQL server which is located overseas, using just Navicat.