MySQL Database Repair (1 Viewer)

[kkozma]

MediaPortal Version: 1.1 RC4
MediaPortal Skin: StreamedMP
Windows Version: Windows 7 64 Bit
CPU Type: Intel Core i3 530
HDD: Seagate 500gb, Hitachi 1TB, WD 1TB
Memory: 4gb
Motherboard: MSI H55M-E33
Video Card: INtel Clarkdale
Video Card Driver: Intel 8.15.10.2119
Sound Card: Intel Clarkdale
Sound Card AC3:
Sound Card Driver:
1. TV Card: HDhomerun
1. TV Card Type: ATSC
1. TV Card Driver:
2. TV Card: HDhomerun
2. TV Card Type: ATSC
2. TV Card Driver:
3. TV Card:
3. TV Card Type:
3. TV Card Driver:
4. TV Card:
4. TV Card Type:
4. TV Card Driver:
MPEG2 Video Codec: MS DTV
MPEG2 Audio Codec: ffdshow (Latest SAF)
h.264 Video Codec: ffdshow (Latest SAF)
Satelite/CableTV Provider:
HTPC Case:
Cooling:
Power Supply:
Remote: MCE 2005
TV: LG 47LH30
TV - HTPC Connection: HDMI through Onkyo 605

Last night I was forced to re-install MP on my HTPC due to a corrupt database (information_schema). I'm definitley not a noob when it comes to working with SQL so I figured I could just repair the database tables and that would be it and I'd be back in business. Errr! Wrong.

When I try to check the tables and repair them I always get the same error:

Error - Table `information_schema`.`CHARACTER_SETS` could not be optimized.
MySQL Error Nr.1044
Access denied for user 'root'@'localhost' to database 'information_schema'

So what's the deal here, why can't the root user make changes to this database? Is there another user I can log in with? The MPTVDB database repairs perfectly fine, it's just information_schema.

Thanks in advance!

 

[robbo100]

I am not an expert, but when I get database problems it is often easiest to delete the whole database and let MP reconstruct one (back it up first though in-case this causes different problems and you want to reinstate it).

Reinstalling will not necessarily replace the DB which might be the problem.

However - as I say, I am not an expert, so please use my advice with caution, and you may be better to wait for someone cleverer than me to answer your post.

Robbo100

 

[kkozma]

I did some digging around and it seems that the information_schema database isn't really a database which explains why I couldn't repair it.

So, I guess that leaves me with how do you recover from something like that?

 

[smith69085]

Normally best to just delete the database

Open Start > Programs > MySQL > MySQL Server and open the command line utility

Password on (MediaPortal if you didnt change it on install)

and enter drop database mytvdb;

dont forget the ;

This will clear the data
Reboot and launch the TV server config and re tune your cards, settings etc.

No recovery but it generally dose the job

 

[madcart]

I assume that should be:

drop database mptvdb;

 

[bingo99]

If you save your settings on the Import/Export tab you won't need to set everything up again from scratch, but you will need to check them just in case some things do change

You ma\y also need to rescan your channels

 

[gurk]

Normally best to just delete the database

Open Start > Programs > MySQL > MySQL Server and open the command line utility

Password on (MediaPortal if you didnt change it on install)

I'm a sql-dummy. How is the actual sxntax once I'm at the mysql> prompt? Above implies "Password on MediaPortal" but this appears to be incorrect.