Restore MySQL database from a backup file
There are many reasons you would want to restore a database from a backup file… But you should also test this on a test server just to make sure that your database backups are working correctly. Here's the syntax:
mysql -h hostname -u username -pthepassword databasename < dumpfile.sql
Here's an example:
mysql -h localhost -u root -p72aDufi8 db01 < thedumpfile.sql
The Geek is the founder of How-To Geek and a geek enthusiast. When he's not coming up with great how-to articles, he's probably writing at his personal blog. This article was written on 09/11/06 and tagged with: MySQL
