Fedora Linux Support Community & Resources Center
  #1  
Old 12th September 2008, 11:46 AM
MichaelS-R Offline
Registered User
 
Join Date: Sep 2004
Location: Berkshire, UK
Posts: 168
Moving MySQL datadir

I am trying to move my MySQL datadir. my.cnf is now:
Code:
[mysqld]
datadir=/mnt/data1/mysql
socket=/mnt/data1/mysql/mysql.sock
user=mysql
# Default to using old password format for compatibility with mysql 3.x
# clients (those using the mysqlclient10 compatibility package).
old_passwords=1

[mysqld_safe]
log-error=/var/log/mysqld.log
pid-file=/var/run/mysqld/mysqld.pid
This all seemed pretty straightforward but I now cannot get mysqld to start (or can I?). It is really not clear what is happening - when I run mysqld_safe I get the error message: A mysqld process already exists. service mysqld stop produces a Stopping MySQL: [ OK ] message.

I am really confused as to what is going on - help greatly appreciated!

I also get constant SELinux errors (currently in permissive mode so should not actually be stopping it) and cannot work out what to do about them at all..

Thanks,

Michael
__________________
Michael S-R

F12 x86_64 -
Dual Opteron 280, Tyan Thunder K8WE (SCSI), 4Gb RAM, 2 x 36Gb Raptor, 3Ware 9500S RAID controller with 5T HDs, GeForce 6600. :cool:
Reply With Quote
  #2  
Old 12th September 2008, 01:08 PM
MichaelS-R Offline
Registered User
 
Join Date: Sep 2004
Location: Berkshire, UK
Posts: 168
Ok - new development. It appears that the server is running correctly now (mysqld_safe never exits) BUT... connecting requires that I specify the mysql.sock file or it does not work (I copied /mnt/data1/mysql/mysql.sock from the my.conf file). What am I missing?

Thanks,

Michael
__________________
Michael S-R

F12 x86_64 -
Dual Opteron 280, Tyan Thunder K8WE (SCSI), 4Gb RAM, 2 x 36Gb Raptor, 3Ware 9500S RAID controller with 5T HDs, GeForce 6600. :cool:
Reply With Quote
Reply

Tags
datadir, moving, 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
Problems moving MySQL data dir KhaiPi Using Fedora 1 15th February 2009 01:44 AM
Moving mysql to a new server GrandpaGenocide Using Fedora 0 15th October 2007 12:55 AM
changing datadir for mysql 5.0.27 csfalcon Using Fedora 3 5th February 2007 11:11 PM
Problems moving MySQL data dir KhaiPi Using Fedora 1 6th December 2006 01:35 PM


Current GMT-time: 00:33 (Tuesday, 21-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
Golden Gate - Hafizabad Travel Photos - Okara Travel Photos