Welcome to the Linux community forum, interact with 2 million technical staff into 1. Modify the table name SQL code altertablet1renametot1_back_201305022. Export Structure SQL code mysqldump-h192.168.1.1-uroot-p1234 -- default-character-setutf8 -- opt-d-Rdbnametablenamed: data_f
Welcome to the Linux community forum and interact with 2 million technical staff> enter 1. alter table t1 rename to t1_back_20130502 2. export structure SQL code mysqldump-h192.168.1.1-uroot-p1234 -- default-character-set = utf8 -- opt-d-R dbname tablename d: \ data_f
Welcome to the Linux community forum and interact with 2 million technicians>
1. Modify the table name
SQL code
Alter table t1 rename to t1_back_20130502
2. Export Structure
SQL code
Mysqldump-h192.168.1.1-uroot-p1234 -- default-character-set = utf8 -- opt-d-R dbname tablename> d: \ data_file_table_130507. SQL
3. Export data again
SQL code
Mysqldump-h192.168.1.1-uroot-p1234 -- default-character-set = utf8-t-c dbname tablename> d: \ data_file_data_130507. SQL
4. Import Data
SQL code
Source D:/data_file_table_130507. SQL
Source D:/data_file_data_130507. SQL