
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:
- 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 - Install rar on your server:
apt-get install rar
# if it fails, follow this post: install rar on ubuntu - 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 - 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).
Leave a Reply