tabrestore.8¶
NAME¶
tabrestore - replaces with or adds to a xCAT database table the contents in a csv file.
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.
RETURN VALUE¶
- The command completed successfully.
- An error has occurred.
EXAMPLES¶
- To replace the rows in the mp table with the rows in the mp.csv file:
tabrestore mp.csvThe 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 from restore_directory 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