hello, I'm kindof a newbie with MySQL, and recently did something fairly stupid : I installed a new system (I'm running on MacOSX, was 10.1.5.1, now after upgrading it is 10.2.1) and I did not properly do it I'm afraid : I backed up my /usr/local/var directory which contained all my mysql 3.23.28 files. Then I wiped the disk (it needed repartitioning) and installed jaguar. Then I installled mysql from www.entropy.ch packages, which is 3.23.52.
then I copied the backups to /usr/local/mysql/data now it doesn't work anymore : mysql> select * from reeksen; ERROR 1017: Can't find file: './ETL/reeksen.frm' (errno: 13) even though the file is there : [juturnas-Computer:mysql/data/ETL] jeroen% ls -l total 200 -rwxrwxrwx 1 mysql wheel 476 Jul 8 16:27 auteurs.MYD -rwxrwxrwx 1 mysql wheel 2048 Jul 8 16:27 auteurs.MYI -rwxrwxrwx 1 mysql wheel 8650 Jul 2 15:20 auteurs.frm -rwxrwxrwx 1 mysql wheel 1160 Jul 29 15:48 main.MYD -rwxrwxrwx 1 mysql wheel 2048 Jul 29 15:48 main.MYI -rwxrwxrwx 1 mysql wheel 9896 Jul 24 21:28 main.frm -rwxrwxrwx 1 mysql wheel 88 Jul 24 21:38 reeksen.MYD -rwxrwxrwx 1 mysql wheel 2048 Jul 24 21:38 reeksen.MYI -rwxrwxrwx 1 mysql wheel 8664 Jul 9 00:09 reeksen.frm -rwxrwxrwx 1 mysql wheel 40 Jul 11 13:44 tijdschriften.MYD -rwxrwxrwx 1 mysql wheel 2048 Jul 11 13:44 tijdschriften.MYI -rwxrwxrwx 1 mysql wheel 8676 Jul 11 13:10 tijdschriften.frm -rwxrwxrwx 1 mysql wheel 116 Jul 10 15:20 uitgevers.MYD -rwxrwxrwx 1 mysql wheel 2048 Jul 10 15:20 uitgevers.MYI -rwxrwxrwx 1 mysql wheel 8718 Jul 8 21:45 uitgevers.frm what can I do to get this thing working again ? Please ? Any help would be VERY MUCH appreciated ! I need this server to be back up by sunday evening ! thanks ! --------------------------------------------------------------------- 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
