ok great, thanks barney, appreciate it
>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: >> ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| 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:306718 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4