SageTV Community  

Go Back   SageTV Community > SageTV Development and Customizations > SageTV v9 Customizations

Notices

SageTV v9 Customizations This forums is for discussing and sharing user-created modifications for the SageTV version 9 application created by using the SageTV Studio or through the use of external plugins. Use this forum to discuss plugins for SageTV version 9 and newer.

Reply
 
Thread Tools Search this Thread Display Modes
  #1  
Old 03-09-2021, 06:03 PM
mitchcecg mitchcecg is offline
Sage User
 
Join Date: Feb 2006
Posts: 31
help with Wiz.bin database is huge

my wiz.bin has grown to be 7,241,846kb is there a cleanup utility or some way for me to extract my favorites from it and import it into a new wiz.bin

Any info would be appreciated

BTW it causes an issue that the clients run out of memory and cant load

THANX
MITCH
If I had a son he would be a son of a Mitch
Reply With Quote
  #2  
Old 03-11-2021, 11:40 AM
egeller egeller is offline
Sage Aficionado
 
Join Date: Feb 2006
Location: Drexel Hill, PA
Posts: 275
I did that back in 2012. I rebuilt the wiz.bin from scratch. I am not aware of any automated way to clean out / compress the wiz.bin.

I ran a manual process. Prerequisites include having the Jetty web server and SageTV web interface installed. You need that to export favorites.

I was going to list the steps here, but I am lazy. Then I remembered I've worked in IT for 40 years. I keep notes. I found the notes. They point me to this link. It is what I used. Good luck.

Interestingly, I searched the forum for 'recreate "wiz.bin"' and the search returned no results. Fascinating. I had a PDF of the posting and used that to find it.
__________________
Server:UnRaid;2x Intel Xeon E5; SuperMicro moboard;Also:BM3000 w/ WMC; 2x Ceton ETH 6; OpenDCT
SageTV Extender:3x HD200 1x HD300
Sage TV: 9.2.1, Standard STVi, Comskip Playback, Web Interface, 24 Hour Clock, SRE, YouTube2015, Playon
All in lovely Drexel Hill, PA
Reply With Quote
  #3  
Old 03-16-2021, 02:44 AM
VCRUser VCRUser is offline
Sage Aficionado
 
Join Date: Jan 2008
Posts: 380
I looked at the linked instructions, and it said to export the wiz.bin as xml. In the web server I see an option to import xml but no export function.

(This is not something I need to do currently, but am saving the instructions for just-in-case).
__________________
Server: Windows 8.1 4gb RAM; 4TB SATA + others. Homebrew quad core AMD. Inputs: Haup. 980, 850 & 950Q on ATSC; Haup 1600 on ATSC & Comcast 2 DTAs with USBUIRT for NTSC. Haup 1800 on ATSC. HDHR Dual (ATSC). Sage 9.22 64 bit.
Reply With Quote
  #4  
Old 03-16-2021, 07:31 AM
graywolf's Avatar
graywolf graywolf is offline
Sage Icon
 
Join Date: Oct 2009
Location: NC
Posts: 1,323
From the Web UI

SageTV drop down, choose Recordings
Then above the list, you will see:
SageTV logoSage Recordings [XML]
Click on the XML icon
Reply With Quote
  #5  
Old 03-16-2021, 08:44 AM
CptKirk CptKirk is offline
Sage Advanced User
 
Join Date: Sep 2010
Posts: 170
Hmm, I just tried this and got the following

It tried to load this page after clicking on the XML icon: http://htpc:8080/sage/Recordings?xml=yes

Showed this error

Quote:
This site can’t be reached
The webpage at http://htpc:8080/sage/Recordings?xml=yes might be temporarily down or it may have moved permanently to a new web address.
ERR_INVALID_RESPONSE
Update...

I can go into Schedule Recordings-Favorites Manager and click on the orange XML icon for it to load page: http://htpc:8080/sage/Favorites?xml=yes

That prompts a download for favorites.xml, so I can get the favorites.xml download to work but for some reason the recordings.xml does not.
__________________
SageTV running on: Win7 SP1 64 Pro
SageTV 9.1.9.778 (32 bit)
Java 1.7.0_80 (32 bit)
OpenDCT 0.5.29 (Comcast Music channels set to FFmpeg)
Clients: HD300 (x2)
HDHR3-CC Prime 20190621 (Comcast CableCard) - 3 Tuners
Hauppauge 1950 STB SD (USB-UIRT Zone 1)
Hauppauge 1950 STB SD (USB-UIRT Zone 2)

Last edited by CptKirk; 03-16-2021 at 08:57 AM.
Reply With Quote
  #6  
Old 03-16-2021, 03:44 PM
KeithAbbott KeithAbbott is offline
Sage Icon
 
Join Date: Oct 2009
Location: Southeastern Michigan
Posts: 1,178
Quote:
Originally Posted by mitchcecg View Post
my wiz.bin has grown to be 7,241,846kb is there a cleanup utility or some way for me to extract my favorites from it and import it into a new wiz.bin
Just to clarify, are you certain the size of your wiz.bin is 7,241,846kb? That would be over 7gb. For comparison purposes, mine is 66,308kb, or 66mb. If your wiz.bin is actually 7,241,846 bytes, that is good size but not huge. If it truly is over 7gb, that could certainly be the cause of your problem. I'd be surprised if the Sage server would even successfully start.
__________________
Server: MSI Z270 SLI Plus ATX Motherboard, Intel i7-7700T CPU, 32GB Memory, unRAID 6.9.2, SageTV & OpenDCT Dockers
Tuners: 2 x SiliconDust HDHomeRun Prime Cable TV Tuners
Clients: Multiple HD300 Extenders, Multiple Fire TV Stick 4K w/MiniClient
Miscellaneous: Multiple Sony RM-VLZ620 Universal Remote Controls

Last edited by KeithAbbott; 03-16-2021 at 03:52 PM.
Reply With Quote
  #7  
Old 04-10-2021, 05:09 PM
mitchcecg mitchcecg is offline
Sage User
 
Join Date: Feb 2006
Posts: 31
Thanks

Just wanted to thank everyone for the reply

Mitch
If I had a son he would be a son of a Mitch
Reply With Quote
Reply


Currently Active Users Viewing This Thread: 1 (0 members and 1 guests)
 
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is On
HTML code is Off

Forum Jump

Similar Threads
Thread Thread Starter Forum Replies Last Post
HD Videos are huge! ericscottf Hardware Support 28 08-18-2010 11:58 AM
Huge Thanks pjt630 The SageTV Community 1 10-23-2008 07:09 PM
Is 8MB a huge wiz.bin? How to reduce? IVB SageTV Software 16 10-02-2005 05:11 PM
SageTV 2.1 is a huge mem/cpu hog? tankd0g SageTV Software 7 01-27-2005 10:21 AM


All times are GMT -6. The time now is 03:50 AM.


Powered by vBulletin® Version 3.8.11
Copyright ©2000 - 2021, vBulletin Solutions Inc.
Copyright 2003-2005 SageTV, LLC. All rights reserved.