MySQL error to syslog

HI, I am running MySQL 5.5.31 on FreeBSD 9.2. I have a web server with a miss-configured service that generates faulty connections. After a while, MySQl blocks any connection from the web server. At some stage, I had set-up a script that would browse syslog log and look for a string like "Host 'x

RE: MySQL Error#: 2002

o: Patrice Olivier-Wilson; mysql@lists.mysql.com Subject: RE: MySQL Error#: 2002 Check directory permissions, and check out the 'answers' in here: http://forums.mysql.com/read.php?10,284776,284936 > -Original Message- > From: Patrice Olivier-Wilson [mailto:b...@biz-comm.com] >

MySQL Error#: 2002

r via Dreamweaver, the error message is: MySQL Error#: 2002 Can't connect to local MySQL server through socket '/var/lib/myswl/mysql.sock'(111). I have one site that uses a different IP number that that site is ok. My static sites, ie, no database inclusion, are ok. Any ideas wh

RE: MySQL Error#: 2002

Check directory permissions, and check out the 'answers' in here: http://forums.mysql.com/read.php?10,284776,284936 > -Original Message- > From: Patrice Olivier-Wilson [mailto:b...@biz-comm.com] > Sent: Monday, March 18, 2013 12:05 PM > To: mysql@lists.mysql.com

DBD::mysql error

MySQL 5.5.11 Perl 5.14.0 DBI 1.616 DBD::mysql 4.018 Installing the DBD::mysql on OS X Snow Leopard 10.6.6, I ran `perl Makefile.PL` fine but `make test` produced: # make test cp lib/DBD/mysql.pm blib/lib/DBD/mysql.pm cp lib/DBD/mysql/GetInfo.pm blib/lib/DBD/mysql/GetInfo.pm cp lib/DBD/mysql/INS

Re: [PHP] mysql error

>> CREATE TABLE log (  idlog int auto_increment not null,  imepriimek >> varchar(50),  clock timestamp,  action varchar(30),  onfile >> varchar(100), filesize float(6,2), uniqueid(idlog) ); -- here is your mistake the syntax for that should be 'unique key(idlog)' if you only wanted to specify a

Re: [PHP] mysql error

On Thu, May 5, 2011 at 10:29, Grega Leskovšek wrote: > Can smbd please look  at this sentence - I got an error and do not > know how to fix it - I am still very unfamiliar with MYSQL: > > CREATE TABLE log (  idlog int auto_increment not null,  imepriimek > varchar(50),  clock timestamp,  action va

Re: MySQL Error 1045

Hi, On 21-9-2010 5:25, Tim Thorburn wrote: Ignore that ... it's amazing how you can solve problems with enough caffeine and enough time away from a computer screen >.> It's also amazing how frustrating it is for those who are searching for the problem you mentioned to only find threads with '

Re: MySQL Error 1045

Ignore that ... it's amazing how you can solve problems with enough caffeine and enough time away from a computer screen >.> On 9/20/2010 10:58 PM, Tim Thorburn wrote: Hello, A few days ago I ran into Error 1045 when attempting to add a new database user to my development machine. The erro

MySQL Error 1045

Hello, A few days ago I ran into Error 1045 when attempting to add a new database user to my development machine. The error only occurred when trying to connect to the database as a new user which I found a little odd. After searching Google I discovered that this error is caused by a time

RE: Mysql error causing database to not accept threads

f the amount of connections though. Machiel Richards MySQL DBA Relational Database Consulting -Original Message- From: joerg.bru...@sun.com [mailto:joerg.bru...@sun.com] Sent: 30 June 2010 10:53 AM To: mysql@lists.mysql.com Cc: Machiel Richards Subject: Re: Mysql error causing database t

Re: Mysql error causing database to not accept threads

Hi! Machiel Richards wrote: > [[...]] > > We received an error on a MySQL database this morning which > caused it to be unavailable for connections. > > Error: > > ERROR 1135 (0): Can't create a new thread (errno 11); if > you are not out of

RE: Mysql error causing database to not accept threads

@lists.mysql.com Subject: Re: Mysql error causing database to not accept threads Note that some of the memory settings are per connection, if you have 63 connections, you may have up to 63 copies of the buffers, and you have pretty huge buffers even with 30GB of memory. Join buffers close to 1 G

Re: Mysql error causing database to not accept threads

Note that some of the memory settings are per connection, if you have 63 connections, you may have up to 63 copies of the buffers, and you have pretty huge buffers even with 30GB of memory. Join buffers close to 1 G, tmp_table_size of 2 G, 63 connections could mean upto 63 copies of these, and

Mysql error causing database to not accept threads

Good morning all Hope everyone is well We received an error on a MySQL database this morning which caused it to be unavailable for connections. Error: ERROR 1135 (0): Can't create a new thread (errno 11); if you

XAMMP and Mysql error

Hi, From yesterday 2009-08-26 i have an error message when my computer start. The mysqld.exe crash blablabla I search on g**gle "006B8853mysqld.exe" and i find somebody in this mailing with this problem!! I don't change anything in my mysql config file, cause i didn't use mysql dur

RE: MySQL error

bali...@weizmann.ac.il] Sent: Monday, June 08, 2009 10:02 AM To: mysql@lists.mysql.com Cc: shlomit.af...@weizmann.ac.il Subject: MySQL error We are running MySQL 5.0.45 on a Linux machine. Today, when I tried to go into MySQL via the command line, I got an error message: Can't connect to lo

