<html>
<head>
<meta http-equiv="Content-Type" content="text/html; charset=UTF-8">
</head>
<body text="#000000" bgcolor="#FFFFFF">
<p><br>
</p>
<p> </p>
<p style="margin-bottom: 0in; line-height: 100%"><span
style="font-style: normal">Hi
</span><span style="font-style: normal">Stephen</span><span
style="font-style: normal">!</span></p>
<p style="margin-bottom: 0in; line-height: 100%"><span
style="font-style: normal">(From
yesterday’s)</span></p>
<pre class="western">If you want to go ahead and export all the existing recordings from
BE2 to BE3, then you need to first decide how you are going to move
all the recording files to BE3. How many recordings are there? Do
you want to move the hard drive(s) with the recording files from BE2
to BE3? That would probably be the easiest if there are lots of
recordings. Otherwise, you would first need to ensure that BE3 has
enough space on its recording drives for all of BE2's recordings, plus
space for any new ones it will be making. Then you would need to set
up network access (using SAMBA?) for BE2 to be able to write files to
BE3's recording drives. Or you could temporarily install each BE2
recording drive on BE3 to move the recording files. Or use an
external drive mount to do that. I will need to know how this is
going to happen in order to do a custom version of mythexport for you.
Also, does BE2 have multiple recording file locations (multiple
directories in its recording storage groups)? Does BE3 record to any
storage groups other than "Default"? Does BE3 have multiple recording
drives, or only one?</pre>
<p style="margin-bottom: 0in; line-height: 100%">
<br>
</p>
<p style="margin-bottom: 0in; line-height: 100%">(From today’s)</p>
<pre class="western" style="margin-bottom: 0.2in">Some SQL queries you can run on BE2 and BE3 that can help with all this:
do_mythconverg.sh
# Number of recordings
select count(*) from recorded;
# Total size of recordings in bytes
select sum(filesize) from recorded;
# Total size of recordings in Gbytes
select sum(filesize)/1000/1000/1000 from recorded;
# List of all partitions in all storage groups
select * from storagegroup order by groupname,dirname;
quit</pre>
<dl>
<dd>
<table width="618" cellspacing="0" cellpadding="4">
<colgroup><col width="608"> </colgroup><tbody>
<tr>
<td style="border: 1px solid #000000; padding: 0.04in"
width="608" valign="top">
<p>Glad I procrastinated! The above mythconverg commands
makes things a lot easier!!</p>
</td>
</tr>
<tr>
<td style="border-top: none; border-bottom: 1px solid
#000000; border-left: 1px solid #000000; border-right:
1px solid #000000; padding-top: 0in; padding-bottom:
0.04in; padding-left: 0.04in; padding-right: 0.04in"
width="608" valign="top">
<p><br>
</p>
</td>
</tr>
<tr>
<td style="border-top: none; border-bottom: 1px solid
#000000; border-left: 1px solid #000000; border-right:
1px solid #000000; padding-top: 0in; padding-bottom:
0.04in; padding-left: 0.04in; padding-right: 0.04in"
width="608" valign="top">
<p>Run from Backend-3 – the destination box:</p>
<p><br>
</p>
<p><font face="Andale Mono"><font style="font-size: 9pt"
size="2">barry@Backend-3:~$ do_mythconverg.sh</font></font></p>
<p><font face="Andale Mono"><font style="font-size: 9pt"
size="2">Reading table information for completion
of table and column names</font></font></p>
<p><font face="Andale Mono"><font style="font-size: 9pt"
size="2">You can turn off this feature to get a
quicker startup with -A</font></font></p>
<p><br>
</p>
<p><font face="Andale Mono"><font style="font-size: 9pt"
size="2">Welcome to the MariaDB monitor. Commands
end with ; or \g.</font></font></p>
<p><font face="Andale Mono"><font style="font-size: 9pt"
size="2">Your MariaDB connection id is 4816</font></font></p>
<p><font face="Andale Mono"><font style="font-size: 9pt"
size="2">Server version:
10.1.38-MariaDB-0ubuntu0.18.04.2 Ubuntu 18.04</font></font></p>
<p><br>
</p>
<p><font face="Andale Mono"><font style="font-size: 9pt"
size="2">Copyright (c) 2000, 2018, Oracle, MariaDB
Corporation Ab and others.</font></font></p>
<p><br>
</p>
<p><font face="Andale Mono"><font style="font-size: 9pt"
size="2">Type 'help;' or '\h' for help. Type '\c'
to clear the current input statement.</font></font></p>
<p><br>
</p>
<p><br>
</p>
<p><font face="Andale Mono"><font style="font-size: 9pt"
size="2">MariaDB [mythconverg]> select count(*)
from recorded;</font></font></p>
<p><font face="Andale Mono"><font style="font-size: 9pt"
size="2">+----------+</font></font></p>
<p><font face="Andale Mono"><font style="font-size: 9pt"
size="2">| count(*) |</font></font></p>
<p><font face="Andale Mono"><font style="font-size: 9pt"
size="2">+----------+</font></font></p>
<p><font face="Andale Mono"><font style="font-size: 9pt"
size="2">| 110 |</font></font></p>
<p><font face="Andale Mono"><font style="font-size: 9pt"
size="2">+----------+</font></font></p>
<p><font face="Andale Mono"><font style="font-size: 9pt"
size="2">1 row in set (0.00 sec)</font></font></p>
<p><br>
</p>
<p><br>
</p>
<p><font face="Andale Mono"><font style="font-size: 9pt"
size="2">MariaDB [mythconverg]> select
sum(filesize) from recorded;</font></font></p>
<p><font face="Andale Mono"><font style="font-size: 9pt"
size="2">+---------------+</font></font></p>
<p><font face="Andale Mono"><font style="font-size: 9pt"
size="2">| sum(filesize) |</font></font></p>
<p><font face="Andale Mono"><font style="font-size: 9pt"
size="2">+---------------+</font></font></p>
<p><font face="Andale Mono"><font style="font-size: 9pt"
size="2">| 335301163476 |</font></font></p>
<p><font face="Andale Mono"><font style="font-size: 9pt"
size="2">+---------------+</font></font></p>
<p><font face="Andale Mono"><font style="font-size: 9pt"
size="2">1 row in set (0.00 sec)</font></font></p>
<p><br>
</p>
<p><br>
</p>
<p><font face="Andale Mono"><font style="font-size: 9pt"
size="2">MariaDB [mythconverg]> select
sum(filesize)/1000/1000/1000 from recorded;</font></font></p>
<p><font face="Andale Mono"><font style="font-size: 9pt"
size="2">+------------------------------+</font></font></p>
<p><font face="Andale Mono"><font style="font-size: 9pt"
size="2">| sum(filesize)/1000/1000/1000 |</font></font></p>
<p><font face="Andale Mono"><font style="font-size: 9pt"
size="2">+------------------------------+</font></font></p>
<p><font face="Andale Mono"><font style="font-size: 9pt"
size="2">| 335.301163476000 |</font></font></p>
<p><font face="Andale Mono"><font style="font-size: 9pt"
size="2">+------------------------------+</font></font></p>
<p><font face="Andale Mono"><font style="font-size: 9pt"
size="2">1 row in set (0.00 sec)</font></font></p>
<p><br>
</p>
<p><br>
</p>
<p><font face="Andale Mono"><font style="font-size: 9pt"
size="2">MariaDB [mythconverg]> select * from
storagegroup order by groupname,dirname;</font></font></p>
<p><font face="Andale Mono"><font style="font-size: 9pt"
size="2">+----+-------------+-----------+---------------------------------+</font></font></p>
<p><font face="Andale Mono"><font style="font-size: 9pt"
size="2">| id | groupname | hostname | dirname |</font></font></p>
<p><font face="Andale Mono"><font style="font-size: 9pt"
size="2">+----+-------------+-----------+---------------------------------+</font></font></p>
<p><font face="Andale Mono"><font style="font-size: 9pt"
size="2">| 9 | Banners | Backend-3 |
/home/barry/Mythtv/banners/ |</font></font></p>
<p><font face="Andale Mono"><font style="font-size: 9pt"
size="2">| 5 | Coverart | Backend-3 |
/home/barry/Mythtv/coverart/ |</font></font></p>
<p><font face="Andale Mono"><font style="font-size: 9pt"
size="2">| 2 | DB Backups | Backend-3 |
/home/barry/Mythtv/db_backups/ |</font></font></p>
<p><font face="Andale Mono"><font style="font-size: 9pt"
size="2">| 14 | Default | Backend-3 |
/home/barry/Mythtv/recordings/ |</font></font></p>
<p><font face="Andale Mono"><font style="font-size: 9pt"
size="2">| 7 | Fanart | Backend-3 |
/home/barry/Mythtv/fanart/ |</font></font></p>
<p><font face="Andale Mono"><font style="font-size: 9pt"
size="2">| 1 | LiveTV | Backend-3 |
/home/barry/Mythtv/livetv/ |</font></font></p>
<p><font face="Andale Mono"><font style="font-size: 9pt"
size="2">| 11 | Music | Backend-3 |
/home/barry/Mythtv/music/ |</font></font></p>
<p><font face="Andale Mono"><font style="font-size: 9pt"
size="2">| 12 | MusicArt | Backend-3 |
/home/barry/Mythtv/music_art/ |</font></font></p>
<p><font face="Andale Mono"><font style="font-size: 9pt"
size="2">| 10 | Photographs | Backend-3 |
/home/barry/Mythtv/photographs/ |</font></font></p>
<p><font face="Andale Mono"><font style="font-size: 9pt"
size="2">| 8 | Screenshots | Backend-3 |
/home/barry/Mythtv/screenshots/ |</font></font></p>
<p><font face="Andale Mono"><font style="font-size: 9pt"
size="2">| 4 | Trailers | Backend-3 |
/home/barry/Mythtv/trailers/ |</font></font></p>
<p><font face="Andale Mono"><font style="font-size: 9pt"
size="2">| 3 | Videos | Backend-3 |
/home/barry/Mythtv/videos/ |</font></font></p>
<p><font face="Andale Mono"><font style="font-size: 9pt"
size="2">+----+-------------+-----------+---------------------------------+</font></font></p>
<p><font face="Andale Mono"><font style="font-size: 9pt"
size="2">12 rows in set (0.01 sec)</font></font></p>
<p><br>
</p>
<p><font face="Andale Mono"><font style="font-size: 9pt"
size="2">MariaDB [mythconverg]> </font></font>
</p>
<p><br>
</p>
</td>
</tr>
<tr>
<td style="border-top: none; border-bottom: 1px solid
#000000; border-left: 1px solid #000000; border-right:
1px solid #000000; padding-top: 0in; padding-bottom:
0.04in; padding-left: 0.04in; padding-right: 0.04in"
width="608" valign="top">
<p><br>
</p>
</td>
</tr>
<tr>
<td style="border-top: none; border-bottom: 1px solid
#000000; border-left: 1px solid #000000; border-right:
1px solid #000000; padding-top: 0in; padding-bottom:
0.04in; padding-left: 0.04in; padding-right: 0.04in"
width="608" valign="top">
<p>Run from BE2 – the source box:</p>
<p>(Real name is MythBE2)</p>
<p><br>
</p>
<p><font face="Andale Mono"><font style="font-size: 9pt"
size="2">barry@MythBE2:~$ do_mythconverg.sh</font></font></p>
<p><font face="Andale Mono"><font style="font-size: 9pt"
size="2">bash: /usr/local/bin/do_mythconverg.sh:
Permission denied</font></font></p>
<p style="margin-left: 0.49in">(I had not rebooted the
machine following installation, not sure if the need
for sudo shows anything or a special requirment ro run
mythimport/mythexport.)</p>
<p><font face="Andale Mono"><font style="font-size: 9pt"
size="2">barry@MythBE2:~$ sudo do_mythconverg.sh</font></font></p>
<p><font face="Andale Mono"><font style="font-size: 9pt"
size="2">mysql: [Warning] Using a password on the
command line interface can be insecure.</font></font></p>
<p><font face="Andale Mono"><font style="font-size: 9pt"
size="2">Reading table information for completion
of table and column names</font></font></p>
<p><font face="Andale Mono"><font style="font-size: 9pt"
size="2">You can turn off this feature to get a
quicker startup with -A</font></font></p>
<p><br>
</p>
<p><font face="Andale Mono"><font style="font-size: 9pt"
size="2">Welcome to the MySQL monitor. Commands
end with ; or \g.</font></font></p>
<p><font face="Andale Mono"><font style="font-size: 9pt"
size="2">Your MySQL connection id is 21977</font></font></p>
<p><font face="Andale Mono"><font style="font-size: 9pt"
size="2">Server version: 5.7.26-0ubuntu0.16.04.1
(Ubuntu)</font></font></p>
<p><br>
</p>
<p><font face="Andale Mono"><font style="font-size: 9pt"
size="2">Copyright (c) 2000, 2019, Oracle and/or
its affiliates. All rights reserved.</font></font></p>
<p><br>
</p>
<p><font face="Andale Mono"><font style="font-size: 9pt"
size="2">Oracle is a registered trademark of
Oracle Corporation and/or its</font></font></p>
<p><font face="Andale Mono"><font style="font-size: 9pt"
size="2">affiliates. Other names may be trademarks
of their respective</font></font></p>
<p><font face="Andale Mono"><font style="font-size: 9pt"
size="2">owners.</font></font></p>
<p><br>
</p>
<p><font face="Andale Mono"><font style="font-size: 9pt"
size="2">Type 'help;' or '\h' for help. Type '\c'
to clear the current input statement.</font></font></p>
<p><br>
</p>
<p><br>
</p>
<p><font face="Andale Mono"><font style="font-size: 9pt"
size="2">mysql> select count(*) from recorded;</font></font></p>
<p><font face="Andale Mono"><font style="font-size: 9pt"
size="2">+----------+</font></font></p>
<p><font face="Andale Mono"><font style="font-size: 9pt"
size="2">| count(*) |</font></font></p>
<p><font face="Andale Mono"><font style="font-size: 9pt"
size="2">+----------+</font></font></p>
<p><font face="Andale Mono"><font style="font-size: 9pt"
size="2">| 878 |</font></font></p>
<p><font face="Andale Mono"><font style="font-size: 9pt"
size="2">+----------+</font></font></p>
<p><font face="Andale Mono"><font style="font-size: 9pt"
size="2">1 row in set (0.02 sec)</font></font></p>
<p><br>
</p>
<p><br>
</p>
<p><font face="Andale Mono"><font style="font-size: 9pt"
size="2">mysql> select sum(filesize) from
recorded;</font></font></p>
<p><font face="Andale Mono"><font style="font-size: 9pt"
size="2">+---------------+</font></font></p>
<p><font face="Andale Mono"><font style="font-size: 9pt"
size="2">| sum(filesize) |</font></font></p>
<p><font face="Andale Mono"><font style="font-size: 9pt"
size="2">+---------------+</font></font></p>
<p><font face="Andale Mono"><font style="font-size: 9pt"
size="2">| 2513111679220 |</font></font></p>
<p><font face="Andale Mono"><font style="font-size: 9pt"
size="2">+---------------+</font></font></p>
<p><font face="Andale Mono"><font style="font-size: 9pt"
size="2">1 row in set (0.00 sec)</font></font></p>
<p><br>
</p>
<p><br>
</p>
<p><font face="Andale Mono"><font style="font-size: 9pt"
size="2">mysql> select
sum(filesize)/100/1000/1000 from recorded;</font></font></p>
<p><font face="Andale Mono"><font style="font-size: 9pt"
size="2">+-----------------------------+</font></font></p>
<p><font face="Andale Mono"><font style="font-size: 9pt"
size="2">| sum(filesize)/100/1000/1000 |</font></font></p>
<p><font face="Andale Mono"><font style="font-size: 9pt"
size="2">+-----------------------------+</font></font></p>
<p><font face="Andale Mono"><font style="font-size: 9pt"
size="2">| 25131.413409200000 |</font></font></p>
<p><font face="Andale Mono"><font style="font-size: 9pt"
size="2">+-----------------------------+</font></font></p>
<p><font face="Andale Mono"><font style="font-size: 9pt"
size="2">1 row in set (0.00 sec)</font></font></p>
<p><br>
</p>
<p><br>
</p>
<p><font face="Andale Mono"><font style="font-size: 9pt"
size="2">mysql> select * from storagegroup
order by groupname,dirname;</font></font></p>
<p><font face="Andale Mono"><font style="font-size: 9pt"
size="2">+----+-------------+----------+----------------------------+</font></font></p>
<p><font face="Andale Mono"><font style="font-size: 9pt"
size="2">| id | groupname | hostname | dirname |</font></font></p>
<p><font face="Andale Mono"><font style="font-size: 9pt"
size="2">+----+-------------+----------+----------------------------+</font></font></p>
<p><font face="Andale Mono"><font style="font-size: 9pt"
size="2">| 9 | Banners | MythBE2 |
/data3/mythtv/banners/ |</font></font></p>
<p><font face="Andale Mono"><font style="font-size: 9pt"
size="2">| 6 | Coverart | MythBE2 |
/data3/mythtv/coverart/ |</font></font></p>
<p><font face="Andale Mono"><font style="font-size: 9pt"
size="2">| 3 | DB Backups | MythBE2 |
/data3/mythtv/db_backups/ |</font></font></p>
<p><font face="Andale Mono"><font style="font-size: 9pt"
size="2">| 1 | Default | MythBE2 |
/data3/mythtv/recordings/ |</font></font></p>
<p><font face="Andale Mono"><font style="font-size: 9pt"
size="2">| 7 | Fanart | MythBE2 |
/data3/mythtv/fanart/ |</font></font></p>
<p><font face="Andale Mono"><font style="font-size: 9pt"
size="2">| 2 | LiveTV | MythBE2 |
/data3/mythtv/livetv/ |</font></font></p>
<p><font face="Andale Mono"><font style="font-size: 9pt"
size="2">| 11 | Music | MythBE2 |
/data3/mythtv/music/ |</font></font></p>
<p><font face="Andale Mono"><font style="font-size: 9pt"
size="2">| 12 | MusicArt | MythBE2 |
/data3/mythtv/music_art/ |</font></font></p>
<p><font face="Andale Mono"><font style="font-size: 9pt"
size="2">| 10 | Photographs | MythBE2 |
/data3/mythtv/photographs/ |</font></font></p>
<p><font face="Andale Mono"><font style="font-size: 9pt"
size="2">| 8 | Screenshots | MythBE2 |
/data3/mythtv/screenshots/ |</font></font></p>
<p><font face="Andale Mono"><font style="font-size: 9pt"
size="2">| 13 | Streaming | MythBE2 |
/data3/mythtv/streaming/ |</font></font></p>
<p><font face="Andale Mono"><font style="font-size: 9pt"
size="2">| 5 | Trailers | MythBE2 |
/data3/mythtv/trailers/ |</font></font></p>
<p><font face="Andale Mono"><font style="font-size: 9pt"
size="2">| 4 | Videos | MythBE2 |
/data3/mythtv/videos/ |</font></font></p>
<p><font face="Andale Mono"><font style="font-size: 9pt"
size="2">+----+-------------+----------+----------------------------+</font></font></p>
<p><font face="Andale Mono"><font style="font-size: 9pt"
size="2">13 rows in set (0.00 sec)</font></font></p>
<p><br>
</p>
<p><font face="Andale Mono"><font style="font-size: 9pt"
size="2">mysql> </font></font> </p>
<p><br>
</p>
</td>
</tr>
<tr>
<td style="border-top: none; border-bottom: 1px solid
#000000; border-left: 1px solid #000000; border-right:
1px solid #000000; padding-top: 0in; padding-bottom:
0.04in; padding-left: 0.04in; padding-right: 0.04in"
width="608" valign="top">
<p><br>
</p>
</td>
</tr>
<tr>
<td style="border-top: none; border-bottom: 1px solid
#000000; border-left: 1px solid #000000; border-right:
1px solid #000000; padding-top: 0in; padding-bottom:
0.04in; padding-left: 0.04in; padding-right: 0.04in"
width="608" valign="top">
<p>BE2 and BE3 record to only /*/recordings.</p>
<p><br>
</p>
<p>BE2 has three hard drives:</p>
<p> /dev/sda1 is /data2 WD WDC20EARS – old shows not
watched and to be discarded</p>
<p> /dev/sdb1 is root (/) WD WDC800BB</p>
<p> /dev/sdc1 is /data3 WD WD30EFRX - has MythTV’s
recordings</p>
<p><br>
</p>
<p><br>
</p>
<p>Samba is available on BE2 but not installed on BE3 –
if need will. </p>
<p><br>
</p>
<p>BE3 has one drive: root, MythTV, etc. </p>
<p> /dev/sda2 is root, and everything else.</p>
<p><br>
</p>
<p> </p>
</td>
</tr>
<tr>
<td style="border-top: none; border-bottom: 1px solid
#000000; border-left: 1px solid #000000; border-right:
1px solid #000000; padding-top: 0in; padding-bottom:
0.04in; padding-left: 0.04in; padding-right: 0.04in"
width="608" valign="top">
<p>Think I got all your questions answered. Thanks again
for all the help! </p>
<p>Barry </p>
</td>
</tr>
</tbody>
</table>
</dd>
</dl>
<p style="margin-bottom: 0in; line-height: 100%"><br>
</p>
<p style="margin-bottom: 0in; line-height: 100%"><br>
</p>
<p>
<style type="text/css">td p { margin-bottom: 0in; }pre.cjk { font-family: "Courier New", monospace; }p { margin-bottom: 0.1in; line-height: 115%; }a:link { }</style></p>
<p><br>
</p>
<p><br>
</p>
<p><br>
</p>
<p><br>
</p>
</body>
</html>