Re: MySQL daemons restarting every 7 minutes

2011-09-09 Thread Suresh Kuna
can you check for any table crashes in the db by using mysqlcheck. and enable the general log for the database. On Fri, Sep 9, 2011 at 10:37 PM, wrote: > No need for that really is there? I posted what was requested. > The part for the shutdown: > > 110909 17:27:31 InnoDB: Starting shutdown...

Re: Update on inner join - looks good to me, where did I go wrong?

2011-09-09 Thread Carsten Pedersen
`userTable.userid` => `userTable`.`userid` / Carsten On 09-09-2011 23:01, Dotan Cohen wrote: Now that I've got the syntax right, MySQL is complaining that a field does not exist, which most certainly does: mysql> UPDATE -> `userTable` -> INNER JOIN `anotherTable` ->ON `u

Re: Update on inner join - looks good to me, where did I go wrong?

2011-09-09 Thread Dotan Cohen
Now that I've got the syntax right, MySQL is complaining that a field does not exist, which most certainly does: mysql> UPDATE -> `userTable` -> INNER JOIN `anotherTable` -> ON `userTable.userid`=`anotherTable.userid` -> SET `userTable.someField`="Jimmy Page" -> WHERE `userT

Update on inner join - looks good to me, where did I go wrong?

2011-09-09 Thread Dotan Cohen
I'm trying to update on an join, but I can't find my error: UPDATE `userTable` SET `someField`="Jimmy Page" FROM `userTable` INNER JOIN `anotherTable` ON `userTable.userid`=`anotherTable.userid` WHERE `userTable.someField`="Jim Morrison" AND `anotherTable.date` < NOW(); ERROR 1064 (42000): Yo

Re: MySQL daemons restarting every 7 minutes

2011-09-09 Thread a . smith
No need for that really is there? I posted what was requested. The part for the shutdown: 110909 17:27:31 InnoDB: Starting shutdown... 110909 17:27:32 InnoDB: Shutdown completed; log sequence number 1589339 110909 17:27:32 [Note] /usr/local/libexec/mysqld: Shutdown complete 110909 17:27:32 mys

Re: MySQL daemons restarting every 7 minutes

2011-09-09 Thread Reindl Harald
jesus christ can you post a WHOLE log this is only a normal start, there is no single line about stop Am 09.09.2011 18:30, schrieb a.sm...@ukgrid.net: > Yep, but its basically identical to the info in the logs when its restarting > itself. I have upgraded to MySQL 5.5 > as of yesterday, so the er

Re: MySQL daemons restarting every 7 minutes

2011-09-09 Thread a . smith
Yep, but its basically identical to the info in the logs when its restarting itself. I have upgraded to MySQL 5.5 as of yesterday, so the error info differs due to the version now. Here is the log output: 110909 17:27:35 mysqld_safe Starting mysqld daemon with databases from /var/db/mysql

Binary builds for AIX

2011-09-09 Thread Peter Gershkovich
I noticed that there is no binary builds for AIX any more. What would be the best way to install a current version of MySQL (5.5) on AIX? Specifically I am looking for instructions for AIX 6.1 and/or 7.1 Thanks, Peter -- MySQL General Mailing List For list archives: http://lists.mysql.com/mys

Re: MySQL daemons restarting every 7 minutes

2011-09-09 Thread Suresh Kuna
can you remove it from service and start it normally using mysqld_safe with log warnings enabled in the cnf file. On Fri, Sep 9, 2011 at 4:16 PM, wrote: > Hi, > > that really is the complete error log, that exact same info gets repeated > over and over, there is zero in the syslog and I get thi

Re: strange mysql update ..

2011-09-09 Thread Derek Downey
Try searching for a row that has a login_date of '-00-00 00:00:00' - Derek On Sep 9, 2011, at 8:52 AM, umapathi b wrote: > Any update from anybody ? > > > -- Forwarded message -- > From: umapathi b > Date: Thu, Sep 8, 2011 at 4:28 AM > Subject: Re: strange mysql update ..

Fwd: strange mysql update ..

2011-09-09 Thread umapathi b
Any update from anybody ? -- Forwarded message -- From: umapathi b Date: Thu, Sep 8, 2011 at 4:28 AM Subject: Re: strange mysql update .. To: Ananda Kumar Cc: mysql@lists.mysql.com Here is the o/p after the update .. user_id: 16078845 drivers_license: TEST1140D

Technofloor

2011-09-09 Thread Technofloor
/*--Text Styles--*/ .ws6 {font-size: 8px;} .ws7 {font-size: 9.3px;} .ws8 {font-size: 11px;} .ws9 {font-size: 12px;} .ws10 {font-size: 13px;} .ws11 {font-size: 15px;} .ws12 {font-size: 16px;} .ws14 {font-size: 19px;} .ws16 {font-size: 21px;} .ws18 {font-size: 24px;} .ws20 {font-size

Re: MySQL daemons restarting every 7 minutes

2011-09-09 Thread a . smith
Hi, that really is the complete error log, that exact same info gets repeated over and over, there is zero in the syslog and I get this behaviour when running with no my.cnf (I do obviously have one but I tried without and it I still see the prob, so that probably makes things easier fr

Re: running a duplicate database

2011-09-09 Thread Rik Wasmus
> Am 09.09.2011 11:09, schrieb Dave Dyer: > > Is there a halfway house between a single database and a full > > master-slave setup? > > > > I have a database with one "piggish" table, and I'd like to direct > > queries that search the pig to a duplicate database, where it won't > > affect all the

Re: running a duplicate database

2011-09-09 Thread Reindl Harald
Am 09.09.2011 11:09, schrieb Dave Dyer: > Is there a halfway house between a single database and a full master-slave > setup? > > I have a database with one "piggish" table, and I'd like to direct queries > that search the pig to a duplicate database, where it won't affect all the > routine tr

running a duplicate database

2011-09-09 Thread Dave Dyer
Is there a halfway house between a single database and a full master-slave setup? I have a database with one "piggish" table, and I'd like to direct queries that search the pig to a duplicate database, where it won't affect all the routine traffic. I could definitely do this by setting up a