Mam problem związany z mysql. Wszystko chodziło dobrze, nagle w nocy z piątku na sobotę pojawił się problem z MySQLem (mam VPS'a).
Kod
Can't connect to local MySQL server through socket '/tmp/mysql.sock' (2)
Czytałem wiele na temat tego problemu i próbowałem różnych sposobów naprawy - nic mi nie pomogło.
Po wykonaniu
Kod
host-01:~# /etc/init.d/mysqld restart
Stopping mysqld: [ FAILED ]
Starting mysqld: [ OK ]
host-01:~# /usr/local/mysql/bin/mysqld_safe &
[1] 10823
host-01:~# 100411 14:58:50 mysqld_safe Logging to '/var/lib/mysql/host-01.amxboard.pl.err'.
100411 14:58:50 mysqld_safe Starting mysqld daemon with databases from /var/lib/mysql
100411 14:58:50 mysqld_safe mysqld from pid file /tmp/mysqld.pid ended
[1]+ Done /usr/local/mysql/bin/mysqld_safe
W logach mamStopping mysqld: [ FAILED ]
Starting mysqld: [ OK ]
host-01:~# /usr/local/mysql/bin/mysqld_safe &
[1] 10823
host-01:~# 100411 14:58:50 mysqld_safe Logging to '/var/lib/mysql/host-01.amxboard.pl.err'.
100411 14:58:50 mysqld_safe Starting mysqld daemon with databases from /var/lib/mysql
100411 14:58:50 mysqld_safe mysqld from pid file /tmp/mysqld.pid ended
[1]+ Done /usr/local/mysql/bin/mysqld_safe
Cytat
100411 14:06:40 [Warning] Forcing shutdown of 2 plugins
100411 14:06:40 [Note]
100411 14:06:40 mysqld_safe mysqld from pid file /tmp/mysqld.pid ended
100411 14:06:51 mysqld_safe Starting mysqld daemon with databases from /var/lib/mysql
100411 14:06:51 [Warning] The syntax '--log_slow_queries' is deprecated and will be removed in MySQL 7.0. Please use '--slow_query_log'/'--slow_query_log_file' instead.
100411 14:06:51 [Warning] The syntax '--log' is deprecated and will be removed in MySQL 7.0. Please use '--general_log'/'--general_log_file' instead.
100411 14:06:51 [Warning] The syntax '--log_slow_queries' is deprecated and will be removed in MySQL 7.0. Please use '--slow_query_log'/'--slow_query_log_file' instead.
100411 14:06:51 [ERROR] Error message file '/usr/share/mysql/english/errmsg.sys' had only 475 error messages,
but it should contain at least 630 error messages.
Check that the above file is the right version for this program!
100411 14:06:51 [Note] Plugin 'InnoDB' disabled by command line option
/usr/local/mysql/bin/mysqld: Unknown error 1146
100411 14:06:51 [ERROR] Can't open the mysql.plugin table. Please run mysql_upgrade to create it.
100411 14:06:51 [ERROR] /usr/local/mysql/bin/mysqld: unknown option '--skip-bdb'
100411 14:06:51 [ERROR] Aborting
100411 14:06:51 [Warning] Forcing shutdown of 2 plugins
100411 14:06:51 [Note]
100411 14:06:51 mysqld_safe mysqld from pid file /tmp/mysqld.pid ended
100411 14:06:40 [Note]
100411 14:06:40 mysqld_safe mysqld from pid file /tmp/mysqld.pid ended
100411 14:06:51 mysqld_safe Starting mysqld daemon with databases from /var/lib/mysql
100411 14:06:51 [Warning] The syntax '--log_slow_queries' is deprecated and will be removed in MySQL 7.0. Please use '--slow_query_log'/'--slow_query_log_file' instead.
100411 14:06:51 [Warning] The syntax '--log' is deprecated and will be removed in MySQL 7.0. Please use '--general_log'/'--general_log_file' instead.
100411 14:06:51 [Warning] The syntax '--log_slow_queries' is deprecated and will be removed in MySQL 7.0. Please use '--slow_query_log'/'--slow_query_log_file' instead.
100411 14:06:51 [ERROR] Error message file '/usr/share/mysql/english/errmsg.sys' had only 475 error messages,
but it should contain at least 630 error messages.
Check that the above file is the right version for this program!
100411 14:06:51 [Note] Plugin 'InnoDB' disabled by command line option
/usr/local/mysql/bin/mysqld: Unknown error 1146
100411 14:06:51 [ERROR] Can't open the mysql.plugin table. Please run mysql_upgrade to create it.
100411 14:06:51 [ERROR] /usr/local/mysql/bin/mysqld: unknown option '--skip-bdb'
100411 14:06:51 [ERROR] Aborting
100411 14:06:51 [Warning] Forcing shutdown of 2 plugins
100411 14:06:51 [Note]
100411 14:06:51 mysqld_safe mysqld from pid file /tmp/mysqld.pid ended
Ma ktoś jakieś propozycje ?
#edit
Podobny mam problem jak tutaj: http://forum.php.pl/index.php?showtopic=48146