View unanswered posts    View active topics

All times are UTC - 6 hours





Post new topic Reply to topic  [ 2 posts ] 
Print view Previous topic   Next topic  
Author Message
Search for:
PostPosted: Sat Dec 07, 2019 7:55 am 
Offline
Joined: Mon Jun 05, 2017 8:23 am
Posts: 57
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!


Top
 Profile  
 
PostPosted: Sat Dec 07, 2019 3:55 pm 
Offline
Joined: Mon Apr 10, 2006 3:48 pm
Posts: 997
Location: Lexington, Ky
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.


Top
 Profile  
 

Display posts from previous:  Sort by  
Post new topic Reply to topic  [ 2 posts ] 


All times are UTC - 6 hours




Who is online

Users browsing this forum: No registered users and 36 guests


You cannot post new topics in this forum
You cannot reply to topics in this forum
You cannot edit your posts in this forum
You cannot delete your posts in this forum
You cannot post attachments in this forum

Jump to:  
cron
Powered by phpBB® Forum Software © phpBB Group

Theme Created By ceyhansuyu