LINEで送る
Pocket

– dump

$ mysqldump -u user -p -h localhost --skip-lock-tables --single-transaction -v -P 1234 db-name table-name | gzip > ~/backup/$(date "+%Y%m%d")/bk.$(date "+%Y%m%d").gz

– restore

$ mysql -u user -p -P 1234 db-name table-name -h localhost  < ~/backup/$(date "+%Y%m%d")/bk.$(date "+%Y%m%d").gz