Hi People,

My brain is just now working today and I cannot seem to find how to "fix" my database. The way I use to do it under 5.5 is below (per the WIKI).


1. Make a database backup using mythbackup.
2. /etc/init.d/mythtv-backend stop
3. /etc/init.d/mysql stop
4. Disable any watchdog scripts you may be running.
5. cd /var/lib/mysql/mythconverg
6. myisamchk -r *.MYI
7. myisamchk -a *.MYI
8. /etc/init.d/mysql start
9. /etc/init.d/mythtv-backend start

What I was tring to do with the new version was
/etc/sv
sv stop mythbackend
sv stop mysql

And here is my issue, I an not find the location of mysql (it is not under the old /var/lib/mysql/mythconverg). Could a more enlightened individual please let me know where it is?

Thanks,

Paul

_________________
Backend/Frontend
ASUS M4A78-EM w/8400GS 4G RAM pcHDTV 3000 + PVR500 (1045), 1TB, 250 & 320. Iguana IR USB (running R6)
Frontend_1
Asus M2NPV-VM - 1GB RAM - 40 GB Hard Disk - StreamZap
Frontend_2
Dragon 1.0 w/ 2G RAM - 40 GB Hard Disk StreamZap

Database is now located in /data/srv/mysql/mythconverg and the commands to stop/start the daemons are no longer valid.

_________________
Retired KM user (R4 - R6.04); friend to LH users.

There really should be a script for doing this. There used to be two (one bash, one perl), did they both disappear?

What were these called?

/usr/LH/bin/optimize_mythdb.py
/usr/share/mythtv/contrib/optimize_mythdb.pl

_________________
Retired KM user (R4 - R6.04); friend to LH users.

In 5.5 I used MythWeb to repair the data base. You have three choices
Optimize Tables
Repair Table
Extended Check

If you scroll down the page it will tell you which file is corrupt.
So far it has worked for me.


I anyone can tell me what extended check means please post it
TVBox

_________________
TVBox
LinHES R8.6.1

I was unaware of the scripts to do this. Thanks very much I appreciate the feedback. Unfortunately my database was way too gone (thanks to my 3 year old and the power button (going on...off...on...off). Anyways, I am now on the latest copy of R6.02.

Thanks once again for the location of the scripts.

Paul

_________________
Backend/Frontend
ASUS M4A78-EM w/8400GS 4G RAM pcHDTV 3000 + PVR500 (1045), 1TB, 250 & 320. Iguana IR USB (running R6)
Frontend_1
Asus M2NPV-VM - 1GB RAM - 40 GB Hard Disk - StreamZap
Frontend_2
Dragon 1.0 w/ 2G RAM - 40 GB Hard Disk StreamZap