Navicat Premium is a powerful tool to manage and administering your MySQL Server, SQL Server, Oracle and some other popular SQL Databases. On this tutorial, I am going to show you how to backup MySQL Database using Navicat Premium. Please note that Navicat is not a freeware, but its worth it. Navicat perform very well to backup my MySQL databases and I have been using this software for some times and won’t look back.
First of all, create a new connection to your MySQL Server. Its easy to do via Connection menu on Navicat window.
Once connected, open your database that you want to backup by double click in on it (left panel). On the example below, I want to backup a database called “mysql”.
Make sure the database that we want to backup is opened (See my example above). Now, click Backup button on the top bar. Or, simply click Backup button below Reports on the left panel.
Your backup file will be listed here. If you don’t have any, you can create a new one. Click New Backup and a new window will be opened. On the General tab, you can type any description to the new backup.
Jump to the Object Selection tab and select which tables you want to include to your backup.
On the Advanced tab you may specify the file name and some other options such as table lock etc.
You may save your setting for future use. Press Start button to start the backup process.