List:General Discussion« Previous MessageNext Message »
From:mwilliams Date:February 16 2006 7:50pm
Subject:(mysqldump) Serial output. . .?
View as plain text  
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
Thread
(mysqldump) Serial output. . .?mwilliams16 Feb
  • RE: (mysqldump) Serial output. . .?Dathan V. Pattishall16 Feb
  • Re: (mysqldump) Serial output. . .?sheeri kritzer20 Feb
RE: (mysqldump) Serial output. . .?mwilliams16 Feb
  • RE: (mysqldump) Serial output. . .?SGreen16 Feb
RE: (mysqldump) Serial output. . .?mwilliams16 Feb
RE: (mysqldump) Serial output. . .?SST - Adelaide)16 Feb
RE: (mysqldump) Serial output. . .?Dirk Bremer16 Feb
RE: (mysqldump) Serial output. . .?mwilliams17 Feb
Re: (mysqldump) Serial output. . .?mwilliams20 Feb
  • Re: (mysqldump) Serial output. . .?SGreen21 Feb
Re: (mysqldump) Serial output. . .?mwilliams21 Feb
  • Re: (mysqldump) Serial output. . .?SGreen21 Feb
Re: (mysqldump) Serial output. . .?mwilliams21 Feb
  • Re: (mysqldump) Serial output. . .?SGreen21 Feb
Re: (mysqldump) Serial output. . .?mwilliams21 Feb