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).