Re: Moving MySQL database from one machine to another and remotely accessing dbs?
Ron Johnson(ron.l.johnson@cox.net) is reported to have said:
> -----BEGIN PGP SIGNED MESSAGE-----
> Hash: SHA1
>
> On 09/10/07 11:27, Wayne Topa wrote:
> > Ron Johnson(ron.l.johnson@cox.net) is reported to have said:
> >> -----BEGIN PGP SIGNED MESSAGE-----
> >> Hash: SHA1
> >>
> >> On 09/10/07 10:50, ArcticFox wrote:
> >>> On Sep 10, 2007, at 10:42 AM, Wayne Topa wrote:
> >>>
> >>>> Ron Johnson(ron.l.johnson@cox.net) is reported to have said:
> >>>>> On 09/10/07 10:00, Wayne Topa wrote:
> >>>>> [snip]
> >>>>>>
> >>>>>> I just used it, on Mysql 5 to transfer all my databases to a new
> >>>>>> server and it's great. Just be sure no one is using the DB when you
> >>>>>> run mysqldump.
> >>>>> Why not?
> >>>>>
> >>>> Because my guru, Paul DuBois, said so.
> >>>>
> >>>> WT
> >>>>
> >>> And there's a chance that you'll end up with missing/corrupt or
> >>> incomplete data being moved.
> >> But isn't MySQL5 supposed to be Enterprise Ready? Any "enterprise"
> >> RDBMS worthy of the appellation can do hot backups *and* PITR
> >> (point-in-time recovery).
I took the above as an invitation to start yet another long thread
about how much better postgresql was. As I did not want to get you
started on that, again, I just ignored it. :-)
> > Yes, I think it is, but the OP said he was using 4.1 and thats what my
> > DuBois Mysql 4.1 book and Articfox said. It might corrupt files 'if'
> > there were read/writes while running mysqldump.
>
> Hmmm. I mentioned v5 because you said that you use it.
Checking my reference (you know who), I do not find the caution about
mysqldump in his books on MySQL 5.0. I have never stopped anyone from
using the server when I used mysqldump and never had a problem anyway.
Thanks for you interest though. :-)
Wayne
--
Air conditioned environment - Do NOT open Windows!
_______________________________________________________
Reply to: