Setting up MySQL

  1. Install the Server

    First if necesary install a MySQL server, available from:

    Version 4 has a bunch of new features, transactions etc but might not be as stable as version 3.23

  2. Obtain the MySQL jdbc driver

    The maverick mysql driver connects to mysql through the jdbc driver:

    This is called Connector/J orignally also the mm mysql driver. Not that the mm mysql driver is licensed under the LGPL and the newer Connector/J under the GPL.

  3. Create a database to use with maverick
        ie mysql> create database maverick;
        
  4. Make mysql jdbc driver available to maverick

    The mysql jdbc driver must be visible to maverick in the classpath. Do this by copying mysql-connector-java-X.X.X-beta-bin.jar or mm-mysql-X.X.X-bin.jar into the lib directory of the distribution or if using a recent jdk the JRE_HOME/lib/ext directory.

  5. Setup maverick.ini

    Set parameters:

            DATABASE_DRIVER=org.maverickdbms.database.mysql.mysqlDataInterface
            org.maverickdbms.database.mysql.url=jdbc:mysql://localhost/maverick
        
  6. Create a test file

    ie at MVSH prompt

        :CREATE.FILE TESTFILE
        :LIST TESTFILE ALL
        ...
        :LIST DICT TESTFILE ALL
        ...
        :SELECT TESTFILE
        >LIST TESTFILE
        ...