One migration of Linux server Web sites to Windows Server

The Web service used by a Web site on a linux server is nginx+mysql+php and needs to be migrated to a Windows server for a variety of reasons.

Preparation for pre-work

Versions of 1,php and MySQL

2, site size and type

3, Database size

Because the website is too huge 90G, and the Linux server disk space is not enough to compress, finally I choose the method is to use FTP pass, did not think of any good way. This process takes a week to download the event to complete.

The database size of this site is more than 2G, which has a web site of the MySQL database to reach 1.9G, and the size of the exported SQL file is also 1.3G, the other few are small site database is not big.

The website source program downloads the process, did not encounter any important question. In the process of database export import encountered a problem, the database SQL file over 100M will have problems (have adjusted the size of the Max_allowed_packet), and finally look at several of the tables are particularly large, the method of importing two, Import in batches (tables with large export data) and copy database files directly.

After all the sites have been deployed, two questions are encountered

1, one of the Web site is installed with Phpyun program, the source program folder Templates_c need higher permissions to run, to ensure that the site is normal;

2, another site is phpcms installation, before building PHP with the php5.3, the same environment other sites do not have problems, and this site has been 500 errors, can not open, after a long study, decided to change a PHP5.2 installation version, after the website access is normal. Preliminary decisions may be caused by the Libmysql.dll file and its permissions issues (not tested only).

At this point, all the Web site source program and database migration is complete!

This article is from the "Forsk" blog, make sure to keep this source http://forsk.blog.51cto.com/8096006/1548323

One migration of Linux server Web sites to Windows Server