Maybe you didn't specify the correct data-dir in my.cnf?
Thomas sql,query On Sun, 6 Oct 2002 09:23:51 +0200 "jeroen" <[EMAIL PROTECTED]> wrote: > 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