At 22:08 -0400 7/29/03, Asif Iqbal wrote:
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]



Reply via email to