MySQL error

We are running MySQL 5.0.45 on a Linux machine. Today, when I tried to go into MySQL via the command line, I got an error message: Can't connect to local MySQL server through socket '/usr/local/mysql/tmp/mysql.sock' The error log was full of the following messages: InnoDB: Unable to lock ./ibd

Re: mysql error 2013 Lost connection to MySQL server during query

Per Jessen wrote: > It happened agaIn this morning, but slightly different: > > [snip] > thd=0x7fe0140c7e00 > Attempting backtrace. You can use the following information to find > out where mysqld died. If you see no messages after this, something > went terribly wrong... > Cannot determine threa

Re: mysql error 2013 Lost connection to MySQL server during query

Per Jessen wrote: > I have just discovered that my mysql server was restarted this > morning, which is what gave me the 2013. In the log I found this: [snip] It happened agaIn this morning, but slightly different: [snip] thd=0x7fe0140c7e00 Attempting backtrace. You can use the following inform

Re: mysql error 2013 Lost connection to MySQL server during query

Darryle Steplight wrote: > Hi Per, > > Maybe you need to beef up your CONNECT_TIMEOUT setting in your .my.cnf > file. Are these queries appearing in your slow query logs?What is your > LOG_QUERY_TIMES set too? > > Here are some other settings you may want to play around wtih > CONNECT_TIMEOUT >

Re: mysql error 2013 Lost connection to MySQL server during query

Hi Per, Maybe you need to beef up your CONNECT_TIMEOUT setting in your .my.cnf file. Are these queries appearing in your slow query logs?What is your LOG_QUERY_TIMES set too? Here are some other settings you may want to play around wtih CONNECT_TIMEOUT INTERACTIVE_TIMEOUT WAIT_TIMEOUT NET_WRITE_T

Re: mysql error 2013 Lost connection to MySQL server during query

The issues that we saw only came to light under stress. The application I am referring to ran under a fair bit of load at the best of times but it was during sustained spikes that the flaws in our driver made themselves apparent. Mind you, we weren't using JFS, so I'm not sure how that would have

Re: mysql error 2013 Lost connection to MySQL server during query

Michael Dykman wrote: > Given the new hardware, I'm now suspecting the RAID controller. I have > seen misconfigured RAIDs or bad RAID drivers take out a server in just > such a manner. I had a debian server connected to an EMC SAN.. As > debian isn't supported, we had this open-source driver whi

Re: mysql error 2013 Lost connection to MySQL server during query

Given the new hardware, I'm now suspecting the RAID controller. I have seen misconfigured RAIDs or bad RAID drivers take out a server in just such a manner. I had a debian server connected to an EMC SAN.. As debian isn't supported, we had this open-source driver which gave us no end of problems.

