Explain how to Dump specific table into file and Dump only table structure providing appropriate example.
SOLUTION....
Dumping Specific Table into a File
When working with databases like MySQL, you may not always want to back up the entire database. Sometimes you only need to export (dump) a single table’s data. This can be done using the mysqldump utility.
Syntax:
Explanation:
mysqldump→ Tool used to export data from MySQL.-u username→ Your MySQL username.-p→ Prompts for password.database_name→ The database containing the table.table_name→ The specific table to dump.filename.sql→ File where dump is saved.
Example:
🔹 Dumping Only Table Structure (No Data)
Sometimes you only want the table structure (schema), without inserting the actual records. This is useful when you want to recreate the table elsewhere but don’t need the data.
Syntax:
Explanation:
--no-data→ Ensures that only the CREATE TABLE statement is exported, withoutINSERTqueries.
Example:
Key Points to Remember:
Use
mysqldumpfor exporting both structure and/or data.To dump only specific tables → provide the table name after the database name.
To dump only table structure → add the
--no-dataoption.To dump only table data without structure → use
--no-create-info.