Travis Tran

Travis Tran

BREAKTHROUGH the limits

Backup MySQL database with mysqldump

Option 1: mysqldump an entire mysql instance

Everything written in one file: table structures, indexes, triggers, stored procedures, users, encrypted passwords. Other mysqldump options can also export different styles of INSERT commands, log file and position coordinates from binary logs, database creation options, partial data (–where option), and so forth.

mysqldump -h... -u... -p... --hex-blob --routines --triggers --all-databases | gzip > MySQLData.sql.gz

Continue reading
X
Welcome to travistran.me
Welcome to TravisBot
wpChatIcon