Don ta atomatik backup
ko MySQL
bayanan MariaDB yau da kullun ta amfani da MySQLDump, zaku iya bin matakan da ke ƙasa:
Ƙirƙiri fayil ɗin rubutun madadin
Ƙirƙiri fayil ɗin rubutun(misali, backup.sh
) don ƙunshe da umarnin madadin. Bude editan rubutu kuma ƙara umarni masu zuwa zuwa fayil ɗin rubutun:
Ajiye fayil ɗin rubutun kuma tabbatar yana da izini masu aiwatarwa. Don yin wannan, gudanar da umarni mai zuwa:
Saita aikin madadin atomatik
Yi amfani da cron
jadawali don saita aikin madadin atomatik na yau da kullun. Bude jadawalin cron ta hanyar gudanar da umarni:
Ƙara layin da ke gaba zuwa fayil ɗin cron don saita aikin madadin yau da kullum a 2 AM:
Ajiye kuma rufe cron
fayil ɗin jadawalin.
Za a aiwatar da rubutun backup.sh
yau da kullun a 2 AM, kuma zai adana MySQL
bayanan ko MariaDB zuwa fayil ɗin th e backup-YYYY-MM-DD.sql
a cikin ƙayyadadden jagorar.
Lura cewa a cikin rubutun, kuna buƙatar maye gurbin username
, password
, da kuma database_name
tare da ainihin bayanan shiga da sunan bayanai. Hakazalika, canza /path/to/backup/directory
zuwa ainihin hanyar ajiyar ajiyar ajiya akan tsarin ku.