LinuxQuestions.org
Download your favorite Linux distribution at LQ ISO.
Home Forums Tutorials Articles Register
Go Back   LinuxQuestions.org > Forums > Linux Forums > Linux - Software
User Name
Password
Linux - Software This forum is for Software issues.
Having a problem installing a new program? Want to know which application is best for the job? Post your question in this forum.

Notices


Reply
  Search this Thread
Old 07-05-2006, 01:54 PM   #1
strmtrupr2
LQ Newbie
 
Registered: Feb 2006
Posts: 2

Rep: Reputation: 0
RHEL4 and MySQL 4.1.20-1 How 2 Change DataDirectory


Hi,

I'm running RHEL4 Update 2 with the mysql-server-4.1.20-1.RHEL4.1 package.
I'm trying to change the data directory to another drive and not having any luck.

I searched for an answer to this, no luck.

Can anyone point me to a thread for help?

-Thanks!

Scott
 
Old 07-06-2006, 11:30 PM   #2
jschiwal
LQ Guru
 
Registered: Aug 2001
Location: Fargo, ND
Distribution: SuSE AMD64
Posts: 15,733

Rep: Reputation: 682Reputation: 682Reputation: 682Reputation: 682Reputation: 682Reputation: 682
Your installation probably includes a manual.pdf or manual.ps in /usr/share somewhere.
Try "rpm -ql mysql" to find where your documentation is. You should be able to make your change by editing
/etc/my.cnf. It may use the dir address of the socket location if not given explicitly (based on grepping my my.cnf file). However for RHEL4, you may also need to reconfigure the Secure Linux access settings to enable musqld to write to your new location.

Last edited by jschiwal; 07-07-2006 at 06:24 PM. Reason: fixed typo
 
  


Reply

Tags
data, directory, mysql



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
Can't change to run as user 'mysql' lostjohnny Linux - Software 9 11-21-2011 02:38 PM
MySQL 5.0 Installation in RHEL4 ljampana Linux - Software 1 05-01-2006 01:46 PM
php-mysql dependancy problem after nitemare mysql upgrade. RHEL4 andrewc Red Hat 1 01-03-2006 04:16 PM
mysql can't start when change my.conf u2911 Linux - Software 1 07-24-2004 08:49 PM
MYSQL on Slackware9.0 ./mysqld: Can't change dir to '/var/lib/mysql/' (Errcode: 13) Litn Linux - Software 2 09-02-2003 09:00 PM

LinuxQuestions.org > Forums > Linux Forums > Linux - Software

All times are GMT -5. The time now is 12:13 AM.

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