Can pt-archiver archive multiple tables

MySQL & MariaDB Other MySQL® Questions
1

I have read through so much documentation and I have tried to specify multiple tables but I don’t think this is possible without some scripting. I can get one table to archive to a file. Has anyone written a script to specify multiple tables to be archived? I think I will need to create a plugin with a variable for table written in perl. If someone has already done this I would appreciate the help.

Thanks,
Luke

1 Like
2

Hi, you don’t need to use perl here, why not simply write a simple bash script with a loop to invoke pt-archiver multiple times?

1 Like
3

I can give that a try, I was just trying to find out what the best practice was for the archiver. Maybe I was making it too complicated.

Thanks for the reply.

1 Like