mysqldump: dump rows matching certain criteria, or limit number of dumped rows

To 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

Advertisements

Removing wine menu entries and file associations on Ubuntu

From 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