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...
`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
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
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
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
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
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
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
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
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 ..
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
/*--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
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
> 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
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
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
16 matches
Mail list logo