Questions about Windows Server and mysql database backup

For advice, this post was last edited by PerfectGet at 18:07:06, January 1, on the Windows Server and mysql database backup.

Mysql database backup

We ran two servers, one IIS and one WAMP integration. now we need to delete the WAMP for separate WAMP configuration. now we need to back up the previous website, I used mysqldump under DOS to back up the old prompt syntax error, so I will use PHPMYADMIN, but the localhost address cannot be opened and the prompt 403 is displayed. how can this problem be solved ??? Another problem is that we need wamp and IIS services to coexist and share port 80. how can this problem be solved ??

Reply to discussion (solution)

Wamp hasn't been deleted yet. can you go to phpmyadmin for backup?

You can also back up data using graphical tools.

You just need to transform the inherited php environment to the discrete environment, you just need to copy the mysql \ data directory to the backup directory.
You can use my. ini to specify the mysql database directory so that you do not have to worry about data loss when changing the mysql system.

Apache and iis coexist, which can be:
Enable apache routing to route to iis
Assign a php website to apache through the assignment function of iis

In fact, there is no need to make any co-existence. iis can support php very well.

Recommended tool navicat can be backed up as long as it can be connected to the database.

Ports cannot coexist. only one port can use 80, and one port can use 8080.

To back up the MySQL database and use tools for export, you can also directly find the data directory under the MySQL installation directory and copy all the original database files.

You just need to transform the inherited php environment to the discrete environment, you just need to copy the mysql \ data directory to the backup directory.
You can use my. ini to specify the mysql database directory so that you do not have to worry about data loss when changing the mysql system.

Apache and iis coexist, which can be:
Enable apache routing to route to iis
Assign a php website to apache through the assignment function of iis

In fact, there is no need to make any co-existence. iis can support php very well.
Well, I want to change the LAMP environment. Is it because I only need to copy this mysql \ data directory to overwrite the new environment, and then change the database account and password in the website configuration? You are not familiar with assigning php websites to apache through the assignment function of iis ..

The first problem has been solved. how can the second problem be solved ??