Tiny one file migration script for MySQL and PostgreSQL using PHP, built for the minimalist.

Handles migrating your database schema upwards. Easy to use in different environments: multiple developers, staging, production. Just run migrate and it will move the database schema to the latest version. Will detect conficts and print out errors.

If you already have a GIT repo for your server, then:

git submodule add https://github.com/kennberg/php-mysql-migrate php-sql-migrate
git submodule init

Or, for installation inside your server directory:

git clone https://github.com/kennberg/php-sql-migrate

To add a new migration:

php php-sql-migrate/migrate.php add [name-without-spaces]

To migrate to the latest version:

php php-sql-migrate/migrate.php migrate

The migrate script will create a ".version" file in the directory from which it is run. For this reason, I recommend running the migration script from one level up. Do not checkin the version file since it needs to be local!

When you add a new migration, a new script file will be created under the "migrations/" folder and this folder should be checked into the code repository. This way other enviornments can migrate the database using them.

To setup your database information, make sure to run:

cp config.php.sample config.php
vim config.php

The database version is tracked locally using file ".version".

The MySQL database link is available using "$link" variable.

Make sure that you use the function "query" instead of "mysql_query" in the migration scripts, since it handles error reporting.

Apache v2. See the LICENSE file.