diff options
| author | James Meyer <james.meyer@operamail.com> | 2010-10-23 18:17:40 (GMT) |
|---|---|---|
| committer | James Meyer <james.meyer@operamail.com> | 2010-10-23 18:19:39 (GMT) |
| commit | adbcf19958300e9b6598990184c8815b945ba0ee (patch) | |
| tree | f4283c850ac0ac202c17e78a637ee7ca8147621b /abs/core-testing/LinHES-system/optimize_mythdb.py | |
| parent | 61a68250df10d29b624650948484898334ff22d0 (diff) | |
| download | linhes_pkgbuild-adbcf19958300e9b6598990184c8815b945ba0ee.zip linhes_pkgbuild-adbcf19958300e9b6598990184c8815b945ba0ee.tar.gz linhes_pkgbuild-adbcf19958300e9b6598990184c8815b945ba0ee.tar.bz2 | |
Removed old core and extra from repo. Renamed -testing to core/extra. This will setup the base for the testing branch.
Diffstat (limited to 'abs/core-testing/LinHES-system/optimize_mythdb.py')
| -rwxr-xr-x | abs/core-testing/LinHES-system/optimize_mythdb.py | 16 |
1 files changed, 0 insertions, 16 deletions
diff --git a/abs/core-testing/LinHES-system/optimize_mythdb.py b/abs/core-testing/LinHES-system/optimize_mythdb.py deleted file mode 100755 index e7b35ed..0000000 --- a/abs/core-testing/LinHES-system/optimize_mythdb.py +++ /dev/null @@ -1,16 +0,0 @@ -#!/usr/bin/python -# import MySQL module -import MySQLdb -import socket -import sys -db = MySQLdb.connect(host="localhost", user="mythtv", passwd="mythtv", db="mythconverg") -cursor = db.cursor() -cursor.execute("SHOW tables") -result = cursor.fetchall() -ops=["REPAIR","OPTIMIZE","ANALYZE"] -for row in result: - ctable=row[0] - for op in ops: - print op,ctable - cmd= "%s table %s" %(op,ctable) - cursor.execute(cmd) |