Does number of backup tables hinder performance
As long as the database and its tables and many indexes are just sitting there, there is essentially no harm:


The extra db and tables have no impact on your ordinary queries.
Some meta operation involving the information_schema will notice them.
The copy takes disk space.  (So would a dump.)


An advantage over a dump:  You can quickly perform a query on the old copy.