imre - If you are using MyISAM tables, you might be able to employ the 'mysqlhotcopy' script to snapshot the data tables, then transfer them to your merge/analysis application db. You'd need to make sure to avoid filename overlaps, and make sure to get permissions correct. In my experience once you transfer the MyISAM files into a database directory with proper permissions, they are ready to be used.
Another possibility if you're using any table format would be mysqldump. Dump the tables from your devices and then pipe the dumps into your application db. Dan On 10/19/06, [EMAIL PROTECTED] <[EMAIL PROTECTED]> wrote:
Hi, I am developping some devices that gather and process data using mysql(embedded). Is there any easy way to merge the databases from these devices into a single database? I could easily deal with the semantics of the merge in SQL level. What I don't know is how can my merge/analysis application see the databases copied from the devices. (I'd rather not go through csv exports if possible ...) Any ideas? Thx ImRe P.S.: Ver 5.0.24a -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
-- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
