Remove 'debian-sys-maint' Account?

2010-03-02 Thread Carlos Williams
I am using Debian 'Squeeze' / Testing on with MySQL 5.1.41-3 installed. It is a fresh install and I was checking all the system accounts and noticed that Debian has a 'debian-sys-maint' account on 'localhost'. Has anyone ever removed this account? Do I need it or can I safely remove this account? I

Re: redirecting query output?

2010-03-02 Thread Chris W
I'm not sure this is the best solution, but whenever I am inserting a lot of records with the possibility of some of those records already existing and I have no reason to update the existing records with new data, I use 'INSERT IGNORE'. I'm not sure if that will 'ignore' other errors that you

Re: redirecting query output?

2010-03-02 Thread Stein, Olaf
I don't think you do anything about the output, you could however check if a record is already in the table before inserting it... And skip it if already there Olaf On 3/2/10 11:17 AM, "Richard Reina" wrote: I have a perl script that periodically reads and enters (via perl->DBI parsed syste

redirecting query output?

2010-03-02 Thread Richard Reina
I have a perl script that periodically reads and enters (via perl->DBI parsed system output (about received faxes) into a table. Since the old output is repeated I have put, when creating the table, the UNIQUE key on the field of the faxname, which is always different (something like fax078

Re: Replication for backup

2010-03-02 Thread Shawn Green
Hello Jeetendra, Jeetendra Mirchandani wrote: Is it possible to replicate only DML statements? I don't want an operator error of "drop table" to replicate to the slave I use 5.0.x ps: please cc me on the reply Regards, Jeetu There is no good, there is no bad, there's just what happened. Dance

MySQL University session on March 4: MySQL Column Databases

2010-03-02 Thread Stefan Hinz
MySQL University: MySQL Column Databases http://forge.mysql.com/wiki/MySQL_Column_Databases This Thursday (March 4th, 15:00 UTC - slightly later than usual), Robin Schumacher will present MySQL Column Databases. If you're doing Data Warehouse with your databases this is a must-attend, but it's als