AH AH !! Génial !! J’ai même pu récupérer mon ancienne base de donnée.
je te colle les logs quand même au cas ou tu vois quelque chose de pas clean ^^.
May 15 14:56:00 server-rpi kernel: [ 9274.680148] sd 7:0:0:0: [sdb] Mode Sense: 43 00 00 00
May 15 14:56:00 server-rpi kernel: [ 9274.691194] sd 7:0:0:0: [sdb] Write cache: disabled, read cache: enabled, doesn't support DPO or FUA
May 15 14:56:00 server-rpi kernel: [ 9274.761566] sdb: sdb1
May 15 14:56:00 server-rpi kernel: [ 9274.805129] sd 7:0:0:0: [sdb] Attached SCSI removable disk
May 15 14:56:39 server-rpi kernel: [ 9313.905571] FAT-fs (sdb1): utf8 is not a recommended IO charset for FAT filesystems, filesystem will be case sensitive!
May 15 14:56:39 server-rpi kernel: [ 9313.944505] SELinux: initialized (dev sdb1, type vfat), uses genfs_contexts
May 15 14:56:48 server-rpi mysqld: 140515 14:56:48 [Note] /usr/sbin/mysqld: Normal shutdown
May 15 14:56:48 server-rpi mysqld:
May 15 14:56:48 server-rpi mysqld: 140515 14:56:48 [Note] Event Scheduler: Purging the queue. 0 events
May 15 14:56:48 server-rpi mysqld: 140515 14:56:48 InnoDB: Starting shutdown...
May 15 14:56:49 server-rpi mysqld: 140515 14:56:49 InnoDB: Shutdown completed; log sequence number 1595685
May 15 14:56:49 server-rpi mysqld: 140515 14:56:49 [Note] /usr/sbin/mysqld: Shutdown complete
May 15 14:56:49 server-rpi mysqld:
May 15 14:56:49 server-rpi mysqld_safe: mysqld from pid file /var/run/mysqld/mysqld.pid ended
May 15 14:56:59 server-rpi mysqld_safe: Starting mysqld daemon with databases from /var/lib/mysql
May 15 14:56:59 server-rpi mysqld: 140515 14:56:59 [Warning] Using unique option prefix key_buffer instead of key_buffer_size is deprecated and will be removed in a future release. Please use the full name instead.
May 15 14:56:59 server-rpi mysqld: 140515 14:56:59 [Warning] Using unique option prefix myisam-recover instead of myisam-recover-options is deprecated and will be removed in a future release. Please use the full name instead.
May 15 14:56:59 server-rpi mysqld: 140515 14:56:59 [Note] Plugin 'FEDERATED' is disabled.
May 15 14:56:59 server-rpi mysqld: 140515 14:56:59 InnoDB: The InnoDB memory heap is disabled
May 15 14:56:59 server-rpi mysqld: 140515 14:56:59 InnoDB: Mutexes and rw_locks use GCC atomic builtins
May 15 14:56:59 server-rpi mysqld: 140515 14:56:59 InnoDB: Compressed tables use zlib 1.2.7
May 15 14:56:59 server-rpi mysqld: 140515 14:56:59 InnoDB: Using Linux native AIO
May 15 14:56:59 server-rpi kernel: [ 9333.194265] type=1400 audit(1400158619.172:101): avc: denied { write } for pid=30753 comm="mysqld" name="tmp" dev=sda1 ino=262145 scontext=unconfined_u:system_r:mysqld_t:s0-s0:c0.c1023 tcontext=unconfined_u:object_r:root_t:s0 tclass=dir
May 15 14:56:59 server-rpi kernel: [ 9333.194303] type=1400 audit(1400158619.172:102): avc: denied { add_name } for pid=30753 comm="mysqld" name="ibA4WOJn" scontext=unconfined_u:system_r:mysqld_t:s0-s0:c0.c1023 tcontext=unconfined_u:object_r:root_t:s0 tclass=dir
May 15 14:56:59 server-rpi kernel: [ 9333.194383] type=1400 audit(1400158619.172:103): avc: denied { create } for pid=30753 comm="mysqld" name="ibA4WOJn" scontext=unconfined_u:system_r:mysqld_t:s0-s0:c0.c1023 tcontext=unconfined_u:object_r:root_t:s0 tclass=file
May 15 14:56:59 server-rpi kernel: [ 9333.194472] type=1400 audit(1400158619.172:104): avc: denied { read write open } for pid=30753 comm="mysqld" name="ibA4WOJn" dev=sda1 ino=262148 scontext=unconfined_u:system_r:mysqld_t:s0-s0:c0.c1023 tcontext=unconfined_u:object_r:root_t:s0 tclass=file
May 15 14:56:59 server-rpi kernel: [ 9333.194533] type=1400 audit(1400158619.172:105): avc: denied { remove_name } for pid=30753 comm="mysqld" name="ibA4WOJn" dev=sda1 ino=262148 scontext=unconfined_u:system_r:mysqld_t:s0-s0:c0.c1023 tcontext=unconfined_u:object_r:root_t:s0 tclass=dir
May 15 14:56:59 server-rpi kernel: [ 9333.194569] type=1400 audit(1400158619.172:106): avc: denied { unlink } for pid=30753 comm="mysqld" name="ibA4WOJn" dev=sda1 ino=262148 scontext=unconfined_u:system_r:mysqld_t:s0-s0:c0.c1023 tcontext=unconfined_u:object_r:root_t:s0 tclass=file
May 15 14:56:59 server-rpi kernel: [ 9333.194629] type=1400 audit(1400158619.172:107): avc: denied { getattr } for pid=30753 comm="mysqld" path=2F746D702F69624134574F4A6E202864656C6574656429 dev=sda1 ino=262148 scontext=unconfined_u:system_r:mysqld_t:s0-s0:c0.c1023 tcontext=unconfined_u:object_r:root_t:s0 tclass=file
May 15 14:56:59 server-rpi mysqld: 140515 14:56:59 InnoDB: Initializing buffer pool, size = 128.0M
May 15 14:56:59 server-rpi mysqld: 140515 14:56:59 InnoDB: Completed initialization of buffer pool
May 15 14:56:59 server-rpi mysqld: 140515 14:56:59 InnoDB: highest supported file format is Barracuda.
May 15 14:56:59 server-rpi mysqld: 140515 14:56:59 InnoDB: Waiting for the background threads to start
May 15 14:57:00 server-rpi mysqld: 140515 14:57:00 InnoDB: 5.5.35 started; log sequence number 1595685
May 15 14:57:00 server-rpi mysqld: 140515 14:57:00 [Note] Server hostname (bind-address): '127.0.0.1'; port: 3306
May 15 14:57:00 server-rpi mysqld: 140515 14:57:00 [Note] - '127.0.0.1' resolves to '127.0.0.1';
May 15 14:57:00 server-rpi mysqld: 140515 14:57:00 [Note] Server socket created on IP: '127.0.0.1'.
May 15 14:57:00 server-rpi mysqld: 140515 14:57:00 [Note] Event Scheduler: Loaded 0 events
May 15 14:57:00 server-rpi mysqld: 140515 14:57:00 [Note] /usr/sbin/mysqld: ready for connections.
May 15 14:57:00 server-rpi mysqld: Version: '5.5.35-0+wheezy1' socket: '/var/run/mysqld/mysqld.sock' port: 3306 (Debian)
May 15 14:57:00 server-rpi /etc/mysql/debian-start[30828]: Upgrading MySQL tables if necessary.
May 15 14:57:00 server-rpi kernel: [ 9334.864016] type=1400 audit(1400158620.844:108): avc: denied { ioctl } for pid=30845 comm="mysql" path="/tmp/sqlCLOIP6" dev=sda1 ino=262154 scontext=unconfined_u:system_r:mysqld_t:s0-s0:c0.c1023 tcontext=unconfined_u:object_r:root_t:s0 tclass=file
May 15 14:57:00 server-rpi /etc/mysql/debian-start[30832]: /usr/bin/mysql_upgrade: the '--basedir' option is always ignored
May 15 14:57:00 server-rpi /etc/mysql/debian-start[30832]: Looking for 'mysql' as: /usr/bin/mysql
May 15 14:57:00 server-rpi /etc/mysql/debian-start[30832]: Looking for 'mysqlcheck' as: /usr/bin/mysqlcheck
May 15 14:57:00 server-rpi /etc/mysql/debian-start[30832]: This installation of MySQL is already upgraded to 5.5.35, use --force if you still need to run mysql_upgrade
May 15 14:57:00 server-rpi /etc/mysql/debian-start[30847]: Checking for insecure root accounts.
May 15 14:57:00 server-rpi /etc/mysql/debian-start[30852]: Triggering myisam-recover for all MyISAM tables
May 15 14:57:51 server-rpi kernel: [ 9385.220134] usb 1-1: USB disconnect, device number 6
May 15 14:59:29 server-rpi mysqld: 140515 14:59:29 [Note] /usr/sbin/mysqld: Normal shutdown
May 15 14:59:29 server-rpi mysqld:
May 15 14:59:29 server-rpi mysqld: 140515 14:59:29 [Note] Event Scheduler: Purging the queue. 0 events
May 15 14:59:29 server-rpi mysqld: 140515 14:59:29 InnoDB: Starting shutdown...
May 15 14:59:30 server-rpi mysqld: 140515 14:59:30 InnoDB: Shutdown completed; log sequence number 1595685
May 15 14:59:30 server-rpi mysqld: 140515 14:59:30 [Note] /usr/sbin/mysqld: Shutdown complete
May 15 14:59:30 server-rpi mysqld:
May 15 14:59:30 server-rpi mysqld_safe: mysqld from pid file /var/run/mysqld/mysqld.pid ended
May 15 15:01:27 server-rpi mysqld_safe: Starting mysqld daemon with databases from /var/lib/mysql
May 15 15:01:27 server-rpi mysqld: 140515 15:01:27 [Warning] Using unique option prefix key_buffer instead of key_buffer_size is deprecated and will be removed in a future release. Please use the full name instead.
May 15 15:01:27 server-rpi mysqld: 140515 15:01:27 [Warning] Using unique option prefix myisam-recover instead of myisam-recover-options is deprecated and will be removed in a future release. Please use the full name instead.
May 15 15:01:27 server-rpi mysqld: 140515 15:01:27 [Note] Plugin 'FEDERATED' is disabled.
May 15 15:01:27 server-rpi mysqld: 140515 15:01:27 InnoDB: The InnoDB memory heap is disabled
May 15 15:01:27 server-rpi mysqld: 140515 15:01:27 InnoDB: Mutexes and rw_locks use GCC atomic builtins
May 15 15:01:27 server-rpi mysqld: 140515 15:01:27 InnoDB: Compressed tables use zlib 1.2.7
May 15 15:01:27 server-rpi mysqld: 140515 15:01:27 InnoDB: Using Linux native AIO
May 15 15:01:27 server-rpi mysqld: 140515 15:01:27 InnoDB: Initializing buffer pool, size = 128.0M
May 15 15:01:27 server-rpi mysqld: 140515 15:01:27 InnoDB: Completed initialization of buffer pool
May 15 15:01:27 server-rpi mysqld: 140515 15:01:27 InnoDB: highest supported file format is Barracuda.
May 15 15:01:28 server-rpi mysqld: 140515 15:01:28 InnoDB: Waiting for the background threads to start
May 15 15:01:29 server-rpi mysqld: 140515 15:01:29 InnoDB: 5.5.35 started; log sequence number 13083346
May 15 15:01:29 server-rpi mysqld: 140515 15:01:29 [Note] Server hostname (bind-address): '127.0.0.1'; port: 3306
May 15 15:01:29 server-rpi mysqld: 140515 15:01:29 [Note] - '127.0.0.1' resolves to '127.0.0.1';
May 15 15:01:29 server-rpi mysqld: 140515 15:01:29 [Note] Server socket created on IP: '127.0.0.1'.
May 15 15:01:29 server-rpi mysqld: 140515 15:01:29 [Note] Event Scheduler: Loaded 0 events
May 15 15:01:29 server-rpi mysqld: 140515 15:01:29 [Note] /usr/sbin/mysqld: ready for connections.
May 15 15:01:29 server-rpi mysqld: Version: '5.5.35-0+wheezy1' socket: '/var/run/mysqld/mysqld.sock' port: 3306 (Debian)
May 15 15:01:30 server-rpi /etc/mysql/debian-start[31548]: Upgrading MySQL tables if necessary.
May 15 15:01:30 server-rpi /etc/mysql/debian-start[31552]: /usr/bin/mysql_upgrade: the '--basedir' option is always ignored
May 15 15:01:30 server-rpi /etc/mysql/debian-start[31552]: Looking for 'mysql' as: /usr/bin/mysql
May 15 15:01:30 server-rpi /etc/mysql/debian-start[31552]: Looking for 'mysqlcheck' as: /usr/bin/mysqlcheck
May 15 15:01:30 server-rpi /etc/mysql/debian-start[31552]: FATAL ERROR: Upgrade failed
May 15 15:01:30 server-rpi /etc/mysql/debian-start[31570]: Checking for insecure root accounts.
May 15 15:01:51 server-rpi mpt-statusd: detected non-optimal RAID status
May 15 15:03:44 server-rpi kernel: [ 9737.993433] usb 1-1: new high-speed USB device number 7 using ehci_hcd
May 15 15:03:44 server-rpi kernel: [ 9738.541516] usb 1-1: New USB device found, idVendor=0781, idProduct=556b
May 15 15:03:44 server-rpi kernel: [ 9738.541528] usb 1-1: New USB device strings: Mfr=1, Product=2, SerialNumber=3
May 15 15:03:44 server-rpi kernel: [ 9738.541535] usb 1-1: Product: Cruzer Edge
May 15 15:03:44 server-rpi kernel: [ 9738.541540] usb 1-1: Manufacturer: SanDisk
May 15 15:03:44 server-rpi kernel: [ 9738.541545] usb 1-1: SerialNumber: 20053551931644C01351
May 15 15:03:44 server-rpi kernel: [ 9738.548311] scsi8 : usb-storage 1-1:1.0
May 15 15:03:45 server-rpi kernel: [ 9739.558754] scsi 8:0:0:0: Direct-Access SanDisk Cruzer Edge 1.26 PQ: 0 ANSI: 5
May 15 15:03:45 server-rpi kernel: [ 9739.563747] sd 8:0:0:0: Attached scsi generic sg2 type 0
May 15 15:03:45 server-rpi kernel: [ 9739.575441] sd 8:0:0:0: [sdb] 15633408 512-byte logical blocks: (8.00 GB/7.45 GiB)
May 15 15:03:45 server-rpi kernel: [ 9739.621320] sd 8:0:0:0: [sdb] Write Protect is off
May 15 15:03:45 server-rpi kernel: [ 9739.621332] sd 8:0:0:0: [sdb] Mode Sense: 43 00 00 00
May 15 15:03:45 server-rpi kernel: [ 9739.633881] sd 8:0:0:0: [sdb] Write cache: disabled, read cache: enabled, doesn't support DPO or FUA
May 15 15:03:45 server-rpi kernel: [ 9739.704494] sdb: sdb1
May 15 15:03:45 server-rpi kernel: [ 9739.755526] sd 8:0:0:0: [sdb] Attached SCSI removable disk
May 15 15:03:50 server-rpi kernel: [ 9744.827607] FAT-fs (sdb1): utf8 is not a recommended IO charset for FAT filesystems, filesystem will be case sensitive!
May 15 15:03:50 server-rpi kernel: [ 9744.863651] SELinux: initialized (dev sdb1, type vfat), uses genfs_contexts
Un truc bizarre cependant… Il refuse d’arreter le service FAILED mais il fonctionne très bien quand même.
service mysql force-reload
[....] Reloading MySQL database sever: mysqld/usr/bin/mysqladmin: connect to server at 'localhost' failed
error: 'Access denied for user 'debian-sys-maint'@'localhost' (using password: YES)'
En tout cas sa remarche un grand merci a toi tu viens de me sauver la vie ^^. J’ai eu peur de devoir tout réadapter pour sqlite ^^.