MySQL Forums
Forum List  »  Backup

Re: Change datadir on Ubuntu server to a Raid1 partion with databases
Posted by: Javier Brito Pacheco
Date: November 08, 2014 06:49PM

Sorry for answering so late,
I finally could make mysql change the datadir !

It was only about permissions in my path for example my path was

/media/user/raid(my hardrive in raid)/mysql(the mysql folder)

each folder needs to be owned by mysql:mysql (chown) and also needs chmod -R 777 in each part of the path (well that worked for me)

ill describe how i did it:

chmod -R 777 /media/user/**

chown --refference=/var/lib/mysql /media/user/raid/mysql

if you want you can give permissions from the hardrive till the mysql folder, i mean the mysql folder thats inside the mysql folder where all databases are

thats all

hope it help some one also

Options: ReplyQuote


Subject
Views
Written By
Posted
Re: Change datadir on Ubuntu server to a Raid1 partion with databases
1264
November 08, 2014 06:49PM


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.