[H-GEN] remote backup of server

[Jason Parker-Burlingham]

[ Humbug *General* list - semi-serious discussions about Humbug and     ]
[ Unix-related topics. Posts from non-subscribed addresses will vanish. ]

Arjen Lentz <arjen at mysql.com> writes:

> On Wed, 2003-01-29 at 03:05, Jason Parker-Burlingham wrote:
> > If they're other, important data files (say MySQL databases or
> > something) [...]
> Just in case there is a MySQL db there:
> A file backup of MySQL databases is generally flawed because of caching.

Yeah, brain fart---I was just reading the PostgreSQL docs on backups
today, before responding to Sandra.

> Either the mysqldump tool to dump the grants/structure/data to an SQL
> file and scp that,

Excellent advice, and what I would usually do.
-- 
``I may have agreed to something involving a goat.''  -- CJ

--
* This is list (humbug) general handled by majordomo at lists.humbug.org.au .
* Postings to this list are only accepted from subscribed addresses of
* lists 'general' or 'general-post'.  See http://www.humbug.org.au/