I want to create an embedded MySQL database for running tests, but I'm not sure how to do it.

• How do I initialize the database?
• How do I run my create table statements?

I'm using Perl, so it needs to be done with a language and not a couple of commands.