LinuxQuestions.org
Review your favorite Linux distribution.
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-31-2009, 06:02 AM   #1
ziggy25
Member
 
Registered: Aug 2005
Distribution: Debian 5.2
Posts: 56

Rep: Reputation: 15
Change the default location of mysql database files


Change the default location of mysql database files
I have installed MySQL on a Linux environment. What i would like to do is create a database but i would like to place the files related to the database in a specific location away from the default mysql location.

The reason for this is that i have a specific partition /home which i never partition when i upgrade or re-install a linux distribution. Is it possible to install the database files in this partition so that if i re-install the operating system i dont have to recreate the database?

If i do re-install the operating system, i would like to just point the mysql installation on the new OS to point to the existing database files on the /home partition. Is this possible? Or are there several config files that will need modification incase of an OS re-install?

Thanks
 
Old 07-31-2009, 11:36 PM   #2
John VV
LQ Muse
 
Registered: Aug 2005
Location: A2 area Mi.
Posts: 17,622

Rep: Reputation: 2651Reputation: 2651Reputation: 2651Reputation: 2651Reputation: 2651Reputation: 2651Reputation: 2651Reputation: 2651Reputation: 2651Reputation: 2651Reputation: 2651
should be no problem to do that.Whenever i build a lamp stack i like to keep everythimg in the same folder something like
/opt/www/apache
/opt/www/mysql
... and so on

just set it up in the config files
 
1 members found this post helpful.
Old 08-18-2009, 01:15 PM   #3
ahmedhamdy27
LQ Newbie
 
Registered: Aug 2009
Posts: 2

Rep: Reputation: 1
check this page it will help you
 
Old 08-18-2009, 01:17 PM   #4
ahmedhamdy27
LQ Newbie
 
Registered: Aug 2009
Posts: 2

Rep: Reputation: 1
http://www.linux-masters.com/2009/08...-location.html
 
1 members found this post helpful.
  


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
How to change default location in flight gear sirius57 Linux - Software 0 11-24-2008 09:21 PM
How to change default smb.conf to another location UltraSoul Linux - Software 3 04-24-2008 01:01 AM
MySQL database filestorage location (how to change?) timnp Linux - Server 3 02-29-2008 05:55 AM
[SOLVED] location of tables in mysql database in linux Buddhike G Linux - Software 1 09-10-2007 05:27 AM
how to change the default mail delivery location mnisski Linux - General 3 10-21-2003 08:59 PM

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

All times are GMT -5. The time now is 01:00 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