Backup
mysqldump -u dbuser -p db_name | gzip -9 > db.sql.gz
Restore
New DB: gunzip < db.sql.gz | mysql -u dbuser -p dbname Existed DB: mysqlimport -u dbuser -p dbname db.sql
// Sorry this version is not in compressed
Backup
mysqldump -u dbuser -p db_name | gzip -9 > db.sql.gz
Restore
New DB: gunzip < db.sql.gz | mysql -u dbuser -p dbname Existed DB: mysqlimport -u dbuser -p dbname db.sql
// Sorry this version is not in compressed