Backup restore error

(Dan Corwin) #1

I’m getting the following when attempting to restore a backup from an old FreePBX 12 server that used to be an even older AsteriskNow install. Any hints on what I can do to restore the backup?

[root@freepbx ~]# fwconsole backup --restore 20210422-144256-1619116976-352822281.tgz --verbose
Transaction ID is: 1d75bb94-45e6-45c0-9426-0c4c50218ea7
Determining backup file type…type is legacy
Legacy CDR Restore Option: 0
Starting restore job with file: 20210422-144256-1619116976-352822281.tgz
Extracting backup…
Loading manifest to memory
Loading astdb to memory
Parsing out SQL tables. This may take a moment depending on backup size.
Found 2 database files in the backup.
File named: /tmp/backup/1d75bb94-45e6-45c0-9426-0c4c50218ea7/mysql-3.sql
Detected file /tmp/backup/1d75bb94-45e6-45c0-9426-0c4c50218ea7/mysql-3.sql as th e PBX (Asterisk) database. Attempting restore
Loading supplied database file mysql-3
INSERT INTO certman_cas VALUES (1,‘ca’,‘localhost.localdomain’,‘localhost.loca ldomain’,‘SÕ�<nj4RY÷ÒŽOIr< ~!œÄó¶>:ô\’’,‘1’);SQLSTATE[HY000]: General error: 1 near “1”: syntax error

(Dan Corwin) #2

I am also getting the same error when upgrading to the edge version of Core and Backup & Restore.

(system) closed #3

This topic was automatically closed 30 days after the last reply. New replies are no longer allowed.