2010-03-18, 09:49 PM
Babbage Wrote:Why not use a little SQL magic to change where the database thinks the files are:
Code:UPDATE RECORDING_SCHEDULE SET filename = REPLACE(filename, "E:\MyPVR", "D:\My Recordings") WHERE filename LIKE "E:\MyPVR%";
Run that once, and everything should be updated (I would perform this first on a copy of my db to make sure everything was changed correctly).
Thanks, but the files are already moved over but I will remember it for the next time

[SIZE="1"]LianLi V600, Intel DG965WH, 4Gb, Core2Quad Q6600, 5x 1TB, 3x 500GB raid1, 3x TechnoTrend C-1501 dvb-c, 2x PCH A-100/A-110, WHS, NPVR, DVBLink
LianLi PC-V351, Intel DG45ID, 4Gb, Core2Duo E8400, 1x 1TB + 2x 500GB, TT C-1501 dvb-c, Win7 Ultimate, W2K8R2 Server, WHS2 Vail, XP Pro, Mandriva Linux
Laptops: Acer 1810TZ, Acer 5235, Dell D610, Win7, Mandriva Linux, Hackintosh
Fritz!Box 7270 WLAN-N/Dect modem/router, Netgear GS116 Gbit switch, Linksys 5 ports Gbit switch[/SIZE]
LianLi PC-V351, Intel DG45ID, 4Gb, Core2Duo E8400, 1x 1TB + 2x 500GB, TT C-1501 dvb-c, Win7 Ultimate, W2K8R2 Server, WHS2 Vail, XP Pro, Mandriva Linux
Laptops: Acer 1810TZ, Acer 5235, Dell D610, Win7, Mandriva Linux, Hackintosh
Fritz!Box 7270 WLAN-N/Dect modem/router, Netgear GS116 Gbit switch, Linksys 5 ports Gbit switch[/SIZE]