mysql+ only schema backup

Asked by slonokot on 2015-03-26

Hello!
We have a bunch of MariaDB master+slave pairs in our environment. So we run backup of real data on slaves, while masters handle user connections. On masters we're used to backup only mysql DB and schemas of all our databases. We use mysqldump --no-data and --routines options to achieve that goal. We're now trying implement a more automated solution which uses mydumper. And it looks like there's no that precious option to backup schemas only. Or am I missing something?

Question information

Language:
English Edit question
Status:
Solved
For:
MySQL Data Dumper Edit question
Assignee:
No assignee Edit question
Solved by:
slonokot
Solved:
2015-03-26
Last query:
2015-03-26
Last reply:
2015-03-26
Max Bubenick (max-bubenick) said : #1

Hi, mydumper historically never supported full schema dump, ie. triggers, sp, views etc. That's because it didnt have a --no-data option.

But the next version release (sooner than later) will have it

  -d, --no-data Do not dump table data
  -G, --triggers Dump triggers
  -E, --events Dump events
  -R, --routines Dump stored procedures and functions

Its already commited to the trunk and you can get the source code with

bzr branch lp:mydumper

This is still on final testing phase, so use it at your own risk :) also take care about some behavior changes mostly on myloader that can affect you.

slonokot (libermansa) said : #2

Thanks!
 We'll wait for release.