How to migrate a local MySQL database to a remote server

Source: Internet
Author: User

Intermediary transaction http://www.aliyun.com/zixun/aggregation/6858.html ">seo diagnose Taobao guest cloud host technology Hall

With Dedecms made a female website (http://www.libanvren.com, template later sent up for everyone to download), is The imitation of the woman net. 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, and then with the data picture upload together. It's fast! Good operation and flexibility. Now the database transplant process written to share with you, have such a friend can do a reference!

All the data is done, the application space, the application database, many cases are already data back. You must first back up the existing database. Then clear the database (clear all tables and data, see Tutorial: http://www.6yee.cn/html/jianzhanjiaocheng/20100522/508.html, before porting the database, make sure the database is empty, That is, there is no 6184.html "> datasheet."

First back up your local database, as follows.

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.

  

  

2. Run Mysql-front Backup to restore your database.

  

  

A, create a new login.

  

  

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

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

  

  

Server: Server IP

Port: typically 3306

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

User: The username 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.

  

  

Fill out this information and click OK to 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. You can open your database until you return all the data.

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

  

  

  

  

  

  

  

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

E, import is the same.

Well, wish you success!

Article originally published in Http://www.6yee.cn, please specify the source

Contact Us

The content source of this page is from Internet, which doesn't represent Alibaba Cloud's opinion; products and services mentioned on that page don't have any relationship with Alibaba Cloud. If the content of the page makes you feel confusing, please write us an email, we will handle the problem within 5 days after receiving your email.

If you find any instances of plagiarism from the community, please send an email to: info-contact@alibabacloud.com and provide relevant evidence. A staff member will contact you within 5 working days.

A Free Trial That Lets You Build Big!

Start building with 50+ products and up to 12 months usage for Elastic Compute Service

  • Sales Support

    1 on 1 presale consultation

  • After-Sales Support

    24/7 Technical Support 6 Free Tickets per Quarter Faster Response

  • Alibaba Cloud offers highly flexible support services tailored to meet your exact needs.