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 Hendri, Hobbyst Coder -----Original Message----- From: "nabil" <nabil.attar@aws-syria.com> To: php-db@lists.php.net Date: Thu, 11 Sep 2003 09:42:44 +0200 Subject: 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\///"`; 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 -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
