因为根目录磁盘满了,我移动数据和软件造成mysql启动不了,查原因mysql.sock不在了...

今天刚接手新项目的服务器,不知道以前谁搭建的

因为要备份数据库,但是发现空间不足

/根目录满的,然后我移动软件和文件

造成 mysql启动不了

1
2
root@localhost ~]# /data/mysql/bin/mysqldump  --databases star -uroot -p123456 > /home/star.sql
mysqldump: Couldn 't execute ' show fields from `c_help`': Got error  28  from storage engine ( 1030 )
1
2
3
4
5
6
[root@localhost ~]# df -lh
Filesystem            Size  Used Avail Use% Mounted on
/dev/sda3              2 .0G   2 .0G      0  100 % /
/dev/sda5             246G   29G  205G   13 % /data
/dev/sda1              99M   12M   82M   13 % /boot
tmpfs                  7 .9G      0   7 .9G    0 % /dev/shm

wKioL1Mvx6DQZB4sAADaQeuA0bk478.jpg

1
2
3
4
5
6
7
8
发现空间不足,也不知道谁搭建的服务器,坑死我了
root@localhost share]# mv * /data/ceshi/share/
[root@localhost share]# df -Th
Filesystem    Type    Size  Used Avail Use% Mounted on
/dev/sda3     ext3     2 .0G   1 .5G  382M   80 % /
/dev/sda5     ext3    246G   24G  209G   11 % /data
/dev/sda1     ext3     99M   12M   82M   13 % /boot
tmpfs        tmpfs     7 .9G      0   7 .9G    0 % /dev/shm

mysql.sock不在了

1
2
3
4
5
[root@localhost tmp]# locate mysql.sock
[root@localhost tmp]# /data/mysql/
bin/        data/        include /    lib/        libexec/    log/        mysql-test/ share/      sql-bench/
[root@localhost tmp]# /data/mysql/bin/mysql start
ERROR  2002  (HY000): Can 't connect to local MySQL server through socket ' /tmp/mysql.sock' ( 2 )

没有进程

1
2
[root@localhost tmp] # killall mysqld
mysqld: no process killed


1
2
3
[root@localhost tmp]# ps -aux | grep mysqld
Warning: bad syntax, perhaps a bogus  '-' ? See /usr/share/doc/procps- 3.2 . 7 /FAQ
root      22246   0.0   0.0   61196    720  pts/ 2     S+    13 : 14    0 : 00  grep mysqld
1
2
3
[root@localhost tmp]# more /etc/my.cnf|grep sock
socket=/ var /lib/mysql/mysql.sock
[root@localhost tmp]# cd / var /lib/mysql/mysql.s

太奇葩了这问题

查看报错日志


1
2
3
4
5
6
7
8
9
10
11
140104   3 : 00 : 02  [ERROR] /data/mysql/libexec/mysqld: Sort aborted
140105   3 : 00 : 02  [ERROR] /data/mysql/libexec/mysqld: Sort aborted
140106   3 : 00 : 01  [ERROR] /data/mysql/libexec/mysqld: Sort aborted
140107   3 : 00 : 01  [ERROR] /data/mysql/libexec/mysqld: Sort aborted
140324  12 : 09 : 26  [Note] /data/mysql/libexec/mysqld: Normal shutdown
140324  12 : 09 : 26  [Note] Slave I/O thread killed  while  reading event
140324  12 : 09 : 26  [Note] Slave I/O thread exiting, read up to log  'mysql-bin.000013' , position  54495054
140324  12 : 09 : 26  [Note] Error reading relay log event: slave SQL thread was killed
140324  12 : 09 : 44   InnoDB: Starting shutdown...
140324  12 : 09 : 46   InnoDB: Shutdown completed; log sequence number  0  1573472989
140324  12 : 09 : 46  [Note] /data/mysql/libexec/mysqld: Shutdown complete


1
2
3
4
[root@localhost tmp]# ps -ef | grep mysqld
root      22330  20131   0  13 : 24  pts/ 2     00 : 00 : 00  grep mysqld
[root@localhost tmp]# ps -ef | grep mysql
root      22332  20131   0  13 : 24  pts/ 2     00 : 00 : 00  grep mysql

