Sheeri, Thanks very much for the reply. However, that is not what I'm looking for. I don't want the tables that *have been* altered. I want CREATE TABLE statements output in the ALTER TABLE format for re-creation on another system (clean or otherwise).
Regards, Michael ---------- Original Message ---------------------------------- From: "sheeri kritzer" <[EMAIL PROTECTED]> Date: Mon, 20 Feb 2006 12:22:55 -0500 >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]
