[tiwil]

Where to add this backup script? (name)
I installed everything but now waiting to select the db backup and etc so i want to edit it.

Ah, I forgot that.
I named that script as backup.sh.
And after that, change permission to +x

Code: (Select All)

chmod +x backup.sh

Use sudo if required.

Then after that, I add to crontab

Code: (Select All)

sudo crontab -e

Why to use sudo? Because of, my VPS, to access other user directory, or /etc folder, I should act as root user.

Then inside the crontab, I insert,

Code: (Select All)

0 0 * * * /pathtobackupfile

So, it will upload to gdrive in 12.00AM everyday.

Btw, to make crontab working, I should reboot my VPS.

[youssefbasha]

root@vps4:~# cd /usr/bin/
root@vps4:/usr/bin# chmod +x backup.sh
root@vps4:/usr/bin# backup.sh
Starting backup
/usr/bin/backup.sh: 23: /usr/bin/backup.sh: cannot create /home/youssefbasha/backups/mysql/ERROR2002(HY000):Can'tconnecttolocalMySQLserverthroughsocket'/var/run/mysqld/mysqld.sock'(2).sql: Directory nonexistent
tar: Removing leading `/' from member names
What to do with this? 
If you have discord then gimme ur username (better and faster)

[perry]

just a quick look at but @youssefbasha are you sure this is mysql?
and as i see the script is based on @dynamos version @tiwil have you done this on another os?

[tiwil]

just a quick look at but @youssefbasha are you sure this is mysql?
and as i see the script is based on @dynamos version @tiwil have you done this on another os?

Dynamo's script? I've done with my Ubuntu, but not working. Then I created my own script, it works perfectly with my Ubuntu 16.04 (same OS as @youssefbasha)

[youssefbasha]

Backuped files and didn't backup mysql
Tiwil's script did the files but cant connect to MySQL