Gentoo Forums
Gentoo Forums
Gentoo Forums
Quick Search: in
MySQL and moving db to another partition [ SOLVED ]
View unanswered posts
View posts from last 24 hours

 
Reply to topic    Gentoo Forums Forum Index Other Things Gentoo
View previous topic :: View next topic  
Author Message
flipnode
Apprentice
Apprentice


Joined: 03 Oct 2004
Posts: 172
Location: USA

PostPosted: Wed Sep 07, 2005 12:01 am    Post subject: MySQL and moving db to another partition [ SOLVED ] Reply with quote

I want to move the mysql db over to another parition where I have more space to expand the db. How can or should this be done? Not 100% sure. Any help would be great. A procedure list maybe? :o)
_________________
I think Gentoo is great!


Last edited by flipnode on Wed Sep 14, 2005 10:32 pm; edited 1 time in total
Back to top
View user's profile Send private message
Earthwings
Bodhisattva
Bodhisattva


Joined: 14 Apr 2003
Posts: 7753
Location: Germany

PostPosted: Wed Sep 07, 2005 12:08 am    Post subject: Reply with quote

Moved from Unsupported Software to Other Things Gentoo and thread subject lowercased (CAPITALS are considered rude).
Back to top
View user's profile Send private message
BastianBalthazarBux
Retired Dev
Retired Dev


Joined: 10 Dec 2004
Posts: 78

PostPosted: Sat Sep 10, 2005 11:57 am    Post subject: Reply with quote

stop mysql, then edit /etc/mysql/my.cnf

under the section "[mysqld]" change the value of
Code:

datadir                     = /var/lib/mysql


to whatever you want.

It should be supported by start/stop scripts and others, if it is not please fill a bug-report.
Back to top
View user's profile Send private message
flipnode
Apprentice
Apprentice


Joined: 03 Oct 2004
Posts: 172
Location: USA

PostPosted: Sat Sep 10, 2005 10:12 pm    Post subject: MYSQL sym link Reply with quote

Can't I just create a symbolic link? Instead of chaning the config file?
_________________
I think Gentoo is great!
Back to top
View user's profile Send private message
flipnode
Apprentice
Apprentice


Joined: 03 Oct 2004
Posts: 172
Location: USA

PostPosted: Wed Sep 14, 2005 10:32 pm    Post subject: mysql move db files Reply with quote

Thanks.. I just moved it and it works fine..
_________________
I think Gentoo is great!
Back to top
View user's profile Send private message
Display posts from previous:   
Reply to topic    Gentoo Forums Forum Index Other Things Gentoo All times are GMT
Page 1 of 1

 
Jump to:  
You cannot post new topics in this forum
You cannot reply to topics in this forum
You cannot edit your posts in this forum
You cannot delete your posts in this forum
You cannot vote in polls in this forum