Create backup table of a DB table

You can create a backup of table with data using AS clause, like : 

CREATE TABLE user_bkp 

AS SELECT * FROM user;