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]
