Recently I was looking for a solution to backup my website and the MySQL database to a Dropbox account…

These are the steps you’d want to follow:

1. Get the DropboxBack script from: https://github.com/Nyr/DropboxBackup#readme
   follow the instructions here to install:https://github.com/Nyr/DropboxBackup/blob/master/README.md
2. Install rar on your server:
   apt-get install rar
   # if it fails, follow this post: install rar on ubuntu
3. Setup cronjob that will run it daily. example (runs every day at 12 o’clock):

   # m h dom mon dow command
   0 12 * * * /bin/bash /root/dropboxbackup-daily.sh

4. If during the backup process, you notice the following error:
   mysqldump: Got error: 1044: Access denied for user ‘root’@’localhost’ to database ‘information_schema’ when using LOCK TABLESThen do the following:
   # login to mysql
   $ mysql -u root -p#And type:
   mysql> GRANT SELECT,LOCK TABLES ON DBNAME.* TO ‘username’@’localhost’;
   (replace the username with the actual user that you see in the above error message).