g "devil's advocate". If you plan works well,
>it may be something many of us in the community may be interested in
>trying for some of our data issues, if you can share. We understand if you
>can't.
>
>Yours,
>
>Shawn Green
>Database Administrator
>Uni
nd each have a different way of handling what
>they call "replication conflicts". Those arise from scenarios very similar
>to what I described above (changes occur to the same record on separate
>servers between synchronization cycles). How do you plan to handle those?
>
log won't fail because they will be applied to the correct schema
>on the slave.
>
>Again, my sincere apologies for missing the difference in the purpose of
>what you are trying to do.
>
>Respectfully,
>
>Shawn Green
>Database Administrator
>Unimin Corporation - S
ments.
>
>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
>
dump program, why not
>massage its output to your specifications.
>
>Dirk Bremer - Senior Systems Engineer - ESS/AMS - NISC Lake St. Louis MO
>- USA Central Time Zone
>636-755-2652 fax 636-755-2503
>
>[EMAIL PROTECTED]
>www.nisc.coop
>
>> -Original Message-
Shawn,
I'd actually considered such, but I was hoping for it to already be present.
I'm currently on a
tight deadline to finish a project I'm working on so devoting time to getting
'mysqldump'
stable enough to then propagate across corporate servers in such a short period
is not very
likely
ou 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. . .?
>:~>
>:~> A
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 M
Hi all,
Having a bit of mysqldump trouble again. I've looked over the documentation
(again) and can't
seem to find the flag to make 'mysqldump' output "CREATE TABLE IF NOT
EXISTS". Any ideas?
Keep in mind, I never want to 'DROP IF EXISTS'. . .I simply want to CREATE if
it doesn't exist s