There is no pre-built table, direct backup, but MySQL does not support select into to back up the table, but you can use the following table statement to back up:
CREATE TABLE User_backup (SELECT * from user), select * from User_backup;
[Sql]create Table User_backup (SELECT * from user); Affected Rows:22time:0.129s[sql]select * from User_backup; Affected rows:0time:0.001s
mysql> INSERT INTO User_temp (SELECT * from user); Query OK, Rows affectedrecords:22 duplicates:0 warnings:0mysql> select * from User_temp;
mysql> truncate TABLE user_temp; Query OK, 0 rows affectedmysql> select * from User_temp; Empty Set
Use Hunlian;select * to Member_backup in Hunlian-test.mdb from Hunlian.dbo.member;
[Sql]use hunlianaffected Rows:0time:0.007s[sql]select * into Member_backup in Hunlian-test.mdb from hunlian.dbo.member[ ERR] 42000-There is a syntax error near the [SQL Server] keyword ' in '. Affected rows:0
Use hunlian;/* because the two tables contain the same ID field, the direct select * from conflict */select Member.name,member.mail,userinfo.city,userinfo.birthday into Member_backup from Memberinner join userinfo on member.id = Userinfo.id;select * from Member_backup;select * from member I Nner Join userinfo on member.id = userinfo.id;
MySQL Table Backup