Power failure, now need to run fix on database...
This morning while watching the news, power went out - turned out the transformer in the neighbours yard blew. Haven't found anything in the house that suffered damaged, but the myth box is not working now. It seems that it cannot connect to the database, complains like it is trying to connect to the master backend, but this is the Master backend/Frontend too.
I've found an old post about doing a "mysqlcheck -repair mythconverg", but when I do that it comes up with "Got error: 1045: Access denied for user 'root'@'localhost' (using password: YES) when trying to connect"
Any ideas of how to solve this OTHER than reloading the box would be nice, as this was just re-built about a month ago and I just got most of the database built back up of what I record and such.
Thanks, Michael
From your mythtv user prompt
From your mythtv user prompt try
$ mysqlcheck -u mythtv -pmythtv --repair mythconverg
Running "mythbackend" while at the command prompt...
I thought I'd poke around and see if I could find what the issue(s) are and appears that I need to fix the database...now the question is HOW.
This is the last bit from when trying to run "mythbackend"
---------------------------------------------------------
2010-06-21 21:40:34.157 Error preparing query: SELECT recorded.chanid, starttime, endtime, title, subtitle, description, hostname, channum, name, callsign, seriesid, programid, recorded.recpriority, progstart, progend, filesize, recgroup, storagegroup, basename FROM recorded LEFT JOIN channel ON recorded.chanid = channel.chanid WHERE recgroup = 'LiveTV' AND endtime < DATE_ADD(starttime, INTERVAL '2' MINUTE) AND endtime <= DATE_ADD(NOW(), INTERVAL '-1' MINUTE) AND deletepending = 0 ORDER BY autoexpire DESC, starttime ASC
2010-06-21 21:40:34.157 Driver error was [2/145]:
QMYSQL3: Unable to prepare statement
Database error was:
Table './mythconverg/recorded' is marked as crashed and should be repaired
While running
While running "mythfilldatabase", I get this at the end of it
2010-06-21 21:28:55.844 MythContext: Connecting to backend server: 127.0.0.1:6543 (try 1 of 1)
2010-06-21 21:28:55.845 Connection to master server timed out.
Either the server is down or the master server settings
in mythtv-settings does not contain the proper IP address
2010-06-21 21:28:55.845 Error rescheduling id -1 in ScheduledRecording::signalChange
2010-06-21 21:28:55.845 MythContext: Connecting to backend server: 127.0.0.1:6543 (try 1 of 1)
2010-06-21 21:28:55.846 Connection to master server timed out.
Either the server is down or the master server settings
in mythtv-settings does not contain the proper IP address
2010-06-21 21:28:55.846 MythContext: Connecting to backend server: 127.0.0.1:6543 (try 1 of 1)
2010-06-21 21:28:55.846 Connection to master server timed out.
Either the server is down or the master server settings
in mythtv-settings does not contain the proper IP address