Re: backing up 55GB myisam database

[Benny Pei]

I got like "synatx error" during a restore. (Sorry I cannot be more specific because the log was removed) It was a mysqldump piped to a compress. It worked fine with a small database.

Here is the piece of code that does the mysqldump.

--- cut here ---
comp() {
if [ -p $1 ]
then
rm $1
fi
mknod $1 p
compress < $1 > ${DUMPDIR}/$1.Z &
sleep 1
}


for dbname in $MYSQL_DB_LIST
do
echo "Starting dumping $dbname at " `date` >> ${LOGFILE}
comp ${dbname}_${d}.dmp

$MYSQLDUMP --opt --all -uroot ${dbname} > ${dbname}_${d}.dmp

if [ -p ${dbname}_${d}.dmp ]
then
rm -f ${dbname}_${d}.dmp
fi

echo "Finished dumping $dbname at " `date` >> ${LOGFILE}
echo "" >> ${LOGFILE}
done
--- cut here ---