Relication

2010-03-09 Thread Mohamed Mubeeth
Hi friends, im Mubeeth now Im working in software in singapore. i want some help for what is replication and how to set this is my id mubeeth@gmail.com this is handphone +65 84300135 -- Best Regards, Mubeeth S'pore +65-84300135 India +91-99940 44101

Front End Application For MySQL

2010-03-09 Thread Carlos Mennens
I am looking for a front end application that will allow me to enter in all my server / workstation data into a MySQL backend running on Linux. I have been told that I need to take all 75 servers we have in our server room and keep a database of the following: - Make - Model - O.S. - I.P. -

Re: Front End Application For MySQL

2010-03-09 Thread Peter Brawley
I am looking for a front end application that will allow me to enter in all my server / workstation data into a MySQL backend running on Linux. How about phpMyAdmin? PB - Carlos Mennens wrote: I am looking for a front end application that will allow me to enter in all my server /

Re: Front End Application For MySQL

2010-03-09 Thread Johan De Meersman
Wrong place to ask, unless you want to reinvent the wheel. There's plenty of applications out there for managing server pools, although thb I can't think of a good OSS one off-hand. On the job, we use HP Openview. Do yourself a favour and stay away from that one :-) On Tue, Mar 9, 2010 at 5:33

Re: Displaying date/time

2010-03-09 Thread Tompkins Neil
I'm still trying with this. Can anyone else offer any support or examples ? Thanks, Neil On Mon, Mar 8, 2010 at 6:02 PM, Tompkins Neil neil.tompk...@googlemail.comwrote: Hi Thanks for the positive reply. Your stored procedure kind of works but doesn't give me the desired results.

RE: Front End Application For MySQL

2010-03-09 Thread Gavin Towey
Google for hardware asset management software -Original Message- From: vegiv...@gmail.com [mailto:vegiv...@gmail.com] On Behalf Of Johan De Meersman Sent: Tuesday, March 09, 2010 9:15 AM To: Carlos Mennens Cc: MySQL Subject: Re: Front End Application For MySQL Wrong place to ask,

Re: UDF - Sequence Numbers

2010-03-09 Thread Johnny Withers
After some tinkering around on one of my test database servers with this sequence table design; I see what you mean. Defining the table with store_id and seq_id columns allows me to UPDATE table SET seq_id=LAST_INSERT_ID(seq_id+1) WHERE store_id=N and will block any further updates on store_id=N

Re: Relication

2010-03-09 Thread prabhat kumar
Hi, I would like to recommend you read following: *What is replication *: http://dev.mysql.com/doc/refman/4.1/en/replication.html *How to set : * http://dev.mysql.com/doc/refman/4.1/en/replication-howto.html , http://www.howtoforge.com/mysql_database_replication after reading above articles if