[HOW TO] backup and restore the mysql database

Hello,

Do you want to backup/ restore the MySQL database?

Please follows this article:

1. Backup
mysqldump -u username -p -–all-databases > file.sql

2. Backup and compress
mysqldump -u username -p -–all-databases | gzip > file.sql.gz

3. Restore
mysql -u username -p < file.sql

Thank you for reading this article, please a comment if you are interested.

Tiến Phan - R0039

Knowledge is Endless

Sharing for Success