mysql提示奇怪错误,请看看是什么原因啊
我的mysql是5.0的,最近经常出问题,遇到各种各样的问题,我在err文件里找到以下内容,
091215 11:39:54 InnoDB: Operating system error number 32 in a file operation.
InnoDB: Some operating system error numbers are described at
InnoDB: http://dev.mysql.com/doc/mysql/en/Operating_System_error_codes.html
InnoDB: File name .\ibdata1
InnoDB: File operation call: 'open'.
InnoDB: Cannot continue operation.
根据这个网站我找到了32号
32 ERROR_SHARING_VIOLATION The process cannot access the file because it is being used by another process.
意思是进程不能访问文件因为有其它进程在使用,现在我只能用
mysqld --console启动我的mysql了,帮帮我吧,到底是什么原因呢,谢谢{{
相关问答:
我是用mysql自带的C API
if(mysql_real_connect(&mysql,"125.0.0.108","root","root","home",3306,NULL,0))
{
AfxMessageBox("数据库连接失败") ......
我开发ASP.net时
插入外文乱码
SHOW VARIABLES LIKE 'character%';
这个时候
character_set_client utf8
character_set_connection utf8
character_set_database utf8
ch ......
要转成一样的效果,用powerdesigner怎么转?能转吗?
create table publishers (
publisherID int identity,
publisherName varchar (30) NOT NULL,
constraint pk_publishers primary key (publisherID)
)& ......
请问下哪位仁兄有比较好的备份方案,用什么工具或者用什么方式,小弟借鉴下
直接用MYSQLDUMP备份
OR
用SQLYOG之类的图形化管理工具备份
直接用mysql自带的 mysqldump 就可以了。
http://dev.mysql.com/doc/re ......
先上错误
无法联接数据库
java.sql.SQLException: Before start of result set
at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:910)
at com.mysql.jdbc.ResultSet.checkRowPos(ResultSet.java: ......