Comments - Changing location of database

10 years, 9 months ago Daniel Bartholomew

Silly question, but you said you stopped the database, reset the basedir in your my.cnf, and then restarted... did you move the data in the datadir to the new location?

 
10 years, 9 months ago Michael Davies

Yes, I did. Also ran checktable on every table. Since writing I have also dropped all schemas and recreated them from scripts. Again all ok until I reboot. Thinking it could be to do with permissions because linux sets all permissions on NTFS drives to root and everybody. Does not use sudo or mysql accounts and doesn't allow them to be changed.

 
Content reproduced on this site is the property of its respective owners, and this content is not reviewed in advance by MariaDB. The views, information and opinions expressed by this content do not necessarily represent those of MariaDB or any other party.