LMSouq
database Open

How to skip certain database tables with mysqldump?

ZA
Zac
1 month ago
3 views
Problem Description
Is there a way to restrict certain tables from the mysqldump command? For example, I'd use the following syntax to dump *only* `table1` and `table2`: ```lang-none mysqldump -u username -p database table1 table2 > database.sql ``` But is there a similar way to dump all the tables *except* `table1` and `table2`? I haven't found anything in the mysqldump documentation, so is brute-force (specifying all the table names) the only way to go?

AI-Generated Solution

Powered by LMSouq AI · GPT-4.1-mini

✓ Solution Ready
Analyzing problem and generating solution…
Was this solution helpful?
Back to Knowledge Base