How can we backup specific tables from database using mysqldump client program?

By using the mysql dump client program, we can back up specific tables in the database to files with the extension ".sql". It can be understood through the following example -

Example

In this example, with the help of mysql dump client program, we backup from the "query" database in a file named "student_info.sql" Table named "student_info". The following command will do this:

C:\mysql\bin>mysqldump -u root query student_info > student_info.sql

The above command will create a file named student_info.sql that contains dump information for the file named "student_info" in the database named "query".

The above is the detailed content of How can we backup specific tables from database using mysqldump client program?. For more information, please follow other related articles on the PHP Chinese website!