Fedora Linux Support Community & Resources Center
  #1  
Old 9th January 2012, 07:00 PM
vikashiiitdm Offline
Registered User
 
Join Date: Oct 2011
Posts: 11
linuxchrome
cannot change mysql default datadir

Dear all,

I have a fedora 15 x86_64 system having mysql and mysql-server installed on it!!! Everything was fine untill recently i found that i do not have sufficient space on my / partition to accomodate the whole of wikipedia_xml_dump , so i thought that i should change the default datadir of mysqld , but every time i change it my server doesn't start, i have tried changing datadir in many places, i even read the article http://docs.fedoraproject.org/en-US/..._Examples.html and followed the instructions but nothing changes , everytime i change my datadir in my.cnf the server just doesn't start and changing it back again to /var/lib/mysql makes it work again. please help , as the wkipedia's sql dump would expand to 80 gbs and i have only 20 gb of storage left on my / partition.


thank you

--
vikash kumar
Reply With Quote
  #2  
Old 9th January 2012, 07:23 PM
jpollard Online
Registered User
 
Join Date: Aug 2009
Location: Waldorf, Maryland
Posts: 6,860
linuxfedorafirefox
Re: cannot change mysql default datadir

Make sure the target directory has the same security label, ownership, and protection modes of the default. Also note that the path to the directory also has the proper labels. This would be the default for the root directory itself, so if you mount the data on /data, then it should be correct. Mounts elswhere (such as /home) have a different security label that could prevent usage.
Reply With Quote
Reply

Tags
change, datadir, default, mysql

Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

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 On
HTML code is Off

Forum Jump

Similar Threads
Thread Thread Starter Forum Replies Last Post
Changing MySQL datadir? guizhou_donkey Servers & Networking 7 20th October 2009 07:57 AM
Moving MySQL datadir MichaelS-R Servers & Networking 1 12th September 2008 01:08 PM
changing datadir for mysql 5.0.27 csfalcon Using Fedora 3 5th February 2007 11:11 PM
how to change the default page of apache from index.htm to default.htm sourin Servers & Networking 6 16th December 2005 04:08 PM
how to change the default page of apache from index.htm to default.htm sourin Servers & Networking 0 14th December 2005 12:42 PM


Current GMT-time: 16:18 (Wednesday, 01-10-2014)

TopSubscribe to XML RSS for all Threads in all ForumsFedoraForumDotOrg Archive
logo

All trademarks, and forum posts in this site are property of their respective owner(s).
FedoraForum.org is privately owned and is not directly sponsored by the Fedora Project or Red Hat, Inc.

Privacy Policy | Term of Use | Posting Guidelines | Archive | Contact Us | Founding Members

Powered by vBulletin® Copyright ©2000 - 2012, vBulletin Solutions, Inc.

FedoraForum is Powered by RedHat