RE: MySQL configuring on Linux

[J.R. Bullington]

Windows has always been more graphical. For Linux, depending on the version 
that you have downloaded
(binary v. source) you have to do very little to configure it for a dedicated 
server. Check out the
my.cnf files in the /support-files/ folder of your MySQL installation. Use 
these as a guideline. The
more RAM you have or the more dedicated you want the server, the different 
my.cnf files that you
want to copy to /etc/my.cnf

For Small Servers (256 - 512 RAM) or Development, use:
shell cp /usr/local/mysql/support-files/my-small.cnf /etc/my.cnf

For Medium Servers (512 - 1GB RAM) or Server, use:
shell cp /usr/local/mysql/support-files/my-medium.cnf /etc/my.cnf

For Large Servers (1GB - 2GB RAM) or Dedicated, use:
shell cp /usr/local/mysql/support-files/my-large.cnf /etc/my.cnf

For Extra Large Servers ( 2GB RAM ) running only MySQL, use:
shell cp /usr/local/mysql/support-files/my-huge.cnf /etc/my.cnf


Each of these can be found in the my-(small, medium, large, huge).cnf files. 
They are commented out
sections. There is nothing new that you need to download.

Also, make sure you read the manual and installation instructions. All of this 
information and more
is located in there.

J.R.

-Original Message-
From: Danesh Daroui [mailto:[EMAIL PROTECTED] 
Sent: Tuesday, November 23, 2004 10:18 AM
To: [EMAIL PROTECTED]
Subject: MySQL configuring on Linux

Hi all,

I have installed MySQL Server 4.1.7 on both my Windows XP and Linux Fedore Core 
3 systems. It was
amazing that everything can be configured in a visual way and it is almost 
ready to use after
installation when install it on Windows XP and I could even change the way 
thatI want to use MySQL
server if it is Developing, Sever or Dedicated Server. But when I installed 
MySQL Server 4.1.7 on my
Linux system, I couldn't configure it as Windows XP. It just installed and 
there was not any
configuration window or anything elase. How can I configure my Linux server for 
example to act as
Dedicated server ? Is there any extra program for Linux so I have to download ?

Thanks,

Danesh Daroui



--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]



-- 
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

RE: MySQL configuring on Linux

[J.R. Bullington]

This error results from Berkley Databases (bdb) not being enabled. This is 
normally OK (unless you
want to use them), but it seems as though your have it set in your my.cnf file 
to have them enabled
and not in MySQL. Go back into your my.cnf file and put a '#' in front of all 
the bdb and innodb
configuration options.
 
Secondly, the socket will be missing as it is a temp. file that is created and 
deleted whenever the
server is started or shut down. It will be recreated when the server is 
restarted.
 
J.R.

  _  

From: Danesh Daroui [mailto:[EMAIL PROTECTED] 
Sent: Tuesday, November 23, 2004 1:30 PM
To: J.R. Bullington
Subject: Re: MySQL configuring on Linux


I just did it and configured it to be a Server but after all when I restarted 
mysqld I got this
error:

shell Can't connect to local mysql server throught socket 
'var/lib/mysql/mysql.sock' 

I also checked and socket files has been deleted. There was aölso an error log 
and there was:

unknown argument bdb_cache_size=4 MB

or something like that ? How can I re-generate socket file ? Why the original 
configuration for
Server has errors in it ?