MySQL ?

chenks · 2007-02-13, 21:05

does it have to be MySQL5 ? or will it also work with MySQL4?

it's v4 i have on my server already... and don't want to migrate my existing databases to v5.

chenks · 2007-02-15, 11:20

no-one able to answer this ?

htpsd · 2007-02-18, 13:58

I didn't test it with MySQL 4. But when your databaseserver is running on windows, it is quite easy to run both: MySQL 4 and 5. You just have to edit some specs in the my.ini and set the standartport from one of them to a diffrent than 3306

Greets

samposoft · 2007-02-18, 18:39

I have no tested tvengine on mysql 4 but i think that can works.
Threre are no specific mysql 5 sql syntax in "mysqldatabase.sql".

You can try to create manually the database with mediaportal sql script.

Try and tell if works.

chenks · 2007-02-18, 19:12

i tried to connect but it failed.. even though root user/pass was correct.

don't know if the tvsetup.exe created a database itself for mysql... or if you had to manually create one first.

2007-02-13, 21:05	#1 (permalink)
chenks Portal Member Join Date: May 2006 Location: Scotland Age: 32 Posts: 728 Thanks: 1 Thanked 1 Time in 1 Post Country: My System	MySQL ? does it have to be MySQL5 ? or will it also work with MySQL4? it's v4 i have on my server already... and don't want to migrate my existing databases to v5.

2007-02-18, 13:58	#3 (permalink)
htpsd Portal Member Join Date: Nov 2006 Location: Aachen Age: 22 Posts: 12 Thanks: 0 Thanked 0 Times in 0 Posts Country: My System	I didn't test it with MySQL 4. But when your databaseserver is running on windows, it is quite easy to run both: MySQL 4 and 5. You just have to edit some specs in the my.ini and set the standartport from one of them to a diffrent than 3306 Greets __________________ My TVServer: - AMD Athlon64 X2 4600+ AM2 on MSI K9N-Diamond Plus! - 4 GB RAM Samsung 1000Mhz DDR-2 - 3,5 TB RAID 5 on Promise EX8350 (8X WD Caviar) - 2X Technotrend S1500 DVB-S - 1X Technotrend S1101 DVB-S - 1X Technotrend S3200 DVB-S2 My Clients: - Samsung X20 1730V (Notebook) - 3x Asus Pundit P1 (Barebone) - Selfmade (See Systemspecs)

Thread Tools
Show Printable Version Email this Page
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
MySQL or MicrosoftSQL?	pedra	General Talk	10	2007-02-18 22:32
MySQL option	dunkstar	Development	44	2007-02-01 14:28
MySQL Useable?	Comm	Get Support	2	2007-01-29 10:05
MPWebControl with mySQL	klestor	Plugins	2	2006-04-09 20:42

2007-02-15, 11:20	#2 (permalink)
chenks Portal Member Join Date: May 2006 Location: Scotland Age: 32 Posts: 728 Thanks: 1 Thanked 1 Time in 1 Post Country: My System	no-one able to answer this ?

2007-02-18, 18:39	#4 (permalink)
samposoft Portal Member Join Date: Jan 2007 Age: 32 Posts: 28 Thanks: 0 Thanked 0 Times in 0 Posts Country: My System	I have no tested tvengine on mysql 4 but i think that can works. Threre are no specific mysql 5 sql syntax in "mysqldatabase.sql". You can try to create manually the database with mediaportal sql script. Try and tell if works.

2007-02-18, 19:12	#5 (permalink)
chenks Portal Member Join Date: May 2006 Location: Scotland Age: 32 Posts: 728 Thanks: 1 Thanked 1 Time in 1 Post Country: My System	i tried to connect but it failed.. even though root user/pass was correct. don't know if the tvsetup.exe created a database itself for mysql... or if you had to manually create one first.