How to migrate a local MySQL database to a remote server _php tutorial

How to port the local MySQL database to a remote server

With Dedecms made a female web site, is the imitation of the Alice Net. In order to test in the local, we need to add categories, in order to see the homepage and the effect of the list page, but also in the online collection of a large number of various categories of content. So down dozens of columns per column of dozens of information, information is thousands of. Doing is not as good as doing it locally, and then uploading it with the data image. Fast speed! Good operation, high flexibility. Now the database of the transplant process is written to share with you, there are friends to do this can also be a reference!

All the data is done, application space, application database, a lot of information is 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 migrating the database to ensure that the database is empty, that is, there is no data table).

Start by backing up your local database, as follows.

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

A, run APMServ5.2.6, click "Manage MySQL Database" on the right. Server fill 127.0.0.1:3306, login name: root, password is empty to log in. On the left is the database list. Click on your database. Click 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

Please write your name in the Information Bar. Identify your sign-in information.

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

Picture 3

Server: IP for server

Port: typically 3306

C, click on the Registration box, respectively fill out:

User: The user name of the database you are applying to (if it is a local root),

Password: the password for the database (local is empty)

Database: The name of the database you are applying for.

Picture 4

Fill in this information and click "OK" to link to your remote database. For example, the remote data on the left

Some databases of the server, click on your database and wait for the link. Until all data is returned, you can open your database

The data table in the. Here you can modify the structure of your data table, 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, General choice of SQL,

E, import is the same.

Well, I wish you success!

http://www.bkjia.com/PHPjc/371617.html www.bkjia.com true http://www.bkjia.com/PHPjc/371617.html techarticle how to port the local MySQL database to a remote server using DEDECMS to do a female website, it is The imitation of the Alice Net. In order to test in the local, we need to add the category column, in order to see the first ...

