To restore database from backed up .sql file
mysql -u [username] -p [database] < yourbackup.sql