Backup failure.
I have a script that backs up the OpManager database every night. It was working until now, only thing that has changed was upgraded from 7xxx to 7200.
The backup script is:
#!/bin/sh
date=`date -I`
for i in /opt/OpManager/mysql/data/*/; do
dbname=`basename $i`
/usr/bin/mysqldump -u root -P 13306 --socket=/opt/OpManager/mysql/mysql.socket $dbname > /mnt/backup/mysql/lnxapp/$dbname-OP-$date.sql
done
I get this error now:
mysqldump: Got error: 1017: Can't find file: './OpManagerDB/STRINGDATA7_22_2008.frm' (errno: 24) when using LOCK TABLES
From some searches on the net, they suggested adding the line allow-open-files=4096 in the config file, but OpManager doesn't really use one supposedly.
Anyone know why this is happening all of a sudden?
The backup script is:
#!/bin/sh
date=`date -I`
for i in /opt/OpManager/mysql/data/*/; do
dbname=`basename $i`
/usr/bin/mysqldump -u root -P 13306 --socket=/opt/OpManager/mysql/mysql.socket $dbname > /mnt/backup/mysql/lnxapp/$dbname-OP-$date.sql
done
I get this error now:
mysqldump: Got error: 1017: Can't find file: './OpManagerDB/STRINGDATA7_22_2008.frm' (errno: 24) when using LOCK TABLES
From some searches on the net, they suggested adding the line allow-open-files=4096 in the config file, but OpManager doesn't really use one supposedly.
Anyone know why this is happening all of a sudden?