MySQL option

[THDBASED]

Originally Posted by samposoft

I currently use TVEngine on MySQL 5.0.26 and it's works.

Could you by any change maybe toss that changed installable version of the TVServer to your Server so I can try it out and maybe even help you out...
If you are not able to do this then you don't have to go to any big trouble to do this then I will just wait until it is in SVN realease....

Thanks!

THDBASED

[dunkstar]

The biggest problem is actually:

CREATE INDEX _dta_index_TuningDetail_7_709577566__K2_1_3_4_5_6_ 7_8_9_10_11_12_13_14_15_16_17_18_19_20_21_22_23_24 _25_26 ON TuningDetail
(
idChannel ASC
)
INCLUDE ( idTuning,
name,
provider,
channelType,
channelNumber,
frequency,
countryId,
isRadio,
isTv,
networkId,
transportId,
serviceId,
pmtPid,
freeToAir,
modulation,
polarisation,
symbolrate,
diseqc,
switchingFrequency,
bandwidth,
majorChannel,
minorChannel,
pcrPid,
videoSource,
tuningSource)

And MySQL doesn't support INCLUDE among others.
I've tried to make an universal setupdatabaseform which converts the database.sql into MySQL friendly SQL.
But if people are satisfied with changing the database.sql themselves you can just make the changes samposoft proposes.

[dunkstar]

One of the solutions I have done is this:

sql = sql.Replace("---", "#"); //Added by Dunkstar, MySQL dont use --- as comments
sql = sql.Replace("use master", " "); //Added by Dunkstar, there is no master database in MySQL
sql = sql.Replace("IF EXISTS (SELECT name FROM sysdatabases WHERE name = N'TvLibrary')", " "); //Added by Dunkstar, dont work in MySQL
sql = sql.Replace("IDENTITY(1,1) NOT NULL", "NOT NULL AUTO_INCREMENT"); //Added by Dunkstar, MySQL uses Auto_increment
sql = sql.Replace("IDENTITY(1,1)NOT NULL", "NOT NULL AUTO_INCREMENT"); //Added by Dunkstar, MySQL uses Auto_increment
sql = sql.Replace(" Version(", " Version ("); //Added by Dunkstar
sql = sql.Replace(" version(", " version ("); //Added by Dunkstar
sql = sql.Replace(" WITH CHECK ADD ", "ADD"); //Added by Dunkstar

Dont know what your thoughts are on this.

[dunkstar]

I can see that samposoft have just dropped "CREATE INDEX", "CREATE STATISTICS" and it looks like also the foreign keys...

[dunkstar]

I can see that somebody else is implementing MySQL option int the newest revisions, so I'll just stop

I look forward seeing how it works...

[THDBASED]

Great! Is it already available in latest SVN? Or will this be in there overnight?

[Noelix]

I'm too inexperienced at SQL server stuff, is there anybody who would be willing to put together a "how-to" for installing MySQL and getting it working with the tv server for us users?

[THDBASED]

Once the code is in the SVN it shoudn't be that hard to implement...SQL is SQL, the same for Mysql as for MSSQL...

[Flerbizky]

Originally Posted by Noelix

I'm too inexperienced at SQL server stuff, is there anybody who would be willing to put together a "how-to" for installing MySQL and getting it working with the tv server for us users?

Don't hold your breath for it, but I'll be transforming our setup from HTPC w. Cathode tube to TV Server based with 1920x1080 LCD over the next couple of weeks - and I'll definitely switch to MySQL as it is far superior to MSSQL in more ways than I can shake a stick at..

So I might as well put together a HowTo while doing so..

Cheers,
Steff

[frodo]

I'll definitely switch to MySQL as it is far superior to MSSQL in more ways than I can shake a stick at..

I disagree, in my tests mysql is way slower then MSSQL