Shulou(Shulou.com)06/01 Report--

This article mainly introduces the example analysis of data backup and structure synchronization in Navicat, which has a certain reference value, and interested friends can refer to it. I hope you will gain a lot after reading this article.

Abstract

When we want to do risky operations on the database, we need to back up the database, every time the online project, online and offline database structure is always inconsistent, 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 enterprises. 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: the Navicat12 version is used in this tutorial, download address: www.navicat.com.cn/download/navicat-premium

Introduction to using database

There are now two databases in the database, mall-test for the test environment database and mall-prod for the online environment database.

Data backup

Now we first backup the mall-test database, after the backup is completed, delete the data of the commodity table, and then use the backup to restore the data.

Overview of data in mall-test

At present, there is only the database table of the commodity module in the database, and there is some data in the pms_ produce table.

Make a data backup

Click the backup icon on the top toolbar, and then click the New backup button

Click the start button to start the backup

A backup file is generated after the backup is completed.

Clear the data in the pms_product table

Restore data from backup

Background description related to structural synchronization

There was only the table of the commodity module in the original mall-test module, but now we have added the order module after a period of development, and deleted and modified some tables of the commodity module at the same time, while the mall-prod table is still the original commodity module table. What we need to do now is to synchronize the mall-test database table structure to mall-prod.

Perform structural synchronization

Select structure synchronization function

Select the source database and the target database and click the compare 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 is synchronized again, it has been found that the two database structures are exactly the same.

Thank you for reading this article carefully. I hope the article "sample Analysis of data backup and structure synchronization in Navicat" shared by the editor will be helpful to you. At the same time, I also hope that you will support and pay attention to the industry information channel. More related knowledge is waiting for you to learn!

Welcome to subscribe "Shulou Technology Information " to get latest news, interesting things and hot topics in the IT industry, and controls the hottest and latest Internet news, technology news and IT industry trends.