MySQL can't find table forms.
Remember a while back when I posted about restoring a mysqlhotcopy copied database that I got an error that it can't find the .frm file? Well, the error reports have been coming in that apparently most if not all my tables (restored or new) have the same error. Here is a sample from one of the pages. Can't find file: './qwerty/table1.frm' (errno: 13) --- Anybody know of a possible reason for this? I have tried restarting mysqld as well as the entire server without any better results. I seem to be able to query some of the tables from the mysql client on the server machine but not always. Quick help would be very much appreciated, as this seems to have gone from bad to worse. Thanks in advance, ~Travis PS - I have just finished backing up all the databases using mysqldump as well as mysqlhotcopy (a little redundant but I don't want to lose any data). - 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
Re: MySQL can't find table forms.
Error 13 is permission denied. chown -R mysql:mysql /var/lib/mysql ( or whatever ) Travis Farmer wrote: Remember a while back when I posted about restoring a mysqlhotcopy copied database that I got an error that it can't find the .frm file? Well, the error reports have been coming in that apparently most if not all my tables (restored or new) have the same error. Here is a sample from one of the pages. Can't find file: './qwerty/table1.frm' (errno: 13) --- Anybody know of a possible reason for this? I have tried restarting mysqld as well as the entire server without any better results. I seem to be able to query some of the tables from the mysql client on the server machine but not always. Quick help would be very much appreciated, as this seems to have gone from bad to worse. Thanks in advance, ~Travis PS - I have just finished backing up all the databases using mysqldump as well as mysqlhotcopy (a little redundant but I don't want to lose any data). - 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
RE: MySQL can't find table forms.
Remember a while back when I posted about restoring a mysqlhotcopy copied database that I got an error that it can't find the .frm file? Well, the error reports have been coming in that apparently most if not all my tables (restored or new) have the same error. Here is a sample from one of the pages. Can't find file: './qwerty/table1.frm' (errno: 13) --- $ perror 13 Error code 13: Permission denied What are the file/directory permissions on the mysql directory? And the qwery directory? and the .frm file? Does the user running mysqld have permission to read/write/execute on those dirs/files? Might you at some point have been running mysqld as root, and now you are running it as the user mysql? / Carsten -- Carsten H. Pedersen keeper and maintainer of the bitbybit.dk MySQL FAQ http://www.bitbybit.dk/mysqlfaq - 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