Re: my.cnf authencication

- Original Message - > From: "Harrie Robins" > Subject: my.cnf authencication > > mysqldump --defaults-file dbase > c:\sql\dbase.sql 2>> c:\log.tct Might just be a typo in your mail, but you'll need to actually pass the defaults-file, too:

RE: my.cnf authencication

ump] in the cnf Thanks -Original Message- From: Johan De Meersman [mailto:vegiv...@tuxera.be] Sent: vrijdag 29 januari 2016 15:06 To: Harrie Robins <har...@eyequestion.nl> Cc: MySql <mysql@lists.mysql.com> Subject: Re: my.cnf authencication - Original Message

Re: my.cnf file

Are you show about the non-outage operation with this command? Best regards. -- Wagner Bianchi 2010/12/31 Sharl.Jimh.Tsin amoiz.sh...@gmail.com rpm -qpi mysql*.rpm | grep my.cnf Best regards, Sharl.Jimh.Tsin (From China **Obviously Taiwan INCLUDED**) 2010/12/30 Lydia Rowe

Re: my.cnf file

Please, forget my last note, I answered in a wrong thread! Sorry. Best regards. -- Wagner Bianchi 2010/12/31 Wagner Bianchi wagnerbianch...@gmail.com Are you show about the non-outage operation with this command? Best regards. -- Wagner Bianchi 2010/12/31 Sharl.Jimh.Tsin

RE: my.cnf file

Adam, you should look upon this as an opportunity to write a my.cnf that suits your application and hardware. Understanding the options in this configuration can be paramount to a well tuned server. a few resources to kick it all off...

Re: my.cnf file

I am seeing you're using an operate system based on Red Hat distro. Well, after install MySQL via yum or via rpm packages, the location of MySQL samples configuration file usually is /usr/share/mysql. After to check the existence of sample configuration files (my-huge.cnf, my-large.cnf,

Re: my.cnf file

find / -name my.cnf -- Lydia On Thu, 2010-12-30 at 11:09 -0200, Wagner Bianchi wrote: I am seeing you're using an operate system based on Red Hat distro. Well, after install MySQL via yum or via rpm packages, the location of MySQL samples configuration file usually is /usr/share/mysql.

Re: my.cnf file

rpm -qpi mysql*.rpm | grep my.cnf Best regards, Sharl.Jimh.Tsin (From China **Obviously Taiwan INCLUDED**) 2010/12/30 Lydia Rowe ly...@lydiarowe.com: find / -name my.cnf -- Lydia On Thu, 2010-12-30 at 11:09 -0200, Wagner Bianchi wrote: I am seeing you're using an operate system based on

Re: my.cnf file

michel wrote: I set up mysql and can't start it because I need to hard code the IP address parameter (bind-address) into my.cnf ... but I have three of them in different sub directories of /mysql/mysql-test/suite Should there not be one basic one?

Re: my.cnf optimization

Here's all the buffer variables: mysql show variables like '%buffer%'\G *** 1. row *** Variable_name: bulk_insert_buffer_size Value: 8388608 *** 2. row *** Variable_name:

Re: my.cnf optimization

On Thu, Sep 4, 2008 at 12:15 AM, Ryan Schwartz [EMAIL PROTECTED] wrote: We're seeing a huge surge in our qps and I'd like to make sure we're tuned as well as we can be. I'm wondering if I've got some variables maybe set too large (is that even possible?) ? We do have a fair bit of innodb, so

Re: my.cnf optimization

Ryan Schwartz wrote mysql show variables like '%buffer%'\G *** 1. row *** *** 3. row *** Variable_name: innodb_buffer_pool_size Value: 8388608 *** 4. row

Re: my.cnf optimization

On Sep 4, 2008, at 1:48 PM, Ranjeet Walunj wrote: Hi ryan. As pointed by Johnny, it is difficult to give optimization advise without exactly knowing the performance of your machine. I'm assuming you are using the machine as Database Server and not running application (Web/other) on the

