MySQL – Backup and Restore MySQL Database

Backup

Classic backup

Compressed backup

Restore

Classic restore

Tip : To import faster, disabled foreign key checks