Re: Apache log errors

2008-02-25 Thread fire9
Krishna Chandra Prajapati 写道: Hi All, My web server log error is " NULL::dba can't connect to mysql" The above error shows occasionally in the error log file of apache. Every thing is fine on the mysql database server. It happens twice or thrice a day. I am not able to find out whats the issue.

Apache log errors

2008-02-25 Thread Krishna Chandra Prajapati
Hi All, My web server log error is " NULL::dba can't connect to mysql" The above error shows occasionally in the error log file of apache. Every thing is fine on the mysql database server. It happens twice or thrice a day. I am not able to find out whats the issue. Please help me. Thanks, Krish

Apache log errors

2008-02-25 Thread Krishna Chandra Prajapati
Hi All, My web server log error is " NULL::dba can't connect to mysql" The above error shows occasionally in the error log file of apache. Every thing is fine on the mysql database server. It happens twice or thrice a day. I am not able to find out whats the issue. Please help me. Thanks, Praja

Setting Variables

2008-02-25 Thread Endie
Dear all.. Does anyone know how to set variables in MySQL ideal for the performance so the machine can run maximum which variable i should be notice? what is the value of each variable? how can i calculate to get the value? is there the formula? for example: max_allowed_packet =? max_binlog_size

Re: Help with running MySQL 5 on OS X Leopard

2008-02-25 Thread Unnsse Khan
Yes, I did and what happens is that the 'xxx' becomes appended to the next line and the line after that asks the user for the password (which also fails). The way I got it working was this: mysql -u root -p Kindest regards, Unnsse On Feb 25, 2008, at 8:34 AM, fire9 wrote: Unnsse Khan 写道

Setting Variables

2008-02-25 Thread e-Ndie
Dear all.. Does anyone know how to set variables in MySQL ideal for the performance so the machine can run maximum which variable i should be notice? what is the value of each variable? how can i calculate to get the value? is there the formula? for example: max_allowed_packet =? max_binlog_size=

Re: Re-creating tables

2008-02-25 Thread Waynn Lue
The problem here though is that there is no MyTable. There are two separate tables, Users and Actions, and I can't alter both of them in the same statement, as far as I know. As a result, when I alter just Users, that fails because there's an FK between Users and Actions and the type of the two c

RE: Bogus unsubscribe!

2008-02-25 Thread Stephen Sunderlin
I got this recently and haven't replied to the list in a while. I responded to the list owner. -Original Message- From: Martijn Tonies [mailto:[EMAIL PROTECTED] Sent: Monday, February 25, 2008 12:13 PM To: mysql@lists.mysql.com Subject: Re: Bogus unsubscribe! > I just got an email fro

Re: Bogus unsubscribe!

2008-02-25 Thread Martijn Tonies
> I just got an email from the list robot asking me to confirm my request to > unsubscribe. The only problem is, I did not ask to unsubscribe! Is > anybody else getting this? It's possible that you get this because you didn't remove that particular part of the message when you replied. When a

Bogus unsubscribe!

2008-02-25 Thread Mike Spreitzer
I just got an email from the list robot asking me to confirm my request to unsubscribe. The only problem is, I did not ask to unsubscribe! Is anybody else getting this? Thanks, Mike

glabal and session variables

2008-02-25 Thread Thomas Raso
hi list I don't understand what happen in mysql 4.1.22 ! ! ! ! ! (the same in version 5.0) -bash-3.00$ mysql -e "show variables like 'wait_timeout%'" +---+---+ | Variable_name | Value | +---+---+ | wait_timeout | *30*| +---+---+ -bash-3.00$ my

Re: records ordered incorrectly

2008-02-25 Thread Dan Nelson
In the last episode (Feb 25), Saravanan said: > Hi Lists, > > I have created a procedure to calculate and update a statistics. It > works correctly. It updates daily. For a single day alone it shows > records in reverse order. For other days it shows correctly. Will > this happen? but the date wit

records ordered incorrectly

2008-02-25 Thread Saravanan
Hi Lists, I have created a procedure to calculate and update a statistics. It works correctly. It updates daily. For a single day alone it shows records in reverse order. For other days it shows correctly. Will this happen? but the date with time shows the orders in revers check the order for "

Re: Re-creating tables

2008-02-25 Thread mos
At 05:16 PM 2/24/2008, Waynn Lue wrote: That's actually why I'm dropping/recreating, because I thought the changes I have to make require multiple statements. Let me know if that's a wrong assumption, here's what I have to do. 1. drop two foreign keys from Users to Actions (in the previous exa

Re: Certified MySQL Associate (CMA) certification value

2008-02-25 Thread Baron Schwartz
Well, it sounds like something you can learn a lot from. But nobody's ever heard of it. And if you're looking to learn about MySQL in particular, I suspect you won't get much out of this; it will mostly be general knowledge. So if you're looking for a job as a MySQL DBA, I suspect this won't do

Re: Certified MySQL Associate (CMA) certification value

2008-02-25 Thread Thufir
Thanks for the input, everyone. I've gone back and am now leaning towards a VCC (Vancouver Community College) certificate: Database Developer Certificate (DDC) http://www.vcc.ca/cs/_printable-datesort.cfm? area=CSCOMPUTER&prog=DATABASE#CSCOMPUTERDATABASE What I like about this is the cumulativ