Usually this is caused by DNS-based authentication, where the
reverse-DNS lookups are hanging for one reason or another.
If you can, switch to IP-based authentication and use --skip-name-resolve.
/ Carsten
On 05.01.2011 08:26, Yogesh Kore wrote:
Hi,
What is unauthenticated user seen in
Good day all
I am hoping that someone can assist me here.
As per a client requirement, I am writing a
script/stored procedure combination in order to do the following:
- Script to be run within a cron once a day
according to a set
Hi,
Use the mysql event scheduler instead of cron, the bash script is quite
pointless, and call your stored procedure with now() - interval 1 day
parameter.
Peter
On 01/05/2011 11:00 AM, Machiel Richards wrote:
Good day all
I am hoping that someone can assist me here.
HI
How do I use the mysql event scheduler?
I have not used this as yet so not sure how to use it.
Regards
Machiel
-Original Message-
From: petya pe...@petya.org.hu
To: Machiel Richards machi...@rdc.co.za, mysql@lists.mysql.com
Subject: Re: Stored procedure
Date: Wed, 05
http://dev.mysql.com/doc/refman/5.1/en/events.html
On 01/05/2011 12:21 PM, Machiel Richards wrote:
HI
How do I use the mysql event scheduler?
I have not used this as yet so not sure how to use it.
Regards
Machiel
-Original Message-
*From*: petya pe...@petya.org.hu
Hey,
happy new year and I do have a question what might be the best way to
migrate some different databases to a new central server.
The question came up as I wanted to put our web CMS database on our
newer master/slave mysql installation.
We run red hat el 4 and 5 right now, so the source db
On 1/4/2011 23:23, James Dekker wrote:
Peter,
Thanks for the response!
Unfortunately, that worked but a new error arose:
check the manual that corresponds to your MySQL server version for the right
syntax to use near 'ID = (select max(CONVERT(id_field, signed)) from
my_table_t)' at line 1
Because some sequence tables contain one to many cardinality and MySQL tables
can only have one auto_increment column...
Is there a way to do what I am trying to do (obtain max sequence id, set it to
its corresponding table, and then increment by one) in a stored function?
Happy programming,
On 1/5/2011 13:31, James Dekker wrote:
Because some sequence tables contain one to many cardinality and MySQL tables
can only have one auto_increment column...
Is there a way to do what I am trying to do (obtain max sequence id, set it to
its corresponding table, and then increment by one) in