Copying local MySQL databases to network server with TestStand

[_Aleksi]

Hi

I'm using MySQL as the main database for TestStand. I'm planning on saving all of the test results to the localhost and when testing is completed the database(s) would copied to a server. So, does anyone have any ideas about doing this? I'm thinkin about using CVI to code this, but there must be an easier way?

I'm currently also playing with the mysqldump, maybe that could be the solution?

Best regards,
Aleksi

[Shannon R]

Aleksi,

You'd need to copy the database to the server or create a script to automate this process. This could be done in any language that allows you to run SQL scripts.

Maybe another engineer with in-depth MySQL experience could point you to a good example or document.

Regards,
Shannon R
Applications Engineer
National Instruments

[_Aleksi]

Hi Shannon!

Actually I got this process working some time ago. After finishing testing, the system will dump the localhost to server. It took a bit time writing it, but now it's working fine. Currently I'm working on a PHP-based browser for the results. I must say, that I recommend MySQL to anyone considering using it as a their database.

Best regards,
Aleksi Sandqvist

[RomanKazicka]

Hi Aleksi,
we are using for archivation purpose mysqldump.
We have writen small script file which is started via sheduled task in W2k.
We are using UML modelator (Enterprise Architect) with MySql. We had no problem with this archivation process.
We have another problem with MySQL and TestStand.
We are trying to use MySql as main database. Could you help me, how you created tables in MySQL and how you parametrised the Teststand (schema,...)?
Thank in advice
Roman