| Table of Contents | ||||||||||
|---|---|---|---|---|---|---|---|---|---|---|
|
Creating the dumpfile
1.Stop the JobScheduler
2.Create a dump of history tables
...
| Code Block |
|---|
|
...
. |
...
/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
...
| Code Block |
|---|
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 archivenoformat
| Code Block |
|---|
prompt:~> |
...
. |
...
/ |
...
mysql -- |
...
host=<host> -- |
...
port=<port> -- |
...
user=<user> -p scheduler_archive < scheduler_history.dmp |
...
How to access logs from the archive by id
setup Setup a new job scheduler instance. This instance should have no own jobs.
To access a task log
| Code Block |
|---|
http://localhost: |
...
4444/show_log? |
...
task=1262811
|
To access an order log
| Code Block |
|---|
http://localhost: |
...
4444/show_log? |
...
order=backup_pg_sql&history_ |
...
id=403816
|