nix, shell, perl, php, mysql and mac os x tips and tricks

Monday, September 24, 2007

Mirror an entire site, dynamic or not, using wget

wget --wait=20 --limit-rate=20K -m -k -E -U 'Mozilla/5.0 (Windows; U; Windows NT 5.1) Gecko/20041001' http://www.site.com/

Monday, September 10, 2007

Update column in a table whose values are NOT found in another table

UPDATE products_staging LEFT JOIN published ON products_staging.SKUID=published.skuid SET products_staging.PUBLISH = '0' WHERE published.skuid IS NULL