How to Import a MySQL Database Dump or Backup
Now that we have covered how to make a backup of your MySQL database, we can go over how to import the backup. To do this, you can use the
cat thebackupfile.sql | mysql -D mydatabase -u myusername -p
This command uses cat to write your database to stdout and then pipes it into mysql. You'll need to have your database created first, but you can do that with:
mysql -u myusername -p -e "create database mydatabase"