Product Knowledge Base

Space shortcuts

Page tree

You are viewing an old version of this page. View the current version.

Compare with Current View Page History

Version 1 Next »

Creating the dumpfile

  1. Stop the JobScheduler
  2. Create a dump of history tables 
     /opt/mysql-5.0.15/bin/mysqldump 
 scheduler SCHEDULER_HISTORY SCHEDULER_ORDER_HISTORY  SCHEDULER_ORDER_STEP_HISTORY  SCHEDULER_VARIABLES  
 --hosh1. <host> --port<port>  --useh1. <user>  -p 
 --add-drop-table --skip-comments --single-transaction --opt > scheduler_history.dmp
  1. create an archive database 
     prompt:~> /opt/mysql-5.0.15/bin/mysql --host<host> --porh1. <port> --user<user> -p scheduler_archive 
 mysql> create databasde scheduler_archive
 mysql> exit
  1. import dump to the archive 
     prompt:~>/opt/mysql-5.0.15/bin/mysql --hosh1. <host> --port<port> --useh1. <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. http://localhost:4139/show_log?task1262811 http://localhost:4139/show_log?ordeh1. backup_pg_sql&history_id403816

  • No labels