MySQL Administrator SQL database restore problem

Archived Topics
1

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?

2

Here’s how you can restore from a command prompt. I’d recommend doing the restore this way for big MySQL restores

  1. create a blank database with the same name
  2. open a dos prompt (cmd) and navigate to the mysql\bin directory
  3. run mysql -u root -p testdb < filename
  4. enter password when prompted