databases option can get the list from file

[Adrian Chapela]

As you can see in the help of innobackupex (innobackupex -help):
    --databases=LIST
        This option specifies the list of databases that innobackupex should
        back up. The option accepts a string argument. The list is of the
        form "databasename1[.table_name1] databasename2[.table_name2] . .
        .". If this option is not specified, all databases containing MyISAM
        and InnoDB tables will be backed up. Please make sure that
        --databases contains all of the InnoDB databases and tables, so that
        all of the innodb.frm files are also backed up. In case the list is
        very long, this can be specified in a file, and the full path of the
        file can be specified instead of the list. (See option
        --tables-file.)

You could specify a file containing a line with a list of databases but innobackupex doesn't understand it.

The option tables-file understand a path as a valid option, but you should write a value each line with format, database.tables and this option affects to all backup instead of databases that affects only to the part of MyISAM tables copy, so it isn't the same option.

The option should change or the help should tell us the correct way of use.

A workaround: innobackupex --databases="`cat list_of_databases`"

[Valentine Gostev (longbow)]

The concenrs here lays in the following:

details of wishlist:
1. Make databases option working as tables-file for InnoDB
2. When specify a file with a list, allow to use masks (dbname.* - to backup whole db)

[Alexey Kopytov (akopytov)]

In fact, the --databases option does accept a path to a file. In which case it treats the contents of that file as if it was specified as the option value (see code in parse_databases_option_value()). So we just need to update the built-in help in innobackupex and documentation.

[Shahriyar Rzayev (rzayev-sehriyar)]

Percona now uses JIRA for bug reports so this bug report is migrated to: https://jira.percona.com/browse/PXB-834