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]
