6 messages in com.mysql.lists.clusterRe: cluster backup
FromSent OnAttachments
Matteo Vadagnini01 Feb 2008 03:08 
Geert Vanderkelen01 Feb 2008 03:17 
Matteo Vadagnini01 Feb 2008 03:24 
Wilersh01 Feb 2008 03:25 
Geert Vanderkelen01 Feb 2008 03:36 
Matteo Vadagnini01 Feb 2008 03:39 
Subject:Re: cluster backup
From:Matteo Vadagnini (mvad@h-care.it)
Date:02/01/2008 03:24:05 AM
List:com.mysql.lists.cluster

Sorry, I forgot to say some important requirements... I'm using MySQL 5.0 and I need something that I can put on another server, if needed.

Il Friday 01 February 2008 12:17:29 Geert Vanderkelen ha scritto:

On Feb 1, 2008, at 12:09 , Matteo Vadagnini wrote:

Hi to everyone! What is the best way to do a backup of a mysql custer? I'm using mysqldump, at this moment, but I would like to know if there is a better way to do it.

There is only one way really: ndb_mgm> START BACKUP;

See: http://dev.mysql.com/doc/refman/5.1/en/mysql-cluster-backup.html

I would only use mysqldump to get the DDL (schema information), just to have it in SQL format. Sometimes handy.

Cheers,

Geert