>>Your table is missing. Try this:
>>mysqldump --single-transaction -u root clientdb <table>
>>--where="FLD_CLIENT_ID=1" > client1_dbbackup.sql
>Yes. The tables are missing. That's because I want the backup of all the
>tables in the db, and those tables that have the column FLD_CLIENT_ID, they
>should be filtered by the where clause.
>
>This is because, if we are to reproduce the system for a client, then all
we
>need to do is to run this backup on a new db.
So, it looks like I will have to backup the db in phases.
1. Backup client-specific tables
mysqldump --single-transaction -u root clientdb table_M1 table_M
table_MX --where="FLD_CLIENT_ID=1" > client1_dbbackup.sql
2. Then append the other tables to the backup.
mysqldump --single-transaction -u root clientdb table_N1 table_N2 table_NX
>> client1_dbbackup.sql
However, this means that I cannot take a backup when the system is up and
running.
Any other ideas, folks?
Regards,
Rithish.
