sivka krd
Junior Member | Редактировать | Профиль | Сообщение | ICQ | Цитировать | Сообщить модератору
После вырубания электроэнергии не стартовал mysql. Сайты просто не работают, mysqladmin:
Код: root@lii273:/etc/init.d# mysqladmin -p status
Enter password:
mysqladmin: connect to server at 'localhost' failed
error: 'Can't connect to local MySQL server through socket '/var/run/mysqld/mysqld.sock' (111)'
Check that mysqld is running and that the socket: '/var/run/mysqld/mysqld.sock' exists! |
Код: root@lii273: sudo /etc/init.d/mysql start
Rather than invoking init scripts through /etc/init.d, use the service(8)
utility, e.g. service mysql start
Since the script you are attempting to invoke has been converted to an
Upstart job, you may also use the start(8) utility, e.g. start mysql
start: Job is already running: mysql |
Код: root@lii273:~# mysql start
ERROR 2002 (HY000): Can't connect to local MySQL server through socket '/var/run/mysqld/mysqld.sock' (2) |
Код: root@lii273:/# 110712 21:46:42 mysqld_safe Logging to syslog.
110712 21:46:42 mysqld_safe Starting mysqld daemon with databases from /var/lib/mysql
110712 21:46:43 mysqld_safe mysqld from pid file /var/lib/mysql/lii273.pid ended
^C
[2]- Done mysqld_safe |
Файл /var/run/mysqld/mysqld.sock не существует. Конфиги остались, базы остались. В процессах то висит, то нет:
Код:
root@lii273:/# ps ax | grep mysql
6247 pts/0 S+ 0:00 grep --color=auto mysql |
Что проверить, что сделать?
Заранее спасибо.
--
Установлено:
Код: root@lii273:/etc/init.d# dpkg -l | grep mysql
ii libdbd-mysql-perl 4.012-1ubuntu1 A Perl5 database interface to the MySQL database
ii libmysqlclient16 5.1.41-3ubuntu12.10 MySQL database client library
ii mysql-client 5.1.41-3ubuntu12.10 MySQL database client (metapackage depending on the
ii mysql-client-5.1 5.1.41-3ubuntu12.10 MySQL database client binaries
ii mysql-client-core-5.1 5.1.41-3ubuntu12.10 MySQL database core client binaries
ii mysql-common 5.1.41-3ubuntu12.10 MySQL database common files (e.g. /etc/mysql/my.cnf)
ii mysql-server 5.1.41-3ubuntu12.10 MySQL database server (metapackage depending on the
ii mysql-server-5.1 5.1.41-3ubuntu12.10 MySQL database server binaries
ii mysql-server-core-5.1 5.1.41-3ubuntu12.10 MySQL database core server files
ii php5-mysql 5.3.2-1ubuntu4.7 MySQL module for php5 |
Логи:
Код: 110712 22:08:57 [Note] Plugin 'FEDERATED' is disabled.
110712 22:08:57 InnoDB: Started; log sequence number 0 1115895063
110712 22:08:57 [ERROR] /usr/sbin/mysqld: unknown variable 'bind-adress=localhost'
110712 22:08:57 [ERROR] Aborting
110712 22:08:57 InnoDB: Starting shutdown...
110712 22:08:59 InnoDB: Shutdown completed; log sequence number 0 1115895063
110712 22:08:59 [Note] /usr/sbin/mysqld: Shutdown complete |
|
Всего записей: 94 | Зарегистр. 02-04-2007 | Отправлено: 02:26 13-07-2011 | Исправлено: sivka krd, 03:48 13-07-2011 |
|
