NoisyVoid.com Knowledgebase

To check / correct the corrupt database

Go to the database directory

# cd /var/lib/mysql/mythconverg/

Stop both the backend and mysql

# /sbin/service mythbackend stop
# /sbin/service mysqld stop

run the script to check the database (check output given directly onto screen)

# myisamchk *.MYI >> mythconverg_check.log

check output of script

# more mythconverg_check.log

If required run a program to correct the data

# myisamchk -f -r *.MYI

Start service

# /sbin/service mysqld start

Alternative way of checking database (backend should be stopped, but mysql should be running)

# mysqlcheck -c -umythtv -pmythtv mythconverg

Then restart the backend

# /sbin/service mythbackend start

Another Alternative way of checking database (I have ran this with both backend and mysql running)

# cd /usr/share/doc/mythtv-0.20/contrib/
# ./optimize_mythdb.pl

To import .nuv files into the database (if xmldata still exists it will autofill the info)

may be obsolete now as I last tried this in 0.18.1

# cd /usr/share/doc/mythtv-0.20/contrib/
# /myth.rebuilddatabase.pl --try_default

Looking at the database

to get into mysql

# mysql -u mythtv -p mythconverg
#

some useful sql commands

show tables;
describe recordedprogram;
select * from recordedprogram where chanid like 1009;
select * from channel where name like 'sky three';
update channel set xmltvid='sky-three.com' where name like 'sky three';

Some useful Fedora core / linux commands

To investigate hardware versions of pci connected cards (and with verbose)

# lspci
# lspci -v

Also use

# dmesg

Also to get what modules the hardware has loaded as

# lsmod

to list packages

# rpm -qa |grep package

to install package rpm

# rpm -Uvh packagename.rpm

to remove package

# rpm -e packagename

list mounted drives

# mount -l

Open drive from ssh

# eject -r

Close drive from ssh

# eject -j

reformat this later

# xvidtune -show # xvinfo

using gawk

# ls -l core* | grep -v Sep | gawk '{print $9}' | xargs rm -f

Ubuntu command and useful stuff

Thing I needed to do to get it working

add vmalloc=250M onto kernel boot line to make DVB-T card work
added customer edid.bin to make monitor work when off
installed libflashsupport and flashplugin-nonfree-extrasound to get flash working
installed msttcoreforts to get fonts for myth

Use the following command to check the vmalloc setting

$ cat /proc/meminfo

apt repository config files are in

$ cd /etc/apt/sources.list.d/

To check what nvidia drivers are loaded

$ sudo dpkg -l | grep nvid

to remove all the relevent drivers

$ dpkg -r nvidia-180-kernel-source nvidia-180-libvdpau nvidia-180-modaliases nvidia-glx-180

to install the nvidia kernal packages

$ sudo apt-get install nvidia-180-kernel-source nvidia-180-libvdpau nvidia-180-modaliases nvidia-glx-180

To upgrade the ubuntu

$ sudo apt-get update $ sudo apt-get -V upgrade

using aptitude (better for resolving dependencies) to upgrade

$ sudo aptitude dist-upgrade

The following command are useful to mount the old Fedora LVM

$sudo lvdisplay $sudo lvscan $vgchange -ay $sudo mount /dev/VolGroup00/LogVol00 /mnt

Starting the Virtual Box VM in headless mode

VBoxManage startvm WinXP --type vrdp

getting status on the VM

$VBoxManage showvminfo WinXP

to check what version of Ubuntu you are running

$ cat /etc/issue

<--COMMENT - the following /div ends the content section, leave it in -->