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, nothing is deleted. Nothing changes in the data either, neither in the source nor in the target database.
Use
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 [Read out].
Update
- Copy the script and the transport file to a web server with access to the target database,
- call the script in the browser,
- Enter the requested data and click on [Update].
The tool has been tested with some databases. Nevertheless, it can of course happen that the tool does not work properly. For this reason, it is recommended (as always with structural changes) to create a backup before executing.
We are grateful for extensions and corrections to the tool. If you are not able to make these corrections yourself, at least give us a hint about the necessary changes.
Notes by e-mail to: Developer@Spider-IT.de
Have fun and success with the tool!
Download
The tool can be downloaded here:
Version 1.1 (06.08.2021)