Re: mysql error 2013 Lost connection to MySQL server during query

Per Jessen wrote: > Michael Dykman wrote: > >> Have you tried running the offending SQL manually against you new >> installation? Does it come back clean in the isolated case? > > No, not manually, but the job/the SQL is run several times a day, > maybe 2-3 times per hour. I've also just run t

Re: mysql error 2013 Lost connection to MySQL server during query

Michael Dykman wrote: > Have you tried running the offending SQL manually against you new > installation? Does it come back clean in the isolated case? No, not manually, but the job/the SQL is run several times a day, maybe 2-3 times per hour. > Is there anything else which runs against this

Re: mysql error 2013 Lost connection to MySQL server during query

On Mon, May 25, 2009 at 11:19 AM, Per Jessen wrote: > Per Jessen wrote: > >> Michael Steinfeld wrote: >> >>> just a thought: Did you run "mysql_upgrade" after the import? >>> >> >> No, I didn't - I didn't think of it as I really only moved the data >> across. >> > I suspect that will solve your i

Re: mysql error 2013 Lost connection to MySQL server during query

Have you tried running the offending SQL manually against you new installation? Does it come back clean in the isolated case? Is there anything else which runs against this database at night? crons? Could you post the script that you are running to give some context to the statement which winds

Re: mysql error 2013 Lost connection to MySQL server during query

Per Jessen wrote: > Michael Steinfeld wrote: > >> just a thought: Did you run "mysql_upgrade" after the import? >> > > No, I didn't - I didn't think of it as I really only moved the data > across. > Okay, have done a mysqlcheck --check-upgrade - came back all clean. I don't see a need to run

Re: mysql error 2013 Lost connection to MySQL server during query

Michael Steinfeld wrote: > just a thought: Did you run "mysql_upgrade" after the import? > No, I didn't - I didn't think of it as I really only moved the data across. best regards Per Jessen, Zürich -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscrib

Re: mysql error 2013 Lost connection to MySQL server during query

just a thought: Did you run "mysql_upgrade" after the import? On Mon, May 25, 2009 at 10:19 AM, Per Jessen wrote: > Michael Dykman wrote: > >> It might be helpful if you could tell us how you affected your data >> migration > > Sorry, I'm not familiar with reporting problems in/on mysql. > > The

Re: mysql error 2013 Lost connection to MySQL server during query

Michael Dykman wrote: It might be helpful if you could tell us how you affected your data migration Sorry, I'm not familiar with reporting problems in/on mysql. The data migration was done with a full database dump (mysqldump) from the 32bit system, then a reload on the new 64bit system. I

Re: mysql error 2013 Lost connection to MySQL server during query

Per Jessen wrote: > This weekend we completed migrating a large(ish) mysql server from > 5.0.26 on 32bit to 5.0.51a on 64bit. Everything went relatively > smoothly, until this morning when I noticed an application had choked > on getting "Error 2013 Lost connection to MySQL server during query".

mysql error 2013 Lost connection to MySQL server during query

This weekend we completed migrating a large(ish) mysql server from 5.0.26 on 32bit to 5.0.51a on 64bit. Everything went relatively smoothly, until this morning when I noticed an application had choked on getting "Error 2013 Lost connection to MySQL server during query". The application is running

Re: MySQL Error Number 1045 Access denied

o run the > > administer GUI. This should solve the problem. > > CHAVA > > On Sat, Aug 16, 2008 at 10:22 PM, AndrewMcHorney > <[EMAIL PROTECTED] <mailto:[EMAIL PROTECTED]>>wrote: > >

Re: MySQL Error Number 1045 Access denied

word and then try to run the administer GUI. This should solve the problem. CHAVA On Sat, Aug 16, 2008 at 10:22 PM, AndrewMcHorney <[EMAIL PROTECTED] <mailto:[EMAIL PROTECTED]>>wrote: Hello I am still getting

Re: MySQL Error Number 1045 Access denied

