본문 바로가기

MySQL

MySQL Job failed to start

출처 : http://stackoverflow.com/questions/22909060/mysql-job-failed-to-start



First make a backup of your /var/lib/mysql/ directory just to be safe.

sudo mkdir /home/<your username>/mysql/
cd /var/lib/mysql/
sudo cp * /home/<your username>/mysql/ -R

Next purge MySQL (this will remove php5-mysql and phpmyadmin as well as a number of other libraries so be prepared to re-install some items after this.

sudo apt-get purge mysql-server-5.1 mysql-common

Remove the folder /etc/mysql/ and it's contents

sudo rm /etc/mysql/ -R

Next check that your old database files are still in /var/lib/mysql/ if they are not then copy them back in to the folder then chown root:root

(only run these if the files are no longer there)

sudo mkdir /var/lib/mysql/
sudo chown root:root /var/lib/mysql/ -R
cd ~/mysql/
sudo cp * /var/lib/mysql/ -R

Next install mysql server

sudo apt-get install mysql-server

Finally re-install any missing packages like phpmyadmin and php5-mysql.


'MySQL' 카테고리의 다른 글

MySQL 테이블 인코딩 변경하기  (0) 2014.11.26
ERROR 2003 (HY000): Can't connect to MySQL server on '127.0.0.1'  (0) 2014.11.26
DB 중복 개수 확인  (0) 2014.11.21
[MySQL] root 비밀번호 분실  (1) 2014.11.20
[MySQL] Mysql 한글 깨짐  (0) 2014.11.14