Skip to content

Instantly share code, notes, and snippets.

@xianx
xianx / backup
Last active March 3, 2018 00:04
RSync
sudo rsync -vrazh --progress root@69.64.65.11:/backup/ /ebs/containers/percona-tdba-d/backup
@xianx
xianx / Basic MySQL Backup.md
Last active March 3, 2021 21:21
MySQL Command

** Backup a single database with verbose output**

mysqldump -u USERNAME -pPASSWORD -v DATABASENAME >  DATABASENAME.sql

** Restore single database with verbose output**

mysql -u USERNAME -pPASSWORD -v DATABASENAME < DATABASENAME.sql