PHP Classes

MySQL Versioning: Update MySQL databases using SQL change set files

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

Author

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: 39
All time rank: 1745 in Romania Romania
Week rank: 106 Up3 in Romania Romania Up
Innovation award
Innovation award
Nominee: 1x

  Files folder image Files  
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  /  __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  /  __DB  /  changesets  
File Role Description
Files folder image001 (1 file)

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

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

  Files folder image Files  /  __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  /  __DB  /  tables  
File Role Description
  Accessible without login Plain text file locations.sql Data initial create for table locations.

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:2
All time:7,077
This week:96Up