Autor Zpráva
mikii
Profil *
zdravím, mám problém padá mi mysql a nevím proč jak infiltrovat problém ? :/

několik měsíců vše bylo vpohodě, poslední dobou mi celkem narostla databáze co se týče struktury (né dat) ale to mi nepříjde že by byl kámen úrazu

.. netuším kliknu zobrazeni databáze v pma nebo vlezu do nějaké tabulky vše ok ale jakmile vlezu do jedné určité tabulky kterou jsem chtěl zeditovat (přidat pár sloupců) tak to spadne .. #2003 - Server neodpovídá

díky moc za výpomoc :D
Kajman_
Profil *
Zkuste check nebo repair table.
mikii
Profil *
ehmm zkusil změnilo se to že se mi otevřela tabulka ale zahalsilo to tohle

SQL-dotaz: DokumentaceUpravit

INSERT INTO `phpmyadmin`.`pma_history` (
`username` ,
`db` ,
`table` ,
`timevalue` ,
`sqlquery`
)
VALUES (
'root', 'abc_db', 'test_table', NOW( ) , 'SELECT * FROM `test_table`'
)

MySQL hlásí: Dokumentace
#2006 - MySQL server has gone away

po překliknutí na něco v té tabulce to zase spadne
#2003 - Server neodpovídá


stímhle jsem se bikdy nesetkal :-( právě ted když je hodně práce :/
mikii
Profil *
dal jsem reparir jna tabulku phpmyadmin`.`pma_history`

vše při starem
..MySQL hlásí: Dokumentace
#2006 - MySQL server has gone away
..
mikii
Profil *
.. další poznatek :/ co stímhle?

phpmyadmin.pma_history check warning 2 clients are using or haven't closed the table pr...
Kajman_
Profil *
Zkusil bych se mrknout na db přes mysql administrator z mysql qui tools
http://dev.mysql.com/downloads/gui-tools/5.0.html

A neloučí se náhodou disk?
Kajman_
Profil *
A příčiny havárie nejsou v logu?
mikii
Profil *
v apache? nejsou v logu. mysql nema nějaky error log?

disk? to snad ne .. mam to na home notebooku noo každopadně dneska se stalo to že mi to nejede vubec:/ a nevim proč po restartu se na DB nepřipojím :/ dá se nějak vycucat ty struktura databáze? když se tam nemužu nijak lognout .. přes administrator gui mi to napíše .. Could not start service

co stim jako je ? : /
Kajman_
Profil *
Apache to mít v logu nebude, mrkněte do adřesáře s daty, jestli tam nemáte soubor nazevpocitace.err.
mikii
Profil *
C:\dev\mysql51\bin\mysqld: Table 'mysql.plugin' doesn't exist
091101 20:37:19 [ERROR] Can't open the mysql.plugin table. Please run mysql_upgrade to create it.
InnoDB: The first specified data file .\ibdata1 did not exist:
InnoDB: a new database to be created!
091101 20:37:19  InnoDB: Setting file .\ibdata1 size to 10 MB
InnoDB: Database physically writes the file full: wait...
091101 20:37:19  InnoDB: Log file .\ib_logfile0 did not exist: new to be created
InnoDB: Setting log file .\ib_logfile0 size to 10 MB
InnoDB: Database physically writes the file full: wait...
091101 20:37:20  InnoDB: Log file .\ib_logfile1 did not exist: new to be created
InnoDB: Setting log file .\ib_logfile1 size to 10 MB
InnoDB: Database physically writes the file full: wait...
InnoDB: Doublewrite buffer not found: creating new
InnoDB: Doublewrite buffer created
InnoDB: Creating foreign key constraint system tables
InnoDB: Foreign key constraint system tables created
091101 20:37:21  InnoDB: Started; log sequence number 0 0
091101 20:37:21 [ERROR] Fatal error: Can't open and lock privilege tables: Table 'mysql.host' doesn't exist
C:\dev\mysql51\bin\mysqld: Table 'mysql.plugin' doesn't exist
091101 20:40:39 [ERROR] Can't open the mysql.plugin table. Please run mysql_upgrade to create it.
InnoDB: Log scan progressed past the checkpoint lsn 0 39548
091101 20:40:45  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 46409
091101 20:40:46  InnoDB: Starting an apply batch of log records to the database...
InnoDB: Progress in percents: 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
091101 20:40:48  InnoDB: Started; log sequence number 0 46409
091101 20:40:51 [ERROR] Fatal error: Can't open and lock privilege tables: Table 'mysql.host' doesn't exist
C:\dev\mysql51\bin\mysqld: Table 'mysql.plugin' doesn't exist
091101 20:57:08 [ERROR] Can't open the mysql.plugin table. Please run mysql_upgrade to create it.
InnoDB: The log sequence number in ibdata files does not match
InnoDB: the log sequence number in the ib_logfiles!
091101 20:57:14  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...
091101 20:57:17  InnoDB: Started; log sequence number 0 46409
091101 20:57:17 [ERROR] Fatal error: Can't open and lock privilege tables: Table 'mysql.host' doesn't exist
C:\dev\mysql51\bin\mysqld: Table 'mysql.plugin' doesn't exist
091101 21:03:43 [ERROR] Can't open the mysql.plugin table. Please run mysql_upgrade to create it.
InnoDB: The log sequence number in ibdata files does not match
InnoDB: the log sequence number in the ib_logfiles!
091101 21:03:48  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...
091101 21:03:48  InnoDB: Started; log sequence number 0 46409
091101 21:03:48 [ERROR] Fatal error: Can't open and lock privilege tables: Table 'mysql.host' doesn't exist
C:\dev\mysql51\bin\mysqld: Table 'mysql.plugin' doesn't exist
091101 21:24:32 [ERROR] Can't open the mysql.plugin table. Please run mysql_upgrade to create it.
InnoDB: The log sequence number in ibdata files does not match
InnoDB: the log sequence number in the ib_logfiles!
091101 21:24:32  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...
091101 21:24:32  InnoDB: Started; log sequence number 0 46409
091101 21:24:32 [ERROR] Fatal error: Can't open and lock privilege tables: Table 'mysql.host' doesn't exist

nightfish
Profil
mikii:
Fatal error: Can't open and lock privilege tables: Table 'mysql.host' doesn't exist
není problém v tomto?
nepomohlo by spustit mysql_upgrade.exe?
mikii
Profil *
ehm nepomohlo po spuštění toho souboru z cmd Err 2003 a fatal error upgrade

ono ta db nejede už vubec :/

error log vypada stjjně

Vaše odpověď

Mohlo by se hodit


Prosím používejte diakritiku a interpunkci.

Ochrana proti spamu. Napište prosím číslo dvě-sta čtyřicet-sedm: