PHP Classes

MySQL Versioning: Update MySQL databases using SQL change set files

Recommend this page to a friend!
     
  Info   View files Files   Install with Composer Install with Composer   Download Download   Reputation   Support forum   Blog    
Ratings Unique User Downloads Download Rankings
Not enough user ratingsTotal: 339 All time: 7,080 This week: 488Up
Version License PHP version Categories
mysql-versioning 0.9GNU General Publi...5.0Databases, Systems administration
Description 

Author

solomongaby

This class can be used to update MySQL databases using SQL change set files.

It can scan directories with files that contain SQL statements that define change sets for creating tables, altering tables, or changing the table data.

The class can execute the SQL statements to update the database schema and alter the requested table data.

Every time it is run the class only execute the newly added change set files.

Picture of solomongaby
Name: solomongaby is available for providing paid consulting. Contact solomongaby .
Classes: 10 packages by
Country: Romania Romania
Age: 40
All time rank: 1745 in Romania Romania
Week rank: 192 Down4 in Romania Romania Up
Innovation award
Innovation award
Nominee: 1x

  Files folder image Files (8)  
File Role Description
Files folder image__DB (2 files, 4 directories)
Accessible without login Plain text file config.php Conf. applications config file

  Files folder image Files (8)  /  __DB  
File Role Description
Files folder imagechangesets (1 directory)
Files folder imagedata (1 file)
Files folder imageenviroment (2 files)
Files folder imagetables (1 file)
  Accessible without login Plain text file index.php Example applications run file
  Accessible without login Plain text file init.php Conf. config file for updater

  Files folder image Files (8)  /  __DB  /  changesets  
File Role Description
Files folder image001 (1 file)

  Files folder image Files (8)  /  __DB  /  changesets  /  001  
File Role Description
  Accessible without login Plain text file 01_changeset1.sql Data example of changeset

  Files folder image Files (8)  /  __DB  /  data  
File Role Description
  Accessible without login Plain text file locations.sql Data data file for table locations

  Files folder image Files (8)  /  __DB  /  enviroment  
File Role Description
  Plain text file Mysql.php Class mysql wrapper
  Plain text file MysqlUpdater.php Class main updater class

  Files folder image Files (8)  /  __DB  /  tables  
File Role Description
  Accessible without login Plain text file locations.sql Data initial create for table locations.

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 Install with Composer
Downloadmysql-versioning-2009-03-29.zip 7KB
Downloadmysql-versioning-2009-03-29.tar.gz
Install with ComposerInstall with Composer
Needed packages  
Class DownloadWhy it is needed Dependency
MySQL-class Download .zip .tar.gz run queries using this wrapper class Required
 Version Control Unique User Downloads Download Rankings  
 0%
Total:339
This week:0
All time:7,080
This week:488Up

  Applications that use this package  
No pages of applications that use this class were specified.

Add link image If you know an application of this package, send a message to the author to add a link here.


  Pages that reference this package  
MySQL Database versioning strategy by Gabi Solomon IF you just got into versioning your code then you are probably really happy with your acomplishment...

Latest pages that reference packages Latest pages that reference packages