mysqldump - how to not specify "use [db]"

[Red Squirrel]

Is there a way I can make it so mysqldump wont put the

"use [dbname]" in the dump?

I'm writing a bash script for quickly taking a snap shot of a DB, but I want to be able to easily restore that snapshot to another DB without having to edit the file.

I was unable to find info in the man page.

If this is not possible is there another way to take a snap shot and copy it to another DB name?

 

[Crusty]

cat dumpfile | sed 's/use olddbname/use newdbname/' | mysql <whatever>

 

[Red Squirrel]

I forgot about using sed, that's an option too. Just added a sed line to delete anything that matches use '.*'; and it works.