| View previous topic :: View next topic |
| Author |
Message |
Sakkath
Apprentice
Joined: 06 Nov 2005
Posts: 198
Location: Pawtucket, RI
|
 Posted: Fri May 11, 2007 12:07 pm Post subject: MySQL Backup Problems |
 |
|
I have a backup script that someone from #gentoo gave me; it was working fine but now I am getting e-mails saying:
| Code: | | mysqldump: Got error: 1016: Can't open file: './xklark_ipb/tarball_contacts.frm' (errno: 24) when using LOCK TABLES |
There was another error too but I accidentally deleted the e-mail.
_________________
The person who makes no mistakes does not usually make anything.
Please add [SOLVED] to the subject of your original post when you feel that your problem is resolved. |
|
| Back to top |
|
 |
blackcollar
n00b
Joined: 23 Jul 2003
Posts: 39
Location: /usa/idaho
|
|
| Back to top |
|
|
Sakkath
Apprentice
Joined: 06 Nov 2005
Posts: 198
Location: Pawtucket, RI
|
| Posted: Sat May 12, 2007 2:18 am Post subject: |
|
|
Is that 330 per database?
| Code: | +-------------------+-------+
| Variable_name | Value |
+-------------------+-------+
| innodb_open_files | 300 |
| open_files_limit | 1024 |
+-------------------+-------+
2 rows in set (0.00 sec)
|
_________________
The person who makes no mistakes does not usually make anything.
Please add [SOLVED] to the subject of your original post when you feel that your problem is resolved. |
|
| Back to top |
|
|
blackcollar
n00b
Joined: 23 Jul 2003
Posts: 39
Location: /usa/idaho
|
| Posted: Sat May 12, 2007 3:58 am Post subject: |
|
|
As I read the documents I linked to, I believe it's a limit on the total number of files opened by the script. So adjusting that parameter within the script should allow at least twice as many open files (Windows, 8x for Linux).
I'm not an expert at SQL, just good with search engines.
MCM
_________________
mcm |
|
| Back to top |
|
|
Sakkath
Apprentice
Joined: 06 Nov 2005
Posts: 198
Location: Pawtucket, RI
|
| Posted: Sat May 12, 2007 1:14 pm Post subject: |
|
|
Oh, I'm sorry you did the work for me, I probably would have but I was very tired last night and fell asleep. Thank you.
By script do you mean 'mysqldump' or my backup script?
I read the links you gave me and I'm going to try raising that variable right now. Thank you again.
_________________
The person who makes no mistakes does not usually make anything.
Please add [SOLVED] to the subject of your original post when you feel that your problem is resolved. |
|
| Back to top |
|
|
Sakkath
Apprentice
Joined: 06 Nov 2005
Posts: 198
Location: Pawtucket, RI
|
| Posted: Sat May 12, 2007 1:22 pm Post subject: |
|
|
Okay, it's changed; now I'll wait for my cronjob to kick in and update you guys later whether or not it erred or not. Thanks a lot! I'm sorry that I didn't think to Google this first, I thought it might be a weird filesystem error, corruption, etc.
_________________
The person who makes no mistakes does not usually make anything.
Please add [SOLVED] to the subject of your original post when you feel that your problem is resolved. |
|
| Back to top |
|
|
|
Networking & Security
