How can we use --log-warnings

We are with mysql 4.0.17-log and we want to use --log-warnings to see aborted connections in our errorlog. We put log_warnings = 2 in our my.cnf and restarted mysql but we did not see aborted connections in our errorlog. We tried --log-warnings = 2 on the command line when we started mysql an

ms sql server to mysql migration

hello, The platform we are working is Mysql 4.1.8 version and Windows XP os. In ms sql server the space used and free space available for each database is obtained through 'sp_spaceused'procedure( built in ). Primary memory used by ms sql server and related services like query

RE: Indexing Questions (Problem?)

> >>Do I need to make a special index to index time on HOUR? > Is it even > >>possible? > > > > I believe the index on time will work for this. > > No, it won't. At least, not with the query as is: > >SELECT * FROM logs >WHERE host IN ('10.20.254.5') > AND date='2005-02-03' >

Re: Indexing Questions (Problem?)

Tom Crimmins wrote: -Original Message- From: Brad Guillory Sent: Thursday, February 03, 2005 18:15 mysql> EXPLAIN SELECT * FROM logs WHERE host in ('10.20.254.5') and date='2005-02-03' and HOUR(time) between '16' and '17' ORDER BY seq DESC; ALTER TABLE logs ADD unique (host,dat

Symchronization problem

Hi List, A have two MySQL 4.1.9 installed into two Linux servers and synchronized them, so I have now a master and slave. My problem is that since I synchronized them, I am receiving comments from my users that the speed is not good as before the synchronization. Is this possible? If yes, how and

Re: Force index

USE INDEX FORCE INDEX IGNORE INDEX See the manual for details. Michael ninjajs wrote: Hi, A table have index1 and index2. A SQL use index1 on Table A. I'd like to use index2 on Table A. How can I do for using index2? ORACLE has SQL hint which is force S

RE: Indexing Questions (Problem?)

> -Original Message- > From: Brad Guillory > Sent: Thursday, February 03, 2005 18:15 > > Please be gentle, I have nearly no experience with SQL > databases. I am > not subscribed to the list so please cc me on replies. > > Because my email client probably did horrable things to this

Force index

Hi, A table have index1 and index2. A SQL use index1 on Table A. I'd like to use index2 on Table A. How can I do for using index2? ORACLE has SQL hint which is force SQL execution plan. Thank you for your advice. -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql

Indexing Questions (Problem?)

Please be gentle, I have nearly no experience with SQL databases. I am not subscribed to the list so please cc me on replies. Because my email client probably did horrable things to this post you can find the text here also: http://nolab.org/scratch/mysql-index-oddness.html I use syslog-ng t

Re: MySQL ODBC 3.51 with alpha5.0.1 on Windows 2003

Lily Wei wrote: Hi: I have problem connect to my MySQL alpha5.0.1 server using MySQL ODBC 3.51. I got this error: That's some error! Even though MS Exchange ate your picture, I can guess what your problem is: you haven't read the documentation about MySQL-4.1 and 5.0 and the new authenticati

MySQL ODBC 3.51 with alpha5.0.1 on Windows 2003

Hi: I have problem connect to my MySQL alpha5.0.1 server using MySQL ODBC 3.51. I got this error:     Please help!   Thanks, lily

register to mail list

REGISTERED MAIL thanks, lily

Re: MySQL 5.02 on Win2K

Elim Qiu wrote: Here is where i stuck: I stopped the mysql service, renamed the 5.01 folder(backup), unzip the 5.02 and put it where 5.01 worked. I'm wondering if there are specific folder names that have "5.02" instead of "5.01"? Or registry entries? My version of MySQL doesn't have anything

Re: Rowcount?

FOUND_ROWS() Homam S.A. wrote: Is there a rowcount global variable or function in MySQL equivalent to @@rowcount in MS SQL Server that returns the number of affected rows from the last SQL statement on the current connection? Thanks! __ Do you Yahoo!? All your f

Rowcount?

Is there a rowcount global variable or function in MySQL equivalent to @@rowcount in MS SQL Server that returns the number of affected rows from the last SQL statement on the current connection? Thanks! __ Do you Yahoo!? All your favorites on on

Re: MySQL 5 ODBC error on Win2K

- SQL command on connect: left empty Note that I can connect to and manipulate the test database interactively (I added a table, inserted records, etc., all as user 'whil') 7. Hit "Test Data Source" 8. Error message: [MySQL][ODBC 3.51 Driver] Client does not support authentication proto

Re: MySQL 5.02 on Win2K

Here is where i stuck: I stopped the mysql service, renamed the 5.01 folder(backup), unzip the 5.02 and put it where 5.01 worked. Delete the data folder shipped with 5.02zip and restart the service. Since my data location is outside of the mysql installation location and this is working with my.in

Re: MySQL 5 ODBC error on Win2K

Whil Hentzen <[EMAIL PROTECTED]> wrote on 02/03/2005 11:02:48 AM: > > 1. Windows 2K and MySQL 5 > 2. Downloaded the 3.51.9 driver (I've seen a number of issues reported > with the .10 driver, so avoided it to begin with) and installed it. It > shows up in the ODBC admin nicely. > 3. Created a n

Re: MySQL 5.02 on Win2K

Elim Qiu wrote: Anyone successfully make MySQL 5.02 working on windows2000? I'm using 5.01 (work fine with me) , and tried 5.02 serveral times with no success. I'm running 5.0.2-alpha-net on W2K. Got it running without any problems. Getting ODBC to work, on the other hand, was a bit of a chore

MySQL 5.02 on Win2K

Anyone successfully make MySQL 5.02 working on windows2000? I'm using 5.01 (work fine with me) , and tried 5.02 serveral times with no success. -- No virus found in this outgoing message. Checked by AVG Anti-Virus. Version: 7.0.300 / Virus Database: 265.8.5 - Release Date: 2/3/2005 -- MySQ

Error on View

Hi, I installed the mysql 5.0.2 alpha for linux and i got an error after created a view and try to select * from the view. ERROR 2013: Lost connection to MySQL server during query Does anyone knows what is happening? Best Regards Alejandro

MySQL 5 ODBC error on Win2K

1. Windows 2K and MySQL 5 2. Downloaded the 3.51.9 driver (I've seen a number of issues reported with the .10 driver, so avoided it to begin with) and installed it. It shows up in the ODBC admin nicely. 3. Created a new file DSN with the ODBC Admin 4. After I entered a name for the dsn ("mysqlf")

RE: Syntax Failures with SELECT SUBSTRING - Help!

Try SELECT SUBSTRING(AnimalName, 1, 1) MySQL wants the "(" to immediately follow the function i.e. no spaces. -Original Message- From: Sue Cram [mailto:[EMAIL PROTECTED] Sent: Thursday, February 03, 2005 9:28 AM To: mysql@lists.mysql.com Subject: Syntax Failures with SELECT SUBSTRING - H

Syntax Failures with SELECT SUBSTRING - Help!

Neither my developer nor I can figure out this one! The package I'm using is "Animal Shelter Manager" and is written in SQL. Every other installation of the product can use the SELECT SUBSTRING command except mine! I use the following code: SELECT SUBSTRING (AnimalName, 1, 1) FROM Animal an

RE : help please : ERROR 2006: MySQL server has gone away

Hi Michael, Yesterday, I restarted the server and the mysql database. And In the errorlog, I only have 050203 00:34:14 mysqld started /u01/mysql/libexec/mysqld: ready for connections. Version: '4.0.17-log' socket: '/tmp/mysql.sock' port: 3306 Also, I verified and my mysql user have access

Re: performance on query with ORDER BY clause

Thanks for your reply, Just to be clear...performing my query without the order by clause will always return the list sorted by the primary identifier? so that SELECT SubmitId from BINDSubmit ORDER BY SubmitId == SELECT SubmitId from BINDSubmit in this case Marc Dathan Pattishall wrote: This te

Re: help please : ERROR 2006: MySQL server has gone away

So far, you have only showed us the client-view of the problem.. look in you data directories on the server machine... there is likely an error file there which should give you some insight (unless permissions for that directory are seriously messed up). IF there is no error file, determine which

help please : ERROR 2006: MySQL server has gone away

We still have the problem... In the error log, I have nothing about problem. I only have that: 050203 00:34:14 mysqld started /u01/mysql/libexec/mysqld: ready for connections. Version: '4.0.17-log' socket: '/tmp/mysql.sock' port: 3306 If I do show variables, I have max_allowed_packet = 16776

ssh connecting with a mysql client I get: ERROR 2013

ssh connecting with a mysql client gui I get: ERROR 2013 Lost connection to MySQL server during query I'm using mysqlyog and trying connect via the ssh tunnel. I can connect with out the ssh w/mysqljog OK. It's a very nice client and would like to get this working. I have googled it but nothing s

Re: mysqldump and Foreign Keys

Hello. Put SET FOREIGN_KEY_CHECKS=0 at the top of your dump file. In 4.1, mysqldump puts that automatically to the dump file. See comments at: http://dev.mysql.com/doc/mysql/en/mysqldump.html Michael Satterwhite <[EMAIL PROTECTED]> wrote: > mysqldump backs all of the tables up in alpha

Re: err-report help me

Hello. See: http://dev.mysql.com/doc/mysql/en/can-not-connect-to-server.html http://dev.mysql.com/doc/mysql/en/windows-troubleshooting.html " ???" <[EMAIL PROTECTED]> wrote: > mysql=A3=AC=C4=FA=BA=C3=A3=A1 > > =09 when click mysql.exe on $home\bin ,the report err is > "D:\Pro

Re: help please : ERROR 2006: MySQL server has gone away

Hello. Does the problem remain? What is in the error log? Please, send us information about MySQL and operating system versions. There are two variables: max_allowed_packet - one has client, another has server. Run mysql with --max_allowed_packet=16M and mysqld with the same value. May be yo

Re: Still can't connect to MySQL 5 on FC3

Hello. > [EMAIL PROTECTED] ~] /usr/bin/mysqld_safe > tee: /var/lib/mysql/mybox.err: Permission denied > -rw-rw 1 mysql root 1844 Feb 2 08:30 mybox.err It seems that you launch the mysqld_safe script as 'me' instead of root. Whil Hentzen <[EMAIL PROTECTED]> wrote: > Hi fol