Okay, I'm very sorry for bothering you all with this. If I had not panicked, I probably would have found it myself.
The solution was right under my nose : http://www.mysql.com/doc/en/perror.html even tough perror doesn'"t work on my macosx machine, the above webpage states nicely that errno 13 means a permission issue. a straight sudo chown -R mysql /usr/local/mysql/* solved everything. ----- Original Message ----- From: "jeroen" <[EMAIL PROTECTED]> To: <[EMAIL PROTECTED]> Sent: Sunday, October 06, 2002 9:23 AM Subject: need urgent help recovering after renistall (pleeeease !) > 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 > > --------------------------------------------------------------------- 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