mysql無法啟動 ERROR 2002 - Linux
By Rae
at 2013-05-24T14:45
at 2013-05-24T14:45
Table of Contents
板上各位大家好
前言:
作業系統是Ubuntu,最近在學校打工幫忙維護Drupal的網頁
昨天接到說突然有網頁無法更新的情況
後來我要從後台使用者登入,server卻一直沒有回應
上網爬文過後嘗試了GRANT ALL PRIVILEGES ON databasename.* 指令
之後重新啟動mysql後 Server load 突然變很重,
Drupal現在就成線site off-line的狀態
後來我要從command-line連線mysql時
出現以下錯誤:
ERROR 2002 (HY000): Can't connect to local MySQL server through socket
'/var/run/mysqld/mysqld.sock' (2)
telnet 發現 mysql 3306 沒有運作
然後/var/run/mysqld也是空的
上網爬文後發現別人的解決方法
1.重灌mysql,可是我怕一重灌mysql,Drupal會整個掛掉
2.有人說/var/lib/mysql站太多容量了,要減肥
可是這裡面都是資料庫的資料表,若要備份該如何下手?
還是能在/var/run/mysqld 底下新增mysqld.sock的檔案呢?
麻煩各位了
-------------------------------
+ set -e
+ basename /etc/init.d/mysql
+ INITSCRIPT=mysql
+ JOB=mysql
+ [ mysql = upstart-job ]
+ [ -z start ]
+ COMMAND=start
+ shift
+ [ -z ]
+ ECHO=echo
+ echo Rather than invoking init scripts through /etc/init.d, use the service(8)
Rather than invoking init scripts through /etc/init.d, use the service(8)
+ echo utility, e.g. service mysql start
utility, e.g. service mysql start
+ echo
+ echo Since the script you are attempting to invoke has been converted to an
Since the script you are attempting to invoke has been converted to an
+ echo Upstart job, you may also use the start(8) utility, e.g. start mysql
Upstart job, you may also use the start(8) utility, e.g. start mysql
+ awk /[0-9]$/ { print $NF }
+ status mysql
+ PID=
+ [ -z ]
+ [ start = stop ]
+ [ -n ]
+ [ -z ]
+ [ start = restart ]
+ start mysql
start: Job failed to start
--
前言:
作業系統是Ubuntu,最近在學校打工幫忙維護Drupal的網頁
昨天接到說突然有網頁無法更新的情況
後來我要從後台使用者登入,server卻一直沒有回應
上網爬文過後嘗試了GRANT ALL PRIVILEGES ON databasename.* 指令
之後重新啟動mysql後 Server load 突然變很重,
Drupal現在就成線site off-line的狀態
後來我要從command-line連線mysql時
出現以下錯誤:
ERROR 2002 (HY000): Can't connect to local MySQL server through socket
'/var/run/mysqld/mysqld.sock' (2)
telnet 發現 mysql 3306 沒有運作
然後/var/run/mysqld也是空的
上網爬文後發現別人的解決方法
1.重灌mysql,可是我怕一重灌mysql,Drupal會整個掛掉
2.有人說/var/lib/mysql站太多容量了,要減肥
可是這裡面都是資料庫的資料表,若要備份該如何下手?
還是能在/var/run/mysqld 底下新增mysqld.sock的檔案呢?
麻煩各位了
-------------------------------
+ set -e
+ basename /etc/init.d/mysql
+ INITSCRIPT=mysql
+ JOB=mysql
+ [ mysql = upstart-job ]
+ [ -z start ]
+ COMMAND=start
+ shift
+ [ -z ]
+ ECHO=echo
+ echo Rather than invoking init scripts through /etc/init.d, use the service(8)
Rather than invoking init scripts through /etc/init.d, use the service(8)
+ echo utility, e.g. service mysql start
utility, e.g. service mysql start
+ echo
+ echo Since the script you are attempting to invoke has been converted to an
Since the script you are attempting to invoke has been converted to an
+ echo Upstart job, you may also use the start(8) utility, e.g. start mysql
Upstart job, you may also use the start(8) utility, e.g. start mysql
+ awk /[0-9]$/ { print $NF }
+ status mysql
+ PID=
+ [ -z ]
+ [ start = stop ]
+ [ -n ]
+ [ -z ]
+ [ start = restart ]
+ start mysql
start: Job failed to start
--
Tags:
Linux
All Comments
By Mia
at 2013-05-27T16:26
at 2013-05-27T16:26
By Thomas
at 2013-05-28T05:33
at 2013-05-28T05:33
By Oliver
at 2013-05-30T07:49
at 2013-05-30T07:49
By James
at 2013-06-03T16:50
at 2013-06-03T16:50
By Anthony
at 2013-06-04T09:59
at 2013-06-04T09:59
By Valerie
at 2013-06-04T15:30
at 2013-06-04T15:30
By Una
at 2013-06-09T02:30
at 2013-06-09T02:30
By James
at 2013-06-11T10:37
at 2013-06-11T10:37
By Susan
at 2013-06-12T20:29
at 2013-06-12T20:29
By Kristin
at 2013-06-14T10:37
at 2013-06-14T10:37
By Faithe
at 2013-06-16T01:30
at 2013-06-16T01:30
By Elvira
at 2013-06-18T09:16
at 2013-06-18T09:16
By Hazel
at 2013-06-20T16:28
at 2013-06-20T16:28
By Elma
at 2013-06-23T00:28
at 2013-06-23T00:28
By William
at 2013-06-25T07:16
at 2013-06-25T07:16
By Emma
at 2013-06-29T10:31
at 2013-06-29T10:31
By Xanthe
at 2013-07-03T05:35
at 2013-07-03T05:35
By Ophelia
at 2013-07-03T13:21
at 2013-07-03T13:21
By Heather
at 2013-07-04T18:44
at 2013-07-04T18:44
By Anthony
at 2013-07-06T11:19
at 2013-07-06T11:19
By Regina
at 2013-07-07T14:00
at 2013-07-07T14:00
By Skylar Davis
at 2013-07-08T09:34
at 2013-07-08T09:34
By Skylar Davis
at 2013-07-09T15:07
at 2013-07-09T15:07
By Sandy
at 2013-07-12T21:29
at 2013-07-12T21:29
By Ida
at 2013-07-14T01:56
at 2013-07-14T01:56
By Carol
at 2013-07-16T21:56
at 2013-07-16T21:56
Related Posts
lxde的repository?
By Charlie
at 2013-05-23T21:14
at 2013-05-23T21:14
新手的幾個問題...
By Dorothy
at 2013-05-23T20:31
at 2013-05-23T20:31
有關登錄檔不能記錄資訊?
By Emma
at 2013-05-23T15:53
at 2013-05-23T15:53
編譯核心問題
By Heather
at 2013-05-23T15:20
at 2013-05-23T15:20
yum 升級套件問題
By Selena
at 2013-05-22T17:57
at 2013-05-22T17:57