How to Backup or Restore MySql Database Using SQLyog

This tutorial will guide you how to backup or restore mysql database using sqlyog.

It is really important to create regular backups of database on which you are working. It will keep the database safe from any kind of loss. In case any loss occurs, you can restore the database by its backup. Database backup is also useful when you want to use the database in any other machine.

SQLyog is a great tool for managing database. Below I have shared the steps by which you can backup and restore mysql database.

If you don’t have SQLyog in your system then you can download it from below link.

Download SQLyog: https://www.webyog.com/

 

How to Backup or Restore MySql Database Using SQLyog

How to Create New Connection

Before working with database, we first need to connect SQLyog with the mysql database. Follow below steps to create a connection with database.

1. Open SQLyog and click on New button.

2. Now give a name to this connection.

How to Backup or Restore MySql Database Using SQLyog 1

3. After that, specify the Host Address, Username, Password and Port. Then click on Connect button, if you have entered all information correctly then SQLyog will be connected to the database.

How to Backup or Restore MySql Database Using SQLyog 2

 

How to Backup Database

1. In left column you can see the list of all the databases. Just right click on desired database and select Backup/Export > Backup Database As SQL Dump…

How to Backup or Restore MySql Database Using SQLyog 3

2. It will open a window as given below. Just select backup location and give a name to the backup file. Then click on Export button to backup the database.

How to Backup or Restore MySql Database Using SQLyog 4

You are done!

 

How to Restore Database

1. At top menu go to Database > Import > Restore From SQL Dump…

How to Backup or Restore MySql Database Using SQLyog 5

2. Now browse and choose the database backup file. Then click on Execute button to restore the database.

How to Backup or Restore MySql Database Using SQLyog 6

3. You have to refresh the object browser to see the restored database. It can be done in following way.

How to Backup or Restore MySql Database Using SQLyog 7

This was the simplest way to backup or restore mysql database using sqlyog. Comment below if you are facing any problem.

Category: SQL

Leave a Reply

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