New feature for MyDump. Add IGNORE argument
Posted: Tue 28 Aug 2007 11:46
Hello
I've just had a need of a nice (in my opinion) feature from MyDump.
I have 2 databases. In two different countries. One table of one DB has to be transfered to another DB. But during the day data are inserted in both DBs. It is a kind of master-slave relationship.
So the solution I've found is to dump only the data from the slave with 'IGNORE' argument of the INSERT command and to restore it to the master. This way the records that exists already on the master are ignored, and the new ones are inserted.
Easy and simple.
The main problem is that MyDump does not support including 'IGNORE' argument. By now I've done it by hand. But I guess this would be a very nice feature to add in MyDump in the future.
Tell me your opinion about this. Thanks
I've just had a need of a nice (in my opinion) feature from MyDump.
I have 2 databases. In two different countries. One table of one DB has to be transfered to another DB. But during the day data are inserted in both DBs. It is a kind of master-slave relationship.
So the solution I've found is to dump only the data from the slave with 'IGNORE' argument of the INSERT command and to restore it to the master. This way the records that exists already on the master are ignored, and the new ones are inserted.
Easy and simple.
The main problem is that MyDump does not support including 'IGNORE' argument. By now I've done it by hand. But I guess this would be a very nice feature to add in MyDump in the future.
Tell me your opinion about this. Thanks