Friends Calendar User Info Update Journal Logon/Logoff PhonePost Managment
Manage Account Options Journal Hacking
Mathfred's photos

Wanna vacuum all of your SQLite databases? :D for I in $(file… - Avatar
?

Log in

Wanna vacuum all of your SQLite databases? :D for I in $(file… - Avatar

Lifesimoncion wrote
on August 29th, 2010 at 11:32 pm
Previous Entry Share Next Entry

Wanna vacuum all of your SQLite databases? :D

for I in $(file $(find / -path /some/protected/path -prune -o -type f -iname "*.db" -o -iname "*.sqlite*") | grep -e "SQLite " --color=never | awk '{ print $1 }' | sed -e 's/://'); do sqlite3 $I 'VACUUM;' || echo $I; done

(Leave a comment)
Blow Goats Everyday is
Powered by LiveJournal.com