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