The restore command will take considerably longer than the backup command, so please make sure to give it time. And that's all there is to backing up and restoring a database for your website.

Whether you're running a LAMP stack on Ubuntu or CentOS, you need to back up your MySQL databases. Learn how to do this with the help of the mysqldump command.