From: mwilliams
Date: February 16 2006 7:50pm
Subject: (mysqldump)  Serial output. . .?
List-Archive: http://lists.mysql.com/mysql/194937
Message-Id: <200602161350.AA683147474@mgreg.com>
MIME-Version: 1.0
Content-Type: text/plain; charset=us-ascii

All,

I'm looking to output every piece of data from the database line by line.  Is there any 
methody by which 'mysqldump' can output the following?:


use  MY_DATABASE;

CREATE TABLE IF NOT EXISTS MY_TABLE;

ALTER IGNORE TABLE MY_TABLE ADD MY_COLUMN [properties]
ALTER IGNORE TABLE MY_TABLE ADD MY_COLUMN [properties]
ALTER IGNORE TABLE MY_TABLE ADD MY_COLUMN [properties]
ALTER IGNORE TABLE MY_TABLE ADD MY_COLUMN [properties]
ALTER IGNORE TABLE MY_TABLE ADD MY_COLUMN [properties]
ALTER IGNORE TABLE MY_TABLE ADD MY_COLUMN [properties]
ALTER IGNORE TABLE MY_TABLE ADD MY_COLUMN [properties]

INSERT IGNORE . . . . 
INSERT IGNORE . . . . 
INSERT IGNORE . . . . 
INSERT IGNORE . . . . 
INSERT IGNORE . . . . 
INSERT IGNORE . . . . 
INSERT IGNORE . . . . 



The most important of the features above are the ability to CREATE a table only if it doesn't 
exist (I never want to drop because the same script will be used for syncing) and the ability to 
have 'mysqldump' be "smart" and output ALTER IGNORE statements.  Any asistance would be 
greatly appreciated.

Regards,
Michael