Skip to content

davesloan/mysql-php-migrations

Folders and files

NameName
Last commit message
Last commit date

Latest commit

 

History

15 Commits
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 

Repository files navigation

This project was created to address the problem of maintaining database changes within an actively developed PHP/MySQL project. Frequently, multiple developers need to be able to quickly update their local sandboxes with the latest DB schema changes and also add their own without creating file conflicts in repositories such as CVS and Subversion.

MySQL-PHP-Migrations includes the following features:

* command-line only utility
* migration files are stored using timestamps to reduce repository conflicts
* ability to list, migrate up, migrate down, run a specific migration, and migrate to latest database version
* each migration is wrapped in a transaction to ease error recovery
* migration information stored in database table to support interleaving (insertion of migrations between migrations that have already been run)
* in-line help
* support for PDO with MySQL driver or mysqli
* can store an initial DB schema which allows entire database structure to be erased and rebuilt from an initial schema and existing migrations

About

Command line utility for managing MySQL database migrations.

Resources

License

Stars

Watchers

Forks

Packages

No packages published

Languages