[HOWTO] Make automatic backup of ALL MySQL / MariaSQL databases on QNAP V3.8

[fribse]

I've gone through the script, this is not tested fully, but give it a try and see if it works.
Please report back what you find, and I'll release it in the first post if it's ok...

UPDATE: Version has been released.

[nevaeh]

It looks like it works perfectly!

You my good sir, are amazing!

[fribse]

No problem, let's hope it works...

[nevaeh]

Is there anything specific you would like me to provide to prove that it's working correctly?

I'd be happy to help.

[fribse]

No, but it would be nice if others report back so we can get it tested in different environments.

[fribse]

Hi nevaeh

I've made it a proper 3.6, thankyou for your help!

[nevaeh]

Hi nevaeh

I've made it a proper 3.6, thankyou for your help!

I'm really, really sorry to bother you again. For some reason the script doesn't seem to be cleaning out older backups set by the config file. I currently have the config file at it's defaults, 6, 5, 3.

I've attached as much information as I could to hopefully assist and I thank you so much if you take a look at it.

Edit - My apologies, I have attached the configuration file as well!

[datorexpert]

You need to attach the configuration file too.

[fribse]

Hi Nevaeh
Sorry for not getting back to you sooner, had a mishap during a firmware upgrade, and had to get QNAP to help with getting the RAID's back, they did that, so now I can try and look into what is going on

[fribse]

First of, the easiest test, could you check if the command /bin/rm is present on the NAS?
Secondly, could you check if the command /bin/ls is present on the nas?
Thirdly, could you check if the command /bin/awk is present on the nas?
Fourthly, if the three commands are present, could you try and cd to the 'weekly' dir (via SSH), and run the command /bin/ls | /bin/awk 'NR>6'
To see if that lists the 'excess' files?

Did you try and run the mysqlbackup script from the command line?
I can see the config is almost default, could you maybe copy a fresh config file to the /etc/config folder? If you edit the config file on a windows box, please use a proper editor that doesn't convert it to windows format, something like PSPAD or NOTEPAD++ (not Notepad).

[nevaeh]

First of, the easiest test, could you check if the command /bin/rm is present on the NAS?
Secondly, could you check if the command /bin/ls is present on the nas?
Thirdly, could you check if the command /bin/awk is present on the nas?
Fourthly, if the three commands are present, could you try and cd to the 'weekly' dir (via SSH), and run the command /bin/ls | /bin/awk 'NR>6'
To see if that lists the 'excess' files?

Did you try and run the mysqlbackup script from the command line?
I can see the config is almost default, could you maybe copy a fresh config file to the /etc/config folder? If you edit the config file on a windows box, please use a proper editor that doesn't convert it to windows format, something like PSPAD or NOTEPAD++ (not Notepad).

No worries about the late response, I'm just thankful you're willing to help me troubleshoot!

I ran through all the steps above and included screenshots as well, everything seems to work just fine except clearing out old backups for some reason. I'm not sure if this helps or not, but I can't just clear out the backups by highlighting them and deleting them through Windows Explorer (it claims I need permission from NAS\admin), I have to manually log in to the QNAP, open File Manager and delete them that way.

[fribse]

Ok, that sounds like a rights issue then.
Could you please check the folders owner and rights?

[nevaeh]

Ok, that sounds like a rights issue then.
Could you please check the folders owner and rights?

Each folders owner (mysql.daily, mysql.weekly, mysql.monthly) is: admin
Rights are: drwxr-xr-x

The files owner is: admin
Rights are: -rw-r--r--

[fribse]

Hmm interesting, mine looks like this:
drwxr-xr-x 2 admin administ 4096 Sep 24 00:30 mysql/
drwxrwxrwx 2 admin administ 4096 Sep 24 00:30 mysql.daily/
drwxrwxrwx 2 admin administ 4096 Sep 2 00:30 mysql.monthly/
drwxrwxrwx 2 admin administ 4096 Sep 20 00:30 mysql.weekly/
Did you create them via SSH or CIFS?

[nevaeh]

I let the script create them, the only thing I can think of is that my QNAP has some bizarre inherent permissions that it's pushing down.

I also tried setting the backup to a completely different drive/share and the permissions where the same as well.

The only thing I can think of is restoring to factory defaults and starting over...