Creating a MySQL dump file of your database can be fairly straightforward, but, if you aren't careful, you could corrupt the character set in your backup file.
I used to created a database dump using a command like the following:
mysqldump -u nathan -p database1 > database1.backup.sql
The above command is very straightforward in that it generates a dump file using default options and redirects the output to a file instead of to standard output.
However, I want all my data to maintain a UTF-8 character set. To do this I need to use 2 options:
- --default-character-set=utf8: This insures UTF8 is used for each field
- --result-file=file.sql: This option prevents the dump data from passing the through the Operating System which likely does not use UTF8. Instead it passes the dump data directly to the file specified.
Using these new options your dump command would look something like this:
mysqldump -u nathan -p --default-character-set=utf8 --result-file=database1.backup.sql database1
If you are like me and are constantly creating MySQL dumps, you might want to consider creating a simple shell script like the one I use below.
#!/bin/bash db_user="root" db_pass="password" mysqldump -u $db_user -p $db_pass --single-transaction --default-character-set=utf8 --result-file=$1.$(date -I).sql $1
The script just takes a single argument, the database name, and generates a datestamped dump file of it in the current directory.
Comments
saved my day
thanks!
Air Jordan
Jordan lorsque michael jordan intégra le monde de la nba en 1984, ce ne fut pas seulement le début d'une carrière sans égal, mais aussi
le début de la série célèbre "Air Jordan" de nike. le fabricant d'articles de sport accorda toute
une série de chaussures et d'habits au basketteur doté apparemment de talents surhumain. cette série fit tout de suite sensation : l' Air Jordan 1 fut interdite par la nba puisque la combinaison des coloris noir/rouge ne
correspondit pas au "code vestimentaire" de la nba à l'époque. pourtant, cela ne put empêcher le succès mondial de cette sneaker unique.
au contraire : la chaussure de basket déclencha une véritable hystérie et est, dès lors, lancée dans une nouvelle édition chaque
année.jordan - plus qu'une simple chaussure de basket les spots publicitaires de jordan sont aussi innovateurs que les produits eux-
mêmes. au cours des années 80, avec spike lee alias mars blackmon, ils conquirent les écrans de la télé. aujourd'hui, les spots pour les
différents modèles d'air jordan sont toujours de vrais classiques sur youtube. de nos jurs, le jumpman ne se porte pas seulement sur les
chaussures : Air Jordan 3, Air Jordan
4, Air Jordan 5, Air Jordan 6,
Air Jordan 7, Air Jordan Spizike.
ils se distinguent par le design typique de la marque et convainquent par une excellente qualité et des matières hut de gamme. en 1997,
nike externalisa même la série de jordan : aujourd'hui, la marque de jordan développe ses propres produits, mais coopère néanmoins
étroitement avec nike. des joueurs comme carmelo anthony ou dwyane wade portent le jumpman dans la nba. ainsi, michael jordan reste
présent dans la meilleure ligue de basket-ball du monde. Obtenez les dernières Air
Jordan 2012 Chaussures avec style avant-gardiste et la technologie. Obtenez les dernières Chaussures Air Jordan avec style avant-
gardiste et la technologie. Boutique 100% authentique Nike Air Jordan à partir des collections les
plus emblématiques. Air Jordan Retro, Fusion, Hommes, Femmes et Enfants Chaussures.
Isabel Marant Shoes
Isabel Marant Shoes Isabel Marant Sneakers Isabel Marant Boots Isabel Marant Heels ay Ban Aviator Ray Ban Wayfarer Ray Ban Active Lifestyle Ray Ban 3025 Ray Ban 2140 Ray Ban 2132
Marc Jacobs Handbags
If the Marc Jacobs bags cup is actually damaged, additionally, it results in being waste materials.Nobodt really wants to make use of a Marc Jacobs Purses broken eye-port or even consume having a destroyed galss or even put on a set of damaged Marc Jacobs Handbags glasses.The moment it's damaged, this gets waste materials, The actual price associated with utilizing Marc By Marc Jacobs Dress plastic materials is actually growing day time by day time.Individuals apply plastic material bags since they're convvenitent.Marc By Marc Jacobs Bags Once the go back home, these people toss the actual pouches method, having to pay absolutely no focus on Marc By Marc Jacobs Classic Q Francesca Black the actual ecologically.The greater usefulness plastic materials provide in order to all of us, the greater Marc by Marc Jacobs Framed Shoulder Bag Stone plastic material waste materials is actually created.This really is known as whitened co2 because almost all plastic materials tend to be whitened.A number of Marc By Marc Jacobs Ozzie Squares Brigette M303126 Wild Mushroom the items all of us make use of each day time come from rubberized, similar to the MARC BY MARC JACOBS Pretty Nylon Elizababy Bag Blue Multi tyres and also the bottom level of the footwear.It is accurate which rubberized performs a good vital part within our existence.Nevertheless, this Marc By Marc Jacobs Totally Turnlock Flap Clutch M302495 Forest Green additionally provide all of us a few problem whenever it's been utilized for a long period as well as gets aged.The actual aged tyres turn out to be waste materials since it cannot break up by character.
Coach Outlet is designed so
Coach Outlet is designed so elegance and it is cheap sale Coach Outlet Online. The handbags are one of the most popular designer handbags on the Coach Outlet Online today. Coach Colette Handbags which is one of the classic styles of Coach Outlet. Colorful appearance and beauty accessories are the point of Coach Purses Outlet. These Coach Colette Bags are must-have from this classic Coach family. The traditional stylish Cheap Coach Handbags with gorgeously and luxuriously dotted coach print appearance, updates an Coach Factory extremely clean and extremely modern day time style research to accomplish Coach Outlet Online a alluring stylish coach bags. Every professional woman needs a good handbags. No matter what your industry or position. Colorful appearance and beauty accessories are the point of Coach Colette Bags.Every professional woman needs a good handbags. No matter what your industry or position, a Coach Factory Outlet is essential for anyone to be taken seriously at the condition. Welcome to our website and we will provide the best Coach Colette Handbags and best service for dear customers.
Goyard Handbags
People offer Goyard Handbags, most of some of our Goyard Bags on sale are typically in top quality level, it is possible to comfortable to know other individuals what you may order are definitely the perfect.Goyard St Louis an extremely magnificence! that i was initially also debating in it lake observed that this rates more or less $900 merchandise online i recently found released it all comes along with the bit of backpack which means that i will be purchased! Right now, often times there are waste tips with regards to the excellent goyard tote clients regarding goyard-bags.org.You could select people that you're intrigued.Get goyard wallet with a broad assortment for on line store.
Longchamp outlet
longchamp bags, girls and elegance are two sides Longchamp 2012 of meat of the similar coin. It truly is tough to discover a lady who doesn't desire to be beautiful and fashionable. Longchamp outlet Make a trend argument with branded accessories like Bags, clutches and jewelry. Designer accessories are a ought to in the woman's closet because sacs longchamp pas cher of its merchandise calibre and design. Possessing branded Handbags peculiarly the planet renowned longchamp Handbags portray your fantastic taste. It really is an unavoidable accessory during the closet of many Hollywood stars and renowns.
Ladies and Handbags For centuries longchamp Longchamp sale bags sale are actually an in-chief aspect of a woman's existence. This can be generally because females are recognized as caregivers with the world and sacs longchamp pas cher really like to organize everything. Bags serve them within a variety of strategies to attain this purpose. This longchamp outlet online necessity above a time period has become a sac main Longchamp fashion instrument. You longchamp bags can find many popular brand names within the market which not merely support in Longchamp Bags 2012 organizing your day but also aid in exhibiting your traits. Handbags is got it on for its pure luxury and fabulous sac main craftsmanship. It can be generally stated that in order to Longchamp Bags 2011 sac major Longchamp impress your lady really like make her really feel extraordinary with luxurious Longchamp Limited Edition sac Bags. Producing a Style affirmation Handbags originate from Paris which can be a single Longchamp Travel Bag of the trend deliberate cities of the Longchamp le pliage globe. Some of the Longchamp Backpack Bags well-known handbag styles of it had been Longchamp Leather Handbag co-designed by Longchamp Purses illustrious Hollywood actress and celebrities.
The legendary Birkin Longchamp Gatsby Handbag bag was co-designed sacs by actress Jane Birkin. The Kelly bag which is named right Longchamp Totes Bags after actress Grace Kelly can also be a single in the legendary collections Longchamp Luggage Bags of longchamp Bags.longchamp gives bags for day and evening functions Longchamp Briefcase Bags all produced of large tweedy leather. A few of the extremely better-better-known outlet for your day are clou de selle, double sens, Victoria etc. In addition they Longchamp Cosmetic Bag supply clutches for evening parties and factions. Girls spent a substantial level of dollars on trend. They want branded items with superior tweedy and functionality. They manufacture Handbags which serve every want of a sac key girl. Bags from UK are available in new shapes, sizes and colors. The French famous brand Longchamp mechanizing longchamp 2012 equipment founded in 1948, is famous longchamp sale in the world famous leather one of the family. The Longchamp horse LOGO design has detailed longchamp outlet online present low-key, far from the fashion LOGO crime, real let people remember is Longchamp turn hand bag concept, dumplings pop longchamp and bag to lost in honor of the popular Michae is buttons. It to serve the people theme longchamp outlet set limit to bag. To perfect the top French tradition of work, leading the fashion design, deft practical folding concept, and the price level kind is famous the kate Moss For Longchamp world over, today, the product series more by the original skin pipe extended to handbags, leather belt, leather glove, silk and silk tie. We longchamp bags are selling 100% authentic and brand new Bag. It is against our Longchamp Women policy to carry any handbags other than real and genuine. We do not sell any replica, fake Longchamp Women or knockoff designer bag, Every Longchamp Men bags are come with care card. We do not Longchamp Hobo bag encourage and advice customer to place an order if they do not trust or doubt on Longchamp Tote bag our product.
In 1948, Xiang mechanizing equipment founder Longchamp Messenger bag Jean card and Mr. Grant (Jean Cassegrain) in Paris the Longchamp Backpacks first open Longchamp Travel bag pipe outlets. With extremely Longchamp Briefcase creative spirit, Jean card and Mr. Grant to Longchamp le pliage take the lead in leather set in the pipe handle, make a Longchamp Clutch bag pipe appear in style, by the favour Longchamp Wallets of a market, even the United States a generation of rock and roll giant Elvis Presley (Elvis Presley) is also the support! We store have the good credit, reliable quality, so get a lot of customers. Usually a customer bought later will once again to buy. Because they believed us. Our store sells a variety of jewelry, clothing, shoes, hats and other senior. They are all made of the famous international designers. So the styles of them are liked by most of people. They Longchamp sale are very fashion and beautiful. If you want to buy a gift, please choose it here, Our products are cheaper than other shop and the quality is good. So do not overlook to get your bazaar analysis done if you wish Longchamp bags. Our products look beautiful, very generous decent, and very fashionable.
Cheap Longchamplook beautiful, very generous decent, and very fashionable. It have so many beautiful styles and Kate Moss for longchamp the price is cheap. So come and buy Longchamp Bags Outlet. We will provide you with the most perfect service, price, style, color, etc. This will be your most excellent choice.
Replica Handbags
The Best Designer Replica Handbags are on Sale. We provide the hottest new Designer Replica Handbags.Replica Handbags | Replica Designer Handbags | Cheap Handbags | Cheap Replica Handbags | Replica Louis Vuitton Handbags | Replica Gucci Handbags No sales tax&free shipping. 100% Quality Assurance, 100% Price guarantee ! what do you thinking about.? hurry up.
True Religion Outlet
Users is very http://nikeshopes.com/ attractive! with a single cargo?Remaining in the original materials, to find some ingredients, fight Qi scrape http://jordanonlinecheap.com/ out in accordance with the original version of the type of products. Such goods in addition to the version is pretty http://jordansaleoutlet.com/ good, fabric / workmanship / accessories wrong to recover the single shipment .After factory delivery in the country to find http://nikeoutletc.com/ some counterfeit materials and components according to the original type of recycling batch out for the domestic market such goods in addition to the version http://jordanoutleter.com/ nothing!
cheap oakley sunglasses
We provide the 2012 oakley sunglasses discount in oakley sunglasses outlet Online store,I recommend the cheap oakley sunglasses sale up to 80% Off,our discount oakley sunglasses outlet sale top quality oakley sunglasses,100% secure safe and money back guarantee! http://www.oakleysunglassesis.com
Post new comment