Skip to content
Jérôme Quéré edited this page Aug 14, 2015 · 2 revisions

Mysql

This task use mysqldump command to backup mysql database. Each database will create a separate item on the storage named after the database name.

options:

  • HOST: (optional) (default: "localhost")
    The mysql server hostname
  • PORT: (optional) (default: "3306")
    The mysql server port
  • USER: (optional) (default: "root") The admin mysql user
  • PASSWORD: (optional) (default: "")
    The mysql password
  • DUMP_OPTS: (optional) (default: "--opts")
    A list of options that will be passed to the mysqldump.
  • DATABASE: (optional) (default: "__ALL__")
    A list of database names separated by space that will be dump. If the value is __ALL__ the task will list database present on the server using a SHOW DATABASE a dump them all.

Exemple:

IB_TASK_mysql_TYPE="mysql"
IB_TASK_mysql_USER="root"
IB_TASK_mysql_PASSWORD="password"
IB_TASK_mysql_DUMP_OPTS="--opt"
IB_TASK_mysql_DATABASES="my-database"
IB_TASK_mysql_STORAGE="myStorage"