Dear [EMAIL PROTECTED]:
Here's my setting:
innodb_data_file_path = ibdata1:10M:autoextend
Now the ibdata1 has been grow up to 1.3G
We try to add more ibdata file to store the data by the following setting.
innodb_data_file_path = ibdata1:1500M;ibdata2:1500M:autoextend
innodb_data_file_path = ibdata1:10M;ibdata2:10M:autoextend
But both of them failed,it seems the new setting would crush the db by the diff pages
in the datafile.
Here's the log, do any way to solve this?
040924 15:55:38 mysqld started
InnoDB: Error: data file /home/mysql/data/ibdata1 is of a different size
InnoDB: 82560 pages (rounded down to MB)
InnoDB: than specified in the .cnf file 96000 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!
040924 15:55:38 Can't init databases
040924 15:55:38 Aborting
Best regards.
MaFai
[EMAIL PROTECTED]
2004-09-24
34955929
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
