Exporting Datamajor
There may be a need to load the DataMajor tables into a spreadsheet, another Database e.g. Postgress, Access etc. to use other tools to analyse the data.
While you can export to other formats TSV, XML etc. fairly easily it does need you to look into the MySQL documentation in a little depth.
We have included in the main Premvet release a Unix script that will
export all tables to CSV (Comma Separated Values) which should be
compatible with most other programs. The script is 'sql2csv' and will
be included in /u/source/scripts.
For sites that have not been upgraded recently you can find it
here.
(Note: if you do save it from this web page, make sure it is executable e.g. chmod 0755 sql2csv.txt and make sure
you check the script to ensure the 'TAB' character is an actual tab).
Normally, all you need do is run the script as root, the csv files will
be created autiomatically in /tmp. The csv files will include column
headers to allow you to match the columns with the documentation..
The script has been tested with Mysql Version 3, 4 and 5.