snapshot_backup
Differences
This shows you the differences between two versions of the page.
| Both sides previous revisionPrevious revisionNext revision | Previous revision | ||
| snapshot_backup [2011/09/23 15:22] – [delete shnapshot] k2patel | snapshot_backup [2020/08/10 02:35] (current) – external edit 127.0.0.1 | ||
|---|---|---|---|
| Line 8: | Line 8: | ||
| * perl | * perl | ||
| * Net:: | * Net:: | ||
| + | * DBI:SQLite | ||
| * bash | * bash | ||
| Line 38: | Line 39: | ||
| # instance< | # instance< | ||
| - | #instance1=" | + | instance1=" |
| - | #instance2=" | + | instance2=" |
| </ | </ | ||
| Line 123: | Line 124: | ||
| ##################################### | ##################################### | ||
| - | source config_bash | ||
| - | BASE=$(pwd) | ||
| BASE=" | BASE=" | ||
| cd $BASE | cd $BASE | ||
| + | |||
| + | source config_bash | ||
| + | |||
| DATE=$(date +%Y%m%d) | DATE=$(date +%Y%m%d) | ||
| perl=$(which perl) | perl=$(which perl) | ||
| Line 339: | Line 341: | ||
| } | } | ||
| </ | </ | ||
| + | |||
| + | ==== Machine DB ==== | ||
| + | |||
| + | <code bash> | ||
| + | sqlite3 machine.db | ||
| + | </ | ||
| + | |||
| + | <code sql | machine.db> | ||
| + | PRAGMA foreign_keys=OFF; | ||
| + | BEGIN TRANSACTION; | ||
| + | CREATE TABLE DESK ( v_ID, s_ID, Dte ); | ||
| + | </ | ||
| + | |||
snapshot_backup.1316791350.txt.gz · Last modified: 2020/08/10 02:29 (external edit)