Re: my.cnf optimization

On Thu, Sep 4, 2008 at 3:23 PM, Ryan Schwartz [EMAIL PROTECTED] wrote: I'll have to crack open my copy - haven't read through it in a while If you have the first edition, I recommend getting the newer one. It has a lot more tuning info. - Perrin -- MySQL General Mailing List For list

Re: my.cnf / mysqld logging

Hi, Try to enable query log. Thanks Regards Dilipkumar [EMAIL PROTECTED]: Hey there, I inherited a couple of servers that are in production but I noticed that there\'s not active logging for mysql on any of them. I looked and they don\'t have an active my.cnf file any where on the

Re: my.cnf / mysqld logging

How would I do that? I'm still a novice when it comes to many aspects of mysql. [EMAIL PROTECTED] wrote: Hi, Try to enable query log. Thanks Regards Dilipkumar [EMAIL PROTECTED]: Hey there, I inherited a couple of servers that are in production but I noticed that there\'s not

Re: my.cnf / mysqld logging

Hi, log-queries=/path/ Tom Ray [Lists] wrote: How would I do that? I'm still a novice when it comes to many aspects of mysql. [EMAIL PROTECTED] wrote: Hi, Try to enable query log. Thanks Regards Dilipkumar [EMAIL PROTECTED]: Hey there, I inherited a couple of servers that are

Re: my.cnf / mysqld logging

Hi Tom - In your my.cnf file, you need to specify that the setting you put in is for mysqld, the server process. Your file should look like so: [mysqld] log = /var/log/mysqld.log MySQL generally logs high-level info to files in the data directory: look for a file called hostname.err

Re: my.cnf not being found?

On Sun, 2006-06-04 at 23:28 +0100, Marcus Bointon wrote: On the same OS X machine that's having prefpanel trouble with 5.0.22, I find that mysql is not loading the values set in /etc/my.cnf. The contents of the file is from another Mac that works just fine with it. The file is

Re: my.cnf not being found?

On 5 Jun 2006, at 01:52, Petr Chardin wrote: mysqld --print-defaults. That produces: mysqld would have been started with the following arguments: i.e., it's got no options at all. It is a completely default install. Any other ideas? Marcus -- Marcus Bointon Synchromedia Limited: Putting

Re: my.cnf not being found?

On 5 Jun 2006, at 03:12, Marcus Bointon wrote: Any other ideas? D'oh! I just fixed the my.cnf problems. Because of the slightly peculiar route that the my.cnf file got onto my MacBook, it had somehow had its line breaks translated to Mac format, and it seems MySQL doesn't like that. I

Re: my.cnf files

Hello. Example files are usually shipped with MySQL distribution. Check the support-files directory for my-*.cnf examples. Search in archives at http://list.mysql.com/mysql as well. Philip R. Thompson wrote: Hi all. I am having some troubles with what should be contained within my my.cnf

Re: ~/.my.cnf syntax for multiple MySQL user accounts per login account?

