Re: my.cnf not being found?

it might be that you have another my.cnf, which is also processed. Try checking the option, which are actually read by the server with "mysqld --print-defaults". Petr > Marcus > -- > Marcus Bointon > Synchromedia Limited: Putting you in the picture > [EMAIL

RE: mysqlmanager logging?

On Fri, 2006-05-05 at 15:39 -0500, Duzenbury, Rich wrote: > [mysql.server] > use-manager > > [manager] > socket=/tmp/manager.sock > pid-file=/tmp/manager.pid > monitoring-interval=30 You don't have log option specified here. Try adding log=/var/lib/mysql/mysqlman

Re: mysqlmanager logging?

As it was already advised, check the dir/log file permissions. Also, it might help if you post your my.cnf here. Petr On Wed, 2006-04-19 at 13:17 -0500, Duzenbury, Rich wrote: > MySQL 5.0.20 > > I've got two instances running with mysqlmanager. I'm not getting any &g

Re: Slow query log

On Wed, 2006-04-05 at 11:38 +0200, Mechain Marc wrote: > Is there a way to enable the Slow Query Log on the fly without having to > restart mysqld No. Petr -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

Re: Mysql compile error

or windows). The define should solve at least this particular compile failure. Petr On Wed, 2005-11-23 at 13:40 -0600, Ryan Stille wrote: > Making all in isam > make[2]: Entering directory `/usr/src/mysql-4.1.14/isam' > source='open.c' object='open.o' libtool=no \

Re: timestamp

egards, Petr -- Petr Chardin, Software Developer MySQL AB, www.mysql.com Are you MySQL certified? www.mysql.com/certification -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

RE: Timezone setting wrong?

> I've tried putting TZ = GMT and TZ = UTC into the my.cnf file but then > mysql won't even start. These should be set as environment variables, not as configuration options. You could also try setting time_zone system variable with set @@time_zone=GMT. Petr -- MySQL General

Re: Multiple my.cnf files

le my.cnf files to test ibbackup software because it does not > currently support using mysqld_multi. > CL Petr -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

Re: mysql-test-run --external?

Hello David, I think you are looking for --extern option of the test suite. I corrected the README file. The changes should be propagated to the public repository soon, but you could check the commit mail for more details right now: http://lists.mysql.com/internals/26266 Petr On Tue, 2005-06-21

Re: After upgrade to 5.03beta, mysqld won't start

[mysql] section should have > no affect on the server process and should not prevent mysqlmanager from > running. Yes, it is a bug in mysqlmanager and it is fixed in the source repository. Please upgrade to 5.0.4 when it is released. Petr -- Petr Chardin, Software Developer MySQL AB

Re: Importing a separated file into mysql, national charset problem??

2) ) I define as VARCHAR with the same length. 2) I load data into temporary table using LOAD DATA INFILE 3) I convert all "numeric" values using UPDATE TABLE temptable SET numeric_field=REPLACE(numeric_field, ',' , '.') 4) I load (or append) data from temporary table

Re: Euro Symbol (€)

| PRI | | | +--++--+-+-+---+ Test to use varchar(5) binary field type for CYSYMBOL field (if you store symbols here). Petr Vileta, Czech republic -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[

How to generate data sequences simple way?

Does anybody know how to do it? I would appreciate any hints very much. Thanks, Petr -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

SET CHARACTER SET DEFAULT is not working in 4.0.12

). It looks like SET CHARACTER SET DEFAULT isn't working (but it works in lastest 3.23). I tested this on 2 different computers with FreeBSD. >Fix: Sorry, don't know. >Submitter-Id: >Originator:petr >Organization: CD-R server s.r.o. >MySQL support: none >Synopsis

charsets

I have mysql 3.23.55 for Windows where charset "win1250ch" is included. Now I download the same version for Linux (rpm) but this charset is not included here. Why? Thank you for your quick reply. Petr Vileta, Czech Republic http://www.pra

MySQL segfaults anytime someone connects to 3306 port

>Description: After installation and setting basic authentication data I tried to connect to MySQL from other machine with the mysql client. I could not connect, I just got an error message "ERROR 2013: Lost connection to MySQL server during query" It does not matter which user, databse

Please help! I deleted all data in mysql.user table ! (SOS!)

mand: > > mysql> delete from user where host='%'; > > I have casually deleted all data in user table :((( > > > It works for now but after "reload" all data in the table will be lost ... > Can I recover the user table in such a situation ??? > &g

Re: Database Security

Hi, You can 1. set the permissions to 700. 2. chown of the script to nobody/wwwuser or whoever is the user used for the daemon httpd. You need root access to do this. Petr Svacek - |<[EMAIL PROTEC