MySQL Forums
Forum List  »  Backup

MySQL Enterprise Backup: ERROR 1017 (HY000): Can't find file
Posted by: Charles Delencre
Date: January 19, 2012 10:01AM

To whom it may concern,

I am working on a new project & I am having trouble with my sql queries, I get the following error message when I run this query

mysqlbackup --backup-dir=/bakckupdir/ --copy-back

it's ok, but when i log on mysql and i do:

select * from base.table;


I get this error

ERROR 1017 (HY000): Can't find file: '/database/table.frm' (errno: 13)

By default, after the copy-back, the rights of files and folders in the data_home_dir are:

chown root:root
chmod 650

Then I do this chmod

chown mysql:mysql
chmod 660

and I still get the same error message , it ‘s frustrating not knowing where I am going wrong. Do you have any idea what could be causing this?
I hope that you will be able to help me out with this.

Thank you

Regards



Edited 1 time(s). Last edit at 01/24/2012 07:43AM by Charles Delencre.

Options: ReplyQuote


Subject
Views
Written By
Posted
MySQL Enterprise Backup: ERROR 1017 (HY000): Can't find file
5267
January 19, 2012 10:01AM


Sorry, you can't reply to this topic. It has been closed.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.