Re: Moving MySQL database from one machine to another and remotely accessing dbs?
-----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).
>
> 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.
- --
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)
iD8DBQFG5adyS9HxQb37XmcRAhQjAJ9SdSkJspdvXvbNFfSySNxW55tUhACgwK5a
dp4B2NPDGoaYJjTHVZaqKzQ=
=3NPQ
-----END PGP SIGNATURE-----
Reply to: