Home / Tricky Select Queries / Question No: 46

I want to take data back up of my database table. Is there any easiest way to take data back up of a single table?

You may try this to get data backup of a table:

CREATE TABLE backup_MyTable SELECT * FROM MyTable;

This builds a backup table without the indexes so you can easily copy the data back using an INSERT statement.