[ome-users] Partial Replication of OMERO data for TEST system: how to obtain user specific Pixels data as well?

[Rainer Poehlmann]

Hi Josh,

thanks a lot for your reply, it is making things much clearer.

> The pyramid files can be found with `find /OMERO/Pixels -name "*_pyramid"`

May I then ask what all the other files within "Pixels" not named "*_pyramid" are?

Example:
(...)
-rw-rw-r-- 1 omeronas omeronas   14209619 Oct 18  2013 39851_pyramid
-rw-rw-r-- 1 omeronas omeronas   14343669 Oct 18  2013 39858_pyramid
-rw-rw-r-- 1 omeronas omeronas   14205337 Oct 18  2013 39870_pyramid
-rwxrwx--- 1 omeronas omeronas    2160000 Oct 18  2013 39922
-rwxrwx--- 1 omeronas omeronas    2160000 Oct 18  2013 39923
-rwxrwx--- 1 omeronas omeronas    2160000 Oct 18  2013 39924
(...)

> In order to limit by user, you'd have to cross-check the pixel IDs in
> the DB. Happy to help with this if you'd like.

If possible, I would appreciate getting kind of an SQL example I could use to identify the required pyramid files for a 
specific user.

Thanks & cheers,
-Rainer