This article is half-done without your Comment! *** Please share your thoughts via Comment ***
In this post, I am sharing a solution to take an only table or few tables backup in MySQL and also sharing solution like, How you can ignore few tables while taking a backup of MySQL Database.
In last year, I shared a basic article on how to take a backup of the database in MySQL, which also you can access here.
The copying data from one server to another, data migration, the backup requirement for specific data or object or stored procedure, data versioning – These all are part of DBA’s day to day activity, and N number combinations are there.
There are many options available for mysqldump utility, so I am using few options to play for table backup only. Let me explore few options related to table backup in MySQL.
Take a backup of a single table:
|
1 |
mysqldump -u |
Take a backup of multiple tables:
|
1 |
mysqldump -u |
Ignore a table from full database backup:
|
1 |
mysqldump -u |
Leave a Reply