@Jesse i recently saved a backup of my database using a different name thinking this would create a different database, using Samba’s database backups. i then deleted the database name from the settings to restore my other database.
However when i try to restore my second database i put the database name in settings and then select my database to restore, it says successful but doesnt actually change the database?
any ideas what im doing wrong or even if what im trying to do is possible?
database name changed to Glitterbugs to allow me to restore Glitterbugs database
Leaving database name blank allows me to restore the SambaPOS4 database where the latest backup is the same as all the Glitterbugs backups, ive tried them all and nothing changes
So why isnt it loading any changes, i did a backup after making changes and changed the database name but when restoring that database with those changes nothing happens
In the first screenshot abovein the database name field. Normally this is blank so defaults to SambaPOS4, i made some changes and then backed up the database using the name Glitterbugs.
My thinking was that i could restore previous version by restoring the SambaPOS4 database name and restore the other changes back by using the Glitterbugs database backup, just like you would restore previous versions if i had t changed the name
But when i try to restore the Glitterbugs database it says successful but nothing changes when logging in, its the same as the SambaPOS4 databases even though ive made changes and backed up using the Glitterbugs name
It changes the name of the database backup so you know what changes were made, the point is the changes i made and backed up with the name Glitterbugs dont appear to have actually been backed up as when i try to restore any of those versions of the database nothing happens, the version of the database im trying to restore does not actually restore
I was just doing a normal backup and but changed the name to glitterbugs, then did some more changes and backed up a few more times
Then i wanted to load a previous version that had the name SambaPOS4 so i restored that version and that worked fine
Now when trying to revert back to another version that is called glitterbugs it doesnt actually do this, its says restore successful but hasnt actually loaded that version of the database
My idea was to have two versions of the database each for a different business use which is why i made changes and called that different version a different name. I could then revert to different version using the backup an restore
What you should do honestly is just use 2 databases. Swap between them using actions and rules or just manually changing connection string. You can copy your setup into the new database or start fresh with a completely different one. If you change the connection string and keep everything the same except change Database Name to the new database it will create a fresh new database. You can then switch between your original one and the new one via the connection string or setup actions and rules to switch it.
I was looking to do that but couldnt find where the connection string was in settings, think in missing something really obvious could you send a screen shot shiwing where it is, think im going blind lol
