content_image/783158.jpg content_image/783175.jpg content_image/783176.jpg content_image/783177.jpg
<img src='content_image/783158.jpg'>

You can use these two options together. For example, the following causes all tables in all databases except for  databases db1  and db2 , and tables t1  and t2  in database db3 , to be restored: 

shell> ndb_restore [...] --exclude-databases=db1,db2 --exclude-tables=db3.t1,db3.t2 

(Again, we have omitted other possibly necessary options in the interest of clarity and brevity from the example just shown.) 

You can use --include-*  and --exclude-*  options together, subject to the following rules: 

•The actions of all --include-*  and --exclude-*  options are cumulative. 

•All --include-*  and --exclude-*  options are evaluated in the order passed to ndb_restore, from right to left. 

•In the event of conflicting options, the first (rightmost) option takes precedence. In other words, the first option (going from right to left) that matches against a given database or table “wins” . 

For example, the following set of options causes ndb_restore  to restore all tables from database db1 except db1.t1 , while restoring no other tables from any other databases: 

--include-databases=db1 --exclude-tables=db1.t1 

However, reversing the order of the options just given simply causes all tables from database db1  to be restored (including db1.t1 , but no tables from any other database), because the --include- databases  option, being farthest to the right, is the first match against database db1  and thus takes precedence over any other option that matches db1  or any tables in db1 : 

--exclude-tables=db1.t1 --include-databases=db1 

• --fields-enclosed-by = char 

<img src='content_image/783175.jpg'>

Each column value is enclosed by the string passed to this option (regardless of data type; see the description of --fields-optionally-enclosed-by ). 

• --fields-optionally-enclosed-by 

<img src='content_image/783176.jpg'>

The string passed to this option is used to enclose column values containing character data (such as CHAR , VARCHAR , BINARY , TEXT , or ENUM ). 

• --fields-terminated-by = char 

<img src='content_image/783177.jpg'>

