… innodbackup tool and InnoDB Hot Backup online backup. 2) Do we need to run patched MySQL, because the build instruction mentions the patch for MySQL ? A… feature which is not available for InnoDB users in any form so far – it is incremental and differential backups. Having that you will…
Post: Database problems in MySQL/PHP Applications
August 11, 2006 By 13 Comments
… and profiling tools, as well as have tools which protect you from SQL Injections. For example I …MySQL and LAMP Consuilting Services. 2. Not using auto_increment functionality This is right. With some exception however. For…. It is also much easier to do backup and restore if you need only portion …
Post: xtrabackup-0.8
July 1, 2009 By 8 Comments
….8 of the opensource backup tool for InnoDB and XtraDB is available for download. Key features… to include incremental fix error handling of tar stream The binary packages for RHEL4,5, Debian, FreeBSD as well as source code of the XtraBackup is available on http://www.percona.com/mysql…
Post: How Percona does a MySQL Performance Audit
November 24, 2008 By 17 Comments
… tools to gather a lot of the data for…mysql –user=mysql –pid-file=/var/run/mysqld/mysqld.pid –skip-external-locking –port=3306 –socket=/var/db/mysql/mysql…second and subsequent are incremental differences. I’ll …for sending, add in things I may have noticed along the way (comments on backups, for…
Comment: Thoughs on Innodb Incremental Backups
November 10, 2008 By 8 Comments
> The Innodb pages have great deal of information helpful for their incremental backup in their internal. I wonder if that information can be *properly* accessed by an external tool, or whether the tool will need to be built into MySQL.
Comment: Database problems in MySQL/PHP Applications
August 11, 2006 By 13 Comments
…use > mysql_ functions directly as well – I would go for using… and profiling tools, as well as have > tools which …increment functionality This is right. With some > exception however. For example Innodb tables do internal full table > lock if auto_increment…much easier to do backup > and restore if …
