Can't send messages to the mailing list

Hello, I was subscribed for a long time to MySQL general mailing list but now I see that I can't send messages to the list because they are rejected, and in the error mail message that returns, I saw that it says something about SPAM. I didn't send spam mails to the list or to somewhere else

Re: Getting single results per (left) record with INNER JOIN

Hi Nigel, all ! Nigel Peck wrote: [[...]] My query is: SELECT `People`.`person_id`, `People`.`name` FROM `People` INNER JOIN `Person_postal_addresses` ON `Person_postal_addresses`.`person_id` = `People`.`person_id` WHERE `People`.`name` REGEXP 'example'

Re: InnoDB - CREATE INDEX - Locks table for too long

Hi, I am using your procedure on MyISAM tables now and works but RENAME does not work with locked tables, (anyway it is already an atomic operation) =BARON Try something like this: create table new_table like old_table; alter table new_table add

Re: what will happen if the disk is full when mysql flush binlog to it

Hi Cui, On Sat, Mar 14, 2009 at 4:33 PM, Cui Shijun rancp...@gmail.com wrote: hi,  What will happen if the disk is full when mysql flush binlog to it?  If I use innodb engine(mysql-5.1.22) and turn on the binlog, is there any chance that mysql has data updated without binlog flushed?  

MySQL 5.1 Rolling back a transaction containing Create Alter Drop table statements

Hi, Is there any way to rollback a transaction in MySQL 5.1 that contains Create, Alter, Drop, table statements. i.e. is there any way to turn off the feature:     Statements That Cause an Implicit Commit or even remove some of the default statements that cause a commit. I tried using the

Re: MySQL 5.1 Rolling back a transaction containing Create Alter Drop table statements

On Mon, Mar 16, 2009 at 10:25 AM, Hatem Nassrat hatem.nass...@gmail.com wrote: Hi, Is there any way to rollback a transaction in MySQL 5.1 that contains Create, Alter, Drop, table statements. No. Sorry. -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To

Migrating all MySQL from Netware to Suse

Hi! Trying to migrate from Netware to Suse (SLES 10 sp 1 NOWS SBE 2). I already changed the my.cnf file: 1.added a datadir=/MySQL/data line 2.removed the comments from all INNOdb lines The tables on the Netware files are not big On the SLES server I already see a mysql folder containing

Re: Ever-shrinking disk space after repeated DB restores

OK, I found the answer. The binary log files were filling up (/usr/ local/mysql/data on OS X/mysql-bin.x). Easy fix: mysql reset master; And all the disk space is recovered On 15-Mar-09, at 10:47 AM, René Fournier wrote: It seems MySQL isn't releasing disk space on my laptop

W2008 Server Issues?

1. Any issues running MySQL Ver. X on Windows 2008 Server? 2. Running a query to list all records of about 2600 records is very slow and gets an error of Extremely High Work Load, Each record does contain 1 LONGBLOB containing small voice recording. We are using the SQL Query Browser

Re: W2008 Server Issues?

Duncan, Kurt (MCUSA) wrote: 1. Any issues running MySQL Ver. X on Windows 2008 Server? 2. Running a query to list all records of about 2600 records is very slow and gets an error of Extremely High Work Load, Each record does contain 1 LONGBLOB containing small voice recording. We are

MySQL University session on March 19: How to Use Charsets and Collations Properly

How to Use Charsets and Collations Properly http://forge.mysql.com/wiki/How_to_Use_Charsets_and_Collations_Properly This Thursday (March 19th, 14:00 UTC), Susanne Ebrecht will give a MySQL University session on How to Use Charsets and Collations Properly. Susanne works at the MySQL Support team

Can't create table

Hello, I've tried to create these 4 test tables, but when I try to create the last one, MySQL gives the following error: ERROR 1005 (HY000) at line 20: Can't create table '.\z\favorite_link.frm' (errno : 150) It seems that the foreign keys are not created well in the fourth table, and I

Re: Can't create table

Octavian Râºniþã wrote: Hello, I've tried to create these 4 test tables, but when I try to create the last one, MySQL gives the following error: ERROR 1005 (HY000) at line 20: Can't create table '.\z\favorite_link.frm' (errno : 150) It seems that the foreign keys are not created well in

Re: best mysql optimization tutorial and/or quick start guide?

- Original Message - From: Darryle Steplight dstepli...@gmail.com To: Stephen Edberg sbedb...@ucdavis.edu Cc: John G. Heim jh...@math.wisc.edu; mysql@lists.mysql.com Sent: Thursday, March 05, 2009 12:53 PM Subject: Re: best mysql optimization tutorial and/or quick start guide? High

Re: best mysql optimization tutorial and/or quick start guide?

John G. Heim wrote: - Original Message - From: Darryle Steplight dstepli...@gmail.com To: Stephen Edberg sbedb...@ucdavis.edu Cc: John G. Heim jh...@math.wisc.edu; mysql@lists.mysql.com Sent: Thursday, March 05, 2009 12:53 PM Subject: Re: best mysql optimization tutorial and/or quick