Versions Compared

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.

...

Code Block
 prompt:~>./mysql --host=<host> --port=<port> --user=<user> -p scheduler_archive < scheduler_history.dmp

5.Delete old records (please check scheduler_archive before doing this)

Code Block
 prompt:~> ./mysql --host=<host> --port=<port> --user=<user> -p scheduler 
 mysql> delete from SCHEDULER_HISTORY where start_time < '2012-01-01';
 mysql> delete from SCHEDULER_ORDER_HISTORY where start_time < '2012-01-01';
 mysql> delete from SCHEDULER_ORDER_STEP_HISTORY where start_time < '2012-01-01';
 mysql> exit

...