Not the answer you need?
Register and ask your own question!

pt-archiver temp table in --dest

smith18smith18 EntrantCurrent User Role Beginner
Quick question on pt-archiver -- will the tool create a temp table on destination databse or do we need to create a table and provide that information in --dest

Example : just give host and Databse in --dest so that tool creats temp table
pt-archiver --source h=<server_source>,D=<database_source>,t=<your_table> --dest h=<server_target>,D=<database_target>

OR
Example : first create a temp table with same schema as source and provide table name in the command ? like
pt-archiver --source h=<server_source>,D=<database_source>,t=<your_table> --dest h=<server_target>,D=<database_target>,t=<your_table_archive>

just want to know if tool creats a automatic temp table ? any help would be appriciated. Thank you

Comments

  • carlos.salguerocarlos.salguero Percona Toolkit Developer Percona Staff Role
    You need to create the destination schema and table and provide the connection params using --dest
  • smith18smith18 Entrant Current User Role Beginner
    how can we handle slaves ? and slave_lag ? can we use --recursion-method="dsn=D=my_db,t=dsns" and provide slave information in table named dsns ?
Sign In or Register to comment.

MySQL, InnoDB, MariaDB and MongoDB are trademarks of their respective owners.
Copyright ©2005 - 2020 Percona LLC. All rights reserved.