Re: IDE

2009-07-20 Thread Martijn Tonies
Hello Mosaed, Can you contact me personally? With regards, Martijn Tonies Upscene Productions http://www.upscene.com Download Database Workbench for Oracle, MS SQL Server, Sybase SQL Anywhere, MySQL, InterBase, NexusDB and Firebird! Database questions? Check the forum:

Mysql warning event :Changed limits

2009-07-20 Thread Vinson.Wei
Changed limits: max_open_files: 2048 max_connections: 1024 table_cache: 507 I'm getting the below warning in my event viewer: Changed limits: max_open_files: 2048 max_connections: 1024 table_cache: 507 How can i slove it. Thanks in advance.

Group by column and Sum another

2009-07-20 Thread Hagen
I am hoping I can get some help with a query I am trying to construct: I want to group by a 'contract' column and get the sum of the 'amlp' column values associated with each contract. I can do a select and group by on contract select contract from maintenance group by contract; and I will get

Re: Group by column and Sum another

2009-07-20 Thread Olexandr Melnyk
select contract , sum(amlp) from maintenance group by contract; On Mon, Jul 20, 2009 at 6:50 PM, Hagen finha...@comcast.net wrote: I am hoping I can get some help with a query I am trying to construct: I want to group by a 'contract' column and get the sum of the 'amlp' column values

RE: Group by column and Sum another

2009-07-20 Thread Hagen
Thanks! That did the trick. -Original Message- From: Olexandr Melnyk [mailto:omel...@gmail.com] Sent: Monday, July 20, 2009 10:02 AM To: mysql@lists.mysql.com Subject: Re: Group by column and Sum another select contract , sum(amlp) from maintenance group by contract; On Mon, Jul

JOomla Administrator

2009-07-20 Thread Dave Shariff Yadallee - System Administrator a.k.a. The Root of the Problem
Hello, we are trying to move a Joomla Site and the administrator does nowrk. Using MySQL 5.1.36 on MAC OS X Server. How can I fix this? -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/mysql?unsub=arch...@jab.org

Re: JOomla Administrator

2009-07-20 Thread Daniel Brown
On Mon, Jul 20, 2009 at 15:03, Dave Shariff Yadallee - System Administrator a.k.a. The Root of the Problemr...@doctor.nl2k.ab.ca wrote: Hello, we are trying to move a Joomla Site and the administrator does nowrk. Using MySQL 5.1.36 on MAC OS X Server. How can I fix this? This would be

RE: JOomla Administrator

2009-07-20 Thread Martin Gainty
its possible a single thread language such as PHP would'nt handle your situation..have you tried to recode your application in Java? in the meanwhile please post your stacktrace Martin Gainty __ Verzicht und Vertraulichkeitanmerkung/Note de déni et

Re: mysqldump output

2009-07-20 Thread zhu dingze
we need more information, such as your client and server version, the command that exactly your input etc. 2009/7/14 JingTian jingtian.seu...@gmail.com hi all, i use mysqldump to backup my database, the command line is; mysqldump -p -u -h database_name database_name.sql i find in the