Hi! > > > I accidently deleted the ibdata and iblogfile files.
> InnoDB: Error: log file ./ib_logfile0 is of different size > InnoDB: than specified in the .cnf file! You really have not deleted the ib_logfiles from the MySQL datadir. And probably not the ibdata1 file either. If you have already valuable data inserted, best to edit my.cnf so that it agrees with the real ib_logfile size. Or, if you can start from scratch: http://www.innodb.com/ibman.php#Wrong_creation " If something goes wrong in an InnoDB database creation, you should delete all files created by InnoDB. This means all data files, all log files, the small archived log file, and in the case you already did create some InnoDB tables, delete also the corresponding .frm files for these tables from the MySQL database directories. Then you can try the InnoDB database creation again. It is best to start the MySQL server from a command prompt so that you see what is happening. " Best regards, Heikki Tuuri Innobase Oy http://www.innodb.com Foreign keys, transactions, and row level locking for MySQL InnoDB Hot Backup - a hot backup tool for InnoDB which also backs up MyISAM tables Order MySQL technical support from https://order.mysql.com/ ----- Original Message ----- From: "M.D. DeWar" <[EMAIL PROTECTED]> To: "Heikki Tuuri" <[EMAIL PROTECTED]>; <[EMAIL PROTECTED]> Sent: Monday, December 29, 2003 10:33 PM Subject: Re: INNOB error and mysql won't start > yes. > InnoDB: Error: log file ./ib_logfile0 is of different size > InnoDB: than specified in the .cnf file! > 031229 8:54:37 Can't init databases > 031229 8:54:37 Aborting > > 031229 8:54:37 InnoDB: Warning: shutting down a not properly started > InnoDB: or created database! > 031229 8:54:37 /usr/local/libexec/mysqld: Shutdown Complete > > 031229 08:54:37 mysqld ended > > 031229 12:44:45 mysqld started > InnoDB: Error: log file ./ib_logfile0 is of different size > InnoDB: than specified in the .cnf file! > 031229 12:44:47 Can't init databases > 031229 12:44:47 Aborting > > 031229 12:44:47 InnoDB: Warning: shutting down a not properly started > InnoDB: or created database! > 031229 12:44:47 /usr/local/libexec/mysqld: Shutdown Complete > > 031229 12:44:47 mysqld ended > > Thanks > mark > ----- Original Message ----- > From: "Heikki Tuuri" <[EMAIL PROTECTED]> > To: <[EMAIL PROTECTED]> > Sent: Monday, December 29, 2003 12:41 PM > Subject: Re: INNOB error and mysql won't start > > > > Hi! > > > > What version of MySQL you are running? > > > > Is the output below ALL you get into the .err log? > > > > In >= 4.0 you can disbale InnoDB by putting the line > > > > skip-innodb > > > > to my.cnf. > > > > Best regards, > > > > Heikki Tuuri > > Innobase Oy > > http://www.innodb.com > > Foreign keys, transactions, and row level locking for MySQL > > InnoDB Hot Backup - a hot backup tool for InnoDB which also backs up > MyISAM > > tables > > > > Order MySQL technical support from https://order.mysql.com/ > > > > ----- Original Message ----- > > From: ""M.D. DeWar"" <[EMAIL PROTECTED]> > > Newsgroups: mailing.database.myodbc > > Sent: Monday, December 29, 2003 7:36 PM > > Subject: INNOB error and mysql won't start > > > > > > > Hello, > > > I have a problem that started. > > > I am getting this error in /var/log/messages > > > > > > 31229 12:44:47 Can't init databases > > > 031229 12:44:47 Aborting > > > > > > 031229 12:44:47 InnoDB: Warning: shutting down a not properly started > > > InnoDB: or created database! > > > 031229 12:44:47 /usr/local/libexec/mysqld: Shutdown Complete > > > > > > 031229 12:44:47 mysqld ended > > > > > > in the /etc/my.cnf I have all the innodb statement remmed out. > > > > > > I accidently deleted the ibdata and iblogfile files. > > > > > > How can I fix this. ? > > > > > > Thanks > > > Mark the newbie > > > > > > > > > -- > > > MySQL General Mailing List > > > For list archives: http://lists.mysql.com/mysql > > > To unsubscribe: > > http://lists.mysql.com/[EMAIL PROTECTED] > > > > > > > > > -- > > MySQL General Mailing List > > For list archives: http://lists.mysql.com/mysql > > To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED] > > > > > > -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