I think I'd probably set up aliases that invoke mysql or mysqladmin with a --defaults-extra-file option that contains the username/password for the appropriate account. At 16:39 -0600 10/2/05, s. keeling wrote: I've checked everywhere I can find (Paul DuBois' MySQL, ML archives,

Re: ~/.my.cnf syntax for multiple MySQL user accounts per login account?

Incoming from Paul DuBois: At 16:39 -0600 10/2/05, s. keeling wrote: The admin account, with no password, doesn't function at all. perl programs appear to ignore ~/.my.cnf forcing me to open() them and slurp username and password that way. How is this supposed to work? Surely, you're

Re: ~/.my.cnf syntax for multiple MySQL user accounts per login account?

At 18:50 -0600 10/2/05, s. keeling wrote: Incoming from Paul DuBois: At 16:39 -0600 10/2/05, s. keeling wrote: The admin account, with no password, doesn't function at all. perl programs appear to ignore ~/.my.cnf forcing me to open() them and slurp username and password that way.

Re: ~/.my.cnf syntax for multiple MySQL user accounts per login account?

Incoming from Paul DuBois: At 18:50 -0600 10/2/05, s. keeling wrote: Groan. More stuff to learn, configure, maintain, and memorize. I'm trying to replicate Unix's root vs. mere user security paradigm in I think your analogy is flawed. If you really want the root vs mere user

Re: my.cnf not found

Sujay Koduri wrote: hi, I tried installing MySQL4.1.13 and in the process I installed the following packages * MySQL-client-4.1.13-0.i386.rpm * MySQL-server-4.1.13-0.i386.rpm * MySQL-shared-standard-4.1.13-0.rhel3.i386.rpm I am able to make connections to mysql and able

RE: my.cnf not found

Thanks a lot stassen :) sujay -Original Message- From: Michael Stassen [mailto:[EMAIL PROTECTED] Sent: Wednesday, August 10, 2005 9:50 PM To: Sujay Koduri Cc: MySQL mailing list Subject: Re: my.cnf not found Sujay Koduri wrote: hi, I tried installing MySQL4.1.13

Re: my.cnf parameter settings for 4 GB RAM

Hi. Tune key_buffer_size for it. And you may want to order commercial support to receive finetune of your server: go to https://order.mysql.com/?ref=ensita Anil Doppalapudi [EMAIL PROTECTED] wrote: please provide me listof my.cnf parameter values for 4 GB RAM . from support files i can

Re: .my.cnf

The setting in the my.cnf is just a default setting. It's impossible to have more than one default value. Whichever value you specify last is what the setting will be. When you need to connect to a second server, you need to open another client and specify the hostname you want it to connect

Re: .my.cnf

Yong, If that is the full contents of your my.cnf file, the message is self explanatory: you have not specified a [mysql] section header before you specify a recognized option. There is typically only one my.cnf file on any machine (exceptions do exist). Each my.cnf file can contain both

Re: my.cnf not read in 4.1.3

Are you sure that the server is using the my.cnf file which you are changing? After making the change, what is the output of --print-defaults for mysqld? If it's not as expected, odds are good that the server is getting its defaults from a different location. --V [EMAIL PROTECTED] wrote: Hi

Re: my.cnf not read in 4.1.3

What else is in the my.cnf file? For instance, when I run `mysqld --print-defaults` on my system I see this: mysqld would have been started with the following arguments: --basedir=/path/to/mysql-4.0 --datadir=/path/to/mysql-4.0/data --port=1032 --socket=/path/to/mysql-4.0/mysql.sock

Re: my.cnf - do we need it or not?

Not if you are are on a Win32 platform, all you need is my.ini. Otherwize with the *nix versions, you do need it. Scott Fletcher [EMAIL PROTECTED] wrote on 08/11/2004 09:35:22 AM: Hi! Do we really need the my.cnf file to tweak MySQL? Mine doesn't have it and it just work fine...

Re: my.cnf - do we need it or not?

But only if you need to change settings from the defaults. [EMAIL PROTECTED] wrote: Not if you are are on a Win32 platform, all you need is my.ini. Otherwize with the *nix versions, you do need it. Scott Fletcher [EMAIL PROTECTED] wrote on 08/11/2004 09:35:22 AM: Hi! Do we really need the

Re: my.cnf - do we need it or not?

by looking at it? (without my.cnf) Scott -Original Message- From: Michael Stassen [mailto:[EMAIL PROTECTED] Sent: Wednesday, August 11, 2004 9:12 AM To: [EMAIL PROTECTED] Cc: Scott Fletcher; [EMAIL PROTECTED] Subject: Re: my.cnf - do we need it or not? But only if you need to change settings from

Re: my.cnf Error

Mack Richardson wrote: I'm running MySQL 4.0.20 on Mac OS X 10.3.4. I've added the my.cnf to the etc directory, Which one, and why? Did you restart the server after changing my.cnf? but mySQL server returns the following error: ERROR 2002: Can't connect to local MySQL server through socket

RE: my.cnf setup

-Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] Sent: Tuesday, May 11, 2004 7:42 AM To: Dathan Vance Pattishall Subject: RE: my.cnf setup Thanks for the feedback! I have made the changes you suggested. I do have a question about the slow query log though

RE: my.cnf setup

-Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] Sent: Monday, May 10, 2004 2:23 PM To: [EMAIL PROTECTED] Subject: my.cnf setup I am running a mysql server off a Dell 2650. Dual 2.8Ghz Intel Xeon processors 1 Gig of RAM The MySQL data comes up rather

