Login   Register  
PHP Classes
elePHPant
Icontem

Auto DB Up: Update a MySQL database from SQL files

Recommend this page to a friend!
Stumble It! Stumble It! Bookmark in del.icio.us Bookmark in del.icio.us
  Info   View files View files (2)   DownloadInstall with Composer Download .zip   Reputation   Support forum (1)   Blog    
Last Updated Ratings Unique User Downloads Download Rankings  
2010-06-01 (4 years ago) RSS 2.0 feedNot enough user ratingsTotal: 555 This week: 1All time: 5,003 This week: 1,179Up
Version License PHP version Categories  
auto-db-up 0.1The PHP License3.0PHP 5, Databases, Systems administration
Description Author  

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: 27
All time rank: 283470 in Spain Spain
Week rank: 941 Up23 in Spain Spain Up
Innovation award
Innovation award
Nominee: 1x

  Files folder image Files  
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.

 Version Control Unique User Downloads Download Rankings  
 0%Total:555All time:5,003
 This week:1This week:1,179Up
 User Comments (1)  
 
This class did not use any Connection info with the database.
2 years ago (Md. Tariqul Islam Drubo)
70%StarStarStarStar