Kan mysql niet meer starten
Code (php)
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
Dec 19 20:04:58 server mysqld_safe[7902]: started
Dec 19 20:04:58 server mysqld[7906]: 091219 20:04:58 [Warning] Can't create test file /var/lib/mysql/server.lower-test
Dec 19 20:04:58 server mysqld[7906]: 091219 20:04:58 [Warning] Can't create test file /var/lib/mysql/server.lower-test
Dec 19 20:04:58 server mysqld[7906]: 091219 20:04:58 [Warning] One can only use the --user switch if running as root
Dec 19 20:04:58 server mysqld[7906]:
Dec 19 20:04:58 server mysqld[7906]: 091219 20:04:58 InnoDB: Operating system error number 13 in a file operation.
Dec 19 20:04:58 server mysqld[7906]: InnoDB: The error means mysqld does not have the access rights to
Dec 19 20:04:58 server mysqld[7906]: InnoDB: the directory.
Dec 19 20:04:58 server mysqld[7906]: InnoDB: File name ./ibdata1
Dec 19 20:04:58 server mysqld[7906]: InnoDB: File operation call: 'open'.
Dec 19 20:04:58 server mysqld[7906]: InnoDB: Cannot continue operation.
Dec 19 20:04:58 server mysqld_safe[7912]: ended
Dec 19 20:05:12 server /etc/init.d/mysql[8062]: 0 processes alive and '/usr/bin/mysqladmin --defaults-file=/etc/mysql/debian.cnf ping' resulted in
Dec 19 20:05:12 server /etc/init.d/mysql[8062]: Could not open required defaults file: /etc/mysql/debian.cnf
Dec 19 20:05:12 server /etc/init.d/mysql[8062]: Fatal error in defaults handling. Program aborted
Dec 19 20:05:12 server /etc/init.d/mysql[8062]:
Dec 19 20:04:58 server mysqld[7906]: 091219 20:04:58 [Warning] Can't create test file /var/lib/mysql/server.lower-test
Dec 19 20:04:58 server mysqld[7906]: 091219 20:04:58 [Warning] Can't create test file /var/lib/mysql/server.lower-test
Dec 19 20:04:58 server mysqld[7906]: 091219 20:04:58 [Warning] One can only use the --user switch if running as root
Dec 19 20:04:58 server mysqld[7906]:
Dec 19 20:04:58 server mysqld[7906]: 091219 20:04:58 InnoDB: Operating system error number 13 in a file operation.
Dec 19 20:04:58 server mysqld[7906]: InnoDB: The error means mysqld does not have the access rights to
Dec 19 20:04:58 server mysqld[7906]: InnoDB: the directory.
Dec 19 20:04:58 server mysqld[7906]: InnoDB: File name ./ibdata1
Dec 19 20:04:58 server mysqld[7906]: InnoDB: File operation call: 'open'.
Dec 19 20:04:58 server mysqld[7906]: InnoDB: Cannot continue operation.
Dec 19 20:04:58 server mysqld_safe[7912]: ended
Dec 19 20:05:12 server /etc/init.d/mysql[8062]: 0 processes alive and '/usr/bin/mysqladmin --defaults-file=/etc/mysql/debian.cnf ping' resulted in
Dec 19 20:05:12 server /etc/init.d/mysql[8062]: Could not open required defaults file: /etc/mysql/debian.cnf
Dec 19 20:05:12 server /etc/init.d/mysql[8062]: Fatal error in defaults handling. Program aborted
Dec 19 20:05:12 server /etc/init.d/mysql[8062]:
Waaraan kan dit liggen? Heb al veel gegoogled maar nisk gevonden
EDIT:
Code (php)
1
2
3
4
5
6
7
8
9
10
11
2
3
4
5
6
7
8
9
10
11
Dec 19 20:24:48 server mysqld_safe[5498]: started
Dec 19 20:24:48 server mysqld[5502]: InnoDB: The log sequence number in ibdata files does not match
Dec 19 20:24:48 server mysqld[5502]: InnoDB: the log sequence number in the ib_logfiles!
Dec 19 20:24:48 server mysqld[5502]: 091219 20:24:48 InnoDB: Database was not shut down normally!
Dec 19 20:24:48 server mysqld[5502]: InnoDB: Starting crash recovery.
Dec 19 20:24:48 server mysqld[5502]: InnoDB: Reading tablespace information from the .ibd files...
Dec 19 20:24:48 server mysqld[5502]: InnoDB: Restoring possible half-written data pages from the doublewrite
Dec 19 20:24:48 server mysqld[5502]: InnoDB: buffer...
Dec 19 20:24:48 server mysqld[5502]: 091219 20:24:48 InnoDB: Started; log sequence number 6 2032146287
Dec 19 20:24:48 server mysqld[5502]: 091219 20:24:48 [ERROR] Fatal error: Can't open and lock privilege tables: Table 'mysql.host' doesn't exist
Dec 19 20:24:48 server mysqld_safe[5513]: ended
Dec 19 20:24:48 server mysqld[5502]: InnoDB: The log sequence number in ibdata files does not match
Dec 19 20:24:48 server mysqld[5502]: InnoDB: the log sequence number in the ib_logfiles!
Dec 19 20:24:48 server mysqld[5502]: 091219 20:24:48 InnoDB: Database was not shut down normally!
Dec 19 20:24:48 server mysqld[5502]: InnoDB: Starting crash recovery.
Dec 19 20:24:48 server mysqld[5502]: InnoDB: Reading tablespace information from the .ibd files...
Dec 19 20:24:48 server mysqld[5502]: InnoDB: Restoring possible half-written data pages from the doublewrite
Dec 19 20:24:48 server mysqld[5502]: InnoDB: buffer...
Dec 19 20:24:48 server mysqld[5502]: 091219 20:24:48 InnoDB: Started; log sequence number 6 2032146287
Dec 19 20:24:48 server mysqld[5502]: 091219 20:24:48 [ERROR] Fatal error: Can't open and lock privilege tables: Table 'mysql.host' doesn't exist
Dec 19 20:24:48 server mysqld_safe[5513]: ended
Als ik 'm via m'n controlpanel(webmin) probeer te starten
Gewijzigd op 01/01/1970 01:00:00 door Teun Beijers
Gesponsorde koppelingen:
edit: check http://dev.mysql.com/tech-resources/articles/recovering-from-crashes.html
Gewijzigd op 01/01/1970 01:00:00 door John D
John schreef op 19.12.2009 21:01:
het ziet er naar uit dat je database beschadigd is. Ik hoop dat je een recente backup hebt.
Dacht ik ook aan.
Keer op Windows crash o.i.d. gehad. Toen sputterde mysql tegen.
Oude data geback-upt en nieuwe installatie gedaan.
John schreef op 20.12.2009 12:56:
Bestanden verplaatsen onder een running deamon mysqld is nooit goed. Het proces is dan opeens zijn files kwijt.....
Ikke had dat ook niet gedaan, mysql stond al lang uit :-).
Bedankt voor alle hulp
