Recommend this page to a friend! |
Download |
Info | Documentation | Files | Install with Composer | Download | Reputation | Support forum | Blog | Links |
Ratings | Unique User Downloads | Download Rankings | ||||
Not enough user ratings | Total: 128 | All time: 9,385 This week: 206 |
Version | License | PHP version | Categories | |||
db-migration 1.0.0 | GNU General Publi... | 5 | PHP 5, Databases, Systems administration |
Description | Author | |
This package can migrate MySQL database tables with given SQL files. |
Migration Class to help automatization
The migration Class is a command line php utility and it helps to automatizate database changings and its migrations. It is useful for example to create a Continous Integration environment. The sqlauto directory containts an init script and some mysql stored procedures.
Usage:
put mysql migration files into the sqlauto directory file name conventions:
- start with sql + iso date format (YYYYMMDD)
- should end with .sql
Run:
/usr/local/bin/php migration_runner.php --host=127.0.0.1 --database=bl_model_unit --user=root --password=345+4 --forceload=1 --droptables=1
input parameters:
--host
the mysql database host
--database
the mysql database name
--user
the mysql database user
--password
the mysql database password
--forceload
it will load all sql files into the database, ignore the .migrated file content
--droptables
it will drop all tables inside the database
Files (4) |
File | Role | Description | ||
---|---|---|---|---|
sqlauto (1 file) | ||||
LICENSE | Lic. | License text | ||
migration_runner.php | Class | Class source | ||
README.md | Doc. | Documentation |
The PHP Classes site has supported package installation using the Composer tool since 2013, as you may verify by reading this instructions page. |
Install with Composer |
Version Control | Unique User Downloads | Download Rankings | |||||||||||||||
100% |
|
|
Applications that use this package |
If you know an application of this package, send a message to the author to add a link here.