• Welcome to RadioDJ - Free Radio Automation Software Forum. Please log in or sign up.

MySQL mini server for RDJ !

Started by nemoradio, June 25, 2014, 05:05:07 PM

nemoradio

Hello !

I don't know if someone found this interesting stuff before, but there is a mini portable MySQL server which seems to run well with RDJ 1.7.0. Here it is:
http://sourceforge.net/projects/miniserver/files/MiniServer/MiniServer_%20MySQL%205.0.67%20Portable/

It's only the MySQL part of the portable Uniform server. The default port is 3311, but you can easily tune it to 3306. Just follow the explanations from the readme file. Only a bat file to launch the server and another to stop it ! Its so simple ! And less than 2mb used in ram !

Just tried with a fresh RDJ 1.7.0 install (on a brand new Windows 7 64bits PC) and it works well !
Will try tonight at the studio with my full database to see how it can handle all the SQL requests...
www.nemoradio.fr

starlite

Does one have to load the whole Wamp setup or can use just the MySQL DB. 

What is the actual file to use with RDJ on XP to replace MySQL please.

Also looking at MariaDB..

oz

nemoradio

Just download the mini_server_11.zip file. This is only the MySQL server. Extract the archive somewhere on your HDD. Change MySQL port to 3306 as explained in the readme.txt file. Then launch the mysql_start.bat file. Configure RDJ database utility to use 127.0.0.1 server user: root / password: root.
That's all ! ;)
www.nemoradio.fr

DJ Garybaldy

Quote from: nemoradio on June 27, 2014, 01:00:04 PM
Just download the mini_server_11.zip file. This is only the MySQL server. Extract the archive somewhere on your HDD. Change MySQL port to 3306 as explained in the readme.txt file. Then launch the mysql_start.bat file. Configure RDJ database utility to use 127.0.0.1 server user: root / password: root.
That's all ! ;)

The password for a MySQL install should never be just "root" No matter even if it's a portable version. if it's connected to the Internet  it's open to attack!!

There must be a way of changing the root password surely?
Worlds Biggest Fan of RadioDJ

Install MariaDB https://djgarybaldy.blogspot.com/2020/08/installing-maria-db.html

Install RadioDJ: https://djgarybaldy.blogspot.com/2020/08/how-to-install-radiodj-free-radio.html

Into Internet radio for 25 years 1999-2024

RadioDJ 2045 MariaDB 11.2 Windows 11

nemoradio

Yes you can ! ;D Explained into the readme.txt file also !
www.nemoradio.fr

starlite

Thank you all.  Exciting challenges... :-)

starlite

Hi, 

I have RDJ  running fine so far with it however have not tried to get it to allow access from the web Demo Request script.

Have you got it to do this  yet, if so where do I go to enable remote or maybe it is not needed.

oz

nemoradio

Hi,
You have to copy the files from your "request" plugin folder  (in "disabled plugins" folder) to your "plugins folder" and restart RDJ.

Regards.
www.nemoradio.fr

joshuatree44

Going to give this a try. I noticed that the most up to date version of 5.6 MySQL is seeming to bog down some on my machine. I lose connection to it or RDJ seems to stall in place and then is back like nothing happened. Will let you know how this goes. I just want something that is good.

SnowHow

@joshuatree44

I've been playing with MariaDB the last couple of days and so far I'm impressed. You might want to have a look: MariaDB

It's a drop-in replacement for MySQL

joshuatree44

OK will it import the already setup DB? I am growing tired of MySQL. Also I am trying this portable setup and I am not finding
a) Edit mysql_start.bat locate line:
    udrive\bin\mysqladmin.exe --port=3311 --user=root --password=root shutdown
   Change to:
    udrive\bin\mysqladmin.exe --port=3307 --user=root --password=root shutdown

in the file. I have yet to find it. The other part no prob.

SnowHow

Quote from: joshuatree44 on June 29, 2014, 04:59:21 AM
OK will it import the already setup DB? I am growing tired of MySQL. Also I am trying this portable setup and I am not finding
a) Edit mysql_start.bat locate line:
    udrive\bin\mysqladmin.exe --port=3311 --user=root --password=root shutdown
   Change to:
    udrive\bin\mysqladmin.exe --port=3307 --user=root --password=root shutdown

in the file. I have yet to find it. The other part no prob.

Sorry, I haven't played with the mini portable server at all...

joshuatree44

OK cool. Is there a simple way to setup the Dropin and just move everything over from mysql 5.6.19 to what ever? I just want to be rid of crap not working or having issues. I love how radiodj has come along but mysql has not. Sad but again what can you do.

SnowHow

This is what I did, your mileage may vary:

First, I backed up the entire database - everything.

I went into services, stopped then disabled MySQL

I installed MariaDB and during the install, you have the option to change the service name. The default is MySQL, I changed it to
MariaDB

After it was installed, I restored my databases into MariaDB just like I would MySQL and was up and running in no time.

It was really easy.

J-


joshuatree44

OK cool I will give that a shot. I hope it works easy and not muck up everything. I do love I have an auto backup thanks to Marius and the features he has put in. Thanks Marius :)