PHP Classes

Auto DB Up: Update a MySQL database from SQL 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
StarStarStar 54%Total: 616 All time: 5,107 This week: 115Up
Version License PHP version Categories
auto-db-up 0.1The PHP License3.0PHP 5, Databases, Systems administration
Description 

Author

Alexandru Trandafir Catalin

This class can be used to update a MySQL database from SQL files.

It can scan a given directory for files with numbered .sql name extension.

The class reads the number of the currently installed database version.

It reads the SQL statements from the SQL files the higher number than the last installed version and executes the statements as queries to a MySQL database.

Innovation Award
PHP Programming Innovation award nominee
May 2010
Number 5

Prize: One book of choice by Apress		 During the lifetime of a database application, the database schema has to be changed to support the evolution of the application. Multiple sets of changes may need to be applied upgrade the application database schema.

This class provides an interesting solution to upgrade a MySQL database, either in development or production environments, by applying one or more sets of schema changes that were created since the last time the schema was upgraded.

Manuel Lemos
Picture of Alexandru Trandafir Catalin
Name: Alexandru Trandafir ... <contact>
Classes: 1 package by
Country: Spain Spain
Age: 37
All time rank: 301977 in Spain Spain
Week rank: 195 Up5 in Spain Spain Up
Innovation award
Innovation award
Nominee: 1x

  Files folder image Files (2)  
File Role Description
Plain text file AutoDbUp.php Class The one and single file.
Accessible without login Plain text file example.php Example This code must be included into all the pages of your application.

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
Downloadauto-db-up-2010-06-01.zip 2KB
Downloadauto-db-up-2010-06-01.tar.gz 2KB
Install with ComposerInstall with Composer
 Version Control Unique User Downloads Download Rankings  
 0%
Total:616
This week:0
All time:5,107
This week:115Up
User Ratings User Comments (1)
 All time
Utility:75%StarStarStarStar
Consistency:83%StarStarStarStarStar
Documentation:-
Examples:83%StarStarStarStarStar
Tests:-
Videos:-
Overall:54%StarStarStar
Rank:2107
 
This class did not use any Connection info with the database.
12 years ago (Md. Tariqul Islam Drubo)		70%StarStarStarStar
 

  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.


  Related pages  
A blog post about the class and how to use it.