Is there anyway of doing what is described below with version 5 or will
I l have to wait for MySQL 6.0
PlanetMySQL Blog: MySQL 6.0 Feature #2: Online Backup
Alexander Nozdrin, Chuck Bell, Lars Thalmann, Peter Gulutzan, Rafal Somla
BACKUP DATABASE copies all data and metadata in on
I have worked as a DBA for a long time, just not with MySQL and I have
spent a lot of time making sure the application is secure. I suppose my
question was really what is the best way to do incremental backups? The
DB I have most experience with has thing like after imaging etc. which
allows
On Wed, May 14, 2008 at 11:13 PM, John Comerford
<[EMAIL PROTECTED]> wrote:
> Quickly scanning this page, it doesn't seem to give syntax for an
> incremental backup. I am hoping to be able to run something that dumps only
> data changed since the last backup.
>
You could use diff and the previous
Quickly scanning this page, it doesn't seem to give syntax for an
incremental backup. I am hoping to be able to run something that dumps
only data changed since the last backup.
Rob Wultsch wrote:
On Wed, May 14, 2008 at 10:25 PM, John Comerford
<[EMAIL PROTECTED]> wrote:
2) Incremental
On Wed, May 14, 2008 at 10:25 PM, John Comerford
<[EMAIL PROTECTED]> wrote:
> 2) Incremental Backups - say one every half hour, then a script to transfer
> that to an off site machine that way I can get the DB back to within the
> last good half hour...
http://dev.mysql.com/doc/refman/5.0/en/mysql
Hi Folks,
I am fairly new to MySQL and I am going to be setting up a web site on a
third party hosting machine. I continuously hear horror stories about
machines/sites being hacked and databases being destroyed. Despite my
best efforts I am sure I have some security flaws in my site. What I
