Hi, I'm currently testing the BACKUP TABLE function, and to reconstruct the MYI files, I'm performing the following action :
For exemple : dd if=/home/mysql/Hardwarefr/cookie.MYI bs=16k count=1 of=/home/mirror/mysql/Hardwarefr /cookie.MYI (to restore the valid first 16 K block) [root@forum] /home/mirror/mysql/Hardwarefr> ls -la cookie.MYI -rw-r--r-- 1 root root 16384 Mar 12 01:52 cookie.MYI Then I execute : myisamchk -r cookie.MYI - recovering (with sort) MyISAM-table 'cookie' Data records: 95290 - Fixing index 1 Data records: 95289 [root@forum] /home/mirror/mysql/Hardwarefr> ls -la cookie.MYI -rw-r--r-- 1 root root 879616 Mar 12 01:55 cookie.MYI [root@forum] /home/mirror/mysql/Hardwarefr> myisamchk -e cookie Checking MyISAM file: cookie Data records: 95289 Deleted blocks: 0 - check file-size - check key delete-chain - check record delete-chain - check index reference - check data record references index: 1 - check records and index references Things seems to be perfect here, but : myisamchk -o cookie - recovering (with keycache) MyISAM-table 'cookie' Data records: 95289 [root@forum] /home/mirror/mysql/Hardwarefr> ls -la cookie.MYI -rw-r--r-- 1 root root 1577984 Mar 12 01:56 cookie.MYI Why does the MYI is know nearly twice as big as the old cookie.MYI file ? Thanks you ! Jocelyn Fournier Presence-PC --------------------------------------------------------------------- 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