Shell Programming and Scripting

im looking for a shell script for linux that backups up a specific folder/folders + the whole SQL db, archives into a password encrypted gpg file and uploads to google drive using API every 6 hours (via cron)

does a script like this exist?

---------- Post updated at 12:55 PM ---------- Previous update was at 08:25 AM ----------

the setup is like this
there are several servers running simple web servers (apache) with SQL databases.

I want to be able to specify in the script which folders to backup and then sql details

For example
/var
/opt/someprogram

SQL details
all databases
root user
root password

Then the script should (when run via cron every few hours) backup whole /var with all folders, subfolders, files under it with permissions preserved (in a .tar.gz preferably), along with the whole SQL database (all dbs using root/pass combo), and then encrypt them with a GPG encryption with a password I specify in the script.

When I download the backed up file (gpg), I just decrypt it with the pass, and it gives me the tar.gz with includes the selected directories and the sql file in the end.

/var
/opt/someprogram
databases.sql


The amount of data is only about 1-2 GB and the drives are SSD so I do not expect any issues in regards to performance.

I want this data backed up to 2 drives online for redundancy, like Yandex and google drive using the API login.

In the password I specify in the script (For gpg encryption), i would prefer if it was saved in a salted/hashed format in the script file and not visible in plaintext after I saved it.

i hope this is enough information

Dear galapagos8000,

I have a few to questions pose in response first:-Most importantly, What have you tried so far?

There are probably many ways to achieve most tasks, so giving us an idea of your style and thoughts will help us guide you to an answer most suitable to you so you can adjust it to suit your needs in future.

You may need to create the backup then encrypt it as a second step depending on the database you have, but with such an incomplete request and nothing showing where you are up to, there is little I can suggest at this point.



Robin

I am using this script
Shell backup script modification

But I need a new one.

Would this be better continued on the other thread then? People have already been discussing your needs and I'm sure we could consider a variation.

Don't worry about not understanding it all, let's work out what you do know, then we can work through the code explaining it and you should end up being able to support it in future.



Kind regards,
Robin