Subject: An error occurred during the backup.

S

seachen

Verified User
Joined
Feb 3, 2007
Messages
491
Error while backing up database mamakteh_mamak
mysqldump error output: Warning: option 'max_allowed_packet': unsigned value 4294967296 adjusted to 2147483648
mysqldump: Got error: 29: File './mamakteh_mamak/wp_comments.MYD' not found (Errcode: 24) when using LOCK TABLES

mysqldump error output: Warning: option 'max_allowed_packet': unsigned value 4294967296 adjusted to 2147483648

mysqldump error output: Warning: option 'max_allowed_packet': unsigned value 4294967296 adjusted to 2147483648
Click to expand...

May i know what is this error?

I try to backup database, but failed.
 
try a repair table via ssh or phpmyadmin before run again the backup.

if you are a hoster try to backup via ssh aswell, if u are a client, contact ur hosting company if the repair doesnt solve.

regards
 
You can repair in directadmin now via the mysql section.
 
Its not a fault in the database I have had this for a while with extra large databases

here is fault
...................................................................................................................................................................
mysqldump: Got error: 29: File './databasename/tablename.MYD' not found (Errcode: 24) when using LOCK TABLES

The best way to get to the bottom of the error is to find out what it means:

$ perror 24
OS error code 24: Too many open files

There’s two ways to fix the problem. First, if you find that you only hit the limit during mysqldumps and never during normal database operation, just add --single-transaction to your mysqldump command line options. This will cause mysql to keep only one table open at a time.

However, if this happens while backups aren’t running, you may want to increase the open_files_limit in your MySQL configuration file. By default, the variable is set to 1,024 open files.
.........................................................................................................................................................................


How To Fix In directadmin is

edit


/etc/my.cnf

go to line

[mysqldump]
quick
max_allowed_packet = 16M

[mysql]



CHANGE TO

[mysqldump]
quick
max_allowed_packet = 16M
single-transaction
[mysql]


YOU ADD THE single-transaction IN then it will backup I am just checking the restore on a second server to see if it restores ok or any other problems

:)
 
Last edited:
You must log in or register to reply here.
Back
Top