发现

1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
[root@localhost mysql]# ./
bin/        data/        include /    lib/        libexec/    log/        mysql-test/ share/      sql-bench/
[root@localhost mysql]# ./bin/
comp_err                    mysqlbinlog                 mysql_find_rows             mysqltestmanagerc
innochecksum                mysqlbug                    mysql_fix_extensions        mysqltestmanager-pwgen
msql2mysql                  mysqlcheck                  mysql_fix_privilege_tables  mysql_tzinfo_to_sql
myisamchk                   mysql_client_test           mysqlhotcopy                mysql_upgrade
myisam_ftdump               mysql_config                mysqlimport                 mysql_upgrade_shell
myisamlog                   mysql_convert_table_format  mysql_install_db            mysql_waitpid
myisampack                  mysqld_multi                mysql_secure_installation   mysql_zap
my_print_defaults           mysqld_safe                 mysql_setpermission         perror
mysql                       mysqldump                   mysqlshow                   replace
mysqlaccess                 mysqldumpslow               mysql_tableinfo             resolveip
mysqladmin                  mysql_explain_log           mysqltest                   resolve_stack_dump
[root@localhost mysql]# ./bin/mysqld_safe &
[ 1 22367
[root@localhost mysql]# Starting mysqld daemon  with  databases from /data/mysql/data
[root@localhost mysql]# /data/mysql/bin/mysql -uroot -p123456
Welcome to the MySQL monitor.  Commands end  with  ; or \g.
Your MySQL connection id  is  15
Server version:  5.0 . 88 -log Source distribution
No entry  for  terminal type  "xterm" ;
using dumb terminal settings.
Type  'help;'  or  '\h'  for  help. Type  '\c'  to clear the current input statement.
mysql> Ctrl-C -- exit!
Aborted
[root@localhost mysql]# cd /tmp/
.ICE-unix/  mysql.sock
[root@localhost mysql]# cd /tmp/

终于进去了

wKiom1MvxFvhMEOLAAL8j_S0MjM796.jpg


终于备份好了,为了以后不必要的麻烦,添加service管理

1
2
3
4
[root@localhost data] # cp /data/mysql/share/mysql/mysql.server /etc/init.d/mysql
[root@localhost data] # cd /etc/init.d/
[root@localhost init.d] # chkconfig --add mysql
[root@localhost init.d] # chkconfig mysql on

这样方便多了

1
2
3
4
5
6
7
8
9
10
11
[root@localhost init.d]# service mysql stop
MySQL manager or server PID file could not be found!       [FAILED]
[root@localhost init.d]# service mysql start
Starting MySQL.                                            [  OK  ]
[root@localhost init.d]# /data/mysql/bin/mysql -uroot -p
Welcome to the MySQL monitor.  Commands end  with  ; or \g.
Your MySQL connection id  is  21
Server version:  5.0 . 88 -log Source distribution
No entry  for  terminal type  "xterm" ;
using dumb terminal settings.
Type  'help;'  or  '\h'  for  help. Type  '\c'  to clear the current input statement.

wKiom1Mvx9ag8Yn-AAFs-U_671Y744.jpg


终于解决了!



本文转自 cs312779641 51CTO博客,原文链接:http://blog.51cto.com/chenhao6/1382231

  • 0
    点赞
  • 0
    评论
  • 0
    收藏
  • 一键三连
    一键三连
  • 扫一扫,分享海报

表情包
插入表情
评论将由博主筛选后显示,对所有人可见 | 还能输入1000个字符
©️2021 CSDN 皮肤主题: 大白 设计师:CSDN官方博客 返回首页
实付
使用余额支付
点击重新获取
扫码支付
钱包余额 0

抵扣说明:

1.余额是钱包充值的虚拟货币,按照1:1的比例进行支付金额的抵扣。
2.余额无法直接购买下载,可以购买VIP、C币套餐、付费专栏及课程。

余额充值