Backup for Pandora

[Sancho]

Like it

Up

0

Down

Drop it

::

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 😉

[IzanRLucas]

Like it

Up

0

Down

Drop it

::

Thanks a lot, Nil!!!!