[chef] how best to create and fill a database in an idempotent fashion?

[Dmitry V'yal < >]

Hello list,

I'm writing a receipt which creates a mysql database for my mail server.
I wrote a sql script and call it like this:

***

root_pass = node[:mysql][:server_root_password]

scheme_path = "/tmp/scheme.sql"

template scheme_path do
  mode "600"
  source "mysql-scheme.sql.erb"
end

execute "mysql-scheme" do
  command "cat #{scheme_path} | mysql -u root -p#{root_pass}"
end

file scheme_path do
  action :delete
end

***

Of course, this worked only the first time, the next chef run mysql 
complained the database already exists.

How do you handle similar situations? What're the pros and cons of 
various approaches?

Thanks,
Dmitry