Make a duplicate table with all the data

MySQL / PHP

I am adding a facility for clearing out a database so it’s empty ready for another year of data. I want to create a backup of that data before I delete it all but I can’t see how to achieve this in Wappler. Would I need to do some custom SQL or is there a Wappler way?