mysqldump 시 "Can't open file: './DB/table.frm' (errno: 24) when using LOCK TABLE"

mysqldump --opt --default-char=utf8 -u user -p DB > backup.sqlmysqldump 시 Can't open file: './DB/table.frm' (errno: 24) when using LOCK TABLE라는 메시지가 나오면--lock-all-table 옵션추가 mysqldump --opt --default-char=utf8 --lock-all-table -u user -p DB > backup.sql

  • format_list_bulleted Database
  • · 2012. 5. 29.
  • textsms

mysql 백업스케쥴링

$vi back.sh #!/bin/sh time=`date '+%Y%m%d%H%M'` etc="etc" cd / backup_path ="/backup_path/" cd $backup_path mysqldump -u[userid] -p[userpwd] [dbname] > "$time.sql" --default-character-set=latin1 --set-charset find /backup_path/* -mtime +5 -exec rm -f {} '; $chmod 700 back.sh $crontab -e 00 05 * * * /path/backup.sh (새벽 5시 정각) * --default-character-set=latin1 --set-charset 캐릭터셋 지정

  • format_list_bulleted OS
  • · 2009. 11. 17.
  • textsms