2. PHPRunner General questions
  3. [SOLVED]  Update remote Database
This topic is locked
[SOLVED]

 Update remote Database

 		6/11/2020 10:28:07
PHPRunner General questions
S
 Skayy author

Hello,
I'm not a programmer :-) I like phprunner and want to create a small app with it and need some help.
If I have a phprunner app in operation on a webserver with mysql database and then make changes in phprunner (e.g. change or add fields) - how can I update the database in a simple way, even if there is already data in the database ?
I used to have another tool (AppGini). Maybe someone knows this. It has an overview of the changed fields in the admin and updates them automatically.
How can I update the database in the event of changes without destroying the data?
Thank you very much, Kai
Sergey Kornilov admin 6/11/2020

If you make changes in PHPRunner via 'Modify table' these changes will be applied to your database you connected to.
Are you saying you have two different databases? Hard to understand based on your post.
S
 		Skayy author 6/11/2020

Please excuse my bad English :-)
Yes, I have multiple installations with different databases. I have to update several databases after I make changes in PHPrunner.
Thanks much, Kai
Sergey Kornilov admin 6/12/2020

You need to use a third-party software that will compare local and production databases and creates the script to run against the remote database to synchronize database structure.
Check this for instance:

https://www.red-gate.com/products/mysql/mysql-compare/
S
 		Skayy author 6/12/2020

Ok, thank you very much, Kai