[H-GEN] remote backup of server

Arjen Lentz arjen at mysql.com
Tue Jan 28 17:50:12 EST 2003


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

Hi,

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.
Either the mysqldump tool to dump the grants/structure/data to an SQL
file and scp that, or use a script like mysqlhotcopy to do the proper
locking and flushing to copy the actual data files. Those files can then
be successfully copied using scp.

Regards,
Arjen.
-- 
Purchase Training, Support, Licenses @ https://order.mysql.com/?marl
Brisbane  24-28 Feb 2003: MySQL/PHP, see www.mysql.com/training
Melbourne 24-28 Mar 2003: Using & Managing MySQL
   __  ___     ___ ____  __
  /  |/  /_ __/ __/ __ \/ /    Mr. Arjen G. Lentz <arjen at mysql.com>
 / /|_/ / // /\ \/ /_/ / /__   MySQL AB, Technical Writer, Trainer
/_/  /_/\_, /___/\___\_\___/   Brisbane, QLD Australia
       <___/   www.mysql.com

--
* 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/



More information about the General mailing list