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 <mwilliams@stripped> 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/mysql?unsub=1
>
>
