
                               The MySQL Sandbox

   Copyright © 2006 Giuseppe Maxia, Stardata s.r.l.
   [1]Home page
   [2]Contacts

PURPOSE

   This package is a sandbox for testing features under any version of MySQL
   from 3.23 to 5.1.
   It will install one node under your home directory, and it will provide
   some useful commands to start, use and stop this sandbox.

   With this package you can play with MySQL 5.x without need of using other
   computers. The server installed in the sandbox use non-standard
   ports  and  sockets,  so that they won't interfere with existing MYSQL
   installations.

REQUIREMENTS

     * Linux or FreeBSD operating system (it may work in other *NIX OSs, but
       has not been tested)
     * MySQL 3.23 or later
     * Perl 5.8.1 or later (for installation only)
     * bash shell

INSTALLATION

   Unpack the necessary MySQL binaries somewhere under your home directory, and
   give it a
   convenient name (e.g. /opt/mysql/5.1.10, or $HOME/binaries/5.1.10 )

   Unpack the distribution package in one empty directory and run the install
   script. For example:
   $ ./install.pl -f sandbox.conf --basedir=$HOME/binaries/5.1.10

   You can create the data directory in three ways:

   * using the supplied archive, with pre-defined users and passwords
   install.pl --datadir_from=archive

   * using mysql_install_db script. In this case, you need to create username
   and passwords manually, and eventually replace them in the sandbox scripts.
   install.pl --datadir_from=script

   * copying from an already existing directory (you need to have the necessary
   privileges to read fies from the origin)
   install.pl --datadir_from=dir:/usr/local/mysql/data/mysql

   To see the available options, run ./install.pl --help

USAGE

   Change    directory    to    the    newly    created   one   (default:
   $HOME/mysql_sandboxVERSION)

   Start the server
   ./start.sh

   Stop the server
   ./start.sh

   use a client with the sandbox server:
   ./use.sh

DATABASE USERS

   There are 2 database users installed by default:
 +-----------------+-------------+-------------------------------+
 |  user name      | password    | privileges                    |
 +-----------------+-------------+-------------------------------+
 |  root@localhost | datacharmer | all on *.* with grant option  |
 |  datacharmer@%  | datacharmer | all on *.*                    |
 +-----------------+-------------+-------------------------------+

PORTS AND SOCKETS

   (note: ports can be overriden using -p option during install)
 +--------+-----------------------------+
 | port   | socket                      |
 +--------+-----------------------------+
 |  3310  | /tmp/mysql_sandbox3310.sock |
 +--------+-----------------------------+

LEGAL NOTICE
     _________________________________________________________________

   This program is free software; you can redistribute it and/or modify
   it under the terms of the GNU General Public License as published by
   the Free Software Foundation; either version 2 of the License, or
   (at your option) any later version.

   This program is distributed in the hope that it will be useful,
   but WITHOUT ANY WARRANTY; without even the implied warranty of
   MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE. See the
   GNU General Public License for more details.

   You should have received a copy of the GNU General Public License
   along with this program; if not, write to the Free Software
   Foundation, Inc., 51 Franklin St, Fifth Floor, Boston, MA 02110-1301 USA
     _________________________________________________________________

References

   1. http://sourceforge.net/projects/mysql-sandbox/
   2. http://datacharmer.com/
