window下免安装版mysql启动报如下错误
2014-02-11 16:20:27 8984 [ERROR] InnoDB: Attempted to open a previously opened tablespace. Previous tablespace minblog/tal_advertisement uses space ID: 2 at filepath: .\minblog\tal_advertisement.ibd. Cannot open tablespace mysql/innodb_index_stats which uses space ID: 2 at filepath: .\mysql\innodb_index_stats.ibd
InnoDB: Error: could not open single-table tablespace file .\mysql\innodb_index_stats.ibd
解决方法
Move (DON'T DELETE) those files, into another folder:
innodb_index_stats.frm
innodb_table_stats.frm
slave_master_info.frm
slave_relay_log_info.frm
slave_worker_info.frm
and .ibd files with the same filename:
innodb_index_stats.ibd
innodb_table_stats.ibd
slave_master_info.ibd
slave_relay_log_info.ibd
slave_worker_info.ibd
Try start MySQL.
分享到:
相关推荐
Mysql innodb tablespace 表空间实践
rlv方式增加oracle tablespace datafile
使用VB中的ADO编程实现不同oracle数据库之间数据交换! 源代码需要指定的不 同ORACLE环境下才能运行!
CREATE TABLESPACE命令详解 CREATE TABLESPACE命令详解
create tablespace tbsoa DATAFILE 'F:\app\Administrator\oradata\orcl\tbsoa.dbf' size 1024m autoextend on next 30m; create user oldoa identified by oldoa; grant dba to oldoa; alter user oldoa default ...
Oracle_create_tablespace语法详解.docx
impdp EAMS_NWPU_0913/eams directory=tmp dumpfile=EAMS_NWPU_0913.dpdmp remap_schema=EAMS_X:EAMS_NWPU_0913 remap_tablespace=JIAOWU:USERS LOGFILE=EAMS_NWPU_0913.log ---EAMS_NWPU_0913数据库名 ---eams ...
15:33:05: Copy file of Recover Tablespace: FY_REC_DATA_COPY.DAT 15:33:05: begin to recover table SYS.TRUNTAB1 15:33:19: [restore_table] Trying to restore data to SYS.TRUNTAB1$$2 15:33:20: [restore_...
create temporary tablespace user_temp tempfile 'D:\oracle\oradata\Oracle9i\user_temp.dbf' size 50m autoextend on next 50m maxsize 20480m extent management local; /*第2步:创建数据表空间...
USERNAME VARCHAR2(20) not null, PASSWORD VARCHAR2(20) not null, SEX VARCHAR2(20) not null, HEAD VARCHAR2(20) not null, REGDATE DATE not null ) tablespace SYSTEM pctfree 10 pctused 40 initrans ...
TABLE OBJ$ file_no: 1 block_no: 241 CLUSTER C_OBJ# file_no: 1 block_no: 49 CLUSTER C_OBJ# file_no: 1 block_no: 49 found IND$’s obj# 19 found IND$’s dataobj#:2,ts#:0,file#:1,block#:49,tab#:3 found ...
where table_owner NOT in ('SYS', 'SYSTEM') and t.table_name = 'F_PASSENGER_STOP' group by table_owner, table_name) b where a.table_owner = b.table_owner and a.table_name = b.table_name and a....
CREATE TABLESPACE MEDEXECGTYY DATAFILE 'E:\Oracle\MEDEXECGTYY.dbf' SIZE 20480M AUTOEXTEND OFF LOGGING ONLINE PERMANENT EXTENT MANAGEMENT LOCAL AUTOALLOCATE BLOCKSIZE 8K SEGMENT SPACE MANAGEMENT ...
- sharing <sql_id>: print why cursors are not shared - events [px]: events that someone is waiting for - events [read_by_other_session] events that someone is read by other session - ash ...
21、select ename, sal, comm from emp where sal not in (800, 1500,2000); --(可以对in指定的条件进行取反) 22、select ename from emp where ename like '%ALL%'; --(模糊查询) 23、select ename from emp ...
datafile 'c:\空间名' size 15M --表空间的存放路径,初始值为15M autoExtend on next 10M --空间的自动增长的值是10M permanent online; --永久使用 3.创建用户 create user shi --创建用户名为shi ...
CREATE TABLESPACE jyzx DATAFILE 'jyzx' SIZE 500M AUTOEXTEND ON NEXT 50M MAXSIZE unlimited LOGGING ONLINE PERMANENT EXTENT MANAGEMENT LOCAL AUTOALLOCATE BLOCKSIZE 8K SEGMENT SPACE MANAGEMENT AUTO ...
本ppt较为系统的介绍了Oracle11g的内存与存储管理,主要... --SPECIAL TABLESpaces:Temporary Tablespaces,SYSAUX,Undo Tablespace --Default Table space --BIGFILE TABsPacle 3.Storage Management --OMF --ASM
1.系统用例图 2.页面流程图 3.数据库设计 ... id VARCHAR2(50) not null, username VARCHAR2(20), password VARCHAR2(20), email VARCHAR2(50) ) tablespace USERS pctfree 10 initrans 1 maxtran