The workaround is as follows:
1, first remove the MySQL service
Control Panel-> management tools-> Service, stop MySQL service first
Start-> run-> enter CMD->SC delete MySQL
Service deletion
2. Modify My.ini
If it is not created (the following settings can refer to http://hi.baidu.com/chuyanwu/blog/item/98142a2e7d448d564ec2262c.html general This setting is not wrong)
[Mysqld]
# set Basedir to your installation path
Basedir=c:/mysql (MySQL directory)
# set DataDir to the * * * * * of your Data directory
Datadir=c:/mysql/data (MySQL directory/data)
[Winmysqladmin]
Server=c:/mysql/bin/mysqld-nt.exe
3, start the service
Attached: Boot service Bat: (placed in MySQL root directory)
Copy Code code as follows:
@echo off
If not exist Mysqlserver5\data\%computername%.pid goto STARTSVR
net stop MySQL
Mysqlserver5\bin\mysqld-nt.exe--remove MySQL
: Startsvr
echo MySQL service is starting .....
Mysqlserver5\bin\mysqld-nt.exe--install MySQL--defaults-file= "%cd%\my.ini"
net start MySQL
Pause
MySQL installation and backup
First, download MySQL
Http://www.mysql.org/downloads
Second, the installation process
1, decompression mysql-noinstall-5.0.51b-win32.zip to a directory.
Suppose Mysql_home=c:\mysql-5.0.51b-win32
2, write the MySQL run configuration file My.ini
My.ini
—————————–
[Mysqld]
# set the MySQL installation directory
basedir= $MYSQL _home
# set up the MySQL database data storage directory, must be either data, or \\xxx\data
datadir= $MYSQL _home\data
# set the character set of the MySQL server
Default-character-set=utf8
[Client]
# set the MySQL client's character set
Default-character-set=gbk
—————————–
3. Install MySQL Service
Enter directory C:\mysql-5.0.51b-win32\bin from MS-DOS window,
(Put the My.ini in the C:\mysql-5.0.51b-win32\ directory!) )
Run the following command:
Mysqld–install Mysql5–defaults-file=c:\mysql-5.0.51b-win32\my.ini (Service installation success!) However, a system error occurred 1067)
Mysqld-nt.exe-install (Service installation success!) and started successfully)
4. Start MySQL Database
Also in the command window above, enter the command: net start MySQL5
This will start the MySQL service.
5. Delete Service
Execute Mysqld–remove MySQL5 can
－－－－－－－－－－－－－－－－－－－－－－－－－
MySQL backups often have the following methods
1, the use of phpMyAdmin, but with this backup, the size of the data is less than two trillion, more than a bad recovery, for the data is particularly small backup, or quite useful!
2, the use of software from the background Backup tool with backup tools, this backup out of the data is generally no size limit, backup after the restore is required to install the program in the new space once, and then landing backstage, in the background with its own restore tool to restore the new data to achieve the import, for example, like Discuz, Phpwind, Bo-blog ... Can be backed up like this!
3, use other SQL Tools software Backup: More useful with the imperial backup King Advantage, the database can be unlimited size, but the program was Zend, and backup program files a lot.
Another software for the Faisunsql advantage, the database can be unlimited size, backup program on a file, export, import convenient, direct operation of the database. (Highly recommended)
