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 -- _____________________________________________________________________ Versatel ADSL Gratis. De voordelen van gratis internet met de snelheid van ADSL. Zonder abonnementskosten en zonder vast contract. Je betaalt alleen voor de tijd online. Nu zonder aansluitkosten en met gratis modem. Bestel snel op www.versatel.nl. -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
