Ticket #6271: create-mythvideo-rollback.sh
File create-mythvideo-rollback.sh, 325 bytes (added by , 15 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 |