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

Get a MySQL DB dump from a remote machine

Terminal - Get a MySQL DB dump from a remote machine
ssh [email protected] "mysqldump -h localhost -u mysqluser -pP@$$W3rD databasename | gzip -cf" | gunzip -c > database.sql
2009-10-05 00:57:51
User: daws
Functions: gunzip ssh
8
Get a MySQL DB dump from a remote machine

This command will dump a database on a remote stream to stdout, compress it, stream it to your local machine, decompress it and put it into a file called database.sql.You could even pipe it into mysql on your local machine to restore it immediately. I had to use this recently because the server I needed a backup from didn't have enough disk space.

Alternatives

There are 9 alternatives - vote for the best!

Terminal - Alternatives

Know a better way?

If you can do better, submit your command here.

What others think

where does the files save to?

Comment by all4artz 369 weeks and 2 days ago

or is there a way to save it to my local system?

Comment by all4artz 369 weeks and 2 days ago

It goes to the database.sql file in your current directory.

Comment by daws 369 weeks and 2 days ago

Kids comfort while sleeping is an important element for longer and sleeping, which results in healthy increase in babies. The slumbering bag would make ideal bedsheets on your newborn and removes the potential risks involving unfastened home bedding, which can result in Sudden infant death syndrome. The supplies employed for producing these kind of slumbering bags have utmost value since they require the appropriate attributes appropriate for the infant's good health. There needs to be proper air circulation during cozy days and cosy comfort during freezing weathers. Materials of which soak up sweating outside the skin color in addition to lets out for the oxygen create minimal moisture between the epidermis and also the textile. Mesh products having wonderful humidity management stop little ones through waking up sensation clammy and also hot.Natural fibers can be a good selection compared to manufactured fibers for the newborn sleeping bag. Components just like organic cotton and merino fleece protector usually are not hazardous for the child and still provide the mandatory ease and comfort to have an undisturbed slumber. Organic muscles lower health problems and therefore are health-friendly, specifically toddlers. Just about the most successful fabric that makes an excellent infant getting to sleep bag can be merino fleece protector. Merino fleece protector is a fantastic all-natural dietary fibre obtained from merino sheep within the lavish mountain tops of latest Zealand. Nz provides the very http://www.hermesbeltsbirkinkellybag.co.uk/ best merino lamb to create the very best merino outfits. Merino made of woll is tremendously accomplished at soaking up the actual dampness and also taking it outside the pores and skin for more quickly evaporation. That varieties a new micro-climate involving the body along with the content to reply to alterations in the earth. Merino retains your little one trendy in scorching weather and cozy in chilly weathers.Your newborns vulnerable epidermis will never be prone to skin conditions using merino wool as the materials are soft comfortable, natural and mesh. Merino fleece protector even offers an elastic nature that holds toddler movements in the resting bag. It really is odour-resistant and has pure fire retardants. Over sleeping a new merino little one resting bag will certainly increase your little one's rest regime and so, your own personal. The content will be resilient, bio degradable and to care for. It will be the ideal material for swaddling the baby in addition to shown to be good at the actual speedy wholesome acquire involving pounds throughout quick along with under a healthy weight children. A new merino little one slumbering bag gets rid of your issues associated with bed sheets and covers a newborn safe, wholesome and comfy while sleeping.

Comment by stephanieg915 18 hours ago

Companies use a positive luck on the advancement of their goods. The standard chosen conclusion is definitely appropriation of handouts, identifications, brochures and so forth within an entrance maybe in shopping centers. On the other hand a substantial aspect of the situations they are found out in the dustbin or just lying on the floor following the celebration has finished. This kind of unmistakably signifies that it's ineffectual advertising and marketing, accident of money, a serious amounts of http://www.hermesbeltsbirkinkellybag.co.uk/ resources. Instead of experiencing this wither up, supporters could make by using limited time Back packs that's indicating satisfactory. They may be available in participating describes and therefore are referred to as a competent devices pertaining to marketing as well as growth of marks. Backpacks are usually massively participating and in stylish. Folks are more probable to convey these to much better areas. Therefore your logo are going to be revealed all over the shopper moves. Most of these bags might be more costly than the others but the shopper will keep that having him for the amazing long time. Your handbag bag special ultimately ends up being exceptionally appropriate because they expedite the actual archiving books, attire and other factors. Numerous instructional companies suitable School bags for their historians with all the groundwork logo design imprinted for the back. Coupled creases that they promote their particular tag broadly. Promotional chilly is a different course for agencies to market his or her business. They are the kind of particular things that customers will assume experience journeys or maybe interpersonal occasions. There are lots of works on which usually has to be considered underneath contemplations prior to choosing the type of Company logo colder. Provided that your particular goal shopper is actually regarding freshman age group, that will get vital to include a fashion section it. Distinct chilling bags may very well be useful for this age collecting. Though given that you intend to provide these products to senior individuals after that hinder involving chillier bag may well be more acceptable simply because it provides increased manages that give more powerful hold along with makes it less strenuous to tug the actual promo merchandise almost everywhere. Sex can be a various important aspect to always be known when using the this specific. You are able to decide on much cooler bags together with calfskin match with regard to young women. Whilst males, cooler bags with seats will be a better choice. This will likely guarantee relevance. The final yet one particular important standpoint to become handled will be the setting of chilly bag. Tweaked colder is due possibly be notable while they allow unique magnetic examples. By simply composing infectious expression and signing up for the crooks to your tag name may undeniably grow your recognize power with the object. Cooler bags offer a excellent created as well as heavy protecting. They will maintain factors on the inside safely and securely. The ice Three-dimensional sq usually stays inside very same structure in spite of the risk that the temperatures about is definitely substantial. People bring it about to help trip spots. That steps the plausibility involving symbol label receiving factor also crosswise over geologies.

Comment by stephanieg915 16 hours ago

Your point of view

You must be signed in to comment.