tabrestore.8¶
NAME¶
tabrestore - replaces with or adds to a xCAT database table the contents in a csv file.
SYNOPSIS¶
tabrestore [-a] table.csv
tabrestore [-? | -h | -***-help*]
tabrestore [v | -***-version*]
DESCRIPTION¶
The tabrestore command reads the contents of the specified file and puts its data in the corresponding table in the xCAT database. Any existing rows in that table are replaced unless the (-a) flag is used and then the rows in the file are added to the table. The file must be in csv format. It could be created by tabdump. Only one table can be specified.
This command can be used to copy the example table entries in /opt/xcat/share/xcat/templates/e1350 into the xCAT database.
OPTIONS¶
-?|-h|--help
Display usage message.
-v|--version
Display version.
-a|--addrows
Add rows from the CSV file to the table instead of replacing the table with the CSV file.
EXAMPLES¶
*
To replace the rows in the mp table with the rows in the mp.csv file:
** tabrestore** mp.csv
The file mp.csv could contain something like:
#node,mpa,id,comments,disable "blade","|\D+(\d+)|amm(($1-1)/14+1)|","|\D+(\d+)|(($1-1)%14+1)|",,
*
To add the rows in the mp.csv file to the rows in the mp table:
** tabrestore** -a mp.csv
*
To restore database tables that we dumped with dumpxCATdb:
restorexCATdb -p <restore directory>
FILES¶
/opt/xcat/sbin/tabrestore
SEE ALSO¶
tabdump(8)|tabdump.8, tabedit(8)|tabedit.8, dumpxCATdb(1)|dumpxCATdb.1