Re: my.cnf setup

[EMAIL PROTECTED] wrote: I am running a mysql server off a Dell 2650. Dual 2.8Ghz Intel Xeon processors 1 Gig of RAM The MySQL data comes up rather slowly. Would like some suggestions on my my.cnf file if you had a minute. Conner: The problem is very unlikely your my.cnf, and very likely your

RE: my.cnf Setup!!

Hello List: I have setup MySQL and it is working fine. I tested connection to MySQL. Now I have gone one step futher and added a password for mysql, as follows: shell ./mysqladmin -u root password mysqlpw Now I want to setup myc.cnf. Our SQL server is a standalone server (RH9, Dual CPU, 1.5GB

Re: my.cnf Setup!!

Kirti S. Bajwa wrote: Hello List: I have setup MySQL and it is working fine. I tested connection to MySQL. Now I have gone one step futher and added a password for mysql, as follows: shell ./mysqladmin -u root password mysqlpw Now I want to setup myc.cnf. Our SQL server is a standalone

Re: my.cnf on MySQL-Server-4.0.17

Ronan Lucio wrote: Hi All, I´m trying to do some customization in a MySQL-Server-4.0.17 to gain a better performance. We have a Intel P4-2.4 Ghz with 1 Gb RAM and 40 Gb HD on a FreeBSD-5.2.1 box dedicated for MySQL. The diagnostic error messages are a fairly strong indication that you could have

Re: my.cnf in MySQL-Server-4.0.17

Hi Ronan, Did you perhaps set MAXDSIZ is your kernel configuration above (2047UL*1024*1024) ? Ken - Original Message - From: Ronan Lucio [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: Thursday, February 19, 2004 3:06 PM Subject: my.cnf in MySQL-Server-4.0.17 Hi All, I´m trying to

RE: My.cnf

-Original Message- From: Scott Haneda [mailto:[EMAIL PROTECTED] Sent: Monday, February 02, 2004 6:13 PM To: MySql Subject: My.cnf I have copied my-large.cnf to /etc/my.conf Mysql 4 on OS X server How can I tell these new settings are in effect? What settings were run prior

Re: my.cnf on Shared Hosting

Hassan Shaikh [EMAIL PROTECTED] wrote: Hi, I want --ansi option for MySQL setting to ensure ANSI compatibility. Most shared hosting providers don't allow access to my.cnf. Is there anyway to do this on the fly in my script, PHP/Perl sample would be appreciated. You can do it only from

Re: my.cnf

Hi, Look at /usr/local/mysql/support-files directory. There are several examples of my.cnf files for different configurations there (my-huge.cnf, my-large.cnf, ...). Best regards, Mikhail. - Original Message - From: Kirti S. Bajwa [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: Friday,

Re: my.cnf

The correct entries for your my.cnf will vary depending on which features that you want to support. There is no standard contents. See the manual for the chapters on installation, configuration and optimization. Most distributions come with sample cnf files called: my-huge.cnf, my-large.cnf,

Re: My.cnf

At 14:17 -0500 11/24/03, Arnoldus Th.J. Koeleman wrote: I like to install the my.cnf in another directory and not the default /etc/my.cnf When I move this file to another directory it can't start anymore. Is there a way to install my.cnf in a different location and which file need to be

Re: My.cnf

Paul DuBois wrote: At 14:17 -0500 11/24/03, Arnoldus Th.J. Koeleman wrote: I like to install the my.cnf in another directory and not the default /etc/my.cnf When I move this file to another directory it can't start anymore. Is there a way to install my.cnf in a different location and which file

Re: My.cnf

Paul DuBois wrote: At 14:17 -0500 11/24/03, Arnoldus Th.J. Koeleman wrote: I like to install the my.cnf in another directory and not the default /etc/my.cnf When I move this file to another directory it can't start anymore. Is there a way to install my.cnf in a different location and which file

Re: My.cnf

Paul DuBois wrote: Paul DuBois wrote: At 14:17 -0500 11/24/03, Arnoldus Th.J. Koeleman wrote: I like to install the my.cnf in another directory and not the default /etc/my.cnf When I move this file to another directory it can't start anymore. Is there a way to install my.cnf in a different

Re: My.cnf

At 14:37 -0600 11/24/03, John Nichel wrote: Paul DuBois wrote: Paul DuBois wrote: At 14:17 -0500 11/24/03, Arnoldus Th.J. Koeleman wrote: I like to install the my.cnf in another directory and not the default /etc/my.cnf When I move this file to another directory it can't start anymore. Is

Re: My.cnf

Paul DuBois wrote: At 14:37 -0600 11/24/03, John Nichel wrote: Paul DuBois wrote: Paul DuBois wrote: At 14:17 -0500 11/24/03, Arnoldus Th.J. Koeleman wrote: I like to install the my.cnf in another directory and not the default /etc/my.cnf When I move this file to another directory it can't

Re: My.cnf

When you do a mysqld -? it will say: Default options are read from the following files in the given order: /etc/my.cnf /var/lib/mysql/my.cnf~/.my.cnf So that's the reason you can not start it anymore. (I'm using 4.1.0-alpha.) Hope this helps. Peter Sap. - Original Message

Re: My.cnf

You could install version 3.23 under a different username (like mysql323) than the 4.0 version (like username mysql40). Then put each .my.cnf in the ~ directory. Regards, Peter Sap - Original Message - From: Arnoldus Th.J. Koeleman [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: Monday,

Re: My.cnf

Not correct. The manual explains how. Use separate data directories, and put the my.cnf files in the data directories. Arnoldus Th.J. Koeleman wrote: I wanna deploy two different Mysql versions 3.23 and 4.0 As far as I understand this is not possible am I correct?? Since both version

RE: My.cnf

don't forget to change the port number that the server is listening on if you plan on running them simultaneously -Original Message- From: Peter Sap [mailto:[EMAIL PROTECTED] Sent: Monday, November 24, 2003 4:59 PM To: [EMAIL PROTECTED] Subject: Re: My.cnf You could install

Re: My.cnf

At 16:33 -0500 11/24/03, Arnoldus Th.J. Koeleman wrote: I wanna deploy two different Mysql versions 3.23 and 4.0 As far as I understand this is not possible am I correct?? No, it's perfectly possible. I have dozens of versions installed on my main machine. See the manual here:

Re: my.cnf and binary distributions

At 10:42 AM -0700 9/19/03, Jon Drukman wrote: is there any way to get mysqld 4.0.15a from the linux binary distribution to use another path for my.cnf apart from /etc/my.cnf /usr/local/mysql/data/my.cnf ~/.my.cnf No, but if you have control over how the server gets started, you can invoke it

Re: my.cnf and binary distributions

At 11:13 AM 9/19/2003, Paul DuBois wrote: At 10:42 AM -0700 9/19/03, Jon Drukman wrote: is there any way to get mysqld 4.0.15a from the linux binary distribution to use another path for my.cnf apart from /etc/my.cnf /usr/local/mysql/data/my.cnf ~/.my.cnf No, but if you have control over how the

Re: my.cnf and binary distributions

At 11:30 AM -0700 9/19/03, Jon Drukman wrote: At 11:13 AM 9/19/2003, Paul DuBois wrote: At 10:42 AM -0700 9/19/03, Jon Drukman wrote: is there any way to get mysqld 4.0.15a from the linux binary distribution to use another path for my.cnf apart from /etc/my.cnf /usr/local/mysql/data/my.cnf

Re: my.cnf memory specifications

At 9:29 AM -0700 9/11/03, Mark Kaufer wrote: I've looked and looked but really can't find an answer to this question. In my my.cnf file, these are some of the things that are specified in [mysqld]: set-variable = key_buffer=256M set-variable = table_cache=64 set-variable = sort_buffer=512K

Re: my.cnf memory specifications

On Thu, Sep 11, 2003 at 09:29:27AM -0700, Mark Kaufer wrote: I've looked and looked but really can't find an answer to this question. In my my.cnf file, these are some of the things that are specified in [mysqld]: set-variable = key_buffer=256M set-variable = table_cache=64 set-variable =

Re: my.cnf memory specifications

On Thu, Sep 11, 2003 at 12:06:23PM -0500, Paul DuBois wrote: Linux reports the threads of a process as processes. You really only have one process, with 31 threads. (Probably because a bunch of clients have connected.) So your resources are shared among the threads of the server process.

Re: my.cnf memory specifications

At 10:17 AM -0700 9/11/03, Jeremy Zawodny wrote: On Thu, Sep 11, 2003 at 12:06:23PM -0500, Paul DuBois wrote: Linux reports the threads of a process as processes. You really only have one process, with 31 threads. (Probably because a bunch of clients have connected.) So your resources are

Re: my.cnf memory specifications

By the way, Jeremy's original answer was more correct than mine, because he noted where I did not that the sort buffer is a per-client resource and is allocated once for each client -- or at least for each client that issues queries requiringn sorting, such as those with ORDER BY clauses.

RE: my.cnf memory specifications

PROTECTED] Sent: Thursday, September 11, 2003 11:30 AM To: [EMAIL PROTECTED] Subject: Re: my.cnf memory specifications By the way, Jeremy's original answer was more correct than mine, because he noted where I did not that the sort buffer is a per-client resource and is allocated once for each

Re: my.cnf memory specifications

On Thu, Sep 11, 2003 at 11:30:20AM -0700, Mark Kaufer wrote: By the way, Jeremy's original answer was more correct than mine, because he noted where I did not that the sort buffer is a per-client resource and is allocated once for each client -- or at least for each client that issues

Re: my.cnf is not available under windows 2000

Morten Gulbrandsen [EMAIL PROTECTED] 08/01/03 07:22AM Hi programmers, according to the manual, There are two option files with the same function: `C:\my.cnf', and the `my.ini' file in the Windows directory. Is it sufficient with only one of the files ? I have only my.ini For which purpose

RE: my.cnf is not available under windows 2000

Morten , The file used is my.cnf on unix and my.ini on windows. You should only have one file. Andy -Original Message- From: Morten Gulbrandsen [mailto:[EMAIL PROTECTED] Sent: 01 August 2003 14:23 To: [EMAIL PROTECTED] Subject: my.cnf is not available under windows 2000 Hi

Re: my.cnf not existing - Thx :)

Thx for the answer, found it myself too: Am Montag, 28. Juli 2003 14:22 schrieben Sie: Build the file and put it in your C:\.. You are not given a my.cnf file if you build from source, if you had used the binary file, it came with about 4 of the files and you just pick one and modify it and

Re: my.cnf and passwords

Hutchison; MySQL list Subject: Re: my.cnf and passwords Hi Chris, I believe you are looking in the wrong place. The my.cnf is used to set startup options for the mysql server or the mysql clients - refering to the client tools that come with the RDBMS. You want to look into /etc/php.ini

Re: my.cnf and passwords

Hi Chris, I believe you are looking in the wrong place. The my.cnf is used to set startup options for the mysql server or the mysql clients - refering to the client tools that come with the RDBMS. You want to look into /etc/php.ini or the config.inc.php file from phpmyadmin. Best regards

Re: my.cnf

* Paul DuBois You can relocate the data directory at server startup time with a --datadir option. But when looking for my.cnf files, the server will continue to look in the hardwired directory, if it exists. That's what that sentence means. (The server still looks in /etc/my.cnf; that

Re: my.cnf

At 10:22 +0200 6/12/03, Jon Haugsand wrote: * Paul DuBois You can relocate the data directory at server startup time with a --datadir option. But when looking for my.cnf files, the server will continue to look in the hardwired directory, if it exists. That's what that sentence means. (The

RE: my.cnf

Are you wanting to physically relocate the myd, myi and frm files to a new location? If so specify datadir in the cnf file or --datadir on the command line for mysqld. -Original Message- From: Chris McKeever [mailto:[EMAIL PROTECTED] Sent: Wednesday, June 11, 2003 10:35 AM To: [EMAIL

Re: my.cnf

At 10:34 -0500 6/11/03, Chris McKeever wrote: I have been plowing through the mysql.com resources for something regarding the run-time configuration options as well as the my.cnf. In particular, I am trying to move the entire information store to a separate hard-drive. This line confuses me: ---

Re: my.cnf optimized for InnoDB

Dobrý den, quinta-feira, 21 de novembro de 2002, 09:58:47, napsal jste: IS Hi all. IS The example mysql configuration files included in support-files directory of IS MySQL distribution are optimized for MyISAM table type. IS I want to tunnig the server optimized for InnoDB because I won't use

re: RE: my.cnf settings and running admin commands such as mysqldump

[mailto:victoria.reznichenko;ensita.net] DK Sent: Wednesday, October 23, 2002 5:28 AM DK To: [EMAIL PROTECTED] DK Subject: re: my.cnf settings and running admin commands such as DK mysqldump or m DK David, DK Wednesday, October 23, 2002, 12:23:36 AM, you wrote: DK I was wondering if someone could shed some light

re: my.cnf settings and running admin commands such as mysqldump or m

David, Wednesday, October 23, 2002, 12:23:36 AM, you wrote: DK I was wondering if someone could shed some light on setting parameters in DK my.cnf. When I set params such as user and password in my my.cnf file I DK dont need to then pass these parameters to commands such as mysqldump or DK

RE: my.cnf settings and running admin commands such as mysqldump or m

, 2002 5:28 AM To: [EMAIL PROTECTED] Subject: re: my.cnf settings and running admin commands such as mysqldump or m David, Wednesday, October 23, 2002, 12:23:36 AM, you wrote: DK I was wondering if someone could shed some light on setting parameters in DK my.cnf. When I set params such as user

Re: My.cnf problem when upgrade from 4.01 to 4.02

Sent: Saturday, July 13, 2002 7:23 AM Subject: Re: My.cnf problem when upgrade from 4.01 to 4.02 Hello, I've experienced what seems to be the same problem on Redhat 7.2. I eventually realized that in addition to the regular 4.0.2 server RPM, I had to also install the MySql-Max 4.0.2 server RPM

Re: My.cnf problem when upgrade from 4.01 to 4.02

is that Max supports also BDB tables. Regards, Heikki - Original Message - From: Michael Ivanyo [EMAIL PROTECTED] Newsgroups: mailing.database.mysql Sent: Saturday, July 13, 2002 7:23 AM Subject: Re: My.cnf problem when upgrade from 4.01 to 4.02 Hello, I've

Re: My.cnf problem when upgrade from 4.01 to 4.02

PROTECTED] To: Heikki Tuuri [EMAIL PROTECTED]; [EMAIL PROTECTED] Sent: Sunday, July 14, 2002 1:26 AM Subject: Re: My.cnf problem when upgrade from 4.01 to 4.02 Heikki, I actually upgraded from Max-3.23.51 to the 4.0.2 server. The only way I could get it to start was to comment out all

Re: My.cnf problem when upgrade from 4.01 to 4.02

Hello, I've experienced what seems to be the same problem on Redhat 7.2. I eventually realized that in addition to the regular 4.0.2 server RPM, I had to also install the MySql-Max 4.0.2 server RPM. After that, everything worked fine. I was under the impression that there would only be one

Re: my.cnf necessity

In the last episode (May 31), [EMAIL PROTECTED] said: I currently am a MySQL dba and am having issues from a security/linux administrator that doesn't want me to have access to the /etc/my.cnf. What can't I do with local database .cnf files that I can only do with my.cnf? There are no

Re: my.cnf

On UNIX and Linux machines, there are a few places that MySQL will look for your my.cnf. The are detailed at: http://www.mysql.com/doc/O/p/Option_files.html However if none of these files exist, then MySQL will use the default values assigned for all neccesary settings. You can then just create

RE: my.cnf

You have to create it yourself. The base mysql install comes with example .cnf files ( 3 I think ) -Original Message- From: Amy Zediak [mailto:[EMAIL PROTECTED]] Sent: Tuesday, May 21, 2002 1:12 PM To: [EMAIL PROTECTED] Subject: my.cnf According to the MySQL manual, the my.cnf option

RE: .my.cnf question

Yes, but that file would only have user specific information such as your password in addition to the gloabl variables read from the gloab options file ... If you want to have server specific global variables in your my.cnf file in your directory, than you need to start mysqld with --defults-file

Re: .my.cnf question

Taylor, Monday, May 13, 2002, 5:04:20 PM, you wrote: TL I have created a .my.cnf file in my home directory. When I start mysql as that user, it should read that file automatically correct? Yeah, MySQL reads user-specific options from that file. If you want to specify some global options in

Re: My.cnf and large packet size..

Hi Pete, Thanks for the answer, I will search a bit better in the MySQL manual for info about the .cnf files.. (Already did, but couldn't 123 found the information you gave me.) What I understand is that changing the packet size doesn't have a very negative impact, sounds that it works as a

Re: my.cnf file

I just looked into this myself since today was the first time I had to do anything with the configuration. The answer is, in the default installation, no conf file is created. (In my case, I mean from instllating from source rather than from binary.) So what you do is look for the

Re: my.cnf file

Also note that a search for 'my.cnf' in the online documentation section of mysql.com returns exactly zero (0) results. Hint, hint ... Les Neste 678-778-0382 http://www.lesneste.com

Re: my.cnf file

I've done that, too... but that's because MySQL's doc search engine is interpreting the . as something special. If you search for other things relating to that, you'll actually find an index saying my.cnf configuration options or syntax.. something along those lines. Weird stuff. Mike Les

Re: my.cnf optimization question ..

On Tue, Sep 11, 2001 at 03:17:47PM -0500, Weslee Bilodeau wrote: They average around 500 connections/second at any given time, two have a master/slave setup. Connections/sec or Queries/sec? That's a lot of connections per second? Can you use persistent connections? It would save a

Re: my.cnf optimization question ..

They average around 500 connections/second at any given time, two have a master/slave setup. Connections/sec or Queries/sec? That's a lot of connections per second? Can you use persistent connections? It would save a lot of overhead. Half and half, at the moment .. We had a problem

Re: my.cnf optimization question ..

On Mon, Sep 10, 2001 at 04:54:57PM -0500, Weslee Bilodeau wrote: Basic (maybe?) question on some optimal variables for MySQLd's my.cnf configuration .. Right now, I have three MySQL servers, each with 2 GB ram, dual-CPU P3 1ghz. Nice. :-) They average around 500 connections/second at

Re: my.cnf file

Hi all Is there a document available somewhere outlining some guidelines regarding what parameters should be set in the my.cnf files for the MySQL database and to what values? thanks = __ Do You Yahoo!? Get email alerts NEW webcam

Re: my.cnf file

: Wednesday, September 05, 2001 2:45 PM Subject: Re: my.cnf file Hi all Is there a document available somewhere outlining some guidelines regarding what parameters should be set in the my.cnf files for the MySQL database and to what values? thanks

  1   2   >