QUESTION Restore CDR records after upgrade

[Jadon R]

I am trying to get upgraded from PBX in a Flash Purple to PIAF Green. I've copied and pasted all the settings between the two, but I've not had any luck get the call records from the old to the new. I've tried to do a backup of the CDR, copied off the archive to my desktop and then restore to Green, but no logs appear when I go to CDR reports. Any ideas?

 

[matthew]

You might have to do it directly with mysql. Something like:

On the old box, backup asteriskcdrdb:

/usr/bin/mysqldump -u root -p --events --opt asteriskcdrdb > /tmp/asteriskcdrdb.sql

Transfer the .sql file to the new box, then restore asteriskcdrdb:

mysql -u root -p < /path/to/asteriskcdrdb.sql

*Note* You might like to run the same dump command on the new box first, so you have a clean copy to restore if the transferred db doesn't work out for you.

 

[islandtech]

try

 

[Trimline2]

I am trying to get upgraded from PBX in a Flash Purple to PIAF Green. I've copied and pasted all the settings between the two, but I've not had any luck get the call records from the old to the new. I've tried to do a backup of the CDR, copied off the archive to my desktop and then restore to Green, but no logs appear when I go to CDR reports. Any ideas?

On your old system:
1. Select PhpMyAdmin
2. Select asteriskcdrdb
3. Check the first row (cdr) and press export.
4. On the new screen, just press "Go" and save your export.

On the new system.
1. Select PhpMyAdmin
2. Select asteriskcdrdb
3. Select Import and browse for the file you just created
4. Press "Go" to import.