Introduction

This extension manages MySQL database files residing on CDROM. It can be configured to copy MySQL database files each time Stunnix Perl Web Server is run, or only at first invokation of Stunnix Perl Web Server by this user on a given computer, or not copy at all (if database is used only for reading data).

The MySQL database files should be put to /extensions/data/mysql_data/, rather than to ./data subdirectory of each implementation of MySQL server (so only one copy of your database resides on the CDROM). This is possible since format of MySQL database files is CPU- and OS-independant.

Details

This extension accepts option 'copy_to_hdd' specified via /site/config/extlist.conf file; possible values for this option are no (if you access database only for reading, specifying this option will leave database files on the CDROM), once (thus database files are copied only at first invokation of Stunnix Perl Web Server by this user on the computer to the temporary directory, preserving all changes made to database by user during all their invokations of Stunnix Perl Web Server until user cleans all temp files), once_to_permdir (the database files are copied only at first invokation of Stunnix Perl Web Server by this user on the computer to the permament directory, preserving all changes made to database by user during all their invokations of Stunnix Perl Web Server ) and always (database files are copied each time Stunnix Perl Web Server is run).

If data is copied from CDROM, you may wish to activate mysql_remove_data_copied_on_exit extension to remove database files from disk during shutdown of Stunnix Perl Web Server.

Notes on preparing MySQL database are available in documentation on MySQL extension.