search

DrDBanner / inmanage

Easily install, update, and backup your self-hosted Invoice Ninja with a CLI shell script.
https://www.invoiceninja.org
Creative Commons Zero v1.0 Universal
20 stars 2 forks source link

Backup errors #2

Open kaimano opened 3 weeks ago

kaimano commented 3 weeks ago

Hello, and first thank for your script. It's amazing!

However, I cannot perform the backup in a shared hosting. this is the error: mysqldump: Error: 'Access denied; you need (at least one of) the PROCESS privilege(s) for this operation' when trying to dump tablespaces

I tried creating a .my.cnf file with the DB credentials, which worked on a local LAMP system, but without success.

DrDBanner commented 3 weeks ago

I am a bit unsure what's the question. It's literally stated there: Your Database User has no PROCESS rights which is mandatory. End of story.

Try to convince your share hosting provider to give you that particular right on your DB.

DrDBanner commented 3 weeks ago

We can circumvent this by cutting out the tablespaces information when we invoke the dump. This MAY have implications on the functionality of the dump. So, I'll add a switch to the configuration in the near future.

kaimano commented 3 weeks ago

Ok, thanks

DrDBanner commented 2 weeks ago

I created something. Can you try with the development branch?

cd .inmanage
git pull
git checkout develop
cd ..
./inmanage.sh

Should add the new configuration to the configuration file automatically. Next time you do a backup it should do the mysqldump with the --no-tablespaces switch. Please report if it works. Then I'll push it to the main branch.

DrDBanner commented 2 weeks ago

@kaimano PING!