Bonsoir tout le monde, j'ai un problème de démarrage MySql

Code : Sélectionner tout - Visualiser dans une fenêtre à part
1
2
[root@www ~]# service mysql start
Starting MySQL..........The server quit without updating PID file (/var/lib/mysql/www.exemple.com.pid
J'ai fait cette commande, mais ça ne marche pas :

Code : Sélectionner tout - Visualiser dans une fenêtre à part
1
2
3
4
5
6
[root@www ~]# ps aux | grep mysql
root      2600  0.0  0.1   4164   648 pts/1    S+   14:46   0:00 grep mysql
[root@www ~]# kill -9 2600
-bash: kill: (2600) - Aucun processus de ce type
[root@www ~]# mv /etc/my.cnf /etc/my.cnf.backup
[root@www ~]#mv /var/lib/mysql/ib_logfile* /root/
et voici le fichier (/var/lib/mysql/www.exemple.com.err )

Code : Sélectionner tout - Visualiser dans une fenêtre à part
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
87
88
89
90
91
92
93
94
95
96
97
98
99
100
101
102
103
104
105
106
107
108
109
110
111
112
113
114
115
116
117
118
119
120
121
122
123
124
125
126
127
128
129
130
131
132
133
134
135
136
137
138
139
140
141
142
143
144
145
146
147
148
149
140409 14:24:49 mysqld_safe Starting mysqld daemon with databases from /var/lib/
mysql
2014-04-09 14:24:50 0 [Warning] TIMESTAMP with implicit DEFAULT value is depreca
ted. Please use --explicit_defaults_for_timestamp server option (see documentati
on for more details).
2014-04-09 14:24:50 2291 [ERROR] Can't read from messagefile '/usr/share/mysql/e
nglish/errmsg.sys'
2014-04-09 14:24:50 2291 [Note] Plugin 'FEDERATED' is disabled.
2014-04-09 14:24:51 2291 [Note] InnoDB: The InnoDB memory heap is disabled
2014-04-09 14:24:51 2291 [Note] InnoDB: Mutexes and rw_locks use InnoDB's own im
plementation
2014-04-09 14:24:51 2291 [Note] InnoDB: Compressed tables use zlib 1.2.3
2014-04-09 14:24:51 2291 [Note] InnoDB: Using Linux native AIO
2014-04-09 14:24:51 2291 [Note] InnoDB: Not using CPU crc32 instructions
2014-04-09 14:24:51 2291 [Note] InnoDB: Initializing buffer pool, size = 128.0M
2014-04-09 14:24:51 2291 [Note] InnoDB: Completed initialization of buffer pool
2014-04-09 14:24:51 2291 [Note] InnoDB: Highest supported file format is Barracu
da.
2014-04-09 14:24:54 2291 [Note] InnoDB: 128 rollback segment(s) are active.
2014-04-09 14:24:54 2291 [Note] InnoDB: Waiting for purge to start
2014-04-09 14:24:54 2291 [Note] InnoDB: 5.6.12 started; log sequence number 3430
0076
2014-04-09 14:24:54 2291 [ERROR] Aborting

2014-04-09 14:24:54 2291 [Note] Binlog end
2014-04-09 14:24:54 2291 [Note] Shutting down plugin 'partition'
2014-04-09 14:24:54 2291 [Note] Shutting down plugin 'BLACKHOLE'
2014-04-09 14:24:54 2291 [Note] Shutting down plugin 'ARCHIVE'
2014-04-09 14:24:54 2291 [Note] Shutting down plugin 'PERFORMANCE_SCHEMA'
2014-04-09 14:24:54 2291 [Note] Shutting down plugin 'INNODB_SYS_DATAFILES'
2014-04-09 14:24:54 2291 [Note] Shutting down plugin 'INNODB_SYS_TABLESPACES'
2014-04-09 14:24:54 2291 [Note] Shutting down plugin 'INNODB_SYS_FOREIGN_COLS'
2014-04-09 14:24:54 2291 [Note] Shutting down plugin 'INNODB_SYS_FOREIGN'
2014-04-09 14:24:54 2291 [Note] Shutting down plugin 'INNODB_SYS_FIELDS'
2014-04-09 14:24:54 2291 [Note] Shutting down plugin 'INNODB_SYS_COLUMNS'
2014-04-09 14:24:54 2291 [Note] Shutting down plugin 'INNODB_SYS_INDEXES'
2014-04-09 14:24:54 2291 [Note] Shutting down plugin 'INNODB_SYS_TABLESTATS'
2014-04-09 14:24:54 2291 [Note] Shutting down plugin 'INNODB_SYS_TABLES'
2014-04-09 14:24:54 2291 [Note] Shutting down plugin 'INNODB_FT_INDEX_TABLE'
2014-04-09 14:24:54 2291 [Note] Shutting down plugin 'INNODB_FT_INDEX_CACHE'
2014-04-09 14:24:54 2291 [Note] Shutting down plugin 'INNODB_FT_CONFIG'
2014-04-09 14:24:54 2291 [Note] Shutting down plugin 'INNODB_FT_BEING_DELETED'
2014-04-09 14:24:54 2291 [Note] Shutting down plugin 'INNODB_FT_DELETED'
2014-04-09 14:24:54 2291 [Note] Shutting down plugin 'INNODB_FT_DEFAULT_STOPWORD
'
2014-04-09 14:24:54 2291 [Note] Shutting down plugin 'INNODB_METRICS'
2014-04-09 14:24:54 2291 [Note] Shutting down plugin 'INNODB_BUFFER_POOL_STATS'
2014-04-09 14:24:54 2291 [Note] Shutting down plugin 'INNODB_BUFFER_PAGE_LRU'
2014-04-09 14:24:54 2291 [Note] Shutting down plugin 'INNODB_BUFFER_PAGE'
2014-04-09 14:24:54 2291 [Note] Shutting down plugin 'INNODB_CMP_PER_INDEX_RESET
'
2014-04-09 14:24:54 2291 [Note] Shutting down plugin 'INNODB_CMP_PER_INDEX'
2014-04-09 14:24:54 2291 [Note] Shutting down plugin 'INNODB_CMPMEM_RESET'
2014-04-09 14:24:54 2291 [Note] Shutting down plugin 'INNODB_CMPMEM'
2014-04-09 14:24:54 2291 [Note] Shutting down plugin 'INNODB_CMP_RESET'
2014-04-09 14:24:54 2291 [Note] Shutting down plugin 'INNODB_CMP'
2014-04-09 14:24:54 2291 [Note] Shutting down plugin 'INNODB_LOCK_WAITS'
2014-04-09 14:24:54 2291 [Note] Shutting down plugin 'INNODB_LOCKS'
2014-04-09 14:24:54 2291 [Note] Shutting down plugin 'INNODB_TRX'
2014-04-09 14:24:54 2291 [Note] Shutting down plugin 'InnoDB'
2014-04-09 14:24:54 2291 [Note] InnoDB: FTS optimize thread exiting.
2014-04-09 14:24:54 2291 [Note] InnoDB: Starting shutdown...
2014-04-09 14:24:56 2291 [Note] InnoDB: Shutdown completed; log sequence number
34300086
2014-04-09 14:24:56 2291 [Note] Shutting down plugin 'MRG_MYISAM'
2014-04-09 14:24:56 2291 [Note] Shutting down plugin 'MEMORY'
2014-04-09 14:24:56 2291 [Note] Shutting down plugin 'MyISAM'
2014-04-09 14:24:56 2291 [Note] Shutting down plugin 'CSV'
2014-04-09 14:24:56 2291 [Note] Shutting down plugin 'sha256_password'
2014-04-09 14:24:56 2291 [Note] Shutting down plugin 'mysql_old_password'
2014-04-09 14:24:56 2291 [Note] Shutting down plugin 'mysql_native_password'
2014-04-09 14:24:56 2291 [Note] Shutting down plugin 'binlog'
2014-04-09 14:24:56 2291 [Note]
140409 14:24:57 mysqld_safe mysqld from pid file /var/lib/mysql/www.exemple.com.pid ended
140409 14:42:25 mysqld_safe Starting mysqld daemon with databases from /var/lib/
mysql
2014-04-09 14:42:26 0 [Warning] TIMESTAMP with implicit DEFAULT value is depreca
ted. Please use --explicit_defaults_for_timestamp server option (see documentati
on for more details).
2014-04-09 14:42:26 2536 [ERROR] Can't read from messagefile '/usr/share/mysql/e
nglish/errmsg.sys'
2014-04-09 14:42:27 2536 [Note] Plugin 'FEDERATED' is disabled.
2014-04-09 14:42:27 2536 [Note] InnoDB: The InnoDB memory heap is disabled
2014-04-09 14:42:27 2536 [Note] InnoDB: Mutexes and rw_locks use InnoDB's own im
plementation
2014-04-09 14:42:27 2536 [Note] InnoDB: Compressed tables use zlib 1.2.3
2014-04-09 14:42:27 2536 [Note] InnoDB: Using Linux native AIO
2014-04-09 14:42:27 2536 [Note] InnoDB: Not using CPU crc32 instructions
2014-04-09 14:42:27 2536 [Note] InnoDB: Initializing buffer pool, size = 128.0M
2014-04-09 14:42:27 2536 [Note] InnoDB: Completed initialization of buffer pool
2014-04-09 14:42:28 2536 [Note] InnoDB: Highest supported file format is Barracu
da.
2014-04-09 14:42:32 2536 [Note] InnoDB: 128 rollback segment(s) are active.
2014-04-09 14:42:32 2536 [Note] InnoDB: Waiting for purge to start
2014-04-09 14:42:33 2536 [Note] InnoDB: 5.6.12 started; log sequence number 3430
0086
2014-04-09 14:42:33 2536 [ERROR] Aborting

2014-04-09 14:42:33 2536 [Note] Binlog end
2014-04-09 14:42:33 2536 [Note] Shutting down plugin 'partition'
2014-04-09 14:42:33 2536 [Note] Shutting down plugin 'BLACKHOLE'
2014-04-09 14:42:33 2536 [Note] Shutting down plugin 'ARCHIVE'
2014-04-09 14:42:33 2536 [Note] Shutting down plugin 'PERFORMANCE_SCHEMA'
2014-04-09 14:42:33 2536 [Note] Shutting down plugin 'INNODB_SYS_DATAFILES'
2014-04-09 14:42:33 2536 [Note] Shutting down plugin 'INNODB_SYS_TABLESPACES'
2014-04-09 14:42:33 2536 [Note] Shutting down plugin 'INNODB_SYS_FOREIGN_COLS'
2014-04-09 14:42:33 2536 [Note] Shutting down plugin 'INNODB_SYS_FOREIGN'
2014-04-09 14:42:33 2536 [Note] Shutting down plugin 'INNODB_SYS_FIELDS'
2014-04-09 14:42:33 2536 [Note] Shutting down plugin 'INNODB_SYS_COLUMNS'
2014-04-09 14:42:33 2536 [Note] Shutting down plugin 'INNODB_SYS_INDEXES'
2014-04-09 14:42:33 2536 [Note] Shutting down plugin 'INNODB_SYS_TABLESTATS'
2014-04-09 14:42:33 2536 [Note] Shutting down plugin 'INNODB_SYS_TABLES'
2014-04-09 14:42:33 2536 [Note] Shutting down plugin 'INNODB_FT_INDEX_TABLE'
2014-04-09 14:42:33 2536 [Note] Shutting down plugin 'INNODB_FT_INDEX_CACHE'
2014-04-09 14:42:33 2536 [Note] Shutting down plugin 'INNODB_FT_CONFIG'
2014-04-09 14:42:33 2536 [Note] Shutting down plugin 'INNODB_FT_BEING_DELETED'
2014-04-09 14:42:33 2536 [Note] Shutting down plugin 'INNODB_FT_DELETED'
2014-04-09 14:42:33 2536 [Note] Shutting down plugin 'INNODB_FT_DEFAULT_STOPWORD
'
2014-04-09 14:42:33 2536 [Note] Shutting down plugin 'INNODB_METRICS'
2014-04-09 14:42:33 2536 [Note] Shutting down plugin 'INNODB_BUFFER_POOL_STATS'
2014-04-09 14:42:33 2536 [Note] Shutting down plugin 'INNODB_BUFFER_PAGE_LRU'
2014-04-09 14:42:33 2536 [Note] Shutting down plugin 'INNODB_BUFFER_PAGE'
2014-04-09 14:42:33 2536 [Note] Shutting down plugin 'INNODB_CMP_PER_INDEX_RESET
'
2014-04-09 14:42:33 2536 [Note] Shutting down plugin 'INNODB_CMP_PER_INDEX'
2014-04-09 14:42:33 2536 [Note] Shutting down plugin 'INNODB_CMPMEM_RESET'
2014-04-09 14:42:33 2536 [Note] Shutting down plugin 'INNODB_CMPMEM'
2014-04-09 14:42:33 2536 [Note] Shutting down plugin 'INNODB_CMP_RESET'
2014-04-09 14:42:33 2536 [Note] Shutting down plugin 'INNODB_CMP'
2014-04-09 14:42:33 2536 [Note] Shutting down plugin 'INNODB_LOCK_WAITS'
2014-04-09 14:42:33 2536 [Note] Shutting down plugin 'INNODB_LOCKS'
2014-04-09 14:42:33 2536 [Note] Shutting down plugin 'INNODB_TRX'
2014-04-09 14:42:33 2536 [Note] Shutting down plugin 'InnoDB'
2014-04-09 14:42:33 2536 [Note] InnoDB: FTS optimize thread exiting.
2014-04-09 14:42:33 2536 [Note] InnoDB: Starting shutdown...
2014-04-09 14:42:34 2536 [Note] InnoDB: Shutdown completed; log sequence number
34300096
2014-04-09 14:42:34 2536 [Note] Shutting down plugin 'MRG_MYISAM'
2014-04-09 14:42:34 2536 [Note] Shutting down plugin 'MEMORY'
2014-04-09 14:42:34 2536 [Note] Shutting down plugin 'MyISAM'
2014-04-09 14:42:34 2536 [Note] Shutting down plugin 'CSV'
2014-04-09 14:42:34 2536 [Note] Shutting down plugin 'sha256_password'
2014-04-09 14:42:34 2536 [Note] Shutting down plugin 'mysql_old_password'
2014-04-09 14:42:34 2536 [Note] Shutting down plugin 'mysql_native_password'
2014-04-09 14:42:34 2536 [Note] Shutting down plugin 'binlog'
2014-04-09 14:42:34 2536 [Note]
140409 14:42:35 mysqld_safe mysqld from pid file /var/lib/mysql/www.exemple.com.pid ended

Merci d'avance.