List:General Discussion« Previous MessageNext Message »
From:Mike Blezien Date:March 22 2006 11:59am
Subject:Re: Problem restarting server
View as plain text  
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" <heikki.tuuri@stripped>
To: <mysql@stripped>
Sent: Wednesday, March 22, 2006 2:10 AM
Subject: Re: Problem restarting server


> Mike,
>
> ----- Original Message ----- 
> From: ""Mike Blezien"" <mickalo@stripped>
> 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/mysql?unsub=1
>
> 

Thread
Problem restarting serverMike Blezien22 Mar
Re: Problem restarting serverHeikki Tuuri22 Mar
Re: Problem restarting serverMike Blezien22 Mar