Re: backing up MySQL
| From: | nabil | Date: | Thu, 11 Sep 2003 07:42:44 +0000 |
| Subject: | Re: backing up MySQL | ||
| References: | 1 | Groups: | php.db |
| Request: | Send a blank email to php-db+get-30461@lists.php.net to get a copy of this message | ||
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=
date -I
tar czf /tmp/mysql-$date.tar.gz -C /tmp/ mysql/
#############################
or use :
mysqldump command