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:mwilliams@stripped]
:~> Sent: Thursday, February 16, 2006 11:50 AM
:~> To: mysql@stripped
:~> 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=1
:~> mysql@stripped
