Using CFML to Backup (duplicate) tables into the same orSecond MDB

[bigbrain28]

I need help with some CF code that will target the users tables with in the DB
and make copies of them, I think the best idea is to copy them into a seperate
DB. I have a master DB that services MANY different customers, all have tables
with the same name, but each table includes their "name" as part of the table
name (ei, SMITHemail, and JONESemail are the same format and my templates get
data from the correct table based on the "name" part).

Part of my control panel is (hoping to) give the admin power to BACK-UP their
tables before they make changes to their data, or RESTORE from previous
back-ups if they screw up. I need to be able to do this on a table by table
basis. I have used CF to back-up/copy entire DB's before but never isolated
tables. I have a set list of about 12 tables (per client) and would like to
present the user with the ability to back-up/restore any/all of their tables.

[Dan Bracuk]

For the record, there are probably more efficient ways to accomplish your goal,
but, if this is what you want to do,

Make sure the databases can select from each other.

Then write your queries something like this: note that you are backing up db1
into db2


delete from db2.tablename

insert into db2.tablename
select * from db1.tablename