Creating the dumpfile
1.Stop the JobScheduler
2.Create a dump of history tables
./mysqldump scheduler SCHEDULER_HISTORY SCHEDULER_ORDER_HISTORY SCHEDULER_ORDER_STEP_HISTORY SCHEDULER_VARIABLES --host=<host> --port=<port> --user=<user> -p --add-drop-table --skip-comments --single-transaction --opt > scheduler_history.dmp
3.create an archive database
prompt:~> /opt/mysql-5.0.15/bin/mysql --host=<host> --port=<port> --user=<user> -p scheduler_archive mysql> create databasde scheduler_archive mysql> exit
- import dump to the archive
prompt:~>./mysql --host=<host> --port=<port> --user=<user> -p scheduler_archive < scheduler_history.dmp
How to access logs from the archive by id
Setup a new job scheduler instance. This instance should have no own jobs.
To access a task log
http://localhost:4444/show_log?task=1262811
To access an order log
http://localhost:4444/show_log?order=backup_pg_sql&history_id=403816