What is running sqldump?

Distro Discussion & Help
,
1 
FreePBX distro 10.13.66-17
FreePBX 13.0.190.11
Asterisk 13.13.1

In top I am seeing this:

17777 asterisk  20   0 50824 2640 1888 R 33.5  0.1   4:03.07 mysqldump.

If I read this aright then this has been running for over 4 hours. What starts it,;what database is it trying to backup; and why is it taking so long?

2

Probably the backup module. However, that’s a REALLY long time. You might want to kill it.

1 Like
3

This is what is killing our system:

/usr/bin/mysqldump --host=localhost --port= \
  --user=freepbxuser --password=x xxxxxxxxxx asteriskcdrdb \
  --opt --skip-comments --skip-extended-insert \
  --lock-tables=false --skip-add-locks --compatible=no_table_options \
  --default-character-set=utf8

When this starts we lose calls and cannot get dial tone.

And I am guessing that this is the cron entry that starts it:

ID=freepbx_backup_3 /var/lib/asterisk/bin/backup.php --id=3

Why is this running every hour? Or I should ask: Why is this scheduled to run every hour? What does this give one that running it every six hours would not?

4

I’m guessing because someone set up a backup job to run every hour. I think that once a day is more than sufficient. It depends on how worried you are about data loss.