Re: Logs not working

2010-09-04 Thread monloi perez
on the db server? meaning the mysqld log right? THere is really no data for teh current error. The last error they said was too much connections and shouldnt that be logged in mysqld.log? Thanks, Mon From: Ananda Kumar anan...@gmail.com To: monloi perez

mysqldump error 1064 for database Use command

2010-09-04 Thread Manasi Save
Hi All, I have 10 mysql databases all the tables use MyIsAm mysql storage engine. Database names are 1,2,3,4,...10. When I use mysqldump command with --all-databases option. This gives me following error: mysqldump -u myuser -p --all-databases AllNew_Databases_20100904.sql ERROR MESSAGE :-

Re: Best method to keep totals

2010-09-04 Thread Arthur Fuller
100% agreed. Arthur The other exception is also where financial data is being stored. If you have, say, a database containing sales order records, then as well as storing the individual values of each item in each order, you also need to store the total value of the order, the total price

Re: mysqldump error 1064 for database Use command

2010-09-04 Thread Nitin Mehta
Hi, Have you recently upgraded your MySQL installation? 1064 in earlier days used to mean use of reserved word. Few clients have reported this error in last couple of months after they upgraded from 5.1.41 to higher versions. As of now, I don't have a solution other than changing the name

Re: Logs not working

2010-09-04 Thread Nitin Mehta
I believe that will not be logged unless you have enabled log_warnings. Too many connections would normally mean that the number is going beyond the configured limit and denying new sessions is an expected behavior and should not be an error really. Regards, Nitin