Re: Moving MySQL database from one machine to another and remotely accessing dbs?

[Ron Johnson <ron.l.johnson@cox.net>]

-----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).

- --
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)

iD8DBQFG5WtPS9HxQb37XmcRAq54AJ9sLElYdiDddl2owUicTlBAQAC/rACgwVrN
Cjdm6VKWABxZAcKx0U3Q59g=
=Ahy9
-----END PGP SIGNATURE-----