1. Dup directory to ".orig"
2. In Graphic Converter
   batch Auto-Level into the real subdirectory.
   batch scale with height of 9" into images subdirectory.
   batch scale with height of 1" into thumbnails subdirectory.

3. From command line in picture directory:
   zip 1974 * -i ./*.jpg
   ls *.jpg >~/pictures.txt
   /usr/local/mysql/bin/mysqlimport -r -c "pic_filename" -p pictures ~/pictures.txt

4. In Mysql
   #Create Roll (if needed)
   insert into rolls (roll_title) values ("74-76");
   select roll_id, roll_title from rolls order by roll_id desc limit 3;
   *Add Roll to Album (if new roll added)
   select album_id, album_title from albums order by album_id desc limit 3;
   insert into album_contents (album_id, roll_id) values (3,22);
   #Create Page
   insert into pages (page_title) values ("1952");select roll_id, roll_title from rolls order by roll_id desc limit 3;select page_id, page_title from pages order by page_id desc limit 3;
   #Add Pages to Roll_Contents
   insert into roll_contents (roll_id, page_id) values (17, 58);
   #Add Pictures to Page_Contents
   insert into page_contents (pic_id, page_id) select pic_id, '57' from pictures where pic_sort is NULL;
   #Update Pictures with Titles and Sort
   update pictures set pic_title = pic_filename where pic_title is NULL;
   update pictures set pic_title = left(pic_title,instr(pic_title,".JPG")-1) where pic_title like "%\.JPG";
   update pictures set pic_title = insert(pic_title,instr(pic_title,"_"),1," ") where pic_title like "%_%";
   update pictures set pic_sort = concat(substr(pic_title,12,2), substr(pic_title,2,5)) where pic_sort is NULL;
   #repeat previous line until 0 changes

--- update page using browser ---

5. Update Web Server
   cd ~/Sites/BillHusler.com/B*CD/Photos
   rsync -avz --delete * "pbg417s:/Volumes/Seagate280_2/WebSite/Photos/archive_bill/"

6. Transfer Database
   mysqldump --add-drop-database --add-drop-table --comments --create-options --databases --extended-insert --flush-logs --hex-blob --lock-tables --password --result-file=pictures_dump.sql pictures
   mysql -h www -p < pictures_dump.sql
   
Misc commands:
insert into albums (album_id, Album_title, album_sort) values(3,"Husler Family Archives",2);
insert into album_contents (album_id, roll_id) values (3,19);
http://www.billhusler.com/pictureindex.php?album_id=3&edit=1
select pictures.pic_id, pic_title, pic_filename from pictures left join page_contents on pictures.pic_id = page_contents.pic_id where page_id is NULL;