I just decided to use my.cnf and bumped into this error message
030729 22:04:22 mysqld started InnoDB: Error: data file /usr/local/mysql/data/ibdata1 is of a different size InnoDB: 81024 pages (rounded down to MB) InnoDB: than specified in the .cnf file 16384 pages! InnoDB: Could not open data files 030729 22:04:23 Can't init databases 030729 22:04:23 Aborting
030729 22:04:23 InnoDB: Warning: shutting down a not properly started InnoDB: or created database! 030729 22:04:23 /usr/local/mysql-standard-4.0.13-sun-solaris2.8-sparc/bin/mysqld: Shutdown Complete
030729 22:04:23 mysqld ended
I am assuming I need to change values in the following line taken from my.cnf file
innodb_data_file_path = ibdata1:10M;ibdata2:10M:autoextend
Please help
Most likely you were running without any InnoDB-related options in your option file, so it was using its default values. Then you added the option shown above, which explicitly specifies sizes for the data files -- and which does not match the number or size of the default data file.
What I'd do if it were me in your situation:
- Remove the innodb_data_file_path line from your my.cnf file - Restart the server; it should come up normally now - Perform a complete dump of all your databases (just in case) (use mysqldump) - Perform a complete dump of your InnoDB tables (use mysqldump) - Remove your InnoDB tables - Shut down the server - Remove the default InnoDB data file and log files (these will be the files that begin with "ib" in your data directory) - Shut down the server - Add the innodb_data_file_path line to your my.cnf file - Start the server - Load the dump file back into the server to recreate your InnoDB tables
Thanks
-- Asif Iqbal http://pgpkeys.mit.edu:11371/pks/lookup?op=get&search=0x8B686E08 There's no place like 127.0.0.1
-- Paul DuBois, Senior Technical Writer Madison, Wisconsin, USA MySQL AB, www.mysql.com
Are you MySQL certified? http://www.mysql.com/certification/
-- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]