Automatic SQLite3 Backups


#1

The stable build will provide support to both manually and automatically backup SQLite3 databases.

Note that this only is implemented for SQLite3. There are no plans to include support for MySQL although IniStore may be supported in the future. MySQL will not be supported as it is up to the MySQL administrator of the PhantomBot database to handle backup and restore operations. There are various options for providing backup services for MySQL.

To manually backup from the console: backupdb

To automatically backup SQLite3 database, configure the following in botlogin.txt:

Required: backupsqliteauto=true
Optional: backupsqlitehourfrequency=xx hours to wait between backups, 24 if not provided
Optional: backupsqlitekeepdays=xx days to keep automatic backups, 5 if not provided

If you are running the nightly and would like to test this functionality, please feel free to do so. The files will be stored in a dbbackup directory under your PhantomBot directory.


#2

I see that the dbbackup directory is being created. But, there are no files in it. There is an entry in the log “Backed up SQLite3 DB to ./dbbackup/phantombot.auto.backup.29092017.030930.db”. But, no file or errors.

I’m using the nightly build from the 9/28.

Suggestions?


#3

You can please open a Support Ticket and provide the relevant information such as OS?

Thanks!