Re: DB Crash: Wrong bytesec: 0- 0- 0 at 0;
On Wed, Oct 08, 2008 at 06:43:46PM -0400, Michael Dykman wrote: Assuming all of these databases reside on the same filesystem, it looks to me like your disk is failing. Do you have backups you can restore from? YOu might wnt to swp out your disks for new hardware before you try. I know that. The problem is missing working backup of data. Due to problems (invalid encoding in phpbb, few czech characters are bound to the same one using db dump, why I don't know, I've tried all possible (or some impossible) ways to dump it, but without any result (and phpbb displays the strings correctly)) I've backuped the database by stopping the mysqld, copy the db files and run the daemon again. And all last archives are affected :-(( So my question is simple: is it somehow possible to restore ANY data from such broken dbs? tapik - michael dykman On Wed, Oct 8, 2008 at 6:05 PM, Oto Buchta [EMAIL PROTECTED] wrote: Hi. I had a very big trouble with my MySQL databases. After four years of usage of the MySQL all DBs crashed. Each table is marked as crashed and myisamchk trucates the table, mostly to zero rows. Some of them are not totaly dropped: # myisamchk -o klik_cas.MYI - recovering (with keycache) MyISAM-table 'klik_cas.MYI' Data records: 1270 Wrong bytesec: 0- 0- 0 at 0; Skipped Data records: 50 # Have you any idea where the problem could be? I use 5.0.26 from OpenSuSE. Thanks a lot! Oto 'tapik' Buchta, tapik_at_buchtovi_dot_cz -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED] -- - michael dykman - [EMAIL PROTECTED] - All models are wrong. Some models are useful. -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
DB Crash: Wrong bytesec: 0- 0- 0 at 0;
Hi. I had a very big trouble with my MySQL databases. After four years of usage of the MySQL all DBs crashed. Each table is marked as crashed and myisamchk trucates the table, mostly to zero rows. Some of them are not totaly dropped: # myisamchk -o klik_cas.MYI - recovering (with keycache) MyISAM-table 'klik_cas.MYI' Data records: 1270 Wrong bytesec: 0- 0- 0 at 0; Skipped Data records: 50 # Have you any idea where the problem could be? I use 5.0.26 from OpenSuSE. Thanks a lot! Oto 'tapik' Buchta, tapik_at_buchtovi_dot_cz -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
db crash
Hi all ... our db server is attackt by a root kit, from our old db server the only thing we have are the log files knows someone a little script or app to filter all the querys out of the standard log format of the mysld.log file ..?!? thx a lot 4 all kind of support best regards andreas PS: Some snapshots of the log format: 349586 Connect root@localhost on 349586 Init DB adspot 349586 Query insert into event (even_sess_id, even_camp_code, even_timestamp, even_text) values (812102, 'ANNA1',sysdate(), 'mouseMove event occured') 349586 Quit select, update etc. also needed ... - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
DB CRASH
Hi all ... our db server is attackt by a root kit, from our old db server the only thing we have are the log files knows someone a little script or app to filter all the querys out of the standard log format of the mysld.log file ..?!? thx a lot 4 all kind of support best regards andreas PS: Some snapshots of the log format: 349586 Connect root@localhost on 349586 Init DB adspot 349586 Query insert into event (even_sess_id, even_camp_code, even_timestamp, even_text) values (812102, 'ANNA1',sysdate(), 'mouseMove event occured') 349586 Quit select, update etc. also needed ... - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
