mysqldump takes a table or database and "dumps" it -- current schema, current data. You won't get alter tables.
What you want is something that will show all the alter statements. You can run something like this on unix: tail -f binlog* | grep ALTER > alter.sql and then the alter.sql text file will always have the alter statements. The binary log captures the alter statements. Or, you could create an 'alteration' table with a text field and timestamp, and have a trigger copy the alter statement to the alteration table. But mysqldump is the wrong solution, because it only dumps "now". hope this helps! -Sheeri On 2/16/06, mwilliams <[EMAIL PROTECTED]> wrote: > 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/[EMAIL PROTECTED] > > -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
