Re: Differences between 2 MySQL instances

Information from ESET NOD32 Antivirus, version of virus signature database 5220 (20100623) __ The message was checked by ESET NOD32 Antivirus. http://www.eset.com -- John Daisley Certified MySQL 5 Database Administrator Certified MySQL 5 Developer Microsoft SQL S

Re: MySQL Upgrading

On Wed, Jun 23, 2010 at 6:33 AM, Steven Staples wrote: > Hi, > > I am looking at upgrading my servers Debian version from Etch to Lenny, and > in doing that, I think it will upgrade MySQL from 5.0.32 to the lenny > version, which is  5.0.53 (I think). > > I have also been thinking about using the

RE: Table creation fail

Actually, That table isn't supposed to have a PK, so I removed that, and it works...same effect you suggested. Thanks! From: Krishna Chandra Prajapati [mailto:prajapat...@gmail.com] Sent: Wednesday, June 23, 2010 12:29 PM To: David Stoltz Cc: mysql@lists.mysql.com Subject: Re: Table cr

Re: Table creation fail

David, You did not define a primary key for the table. The "PRIMARY KEY ( ) " is expecting a column name inside the "( )" Mike At 11:21 AM 6/23/2010, David Stoltz wrote: Hi Folks, I use an online SQL Design tool to design my tables, etc. This generates script code that I can run in phpM

Re: Table creation fail

Hi, default cannot be used with primary key. mysql> CREATE TABLE `testresults` ( -> -> `id_employees` INTEGER DEFAULT NULL , -> `id_test_test` INTEGER DEFAULT NULL , -> `testdate` DATE DEFAULT NULL , -> `result` VARCHAR( 10 ) DEFAULT NULL , -> `resultsdescription` MEDIUMTE

Table creation fail

Hi Folks, I use an online SQL Design tool to design my tables, etc. This generates script code that I can run in phpMySQL to create the tables, etc. The below code is causing an error - see below: CREATE TABLE `testresults` ( `id_employees` INTEGER DEFAULT NULL , `id_test_test` INTEGE

MySQL Upgrading

Hi, I am looking at upgrading my servers Debian version from Etch to Lenny, and in doing that, I think it will upgrade MySQL from 5.0.32 to the lenny version, which is 5.0.53 (I think). I have also been thinking about using the 'dotdeb' packages, which will upgrade it even further to 5.1.47. I

Re: MySQL Replication - Master-Slave crash

Hi Manasi, Please try with this one. Replicate_Wild_Ignore_Table = mydb\temp_.% Regards, Nilnandan Joshi Manasi Save wrote: Hi All, I have kept Replicate_Wild_Ignore_Table = mydb%.temp_% this is temporary table which i want should not be replicated. But still it is getting replicated an

MySQL Replication - Master-Slave crash

Hi All,   I have kept  Replicate_Wild_Ignore_Table = mydb%.temp_%   this is temporary table  which i want should not be replicated. But still it is getting replicated and slave is getting crashed.     any input will be a great help. --Thanks and Regards, Manasi Save Artificial Machines Private Li

Re: Differences between 2 MySQL instances

Linux I have MySQL 5.0 and under Windows MySQL 5.1 and I definitely > need to upgrade? > > There are some differences between the global variables that start with > innodb_ under Windows and Linux, but I don't know if those differences make > InnoDB to choose another index. > > Tha