At 10:52 AM 07/04/2001 , you wrote:
>I think you can check this link
>
>http://www.mysql.com/documentation/mysql/bychapter/
That's what I'm reading, and quoted from below, and what gave rise to the
questions in this email.
And, all of it deals with 3.23.29--unless you are referring to all the
changes in appendix "F. MySQL change history" that would take some REAL
time to sort through.
>----- Original Message -----
>From: "Joe Taraba" <[EMAIL PROTECTED]>
>To: <[EMAIL PROTECTED]>
>Sent: Wednesday, July 04, 2001 1:47 PM
>Subject: Replication, update log, mysqldump???
>
>
> > Hi;
> >
> > I'm trying to learn MySQL, having some difficulties understanding backup
> > strategies.
> >
> > mysql Ver 9.38 Distrib 3.22.32, for pc-linux-gnu (i686)
> >
> > Where is the documentation (besides man pages) for mysql Ver 3.22.32
> >
> > According to the the 3.23.29 online docs it appears that there are four
> > ways to go:
> >
> > Replication
> > update log
> > mysqldump
> > mysqlhotcopy script
> >
> > The mysqlhotcopy script is apparently not available for my version so I
> > manually backed-up (copied) all the *.frm, *.MYD, and *.MYI files for each
> > database, so I know the usefulness of that approach--sort'a.
> >
> > I tried mysqldump on an existing database, and then tried to load it back
> > and got several types of errors.
> >
> > 1. Table exists errors, so I deleted all the *.frm, *.MYD, and *.MYI files
> > for that database.
> > 2. I tried to load the dumpfile again and got errors about duplicate keys.
> >
> > This database is not visible to anyone right now, so there were no
> > activities going on. This is an exact copy of a functioning customer
>database.
> >
> > I haven't tried using the update log, nor do I fully understand it's
> > usefulness. The online docs say not to use it for versions later than
> > <quote> Now that master-slave internal replication is available starting
>in
> > Version 3.23.15, using the update log to implement replications is not
> > recommended. See section 11 Replication in MySQL. </quote>
> >
> > Replication, I guess is not available for my version either. I glanced
> > briefly at the docs on Replication--it looks pretty nifty.
> >
> > So I guess there are actually two questions here:
> >
> > 1. Why the errors from mysqldump (reload) from an apparently perfectly
>good
> > database?
> >
> > 2. Should I upgrade my version of MySQL and follow the Replication
>procedures?
> >
> > A ton of thanks from anyone not taking a holiday (USA) today.
> >
> > Joe
> >
> >
> > ---------------------------------------------------------------------
> > Before posting, please check:
> > http://www.mysql.com/manual.php (the manual)
> > http://lists.mysql.com/ (the list archive)
> >
> > To request this thread, e-mail <[EMAIL PROTECTED]>
> > To unsubscribe, e-mail
><[EMAIL PROTECTED]>
> > Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
> >
> >
>
>
>---------------------------------------------------------------------
>Before posting, please check:
> http://www.mysql.com/manual.php (the manual)
> http://lists.mysql.com/ (the list archive)
>
>To request this thread, e-mail <[EMAIL PROTECTED]>
>To unsubscribe, e-mail <[EMAIL PROTECTED]>
>Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
---------------------------------------------------------------------
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/ (the list archive)
To request this thread, e-mail <[EMAIL PROTECTED]>
To unsubscribe, e-mail <[EMAIL PROTECTED]>
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
