Re: Mysql clustering

On Wed, Feb 23, 2011 at 7:53 AM, Machiel Richards wrote: >I tried to find info on the net and on the mysql website, but thus > far I haven't been able to find proper documentation on how to set > everything up. > Uhh... the documentation on the mysql site is very complete, afaik. >If s

Mysql clustering

Good day all Does anybody perhaps have a good resource or ebook on how to setup mysql clustering? I need to learn how to set this up in order to test and present to a client. I tried to find info on the net and on the mysql website, but thus far I haven't been able to find proper doc

innodb buffer pool allocation question

Does innodb buffer pool cache indexes and data in sub sets or in entirety? I've heard people mention the buffer pool allocation is dependent on the size of your tables and indexes. Kyong -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.

Re: ERROR 1005 (HY000): (errno: 150) details for show create table and innodb status given

Sorry for another email. But this is just to expand on what SHawn said..I could also have created an index and then referenced the column. So without a primary key. I can create the parent , then create the child and the index . mysql> create TABLE parent ( id int(16) , name varchar(128))ENGINE=

Re: ERROR 1005 (HY000): (errno: 150) details for show create table and innodb status given

Thanks shawn for your reply. Your simplification of the innodb status message and this post which I just read (http://lists.mysql.com/mysql/221900 ) tells me what I am doing wrong. I need the referenced column to be indexed. I guess one way of ensuring that is to declare it as a primary key . So

Re: ERROR 1005 (HY000): (errno: 150) details for show create table and innodb status given

Hello Hari, You already posted the best answer we could provide :) On 2/22/2011 13:00, hari jayaram wrote: Hi I am getting a Foreign key error . ... I have attached the create table syntax for both the parent and child tables and the innodb status below. ... mysql> show innodb status; +---

ERROR 1005 (HY000): (errno: 150) details for show create table and innodb status given

Hi I am getting a Foreign key error . The command that gives the error is ALTER TABLE child ADD CONSTRAINT child_parent_fk FOREIGN KEY (id) REFERENCES parent(id) ON DELETE NO ACTION ON UPDATE NO ACTION; And the error message is ERROR 1005 (HY000): Can't create table './testforeignkeysyntax_lap/

Illegal non geometric aswkb value found during parsing

Hello, I've migrated a MySQL 5.1.45 on Windows 2003 (32 bit) to a MySQL 5.1.55 on Windows 2008 (64 bit) by mysqldumping alla databases. All seems ok but I have a table with a column "coordinate" of type geometry on a table "address". The following query now fail: SELECT *, X(coordinate) as lon

RE: contact gives empty result

Hi Jaime, Joerg and All, Thanks for the explaining. In all those years I've never actually seen this, quite surprising actually :). In this case the comments field was empty and indeed not set. As it could be filled during the proces I'll be adding an empty string to the field. I still need to

Re: contact gives empty result

2011/2/22 Joerg Bruehe : > You have not understood the concept of NULL in SQL: > NULL does not mean "empty", it means "unknown". [...] Apart form fully agreeing with Joerg, just a tip: you can use the the IFNULL() operand as a workaround:

Re: contact gives empty result

Hi Almar, all! Almar van Pel wrote: > Hello all, > > > > I'm trying to get a TEXT field updated with its own content and an extra > string by using concat. The query looks something like this: > > > > update field_comment set field_comment = concat(field_comment, '\n > my_new_string'); >

contact gives empty result

Hello all, I'm trying to get a TEXT field updated with its own content and an extra string by using concat. The query looks something like this: update field_comment set field_comment = concat(field_comment, '\n my_new_string'); I've noticed that in this case the update doesn't work whe

Re: Mysql to Postgresql

2011/2/22 Adarsh Sharma : > Dear all, > > Today I need to back up a mysql database and restore in Postgresql database > but I don't know how to achieve this accurately. Have a look at: "mysqldump --compatible=postgresql" command:

Mysql to Postgresql

Dear all, Today I need to back up a mysql database and restore in Postgresql database but I don't know how to achieve this accurately. Can anyone kindly describe me the way to do this. Thanks & best Regards, Adarsh Sharma -- MySQL General Mailing List For list archives: http://lists.mysql.