MySQL mini server for RDJ !

[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...

[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 !

[ghm72]

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?

[nemoradio]

Yes you can ! Explained into the readme.txt file also !

[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.

[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

Code Select Expand

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]

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

Code Select Expand

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