For advice, about Windows Server, MySQL database backup problem

This post was last edited by Perfectget on 2013-11-01 18:07:06

MySQL database backup

We ran on the server 2, an IIS a Wamp integration, now we need to put Wamp swap separate wamp configuration, now need to put the previous site backup, I use DOS mysqldump backup old hint syntax error, then I use phpMyAdmin Bar, But the localhost address can not open the hint 403, how to Solve??? Another problem is that we need wamp and IIS services to co-exist with the common port 80 what good way??

Reply to discussion (solution)

Wamp haven't deleted, can you get into phpMyAdmin backup?

Graphical tools can also be used to back up

You just need to transform the inherited PHP environment into a discrete environment, so just copy the Mysql\data directory to the backup directory
You can specify the MySQL database directory with My.ini, so you don't have to worry about data loss when you replace the MySQL system

Apache and IIS coexist, and can have:
Enable the Apache routing feature to route to IIS
assigning PHP sites to Apache via the IIS assignment feature

In fact, there is no need to co-exist, IIS like to support PHP well

Recommended tool Navicat as long as you can connect to the database, you can back up

Ports cannot coexist, only one with 80, one with 8080 and the like.

Backup MySQL database, with the tool for export of course, you can also directly find the MySQL installation directory of the data directory, copy all the database raw files.

You just need to transform the inherited PHP environment into a discrete environment, so just copy the Mysql\data directory to the backup directory
You can specify the MySQL database directory with My.ini, so you don't have to worry about data loss when you replace the MySQL system

Apache and IIS coexist, and can have:
Enable the Apache routing feature to route to IIS
assigning PHP sites to Apache via the IIS assignment feature

In fact, there is no need to co-exist, IIS like to support PHP well
Yes, I want to change the lamp environment. So I just need this mysql\data copy out this directory to overwrite the new environment, and then the site configuration changes the database account password? Your assignment to Apache via IIS does not understand the PHP site.

The first problem has been solved, how to solve the second problem??

