-----BEGIN PGP SIGNED MESSAGE----- Hash: SHA1 On 09/10/07 15:59, Wayne Topa wrote: > Ron Johnson([EMAIL PROTECTED]) is reported to have said: >> -----BEGIN PGP SIGNED MESSAGE----- >> Hash: SHA1 >> >> On 09/10/07 11:27, Wayne Topa wrote: >>> Ron Johnson([EMAIL PROTECTED]) 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([EMAIL PROTECTED]) 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. :-)
Bashing MySQL is a pleasure all it's own. >>> 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. Good to know. > Thanks for you interest though. :-) - -- Ron Johnson, Jr. Jefferson LA USA Give a man a fish, and he eats for a day. Hit him with a fish, and he goes away for good! -----BEGIN PGP SIGNATURE----- Version: GnuPG v1.4.6 (GNU/Linux) iD8DBQFG5bNyS9HxQb37XmcRAkuBAKDMRTiJizQe55SAJa5ucTeyeXCzTwCcDy3T lZzWMjIRSPZgtbiXA23WgSU= =ncQM -----END PGP SIGNATURE----- -- To UNSUBSCRIBE, email to [EMAIL PROTECTED] with a subject of "unsubscribe". Trouble? Contact [EMAIL PROTECTED]
