> > innodb_data_file_path = ibdata1:1266M;ibdata2:10M:autoextend > > might work. But best to make a backup of the MySQL datadir first, just in
That did it. However I could not put ibdata2. It was saying no access rights to file ibdata2. Once I removed the ibdata2 entry it started fine. Another thing I noticed that it can't create the pid file. However it has no problem creating the err file. Would you know why is it so ? > case something goes wrong. > > Regards, > > Heikki > > ............................. > > Subject: Re: innodb data file of different size > From: Paul DuBois > Date: Wed, 30 Jul 2003 00:07:49 -0500 > > > > 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 > > > Thanks -- Asif Iqbal http://pgpkeys.mit.edu:11371/pks/lookup?op=get&search=0x8B686E08 There's no place like 127.0.0.1 -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]