On Thursday, Oct 3, 2002, at 20:41 America/Phoenix, John Kelly wrote:
> Hi, I am trying to use mysqldump to dump the structure of a single > database > and want the output to make create table commands that include the IF > NOT > EXISTS switch so that when the file is imported into an existing > database it > does not write over tables with the same name. Does anyone know if > this is > possible with mysqldump and if so what option achieves this? Thanks. add the option -n or --no-create-db. This will add IF NOT CREATE to the sql. -- Clayburn W. Juniel, III -- Effective Software Solutions Phone: (602) 326-7707 Mobile: (602)326-7707 Email: [EMAIL PROTECTED] http://EffectiveSoftwareSolutions.com -- --------------------------------------------------------------------- Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php