RadioDJ - Free Radio Automation Software Forum

How to restore a database backup?

Offline Marius

  • *****
  • 5642
    • Radio DJ
How to restore a database backup?
« on: October 02, 2011, 05:26:18 PM »
As some of you may noticed, the database utility cannot restore large backup files. This is not an issue of database utility, but a MySQL setting that must be manually changed.
I prefer not to modify user files, so i will not automate this in any way.
So, how we can fix the "Packets larger than max_allowed_packet are not allowed." error?

1. Stop the MySQL server
2. Search "my.cnf" file (is located usually in "bin" subdirectory of MySQL)
3. Locate this line "max_allowed_packet = XM" where X is a number. Change that number to 10 or even higher if needed.
The new line should look like this:
max_allowed_packet = 10M

Save the file, start the mysql server and voila.  :)
DOWNLOADS PAGE

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

garybaldy72uk

Re: How to restore a database backup?
« Reply #1 on: October 25, 2011, 12:29:59 AM »
Post deleted by admin (link no longer worked)
« Last Edit: January 22, 2015, 04:32:03 PM by DJ Garybaldy »

Offline Marius

  • *****
  • 5642
    • Radio DJ
Re: How to restore a database backup?
« Reply #2 on: October 25, 2011, 08:00:38 AM »
Normally, this should do the trick.

[attachment deleted by admin]

[attachment deleted by admin]

[attachment deleted by admin]
DOWNLOADS PAGE

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

Offline Vanlen

  • *****
  • 1150
    • Music for your senses
Re: How to restore a database backup?
« Reply #3 on: October 25, 2011, 03:21:24 PM »
For those in the know re - backing up the DataBase.   I have a main play out system with mysql and music etc and also have a production -editing station on the Local Area Network.  Does it matter which computer I do the backup from or is it best to back up from the main system with database?
« Last Edit: October 25, 2011, 07:01:30 PM by Vanlen »
Forest Green - Music in Nature's Frequency
www.forestgreenradio.ca

Marvin

Re: How to restore a database backup?
« Reply #4 on: October 30, 2011, 12:13:18 AM »
On my Windows XP and Windows 2003 Server mysql the file to look for is my.ini   It did not contain max_allowed_packet = 1M.  So I added the line edited to 10M (max_allowed_packet = 10M).  Saved the file and restarted mysql.  Works like a champ.  Thanks Marius!

Marvin

Re: How to restore a database backup?
« Reply #5 on: October 30, 2011, 12:14:56 AM »
For those in the know re - backing up the DataBase.   I have a main play out system with mysql and music etc and also have a production -editing station on the Local Area Network.  Does it matter which computer I do the backup from or is it best to back up from the main system with database?
Do both of them. It saves the backup in the backup folder in your radiodj folder.  You can never have too many backups!

Offline Vanlen

  • *****
  • 1150
    • Music for your senses
Re: How to restore a database backup?
« Reply #6 on: October 30, 2011, 02:50:13 AM »
Thanks Marvin!

Never thought about two....but then again Murphy's Law rules  ;)


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

Re: How to restore a database backup?
« Reply #7 on: December 24, 2011, 06:27:22 AM »
Hi All, I have reset the max packet size to 10M, but to no avail. Using Win XP, mySQL 5.5 and Radio DJ V 1.6.0
The database is about 5,000 songs and there were 3 or 4 variable duration files of 85mb and 2 of 179mb. Does that make any difference? How do I get the database back????????

Marvin

Re: How to restore a database backup?
« Reply #8 on: February 28, 2012, 03:23:11 PM »
Doesn't work?  What error message?

Offline dariodc

  • ***
  • 167
  • Dario Nencini www.newliferadio.it www.serviceradio
    • newliferadio
Re: How to restore a database backup?
« Reply #9 on: May 17, 2012, 10:59:18 PM »
Hello, I'm trying to do a backup to clone the PC release, but I do not find my.cnf, it is possible that there is? there is in BIN, even in mysql, even in radiodj. I did look on XP but can not find ..
Dariodoc
www.newliferadio.it
www.serviceradio.it