Backup App - solved a longstanding issue I had getting it to work

I have always wanted to get the Backup App running however have not been successful with various attempts over the last few years. I had some inspiration tonight that it might be a database user permission issue and I have got it working now. I tried to find one of my old threads to bump with the solution but maybe that was on the old forum.

The problem I always encountered was that Perch would say I could backup the database and resources, however when the backup ran the database file would only have a couple of lines and none of the Perch data. Resources would backup fine.

I usually create database users with the following permissions for Perch:

Alter, Create, Delete, Drop, Insert, Select and Update

Today I tried changing this to "all privileges" and it worked. With a bit of searching I narrowed it down to needing to add the "Lock Tables" permission.

So I now have it working correctly with the following permissions:

Alter, Create, Delete, Drop, Insert, Lock Tables, Select and Update

Probably obvious to some, but I am no database expert.

Hope this can help someone!