How to port a local MySql database to a remote server _ PHP Tutorial

How to port a local MySql database to a remote server. How to port a local MySql database to a remote server and use dedecms to create a female website is similar to the Alimail female website. To test locally, you need to add a category column. to see how to first port the local MySql database to a remote server

Dedecms is used as a female website, which is similar to the Alimail female website. To test the function locally, you need to add a category column. to view the effects of the homepage and list page, you have to collect a large number of categories on the Internet. In this way, dozens of columns have dozens of pieces of information each, thousands of pieces of information. It is better to do it locally and then upload it together with data images. Fast! Good operation and high flexibility. Now I will share the database porting process with you. if you have any friends who want to do this, you can also make a reference!

When all the data is ready, the application space and the application database are ready, there are many situations where data is already returned. Back up the existing database first. Then clear the database (clear all the tables and data, please refer to the tutorial: tables ).

Back up your local database as follows.

1. use phpmyadmin with APMServ5.2.6 (this site provides tutorials and downloads) to back up and restore data.

A. run APMServ5.2.6 and click "Manage MySql database" on the right ". Enter 127.0.0.1: 3306 on the server, and enter "root" as the logon name. enter a blank password to log on. On the left is the database list. Click your database. Click export to the bottom and tick "Save as file. Click to execute. In this way, you can back up your database.

Image 1

2. run mySQL-Front backup to restore your database.

Image 1

A. create A new logon.

Image 2

Enter a name in the information column. Identifies your logon information.

B. click the connection column and fill in the following information:

Image 3

Server: IP address of the server

Port: generally 3306

C. click the registration column and fill in the following information:

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

Password: password of the database (null locally)

Database: the name of the database you applied.

Image 4

After entering this information, click "OK" to link to your remote database. For example, the remote data on the left

For some databases on the server, click your database and wait for the link. You can open your database until all data is returned.

. Here, you can modify the structure of your data table, delete and fill in data, and perform other operations (with caution ).

Image 5

Image 6

Image 7

Figure 8

D. right-click your database to back up (output) data. There are several backup types. generally, select SQL,

E. The same is true for import.

Well, I wish you success!

Parse used dedecms to build a female website, which is similar to the Alimail female website. To test the function locally, you need to add a category column...