Use mysqldump to backup table with a new table name
You have to use sed to transform the table name

mysqldump -u user -p db_name test_table | sed 's/test_table/test_table_backup/g' &gt; backup.sql


Give it a Try !!!