PHP Classes

How to Use a PHP MySQL Update Script UsingDBUpdater: Generate and execute MySQL database update files

Recommend this page to a friend!
  Info   Screenshots Screenshots   View files View files (1)   DownloadInstall with Composer Download .zip   Reputation   Support forum   Blog    
Ratings Unique User Downloads Download Rankings
Not yet rated by the usersTotal: 68 All time: 10,258 This week: 191Up
Version License PHP version Categories
dbupdater 1.0.0MIT/X Consortium ...5PHP 5, Databases, Systems administration, G...
Description 

Author

The update tool for MySQL databases between development and production system.

This tool transfers the structure of one MySQL database to another.

Use this tool to read the database structure on the development system, then upload the transport file to the productive system and use this tool to update the database structure there.

Only missing columns and tables are added to the target database, and nothing is deleted.

Nothing changes in the data either, neither in the source nor in the target database.

To use this tool, do the following:

The transfer takes place in 2 steps: reading out and updating.

Read out

- Copy the script to a web server with access to the source database,

- Call the script in the browser,

- Enter the requested data and click on the "Read out" link.

The name of the transport file can be freely selected.

Optimally, no path is specified for this, and the file is stored in the same directory where the script is located.

Update

- Copy the script and the transport file to a web server with access to the target database

- Use this tool in the browser

- Enter the requested data and click on the "Update" link.

Logically, the name of the transport file must be the same as that specified in the "Read out" step.

No path must be specified if the file is in the same directory as the tool (recommended).

The tool has been tested with some databases. Nevertheless, it can, of course, happen that the tool does not work correctly.

For this reason, it is recommended (as always with structural changes) to create a backup before executing.

Picture of René Mansveld
  Performance   Level  
Name: René Mansveld <contact>
Classes: 3 packages by
Country: Germany Germany
Innovation award
Innovation award
Nominee: 1x

Winner: 1x

Screenshots  
  • dbupdater.png
  Files folder image Files  
File Role Description
Accessible without login Plain text file dbupdater.php Appl. Script

 Version Control Unique User Downloads Download Rankings  
 0%
Total:68
This week:0
All time:10,258
This week:191Up