4

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?

RolandoMySQLDBA
  • 185,223
  • 33
  • 326
  • 536
IgorAlves
  • 337
  • 3
  • 5
  • 16

1 Answers1

4

Dumping subsets of table data can only be done backing up individual tables.

I once answered a post entitled Is it possible to mysqldump a subset of a database required to reproduce a query?. In that post, I used mysqldump strictly against the tables in question.

The only thing you can do is to produce two dumps

  • mysqldump of the database without table1 (means you have to name all other tables (See my old post How do you mysqldump specific table(s)?)
  • mysqldump only table1 using -w or --where
  • concatenate the second dump to the first dump

Give it a Try !!!

Community
  • 1
RolandoMySQLDBA
  • 185,223
  • 33
  • 326
  • 536