Replicate your databases to another server, and take your dumps from that, so you can lock your replication slave and take your dumps while your site is still running. As an added bonus, you get a server suitable for manual failover should anything happen to your master database.
-Sheeri On 3/10/06, Rithish Saralaya <[EMAIL PROTECTED]> wrote: > >>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. > > > -- > MySQL General Mailing List > For list archives: http://lists.mysql.com/mysql > To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED] > > -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
