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???
Backup for Pandora
IzanRLucas · 7 abr 2008, 14:36 · 3 mensajes · 67 visitas
- 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???
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 ;)
Thanks a lot, Nil!!!!
Entra en tu cuenta para publicar.
