PDA

View Full Version : Retsoring to a remote server problems



BigBirdy
June 15th, 2009, 12:53 PM
I have zrm 2.1 running on on a CentOS 5x host with Mysql 5.1.35. Just a small number of databases, but I believe I have raw and logical backups so when I try to do a restore to a different machine running the same version of mysql,

mysql-zrm --action restore --backup-set MySQL-Full --source-directory /mnt/Backups/MySQL-Full/20090615105058/ --host secondserver

I get prompted for a mysql login and it only seems that the logical backups are restored?

MySQL-Full:restore:INFO: Restored database(s) from logical backup: blabwikidb redmine
MySQL-Full:restore:INFO: Shutting down MySQL
MySQL-Full:restore:INFO: Command being executed is /usr/share/mysql-zrm/plugins/ssh-copy.pl --source-host localhost --source-file /mnt/Backups/MySQL-Full/20090615105058/bacula --destination-host bioinfosrv1.bccrc.ca --destination-directory /var/lib/mysql
mysql@secondserver's password:

Am I missing something in order to restore all db's to a remote server?