Ratheesh K J schrieb:
Hello all,
yesterday we seperated our app server and db server. We moved our 70GB of data from our app server to a new DB server. We installed MySQL 4.1.11 on the DB server.
Now the following happened. On the DB server the ibdata1 and all the databases
are the old ones (which were copied from the app server). But when Mysql was
installed the ib_logfile0 ib_logfile1 and ib_logfile2 were created freshly on
the DB serever. Each of these log files were created with 5M size. on the app
server these files were 256M in size (innodb_log_file_size = 256M). On the DB
server it is (innodb_log_file_size = 5M).
Today morning when I checked the error log, there seems to be a lot of error
msg flowing in.
061211 11:41:47 InnoDB: Error: page 203046 log sequence number 87 3002891543
InnoDB: is in the future! Current system log sequence number 86 4025048037.
InnoDB: Your database may be corrupt.
You cannot just copy innodb-databases to other servers without adjusting
your my.cnf: Once you created an innodb-database, you cannot change
parameters like "innodb_log_file_size" any more.
(this is explained in the manual, you should read the chapter about
backing up and restoring innodb-databases) So when you copy the database
to the new server, be sure to copy the settings from the my.cnf, too!
Jan
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
