MySQL Datenbank sichern
Datenbank sichern
mysqldump --default-character-set=utf8mb4 -h localhost -uroot -ppassword db_name | gzip > db_name.sql.gz
Datenbank wiederherstellen
mysql -h localhost -u root -ppassword db_name < db_name.sql
Knowledgebase von Gerald Allerstorfer
mysqldump --default-character-set=utf8mb4 -h localhost -uroot -ppassword db_name | gzip > db_name.sql.gz
mysql -h localhost -u root -ppassword db_name < db_name.sql