Thanks Dathan,
But I'm more concerned with ALTER than anything. As I said, I basically want to be able
to
output field, type, etc. by row so that *if* the receiving DB needs to add a field it can
do so
without having to nuke the table with all data in it just to add all fields again with a
CREATE
statement. The final purpose is for the sake of data syncronization, not replication.
Regards,
Michael
---------- Original Message ----------------------------------
From: "Dathan V. Pattishall" <dathan-mysql@stripped>
Date: Thu, 16 Feb 2006 12:06:40 -0800
> 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
>
>
>
