Navicat practical functions: data backup and structure synchronization

Summary

When we want to do risky operations on the database, we need to back up the database every time we go online During projects, there will always be inconsistencies in the online and offline database structures. This article will explain how to use Navicat to easily solve these two problems.

Navicat

Navicat is a set of fast and reliable database management tools designed to simplify database management and reduce system management costs. It is designed to meet the needs of database administrators, developers and small and medium-sized businesses. Navicat is built with an intuitive graphical user interface that allows you to create, organize, access and share information in a secure and simple way.

Note: This tutorial uses Navicat12 version, download address: www.navicat.com.cn/download/navicat-premium

Introduction to using the database

Now there are two databases in the database, mall-test represents the test environment database, and mall-prod represents the online environment database.

Data Backup

Now we first back up the mall-test database. After the backup is completed, delete the data in the product table, and then use the backup to restore the data.

Data overview in mall-test

Currently there is only the database table of the product module in the database, and there is certain data in the pms_product table.

Backup data

• First click the backup icon on the top toolbar , then click the New Backup button

• Click the Start button to start the backup

• After the backup is completed, a backup file will be generated

Clear the data of the pms_product table

Restore data from backup

##Structure synchronization

Related background description

The original mall-test module only had the table of the product module. Now after a period of development, we have added the order module, and at the same time deleted and modified some tables of the product module. The mall-prod table still has the original product module table. What we need to do now is to synchronize the database table structure of mall-test to mall-prod.

Perform structure synchronization

• Select the structure synchronization function

• Select the source database and target database and click the comparison button

• You can see the modified, added and deleted table information. Click Deploy and a preview of the sql script will appear

##After confirming the deployment script information, click Run to synchronize the data structure

• When the structure was synchronized again, it was found that the two database structures were completely consistent

The above is the detailed content of Navicat practical functions: data backup and structure synchronization. For more information, please follow other related articles on the PHP Chinese website!