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
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>
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 -u -p
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 -u -p -h
--add-drop-table > test.sql
regards,
Praveen
--- John Kelly <[EMAIL PROTECTED]> wrote:
> Hi, I am trying to use mysqldump to dump the
> structure of a single
