View unanswered posts    View active topics

All times are UTC - 6 hours





Post new topic Reply to topic  [ 23 posts ] 
Go to page Previous  1, 2

Print view Previous topic   Next topic  
Author Message
Search for:
 Post subject: Frontend fix on wiki.
PostPosted: Mon Dec 05, 2005 5:21 am 
Offline
Joined: Wed Jan 26, 2005 3:13 pm
Posts: 117
http://www.knoppmythwiki.org/index.php? ... nlyInstall

I added this last week, I don't kow the exact fix for the database but dropping the old and adding the new works great!

Just make sure you know all the paths for everything.



Snake


Top
 Profile  
 
 Post subject:
PostPosted: Tue Dec 06, 2005 10:59 pm 
Offline
Joined: Mon Aug 29, 2005 4:04 pm
Posts: 729
Location: Philadelphia, PA US
Quote:
I added this last week, I don't kow the exact fix for the database but dropping the old and adding the new works great!


Dropping the database means deleting all tables stored in mythconverg DB.

http://dev.mysql.com/doc/refman/5.0/en/ ... abase.html

I have been running R5A26 for a few weeks as FE/BE and now want to use it as a backend. Does this mean from dropping the DB I will have to re-setup all my MythTV prefrences/setting and repopulate my MythVideo information? Or is it just the info my mythtv-setup portion of setup that will have to be re-inputted?

I am a little scared to do this to and loose all those settings.


Top
 Profile  
 
 Post subject:
PostPosted: Wed Dec 07, 2005 3:40 pm 
Offline
Joined: Sun May 22, 2005 2:44 pm
Posts: 105
Location: The Netherlands
Hi,

Almost everything is stored in the database. .nuv files (recordings) can be reimported using myth.rebuilddatabase.pl, but the possibilities to edit/cut are very limited. Content of /myth/video after entering the setup item in the main menu of the frontend. Samewhere on this path you will find the item 'video' . In my case the content of /myth/video is re-inputted in the database (filenames only). Worst case scenario, I assume?

Fiete


Top
 Profile  
 
 Post subject:
PostPosted: Wed Dec 07, 2005 4:45 pm 
Offline
Joined: Mon Aug 29, 2005 4:04 pm
Posts: 729
Location: Philadelphia, PA US
Well I toyed around and it looks like you can backup the MySQL DBs including mythconverg using MYSQL in Webmin. Webmin backs up to a .sql file so with some basic editing I can always restore the metadata from MythVideo and such using mysql <backup.sql commands.

Thanks,


Top
 Profile  
 
 Post subject:
PostPosted: Thu Dec 08, 2005 6:13 am 
Offline
Joined: Sun May 22, 2005 2:44 pm
Posts: 105
Location: The Netherlands
There is another thread in the forum dealing with the remote frontend problem on R5A26:

http://mysettopbox.tv/phpBB2/viewtopic.php?t=7066

The post from akulcsar might be interesting for you. Please let me know if it works.

Thanks.

Fiete


Top
 Profile  
 
 Post subject:
PostPosted: Thu Dec 08, 2005 8:43 pm 
Offline
Site Admin
Joined: Fri Sep 19, 2003 6:37 pm
Posts: 2659
Location: Whittier, Ca
My sincere apologies, this is due to poor QC on my part. I'll endeavour to insure this doesn't occur again.


Top
 Profile  
 
 Post subject:
PostPosted: Fri Dec 09, 2005 12:01 am 
Offline
Joined: Mon Aug 29, 2005 4:04 pm
Posts: 729
Location: Philadelphia, PA US
Quote:
The post from akulcsar might be interesting for you. Please let me know if it works.


IT WORKED !!! I updated the previously mentioned thread as well, but bascially this is what I did.

Code:
root@mythtv~# mysql

Welcome to the MySQL monitor.  Commands end with ; or \g.
Your MySQL connection id is 9 to server version: 4.0.22-log
Type 'help;' or '\h' for help. Type '\c' to clear the buffer.

mysql> use mythconverg
Reading table information for completion of table and column names
You can turn off this feature to get a quicker startup with -A
Database changed

mysql> UPDATE settings SET settings.hostname=null WHERE settings.value='DBSchemaVer';
Query OK, 1 row affected (0.01 sec)
Rows matched: 1  Changed: 1  Warnings: 0

mysql> \q


After making that DB change my R5A26 Frontend connects to my R5A26 Backend fine.

Quote:
My sincere apologies,

Not a big deal mistakes can happen. Thank you for all the hard work yourself and other devs put into this project. Knoppmyth really is a great project and I personally don't mind debugging.


Top
 Profile  
 
 Post subject:
PostPosted: Fri Dec 23, 2005 9:36 pm 
Offline
Joined: Sat Dec 10, 2005 1:24 pm
Posts: 6
Location: Minnesota
Uhh, none of those solutions have helped me. Can anyone suggest anything else?

_________________
<blockquote><i>"I Said I Was Smart, I Never Said I Was Mature..."</i><br>
--Ivan Kowalenko</blockquote>


Top
 Profile  
 

Display posts from previous:  Sort by  
Post new topic Reply to topic  [ 23 posts ] 
Go to page Previous  1, 2



All times are UTC - 6 hours




Who is online

Users browsing this forum: No registered users and 10 guests


You cannot post new topics in this forum
You cannot reply to topics in this forum
You cannot edit your posts in this forum
You cannot delete your posts in this forum
You cannot post attachments in this forum

Jump to:  
Powered by phpBB® Forum Software © phpBB Group

Theme Created By ceyhansuyu