Is it possible using events in phpMyAdmin to create an event that will allow me to save the database to a folder every week?
|
1 answer
To save the database every week (every Monday at 00:00), you can use cron'a to execute the command mysqldump
In cron rule
00 00 * * 1 mysqldump -u{пользователь} -p{пароль} --all-databases > /{path_to_backups}/mysqldump_`$(date +\%Y\%m\%d\%H\%M\%S)`.sql 
Stanislav Grot Stanislav Grot
1,920 6 silver marks 21 bronze marks
- I am looking for a way to do this with event. Is there any way to do this with the help of event in phpMyAdmin? - Yevgeniy Bagackiy
- onephpMyAdmin is a web interface. Use mysqldump - ilyaplot
|