When I go into mysql and do a select count(*) where dateline > (unix_timestamp(current_timestamp)-30*24*3600) I get approx. 125,000 records. When I do a mysqldump -q -f -e dbname tablename -w 'dateline > (unix_timestamp(current_timestamp)-30*24*3600)' > dump.sql I get approx 95,000 records. It does this for other time frames too (1 week/2 weeks)... I'm guessing it's getting stuck on some post with funky characters/quotes and is dying on that - but I don't see any indication of errors with verbose mode on. (Other than the most obvious indication of error - that being a bunch of posts missing from dump.sql) Running mysql/mysqldump 5.0.24a I don't know what else to try at this point - any ideas?