Shulou(Shulou.com)05/31 Report--

This article mainly explains "how to restore and backup mysql database". The content in the article is simple and clear, and it is easy to learn and understand. Please follow the editor's train of thought to study and learn "how to restore and backup mysql database".

Now let's talk about the management and maintenance method of another kind of database, namely Mysql. Our recommended tool is EMS SQLManger. Many people who use EMS SQL Manager for the first time find EMS SQL Manager difficult to use and don't know how to use it to manage Mysql databases. In fact, once you are familiar with it, you will find its unique advantages. At least I personally think it is much easier to use than the enterprise manager that manages MSSQL:)

Download, install and run EMS SQLManger

We provide a download of EMS SQLManger: http://www.jspcn.net/mngtools/mymanager_lite.zip download is complete, and after installation, run SQLManger.

Register the database

Select as shown in the following figure to start registering the database.

The following dialog box appears, and the corresponding parameters can be found in the user self-service.

Notice that the port number of Mysql5 is 3307 and the port number of MySQL 4 is 3306. You can refer to the database information in your own vhost.jspcn.net for specific ports.

Next, add your database name. You don't have to choose the rest, just default.

Choose to connect to the database

Once connected, you can perform various operations on your database, such as adding, deleting, changing tables, and so on.

III. Restore of database

Now let's talk about how to upload data from the local database to the server. It's actually very simple:

1. Connect locally and import the local database and data into a sql script

2. Connect to the server and execute the sql script

First of all, it is easier to set up a local registration than to set up a registration on the server. Don't ask me the password of MYSQL on your own machine.

Select Extract Database.

Select your local database

The next step, the next step, be sure to note that if you have set up a database on the server, remove the "CREATE DATABASE" option.

Continue to generate a .sql script. Save it in the place you are used to.

Now we need to think about how to use this script to restore the data to the database on the server.

First open the sql edit box and select the database of the server.

The sql edit box is displayed to select your database on the server. The figure below is as follows

You can edit the SQL statement yourself in the session box, or you can LOAD the sql script you just saved.

Execute this script

After a successful execution

Refresh the database on the server and take a look

Look, the database on the server has been updated.

The backup and restore of MYSQL can also be done by connecting to the server and using Extract Database and SQL Editor.

IV. Backup of database

Export the database on the server as a sql script, and the backup operation is complete.

Thank you for your reading, the above is the content of "how to restore and backup mysql database". After the study of this article, I believe you have a deeper understanding of how to restore and backup mysql database. Here is, the editor will push for you more related knowledge points of the article, welcome to follow!

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.