I should note that storing backups in the same database on the same server on the same disk drive is not a good idea. One disk drive failure and everything is gone.
At the minimum, you should have two disk drives and then tell MySQL to put the backups tables on the backup disk drive. (Yes, MySQL can store different databases on different drives.)
Better is to use mysqldump to create text files as backups and store them offline and/or on some other server.
An optimist sees the glass as half full.
A pessimist sees the glass as half empty.
A realist drinks it no matter how much there is.