Pandora FMS Community

Backup for Pandora

IzanRLucas · 7 abr 2008, 14:36 · 3 mensajes · 67 visitas

  1. Inicio del debate

    Hi, we are concerned about making backup of our Pandora service. We have thought about copying the pandora mysql database so in case of problem: 1. Installed pandora server as normal. 2. Use the install.php script for Pandora Console, that will create a pandora database. 3. Substitute the blank database for our backed-up database. Is that possible??? Any other idea???

  2. Hi, we are concerned about making backup of our Pandora service. We have thought about copying the pandora mysql database so in case of problem: 1. Installed pandora server as normal. 2. Use the install.php script for Pandora Console, that will create a pandora database. 3. Substitute the blank database for our backed-up database. Is that possible??? Any other idea???

    Much more simple. A simple mysqldump will dump your database contents. A blank database with the same name (without data), should be enought to receive dump generated by mysqldump. Make the backup mysqldump -u root -p pandora > /backup/pandoradb_backup.sql Restore the backup (from scratch) mysql -u root -p create database pandora; use pandora; source /backup/pandoradb_backup.sql Probably you also need to give access to your console pandora user: grant all privileges on pandora.* to pandora@localhost identified by 'mypassword'; Ready. I've added this to our FAQ because is a good question ;)

  3. Thanks a lot, Nil!!!!

Entra en tu cuenta para publicar.