Re: MySql - crashes daily

2010-12-03 Thread Wm Mussatto
On Fri, December 3, 2010 14:11, Basil Daoust wrote: > Any help greatly appreciated. > > Our mysql is restarting a LOT! > Here is what is in the log, it doesn't seem to give much help. > > --start of log-- > InnoDB: Warning: a long semaphore wait: > 101203 15:12:40 - mysqld got signal 11; > This

MySql - crashes daily

2010-12-03 Thread Basil Daoust
Any help greatly appreciated. Our mysql is restarting a LOT! Here is what is in the log, it doesn't seem to give much help. --start of log-- InnoDB: Warning: a long semaphore wait: 101203 15:12:40 - mysqld got signal 11; This could be because you hit a bug. It is also possible that this binary or

Re: Verifying security

2010-12-03 Thread Grant
> To verify that root has a password, do the following: > > 1) service mysql restart --skip-grant-tables > 2) In MySQL, SELECT CONCAT(,user,'''@''',host,) mysql_user,password > from mysql.user where user='root'; > This will show every host that root can login as along with the PASSWORD >

Re: Verifying security

2010-12-03 Thread Grant
> without flags to tell it otherwise, nmap only scan ports 1-1024, > higher numbered ports would have to be specified via nmap -p 1-5000 > but see how much longer it takes. Bingo. That was it. I see now that I've had port 3306 open until recently. I'm working on verifying that the mysql users h

Parameter(s) need to take care when setting replication over WAN

2010-12-03 Thread Ryan Chan
Hello, I am setting MySQL (5.0) replication over WAN for backup purpose (with SSL enabled). I have read the document: http://dev.mysql.com/doc/refman/5.0/en/replication.html, and wonder if any special tunning needed for using replication over WAN. Are there any configuration parameter(s) need s

unfortunately truncate tables

2010-12-03 Thread kranthi kiran
Hi all unfortunately some body truncate the 2 tables , in this data we did not enable log-bin file.how can recovery that data.i am using innodb engine , plz help me its urgent , thanks advance

Re: Lowest non-zero number

2010-12-03 Thread Shawn Green (MySQL)
On 12/3/2010 12:16, Mark Goodge wrote: On 03/12/2010 16:56, Paul Halliday wrote: On Fri, Dec 3, 2010 at 12:50 PM, Mark Goodge wrote: Given a table containing a range of INT values, is there any easy way to select from it the lowest non-zero number? SELECT number FROM table WHERE number> 0 OR

Re: Lowest non-zero number

2010-12-03 Thread Mark Goodge
On 03/12/2010 16:56, Paul Halliday wrote: On Fri, Dec 3, 2010 at 12:50 PM, Mark Goodge wrote: Given a table containing a range of INT values, is there any easy way to select from it the lowest non-zero number? SELECT number FROM table WHERE number> 0 ORDER BY number ASC LIMIT 1; Sorry, I

Re: Lowest non-zero number

2010-12-03 Thread Shawn Green (MySQL)
On 12/3/2010 11:50, Mark Goodge wrote: Given a table containing a range of INT values, is there any easy way to select from it the lowest non-zero number? Obviously, MAX(column) will return the highest, but MIN(column) will return 0 if any row contains a 0, which isn't what I want. Any clues?

Re: Lowest non-zero number

2010-12-03 Thread Paul Halliday
On Fri, Dec 3, 2010 at 12:50 PM, Mark Goodge wrote: > Given a table containing a range of INT values, is there any easy way to > select from it the lowest non-zero number? > SELECT number FROM table WHERE number > 0 ORDER BY number ASC LIMIT 1; ? -- Paul Halliday Ideation | Individualization |

Lowest non-zero number

2010-12-03 Thread Mark Goodge
Given a table containing a range of INT values, is there any easy way to select from it the lowest non-zero number? Obviously, MAX(column) will return the highest, but MIN(column) will return 0 if any row contains a 0, which isn't what I want. Any clues? Mark -- http://mark.goodge.co.uk --

Re: MySQL restore failing

2010-12-03 Thread Shawn Green (MySQL)
On 12/3/2010 03:40, Machiel Richards wrote: I checked now and saw that they have already attempted a restore previously and hence the original table was dropped and recreated. I found some links on the internet stating that after restoring the dump file to the new version, the proc table sh

Re: MySQL restore failing

2010-12-03 Thread Machiel Richards
I checked now and saw that they have already attempted a restore previously and hence the original table was dropped and recreated. I found some links on the internet stating that after restoring the dump file to the new version, the proc table should be dumped using the new version and reload

Re: MySQL restore failing

2010-12-03 Thread partha sarathy
In mysql 5.1, mysql.proc table contains 20 columns. Can you check your new DB again? -Partha - Original Message From: Machiel Richards To: mysql mailing list Sent: Fri, 3 December, 2010 1:38:24 PM Subject: MySQL restore failing Hi All I am hoping that someone could assist

MySQL restore failing

2010-12-03 Thread Machiel Richards
Hi All I am hoping that someone could assist me with this one. I am trying to restore a database to a new machine for testing purposes. The current machine is running mysql-5.0.72sp1 and the new machine 5.1.50. When running the restore is runs for quite a while a