easiest way to go from one db to another

[Anon]

I need to be able to allow a user to click a button/link and have the contents of one database dumped into another, then the original database get wiped out with a "delete from table" SQL statement.

Has anyone ever tried this before?

[Anon]

I stand corrected, I need the contents of a TABLE dumped into another TABLE... not a db...