How to batch change Default Path of photos?

[seanspeng]

I have a gallery of 200 photos. I was able to change the thumb and microthumb from Edit Exhibition page, but I did not find a quick way to change all the Default Path for the photos' BIG and Medium size. Is there any way to achieve this other than go to Photo Editor and do it one by one?

Thanks!

[wkitty42]

i don't have the needed stuffs handy but you could do it with a sql update in phpmyadmin... hopefully someone will have the proper incantation to work the majik ;)

my initial thought, though, was to just set the path in one of the editors and that it would take for all (ie: shared database path field) but then i remembered that each photo carries its own copy...

another alternative would be to make a backup and then run a search and replace in an editor and then do a restore... this would be similar to moving to another server... as i recall, davidW (if i got the right one) also posted a message about maintaining a duplicate database on a seperate server... that message should also contain enough info to assist you... well, if you're one of us who gets "into" their setups, that is ;)

hopefully this has helped even though i didn't serve it to you directly 8)

[seanspeng]

Thanks wkitty for explaining it to me. I found davidw's post, and it did not have the details:

http://photography-on-the.net/forum/showthread.php?t=233217

I wish I knew the sql command to make the batch update.

[wkitty42]

not that thread... try this one, instead...
http://photography-on-the.net/forum/showthread.php?t=227701