how to restore database in mysql?

Question

I am using sqlyog in office. But at my home I have mysql gui. now how can I backup a database from sqlyog and restore it mysql gui? any idea please

by `mysql gui`, you mean mysql workbench? – John Woo Feb 24 '13 at 09:04 — John Woo, Feb 24 '13 at 09:04

score 3 · Accepted Answer · answered Feb 24 '13 at 09:06

3

Why over complicate things?

Create backup

mysqldump -u <user> -p<password> <database> > backup.sql

Restore

mysql -u <user> -p<password> <database> < backup.sql

answered Feb 24 '13 at 09:06

Rob

1 Answers1