How to take backup of a table in MySQL? I have a database which contains many tables. What is the command to take the backup of one table with data from database?
mysqldump tool is very useful. You have to use the mysqldump tool to take the backup of one table from database.
The mysqldump tools comes with mysql distribution. You can find it in the bin directory of your MySQL installation.
On Linux it is accessible from the command prompt. You can use the following command to take the backup of one table from database.
mysqldump -u -p mydatabase mytable> mytable.sql