Backup to Dropbox in Ubuntu

[pinguy]

To Backup files to Dropbox run:

Code:

wget -O dropbox_uploader.sh https://raw.githubusercontent.com/andreafabrizi/Dropbox-Uploader/master/dropbox_uploader.sh
chmod a+rx dropbox_uploader.sh
sudo mv dropbox_uploader.sh /usr/local/bin/dropbox_uploader
sudo chown root:root /usr/local/bin/dropbox_uploader
dropbox_uploader

Follow the on prompt commands because you will need to create a Dropbox API.

For tips on how to use the script see: https://github.com/andreafabrizi/Dropbox-Uploader

Once complete you can make a cron job to backup the whole site to Dropbox.

Example:

This is to backup the whole site to Dropbox once a Month.

Code:

nano /etc/cron.monthly/backup

Code:

#!/bin/bash
rm -rf /var/sentora/hostdata/zadmin/backup.zip
cd /var/sentora/hostdata/zadmin/
zip -r backup.zip public_html
dropbox_uploader delete /backup.zip
dropbox_uploader upload /var/sentora/hostdata/zadmin/backup.zip /backup.zip
exit 0

F3 will save the file and Ctrl+X will exit nano.

Next set permissions and make it executable.

Code:

sudo chmod +x /etc/cron.monthly/backup
sudo chmod 755 /etc/cron.monthly/backup

To backup databases to Dropbox daily run:

Code:

nano /etc/cron.daily/database

Code:

#!/bin/bash
mkdir -p /var/sentora/hostdata/zadmin/database
mysql -u root -p*PASSWORD* -e "FLUSH TABLES WITH READ LOCK;"
mysqlcheck --auto-repair -Aos -u root -p*PASSWORD*
mysqldump -u *USER* -p*PASSWORD* *DATABASE_NAME* > /var/sentora/hostdata/zadmin/database/*DATABASE_SAVE*.sql
*Repeat the above line for each database*
mysql -u root -p*PASSWORD* -e "UNLOCK TABLES;"
rm -rf /var/sentora/hostdata/zadmin/database.zip
cd /var/sentora/hostdata/zadmin/
zip -r database.zip database
rm -rf /var/sentora/hostdata/zadmin/database
dropbox_uploader delete /database.zip
dropbox_uploader upload /var/sentora/hostdata/zadmin/database.zip /database.zip
exit 0

F3 will save the file and Ctrl+X will exit nano.

Next set permissions and make it executable.

Code:

sudo chmod +x /etc/cron.daily/database
sudo chmod 755 /etc/cron.daily/database

What's great about doing this is Dropbox keeps backups of the files for up to 30 days (trust me this has saved my ass more then once). So it makes it pretty easy to roll back to an older backup of the database.

Also if you use the desktop client you will have synced local copies of the site and databases on your PC.

As my site is just under 2GB (zipped) I have no issues using the free version of Dropbox (free version offers up to 16 GB). So I do find this an elegant free solution to keep backups.

[liamgreen]

This is brilliant, Have to have a look at this. Do you also know of a way to get the MySQL databases to back up to dropbox?

[pinguy]

This is brilliant, Have to have a look at this. Do you also know of a way to get the MySQL databases to back up to dropbox?

Details are posted in the first post.

[pinguy]

After all this time, this still works great for me. I even found out that Dropbox keeps old versions of the backup. So if the backup is fubar dropbox probably has an older working version.

[TGates]

Have you tried the Dropbox backup module? I'd have to recheck it,to see if it does the db also. And, find out where it is lol. I thought I had updated the old one and posted it to my repo but can't find it.(on my phone atm) will look into it.

[pinguy]

Have you tried the Dropbox backup module? I'd have to recheck it,to see if it does the db also. And, find out where it is lol. I thought I had updated the old one and posted it to my repo but can't find it.(on my phone atm) will look into it.

Nope. This method works really well for me. There is probably better options, but why try and fix something that isn't broken.

If there is away to do this that is hands down better, I will look into it. As it stands at the moment this works and I haven't seen another method that is better.

[FernandoGarcia]

Hi!

After run this command line:

Code:

mysqlcheck --auto-repair -Aos -u root -p'password'

The log to "datalog" table is:

Code:

databaseName.datalog
error    : Can't create new tempfile: './databaseName/datalog.TMD'

After this command the table "datalog" is marked as crashed and last repair failed.

Then trying to run this SQL

Code:

REPAIR TABLE  `datalog`

The error is:

Code:

error    : Can't create new tempfile: './databaseName/datalog.TMD'

This command doesn't work too the error is equal.

Code:

myisamchk -r /var/lib/mysql/databaseName/datalog.MYI

I'm using mysql 5.5.53

The engine for this table is MyISAM.

Do you have any idea how to fix this table now?

Best regards.

[TGates]

Try using sudo or root user... sounds like a permission issue.

[FernandoGarcia]

Try using sudo or root user... sounds like a permission issue.

I did it already, same result.

[TGates]

How about:

Code:

myisamchk -r -f datalog.MYI

Also, another thing to try, is to move directly into that file's folder and run the above command, another suggestion would be to stop mysql, run the command, restart mysql.