Mike,
----- Original Message -----
From: ""Mike Blezien"" <[EMAIL PROTECTED]>
Newsgroups: mailing.database.myodbc
Sent: Wednesday, March 22, 2006 3:42 AM
Subject: Problem restarting server
Hello,
we had to reboot our server and now we can't get MySQL started, in the
error log
it states:
==============================================
060321 19:34:13 mysqld started
060321 19:34:13 [Warning] Asked for 196608 thread stack, but got 126976
InnoDB: Error: log file ./ib_logfile0 is of different size 0 67108864
bytes
InnoDB: than specified in the .cnf file 0 5242880 bytes!
060321 19:34:13 [ERROR] Can't init databases
060321 19:34:13 [ERROR] Aborting
060321 19:34:13 [Note] /usr/sbin/mysqld: Shutdown complete
060321 19:34:13 mysqld ended
=============================================
How can this problem be fixed so we can restart MySQL server, kind of in a
bind
here now...
mysqld is probably reading a different my.cnf file now than it did when you
started mysqld last time. Have you edited my.cnf or replaced it while mysqld
was running?
Or could mysqld fail to find a my.cnf file altogether?
You should determine where your my.cnf is, and where your ibdata files and
ib_logfiles are, and specify in my.cnf appropriately:
http://dev.mysql.com/doc/refman/5.0/en/innodb-configuration.html
innodb_data_file_path
innodb_log_group_home_dir
innodb_log_files_in_group
innodb_log_file_size
TIA,
Mike
Mike(mickalo)Blezien
===============================
Thunder Rain Internet Publishing
Providing Internet Solution that Work
http://www.thunder-rain.com
===============================
Best regards,
Heikki
Oracle Corp./Innobase Oy
InnoDB - transactions, row level locking, and foreign keys for MySQL
InnoDB Hot Backup - a hot backup tool for InnoDB which also backs up MyISAM
tables
http://www.innodb.com/order.php
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]