| 1 |
Hi, |
| 2 |
|
| 3 |
The default log size changed between 4.0 and 4.1 and when u upgraded |
| 4 |
the /etc/mysql/my.cnf was overwriten. |
| 5 |
One solution would be to either remove the logs from /var/lib/mysql |
| 6 |
and restart the |
| 7 |
server and let mysql rebuild the log files. |
| 8 |
Second is to edit the /etc/mysql/my.cnf and make the log size 8M for |
| 9 |
innodb (innodb_log_file_size) |
| 10 |
InnoDB is no longer a use flag, it is compiled by default. |
| 11 |
If you don't want to use innodb engine you can tell mysql in the |
| 12 |
conf file to skip_innodb. |
| 13 |
In case it still doesn't want to start, check the error log again. |
| 14 |
|
| 15 |
Catalin |
| 16 |
|
| 17 |
Kevin Philp wrote: |
| 18 |
|
| 19 |
>I don't seem to have the log file you mention but this is in the |
| 20 |
>mysqld.err file. |
| 21 |
> |
| 22 |
>/var/log/mysql/mysqld.err |
| 23 |
>InnoDB: Error: log file ./ib_logfile0 is of different size 0 8388608 bytes |
| 24 |
>InnoDB: than specified in the .cnf file 0 5242880 bytes! |
| 25 |
>051107 9:13:17 [ERROR] Can't init databases |
| 26 |
>051107 9:13:17 [ERROR] Aborting |
| 27 |
> |
| 28 |
>I did read that innodb was a use flag (its not in my make.conf) and |
| 29 |
>emerge -pv mysql doesn't show it up. |
| 30 |
> |
| 31 |
>On 07/11/05, Catalin Trifu <catalin@××××××××××××.de> wrote: |
| 32 |
> |
| 33 |
> |
| 34 |
>> Hi, |
| 35 |
>> |
| 36 |
>> What does the mysql log say ? /var/lib/mysql/host.err |
| 37 |
>> |
| 38 |
>> Catalin |
| 39 |
>> |
| 40 |
>> |
| 41 |
>> |
| 42 |
>> Kevin Philp wrote: |
| 43 |
>> Last week I upgraded to mysql 4.1.14. I carefully followed every line |
| 44 |
>>of the upgrade guide inlcuding the revdep-rebuild and at the end I had |
| 45 |
>>a lovely new mysql 4.1 and all my databases had imported with no |
| 46 |
>>problems, phpmyadmin also worked fine. Now....about a week later I |
| 47 |
>>can't start mysql: |
| 48 |
>> |
| 49 |
>>/etc/init.d/mysql start - says mysql has already started but it hasn't |
| 50 |
>>(ps aux | grep -i my* shows nothing) |
| 51 |
>> |
| 52 |
>>mysql shows |
| 53 |
>>ERROR 2002 (HY000): Can't connect to local MySQL server through socket |
| 54 |
>>'/var/run/mysqld/mysqld.sock' (2) |
| 55 |
>> |
| 56 |
>>I have checked permissions on var/run/mysqld as recommended in another |
| 57 |
>>post and they are correct. I am running out of ideas....anyone any |
| 58 |
>>further ideas?? |
| 59 |
>> |
| 60 |
>>Thanks |
| 61 |
>> |
| 62 |
>>Kevin. |
| 63 |
>> |
| 64 |
>> |
| 65 |
>> |
| 66 |
>> |
| 67 |
>> |
| 68 |
> |
| 69 |
> |
| 70 |
> |
Archives