Hi Nirmal,
Now i understand what you wish to do.
MySQL daemon don't use libmysql.This library is for client.
I think you have at least 2 option :
1.Devices work off line with RDBMS and half duplex communication (from
devices to DataBase).
- but this devices must do an output into ASCII file, to be imported
after in mysql database using LOAD DATA.This can be a script handled by
crontab, for example.
2.Devices work on line with RDBMS and full duplex communication:
- this solution expect to write an server application (which use
libmysql-in this library are all functions you need for
connecting,querying,retrieve data ...) for this devices but client for the
mysql daemon and which must organize data outputted from devices to put in
the mysql table.(This is 3-tier application)
In this cases ,i think , you can use one machine for both:devices and mysql
daemon.REASON : you don't handle very large data.
It happens i have already done a similarly application but using solution
no. 2. It's work (non-stop,over 1 year) very good and it's very safe.MySQL
server(Linux version) it's very stable and the libmysql (Linux and Windows)
is a quite success.
Best regards,
Gelu
_____________________________________________________
G.NET SOFTWARE COMPANY
Permanent e-mail address : [EMAIL PROTECTED]
[EMAIL PROTECTED]
---------------------------------------------------------------------
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/ (the list archive)
To request this thread, e-mail <[EMAIL PROTECTED]>
To unsubscribe, e-mail <[EMAIL PROTECTED]>
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
