Restore database every 15min by cron job

Ditsly

Hello,

I'm using google drive backup for databases and websites, I would like to restore the database every 25 min and replace the database, any ability with AApanel ?

aaPanel_Kern

Ditsly
Hello, aapanel does not have such a function, but you can use cron's Shell Script to execute commands.

Ditsly

aaPanel_Kern

May i know how can i use it or any example from your side ?

aaPanel_Kern

Ditsly
Hello, the following is the command to restore the database: pay attention to replace it with your file, root password, and database name.
Set in cron to run every 25 minutes.
Note that restoring the database will lose your previous data, please carefully consider and backup your data.
/usr/bin/gunzip < /www/backup/database/djangoblog_test_20220613_094353.sql.gz | /www/server/mysql/bin/mysql -uroot -p'9aa923702343f8c2' djangoblog_test