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
linux:backup:databases [2015/06/24 07:14] – 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.