I can’t seem to restore a large database backup (db.SQL) with the MySQL Administrator. It hangs at random points. Is there another way that I can restore my database?
Here’s how you can restore from a command prompt. I’d recommend doing the restore this way for big MySQL restores
- create a blank database with the same name
- open a dos prompt (cmd) and navigate to the mysql\bin directory
- run mysql -u root -p testdb < filename
- enter password when prompted