Is there a way to back up a table using
mysqldump so the table that is being backed up can have a new name in the
sql script created by mysqldump.
So that If I back up the table 'test_table' like so.
mysqldump -u user -p db_name test_table > backup.sql
and I want 'test_table' to now be called 'test_table_backup' in the
backup.sql that is created.
CREATE TABLE `test_table_backup` ( ... );
I know i can just dump the file then craft some way to do a search and replace on the table name but I was hoping there was a safer way using mysqldump itself.