LP #868164: databases option can get the list from file

Description

**Reported in Launchpad by Adrian Chapela last update 19-09-2012 11:48:05

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`"

Environment

None

Smart Checklist

Activity

lpjirasync January 19, 2018 at 6:05 PM

**Comment from Launchpad by: Alexey Kopytov on: 19-09-2012 07:27:58

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.

lpjirasync January 19, 2018 at 6:05 PM

**Comment from Launchpad by: Valentine Gostev on: 20-10-2011 14:29:17

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)

Done

Details

Assignee

Reporter

Priority

Smart Checklist

Created January 19, 2018 at 6:04 PM
Updated January 19, 2018 at 6:05 PM
Resolved January 19, 2018 at 6:05 PM