Re: [gentoo-user] [slightly O/T] mysql problems

2014-10-17 Thread Mick
On Thursday 16 Oct 2014 07:24:43 J. Roeleveld wrote: > On Wednesday, October 15, 2014 09:40:56 PM Mick wrote: > > Well, I still have the backup from the live website, I can restore from > > it if I have to. However, what I find confusing is that the errors > > mention the live website's database

Re: [gentoo-user] [slightly O/T] mysql problems

2014-10-15 Thread J. Roeleveld
On Wednesday, October 15, 2014 09:40:56 PM Mick wrote: > On Wednesday 15 Oct 2014 13:41:03 Kerin Millar wrote: > > > Database changed > > > mysql> DROP TABLE `website1@002dnew`.`actions`; > > > > Is this a table for which it is also complaining that a corresponding > > tablespace doesn't exist in

Re: [gentoo-user] [slightly O/T] mysql problems

2014-10-15 Thread Mick
On Wednesday 15 Oct 2014 13:41:03 Kerin Millar wrote: > > Database changed > > mysql> DROP TABLE `website1@002dnew`.`actions`; > > Is this a table for which it is also complaining that a corresponding > tablespace doesn't exist in database `website1@@002dnew`? Your original > post mentioned on

Re: [gentoo-user] [slightly O/T] mysql problems

2014-10-15 Thread Kerin Millar
On 15/10/2014 13:05, Mick wrote: On Wednesday 15 Oct 2014 02:14:37 Kerin Millar wrote: On 14/10/2014 23:25, Mick wrote: On Tuesday 14 Oct 2014 21:15:48 Kerin Millar wrote: * Have you upgraded MySQL recently without going through the documented upgrade procedure? [1] I'm still o

Re: [gentoo-user] [slightly O/T] mysql problems

2014-10-15 Thread Mick
On Wednesday 15 Oct 2014 02:14:37 Kerin Millar wrote: > On 14/10/2014 23:25, Mick wrote: > > On Tuesday 14 Oct 2014 21:15:48 Kerin Millar wrote: > >> * Have you upgraded MySQL recently without going through the > >> documented upgrade procedure? [1] > > > > I'm still on mysql-5.5.39 >

Re: [gentoo-user] [slightly O/T] mysql problems

2014-10-14 Thread Kerin Millar
On 14/10/2014 23:25, Mick wrote: On Tuesday 14 Oct 2014 21:15:48 Kerin Millar wrote: On 14/10/2014 19:54, Mick wrote: # Uncomment this to get FEDERATED engine support #plugin-load=federated=ha_federated.so loose-federated As far as I recall this is a default setting. Should I change it? N

Re: [gentoo-user] [slightly O/T] mysql problems

2014-10-14 Thread Mick
On Tuesday 14 Oct 2014 21:15:48 Kerin Millar wrote: > On 14/10/2014 19:54, Mick wrote: > > # Uncomment this to get FEDERATED engine support > > #plugin-load=federated=ha_federated.so > > loose-federated > > > > As far as I recall this is a default setting. Should I change it? > > No. I presume

Re: [gentoo-user] [slightly O/T] mysql problems

2014-10-14 Thread Mick
On Tuesday 14 Oct 2014 20:21:27 Daniel Frey wrote: > On 10/14/2014 11:54 AM, Mick wrote: > > Hi All, > > > > This may be slightly off topic, but I thought of asking here first. I > > noticed two problems, one specific to a particular database, the other > > more general. In reverse order: > > >

Re: [gentoo-user] [slightly O/T] mysql problems

2014-10-14 Thread Kerin Millar
On 14/10/2014 19:54, Mick wrote: Hi All, This may be slightly off topic, but I thought of asking here first. I noticed two problems, one specific to a particular database, the other more general. In reverse order: 1. I am getting this error when I start mysqld 141014 19:41:38 [Warning] /usr/

Re: [gentoo-user] [slightly O/T] mysql problems

2014-10-14 Thread Daniel Frey
On 10/14/2014 11:54 AM, Mick wrote: > Hi All, > > This may be slightly off topic, but I thought of asking here first. I > noticed > two problems, one specific to a particular database, the other more general. > In reverse order: > > > 1. I am getting this error when I start mysqld > > 1410

[gentoo-user] [slightly O/T] mysql problems

2014-10-14 Thread Mick
Hi All, This may be slightly off topic, but I thought of asking here first. I noticed two problems, one specific to a particular database, the other more general. In reverse order: 1. I am getting this error when I start mysqld 141014 19:41:38 [Warning] /usr/sbin/mysqld: unknown option '--l