you can test with the below solution :- >>> >>> Try to reconfigure MySQL by providing the root password and >>> then >>> try to run the >>> >>> administer GUI. This should solve the problem. >>> >>> CHAVA &g

Re: MySQL Error Number 1045 Access denied

assword and then try to run the administer GUI. This should solve the problem. CHAVA On Sat, Aug 16, 2008 at 10:22 PM, AndrewMcHorney <[EMAIL PROTECTED]>wrote: Hello I am still getting the MySQL Error Number 1045 Access denied error message when running the adminstrator gui. I at

Re: MySQL Error Number 1045 Access denied

. CHAVA On Sat, Aug 16, 2008 at 10:22 PM, AndrewMcHorney <[EMAIL PROTECTED]>wrote: > Hello > > I am still getting the MySQL Error Number 1045 Access denied error message > when running the adminstrator gui. I attempted to start mysql from the dos > command line via "m

Re: MySQL Error Number 1045 Access denied

TED]>wrote: > Hello > > I am still getting the MySQL Error Number 1045 Access denied error message > when running the adminstrator gui. I attempted to start mysql from the dos > command line via "mysql" and I am getting the following. ERROR 1045 (28000): > Access

MySQL Error Number 1045 Access denied

Hello I am still getting the MySQL Error Number 1045 Access denied error message when running the adminstrator gui. I attempted to start mysql from the dos command line via "mysql" and I am getting the following. ERROR 1045 (28000): Access denied for user 'ODBC'@'lo

Re: Odd item in MySql error log

Good Morning Ben this is an acknowledged bug http://bugs.mysql.com/bug.php?id=20090 which was fixed in 5.1.22-beta + can you upgrade? Martin-- - Original Message - From: "Ben Clewett" <[EMAIL PROTECTED]> To: Sent: Friday, December 21, 2007 4:52 AM Subject: Odd item in

Odd item in MySql error log

MySql 5.0.41 SUSE 10.2 Linux dbms-04-r1 2.6.18.2-34-default #1 SMP Mon Nov 27 11:46:27 UTC 2006 x86_64 x86_64 x86_64 GNU/Linux Dear MySql, I have an odd item in my error log, I wonder if you can tell me what this means? Also whether should do anything about it? (This table once corrupted b

Re: recovering from 'disk full' mysql error

Ya, I did that. I read elsewhere that this was recommended for 4.1.9+. I did stop slave; change master to master_log_file='{Relay_Master_Log_File}', master_log_pos={Exec_master_log_pos}; start slave And it gave the same error. That is when I checked the binlogs and saw that it was corrupted at {E

Re: recovering from 'disk full' mysql error

stop slave; change master to master_log_file='Relay_Master_Log_File' , master_log_pos=Exec_master_log_pos; #Get the values for the above command from your show slave status output. start slave; The above process should fix your problem. On 9/4/07, Russell E Glaue <[EMAIL PROTECTED]> wrote: >

recovering from 'disk full' mysql error

I had a disk full error on the master MySQL (4.1.22), which was replicating to a slave (4.1.22). My question is, how do I recover a slave replica when the master had a disk full error, space was freed, but the 'disk full' issue left a corrupted master binlog? 1) Do I have to reinitialize the slav

MySQL ERROR on DELETE

Hi there ! Does anyone knows if there is a specific MySQL ERROR (SQLSATE) for DELETE of a not found key? I have tried MySQL Error 1032 e 1176 (SQLSTATE HY000) but it does not seems to work .. Thanks in advance

Re: mysql error

, Brown, Charles <[EMAIL PROTECTED]> wrote: > > Hello all. > > I noticed that the last entry in mysql error log was two weeks ago. Can > some one tell me why mysql is not writing to this log > > > This message is intended onl

Re: mysql error

Have you had any errors in the last 2 weeks? Have you restarted your server in the last 2 weeks? Your problem might just be a symptom of no problem at all. - michael On 8/20/07, Brown, Charles <[EMAIL PROTECTED]> wrote: > Hello all. > > I noticed that the last entry in mysql er

mysql error

