MySQL Community Server 5.5.21 has been released

2012-02-20 Thread Hery Ramilison
Dear MySQL users, MySQL 5.5.21 is a new version of the 5.5 production release of the world's most popular open source database. MySQL 5.5.21 is recommended for use on production systems. MySQL 5.5 includes several high-impact enhancements to improve the performance and scalability of the MySQL D

Re:Cant drop trigger.

2012-02-20 Thread Andrew Moore
Is there white space at the end of the trigger name? A On Feb 20, 2012 10:04 PM, "Brent Clark" wrote: > Hi Guys > > I wonder if someone could urgently help me > > Im trying to drop some triggers. But mysql says the trigger does not exist. > > I ran > > SELECT TRIGGER_SCHEMA, EVENT_OBJECT_TABLE,

Re: Design advice for hotel availability program

2012-02-20 Thread Chaim Rieger
On 2/17/2012 4:01 AM, Tompkins Neil wrote: Hi, I'm in the process of starting to design a hotel booking system that will eventually consist of over 10,000 hotels all with different room types, rates and availability for different dates. My question is does anyone have any experience with regard

Re: Design advice for hotel availability program

2012-02-20 Thread Neil Tompkins
Hi I am trying to get some background information with regards the design. I have a fair idea but would like advice from anyone that has previously worked on similar projects. On 20 Feb 2012, at 17:22, Jan Steinman wrote: > Where are your domain experts? You *are* consulting with them, no

Re: Design advice for hotel availability program

2012-02-20 Thread Claudio Nanni
Hi, Nobody answers because this is a very wide question about software engineering, Trust me, It seems like a simple question but it is not. The only advice I can give you is to try to imagine all possible scenarios/use-cases before starting the design. Cheers Claudio 2012/2/20 Jan Steinman

How to split a mysqldump file of multiple databases to singlefile databases... SOLVED with script

2012-02-20 Thread Andrés Tello
Today I needed to split a mysqldump -A into it several databases. I didn't have access to the original source, so I only had the texr file to work. It was a webhosting server dump, so there was a LOT of databases... I split the file with this little script I made: file= nextTable="" nextStart=0 n

Re: Design advice for hotel availability program

2012-02-20 Thread Jan Steinman
Where are your domain experts? You *are* consulting with them, no? If you don't know the answers, and don't have access to domain experts to help you, I would design for the most general case, and factor out exceptions as they prove to be so. "Pre-optimization" for exceptions almost always turns