Restoring from a MySQL dump is simple: you just pipe its contents into the mysql command itself, again using an account with appropriate permissions. Here's a full example of backup and restore ...

The command-line client is nice too. Also, I use MariaDB instead of MySQL in my examples ... The most common SQL statements are selects, inserts, updates and deletes. As a computer language, SQL is ...