How to Take Backup of a Table in MySQL

---

In this post, I am going to show you couple of ways to take the tables backups in MySQL.

---

Taking Backup of a MySQL Table Using LIKE

 

CREATE TABLE tbl_backup;
INSERT INTO tbl_backup SELECT * FROM tbl_original;

---

Taking Backup of a MySQL Table Using mysqldump

 

mysqldump -u <backup_user> -p <backup_password> db_name table_name > backup_file.sql

 

 

---