So I have backed all my databases up with this:

mysqldump -u root -p --all-databases > all.sql

My question is how to restore all.sql to mysql?

link|improve this question

feedback

1 Answer

up vote 3 down vote accepted

If you've included the CREATE TABLE lines,

mysql -uroot -p < all.sql
link|improve this answer
Thanks! It worked. – kavoir.com Sep 5 '09 at 6:19
feedback

Your Answer

 
or
required, but never shown

Not the answer you're looking for? Browse other questions tagged or ask your own question.