TASIOMIND.DEV — OPERATIONAL▸▸▸FULL STACK DEVELOPER @ GWQ SERVICEPLUS AG▸▸▸FOUNDER — K8SGPT.AI▸▸▸OPEN SOURCE: ACTIVE▸▸▸DISTRIBUTED SYSTEMS / KUBERNETES / AI▸▸▸RUST + GO + PYTHON▸▸▸FIELD TESTED / STATUS — NOMINAL▸▸▸LOCATION: EUROPE/BERLIN▸▸▸TASIOMIND.DEV — OPERATIONAL▸▸▸FULL STACK DEVELOPER @ GWQ SERVICEPLUS AG▸▸▸FOUNDER — K8SGPT.AI▸▸▸OPEN SOURCE: ACTIVE▸▸▸DISTRIBUTED SYSTEMS / KUBERNETES / AI▸▸▸RUST + GO + PYTHON▸▸▸FIELD TESTED / STATUS — NOMINAL▸▸▸LOCATION: EUROPE/BERLIN▸▸▸
← databases

Backing up and Restoring Databases

February 20, 2015

Export (mysqldump)

Ein DB:

code
mysqldump -u USER -p -h HOST DB_NAME > backup.sql

Mehrere DBs:

code
mysqldump -u USER -p --databases db1 db2 | gzip > backup.sql.gz

Alle DBs:

code
mysqldump -u USER -p --all-databases | gzip > all.sql.gz

Ohne Lock (InnoDB)

code
mysqldump -u USER -p --single-transaction --quick --lock-tables=false DB_NAME > backup.sql

Restore

code
mysql -u USER -p DB_NAME < backup.sql

Gzip:

code
gunzip -c backup.sql.gz | mysql -u USER -p DB_NAME

Remote Copy

code
scp backup.sql.gz user@host:/path/

Pipe (Server -> Server)

code
mysqldump -u USER -p -h SRC DB | mysql -u USER -p -h DST DB

Link