Restore a MySQL Database
June 6, 2008
To restore a MySQL database with a backed up *.sql file, enter the following from a command line prompt after moving into the directory in which the *.sql file is in:
mysql -u root -p databasename < backupfile.sql
That’s it..
Advertisement