Quickly back up a MySQL or MariaDB table

CREATE TABLE table_backup LIKE my_friend
INSERT INTO table_backup (SELECT * FROM table)