Менял права на /var/lib/mysql , чтобы забрать оттуда файл экспорта БД, затем вернул все обратно,теперь mysql не стартует
ERROR 2013 (HY000) at line 1: Lost connection to MySQL server during query
ERROR 2002 (HY000): Can't connect to local MySQL server through socket '/var/run/mysqld/mysqld.sock' (2)
160120 14:55:16 InnoDB: ERROR: the age of the last checkpoint is 9448197,
InnoDB: which exceeds the log group capacity 9433498.
InnoDB: If you are using big BLOB or TEXT rows, you must set the
InnoDB: combined size of log files at least 10 times bigger than the
InnoDB: largest such row.
160120 14:55:47 [ERROR] /usr/sbin/mysqld: Can't find file: './ciz_new/wp_postmeta.frm' (errno: 13)
160120 14:55:47 [ERROR] /usr/sbin/mysqld: Can't find file: './ciz_new/wp_postmeta.frm' (errno: 13)
160120 14:55:47 InnoDB: Operating system error number 13 in a file operation.
InnoDB: The error means mysqld does not have the access rights to
InnoDB: the directory.
InnoDB: File name ./ciz_new/wp_options.frm
InnoDB: File operation call: 'stat'.
160120 14:55:47 [ERROR] /usr/sbin/mysqld: Can't find file: './ciz_new/wp_posts.frm' (errno: 13)
160120 14:55:47 [ERROR] /usr/sbin/mysqld: Can't find file: './ciz_new/wp_postmeta.frm' (errno: 13)
160120 15:01:39 [ERROR] Table ./ciz_new/wp_postmeta has a primary key in InnoDB data dictionary, but not in MySQL!
12:01:39 UTC - mysqld got signal 11 ;
This could be because you hit a bug. It is also possible that this binary
or one of the libraries it was linked against is corrupt, improperly built,
or misconfigured. This error can also be caused by malfunctioning hardware.
We will try our best to scrape up some info that will hopefully help
diagnose the problem, but since we have already crashed,
something is definitely wrong and this may fail.
судя по логу mysqld не хватает прав
Пользователь решил продолжить мысль 20 Января 2016, 16:06:25:
удалил mysqld.sock из /var/run/mysqld
поставил заново права sudo chown -R mysql /var/run/mysqld
и стартанул,все заработао,иеху)