Hi,
Do u mean when u take a dump you need to add before
each table drop table if exists
then here is the command.
mysqldump -uusername -p -hhostname
--add-drop-table databasename tablename test.sql
regards,
Praveen
--- John Kelly [EMAIL PROTECTED] wrote:
Hi, I am trying to use mysqldump to
Kelly [EMAIL PROTECTED]; [EMAIL PROTECTED]
Sent: Friday, October 04, 2002 5:19 AM
Subject: Re: Create table if not exists from mysqldump?
Hi,
Do u mean when u take a dump you need to add before
each table drop table if exists
then here is the command.
mysqldump -uusername -p -hhostname
--add
John,
Friday, October 04, 2002, 6:41:46 AM, you wrote:
JK Hi, I am trying to use mysqldump to dump the structure of a single database
JK and want the output to make create table commands that include the IF NOT
JK EXISTS switch so that when the file is imported into an existing database it
JK
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
Begin forwarded message:
From: Clayburn W. Juniel, III [EMAIL PROTECTED]
Date: Fri Oct 4, 2002 10:24:06 America/Phoenix
To: Clayburn W. Juniel, III [EMAIL PROTECTED]
Subject: Re: Create table if not exists from mysqldump?
On Friday, Oct 4, 2002, at 08:48 America/Phoenix, Clayburn W. Juniel
Thanks for all the responses on how to import a dump file that will not
write over existing tables and not stop with an error on existing tables -
in other words just add missing tables. As Victoria pointed out, there is no
option in mysqldump to add the appropriate create table option [IF NOT
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