Prob Mysql
Inviato: mar 22 apr 2008, 14:20
Ho appena installato Slackware12, lancio Mysql e mi dice tramite il file "marco.err" (marco è il nome del mio PC) he manca la directory "/var/lib/mysql/mysql". La copio e incollo da un' altro OS ed ora mi dice che mancano dei files all'interno della medesima directory (in realtà ci sono). Così mi sono scaricato da Slacky.eu l' ultima versione di Mysql e l' ho sostituita con quella che ho. Non cmbia niente.
Codice: Seleziona tutto
root@marco:~# cat /var/lib/mysql/marco.err
080421 07:59:30 mysqld started
InnoDB: Log scan progressed past the checkpoint lsn 0 36808
080421 7:59:30 InnoDB: Database was not shut down normally!
InnoDB: Starting crash recovery.
InnoDB: Reading tablespace information from the .ibd files...
InnoDB: Restoring possible half-written data pages from the doublewrite
InnoDB: buffer...
InnoDB: Doing recovery: scanned up to log sequence number 0 43655
080421 7:59:30 InnoDB: Starting an apply batch of log records to the database...
InnoDB: Progress in percents: 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
InnoDB: Apply batch completed
080421 7:59:30 InnoDB: Started; log sequence number 0 43655
080421 7:59:30 [ERROR] /usr/libexec/mysqld: Can't find file: './mysql/host.frm' (errno: 13)
080421 7:59:30 [ERROR] /usr/libexec/mysqld: Can't find file: './mysql/host.frm' (errno: 13)
080421 7:59:30 [ERROR] Fatal error: Can't open and lock privilege tables: Can't find file: './mysql/host.frm' (errno: 13)
080421 07:59:30 mysqld ended
root@marco:~# ls /var/lib/mysql/
easykern ib_logfile0 ib_logfile1 ibdata1 marco.err mysql
root@marco:~# ls /var/lib/mysql/mysql
columns_priv.MYD help_relation.frm time_zone.MYI
columns_priv.MYI help_topic.MYD time_zone.frm
columns_priv.frm help_topic.MYI time_zone_leap_second.MYD
db.MYD help_topic.frm time_zone_leap_second.MYI
db.MYI host.MYD time_zone_leap_second.frm
db.frm host.MYI time_zone_name.MYD
func.MYD host.frm time_zone_name.MYI
func.MYI proc.MYD time_zone_name.frm
func.frm proc.MYI time_zone_transition.MYD
help_category.MYD proc.frm time_zone_transition.MYI
help_category.MYI procs_priv.MYD time_zone_transition.frm
help_category.frm procs_priv.MYI time_zone_transition_type.MYD
help_keyword.MYD procs_priv.frm time_zone_transition_type.MYI
help_keyword.MYI tables_priv.MYD time_zone_transition_type.frm
help_keyword.frm tables_priv.MYI user.MYD
help_relation.MYD tables_priv.frm user.MYI
help_relation.MYI time_zone.MYD user.frm
root@marco:~# cat /var/lib/mysql/mysql/host.frm
þ 0éSéÃ
//
t´¶ÀÿPRIMARYÿÿ MyISAMÈ1Host privileges; Merged with database privilegesc§üPc) HostDb
Select_priv
Insert_priv
Update_priv
Delete_priv
Create_priv
Drop_priv
References_privpriv
Index_priv
Alter_privCreate_tmp_table_privLock_tables_privCreate_vExecute_privJ´þSLÀ¶þSvCreate_routine_privAlter_routine_priv
÷!
÷!
÷!
÷!
÷!
÷!
÷!÷!
÷!
÷!ÿHostÿDbÿSelect_privÿInsert_privÿUpdate_privÿDelete_privÿCreate_privÿDrop_privÿGrant_privÿReferences_privÿIndex_privÿAlter_privÿCreate_tmp_table_privÿLock_tables_privÿCreate_view_privÿShow_view_privÿCreate_routine_privÿAlter_routine_privÿ