How to make a backup using phpmyadmin events?

Question

MySQL

In general, php cannot be used to use cron in phpmyadmin, but I found events in this miracle.

On mysqldump swears. Is it possible to make a backup through events?

Answer 1

Hello,
you all (cron, phpmyadmin, events) mixed together, IMHO.
Cron is an OS-level task scheduler.
PhpMyAdmin is a web interface for managing MySql.
Events is the scheduler inside MySql.
Cron and events (events) in MySql are not related at all. In MySql events, you write some code with SQL commands, and if event_scheduler is enabled, then the database server will process this code at the right time. PhpMyAdmin helps to write this code in the web interface, not in the console. Cron is not needed to process MySql events.
Read here, for example:
https://habr.com/post/123391/
www.rldp.ru/mysql/mysqlpro/events.htm
or in search engines, type "work with events in mysql" - it will display a bunch of links to docks and examples.