meta data for this page
  •  

Differences

This shows you the differences between two versions of the page.

Link to this comparison view

Both sides previous revisionPrevious revision
Next revision		Previous revision
linux:backup:databases [2015/06/24 07:02] – niziaklinux:backup:databases [2015/07/13 07:55] (current) – niziak
Line 1: Line 1:
-====== Databases ======+===== Databases ======
  
 <code bash> <code bash>
Line 11: Line 11:
 </code> </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 ===== ===== automysqlbackup =====
 Default debian configuration should be enough.  Default debian configuration should be enough. 
Line 20: Line 51:
 BACKUPDIR="/var/lib/automysqlbackup" BACKUPDIR="/var/lib/automysqlbackup"
 DBNAMES="all" DBNAMES="all"
-DBEXCLUDE="information_schema performance_schema"+DBEXCLUDE="information_schema performance_schema events"
 </code> </code>
  
Line 29: Line 60:
  
 |ERROR| Warning: Skipping the data of table mysql.event. Specify the --events option explicitly.| |ERROR| Warning: Skipping the data of table mysql.event. Specify the --events option explicitly.|
-|SOLUTION| Add to my.cnf \\ tetet \\ +|SOLUTION| See above | 
-<code ini> +
-[mysqldump] +
-... +
-events +
-ignore-table=mysql.events  +
-... +
-</code>|}|+
  
 Default configuration for Debian is using //debian-sys-maint// user to get access to database. Default configuration for Debian is using //debian-sys-maint// user to get access to database.