LinuxQuestions.org
Review your favorite Linux distribution.
Go Back   LinuxQuestions.org > Forums > Linux Forums > Linux - Newbie
User Name
Password
Linux - Newbie This Linux forum is for members that are new to Linux.
Just starting out and have a question? If it is not in the man pages or the how-to's this is the place!

Notices


Reply
  Search this Thread
Old 03-31-2009, 06:07 AM   #1
lakshmi4linux
LQ Newbie
 
Registered: Mar 2009
Posts: 26

Rep: Reputation: 15
How to Move the data directory of Mysql to different Location


Hi,

Please Help me on that.

I installed MySQL database in my debian box. Now,How i can locate my "data directory" of MySQL and i need to move the "data directory" alone to some other location,and MySQL need to point the data directory location.

Thanks in Advance
 
Old 03-31-2009, 07:25 AM   #2
bathory
LQ Guru
 
Registered: Jun 2004
Location: Piraeus
Distribution: Slackware
Posts: 11,882

Rep: Reputation: 1608Reputation: 1608Reputation: 1608Reputation: 1608Reputation: 1608Reputation: 1608Reputation: 1608Reputation: 1608Reputation: 1608Reputation: 1608Reputation: 1608
AFAIK in debian the directory containing the various mysql databases is /var/lib/mysql.
If you want to move that directory in another location you can create a symlink fron the new location pointing to the above dir, or start the server with the "--datadir=/path/to/new/location" option. You can change the mysql startup script to add/edit this option.

Regards
 
  


Reply


Thread Tools Search this Thread
Search this Thread:

Advanced Search

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
Location of actual mysql tables and data on RH8 rsleventhal Linux - Server 4 04-01-2008 07:30 AM
MySql Data directory SlacUser Linux - Software 5 06-19-2007 11:48 AM
MySQL data Location. AbsoluteMonkey Linux - General 2 12-22-2004 05:58 PM
SUsE 8.2 MySQL data location? xardoz Linux - General 1 04-16-2004 11:26 AM
location of MySQL Directory in Red Hat meluser Linux - Software 3 04-20-2003 12:59 PM

LinuxQuestions.org > Forums > Linux Forums > Linux - Newbie

All times are GMT -5. The time now is 01:34 PM.

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
Facebook: linuxquestions Google+: linuxquestions
Open Source Consulting | Domain Registration