Questions about Windows Server and mysql database backup

Source: Internet
Author: User
For advice, this post is about the Windows Server and mysql database backup problems. at last, we ran two IIS & nbsp; and one WAMP integration on the server by PerfectGet at 2013-11-011:07:06, now we need to delete the WAMP & nbsp; for the separate WAMP configuration, & nbsp; now we need to take the previous instructions on Windows Server and mysql database backup issues.
At last, this post was edited by PerfectGet at 18:07:06. we ran two servers, one for IIS and one for WAMP integration. now we need to delete WAMP for separate WAMP configuration, now I need to back up my previous website. if I use mysqldump under DOS to back up my old website with a syntax error, I will use PHPMYADMIN, but the localhost address cannot be opened and the error 403 will be 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 ?? Mysql database backup is shared:
------ Solution --------------------
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.
------ Solution --------------------
Recommended tool navicat can be backed up as long as it can be connected to the database.
------ Solution --------------------
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.

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.