mysqldump to Restore and Backup MySQL database

When you need to handle MySQL databases, it is useful to have a tool which lets you create backup files and also restore them properly; this can be achieved by using mysql and mysqldump commands in the command line. To be able to use them, you have to make sure the user you will use has the privileges to manage the database you are working with, we will be using root MySQL user to go through the examples.

Continue reading