How to transplant a local MySql database to a remote server_PHP tutorial

How to transplant the local MySql database to the remote server

I used dedecms to create a women’s website, which is imitated by Aili Women’s Network. In order to test locally, it is necessary to add category columns. In order to see the effect of the homepage and list pages, a large amount of content in each category must be collected online. In this way, there are dozens of columns and dozens of information in each column, and there are thousands of pieces of information at once. It’s better to do it locally first and then upload it with the data and pictures. Fast! Easy to operate and flexible. Now I will write down the database transplantation process and share it with everyone. Friends who have done this can also use it as a reference!

After all the data is ready, you need to apply for space and database. In many cases, the data that already has data is returned. You need to back up the existing database first. Then clear the database (clear all tables and data, please see the tutorial: http://www.6yee.cn/html/jianzhanjiaocheng/20100522/508.html. Before transplanting the database, make sure the database is empty, that is, there is no data sheet).

First back up your local database. The method is as follows.

1. Use phpmyadmin that comes with APMServ5.2.6 (tutorials and downloads are available on this site) for backup and recovery.

A. Run APMServ5.2.6 and click "Manage MySql Database" on the right. Enter 127.0.0.1:3306 for the server, login name: root, and leave the password blank to log in. On the left is the database list. Click on your database. Click Export, scroll to the bottom and check "Save as file". Click Execute. This way 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 casually in the information field. Identify your login information.

B. Click the connection column and fill in the following:

Picture 3

Server: IP of the server

Port: Generally 3306

C. Click the registration column and fill in the following:

User: the user name of the database you applied for (usually root if it is local),

Password: database password (locally empty)

Database: The name of the database you applied for.

Picture 4

After filling in the information, click "OK" to link to your remote database. As shown below, the remote data on the left

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

is up. Here you can modify your data table structure, delete and add data, etc. (operate carefully).

Picture 5

Picture 6

Picture 7

Picture 8

D. Right-click your database to back up (output) data. There are several types of backup. Generally, sql is selected,

E. The same goes for importing.

Okay, I wish you success!