hi, we have been doing mysqldump of our database and realise that it is not doing exactly what we want it to do
it is dumping out all the data and if we load into another database then it loads the data in and creates the tables it needs in order to enter the database. however it does not delete any unneccasy tables that doesnt exist in the dump we want to have a process where if we load in a dump it creates an exact replica of all tables and data etc... - not just the data is there a way to do this? thanks ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;192386516;25150098;k Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:306708 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4

