<html>
<head>
<meta http-equiv="Content-Type" content="text/html; charset=UTF-8">
</head>
<body text="#000000" bgcolor="#FFFFFF">
<p> </p>
<p style="margin-bottom: 0in; line-height: 100%"><br>
</p>
<p style="margin-bottom: 0in; line-height: 100%">Hi Stephen!</p>
<pre class="western"><font face="moz-fixed"><font style="font-size: 9pt" size="2">OK, that looks like I have all the information I need. BE2 has 2.5 Tbytes of recordings that you want moved to BE3. There is only one recording partition each on BE2 and BE3. So the setup is quite simple.</font></font>
</pre>
<dl>
<dd>
<table width="627" cellspacing="0" cellpadding="4">
<colgroup><col width="617"> </colgroup><tbody>
<tr>
<td style="border: 1px solid #000000; padding: 0.04in"
width="617" valign="top">
<p><font face="moz-fixed"><font style="font-size: 9pt"
size="2">Good! You’re doing a lot of work for me
which I greatly appreciate and would feel guilty
if gets too complicated.</font></font></p>
</td>
</tr>
</tbody>
</table>
</dd>
</dl>
<pre class="western">
<font face="moz-fixed"><font style="font-size: 9pt" size="2"><span lang="en-US">I can now write a version of mythexport that will create a .sql file with all the data for each of the recordings on BE3 and store it in the same directory as the recording files. Then we need to get that directory copied or moved to BE3 and run mythimport from it on BE3. My plan is to have the special mythexport version run in the recording directory on BE2, and it will simply take a list of all the recording files in that directory (*.mpg, *.ts and *.nuv) and for each of those files, it will run mysqldump with the right commands to export all the</span></font></font>
<font face="moz-fixed"><font style="font-size: 9pt" size="2"><span lang="en-US">database entries matching that recording (from these tables: recorded, recordedseek, recordedrating, recordedprogram, recordedmarkup and recordedcredits). </span></font></font>
</pre>
<dl>
<dd>
<table width="628" cellspacing="0" cellpadding="4">
<colgroup><col width="618"> </colgroup><tbody>
<tr>
<td style="border: 1px solid #000000; padding: 0.04in"
width="618" valign="top">
<p><font face="moz-fixed"><font style="font-size: 9pt"
size="2">Probably does not make any difference but
I only have *.ts recordings in (BE2’s)
/data3/mythtv/recordings., along with the
associated *.png files. </font></font> </p>
</td>
</tr>
</tbody>
</table>
</dd>
</dl>
<pre class="western">
<font face="moz-fixed"><font style="font-size: 9pt" size="2"><span lang="en-US">The only thing really left to decide is that 2.5 Tbytes will take a very long time to move to a new drive, either directly between drives or over Ethernet. The easiest way to get all those recordings onto BE3 is simply to take that drive out of BE2 and install it on BE3, then import the data for the recordings into BE3's database. The files are never moved, and BE3 then has a lot more space for future recordings.</span></font></font></pre>
<dl>
<dd>
<table width="628" cellspacing="0" cellpadding="4">
<colgroup><col width="618"> </colgroup><tbody>
<tr>
<td style="border: 1px solid #000000; padding: 0.04in"
width="618" valign="top">
<p><font face="moz-fixed"><font style="font-size: 9pt"
size="2">Agree would be a lot faster using SATA (6
Gbps?) but I have a mechanical issue swapping hard
drives and would need to remove the motherboard.
Will just have to transfer via the network and be
patient.</font></font></p>
</td>
</tr>
</tbody>
</table>
</dd>
</dl>
<pre class="western">
<font face="moz-fixed"><font style="font-size: 9pt" size="2"><span lang="en-US">If you want to keep using BE2 to record, then the recording files will need to be copied or moved to BE3's drive, which has enough space for them all plus what is already there. Given how much data there is to</span></font></font>
<font face="moz-fixed"><font style="font-size: 9pt" size="2"><span lang="en-US">be moved, it is going to take a day or more. So you will likely want to have BE3 (and maybe also BE2) doing recordings at the same time. That is a bit more complicated, but I do have code that can detect when the next recording time is going to be, and stop a copy or move that is in progress before that time. So it should be possible to expand that code a bit so that it will check both BE2 and BE3 for the next recording time and will stop if either of them need to record. </span></font></font></pre>
<dl>
<dd>
<table width="628" cellspacing="0" cellpadding="4">
<colgroup><col width="618"> </colgroup><tbody>
<tr>
<td style="border: 1px solid #000000; padding: 0.04in"
width="618" valign="top">
<p><font face="moz-fixed"><font style="font-size: 9pt"
size="2">You are one smart cookie y’know! :) </font></font>
</p>
<p><br>
</p>
<p><font face="moz-fixed"><font style="font-size: 9pt"
size="2">Probably already considered and accounted
for but will ask anyway. What happens if there is
a power failure? Both BE2 and BE3 and the network
hardware between are on UPSs so a short term
outage is resolved here, just considering the one
the middle of last month where didn’t have power
for 2½ hours. Very rare situation, but always a
possibility.</font></font></p>
</td>
</tr>
</tbody>
</table>
</dd>
</dl>
<pre class="western"><font face="moz-fixed"><font style="font-size: 9pt" size="2"><span lang="en-US">All of the recording files on BE2 that were being moved would be put in a special new directory that was in a new storage group on BE2, not "Default". That prevents new BE2 recordings from being put into that directory, and would allow the copy/move software to work without having to handle the problem of new files appearing. The copying or moving would use a network connection to copy or move the BE2 files to BE3, and as it completed the copy or move of a file, it would move that recording out of the current BE2 directory to yet another one that you would create that was also in BE2's new storage group, where BE2 could see it but the copy/move program would not see it any more.</span></font></font>
</pre>
<dl>
<dd>
<table width="628" cellspacing="0" cellpadding="4">
<colgroup><col width="618"> </colgroup><tbody>
<tr>
<td style="border: 1px solid #000000; padding: 0.04in"
width="618" valign="top">
<p><font face="moz-fixed"><font style="font-size: 9pt"
size="2">Wow! :) I almost have the feeling my
power failure question is resolved by that.</font></font></p>
<p><br>
</p>
<p><font face="moz-fixed"><font style="font-size: 9pt"
size="2">Thanks for all the work you’ve put into
this!</font></font></p>
<p><font face="moz-fixed"><font style="font-size: 9pt"
size="2">Barry </font></font> </p>
</td>
</tr>
</tbody>
</table>
</dd>
</dl>
<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>
</body>
</html>