Hello all. I noticed that the last entry in mysql error log was two weeks ago. Can some one tell me why mysql is not writing to this log This message is intended only for the use of the Addressee and may contain information that is PRIVILEGED and

Re: mysql error.

Hi Sebastian, I did not remove any ibdata files. They are present. regards anandkl On 6/21/07, Sebastian Mendel <[EMAIL PROTECTED]> wrote: very wisely taken topic "mysql error." ... Ananda Kumar schrieb: > [...] > I cleared some old bin-logs and when i restart my

Re: mysql error.

very wisely taken topic "mysql error." ... Ananda Kumar schrieb: > [...] > I cleared some old bin-logs and when i restart mysql using "mysqld_safe" > [...] > InnoDB: using the same InnoDB data or log files. > InnoDB: Unable to lock /data/mysql/ibdata1, error:

mysql error.

Hi All, In my master db, bin-log was not getting generated due to space issue, so i shut it down using 'mysqladmin shutdown". I cleared some old bin-logs and when i restart mysql using "mysqld_safe", i am getting below error. I checked for any other mysqld process, but did not find any. Please he

RE: MySQL Error for Blobs

12:46 PM > To: mysql@lists.mysql.com; [EMAIL PROTECTED] > Subject: MySQL Error for Blobs > > I got an error while entering an BMP image of 1.7MB size in a > mediumblob field through MS Access 2003 with MyODBC 3.51.12 > on Windows XP SP2 also with MySQL Query Browser > and Navi

Re: MySQL Error for Blobs

max_allowed_packet is the maximum size of a single SQL statement. It's a setting on the server, as well as for the mysql command line interface. See http://dev.mysql.com/doc/refman/5.0/en/packet-too-large.html I think 1 MB is the default; the maximum setting for MySQL 5 is 1 GB. You can adjust t

MySQL Error for Blobs

I got an error while entering an BMP image of 1.7MB size in a mediumblob field through MS Access 2003 with MyODBC 3.51.12 on Windows XP SP2 also with MySQL Query Browser and Navicat GUI tool. Navicat returned the error as 'Got a packet bigger than Max_allowed_packet bytes'. What this means?. Acces

RE: MySql Error Number 1130

Interesting. I have never heard of that option. LX09:/home/rduz/backup # mysql -p -h. --port=3307 Enter password: ERROR 2005 (HY000): Unknown MySQL server host '.' (1) Perhaps it no longer functions? Thanks. Regards, Rich > -- MySQL General Mailing List For list archives: http://lists.mysq

RE: MySql Error Number 1130

--- "Duzenbury, Rich" <[EMAIL PROTECTED]> wrote: > > > > -Original Message- > > From: Barry [mailto:[EMAIL PROTECTED] > > Sent: Thursday, April 13, 2006 9:41 AM > > To: mysql@lists.mysql.com > > Subject: Re: MySql Error Number

RE: MySql Error Number 1130

> -Original Message- > From: Barry [mailto:[EMAIL PROTECTED] > Sent: Thursday, April 13, 2006 9:41 AM > To: mysql@lists.mysql.com > Subject: Re: MySql Error Number 1130 > > Duzenbury, Rich wrote: > >>localhost means socket. > > > > > &g

Re: MySql Error Number 1130

Duzenbury, Rich wrote: localhost means socket. Hmm, I don't believe it does. localhost is a DNS shortcut to the IP address of the local machine. If that is how mysql wants to treat things, then it should issue an error message on connect because --host=localhost and --port=anything would

RE: MySql Error Number 1130

> localhost means socket. Hmm, I don't believe it does. localhost is a DNS shortcut to the IP address of the local machine. If that is how mysql wants to treat things, then it should issue an error message on connect because --host=localhost and --port=anything would then be mutually exclusive

Re: MySql Error Number 1130

Duzenbury, Rich wrote: Wow, I found the problem! I think this may be a bug. In my case, I've got three instances running on ports 3306, 3307, and 3320. On the local machine, I connect to them via mysql -p --port-3306 --host=localhost mysql -p --port-3307 --host=localhost mysql -p --port-3

RE: MySql Error Number 1130

mand line client to use the specified parms, rather than the (incorrect) socket? Thank you. Regards, Rich > -Original Message- > From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] > Sent: Wednesday, April 12, 2006 6:00 PM > To: mysql@lists.mysql.com > Subject: Re: MySql Erro

Re: MySql Error Number 1130

0 sec) HTH Keith In theory, theory and practice are the same; in practice they are not. On Wed, 12 Apr 2006, Duzenbury, Rich wrote: > To: mysql@lists.mysql.com > From: "Duzenbury, Rich" <[EMAIL PROTECTED]> > Subject: MySql Error Number 1130 > > Hi all, > >

