MySQL: Umlaute beim Import und Export erhalten
Es geschieht schon häufiger, dass bei einem Umstieg auf einen neuen Server oder bei einem Update nach dem Im- bzw. Export der MySQL-Datenbanken plötzlich die Umlaute falsch dargestellt werden.
Das liegt daran, dass der Standard-Zeichensatz von PhpMyAdmin inzwischen auf UTF-8 eingestellt ist. Viele Datenbanken, verwenden aber noch den in Deutschland gebräuchlichen Zeichensatz ISO-8859-1 oder ISO-8859-15. Das heisst, die Exportdatei von PHPMyAdmin muss in UTF-8 konvertiert werden.
4 Schritte zum Umlaute erhalten
1. Exportieren Sie in PhpMyAdmin Ihre Daten in einen SQL-Dump. Das ist die ganz normale *.sql Datei die sie nach dem Export erhalten.
2. Öffnen Sie den SQL-Dump mit dem Windows Notepad, einem einfachen Text-Editor von Windows. Lassen Sie sich nicht von dem vielleicht ungewöhnlich angezeigten Code irritieren. Oft werden die Daten nur in einer Zeile oder sehr komprimiert dargestellt.
3. Gehen Sie dann im Menü auf “Speichern unter”, wählen Sie im folgenden Dialog bei Codierung “UTF-8″ und speichern sie die SQL-Datei
4. Importieren Sie Ihren SQL-Dump in der (neuen) Datenbank mit PhpMyAdmin.
Fertig! Eigentlich ganz simpel, oder?
Share the love
BTW: Good Quality Brochures Online Color Printing at PsPrint.Spread this KnowTe
Digg Del.icio.us Stumble Facebook Float Technorati Bump
WP Cumulus Flash tag cloud by Roy Tanck requires Flash Player 7 or better.
Subscribe to KnowTeBook
Loved KnowTes
- SEO: Create Advanced Sitemaps with A1 Sitemap Generator
- 20+ Amazing Video Apps for Twitter
- Create and Share Reviews Using New Adobe CS Review
- WordPress: Custom CSS stylesheets for Posts or Pages
- 100+ Brilliant Free Go Green Eco Friendly Vector Graphics and Icons
- Web Strategy: Get real-time comments built for the social web with Lifefyre
- iPhone App for Designer: Proportions Calculator by Erik
- What Does Google Wallet do for Mobile Marketing?
- Combine Wordpress, PHPBB and 4Images together without multiple user-registrations
- Facebook vs. Google: How Marketers Can Learn Out Of the Recent Smear Campaign?
- Social Media: How to Create Automatic If This Then That Tasks
- Selected Free Wallpapers That Rock - Volume 1
- 350+ Free eCommerce Icons for Web Design Projects
- Convert your Image To Vector Online For Free
- 80 Free Mobile Device Icons Including BlackBerry Special
- Free iPad Vector GUI Elements for Adobe Illustrator
- UI Inspiration: A Showcase of Beautiful User Interfaces
- 56 Free Vector Arrow Symbols & Icons
- Free Hand Drawn Social Media Icon Set as Vector for Bloggers
- 10 Awesome And Creative Google+ Brand Pages
- 20 Amazing Mobile Friendly Tips and Tools for your Website
- Icons: Free Social Media Icon Set With Bubbles
- Seven Big Mistakes Of A Twitter Addict
- Free Photoshop Case Templates For DVD, CD and Cassette
- Go Google: Socialize Your WordPress Blog without Using Plugins
- 8 Free Brand Logo Download Websites You Should Know
- Styling Website Comments: Correct Markup and Free Examples
- Brilliant 3D Flash Image Slider For Websites
- 35 Free Beautiful Japan Theme ICONS
- 125 FREE Oldschool Pattern Swatches for Illustrator
- How To Create a Retro Wallpaper
- 8 Heatmap Tools and Why / How to use them
- Introducing New RSS Generation - What is pubsubhubbub?
- 10 Hot Facebook Plugins For Wordpress
- 28 Free Twitter Background PSD Templates
- Impressive Ways to Present Your Portfolio or Media Files
- Mega Drop-Down Menu Inspiration
- 160+ Brilliant Web Design Templates & Tutorials
- 11 Hot Tips and Tricks to Speed Up Wordpress
- Semantic Wordpress - Automatic Semantic Metadata for Your Content
- 800+ Free HTML Newsletter Templates for Startups
- Hot Trends and Insights On Web 3.0
- How To Build a Clean Modern Website Design From Scratch
- Analyzing A Trademark Brand: Absolut Vodka
- Inspiration: What If Google Ruled The World
- 72 Questions to Ask New Web Design Clients
- Free iPhone Design Set for Photoshop
- How To Easily Move or Export Your Thunderbird Mails to Outlook
- How To Add License Free Images To Any website - PicApp
- Awesome Slideshow jQuery Plugin For Portfolios with SlideDeck
- Gpanion - A new google workspace with all your apps
- How Workstations Of Designers and Bloggers look like
- Small and Accessible News Slider in JQuery
- 17 Free Brilliant Photoshop Browser Templates
- 20 web-based business collaboration tools that lets make you breathless
- Free Icons: Digg, Twitter, Stumble, RSS, Delicious & Reddit
- Use A Body ID To Style Your Website In CSS
- How To Create A Webdesign Company Layout in Photoshop
- Old eMail - New eMail: Google ReNews Email Communication
- GIVEAWAY WINNERS - 3 x Fanurio Time Tracking License
Community Links
- 20 Mind Melting Examples of Light Painting
Photographers utilize their knowledge of the different colors produced by various lights, and how they interplay with white balance settings. Light paint brushes can be as simple as a flash light, laser pen, old lantern, or even off-camera flash combined with colored gels.
- KP Design
Inspiration for all - photography, design, art, travels, and more!
- 30 Free Christmas Icon Sets for Designers
Christmas is just around the corner and this is the time when designers need loads of different resources and material to design Christmas related themes,
- Domain Name Selection: How to choose the best
To have an appropriate domain name is always the cause of worry for most website owners, the reason being, it is the primary step to ensure the success of a website or an online business. But there are several other benefits of having a right domain name such as it helps in effective marketing, branding, attracting visitors, building credibility, etc.
- 60 Remarkable Examples Of Typography Design #6
It’s been a really long time since we did our last installment series of “Remarkable Examples Of Typography Design.” To be precise, the last post was way back in June, 2011. Christmas is right around the corner and many designers are using their creativity at a maximum expense.
- Make Forms More Usable With HTML5
html5 introduces new form elements, new input types, and new attributes to help making building and using forms easier.
- Examples of Street Art and Graffiti Art
With today’s collection, we aim to pay tribute to some of the best street art that will simply blow your mind away.
- Showcase of Beautiful iPhone Wallpapers
Acknowledging the fact that the design and development community love to decorate their devices with stylish and classy wallpapers,
- Beautiful Tera Environment Concept Art & Character Design
Developed by Korean game developer Bluehole Studio and published by Frogster who also manage Runes of Magic, these environments are breathtaking with some being just concept art and not the final version they show that the world will be beautiful. In addition featuring detailed character design I can not wait for the release of Tera next year.
- 25 Incredible Logo Designs Inspired by Plant
Logos are the visual representation of the organizations and their businesses,
- How To Add Images To Your CSS Borders
How to use css3 border-images, instead of generic styles, as borders around your elements.
- web 2.0 templatesWeb 2.0 templates with simplicity, cleanliness, and elegance in design and the less number of columns and work great for all your needs and have all the great features of Web 2.0 technology.
KnowTeBook.com
UserTalk
спортни стоки: That gives me ideas what to do with mine. :)
BestBit: Very interesting free tool, but if you have a big site, with more than 500 pages, you have to pay for it.
andrew: cool
Randy: I am thinking of using Lifefyre but maybe for now, I’ll use Disqus. I have a friend from peak...
Niringalpha: Wow, this is soooooo cooool . Guy’s if ya want to seek out cool wallpapers , take a peek out...
Friends
- Business Cards Online
- Craig Farrall’s Blog
- CSS Built
- Design Inspiration
- Design Resources
- Design Tutorials
- Dezignus
- Flash Mint Design Blog
- Free Photoshop Brushes
- fudgegraphics
- Fuel Your Creativity
- Just Creative Design
- Logo designs
- My Ink Blog
- NaldzGraphics
- Onextrapixel
- Pelfusion
- Photoshop Girl Tutorials
- spidanet.de
- Tasarimini | Graphic Tools
- The most stylish websites
- Vector Pack
- Wallpapers
- Website templates
- Webtoolkit4.me
Random KnowTes
- Knowtebook Boosts 611% per Month - spread and succeed too!
- Business: Free Spreadsheet to Track your Blog-Income
- Graphics: 15 Free Outstanding Icon Sets for iPhone
- Color-Management: Web-Farbpaletten mit ColorBlender
- PDF-Dokumente kostenlos aus Microsoft Word, Excel oder Powerpoint erstellen
- CSS Formatter and Optimiser
- Recht: Lästige Spamemailversender den Behörden melden.
- The Most Stunning Viral Ad Campaigns Ever
Serverwechsel vollzogen und Umlaute Problem behoben | Crazy Girls Tipps
May 02, 2009
ID: 1
[…] lesen sind, erst einmal kurz im Netz dazu recherchiert. Dabei bin ich auf einen Beitrag gestoßen MySQL: Umlaute beim Import und Export erhalten, den ich meinem Provider All-Inkl schickte und sie bat, mich bei der Problemlösung der jetzt nach […]