Code Newbie
News     Forums     Search     Members     Sign Up    

My Code Newbie
Username

Password

Articles/Snippets
ASP Classic
ASP.NET
C
C#
C++
HTML / CSS
Java
Javascript
Linux / BSD
Perl
PHP
Python
Ruby
SQL
VB 6
VB.NET

C.N. Friends
  Planet Rome

Link to Us!
Code Newbie
  Code Newbie
    forums

Go Back   Code Forums > Systems > Linux / BSD / OS X

Reply
 
LinkBack Thread Tools Display Modes
Old 04-28-2004, 08:32 PM   #1 (permalink)
infinite_root
Registered User
 
infinite_root's Avatar
 
Join Date: Apr 2004
Posts: 26
infinite_root is on a distinguished road
moving mysql from its default directory

I am thinking of moving my database from its default directory where mysql puts on new databases. I am currently running OpenNA 1.0 and my database server may soon be out of disk space. I know I can do this thru my.cnf. Are there anything to consider execept changing the ff:

datadir=/var/lib/mysql

How about the basedir should I change it too to the desired location?

Hope you can help me.

Thanks and more power.
infinite_root is offline   Reply With Quote
Old 04-28-2004, 10:30 PM   #2 (permalink)
Admin
$_['Your_Mom'];
 
Admin's Avatar
 
Join Date: May 2002
Location: Santee
Posts: 627
Admin is on a distinguished road
why dont you shut down SQL and then move the data to a new disk and then create a link from the old destination to the new one?

ie>

mv /var/lib/mysql /local/mysql_storage
ln -s /var/lib/mysql /local/mysql_storage

then you don't need to mess w. config stuff...
__________________


Urban Clothing
Admin is offline   Reply With Quote
Old 04-28-2004, 10:32 PM   #3 (permalink)
infinite_root
Registered User
 
infinite_root's Avatar
 
Join Date: Apr 2004
Posts: 26
infinite_root is on a distinguished road
Quote:
Originally posted by Admin
why dont you shut down SQL and then move the data to a new disk and then create a link from the old destination to the new one?

ie>

mv /var/lib/mysql /local/mysql_storage
ln -s /var/lib/mysql /local/mysql_storage

then you don't need to mess w. config stuff...
Well, that sounds reasonable. I'll try that thanks.


infinite_root is offline   Reply With Quote
Reply

Bookmarks

Thread Tools
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
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Mysql nested query help! kitrak2004 Everything SQL ( MySQL, MSSQL, DB2, Postgre, Oracle, etc...) 4 08-18-2004 06:33 AM
and on to mysql .. sde Linux / BSD / OS X 2 01-18-2003 07:39 PM
mySQL Ilya020 PHP 8 01-18-2003 06:23 PM


All times are GMT -8. The time now is 01:12 PM.


Powered by vBulletin® Version 3.7.0
Copyright ©2000 - 2008, Jelsoft Enterprises Ltd.
Search Engine Optimization by vBSEO 3.0.0 RC8





Copyright © 2000-2008, Milano Interactive
Web Hosting provided by Portal 360 Web Hosting