RE: MySQL Error#: 2002

2013-03-21 Thread Stillman, Benjamin
Assuming you copied and pasted the error, it looks like the host made a typo in the config file: '/var/lib/myswl/mysql.sock' Should probably be mysql, not myswl. -Original Message- From: Rick James [mailto:rja...@yahoo-inc.com] Sent: Monday, March 18, 2013 3:32 PM To: Patrice Olivier

Re: Foreign key on multiple columns

2013-03-21 Thread Abhishek Choudhary
>      CREATE TABLE test2 ( >        ID INT NOT NULL AUTO_INCREMENT, >        col1 INT NOT NULL, >        col2 INT NOT NULL, >        PRIMARY KEY (ID), >        CONSTRAINT fk FOREIGN KEY (col1, col2) >                      REFERENCES test1(ID, ID) >        ON UPDATE CASCADE >        ON DELETE RESTR

Re: Foreign key on multiple columns

2013-03-21 Thread shawn green
On 3/21/2013 12:43 PM, Abhishek Choudhary wrote: CREATE TABLE test2 ( ID INT NOT NULL AUTO_INCREMENT, col1 INT NOT NULL, col2 INT NOT NULL, PRIMARY KEY (ID), CONSTRAINT fk FOREIGN KEY (col1, col2) REFERENCES test1(ID, ID

compiling mysql-5.6.10 on solaris10 64bit sparc

2013-03-21 Thread Felix
Hi, Im trying to compile mysql-5.6.10 for Solaris10 for sparc, I used the following parameters for cmake to get it to work, but at 80% the compilation fails. WITH_INNOBASE_STORAGE_ENGINE=1 DEFAULT_CHARSET=utf8 CMAKE_C_FLAGS="-m64" CMAKE_C_COMPILER=/opt/csw/bin/gcc CMAKE_CXX_FLAGS="-m64" CMAKE_CXX

Re: Foreign key on multiple columns

2013-03-21 Thread Peter Brawley
On 2013-03-21 8:12 AM, Norah Jones wrote: I'm trying to create a foreign key on two columns but getting error... Here's what I tried: CREATE TABLE test2 ( ID INT NOT NULL AUTO_INCREMENT, col1 INT NOT NULL, col2 INT NOT NULL, PRIMARY KEY (ID), CONSTRAINT f

Re: Promoting MySQL 5.5 slave to master

2013-03-21 Thread Miguel Gonzalez
- Mensaje original - De: Manuel Arostegui Para: Miguel Gonzalez CC: mysql@lists.mysql.com Enviado: Jueves 21 de marzo de 2013 9:17 Asunto: Re: Promoting MySQL 5.5 slave to master 2013/3/21 Miguel Gonzalez > > > > Can you elaborate about this? I thought that once you fixed the issue

Re: Promoting MySQL 5.5 slave to master

2013-03-21 Thread Miguel Gonzalez
>[AM] If you've the option to use MySQL 5.6 then managing replication is a lot >simpler and more reliable... >http://www.clusterdb.com/mysql-replication/mysql-5-6-ga-replication-enhancements/ >MySQL 5.6 Failing over is described in section 5 of >http://www.mysql.com/why-mysql/white-papers/my

RE: Promoting MySQL 5.5 slave to master

2013-03-21 Thread Andrew Morgan
> -Original Message- > From: Miguel Gonzalez [mailto:miguel_3_gonza...@yahoo.es] > Sent: 21 March 2013 08:29 > To: Manuel Arostegui > Cc: mysql@lists.mysql.com > Subject: Re: Promoting MySQL 5.5 slave to master > > > > > > - Mensaje original - > De: Manuel Arostegui > Para:

Re: Promoting MySQL 5.5 slave to master

2013-03-21 Thread Manuel Arostegui
2013/3/21 Miguel Gonzalez > > > > Can you elaborate about this? I thought that once you fixed the issues in > the master server you needed to set it as slave of the new promoted master > server, and do the other way round. > > That's why you might want to have master-master replication to avoid t

Re: Promoting MySQL 5.5 slave to master

2013-03-21 Thread Manuel Arostegui
2013/3/21 Miguel González Castaños > Dear all, > >I have a pretty simple setup. A LAMP server in production and a > failover LAMP server in case the main server is down. > >I have been searching around to find out a clear answer of how to > proceed when you need to promote a MySQL 5.5 sla