Bug #89991 | Can't Move Data Directory | ||
---|---|---|---|
Submitted: | 9 Mar 2018 14:31 | Modified: | 16 Mar 2018 10:31 |
Reporter: | Colin Bruce | Email Updates: | |
Status: | Not a Bug | Impact on me: | |
Category: | MySQL Server | Severity: | S3 (Non-critical) |
Version: | 5.7 | OS: | Windows (8.1) |
Assigned to: | MySQL Verification Team | CPU Architecture: | Any (X64) |
[9 Mar 2018 14:31]
Colin Bruce
[9 Mar 2018 14:34]
Colin Bruce
Error file
Attachment: HOME-PC.err (application/octet-stream, text), 2.40 KiB.
[9 Mar 2018 14:36]
Colin Bruce
I've attached the error file and I suspect it makes clear what the problem is. The error file is in the new location so MySQL is able to write to the directory and if I delete the ib* files it recreates them so why it then complains: "os_file_get_status() failed on '.\ibdata1'. Can't determine file permissions" when it created the file just a few minutes before is beyond me.
[9 Mar 2018 14:54]
Colin Bruce
Now it gets stranger. I moved the data directory from where it was on the E drive to a new location on the D drive, updated the my.ini file and the server started perfectly. Right I thought it must be permissions but starting at the drive and working down both drives and sub folders looked pretty much the same. Anyway, I then moved the data folder back to the E drive and the server started without a problem. So now I have no idea what the cause is. I had moved it to the E drive many many times with no success. The only difference this time is that I didn't use xcopy but just did a cut and paste with Windows Explorer. However, the security settings seem to be just the same unless there is something hidden the Windows Explorer doesn't show.
[16 Mar 2018 10:31]
MySQL Verification Team
Hi, This is not a bug, it has to do with permissions of the target directory. Check permissions with showacls.exe (should be in resource kit description how to use it should be here https://docs.microsoft.com/en-us/previous-versions/windows/it-pro/windows-server-2003/cc78...) ) or you can use icacls that should be there already. If you need help setting up our Support & Consulting team is always there to help, or you can also ask for help on https://forums.mysql.com/ thanks Bogdan