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 of ...

Also, I use MariaDB instead of MySQL in my examples, because that's what I have installed, and because I like the improvements MariaDB includes in both the command-line client and in the database ...