Hide

What's this?

commandlinefu.com is the place to record those command-line gems that you return to again and again.

Delete that bloated snippets file you've been using and share your personal repository with the world. That way others can gain from your CLI wisdom and you from theirs too. All commands can be commented on, discussed and voted up or down.


Get involved!

You can sign-in using OpenID credentials, or register a traditional username and password.

First-time OpenID users will be automatically assigned a username which can be changed after signing in.

Universal configuration monitoring and system of record for IT.
Hide

Stay in the loop…

Follow the Tweets.

Every new command is wrapped in a tweet and posted to Twitter. Following the stream is a great way of staying abreast of the latest commands. For the more discerning, there are Twitter accounts for commands that get a minimum of 3 and 10 votes - that way only the great commands get tweeted.

» http://twitter.com/commandlinefu
» http://twitter.com/commandlinefu3
» http://twitter.com/commandlinefu10

Subscribe to the feeds.

Use your favourite RSS aggregator to stay in touch with the latest commands. There are feeds mirroring the 3 Twitter streams as well as for virtually every other subset (users, tags, functions,…):

Subscribe to the feed for:

Hide

News

May 19, 2015 - A Look At The New Commandlinefu
I've put together a short writeup on what kind of newness you can expect from the next iteration of clfu. Check it out here.
March 2, 2015 - New Management
I'm Jon, I'll be maintaining and improving clfu. Thanks to David for building such a great resource!
Hide

Top Tags

Hide

Functions

Psst. Open beta.

Wow, didn't really expect you to read this far down. The latest iteration of the site is in open beta. It's a gentle open beta-- not in prime-time just yet. It's being hosted over at UpGuard (link) and you are more than welcome to give it a shot. Couple things:

  • » The open beta is running a copy of the database that will not carry over to the final version. Don't post anything you don't mind losing.
  • » If you wish to use your user account, you will probably need to reset your password.
Your feedback is appreciated via the form on the beta page. Thanks! -Jon & CLFU Team

Convert all MySQL tables and fields to UTF8

Terminal - Convert all MySQL tables and fields to UTF8
mysql --database=dbname -B -N -e "SHOW TABLES" | awk '{print "ALTER TABLE", $1, "CONVERT TO CHARACTER SET utf8 COLLATE utf8_general_ci;"}' | mysql --database=dbname &
2009-03-21 18:45:15
User: root
Functions: awk
18
Convert all MySQL tables and fields to UTF8

This loops through all tables and changes their collations to UTF8. You should backup beforehand though in case some data is lost in the process.

Alternatives

There is 1 alternative - vote for the best!

Terminal - Alternatives

Know a better way?

If you can do better, submit your command here.

What others think

http://www.mysqlperformanceblog.com/2009/03/17/converting-character-sets/ read before you will mess up your database :P

Comment by sander85 408 weeks and 3 days ago

This really doesn't need to be backgrounded... leave off the trailing & if you want to keep track of what it's doing!

Comment by trisweb 201 weeks ago

Mentor bags available for sale have grown to be very popular while using increasing length of time as a result of wide variety in the solutions, the particular patterns and the dependable components. Now Instructor Bags publicize their very best merchandise to be on sales so you're able to very easily get the wanted bag within an affordable price. Trainer bags tend to be swiftly generating the position amid current market due to its female glance and trendy hint seems to be. Women of all ages right now like Trainer Bags a growing number of due to stylish patterns and ways in which comfy believe that your bag. Coach bags totally show the design and style and also tastes from the ladies sporting the bag.What folks declare with regards to Mentor Bags On discount sales?People nowadays take into account trainer bags discounted because economical high-class brand. Trainer known among the people for the charming models ideal for ladies of all the course every age. The increasing demand of Instructor Bags between persons has risen the job awareness amongst Coach Developers. Private coach bags have adequately possessed the particular individuals preference. Instructor bag has turned into a well-liked term for ladies when evaluating a traditional and fashionable hands bags on the net.The most up-to-date designs inside Trainer Bags In SaleIn order to fulfill the needs of men and women Mentor Bag creative designers are discovering a variety of trendy patterns every single day. Bleeker, Signature, Legacy of music, Peyton, Hamptons, Carly, Spot functions, Therefore, Addison, Madison, Leach and even more are the most up-to-date styles pointed out with the private coach bags. Within the most current designs of mentor bags you will discover variety of choices for every single event as well as your each design, that will work with your every room as well as simple to transport all-around.Reasons why Mentor Bags On discount sales are Well-known http://www.hermesbeltsbirkinkellybag.co.uk/ ?One of the reasons precisely why Mentor Bags usually are well-known could be because of his or her adjusted price. Not like some other brand name bags you needn't to cover hundreds and thousands involving dollars for any sole bag, in fact you can easily attain needed bag with every design you may need from it, within an affordable price. Inexpensive not simply with regard to celebrities and enterprise women of all ages but in addition college or university teenage manner freaks. Mentor bags are not only found with adjusted price it supplies high quality together with fashion. What exactly women favor nowadays are the palm bags which are resilient and many zipped to avoid their particular stuff coming from obtaining snarled. If you're a tough consumer and cannot pay out much attention towards prevention of your bag coming from scrapes then Mentor Bags on sale are the best selection for youCoach Bags With Sale