MySql Error Number 1130

-port=3306 mysql -p --port=3307 mysql -p --port=3320 I have always been able to connect remotely from my workstation to the base server on 3306. My problem is that I cannot connect remotely to either of the new additional instances running on 3307 or 3320. Anytime I attempt to do so, I receive

Re: MySQL Error

access a local (to my home) message board, I get a black 'page' on my monitor screen with the above message (MySQL Error) on the top left of the black page. Local message board? Ethernet one or really local like 127.0.0.1? I guess the font color is white because otherwise it would be har

Re: Difficult Problem: SQLDescribeCol call on MySQL Error

Hello. I'm not a MyODBC expert and not completely sure if it is your case, but it seems that there're several bugs similar to your. See: http://bugs.mysql.com/bug.php?id=10148 You can find more by searching on the 'SQLDescribeCol' keyword in the bugs database. Check that you're using the latest

Difficult Problem: SQLDescribeCol call on MySQL Error

This call works fine on Oracle, Access, MS SQL. But Not works on MySQL. MySQL 5.0.15, MySQL ODBC drive 3.51, The OP is Windows 2000/2003, Program in VC++ In my SQLDescribeCol call on MySQL I get correct value on: ColumnName, BufferLength, NameLengthPtr, NullablePtr I get corect value on Dat

Re: MySQL error 1267: Illegal mix of collations (latin1_swedish_ci,COERCIBLE) and (utf8_general_ci,IMPLICIT) for operation 'UNION' -- again

Hello. > MySQL error 1267: Illegal mix of collations (latin1_swedish_ci,COERCIBLE) >and (utf8_general_ci,IMPLICIT) for operation 'UNION' -- again Check the character set of fields in you tables with 'SHOW CREATE TABLE' statement. I recommend you to test if the

MySQL error 1267: Illegal mix of collations (latin1_swedish_ci,COERCIBLE) and (utf8_general_ci,IMPLICIT) for operation 'UNION' -- again

Hi list, I've got a query coming out of sugarCRM that is generating this error: MySQL error 1267: Illegal mix of collations (latin1_swedish_ci,COERCIBLE) and (utf8_general_ci,IMPLICIT) for operation 'UNION' I recently converted the entire database to utf8 - made sure all the

RE: AMD64 Linux MySQL Error 1041 Out of Memory

On Thu, 2005-06-16 at 21:06, Richard Dale wrote: > > So we have recently started stress testing Mysql on an Opteron dual > CPU > > machine running Ubuntu Hoary. We are using the 64-bit GCC > > 4.0.24-standard binary from mysql. The stress test that I'm currently > > running on it involves ins

RE: AMD64 Linux MySQL Error 1041 Out of Memory

On Thu, 2005-06-16 at 21:06, Richard Dale wrote: > > So we have recently started stress testing Mysql on an Opteron dual > CPU > > machine running Ubuntu Hoary. We are using the 64-bit GCC > > 4.0.24-standard binary from mysql. The stress test that I'm currently > > running on it involves ins

Re: AMD64 Linux MySQL Error 1041 Out of Memory

Hello. MySQL on 64-bit AMD rises lots of questions. There is an Opteron HOWTO at: http://hashmysql.org/index.php?title=Opteron_HOWTO I can't give any advice except sending to the list the output of SHOW STATUS and SHOW PROCESSLIST statements performed when MySQL uses a lot of memory.

RE: AMD64 Linux MySQL Error 1041 Out of Memory

