This article is half-done without your Comment! *** Please share your thoughts via Comment ***
In the previous article, I shared few mysqldump options to take the table only backup or ignore few tables from the full database backup.
In addition to the previous post, here I am sharing other relevant options to take the backup of table structure or take the backup of table data only.
Why we need this kind of choices? Because sometimes we need to create a database with empty tables in a new server and in that newly created database we might require to insert data from another server.
So there are few requirements for table structure and table data which require loading from different servers.
Take a backup of table structure only:
1 |
mysqldump -u user_name -p --no-data db_name > db_backup.sql |
Take a backup of table data only:
1 |
mysqldump -u user_name -p --no-create-info db_name > db_backup.sql |
Leave a Reply