Comment by stephanieg915 2 days ago

http://www.canadagoosefemmehomme2016.fr/canada-goose-printemps-haussmann_323.html

http://www.canadagoosefemmehomme2016.fr/blouson-canada-goose-pas-cher_78.html

http://www.canadagoosefemmehomme2016.fr/veste-canada-goose-pas-cher_200.html

http://www.canadagoosefemmehomme2016.fr/canada-goose-victoria_293.html

http://www.canadagoosefemmehomme2016.fr/solaris-parka-canada-goose_110.html

http://www.canadagoosefemmehomme2016.fr/canada-goose-chilliwack-enfant_431.html

http://www.canadagoosefemmehomme2016.fr/chateau-parka-canada-goose_225.html

http://www.canadagoosefemmehomme2016.fr/doudoune-canadian-goose_205.html

http://www.canadagoosefemmehomme2016.fr/canada-goose-femme-trillium_201.html

http://www.canadagoosefemmehomme2016.fr/blouson-aviateur-canada-goose_299.html

http://www.canadagoosefemmehomme2016.fr/doudoune-canada-goose-pas-cher_192.html

http://www.canadagoosefemmehomme2016.fr/canada-goose-montreal_267.html

http://www.canadagoosefemmehomme2016.fr/manteau-canada-goose-femme-pas-cher_472.html

http://www.canadagoosefemmehomme2016.fr/canada-goose-prix-canada_277.html

http://www.canadagoosefemmehomme2016.fr/canada-goose-bleu-electrique_187.html

http://www.canadagoosefemmehomme2016.fr/doudoune-canada-goose-montebello-femme_128.html

http://www.canadagoosefemmehomme2016.fr/canada-goose-pas-cher_455.html

http://www.canadagoosefemmehomme2016.fr/canada-goose-chilliwack_393.html

http://www.canadagoosefemmehomme2016.fr/canada-goose-violette_121.html

http://www.canadagoosefemmehomme2016.fr/borden-canada-goose_442.html

http://www.canadagoosefemmehomme2016.fr/canada-goose-chilliwack-bomber-pas-cher_465.html

http://www.canadagoosefemmehomme2016.fr/entrepot-canada-goose_158.html

http://www.canadagoosefemmehomme2016.fr/parka-canada-goose-prix_395.html

http://www.canadagoosefemmehomme2016.fr/canada-goose-boutique-en-ligne_184.html

http://www.canadagoosefemmehomme2016.fr/parka-canada-goose-homme_376.html

Comment by sguerra376 14 hours ago

http://www.canadagoosefemmehomme2016.fr/canada-goose-prix-canada_277.html

http://www.canadagoosefemmehomme2016.fr/forum-canada-goose_60.html

http://www.canadagoosefemmehomme2016.fr/canada-goose-chilliwak_109.html

http://www.canadagoosefemmehomme2016.fr/site-canada-goose_352.html

http://www.canadagoosefemmehomme2016.fr/canada-goose-accessoires_183.html

http://www.canadagoosefemmehomme2016.fr/marque-doudoune-canada-goose_74.html

http://www.canadagoosefemmehomme2016.fr/canada-goose-tuque_58.html

http://www.canadagoosefemmehomme2016.fr/femmes-canada-goose_281.html

http://www.canadagoosefemmehomme2016.fr/goose-canada-femme_476.html

http://www.canadagoosefemmehomme2016.fr/prix-d-une-canada-goose-au-canada_175.html

http://www.canadagoosefemmehomme2016.fr/canada-goose-victoria-pas-cher_211.html

http://www.canadagoosefemmehomme2016.fr/blouson-canada-goose_156.html

http://www.canadagoosefemmehomme2016.fr/doudoune-canada-goose-enfant_83.html

http://www.canadagoosefemmehomme2016.fr/canada-goose-pas-cher_455.html

http://www.canadagoosefemmehomme2016.fr/ontario-canada-goose_96.html

http://www.canadagoosefemmehomme2016.fr/canada-goose-le-bon-march��_461.html

http://www.canadagoosefemmehomme2016.fr/veste-canada-goose-pas-cher_200.html

http://www.canadagoosefemmehomme2016.fr/canada-goose-blouson-aviateur-chilliwack-homme_321.html

http://www.canadagoosefemmehomme2016.fr/canada-goose-doudoune-sans-manche_166.html

http://www.canadagoosefemmehomme2016.fr/canada-goose-huron-bomber_437.html

http://www.canadagoosefemmehomme2016.fr/parajumpers-ou-canada-goose_87.html

http://www.canadagoosefemmehomme2016.fr/canada-goose-suisse_41.html

http://www.canadagoosefemmehomme2016.fr/parka-canada-goose-homme_376.html

Comment by sguerra376 8 hours ago

Your point of view

You must be signed in to comment.