On 30-8-2011 21:18, Benoît Minisini wrote: >> I need that the "insert" statement to be logged in the binary log. >> > I have no idea why it is not logged. I didn't know there was a "mysql binary > log", and I don't know how it works. > > Try to set 'DB.Debug = True' to see what SQL queries are sent to the SQL > client library. > > Regards, >
The advantage for having your mysql server run in binary log mode, is that you can make live incremental backups. After enabling, you can simply do: rsync -a /var/lib/mysql/<dbname>-bin* /backup/location Regards, Ron_2nd. ------------------------------------------------------------------------------ Special Offer -- Download ArcSight Logger for FREE! Finally, a world-class log management solution at an even better price-free! And you'll get a free "Love Thy Logs" t-shirt when you download Logger. Secure your free ArcSight Logger TODAY! http://p.sf.net/sfu/arcsisghtdev2dev _______________________________________________ Gambas-user mailing list Gambas-user@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/gambas-user