Help - Search - Members - Calendar
Full Version: MySQL Problem - Somebody Plse Help Me!!!
The Planet Forums > System Administration > Load Balancing
Kaya
Hey Guys,

I'm quite a Newbie on Linux stuff.

How can I Change my server to start up the mysqld daemon with the following paramaters in addition to any it's already starting with:

--big-tables --tmpdir=/usr/local/mysql/temp

Iwas told to logon as root and from the command line how do I proceed?

Kaya :confused:
Rob Boudrie
Log in as root and look at /etc/my.cnf

You will see lines like:

[application]
var=value
var=value

[another application]
var=value


Do a google or look up the MySql reference documentation to see what you need to set in the file to get the options you seek.
alex.davies
In /etc/my.cnf, go to the bit under

[mysqld]

And add this line:

tmpdir=/usr/local/mysql/temp

Then restart mysql.

Alex
This is a "lo-fi" version of our main content. To view the full version with more information, formatting and images, please click here.
Invision Power Board © 2001-2009 Invision Power Services, Inc.