I'm trying to rescue my MySQL data from a crashed disk (... I know ... backup ... which I normally do, but ... <poor excuse>...). I managed to retrieved the complete database structure as it is normally stored under /var/lib/mysql under "Linux Fedora 2". Following up on the advise in the posting http://lists.evolt.org/archive/Week-of-Mon-20020715/118061.html 1) I copied all the database files to the new MySQL repository (Fedora 3); of the 'mysql' I only copied the 'db', 'users' and 'host' tables; 2) I executed a 'mysqladmin flush-privileges' to have all the right permissions granted; 3) I did the following repair on the database 'zforum' (the results of which typical for all other four databases that I have to recover). Here's the result of that repair:
>>>>> [EMAIL PROTECTED] mysql]# myisamchk -r zforum/*.MYI - recovering (with sort) MyISAM-table 'zforum/zf_available_languages.MYI' Data records: 1 - Fixing index 1 --------- - recovering (with sort) MyISAM-table 'zforum/zf_forums.MYI' Data records: 5 - Fixing index 1 - Fixing index 2 --------- - recovering (with sort) MyISAM-table 'zforum/zf_global_announcement.MYI' Data records: 1 - Fixing index 1 --------- - recovering (with sort) MyISAM-table 'zforum/zf_member_avatars.MYI' Data records: 0 - Fixing index 1 --------- - recovering (with sort) MyISAM-table 'zforum/zf_member_properties.MYI' Data records: 48 - Fixing index 1 - Fixing index 2 - Fixing index 3 - Fixing index 4 - Fixing index 5 --------- - recovering (with sort) MyISAM-table 'zforum/zf_member_properties_skel.MYI' Data records: 13 - Fixing index 1 --------- - recovering (with sort) MyISAM-table 'zforum/zf_member_rank.MYI' Data records: 8 - Fixing index 1 - Fixing index 2 --------- - recovering (with sort) MyISAM-table 'zforum/zf_member_subscriptions.MYI' Data records: 5 - Fixing index 1 - Fixing index 2 - Fixing index 3 - Fixing index 4 --------- - recovering (with keycache) MyISAM-table 'zforum/zf_metadata.MYI' Data records: 0 --------- - recovering (with sort) MyISAM-table 'zforum/zf_pm_categories.MYI' Data records: 4 - Fixing index 1 --------- - recovering (with sort) MyISAM-table 'zforum/zf_pm.MYI' Data records: 4 - Fixing index 1 - Fixing index 2 - Fixing index 3 - Fixing index 4 --------- - recovering (with sort) MyISAM-table 'zforum/zf_polls.MYI' Data records: 5 - Fixing index 1 - Fixing index 2 --------- - recovering (with sort) MyISAM-table 'zforum/zf_system_properties.MYI' Data records: 16 - Fixing index 1 --------- - recovering (with sort) MyISAM-table 'zforum/zf_topics.MYI' Data records: 61 - Fixing index 1 - Fixing index 2 - Fixing index 3 - Fixing index 4 <<<<< where the data records indeed match the content of the databases (as I remember them); this looks very promising indeed. However, a mysqldump of the zforum database doesn't show more than this >>>>> [EMAIL PROTECTED] mysql]# mysqldump zforum -- MySQL dump 8.23 -- -- Host: localhost Database: zforum --------------------------------------------------------- -- Server version 3.23.58 <<<<< ... which is rather disappointing... Can anyone advise me how I will be able to retrieve the actual data? Thanks in advance. --Henk -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
