Backup and retrieve multiple databases

crycry

After backing up multiple databases with the following command:
mysqldump --all-databases > bkp.sql
I wonder how to retrieve them using something like:
mysql database < bkp.sql

I know it works for simple databases, but is it possible for multiple (I hope so), and what would be the correct syntax ?

Thank you

cry-cry

Anon

To dump them all out:

mysqldump --all-databases --add-drop-tables --extended-insert > my_bkp.sql

my_bkp.sql will include statements to re-create and use each database in turn.

To recreate:

mysql < my_bkp.sql (there's no need to tell mysql which database)

CHeers
Justin