I am attempting to backup/restore from one server to another online using the “restore here” function. While it should be relatively easy, I’m running into some serious crashes that I can’t explain. Below is what the backup window displays before the system can’t connect to the Asterisk database anymore. Any suggestions?
Saving Backup 2…Intializing Backup 2
Connecting to remote server…
/bin/tar: Removing leading /' from member names /bin/tar: Removing leading/’ from member names
/bin/tar: Removing leading /' from member names /bin/tar: Removing leading/’ from member names
mysqldump: Error 1194: Table ‘qxact_system_events’ is marked as crashed and should be repaired when dumping table qxact_system_events at row: 256
/bin/tar: Removing leading /' from member names /bin/tar: Removing leading/’ from member names
Veryfing received file…
Prossesing received file…
Storing backup…
Running post-backup hooks…
Restoring backup…
Intializing Restore…
Running pre-restore hooks, if any…
Restoring files…
File restore complete!
Restoring settings…
Getting Settings size…
Processed 100% of Settings’!
Restoring astDB…
Restoring Settings’ complete
Running post-restore hooks, if any…
Cleaning up…
[FATAL] DELETE FROM notifications WHERE module = ‘core’ AND id = ‘AMPMGRPASS’ [nativecode=1100 ** Table ‘notifications’ was not locked with LOCK TABLES]SQL -
DELETE FROM notifications WHERE module = ‘core’ AND id = ‘AMPMGRPASS’
Trace Back:
/var/www/html/admin/libraries/sql.functions.php:25 die_freepbx()
[0]: DELETE FROM notifications WHERE module = ‘core’ AND id = ‘AMPMGRPASS’ [nativecode=1100 ** Table ‘notifications’ was not locked with LOCK TABLES]SQL -
DELETE FROM notifications WHERE module = ‘core’ AND id = ‘AMPMGRPASS’
/var/www/html/admin/libraries/notifications.class.php:262 sql()
[0]: DELETE FROM notifications WHERE module = ‘core’ AND id = ‘AMPMGRPASS’
/var/www/html/admin/libraries/utility.functions.php:1371 notifications->delete()
[0]: core
[1]: AMPMGRPASS
/var/www/html/admin/modules/backup/bin/restore.php:335 fpbx_ami_update()
[0]: DB Error: not locked
[1]: DB Error: not locked
Running post-backup hooks…
Backup successfully completed!
done!