2011年4月5日 星期二

Mysql error 1289問題

今天匯入access2010到mysql時遇到error1289錯誤,找了一些資料都是不成功,後面才發現是mysql應該用命令模式停止
InnoDB problem with windows MySQL 5.0.15?
Step 1. Stop MySQL service
使用管理者權限執行cmd
net stop mysql

Step 2. In my.ini file search and change:

# Use this option if you have a MySQL server with InnoDB support enabled
# but you do not plan to use it. This will save memory and disk space
# and speed up some things.
skip-innodb
to:

# Use this option if you have a MySQL server with InnoDB support enabled
# but you do not plan to use it. This will save memory and disk space
# and speed up some things.
#skip-innodb



Step 3. Save my.ini file.

Step 4. ReStart MySQL service.
net start mysql
這個問題解決了。