Restore a MySQL Database Backup from the .sql File

11 May

I’ve written a bit on backing up data and have been asked how to restore data to MySQL.

Pretty simple, assuming you have your backup file, just run:

“C:\Program Files\MySQL\MySQL Server 5.0\bin\mysql.exe” -uUSERNAME -pPASSWORD DATABASENAME < “c:\BACKUPFILENAME.sql”

On the box running MySQL. Easy.