求军哥来看看

jalena

服务器是centos6.4 x64的版本。安装的是lnmp1.0 mysql版本5.5.28-log
现在导出数据库报错，求军哥看看。。。

这是备份命令

for db in `mysql -u111 -p1111 -B -N -e 'SHOW DATABASES' | xargs`; do
    (mysqldump -u1111 -p1111 ${db} --skip-lock-tables | gzip -9 - > ${db}.sql.gz)
done

报错是这个

mysqldump: Couldn't execute 'SELECT /*!40001 SQL_NO_CACHE */ * FROM `INNODB_BUFFER_PAGE`': Lost connection to MySQL server during query (2013)
mysqldump: Got error: 2002: Can't connect to local MySQL server through socket '/tmp/mysql.sock' (111) when trying to connect
mysqldump: Got error: 2002: Can't connect to local MySQL server through socket '/tmp/mysql.sock' (111) when trying to connect
mysqldump: Got error: 2002: Can't connect to local MySQL server through socket '/tmp/mysql.sock' (2) when trying to connect
mysqldump: Got error: 2002: Can't connect to local MySQL server through socket '/tmp/mysql.sock' (2) when trying to connect

[ 本帖最后由 jalena 于 2013-9-1 20:00 编辑 ]

licess

mysql可能挂掉或没启动

jalena

启动了的，现在主要是要写个备份的脚本。总是在导出数据的地方报错，不过现在好了，我把几个默认库给排除了就ok。

1. #!/bin/bash
   
2. 
   
3. # Author: Jalena
   
4. # Website: http://jalena.bcsytv.com/archives/1099
   
5. 
   
6. # 常规定义
   
7. MYSQL_USER="user"
   
8. MYSQL_PASS="pass"
   
9. DROPBOX_DIR="/backup/$(date +%Y-%m-%d)"
   
10. BACK_DIR="backup"
    
11. 
    
12. # 备份网站数据目录
    
13. NGINX_DATA="/usr/local/nginx/conf/vhost"
    
14. BACKUP_BLOG="/home/wwwroot/blog"
    
15. BACKUP_DEFAULT="/home/wwwroot/default"
    
16. BACKUP_JOOMLA="/home/wwwroot/joomla"
    
17. 
    
18. # 定义备份文件名
    
19. mysql_DATA=mysql_$(date +"%Y%m%d").tar.gz
    
20. www_BLOG=blog_$(date +%Y%m%d).tar.gz
    
21. www_DEFAULT=deafult_$(date +%Y%m%d).tar.gz
    
22. www_joomla=joomla_$(date +%Y%m%d).tar.gz
    
23. nginx_config=nginx_$(date +%Y%m%d).tar.gz
    
24. 
    
25. # 定义Dropbox远程文件夹（3天删除一次）
    
26. Old_DROPBOX_DIR=/backup/$(date -d -3day +%Y-%m-%d)
    
27. 
    
28. # 判断本地备份目录，不存在则创建
    
29. if [ ! -d $BACK_DIR ] ;
    
30.   then
    
31.    mkdir -p "$BACK_DIR"
    
32. fi
    
33. 
    
34. # 进入备份目录
    
35. cd $BACK_DIR
    
36. 
    
37. # 备份所有数据库
    
38. # 导出需要备份的数据库，清除不需要备份的库
    
39. mysql -uroot -pprivacy -B -N -e 'SHOW DATABASES' > databases.db
    
40. sed -i '/performance_schema/d' databases.db
    
41. sed -i '/information_schema/d' databases.db
    
42. sed -i '/mysql/d' databases.db
    
43. 
    
44. for db in $(cat databases.db)
    
45. do
    
46.    mysqldump -u$MYSQL_USER -p$MYSQL_PASS ${db} | gzip -9 - > ${db}.sql.gz
    
47. done
    
48. 
    
49. # 打包数据库
    
50. tar -zcvf $mysql_DATA *.sql.gz
    
51. 
    
52. # 打包本地网站数据
    
53. tar -zcvf $www_BLOG $BACKUP_BLOG
    
54. tar -zcvf $www_DEFAULT $BACKUP_DEFAULT
    
55. 
    
56. # 打包Nginx配置文件
    
57. tar -zcvf $nginx_config $NGINX_DATA/*.conf
    
58. 
    
59. # upload
    
60. cd ~
    
61. ./dropbox_uploader.sh upload /$BACK_DIR/$mysql_DATA $DROPBOX_DIR/$mysql_DATA
    
62. ./dropbox_uploader.sh upload /$BACK_DIR/$www_BLOG $DROPBOX_DIR/$www_BLOG
    
63. ./dropbox_uploader.sh upload /$BACK_DIR/$www_DEFAULT $DROPBOX_DIR/$www_DEFAULT
    
64. ./dropbox_uploader.sh upload /$BACK_DIR/$nginx_DATA $DROPBOX_DIR/$nginx_DATA
    
65. 
    
66. # Delete all local backup
    
67. rm -rf $BACK_DIR
    
68. 
    
69. # Delete the file 3  days ago
    
70. ./dropbox_uploader.sh delete $Old_DROPBOX_DIR/
    
71. 
    
72. # DropBox info
    
73. ./dropbox_uploader.sh info
    
74. 
    
75. exit 0

复制代码