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
If you are facing any programming issue, such as compilation errors or not able to find the code you are looking for.
Ask your questions, our development team will try to give answers to your questions.