...
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 |
...