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

Maria DB

Started by DJ Garybaldy, June 26, 2014, 10:12:27 AM

AndyDeGroo

Quote from: Vanlen on July 23, 2014, 01:13:04 AM
I'm wondering if backing up with MySQL is a good idea and for those starting out with MariaDB should start from scratch.   Seems to me the way to go.
You had internal mysql tables in backup file because you had "mysql" in "MySQL Database" field on Database Setup Utilty. That database should not be messed with.
I'm surprised that you didn't have issues before. It might have appeared after moving to MariaDB because internal tables are different in MariaDB.

Vanlen

Thanks for the explanation.

Cheers

Forest Green - Music in Nature's Frequency
www.forestgreenradio.ca

704djs

Quote from: DJ Garybaldy on June 26, 2014, 12:58:14 PM
Just done a Tutorial on setting up Maria DB http://djgarybaldy.co.uk/maria-db-radiodj/

Should be fairly easy if your not used to a SQL server......

Hope this helps someone.



link not work Gary
Beat 94.7/Hot 107.9  fm banging the hitz that you wanna hear.

FL Coast

:)    Play the Music and Have Fun!    :ok:
==================================
Fun In The Sun,  From the Florida Coast
***************************************************
"It is what we learn after we think we know it all, that counts."
John Wooden 1910 - 2010

DJ Garybaldy

#79
Quote
link not work Gary

Our  VPS fell over it should be up and running again now.

I've updated the original post about the tutorial to include a basic how to setup should my blog not be available.

http://www.radiodj.ro/community/index.php?topic=5339.msg31097#msg31097
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

elsilva0

QuoteI will also test it more and share my thoughts.

@Marius #Mairus Have u tested mariadb anymore? Does it really get more memory usage than mysql?

DJ Garybaldy

Just to confirm to anyone reading this topic.

So far since July 2014 my database hasn't crashed once, hasn't spluttered it's just worked as it should.

So yes the answer to the question: MariaDB is really stable and works like a trooper.

QuoteHave u tested mariadb anymore? Does it really get more memory usage than mysql?

You tell the program how much memory to use when you set MariaDB up I have mine set at 300mb and as you can tell everything works.
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

Hansen

there is hope for mankind......

by that, i mean that even i, could install this....

works perfectly even flawless ;)
Best Regards
Lars Hansen

Marius

DOWNLOADS PAGE

HOW TO FIX RADIODJ DATABASE
----------------
Please don't PM me for support requests. Use the forums instead.

Jhonny

#84
Today had a funeral of my uncle, was a bit sad, but after reading the latest comments, I really had to  :D :D :D

Quote@Marius #Mairus Have u tested mariadb anymore? Does it really get more memory usage than mysql?
No just less.
Hasta la vista elsilvaO, you have make my day. 
great boys... Thanks

JH.
R.T.F.M. means to me, Read The Fantastic Messages.
Einstein says: Make things simple, but don't make simple things simpler! (wise) this is just my life lesson you know.

I don't do drugs ( ͡° ͜ʖ ͡°)
The Radiodj tutorials site is now managed by Domstad radio .nl still  Just in English

DJ Garybaldy

I've just upgraded my copy of MariaDB to the latest build https://downloads.mariadb.org/mariadb/10.0.21/

Top Tip: As I've just found out before you attempt to upgrade MariaDB you need to:

A) Backup your RDJ database
B) Shut RadioDJ down including the database backup tool.
B) Stop mysqld.exe as a service.

Then you can begin the install of 10.0.21 if all goes to plan, the installer should automatically restart mysqld.exe as a service then you should just be able to restart RadioDJ

5 minute job if that.
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

ricky

Have been using it now for over two months and as of yet no problems it just works and as you say it is not as hard to setup  on win 7 pc  :) :cool:

DJ Garybaldy

I've been using MariaDB now since June 2014. I've never had a an SQL program that was this stable and easy to use.

Something would regularly go wrong with MySQL esp the 4 series but I don't seem to have that problem with MariaDB.

Only had to repair the database once to my memory and that was after a power cut. Other than that it's running absolutely flawless.

It's just nice when stuff works..... **Looks at Windows 10**  >:D

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

DJ Garybaldy

Wow has it really been 2 years this month since I first tried MariaDB .... ???

I don't know about anyone else but everything here is running as smooth as a nut...

It's been rare to have an issue. I haven't had to reinstall the database from scratch once. If I have had any issues they've been quickly sorted with HeidiSQL, The only time the DB has crashed was due to a power failure.

I love it when I can just leave software to do its own thing without having to constantly rebuild the database  :bash:

MariaDB & RadioDJ a partnership made in heaven? I think so.

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

packzap