My suggestion: Modify the source of mysqldump yourself. After all, it is open source. Make sure you adhere to any and all licensing requirements and copyright notices and you will keep yourself out of any legal trouble.
For the vast majority of users, replication is a better solution than what you propose so the changes you propose haven't been discussed at all. If others would like to have your changes, perhaps you would consider synching your mods with the main development tree and releasing them to the community? Shawn Green Database Administrator Unimin Corporation - Spruce Pine "mwilliams" <[EMAIL PROTECTED]> wrote on 02/16/2006 03:22:51 PM: > 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" <[EMAIL PROTECTED]> > 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:[EMAIL PROTECTED] > >:~> Sent: Thursday, February 16, 2006 11:50 AM > >:~> To: mysql@lists.mysql.com > >:~> 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=dathan- > >:~> [EMAIL PROTECTED] > > > > > > > > -- > MySQL General Mailing List > For list archives: http://lists.mysql.com/mysql > To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED] >
