Failed Sector on HDD - MySQL Error?

Hi,

didnt find a better topic so ... Im confronted with HDD crashes in the past, but I got everything working due to my backups ... It was not easy but it did work ...

Now a Server of a friend is getting in a bad trouble.

This in the syslog:

Quote

Sep 20 15:53:39 srv07 kernel: [6814528.668905] ata4.00: exception Emask 0x0 SAct 0x1 SErr 0x0 action 0x0
Sep 20 15:53:39 srv07 kernel: [6814528.668942] ata4.00: irq_stat 0x40000008
Sep 20 15:53:39 srv07 kernel: [6814528.668963] ata4.00: failed command: READ FPDMA QUEUED
Sep 20 15:53:39 srv07 kernel: [6814528.668988] ata4.00: cmd 60/08:00:08:63:e4/00:00:48:00:00/40 tag 0 ncq 4096 in
Sep 20 15:53:39 srv07 kernel: [6814528.668989] res 41/40:08:08:63:e4/00:00:48:00:00/00 Emask 0x409 (media error) <F>
Sep 20 15:53:39 srv07 kernel: [6814528.670411] ata4.00: status: { DRDY ERR }
Sep 20 15:53:39 srv07 kernel: [6814528.670431] ata4.00: error: { UNC }
Sep 20 15:53:39 srv07 kernel: [6814528.688432] ata4.00: configured for UDMA/133
Sep 20 15:53:39 srv07 kernel: [6814528.688470] sd 3:0:0:0: [sdb] Unhandled sense code
Sep 20 15:53:39 srv07 kernel: [6814528.688496] sd 3:0:0:0: [sdb] Result: hostbyte=DID_OK driverbyte=DRIVER_SENSE
Sep 20 15:53:39 srv07 kernel: [6814528.688545] sd 3:0:0:0: [sdb] Sense Key : Medium Error [current] [descriptor]
Sep 20 15:53:39 srv07 kernel: [6814528.688578] Descriptor sense data with sense descriptors (in hex):
Sep 20 15:53:39 srv07 kernel: [6814528.688598] 72 03 11 04 00 00 00 0c 00 0a 80 00 00 00 00 00
Sep 20 15:53:39 srv07 kernel: [6814528.688626] 48 e4 63 08
Sep 20 15:53:39 srv07 kernel: [6814528.688644] sd 3:0:0:0: [sdb] Add. Sense: Unrecovered read error - auto reallocate failed
Sep 20 15:53:39 srv07 kernel: [6814528.688678] sd 3:0:0:0: [sdb] CDB: Read(10): 28 00 48 e4 63 08 00 00 08 00
Sep 20 15:53:39 srv07 kernel: [6814528.688706] end_request: I/O error, dev sdb, sector 1222927112
Sep 20 15:53:39 srv07 kernel: [6814528.688741] ata4: EH complete

Display More

Cant dump all databased - tried to copy /var/lib/mysq/ I got:

Quote

cp: reading `/var/lib/mysql/ibdata1': Input/output error
cp: failed to extend `/home/backups/mysql/ibdata1': Input/output error

Quote

Sep 20 15:21:41 srv07 mysqld: 140920 15:21:41 InnoDB: Operating system error number 0 in a file operation.
Sep 20 15:21:41 srv07 mysqld: InnoDB: Error number 0 means 'Success'.
Sep 20 15:21:41 srv07 mysqld: InnoDB: Some operating system error numbers are described at
Sep 20 15:21:41 srv07 mysqld: InnoDB: http://dev.mysql.com/doc/refma…g-system-error-codes.html
Sep 20 15:21:41 srv07 mysqld: InnoDB: File name ./ibdata1
Sep 20 15:21:41 srv07 mysqld: InnoDB: File operation call: 'Linux aio'.
Sep 20 15:21:41 srv07 mysqld: InnoDB: Cannot continue operation.

Display More

So can someone help my backing up the mysql database so I can replace the fault hdd? All web files, config files and so one are save ... :x

Its only a small workstation with one hdd ... the export is not possible:

mysqldump: Error 2013: Lost connection to MySQL server during query when dumping table `domain_traffic` at row: 371550

Its backing up over 1,9GB of Databases but at this (imscp database) the mysql server every time says goodbye ... and the syslog is spammed full of kernel errors