Apparently re-creating the partition worked and now I can see the once-missing PV. However, upon getting the previously missing PV back my formerly established-to-be-OK PV disappeared. Weirdness, the LVM (type 8e) partition is still there but an lvmdiskscan returns the newly fixed partition as a PV but not the one that was working from the start.
Once I get the VG up, or give up and start over, I'll be able to move on the DB issue.
Thanks again,
Cory
On 11/3/05, Cory Zerwas <[EMAIL PROTECTED]> wrote:
On 11/3/05, Stuart Auchterlonie <[EMAIL PROTECTED] > wrote:On Wed, Nov 02, 2005 at 03:32:08PM -0600, Cory Zerwas wrote:
> ...Is there an easy way to purge the
> currently recorded programs out of the DB so I just have the core MythTV
> config, schedules, and recording groups/priorities?
Well the main tables relating to recorded programs are
anything starting with recorded (recorded, recordedcredits, recordedmarkup,
recordedprogram, recordedrating). You could manually delete the records
from those tables with a bit of sql.
First, thanks for the reply Stuart.
I'm not a big SQL guy, at least not mySQL, but I will start reading up and see what I can manage to accomplish. Of course, I'll be sure to keep a backup handy in the likely event I kill the DB in some bad way.
> Also, if anyone has recovered an LVM 2 member disk's partition table I would
> appreciate hearing about that as well.
You can create a partition table which matches what was there before
(easy with a single partition on the whole disk) then cross your
fingers and hope that the data is there. But if you get it wrong
your data is dead.
Good idea, I was guessing I could give this a shot. The reason I haven't done so yet is the same reason you mentioned; risk. The drive was just a single partition so I guess I just have to create a compatible table for LVM 2. I haven't researched any yet in this regard, so there's some more work for me to do this weekend or next week. (Took next week off work, yay!)
What's so puzzling is why the partition table vanished, since I didn't elect to do anything with those disks. I even had them unplugged during the upgrade to prevent such a problem from occurring. This leads me to wonder if there was a problem occurring just before the upgrade that I hadn't noticed...
So, in all some good information and it points to some weak areas of knowledge for me. Thank you very much, I'm off to do a bit of related reading. If anyone else has a tip, please drop me a message.
-Cory
_______________________________________________ mythtv-users mailing list mythtv-users@mythtv.org http://mythtv.org/cgi-bin/mailman/listinfo/mythtv-users
