LinHES Forums http://forum.linhes.org/ |
|
Several mythtv database tables are not found http://forum.linhes.org/viewtopic.php?f=21&t=25567 |
Page 1 of 1 |
Author: | drhood [ Sat Dec 07, 2019 7:55 am ] |
Post subject: | Several mythtv database tables are not found |
Hello, MythWeb is reporting the following mythtv database tables are not found: Quote: Table Name: channel Status: File './mythconverg/channel.MYD' not found (Errcode: 2 - No such file or directory) Table Name: users Status: Can't find file: 'users' (errno: 2 - No such file or directory) Table Name: videocategory Status: Can't find file: 'videocategory' (errno: 2 - No such file or directory) Table Name: videocountry Status: Can't find file: 'videocountry' (errno: 2 - No such file or directory) Table Name: videogenre Status: Can't find file: 'videogenre' (errno: 2 - No such file or directory) Table Name: videometadata Status: File './mythconverg/videometadata.MYD' not found (Errcode: 2 - No such file or directory) Table Name: videometadatacast Status: File './mythconverg/videometadatacast.MYD' not found (Errcode: 2 - No such file or directory) Table Name: videopart Status: File './mythconverg/videopart.MYD' not found (Errcode: 2 - No such file or directory) I googled and have not found a command that will 'fix' these errors. I have tried the repair, extended check and optimize commands; however, the errors remain. I suspect the next option is to replace the mythtv database (all tables) or just the missing datatables that cannot be found. I was wondering if someone could confirm that the above errors cannot be resolve by a single/few command(s) or if the mysql database/tables need replacement/restoring. If database replacement/restoring is needed, I will appreciate a link that describes how to do this task. Any assistance will be appreciated. Cheers! |
Author: | tscholl [ Sat Dec 07, 2019 3:55 pm ] |
Post subject: | Re: Several mythtv database tables are not found |
To restore your database, put your_mythtv ip address in your browser. That will take you to the LinHes home page. Select Health & Maintenance from list on the left. Click on the name of you LinHes backend. That will take you to yourbackend (Master_backend) page. Click the "Restore Database" button then use the pull down to select the date of the database you want to restore. (The most recent one will be displayed) Once the database is selected scroll to the bottom of the page and select GO. The process will take awhile so sit back and relax. You can watch the disk usage light on the server. If your want. When the process finally finishes it will come back to your browser and say it's finished. The process also stops and restarts the backend so when its finished your ready to go. |
Page 1 of 1 | All times are UTC - 6 hours |
Powered by phpBB® Forum Software © phpBB Group http://www.phpbb.com/ |