Description:
Hi,
I migrated my server from slackware to centos 4.3. Backuped my databases using mysqldump(5.0.18), and restore it to mysql(5.0.22). i had a successful restoration, but every time i restart mysql, there's an error appearing on .err file. Below is the error file generated by mysql and my.cnf that i modified. Hoping for your resposne.
Thanks,
Noel
060805 02:03:42 mysqld started
InnoDB: The first specified data file ./ibdata1 did not exist:
InnoDB: a new database to be created!
060805 2:03:42 InnoDB: Setting file ./ibdata1 size to 10 MB
InnoDB: Database physically writes the file full: wait...
060805 2:03:42 InnoDB: Log file ./ib_logfile0 did not exist: new to be created
InnoDB: Setting log file ./ib_logfile0 size to 5 MB
InnoDB: Database physically writes the file full: wait...
060805 2:03:42 InnoDB: Log file ./ib_logfile1 did not exist: new to be created
InnoDB: Setting log file ./ib_logfile1 size to 5 MB
InnoDB: Database physically writes the file full: wait...
InnoDB: Doublewrite buffer not found: creating new
InnoDB: Doublewrite buffer created
InnoDB: Creating foreign key constraint system tables
InnoDB: Foreign key constraint system tables created
060805 2:03:43 InnoDB: Started; log sequence number 0 0
060805 2:03:43 [Note] /usr/sbin/mysqld: ready for connections.
Version: '5.0.22-standard' socket: '/var/lib/mysql/mysql.sock' port: 3306 MySQL Community Edition - Standard (GPL)
060805 2:20:29 [Note] /usr/sbin/mysqld: Normal shutdown
060805 2:20:29 InnoDB: Starting shutdown...
060805 2:20:31 InnoDB: Shutdown completed; log sequence number 0 43655
060805 2:20:31 [Note] /usr/sbin/mysqld: Shutdown complete
060805 02:20:31 mysqld ended
060805 02:20:31 mysqld started
InnoDB: Error: data file /var/lib/mysql/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!
060805 2:20:32 [Note] /usr/sbin/mysqld: ready for connections.
Version: '5.0.22-standard-log' socket: '/var/lib/mysql/mysql.sock' port: 3306 MySQL Community Edition - Standard (GPL)
060805 2:47:40 [Note] /usr/sbin/mysqld: Normal shutdown
my.cnf - for innodb
innodb_data_home_dir = /var/lib/mysql/
innodb_data_file_path = ibdata1:2000M;ibdata2:10M:autoextend
innodb_log_group_home_dir = /var/lib/mysql/
innodb_log_arch_dir = /var/lib/mysql/
innodb_buffer_pool_size = 384M
innodb_additional_mem_pool_size = 20M
innodb_log_file_size = 100M
innodb_log_buffer_size = 8M
innodb_flush_log_at_trx_commit = 1
innodb_lock_wait_timeout = 50
How to repeat:
migrate databases from slackware(mysql-5.0.18.tar) to centos(mysql-5.0.22 rpm),
