Resolution of system error 1067 in mysql

The solution is as follows:
1. Delete the mysql service first
Control panel - > Management tools - > Service, stop the mysql service first
Start - > Run - > Input cmd - > sc delete mysql
Service to delete
2. Modify my. ini
If you don't have to create it (the following Settings can be reference http: / / hi baidu. com chuyanwu/blog item / 98142 a2e7d448d564ec2262c html1 like this setting will not mistake)
[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
Attachment: launch service bat: (under mysql root)

 
@echo off 
if not exist mysqlServer5\data\%computername%.pid goto startsvr 
net stop MySQL 
mysqlServer5\bin\mysqld-nt.exe --remove MySQL 
:startsvr 
echo MySQL The service is starting ..... 
mysqlServer5\bin\mysqld-nt.exe --install MySQL --defaults-file="%cd%\my.ini" 
net start MySQL 
pause 

MySQL installation and backup
1. Download MySQL
http://www.mysql.org/downloads
2. Installation process
1. Extract mysql-noinstall-5.0.51 b-win32.zip to 1 directory.
Assuming MYSQL_HOME = C: \ mysql - 5.0.51 b - win32
2. Wrote my.ini running configuration file for mysql
my.ini
-- -- -- -- -- �
[mysqld]
Set the installation directory for mysql
basedir=$MYSQL_HOME
Set the directory of the mysql database. It must be data or \\xxx\data
datadir=$MYSQL_HOME\data
Set the mysql server's character set
default-character-set=utf8
[client]
Set the character set for the mysql client
default-character-set=gbk
-- -- -- -- -- �
3. Install mysql service
Enter C from MS-DOS window :\ mysql-5.0.51 b-win32 \bin,
(put my.ini under C:\ mysql-5.0.51 b-win32 \)
Run the following command:
mysqld, install MySQL5, defaults-file =C:\ mysql-5.0.51 b-win32 \ my.ini But system error occurred.
mysqld-nt.exe-install (service installed successfully! And started successfully)
4. Start the mysql database
Also in the command window above, type net start MySQL5
This launches the mysql service.
5. Delete the service
Just execute mysqld and remove MySQL5
-- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- --
MySQL backups are often done in the following ways
1, use phpmyadmin, but with this backup, the size of the data should be less than two megabytes, too much is difficult to restore, for the data is very small backup, or quite useful!
2, backup, backup tool software program used to own the background that the backup data 1 and there is no limit to the size of the backup to come out after the restore is need to install the program in the new space, and then log in the background, in the background with its own 1 under the reducing tool is realized the import of new data, for example, like discuz, phpwind, bo - blog... Can backup like this!
3, use other SQL tools and software backup: easy to use has the advantage of the imperial backup king, the size of the database can be unlimited, but the program is zend, and a lot of backup program files.
Another software for faisunsql advantages, the size of the database can be unlimited, backup program on a file, easy to export, import, direct operation of the database. (highly recommended)