Re: Moving MySQL database from one machine to another and remotely accessing dbs?
-----BEGIN PGP SIGNED MESSAGE-----
Hash: SHA1
On 09/10/07 15:59, 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 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. :-)
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-----
Reply to: