===== Databases ======

<code bash>
apt-get install automysqlbackup autopostgresqlbackup backupninja
</code>

===== backupninja =====
Add to /etc/backup.d/20.mysql
<code ini>
nodata = performance_schema.cond_instances
</code>

add --skip-events parameter to mysqldump call in file /usr/share/backupninja/mysql
<code bash>
...
DUMP="$DUMP_BASE $ignore $db --skip-events"
...
</code>

Add to /etc/my.cnf
<code ini>
[mysqldump]
...
ignore-table=mysql.event
ignore-table=performance_schema.cond_instances
ignore-table=performance_schema.events_waits_current
ignore-table=performance_schema.events_waits_history
ignore-table=performance_schema.events_waits_history_long
ignore-table=performance_schema.events_waits_summary_by_instance
ignore-table=performance_schema.events_waits_summary_by_thread_by_event_name
ignore-table=performance_schema.events_waits_summary_global_by_event_name
ignore-table=performance_schema.file_instances
ignore-table=performance_schema.file_summary_by_event_name
ignore-table=performance_schema.file_summary_by_instance
ignore-table=performance_schema.mutex_instances
ignore-table=performance_schema.performance_timers
ignore-table=performance_schema.rwlock_instances
ignore-table=performance_schema.setup_consumers
ignore-table=performance_schema.setup_instruments
ignore-table=performance_schema.setup_timers
ignore-table=performance_schema.threads

</code>
===== automysqlbackup =====
Default debian configuration should be enough. 
Pleae test if script has access to mysqldatabase by issuing command:
<code bash>mysql --defaults-file=/etc/mysql/debian.cnf --execute="SHOW DATABASES"</code>

You can customize configuration:
<code ini /etc/default/automysqlbackup>
BACKUPDIR="/var/lib/automysqlbackup"
DBNAMES="all"
DBEXCLUDE="information_schema performance_schema events"
</code>

==== Issues ====

|ERROR| mysqldump: Got error: 1142: SELECT,LOCK TABL command denied to user 'debian-sys-maint'@'localhost' for table 'cond_instances' when using LOCK TABLES|
|SOLUTION| Add DBNAMES and DBEXCLUDE configuration values like in example above.|

|ERROR| Warning: Skipping the data of table mysql.event. Specify the --events option explicitly.|
|SOLUTION| See above |


Default configuration for Debian is using //debian-sys-maint// user to get access to database.
This user cannot get access to //information_schema// database.


===== autopostgresqlbackup =====

# Password
# create a file $HOME/.pgpass containing a line like this
#   hostname:*:*:dbuser:dbpass
# replace hostname with the value of DBHOST and postgres with.
# the value of USERNAME

Default $HOME for user //postgres// is /var/lib/postgresql


Pleae test if script has access by issuing command:
<code bash>mysqldump --defaults-file=/etc/mysql/debian.cnf --all-databases --no-data</code>

You can customize configuration:
<code ini /etc/default/autopostgresqlbackup>
BACKUPDIR="/var/lib/autopostgresqlbackup"
</code>