Product Knowledge Base

Space shortcuts

Page tree

Versions Compared

Old Version 7

changes.mady.by.user Uwe Risse

Saved on

compared with

New Version 8

changes.mady.by.user Unknown User (admin)

Saved on

Key

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

...

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 Create an archive database

Code Block
 prompt:~> ./mysql --host=<host> --port=<port> --user=<user> -p scheduler_archive 
 mysql> create database scheduler_archive
 mysql> exit

4.import Import dump to the archive

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

...