RENAME TABLE table_name_1 TO table_name_2;
This statement was added in MySQL 5.1.7 but was found to be dangerous and was removed in MySQL 5.1.23. ... However, use of this statement could result in loss of database contents, which is why it was removed. Do not use RENAME DATABASE in earlier versions in which it is present.
RENAME TABLE DB_NAME_1.table_name_1 TO DB_NAME_2.table_name_2;