Shulou(Shulou.com)05/31 Report--

This article mainly introduces the mysql system error 1067 how to do, has a certain reference value, interested friends can refer to, I hope you can learn a lot after reading this article, the following let Xiaobian take you to understand.

The solution is as follows:

1. Delete the mysql service first

Control Panel-> Administrative tools-> Services, stop the mysql service first

Start-> run-> enter cmd- > sc delete mysql

Service deletion

2. Modify my.ini

If it is not created (you can refer to http://hi.baidu.com/chuyanwu/blog/item/98142a2e7d448d564ec2262c.html for the following settings, generally this setting will not be wrong)

[mysqld]

# set basedir to your installation path

Basedir=c:/mysql (directory where mysql is located)

# set datadir to the * of your data directory

Datadir=c:/mysql/data (directory where mysql is located / data)

[WinMySQLAdmin]

Server=c:/mysql/bin/mysqld-nt.exe

3. Start the service

Attached: start the service bat: (put it in the mysql root directory)

The copy code is as follows:

@ echo off

If not exist mysqlServer5\ data\% computername%.pid goto startsvr

Net stop MySQL

MysqlServer5\ bin\ mysqld-nt.exe-- remove MySQL

: startsvr

The 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

1. MySQL

Http://www.mysql.org/downloads

II. Installation process

1. Extract the mysql-noinstall-5.0.51b-win32.zip to a directory.

Suppose MYSQL_HOME=C:\ mysql-5.0.51b-win32

2. Write the running configuration file my.ini of mysql

My.ini

--

[mysqld]

# set the installation directory of mysql

Basedir=$MYSQL_HOME

# set the data storage directory of the mysql database, which must be data or\\ xxx\ data

Datadir=$MYSQL_HOME\ data

# set the character set of mysql server

Default-character-set=utf8

[client]

# set the character set of mysql client

Default-character-set=gbk

--

3. Install the mysql service

Enter the directory C:\ mysql-5.0.51b-win32\ bin from the MS-DOS window

(put 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 installed successfully! However, a system error occurred 1067)

Mysqld-nt.exe-install (service installed successfully! And successfully started)

4. Start the mysql database

Still in the command window above, enter the command: net start MySQL5

This starts the mysql service.

5. Delete the service

Just execute mysqld-remove MySQL5

-

There are often the following methods for MySQL backup

1, the use of myadmin, but with this backup, the size of the data should be less than two megabytes, more difficult to restore, for very small data backup, or quite useful!

2. Use the background backup tool that comes with the program software to back up the data, so there is generally no limit on the size of the data. After the backup comes out, you need to install the program in the new space once, then log in to the background, restore it with its own restore tools in the background, and then import the new data, such as discuz, phpwind, bo-blog. Can be backed up like this!

3, use other SQL tools software backup: easier to use the Imperial backup King advantages, can be unlimited size, but the program has been zend, and a lot of backup program files.

Another software for the advantages of faisunsql, the database can be unlimited size, backup program on a file, export, import convenience, direct operation of the database.

Thank you for reading this article carefully. I hope the article "what to do with mysql system error 1067" shared by the editor will be helpful to everyone. At the same time, I also hope that you will support us and pay attention to the industry information channel. More related knowledge is waiting for you to learn!

Welcome to subscribe "Shulou Technology Information " to get latest news, interesting things and hot topics in the IT industry, and controls the hottest and latest Internet news, technology news and IT industry trends.