에러 메시지

ex)

 [root@lottov data]# vi localhost.err

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!

my.cnf 설정 내역
innodb_data_file_path = ibdata1:2000M;ibdata2:10M:autoextend
실제 pages (640) 와, my.cnf에 설정된 pages (128000) 가 달라서 에러가 나는것임.
.
계산을 해보면 1page 당 Memory는 16kbytes 이라고 하는데….
즉, 위 에러 로그상의 실제 page 는 640 pages 이므로
640 pages = 10Mbytes
128000 pages = 1000Mbytes
정확한 내용은 요기에 —> http://www.mail-archive.com/mysql@lists.mysql.com/msg76029.html
위 메모리 양에 따라 my.cnf 내용을 아래처럼 수정하고 mysql restart

innodb_data_file_path = /mysql/var/ibdata1:10M;/mysql/var/ibdata2:10M:autoextend