- August 13, 2012
- 14
- 1
- Home Country
-
Australia
I've got a corrupt MPTVDB as I can't seem to Import any of my TV Recordings using the TV Server Configurator. The actual recordings are showing up in the TV Server Configurator window but when I try and import the shows I get the following error:
"Error retrieving recordings from database:
The columns idRecording, idChannel, idSchedule.....episodePart in table Recording do not exist". (I've truncated the whole error message but it pretty much outlines every column in this DB).
Searching around the threads, I then tried reparing the database by executing the following commands from the command line:
CD C:\Program Files\MySQL\MySQL Server 5.1\bin
mysqlcheck mptvdb --auto-repair -e -u root -p
...and various other versions of the "mysqlcheck" command above. For the password I enter "Mediaportal". I also stoped the TVService prior to executing the above commands.
Each time however, I get the following error:
"mysqlcheck: Got error: 10 45: Access denied for user 'root'@'localhost' <using password: YES> when trying to connect "
I have scoured the web to try and determine why I'm getting this error to no avail. Can someone please help as to why I'm getting this error and how to get around it.
I need a way to repair the MPTVDB database and the only way seems to be by executing the above but for some reason, I don't seem to have the privelages to execute the command.
Help greatly appreciated.
"Error retrieving recordings from database:
The columns idRecording, idChannel, idSchedule.....episodePart in table Recording do not exist". (I've truncated the whole error message but it pretty much outlines every column in this DB).
Searching around the threads, I then tried reparing the database by executing the following commands from the command line:
CD C:\Program Files\MySQL\MySQL Server 5.1\bin
mysqlcheck mptvdb --auto-repair -e -u root -p
...and various other versions of the "mysqlcheck" command above. For the password I enter "Mediaportal". I also stoped the TVService prior to executing the above commands.
Each time however, I get the following error:
"mysqlcheck: Got error: 10 45: Access denied for user 'root'@'localhost' <using password: YES> when trying to connect "
I have scoured the web to try and determine why I'm getting this error to no avail. Can someone please help as to why I'm getting this error and how to get around it.
I need a way to repair the MPTVDB database and the only way seems to be by executing the above but for some reason, I don't seem to have the privelages to execute the command.
Help greatly appreciated.