I see in the mysqlcheck manual that there's an option for --tables that overrides that databases option, but it isn't well explained.
I'm trying to run mysqlcheck -o and I want it to optimize a specific table that exists in every database, but only that table.
** I think I may not have been clear enough
I have 250 databases that all contain the table api_log. I want to run a single command that will optimize just the table api_log, but on every database that mysql server has.
mysqlcheck -o --tables api_log -A
Obviously this specific snippet won't work, but it expresses what I'd like to accomplish. I don't want to optimize every table in every database, just one table that exists in all 250 databases.