porting MySQL to remote server using Apmserv

MySQL is an open source relational database management system, the developer for the Swedish MySQL AB company, is now part of sun company. Oracle announced the acquisition of Sun Company in 2009, so MySQL may become Oracle's products. Because of its high performance, low cost and good reliability, MySQL has become the most popular open source database and is widely used in small and medium Web sites on the Internet. As MySQL matures, it is increasingly used for more large-scale websites and applications, such as Wikipedia, Google and Facebook. The very popular open source software combination of "M" in lamp refers to MySQL.
Download: http://dev.mysql.com/downloads/mysql/#downloads

APMServ5.2.6 is a rapid structure with a graphical interface Apache2.2.9, PHP5.2.6, mysql5.1.28&4.0.26, Nginx0.7.19, Memcached1.2.4, phpMyAdmin2.11.9.2, OpenSSL, SQLite, Zendoptimizer, and green Software for ASP, CGI, and Perl Web server platforms. No installation, flexible mobility, copy it to other directories, partitions or other computers, all you need to click the Start button in APMServ.exe, you can automatically set the relevant settings, Apache and MySQL installed as system services and start. Apmserv brings together the advantages of Apache stability and security, and has a graphical management interface as convenient as IIS, while supporting the mysql5.0&4.0 two versions, virtual hosts, virtual directories, port changes, SMTP, upload size limits, automatic global variables, SSL certificate making, Caching performance optimization settings, just a little mouse to complete.

[DOMESTIC download point ①→ sina love to ask CDN] http://blog.s135.com/apmserv/bin/5.2.6/sina/
[FOREIGN download Point ①→ US Microsoft] http://blog.s135.com/apmserv/bin/5.2.6/microsoft/

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 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, 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.