I have a database (myDB) that holds some tables. During my backup process I have one of those tables that should be filtered. So I want to backup only a subset of rows inside table1, when I backup the entire database.
I am using mysqldump like this:
mysqldump -uUSER -pPASSWORD --routines --add-drop-database --databases myDB --tables table1 -w "id<3"> myDB_BK.sql
The subset rows is correct for table1 but I dont have the entire database. Only the specified table1.
I've tried all combination with no success.
Any Idea in how to accomplish this task?