> So we have recently started stress testing Mysql on an Opteron dual CPU > machine running Ubuntu Hoary. We are using the 64-bit GCC > 4.0.24-standard binary from mysql. The stress test that I'm currently > running on it involves inserting a large database (from a mysqldump) > ... Which l

AMD64 Linux MySQL Error 1041 Out of Memory

So we have recently started stress testing Mysql on an Opteron dual CPU machine running Ubuntu Hoary. We are using the 64-bit GCC 4.0.24-standard binary from mysql. The stress test that I'm currently running on it involves inserting a large database (from a mysqldump) from three separate

Re: stability of mysql error strings

- Original Message - From: "Scott Haneda" > on 5/4/05 7:22 PM, Paul DuBois at [EMAIL PROTECTED] wrote: > > Error strings do change format sometimes. > > And they won't necessarily be in English. :-) > > I had a feeling, what is the general method most use to deal with the above > scenario?

Re: stability of mysql error strings

at my concern is, wonder what the preferred method >> to fix is, or if someone can tell me when, if ever, the error string has >> ever changed format in mysql. > > Error strings do change format sometimes. > > And they won't necessarily be in English. :-) I had a fee

Re: stability of mysql error strings

x27;ends with', so I could move to 'contains'. Anyway, I think you see what my concern is, wonder what the preferred method to fix is, or if someone can tell me when, if ever, the error string has ever changed format in mysql. Error strings do change format sometimes. And they won'

stability of mysql error strings

I have a unique key on username and email address in mysql. In my application logic, I want to test for that response on failed insert. Error number 1062 tells me there is a duplicate key, but no way to tell what key that is. The error string returned is more telling, but seems less than ideal t

mysql error nr.0

Using MySQL version 4.0, I am trying to backup my database using MySQL Administrator. When executing the backup I get error "mysql error nr.0" which doesn't tell me much. I did a Google search on the error and it didn't tell me much. Can anyone shed light on this er

RE: mysql error logging

