Josh, Thanks! That is exactly what I was looking for. I'll give it a try and let you know how it works out.
-Bill -----Original Message----- From: Josh Thompson [mailto:[email protected]] Sent: Monday, June 27, 2016 4:00 PM To: [email protected] Subject: Re: transferring vcl images to another vcl system -----BEGIN PGP SIGNED MESSAGE----- Hash: SHA1 William, To import the images, you'll need to do some database work. The following instructions assume you haven't already created any images in the new system. You'll encounter some problems with the image.id and imagerevision.id if you have already created some images (these are embedded in the actual image disk files). Backup the new system's database before doing this. 1) dump these tables from the old system: image, imagemeta, imagerevision 2) import those dumps into the new system (you'll probably need to delete the noimage entry either from the new system or from the dumps so that you don't get a conflict) 3) on the VCL site, create an image group you will put all of them in (I'll call it "Imported Images") 4) create records in the resource table: INSERT INTO resource (resourcetypeid, subid) SELECT 13, id FROM image; 5) add all of them to the image group: INSERT INTO resourcegroupmemebers (resourceid, resourcegroupid) SELECT resource.id, resourcegroup.id FROM resource, resourcegroup WHERE resource.resourcetypeid = 13 AND resource.subid != (SELECT id FROM image WHERE name = 'noimage') AND resourcegroup.name = 'Imported Images' AND resourcegroup.resourcetypeid = 13 6) You should now see all of the images on the VCL site (possibly after logging out/back in), assuming your use account has access to the image group created in #3 Let us know how it works out for you. Josh On Monday, June 27, 2016 1:51:41 PM Doran, William wrote: > Hello, > I currently admin a running/working VCL installation using v2.3.2, and am > working on bringing up a completely new installation using the latest > stable release. Is there an easy way to transfer the existing VCL images > from the running/working 2.3.2 installation to the new installation? Any > pointers on where to start with this would be greatly appreciated! > > Thanks in advance! - -- - ------------------------------- Josh Thompson VCL Developer North Carolina State University my GPG/PGP key can be found at pgp.mit.edu All electronic mail messages in connection with State business which are sent to or received by this account are subject to the NC Public Records Law and may be disclosed to third parties. -----BEGIN PGP SIGNATURE----- Version: GnuPG v2 iEYEARECAAYFAldxhd0ACgkQV/LQcNdtPQOzMwCfUiseBymZz9g0ObsixoI3K4J7 HdcAnA6Yas9He2KCauiR164pcBJ/VF0z =crfb -----END PGP SIGNATURE-----
