How to backup MySQL Database using Navicat Premium

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.

create new mysql connection on navicat

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”.

backup mysql database on navicat 1.png

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.

backup mysql database on navicat 2.png

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.

backup mysql database on navicat 3.png

Jump to the Object Selection tab and select which tables you want to include to your backup.

backup mysql database on navicat 4

On the Advanced tab you may specify the file name and some other options such as table lock etc.

backup mysql database on navicat 5.png

You may save your setting for future use. Press Start button to start the backup process.


Leave a Reply

Your email address will not be published. Required fields are marked *

This site uses Akismet to reduce spam. Learn how your comment data is processed.