...
Creating the dumpfile
1.Stop the JobScheduler
2.Create a dump of history tables
...
| Code Block |
|---|
prompt:~> /opt/mysql-5.0.15/bin/mysql --host=<host> --port=<port> --user=<user> -p scheduler_archive mysql> create databasdedatabase scheduler_archive mysql> exit |
4.import dump to the archive
| Code Block |
|---|
prompt:~>./mysql --host=<host> --port=<port> --user=<user> -p scheduler_archive < scheduler_history.dmp
|
5.Optional drop the archived tables (DO NOT DROP SCHEDULER_VARIABLES!!!!!!!!!!!!!!!!!)
| Code Block |
|---|
prompt:~> ./mysql --host=<host> --port=<port> --user=<user> -p scheduler
mysql> drop table SCHEDULER_HISTORY
mysql> drop table SCHEDULER_ORDER_HISTORY
mysql> drop table SCHEDULER_ORDER_STEP_HISTORY
mysql> exit
|
6.Recreate the tables
| Code Block |
|---|
prompt:~> ./opt/sos-berlin/..../install/scheduler_install_tables.sh
|
How to access logs from the archive by id
...