mysqldump: dump rows matching certain criteria, or limit number of dumped rows
Posted: 23 September 2011 Filed under: development | Tags: command line, mysql, mysqldump, web development Leave a commentTo limit the number of rows dumped by mysqldump
, you can do:
mysqldump -u [user] -p[password] --where="true LIMIT 5" [database] [tablename] > outputfilename.sql
You could select other criteria as well:
mysqldump -u [user] -p[password] --where="userid > 24" [database] [tablename] > outputfilename.sql
Removing wine menu entries and file associations on Ubuntu
Posted: 20 September 2011 Filed under: Uncategorized 1 CommentFrom the Wine FAQ, this works for me on Ubuntu Lucid, using Wine 1.2.2:
rm -f $HOME/.config/menus/applications-merged/wine*
rm -rf $HOME/.local/share/applications/wine
rm -f $HOME/.local/share/desktop-directories/wine*
rm -f $HOME/.local/share/icons/????_*.{xpm,png}
rm -f $HOME/.local/share/icons/*-x-wine-*.{xpm,png}
And the file associations:
rm -f $HOME/local/share/applications/wine-extension-*
Finally, if you’d like to remove installed Wine applications entirely for a single user, say, yourself:
rm -rf $HOME/.wine