LinuxQuestions.org
Share your knowledge at the LQ Wiki.
Home Forums Tutorials Articles Register
Go Back   LinuxQuestions.org > Forums > Linux Forums > Linux - Distributions > Slackware
Reload this Page [SOLVED] Move MySql datafile to different location
User Name
Password
Slackware This Forum is for the discussion of Slackware Linux.

Notices


Reply
  Search this Thread
Old 08-27-2010, 11:22 PM   #1
ethereal1m
Member
 
Registered: Jan 2010
Distribution: Ubuntu
Posts: 312

Rep: Reputation: 31
Question Move MySql datafile to different location

Dear all,
I want to move the location of MySql data file by setting datadir variable but I cannot find the variable in my.cnf file.

Should I set the variable in my.cnf, or is there any other configuration file beside this one?

Regards,
ethereal1m
 
Old 08-27-2010, 11:32 PM   #2
quanta
Member
 
Registered: Aug 2007
Location: Vietnam
Distribution: RedHat based, Debian based, Slackware, Gentoo
Posts: 724

Rep: Reputation: 101Reputation: 101
Yes, you can add it to [mysqld] section. A simplier way, I suggest you use symlink to change datadir location.
 
1 members found this post helpful.
Old 08-28-2010, 12:01 AM   #3
ethereal1m
Member
 
Registered: Jan 2010
Distribution: Ubuntu
Posts: 312

Original Poster
Rep: Reputation: 31
nice, thanks for fast reply!
 
  


Reply



Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts
BB code is On
Smilies are On
[IMG] code is Off
HTML code is Off


Similar Threads
Thread Thread Starter Forum Replies Last Post
Move Nautilus Location Bar ThomasB2k Ubuntu 3 04-11-2010 10:31 PM
How to Move the data directory of Mysql to different Location lakshmi4linux Linux - Newbie 1 03-31-2009 06:25 AM
How to move the mailbox location of the particular users haariseshu Linux - Server 3 07-24-2008 01:07 AM
move a file to same location with a different extention chasegger Linux - Newbie 4 06-25-2008 06:21 PM
JRE will not move to location so can install... linexnal Linux - Software 4 07-17-2007 02:08 PM

LinuxQuestions.org > Forums > Linux Forums > Linux - Distributions > Slackware

All times are GMT -5. The time now is 08:51 PM.

Contact Us - Advertising Info - Rules - Privacy - LQ Merchandise - Donations - Contributing Member - LQ Sitemap -
Main Menu
Advertisement
My LQ
Write for LQ
LinuxQuestions.org is looking for people interested in writing Editorials, Articles, Reviews, and more. If you'd like to contribute content, let us know.
Main Menu
Syndicate
RSS1  Latest Threads
RSS1  LQ News
Twitter: @linuxquestions
Open Source Consulting | Domain Registration