You have to manually do it. mysqldump just dumps out tables and/or databases to a SQL script. Once mysqldump is done, there's no way to tell that the SQL file was generated by mysqldump, hand coding, or arbitrary automated process X - it's just a SQL file.
When you load the script, you need to make sure you load it into the right thing, which in your case sounds like an empty database. So it's up to you to ensure you have an empty database. I suppose you could prefix your script with the database drop/create commands after mysqldump is done with it, but it's simple enough to just do that before loading the script. cheers, barneyb On Tue, Jun 3, 2008 at 10:14 AM, Richard White <[EMAIL PROTECTED]> wrote: > Hi Barney, > > thanks for the reply, are these options in the mysqldump or do you mean > physically do this? > > if they are options in mysqldump can you provide an example please > > thanks again > >>Prefix the load with a delete database;create database pair, so you >>always start blank. >> >>cheers, >>barneyb >> >>On Tue, Jun 3, 2008 at 9:48 AM, Richard White <[EMAIL PROTECTED]> wrote: >>> > > ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| 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:306713 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
