Thanks Dathan, But I'm more concerned with ALTER than anything. As I said, I basically want to be able to output field, type, etc. by row so that *if* the receiving DB needs to add a field it can do so without having to nuke the table with all data in it just to add all fields again with a CREATE statement. The final purpose is for the sake of data syncronization, not replication.
Regards, Michael ---------- Original Message ---------------------------------- From: "Dathan V. Pattishall" <[EMAIL PROTECTED]> Date: Thu, 16 Feb 2006 12:06:40 -0800 > Mysqldump can do all the following except dump the ALTER commands, it will >log the create statement of the table as the table exists. Mysql doesn't >keep a record of what, when, how a table was altered only the final result. > >Look at the mysqldump options for the stuff you want to do by typing >mysqldump --help > > >:~> -----Original Message----- >:~> From: mwilliams [mailto:[EMAIL PROTECTED] >:~> Sent: Thursday, February 16, 2006 11:50 AM >:~> To: mysql@lists.mysql.com >:~> Subject: (mysqldump) Serial output. . .? >:~> >:~> 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 >:~> >:~> -- >:~> MySQL General Mailing List >:~> For list archives: http://lists.mysql.com/mysql >:~> To unsubscribe: http://lists.mysql.com/mysql?unsub=dathan- >:~> [EMAIL PROTECTED] > > > -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
