How to use existing mysql database.

If you're a new user of AppGini, feel free to ask general usage questions, or look for answers here.
Post Reply
Thomas Pang
Posts: 11
Joined: 2015-04-14 16:16

How to use existing mysql database.

Post by Thomas Pang » 2024-04-14 10:05

Hi Guru,

I accidently deleted config.php and setup.md5 (can't find in trash) when ftp files into webserver, now the appgini require to setup new database, but I wish to use existing mysql named emolycom_sms, because a lot of important data were entered before this. How can I setup appgini to use the existing database?

Your help is very much appreciated. TIA.

Regards
Attachments
existing db.png
existing db.png (66.5 KiB) Viewed 2738 times
-----------------------------------
Thomas Pang
[email protected]
AppGini 25.13
Summary Report 3.4
Customizing AppGini web applications (Udemy)

User avatar
jsetzer
AppGini Super Hero
AppGini Super Hero
Posts: 1944
Joined: 2018-07-06 06:03
Location: Kiel, Germany
Contact:

Re: How to use existing mysql database.

Post by jsetzer » 2024-04-14 15:55

What about re-generating the web app in a new (blank) directory, installing in a new database, then copying config.php into old directory and editing connection parameters at the beginning of config file.

Don't forget backups!
Kind regards,
<js />

My AppGini Blog:
https://appgini.bizzworxx.de/blog

You can help us helping you:
Please always put code fragments inside [code]...[/code] blocks for better readability

AppGini 25.10 + all AppGini Helper tools

pbottcher
AppGini Super Hero
AppGini Super Hero
Posts: 1709
Joined: 2018-04-01 10:12

Re: How to use existing mysql database.

Post by pbottcher » 2024-04-14 16:29

Hi,

actually I do not think that you need to use a new database. Just use the existing database with the setting that you had previously. Same accounts and settings. Appgini will regenerate the config.php and will tell during the setup that the tables where already existing.

Take a backup of you db, just in case AppGini would overwrite anything. But I think that should work.
Any help offered comes with the best of intentions. Use it at your own risk. In any case, please make a backup of your existing environment before applying any changes.

Thomas Pang
Posts: 11
Joined: 2015-04-14 16:16

Re: How to use existing mysql database.

Post by Thomas Pang » 2024-04-19 03:00

Hi,

Thank you so much to Guru Jsetzer and Pbottcheer, I finally get to the existing database with the same settings as before.

Thank you and appreciated for the helps.

Regards,
-----------------------------------
Thomas Pang
[email protected]
AppGini 25.13
Summary Report 3.4
Customizing AppGini web applications (Udemy)

Post Reply