the client side and/or middle tier anyway. Just my $0.02 worth. -Daniel. -Original Message- From: Michael Loftis [mailto:[EMAIL PROTECTED] Sent: Tuesday, March 08, 2005 2:45 PM To: mysql@lists.mysql.com Subject: mysql error logging OK I've honestly banged my head against everyi

mysql error logging

OK I've honestly banged my head against everying, but as far as I can tell MySQL has *NO* real logging support. You have three options, log everything as text, log all queries as binary, or nothing. What I want/NEED is connection logging and some sort of ERROR logging. I'm getting an increasi

RE: MySql error...

Sent: Tuesday, March 08, 2005 8:10 AM > To: [EMAIL PROTECTED]; mysql@lists.mysql.com > Subject: RE: MySql error... > > > Hi, > Have a look in the error file which is in mysql/data and called > hostname.err > > to have more information on why it is shutting down. > With that

RE: MySql error...

ley [mailto:[EMAIL PROTECTED] > Sent: Tuesday, March 08, 2005 9:12 AM > To: mysql@lists.mysql.com > Subject: RE: MySql error... > > > If you're starting the process as a non-system user then the var > directory and anything under it should be owned/writable by that user.

RE: MySql error...

ilto:[EMAIL PROTECTED] > Sent: 08 March 2005 17:40 > To: Kevin Cowley; mysql@lists.mysql.com > Subject: RE: MySql error... > > True. I forgot to mention, when doing the normal install from the tar, the > files/databases for mysql and test both refused to create, although I see > no

RE: MySql error...

-Original Message- From: Kevin Cowley [mailto:[EMAIL PROTECTED] Sent: Tuesday, March 08, 2005 9:12 AM To: mysql@lists.mysql.com Subject: RE: MySql error... If you're starting the process as a non-system user then the var directory and anything under it should be owned/writable by that use

RE: MySql error...

ent: 08 March 2005 16:44 > To: 'mel list_php'; [EMAIL PROTECTED]; mysql@lists.mysql.com > Subject: RE: MySql error... > > Hi, > I don't have an answer for you yet - but I encountered exactly the same > situation with one of my systems last weekend. Unfortunately, th

RE: MySql error...

IL PROTECTED]; mysql@lists.mysql.com Subject: RE: MySql error... Hi, Have a look in the error file which is in mysql/data and called hostname.err to have more information on why it is shutting down. With that info you usually can find more help on the mysql website. Good luck! >From: "S.Yo

RE: MySql error...

ECTED] To: mysql@lists.mysql.com Subject: MySql error... Date: Tue, 8 Mar 2005 20:01:06 +0500 (PKT) Hi, I have installed mysql on my system using tar file. But when i start mysql it generates following error and shuts down. Plz help me out to run the MySql server as i have important data on it. [EMAIL

RE: MySql error...

From: "S.Yousaf Shah" <[EMAIL PROTECTED]> Reply-To: [EMAIL PROTECTED] To: mysql@lists.mysql.com Subject: MySql error... Date: Tue, 8 Mar 2005 20:01:06 +0500 (PKT) Hi, I have installed mysql on my system using tar file. But when i start mysql it generates following error and shut

MySql error...

Hi, I have installed mysql on my system using tar file. But when i start mysql it generates following error and shuts down. Plz help me out to run the MySql server as i have important data on it. [EMAIL PROTECTED] mysql-standard-4.0.21-pc-linux-i686]# ./bin/safe_mysqld Starting mysqld daemon wit

RE: MySQL Error 1251 / phpMyAdmin

1 8 8408 4273 - Work +61 417 268 665 - Mobile +61 8 8408 4259 - Fax -Original Message- From: GH [mailto:[EMAIL PROTECTED] Sent: Tuesday, 8 February 2005 3:12 AM To: mysql@lists.mysql.com; php-general; PHP DB Subject: MySQL Error 1251 / phpMyAdmin I just installed phpMyAdmin 2.6.1 on my Wi

Re: MySQL Error 1251 / phpMyAdmin

The short answer is, download the php source and add --with-mysql=/your/path/to/mysql to your build options. The long answer is in the directions in the php manual . Michael GH wrote: I am still new to the PHP scene could you tell me how I "rebuil

Re: MySQL Error 1251 / phpMyAdmin

I am still new to the PHP scene could you tell me how I "rebuild" the PHP with the client library... On Mon, 07 Feb 2005 12:20:26 -0500, Michael Stassen <[EMAIL PROTECTED]> wrote: > > You have mysql 4.1.8, but your php was built with the library for an earlier > version, which, as the error mess

Re: MySQL Error 1251 / phpMyAdmin

You have mysql 4.1.8, but your php was built with the library for an earlier version, which, as the error message says, doesn't support the new, more secure authentication protocol. Your choices are to tell mysql to use the older, less-secure protocol, or build a copy of php using your current

MySQL Error 1251 / phpMyAdmin

I just installed phpMyAdmin 2.6.1 on my Windows Laptop with PHP Version 4.3.10 [Build Date Dec 14 2004 17:46:48] and mySql 4.1.8 I am receiving the enclosed error when I attempt to go into phpMyAdmin and do not know how to solve the issue... Any assistance would be greatful. Thank you Gary

Re: Cant connect to mysql error :20031 /10061

First, check your my.cnf file to see if you have a 'bind-address' entry. Such an entry will constrain you system only responding to machines on the same network. Failing that, have you checked you firewall settings? Are you sure that can can even reach port 3306 on that machine from the outside

Cant connect to mysql error :20031 /10061

Hi I've a question I have a delphi program that connects to a mysql database via obdc, and works perfect in the lan and in the server, I want to know if I can enter the database if I have the program installed in another city or place, I know that I have to enter the IP of the server but I've t

Re: help please !! [MySQL][ODBC 3.51Driver][mysqld-4.1.8-nt-log]Unknow MySQL error

Hello. You can enable logging on the server. See: http://dev.mysql.com/doc/mysql/en/log-files.html You need the error log, query log, slow log. But be careful! Heavy loaded server can produce a lot of messages and your files will grow quickly. If you use InnoDB, you can enable the InnoD

  1   2   3   4   >