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.