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" <[EMAIL PROTECTED]> To: [EMAIL PROTECTED] Date: Thu, 11 Sep 2003 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\///"`; 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