summaryrefslogtreecommitdiffstats
path: root/abs/mv-core/MythVantage-system/optimize_mythdb.py
diff options
context:
space:
mode:
Diffstat (limited to 'abs/mv-core/MythVantage-system/optimize_mythdb.py')
-rwxr-xr-xabs/mv-core/MythVantage-system/optimize_mythdb.py16
1 files changed, 0 insertions, 16 deletions
diff --git a/abs/mv-core/MythVantage-system/optimize_mythdb.py b/abs/mv-core/MythVantage-system/optimize_mythdb.py
deleted file mode 100755
index e7b35ed..0000000
--- a/abs/mv-core/MythVantage-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)