rename - How to add #prefix of all tables in #mysql - Stack Overflow
▻https://stackoverflow.com/questions/7970798/how-to-add-prefix-of-all-tables-in-mysql
Run all queries that you get from running this query:
SELECT Concat('ALTER TABLE `', TABLE_NAME, '` RENAME TO `dr_', TABLE_NAME, '`;') FROM INFORMATION_SCHEMA.TABLES WHERE TABLE_SCHEMA = '<name of your db>';