BackupSettings for Tv Server and Media Portal (1 Viewer)

[AfshinBarani]

hi huha
i have a problem
i tried 2 times to import the backup files , but both times i get "uable to creat graph" message on tv channels
every thing else is ok
i use MP 1.2.3
Win7 64bit
and latest version of plugins.
My DVB Card is Technotrend 1600 (DVB-S2)
if you need more info please tell me and sry for my bad english.

 

[Der_Bub]

try repair database

 

[AfshinBarani]

unfortunetely i cant read deutsch , so

 

[Lehmden]

Hi.
It's easy. Create a batch file with two lines in:

cd c:\Program Files\MySQL\MySQL Server 5.1\bin
mysqlcheck.exe -u root -pMediaPortal --auto-repair --all-databases

Copy those two lines to Notepad and safe the file as (e.g.) databaserepair.bat

If you have another path to your MySQL Dir you have to change this in first line. If you don't use default Mediaportal user and Password you have to change this in second row (-u is username, -p is password, important to have a white space after -u and none after -p).

Now you only need to doubleclick the .bat file and the database will be repaired automatically

 

[AfshinBarani]

Worked great , thanks a lot

 

[huha]

Lehmden,
I am planning to include your script into BackupSettings in one of my next versions. I had also issues in the past with a corrupted database.
A couple of questions on this:

1) I guess i can make it user friendly by creating the script from Gentle.config and using the correct user name and password.
As Tv server is supporting MySQL and MsSQL do you know how the script would look like for MsSQL users?

2) From what I have seen the script does not require "start as admin" for the UAC, but I did not have anything to repair. Does it repair the data even in standard user mode?

3) I am getting an error message when running your script "You can´t use locks with log tables". Do i have to worry about this?

Thanks a lot for your posting!

 

[Lehmden]

Hi.
@1) Mysqlcheck.exe is part of the MySQL distribution. The executable is located in the BIN subdir of the MySQL installation. (see first line of batch).. I don't know if there is something similar on MsSQL as I don't use MsSQL. Maybe someone who uses MsSQL can tell you.

@2) I don't believe MySQLcheck.exe needs to be running as Admin. But I don't know for sure as I always have UAC disabled and the only User I've created is an Admin...

@3) Don't worry, Should be working also you got this message.

 

[huha]

Test Version 1.2.0.14 released
I have done a major code reordering and I am releasing this test version which includes now a new client backup/restore program for MP1, MP2 Client and MP2 server. As a result from the code restructuring i am also supporting now scheduled exports via Tv server. This version also includes the Lehmden script for automatic database repair before an export and before an import.
I do need help in testing as this is a big change from the previous version.

Update: Ignore the PB_Export error message when you run the first time

Version 1.2.0.14

-new: auto repair of Tv server database before export and before import with the Lehmden script (only for users of MySQL)
-new: scheduled export by tvserver
-new. MP1/MP2 client program and MP2 client plugin
-many minor bug fixes
-installer updated

 

[huha]

Update: The scheduler is not working yet - I am working on a fix

 

[huha]

I have tested now the automated exporter for more than a week and everything worked fine. Attached the corrected version.
Greetings, huha