The entire process of migrating from a MySQL database and forum program in Windows Server to a Linux system

1. preferred to enter Windows Server, current directory under D:\Mysql server5.0\data\ mysqldump–u root–p ultrax >ultrax.sql //Note Meaning: The current directory is to be located in the data directory, otherwise exported is an empty file;

or d:\Mysql server5.0\data\ mysqldump–u root–p ultrax >ultrax.txt// the Export data format is determined by the user ;

when you execute the above command, you are prompted to enter MySQL database Password, the time to export the data depends on the size of your database.

2. put the exported data through the WinSCP tools, remote upload Linux server;

3. in theLinuxin the serverMysql>source/home/ultrax.sql//The path is the location that is stored according to your data source;Note: First set up the databasemysql>createdatabase Ultrax; second, to open the databasemysql>useultrax;the last is the import data, otherwise cannot import;

4. putForumProgram throughWinSCPthe tool uploadsLinuxServer,Storage Path#/var/www/html/forum

There are 3 things to do next:

Error 1 :

Can not write to Cachefiles, please check directory./data/and./data/cach

# Chmod-r 777/var/www/html/bbs/data// Note: -R can not be less, refer to the specific file, or point to the data all files under the , in manipulating this item, keep in mind that do not operate in the current directory, to be returned to the parent level directory to operate;

Error 2 : Ucenter Info: Can not connect to MySQLServer
Error:
Errno:0

The reason for this error is that because the Linux server is running on a Windows server , the database configuration file must be changed to the current linux mysql password ;

Error 3:

650) this.width=650; "src=" Http://s3.51cto.com/wyfs02/M01/4D/DB/wKiom1RbFprAmkYmAAGsTvGsY1Y388.jpg "title=" Not named 2. JPG "alt=" wkiom1rbfpramkymaagstvgsy1y388.jpg "/>

The above reason is due to the previously set path, which now needs to be updated to the current address: Http://117.40.239.9/bbs

key steps: Log in to the forum backstage find the corresponding background Tools menu for the current site's files to update the cache and file permission checks.

Finally, you can visit the forum. In fact, the entire process is not very complex, but the database technology, program file mode, basic command use, port number settings, firewall settings, professional basic theory, analysis, processing problems of a whole learning and application process. In fact, can be used as a case, so that students solve similar problems, the harvest is certainly not small.

The above cases are solved in the real environment. Completed at noon on 2014.11.6 Day.

This article is from the "Operations" blog, please be sure to keep this source http://sky9896.blog.51cto.com/2330653/1573413

The entire process of migrating from a MySQL database and forum program in Windows Server to a Linux system