Hendri wrote:
how about just hard copy /var/lib/myql/ directory
and then restore them as ordinary copy file scheme ?
it works for me, and with no something strange
You can do that, but you need to shut down MySQL first. If you don't,
one of these times you'll run into trouble.
--
---John Holmes..
3 09:42:44 +0200
Subject: [PHP-DB] Re: backing up MySQL
use the following script
##
#!/bin/sh
# Create the temporary copy directory
mkdir /tmp/mysql
# Get the list of MySQL Databases & copy them
for var in `find /var/lib/mysql/ -type d | \
sed -e "s/\/var\/lib\/mysql\///&qu
use the following script
##
#!/bin/sh
# Create the temporary copy directory
mkdir /tmp/mysql
# Get the list of MySQL Databases & copy them
for var in `find /var/lib/mysql/ -type d | \
sed -e "s/\/var\/lib\/mysql\///"`; do
mysqlhotcopy -q "$var" /tmp/mysql
done
# Tar/gzip data
date=
