[mythtv-users] Database corruption - I think

[Barry Martin]

Roland and Steve:


I apologize for the delay in responding – semi-minor family issue (OK now).


Steve: The Backend’s IP address is fine (set for static) and a remote 
Frontend is able to connect plus play the recordings. Thanks for that 
reminder.


Roland: Appears sufficient free space: 21% used; various tmpfs show 0 
and 1% used.


You may need a lot of free space on the /tmp folder.

If I’m reading the table correctly I should have almost a TB available.



Note, the needed password is stored in the 'config.xml' file
mysql -u mythtv -p<your-password> mythconverg


I’m assuming there should be a space after the ‘-p’. I did and output 
was a help display followed by a table of variables. Lots of ‘(No 
default value)’ listed.



MariaDB [mythconverg]>check table program;
MariaDB [mythconverg]>repair table program;


Here things don’t go quite right. Here it wanted ‘mariadb’ – 
lower-cased. No biggie.


Both commands went straight/immediately to the command line. ….Ah! It 
created files called ‘check’ and ‘repair’, both of which contain the 
help and variables I saw above. Makes sense with the ‘>’ redirect 
thingie. Assume the ‘check table program’ is a switch option. Will post 
this and do a little Googling in the meantime.


Thanks for the help, gentlemen!

Barry


P.S.: Where is the correct website to post? I’m replying via my e-mail’s 
“Rely List” and in the past have been told it creates a new thread. I 
looked in https://forum.mythtv.org <https://forum.mythtv.org/> but was 
unable to find this thread – found some earlier ones. I can find me and 
this thread at

http://lists.mythtv.org/pipermail/mythtv-users/

https://lists.mythtv.org/pipermail/mythtv-users/2022-January/408623.html

but can’t figure out how to reply.




-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.mythtv.org/pipermail/mythtv-users/attachments/20220107/1397780f/attachment.htm>