The World's Most Popular Open Source Database
  MySQL
Table of Contents

2 Upgrade Installation

Currently, this package is only working under UNIX systems.

Below the original MySQL system is called MySQL for short. The Temporal Subsystem package for MySQL is called tMySQL. The Temporal Subsystem package for BerkeleyDB is called tBDB.

MySQL uses BerkeleyDB databases. So in order to make MySQL temporal, besides this temporal MySQL installation package you also need a templral BerkeleyDB installation package.

INSTALL
*******

  1. If you have already installed a copy of the MySQL 3.23.49, you don't have to download it again; please jump to step (3). Otherwise, download MySQL package from http://www.mysql.com.
  2. Untar the MySQL source tree (e.g., /home/mike/mysql).
  3. Download tBDB package (tbdb-install.tar.gz) from http://www.cs.arizona.edu/tau.
  4. Untar the tBDB package to your working directory. You can untar the tBDB package to anywhere you feel convenient (e.g. /home/mike/tbdb-install).
  5. Go into the tBDB directory (e.g., cd /home/mike/tbdb-install).
  6. Run "make install BDBVER=<BDB_VERSION> BDBSRC=<BDB_SRC_TREE_DIR>" to patch the Temporal Subsystem into the original BerkeleyDB source tree inside of the MySQL (e.g., make install BDBVER=3 BDBSRC=/home/mike/mysql/bdb).
  7. Download tMySQL package (tmysql-install.tar.gz) from http://www.cs.arizona.edu/tau.
  8. Untar the tMySQL package to your working directory. You can untar the tMySQL package to anywhere you feel convenient (e.g., /home/mike/tmysql-install).
  9. Go into the tMySQL directory (e.g., cd /home/mike/tmysql-install).
  10. Run "make install MYSQLVER=<MYSQL_VERSION> MYSQLSRC=<MYSQL_SRC_TREE_DIR>" to patch the Temporal Subsystem into the original MySQL (e.g., make install MYSQLVER=3.23.49 MYSQLSRC=/home/mike/mysql).
  11. Go to the MySQL source tree (e.g., cd /home/mike/mysql).
  12. Run "make distclean" to clean the old configurations. If "make" complains about no Makefile exists, that means we don't have old configurations left, you can just ignore the complaint.
  13. Configure the MySQL with "configure <OPTIONS>" instead (e.g., configure --prefix=/home/mike/MySQL_Home --with-berkeley-db).
  14. Build the MySQL by "make".
  15. Install the MySQL by "make install".
  16. Go into the tMySQL directory (e.g., cd /home/mike/tmysql-install).
  17. Run testcases by "make test MYSQLVER=<MYSQL_VERSION> MYSQLSRC=<MYSQL_SRC_TREE_DIR>" (e.g., make test MYSQLVER=3.23.49 MYSQLSRC=/home/mike/mysql). The final test result will be given after the testcases are done.

UNINSTALL
*********

  1. Go into the tMySQL directory (e.g., cd /home/mike/tmysql-install).
  2. Check the list of changes that tMySQL package uninstallation script will do to the MySQL (with Temporal Subsystem) by "make -n uninstall MYSQLVER=<MYSQL_VERSION> MYSQLSRC=<MYSQL_SRC_TREE_DIR>" (e.g., make -n uninstall MYSQLVER=4 MYSQLSRC=/home/mike/mysql). (Note: "install" overwrites some original MySQL files with a modified version. Before the overwriting, it also backup the files to be replaced in the tMySQL package. To restore the original MySQL, "uninstall" will copy the backup files back to the MySQL source tree. Original files are only backup once, which means if there are backup files in the tMySQL package, it won't backup files again when you rerun "make install". If you want to delete the old backup files so that it can backup again, you need to run "make del_backup MYSQLVER=".)
  3. Run "make uninstall MYSQLVER=<MYSQL_VERSION> MYSQLSRC=<MYSQL_SRC_TREE_DIR>" script to restore the MySQL to the original version (e.g., make uninstall MYSQLVER=4 MYSQLSRC=/home/mike/mysql).
  4. Go into the tMySQL directory (e.g., cd /home/mike/tbdb-install).
  5. Run "make uninstall BDBVER=<BDB_VERSION> BDBSRC=<BDB_SRC_TREE_DIR>" script to restore the BerkeleyDB to the original version (e.g., make uninstall BDBVER=3 BDBSRC=/home/mike/mysql/bdb).
  6. Go into the MySQL source tree (e.g., cd /home/mike/mysql).
  7. Run "make distclean" to clean all configurations for temporal support.
  8. Reconfigure the MySQL by "configure <OPTIONS>".
  9. Build the original MySQL by "make".
  10. Install the original MySQL by "make install".

Developed by the TAU Project, Computer Science Department, University of Arizona