I remember back in the days backing up vbulletin with mySql but l'm wondering if that is the method of doing it with Xen and two if so can somebody refresh my memory on how it's done? Thanks
Further to my post #18 above the Access denied message is :
12:21:15 Dumping DBName (xf_class_extension)
Running: /Applications/MySQLWorkbench.app/Contents/MacOS/mysqldump --defaults-file="/var/folders/8v/hclstpf56f953879w7xwy2jm0000gn/T/tmpvNktUJ/extraparams.cnf" --user=XXXXXXX --host=123.123.123.123:3306 --protocol=tcp --port=3306 --default-character-set=utf8 --skip-triggers --column-statistics=0 "DBname" "xf_class_extension"
mysqldump: Error: 'Access denied; you need (at least one of) the PROCESS privilege(s) for this operation' when trying to dump tablespaces
NB I've redacted/changed sensitive information from the message.
This message appears 215 times in my log .
I've 215 files in my off-site back up, therefore it's appearing for every file there's an error logged.
However when I check the file size of my overall back up it's 51Mb the same as the DB size according to the server stats via my hosts control panel.
So I'm a little perplexed being a newbie to these things, has my DB been backed up or not?
I am running 2 cron jobs for backing up my DB.
One runs every 6 hours and makes a incr backup.
Once a week the other cron runs a full backup. This is around 29 GB.
They are hot backups. Means i don't shut down the forum.
Since i use Percona Mysql i use their Scripts. Can be used also with Mysql or Maria (they also have their own tool)
The xtrabackup tool has several features to enable scripts to control it while they perform related tasks. The innobackupex script is one example, but xtrabackup is easy to control with your own command-line scripts too.
www.percona.com
After the cron is finished another cron with rclone send the backups to my Cloud space.
The forum itself i backed up 1 Time into the cloud space. One time is enough because the size of my forum is 386 GB.
So every 3 hours rclone sync it with the cloud.