Yes, that was the problem, the my.cnf file was missing, replace it, restarted
and all is well :)
thx's
Mike
- Original Message -
From: Heikki Tuuri [EMAIL PROTECTED]
To: mysql@lists.mysql.com
Sent: Wednesday, March 22, 2006 2:10 AM
Subject: Re: Problem restarting server
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]
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]