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

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.