There are few other threads about this question using mysqldump but however i tend to not use mysqldump but instead backup the whole files in /mysql.
I would like to create a cronjob in mysql slave which only involves
slave
and slave
.
I only know how to use crontab with starting and stopping mysql (as below). Instead i have no idea how to insert start and stop slave in crontab. Any help?
19 * * * service mysql stop;rsync -avzr -e 'ssh -p 22' /home/mysql /home/DAILY-BACKUP-SQL;service mysql start
Asked by Daniel
Oct 17, 2021, 02:57 PM
Last activity: Oct 26, 2021, 04:18 PM
Last activity: Oct 26, 2021, 04:18 PM