MySQL Forums
Forum List  »  InnoDB

Can't access different disk
Posted by: Matt G
Date: October 08, 2014 03:07AM

I'm having trouble moving my sql files to a different disk. I've tried creating a symbolic link (or creating a table with 'data directory ='), moving ibdata1, and changing innodb_data_home_dir in my.cnf as I did with another server that this worked for, but I'm now getting this error:

[Note] InnoDB: Completed initialization of buffer pool
2014-10-07 21:09:57 b77588e0 InnoDB: Operating system error number 13 in a file operation.
InnoDB: The error means mysqld does not have the access rights to
InnoDB: the directory.
2014-10-07 21:09:57 12595 [ERROR] InnoDB: os_file_get_status() failed on '/path/to/ibdata1'. Can't determine file permissions
2014-10-07 21:09:57 12595 [ERROR] InnoDB: The system tablespace must be writable!

I'm sure I set all the correct permissions and owner/group settings and I'm able to store the files in different locations on the same disk, but as soon as I try using the new disk I keep getting that error. Do you know how this can be fixed? I'm using MySQL 5.6.17.

Options: ReplyQuote


Subject
Views
Written By
Posted
Can't access different disk
2754
October 08, 2014 03:07AM


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.