This shows you the differences between two versions of the page.
Both sides previous revisionPrevious revision | Next revisionBoth sides next revision | ||
database:mysql [2019/04/02 13:52] – [Master-Master Replication] tmade | database:mysql [2019/04/02 17:53] – [Backup] tmade | ||
---|---|---|---|
Line 94: | Line 94: | ||
mysqldump --user=${USERNAME} --password --host=${DBHOST} --port=${PORT} --quick --triggers --routines --events --add-drop-database --single-transaction --master-data --hex-blob --databases $candidates | gzip > $BACKUPDIR/ | mysqldump --user=${USERNAME} --password --host=${DBHOST} --port=${PORT} --quick --triggers --routines --events --add-drop-database --single-transaction --master-data --hex-blob --databases $candidates | gzip > $BACKUPDIR/ | ||
</ | </ | ||
+ | |||
+ | Check also: | ||
+ | |||
+ | https:// | ||
==== Restore ==== | ==== Restore ==== |