mysqldump 1016
今天检查网站数据备份，发现有问题：# cd /discuz/backup/
# ll
total 936740
-rw-r--r-- 1 root root 937 Mar 19 01:00 db_20200319.sql
-rw-r--r-- 1 root root 937 Mar 20 01:00 db_20200320.sql
-rw-r--r-- 1 root root 937 Mar 21 01:00 db_20200321.sql
-rw-r--r-- 1 root root 937 Mar 22 01:00 db_20200322.sql
-rw-r--r-- 1 root root 937 Mar 23 01:00 db_20200323.sql
-rw-r--r-- 1 root root 937 Mar 24 01:00 db_20200324.sql
-rw-r--r-- 1 root root 937 Mar 25 01:00 db_20200325.sql
-rw-r--r-- 1 root root 115633871 Mar 19 00:00 dz_20200319.tar.gz
-rw-r--r-- 1 root root 120904249 Mar 20 00:00 dz_20200320.tar.gz
-rw-r--r-- 1 root root 119014389 Mar 21 00:00 dz_20200321.tar.gz
-rw-r--r-- 1 root root 119032640 Mar 22 00:00 dz_20200322.tar.gz
-rw-r--r-- 1 root root 118955664 Mar 23 00:00 dz_20200323.tar.gz
-rw-r--r-- 1 root root 119143789 Mar 24 00:00 dz_20200324.tar.gz
-rw-r--r-- 1 root root 119029666 Mar 25 00:00 dz_20200325.tar.gz
-rw-r--r-- 1 root root 119060206 Mar 26 00:00 dz_20200326.tar.gz于是手动执行了数据库备份脚本，发下报错如下：
# sh bk_db.sh
mysqldump: Got error: 1016: "Can't open file: './ultrax/pre_myrepeats.frm' (errno: 24)" when using LOCK TABLES
# cat bk_db.sh
mysqldump -uroot -pGodba_4316 --database ultrax >/discuz/backup/db_`date +%Y%m%d`.sql于是，修改脚本，添加--lock-tables=false,手动执行成功：# mysqldump -uroot -pGodba_4316 --database ultrax >/discuz/backup/db_`date +%Y%m%d`.sql --lock-tables=false
# cd /discuz/backup/
# ll
total 936740
-rw-r--r-- 1 root root 937 Mar 19 01:00 db_20200319.sql
-rw-r--r-- 1 root root 937 Mar 20 01:00 db_20200320.sql
-rw-r--r-- 1 root root 937 Mar 21 01:00 db_20200321.sql
-rw-r--r-- 1 root root 937 Mar 22 01:00 db_20200322.sql
-rw-r--r-- 1 root root 937 Mar 23 01:00 db_20200323.sql
-rw-r--r-- 1 root root 937 Mar 24 01:00 db_20200324.sql
-rw-r--r-- 1 root root 937 Mar 25 01:00 db_20200325.sql
-rw-r--r-- 1 root root 8406611 Mar 26 17:00 db_20200326.sql
-rw-r--r-- 1 root root 115633871 Mar 19 00:00 dz_20200319.tar.gz
-rw-r--r-- 1 root root 120904249 Mar 20 00:00 dz_20200320.tar.gz
-rw-r--r-- 1 root root 119014389 Mar 21 00:00 dz_20200321.tar.gz
-rw-r--r-- 1 root root 119032640 Mar 22 00:00 dz_20200322.tar.gz
-rw-r--r-- 1 root root 118955664 Mar 23 00:00 dz_20200323.tar.gz
-rw-r--r-- 1 root root 119143789 Mar 24 00:00 dz_20200324.tar.gz
-rw-r--r-- 1 root root 119029666 Mar 25 00:00 dz_20200325.tar.gz
-rw-r--r-- 1 root root 119060206 Mar 26 00:00 dz_20200326.tar.gz注意：--lock-tables参数，是指mysqldump备份时，锁定备份得所有表。
页:
[1]