How to migrate a local MySQL database to a remote server

How to migrate a local MySQL database to a remote server

Using Dedecms to do a female website, is the imitation of the woman net of Alice. In order to test in the local, it is necessary to add category columns, in order to see the home page and the effect of the list pages, but also in the online collection of a large number of various categories of content. So down dozens of columns per column dozens of information, information is thousands of. Do do is not as good as the first local do, and then with the data picture upload together. Fast! Good operation, great flexibility. Now the database transplant process written to share with you, have such a friend can also make a reference!

All the data is done, the application space, the application database, many cases are already data back. You need to back up the existing database first. Then empty the database (clear all the tables and data, see Tutorial: http://www.6yee.cn/html/jianzhanjiaocheng/20100522/508.html, before porting the database to ensure that the database is empty, that is, no data table).

First back up your local database, the following methods.

1, with APMServ5.2.6 (this site has tutorials and downloads) with the phpMyAdmin for backup recovery.

A, run APMServ5.2.6, click on the right "management MySQL database." The server fills in the 127.0.0.1:3306, login name: root, the password is empty to log in. On the left is the list of databases. Click on your database. Point export, pull to the bottom of the "Save as file" tick. Point execution. So you can back up your database.

Picture 1

2, run Mysql-front Backup to restore your database.

Picture 1

A, create a new login.

Picture 2

Write your name in the InfoBar. Identify your login information.

B, click on the connection bar, respectively, fill out:

Picture 3

Server: IP of server

Port: typically 3306

C, click on the registration bar, respectively, fill out:

User: The user name of the database you are requesting (if it is native to root),

Password: password for the database (blank locally)

Database: The name of the database you requested.

Picture 4

Fill out this information and click "OK" so that you can link to your remote database. As shown below, this remote data on the left

Server some database, click on your database to wait for the link. Until you return all the data, you can open your database.

The data table in the. Here you can modify the structure of your datasheet, delete the fill data, and so on (careful operation).

Picture 5

Picture 6

Picture 7

Figure 8

D, right click on your database for backup (output) data, there are several types of backup, the general selection of SQL,

E, import is the same.

Well, wish you success!