[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