mysql-cluster + mysqldump

Piotr Kirklewski — Fri, 14 Dec 2007 17:59:47 GMT

Hi there

My task is to perform backup on mysql-cluster from managemenet node using mysqldump.

START BACKUP; is working fine but we need to be sure thet we have sql file as well as it's more convinient etc.

I was trying to use this script:

#!/bin/sh

MAILTO=xxx@xxx.com

ndb_mgm -e "ENTER SINGLE USER MODE 4"; sleep 10;

mysqldump -u xxx -p --password=xxx --lock-tables xxx_production > backup-xxx_production.sql;

ndb_mgm -e "EXIT SINGLE USER MODE";

ndb_mgm –e "START BACKUP WAIT COMPLETED"

But it gives me an empty file.

Does enybody know why?

Best Regards

Peter

Re: mysql-cluster + mysqldump

Piotr Kirklewski — Sat, 15 Dec 2007 11:13:53 GMT

Sorted !

You have to ganerate keys to make the script login to the servers without password.

Best Regards

Peter

#!/bin/sh

MAILTO=me@mydomain.com

ndb_mgm -e "ENTER SINGLE USER MODE 4"; sleep 10;

ssh -p 22 user@server 'mysqldump -u root -p --password=xxx --lock-tables dbname_production > /home/username/backup/backup-dbname_production.sql'

ndb_mgm -e "EXIT SINGLE USER MODE";

ndb_mgm -e "ENTER SINGLE USER MODE 5"; sleep 10;

ssh -p 22 user@server1 'mysqldump -u root -p --password=xxx --lock-tables dbnaem_production > /home/username/backup/backup-dbname_production.sql'

ndb_mgm -e "EXIT SINGLE USER MODE";

ndb_mgm -e "START BACKUP WAIT COMPLETED"

topic mysql-cluster + mysqldump in Operating System - Linux

mysql-cluster + mysqldump

Re: mysql-cluster + mysqldump