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 name,

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

2014-10-16 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 database

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 OK. If it

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

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 only a

[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

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 141014

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]

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: 1. I am

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 that you are

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?