RadioDJ - Free Radio Automation Software Forum

Maria DB

AndyDeGroo

Re: Maria DB
« Reply #75 on: July 23, 2014, 01:42:37 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.

Offline Vanlen

  • *****
  • 1156
    • Music for your senses
Re: Maria DB
« Reply #76 on: July 23, 2014, 02:42:48 PM »
Thanks for the explanation.

Cheers

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

Offline 704djs

  • *****
  • 928
  • 704djs We break records like Dj's suppose
    • Hot 107.9 fm
Re: Maria DB
« Reply #77 on: September 02, 2014, 04:27:29 AM »
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.

Re: Maria DB
« Reply #78 on: September 02, 2014, 05:17:28 AM »

The link works for me.


link not work Gary
:)    Play the Music and Have Fun!    :ok:
==============================
 Fun In The Sun,  From the Florida Coast

Offline DJ Garybaldy

  • *****
  • 4329
  • Don't Shoot! I'm only the Moderator
    • DJ Garybaldy Blog
Re: Maria DB
« Reply #79 on: September 02, 2014, 08:09:19 AM »
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
« Last Edit: September 02, 2014, 10:11:05 AM by DJ Garybaldy »
Retired DJ & Proud USER of RadioDJ since 2010

https://djgarybaldy.blogspot.com/
https://djgarybaldy.blogspot.com/2020/08/radiodj-frequently-asked-questions-faq.html

Database repair: https://tinyurl.com/dbrepairradiodj

https://djgarybaldy.blogspot.com/p/about-me.html

elsilva0

Re: Maria DB
« Reply #80 on: January 02, 2015, 06:41:14 AM »
Quote
I 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?

Offline DJ Garybaldy

  • *****
  • 4329
  • Don't Shoot! I'm only the Moderator
    • DJ Garybaldy Blog
Re: Maria DB
« Reply #81 on: January 15, 2015, 05:44:39 PM »
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.

Quote
Have 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.
Retired DJ & Proud USER of RadioDJ since 2010

https://djgarybaldy.blogspot.com/
https://djgarybaldy.blogspot.com/2020/08/radiodj-frequently-asked-questions-faq.html

Database repair: https://tinyurl.com/dbrepairradiodj

https://djgarybaldy.blogspot.com/p/about-me.html

Offline Hansen

  • ***
  • 233
    • dinFM
Re: Maria DB
« Reply #82 on: January 15, 2015, 07:04:32 PM »
there is hope for mankind......

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

works perfectly even flawless ;)
Best Regards
Lars Hansen

Offline Marius

  • *****
  • 5673
    • Radio DJ
Re: Maria DB
« Reply #83 on: January 15, 2015, 07:23:51 PM »
 :D
DOWNLOADS PAGE

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

Online Jhonny

  • *****
  • 3930
  • Peace, enjoy life, last sleep is longer than live!
    • Jhonny's RadioDJ tutorials.
Re: Maria DB
« Reply #84 on: January 15, 2015, 10:39:58 PM »
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.
« Last Edit: January 15, 2015, 10:48:02 PM by Jhonny »
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, I do tuts. ( ͡° ͜ʖ ͡°) visit  https://radiodj.info

Testing RadioDJ v2.0.2.0 Beta

Offline DJ Garybaldy

  • *****
  • 4329
  • Don't Shoot! I'm only the Moderator
    • DJ Garybaldy Blog
Re: Maria DB
« Reply #85 on: September 03, 2015, 03:11:08 PM »
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.
Retired DJ & Proud USER of RadioDJ since 2010

https://djgarybaldy.blogspot.com/
https://djgarybaldy.blogspot.com/2020/08/radiodj-frequently-asked-questions-faq.html

Database repair: https://tinyurl.com/dbrepairradiodj

https://djgarybaldy.blogspot.com/p/about-me.html

Offline ricky

  • ***
  • 196
    • Preston Bissett Alternative Website
Re: Maria DB
« Reply #86 on: September 03, 2015, 10:22:37 PM »
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:

Offline DJ Garybaldy

  • *****
  • 4329
  • Don't Shoot! I'm only the Moderator
    • DJ Garybaldy Blog
Re: Maria DB
« Reply #87 on: September 04, 2015, 01:21:39 PM »
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

Retired DJ & Proud USER of RadioDJ since 2010

https://djgarybaldy.blogspot.com/
https://djgarybaldy.blogspot.com/2020/08/radiodj-frequently-asked-questions-faq.html

Database repair: https://tinyurl.com/dbrepairradiodj

https://djgarybaldy.blogspot.com/p/about-me.html

Offline DJ Garybaldy

  • *****
  • 4329
  • Don't Shoot! I'm only the Moderator
    • DJ Garybaldy Blog
Re: Maria DB
« Reply #88 on: June 01, 2016, 11:16:53 AM »
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.

Retired DJ & Proud USER of RadioDJ since 2010

https://djgarybaldy.blogspot.com/
https://djgarybaldy.blogspot.com/2020/08/radiodj-frequently-asked-questions-faq.html

Database repair: https://tinyurl.com/dbrepairradiodj

https://djgarybaldy.blogspot.com/p/about-me.html

Re: Maria DB
« Reply #89 on: June 02, 2016, 05:29:29 AM »
Yes!  I concur.