Events (Job Scheduler) | Forum profile

Try to backup events using mysqldump program and --events or -E option. Or you could backup them with Generate DDL or SchemaExport tool in dbForge Studio for MySQL. These tools allows you to make DDL statements or scripts of existing database objects. Find more information about dbForge Studio for MySQL here - http://www.devart.com/dbforge/mysql/studio/ Devart Company, ...

Any help, anyone?

Events do not have such capabilities, but you could do it in a different way. So, write a '.bat' file that starts your MySQL service and runs your SP after. Example: net start [MySQLserviceName] mysql\bin\mysql --host=[hostName] --user=[userName] --password=[password] --execute="call db_name.proc1()" Execute command can be included in a script file: mysql\bin\mysql --host=[...

No one?

fixed Edited 2 time(s). Last edit at 11/11/2009 10:02AM by ashr ben.

That is right. Event's support was added in MySQL 5.1.6. To work with evenets you should use version of MySQL 5.1.6 or higher. Devart Company, Database development tools http://www.devart.com/dbforge .

Events are executed by a event scheduler. Firstly, you should start this one with a next statement: SET GLOBAL event_scheduler = 1; Then, you can create and shedule your event. For example: CREATE DEFINER = 'root'@'localhost' EVENT test.event1 ON SCHEDULE AT '2010-01-01 00:00:01' DO BEGIN INSERT INTO test.table1 VALUES('work'); END Find more information on ...

Please provide output of: mysql> SHOW EVENTS;