In a newly installed FPBX 17 there are several error messages in connection with mysql when restoring the backup of FPBX 16.
I have solved the problem by removing the string - in the first line of the SQL backup files.
Instead of
/*M!999999- enable the sandbox mode */
then reads
/*M!999999 enable the sandbox mode */
By the way, I am very surprised why the Devices.sql file is restored several times as you can see in the error messages.
Enclosed the error messages:
Ampusers table Restore Error The command “/usr/bin/mysql -P 3306 -ufreepbxuser -p6d6d7c82874a985f0f03d5de32c403a4 asterisk < /tmp/backup/e49b0784-afda-45d5-b859-2317416b07bd/files/tmp/Devices_dump/Devices.sql” failed.
Dahdichannels table Restore Error The command “/usr/bin/mysql -P 3306 -ufreepbxuser -p6d6d7c82874a985f0f03d5de32c403a4 asterisk < /tmp/backup/e49b0784-afda-45d5-b859-2317416b07bd/files/tmp/Devices_dump/Devices.sql” failed.
Did table Restore Error The command “/usr/bin/mysql -P 3306 -ufreepbxuser -p6d6d7c82874a985f0f03d5de32c403a4 asterisk < /tmp/backup/e49b0784-afda-45d5-b859-2317416b07bd/files/tmp/Devices_dump/Devices.sql” failed.
Astmodules table Restore Error The command “/usr/bin/mysql -P 3306 -ufreepbxuser -p6d6d7c82874a985f0f03d5de32c403a4 asterisk < /tmp/backup/e49b0784-afda-45d5-b859-2317416b07bd/files/tmp/Devices_dump/Devices.sql” failed.
Trunks table Restore Error The command “/usr/bin/mysql -P 3306 -ufreepbxuser -p6d6d7c82874a985f0f03d5de32c403a4 asterisk < /tmp/backup/e49b0784-afda-45d5-b859-2317416b07bd/files/tmp/Devices_dump/Devices.sql” failed.
Users table Restore Error The command “/usr/bin/mysql -P 3306 -ufreepbxuser -p6d6d7c82874a985f0f03d5de32c403a4 asterisk < /tmp/backup/e49b0784-afda-45d5-b859-2317416b07bd/files/tmp/Devices_dump/Devices.sql” failed.
Routing table Restore Error The command “/usr/bin/mysql -P 3306 -ufreepbxuser -p6d6d7c82874a985f0f03d5de32c403a4 asterisk < /tmp/backup/e49b0784-afda-45d5-b859-2317416b07bd/files/tmp/Devices_dump/Devices.sql” failed.
Devices table Restore Error The command “/usr/bin/mysql -P 3306 -ufreepbxuser -p6d6d7c82874a985f0f03d5de32c403a4 asterisk < /tmp/backup/e49b0784-afda-45d5-b859-2317416b07bd/files/tmp/Devices_dump/Devices.sql” failed.
cdr table Restore Error The command “gunzip < /tmp/backup/e49b0784-afda-45d5-b859-2317416b07bd/files/tmp/cdr_dump/cdr.sql.gz | /usr/bin/mysql -P 3306 -ufreepbxuser -p6d6d7c82874a985f0f03d5de32c403a4 asteriskcdrdb” failed.
cel table Restore Error The command “gunzip < /tmp/backup/e49b0784-afda-45d5-b859-2317416b07bd/files/tmp/cel_dump/cel.sql.gz | /usr/bin/mysql -P 3306 -ufreepbxuser -p6d6d7c82874a985f0f03d5de32c403a4 asteriskcdrdb” failed.