리눅스 mysql 데몬 실행시 에러 로그파일이 다음과 같을때...
페이지 정보
작성자
본문
110716 23:35:23 mysqld started
InnoDB: Error: data file /usr/local/mysql/var/ibdata1 is of a different size
InnoDB: 0 pages (rounded down to MB)
InnoDB: than specified in the .cnf file 128000 pages!
InnoDB: Could not open or create data files.
InnoDB: If you tried to add new data files, and it failed here,
InnoDB: you should now edit innodb_data_file_path in my.cnf back
InnoDB: to what it was, and remove the new ibdata files InnoDB created
InnoDB: in this failed attempt. InnoDB only wrote those files full of
InnoDB: zeros, but did not yet use them in any way. But be careful: do not
InnoDB: remove old data files which contain your precious data!
110716 23:35:23 [ERROR] Can't init databases
110716 23:35:23 [ERROR] Aborting
ib_logfile0 파일을 삭제하고 mysql 데몬을 아래와 같이 재시작하면....
#/usr/local/mysql/share/mysql/mysql.server start
Starting MySQL SUCCESS!
만약 아래와 같이 에러 로그가 기록되어 있다면...
080307 20:24:58 mysqld started
InnoDB: Error: data file /usr/local/mysql/data/ibdata1 is of a different size
InnoDB: 640 pages (rounded down to MB)
InnoDB: than specified in the .cnf file 128000 pages!
InnoDB: Could not open or create data files.
InnoDB: If you tried to add new data files, and it failed here,
InnoDB: you should now edit innodb_data_file_path in my.cnf back
InnoDB: to what it was, and remove the new ibdata files InnoDB created
InnoDB: in this failed attempt. InnoDB only wrote those files full of
InnoDB: zeros, but did not yet use them in any way. But be careful: do not
InnoDB: remove old data files which contain your precious data!
080307 20:24:58 [ERROR] Can't init databases
080307 20:24:58 [ERROR] Aborting
080307 20:24:58 [Note] /usr/local/mysql/libexec/mysqld: Shutdown complete
1page = 16KB이므로 640페이지*16KB / 1024KB = 10MB
#vi /etc/my.cnf
:
innodb_data_home_dir = /usr/local/mysql/data/
innodb_data_file_path = ibdata1:10M;ibdata2:10M:autoextend
:
위와 같이 설정해 주고 ibdata* 파일을 삭제하고 mysql 데몬을 재시작한다.
InnoDB: Error: data file /usr/local/mysql/var/ibdata1 is of a different size
InnoDB: 0 pages (rounded down to MB)
InnoDB: than specified in the .cnf file 128000 pages!
InnoDB: Could not open or create data files.
InnoDB: If you tried to add new data files, and it failed here,
InnoDB: you should now edit innodb_data_file_path in my.cnf back
InnoDB: to what it was, and remove the new ibdata files InnoDB created
InnoDB: in this failed attempt. InnoDB only wrote those files full of
InnoDB: zeros, but did not yet use them in any way. But be careful: do not
InnoDB: remove old data files which contain your precious data!
110716 23:35:23 [ERROR] Can't init databases
110716 23:35:23 [ERROR] Aborting
ib_logfile0 파일을 삭제하고 mysql 데몬을 아래와 같이 재시작하면....
#/usr/local/mysql/share/mysql/mysql.server start
Starting MySQL SUCCESS!
만약 아래와 같이 에러 로그가 기록되어 있다면...
080307 20:24:58 mysqld started
InnoDB: Error: data file /usr/local/mysql/data/ibdata1 is of a different size
InnoDB: 640 pages (rounded down to MB)
InnoDB: than specified in the .cnf file 128000 pages!
InnoDB: Could not open or create data files.
InnoDB: If you tried to add new data files, and it failed here,
InnoDB: you should now edit innodb_data_file_path in my.cnf back
InnoDB: to what it was, and remove the new ibdata files InnoDB created
InnoDB: in this failed attempt. InnoDB only wrote those files full of
InnoDB: zeros, but did not yet use them in any way. But be careful: do not
InnoDB: remove old data files which contain your precious data!
080307 20:24:58 [ERROR] Can't init databases
080307 20:24:58 [ERROR] Aborting
080307 20:24:58 [Note] /usr/local/mysql/libexec/mysqld: Shutdown complete
1page = 16KB이므로 640페이지*16KB / 1024KB = 10MB
#vi /etc/my.cnf
:
innodb_data_home_dir = /usr/local/mysql/data/
innodb_data_file_path = ibdata1:10M;ibdata2:10M:autoextend
:
위와 같이 설정해 주고 ibdata* 파일을 삭제하고 mysql 데몬을 재시작한다.
댓글목록
등록된 댓글이 없습니다.