Ticket #6271: create-mythvideo-rollback.sh
| File create-mythvideo-rollback.sh, 325 bytes (added by , 17 years ago) |
|---|
| Line | |
|---|---|
| 1 | #!/bin/bash |
| 2 | |
| 3 | ( |
| 4 | cat - <<EOF |
| 5 | |
| 6 | delete from settings where value='mythvideo.DBSchemaVer'; |
| 7 | |
| 8 | EOF |
| 9 | |
| 10 | mysqldump --extended-insert --no-create-info \ |
| 11 | -u mythtv -pmythtv mythconverg settings --where="value='mythvideo.DBSchemaVer'" |
| 12 | |
| 13 | mysqldump --extended-insert -u mythtv -pmythtv mythconverg videometadata |
| 14 | |
| 15 | ) > rollback-mythvideo.sql |
