Restore Mysql dump. Share on Facebook Share Share on TwitterTweet Share on LinkedIn Share mysql -u root -pdbaft schema_name < dumpfile For example: mysql -u root -pdbaft dce2 < /backup/dce2_backup_20150814.sql Share on Facebook Share Share on TwitterTweet Share on LinkedIn Share Related posts: Show all the users of mysql Give grant of the database to other systems. Create Mysql user with all privileges.