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?
Spread the words
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
LovedKnowtes
- Pattern Freebies: 26.000+ Free Photoshop Patterns for any use
- Community Link Feed
- Graphics: 15 000 free high quality icons
- Graphics: 9 Free Vector PNG Icons
- 8 Free Brand Logo Download Websites You Should Know
- Graphics: 66 free logo vector templates for your business
- Free Simple Wordpress Portfolio Theme
- Free Design Portfolio Theme for WordPress: ImPress
- Free Wordpress Theme for Designer and Portfolio Websites
- How To Promote Your Posts in 10 Minutes to 1 Mio People
- 35 Free Beautiful Japan Theme ICONS
- 34+ free HTML newsletter templates for startups
- Cool Business Cards That People Will Never Throw Away
- 8 Heatmap Tools and Why / How to use them
- 148 free beautiful vector graphics for web and print
- Free iPhone Design Set for Photoshop
- The Most Stunning Viral Ad Campaigns Ever
- 56 Free Vector Arrow Symbols & Icons
- Free Photoshop Case Templates For DVD, CD and Cassette
- Free vector brand logotypes in CDR, EPS and WMF formats
- 20 web-based business collaboration tools that lets make you breathless
- Creative Online Ad Design: Ideas & Trends in 2008
- Graphics: Great Free Icons & iphone Wallpaper at Pixelgirl
- Convert your Image To Vector Online For Free
- Free Brilliant Website Chats and Why / How to use them
- Graphics: 2000+ Open Source Web Templates
- CSS: How to make a footer which really stays on the bottom
- Free iPhone style Photoshop Icons
- Most Awarded Advertisements in 2008
- Free Vector Graphics at Vecteezy
- Free Icons: Digg, Twitter, Stumble, RSS, Delicious & Reddit
- PDF-Dokumente kostenlos aus Microsoft Word, Excel oder Powerpoint erstellen
- Freebies: Twitter Bird Icons & Illustration
- SEO: How To Create a Google Sitemap in 5 Minutes
- Create a realistic Credit Card in Photoshop
- Graphics: Free Smashing Vector Icon Set - Milky
- 6 Awesome Wallpapers for PC, MAC and Iphone
- 25 graphic resources for ornaments, fleurons, and more
- Freebies: Creative Twitter Themes
- What's better? Ruby on Rails vs. PHP
- 1.000 More Free High Quality Icons For Download
- Graphics: 15 Free Outstanding Icon Sets for iPhone
- CSS: How To Hide Headlines For Better SEO Effects
- CMS: Open source php cms without database
- Brilliant Ways to Style Blockquotes
- Free Unique WordPress Magazine Theme: ZinePress
- CSS Revolution - Use Condition Rules WITHIN Styles
- Combine Wordpress, PHPBB and 4Images together without multiple user-registrations
- Tutorial: How to make Professionell Glossy Web 2.0 Graphics
- Von Word zu PDF kostenlos in 3 Minuten
- Graphics: Free Web Development Icon Sets
- Interesting Sites
- Ambient Media Premium Advertising Inspiration
- Self-Marketing: Outstanding Portfolio Ideas in 3D
- 100+ Free Photoshop Actions at Erics FX
- CSS: Überschriften durch Bilder ersetzen
- Free Maps Of All Countries and States On the World
- CSS Freedom - Redesign HTML Form Elements As You Like
- How To Create a Retro Wallpaper
- CSS: 7 Free Perfect Multi-column Liquid Layouts
Recommendation
Community Links
- 70 Impressive Painting Artworks - Winter Inspiration
Where do mixed media artists find inspiration in the winter? We have hand-picked an incredible amount of amazing painting artworks from deviantart to inspire any artist
- Six Thinking Hats
Applying the Six Thinking Hats method can greatly improve our web design process.
- 3 Methods To Exclude Wordpress Categories In A Post
Although there are a lot of methods to exclude categories on your articles or sidebar. But i am going to show you 3 methods which commonly use by people.
- Marta Dahlig - digital painter
Marta Dahlig is one of the most known deviants on deviantart.com with nearly 4 milion views on her profile and who knows how many on all her deviations. She is known for her 7 deadly sins drawings of women.
- Web Designs with Coffee Aroma
The stimulating collection of Top Coffee Brands websites!
- Bible Design
Illuminated Manuscripts to Postmodern Power Plays
- 45 Vintage 'Space Age' Illustrations
An inspiring collection of 45 vintage illustrations of a space age tomorrow!
- 8 Wrinkled Paper Textures | Texturise
8 assorted wrinkled paper textures scanned at 300 DPI.
- Red themed CSS and Flash design gallery - Part 1
I’ve decided to make the web design showcase themed as it is more easy to find what you are looking for. You will be surprised but there aren’t many quality red CSS and Flash sites. But don’t worry. I’ve gathered in this showcase article 22 of the best, and 23 more are waiting for the release of Part 2 so they can show off their red design.
- Typography resources for all things typographic
Here are a few resources I have bookmarked along the way that relate to inspirational galleries, fonts, tips and other type resources.
- 10 Blender 3D tutorials worth a look
Blender is the free open source 3D content creation suite, available for all major operating systems under the GNU General Public License. I have always wanted to learn a 3d program to extend my capabilities and a little 3D in our designs can take your designs to another level. There is no harm in learning something new so I will list a few good tutorials that I will use to learn my way through blender.
- 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.
UserTalk
3wlink: Hi, I was looking for exactly this code. Thanks a lot for the nice and excellent solution.
The Palermo Project: again, web analytics play a central role thanks to these tools- questionnaires, audience...
kovilen: That’s a great list, Thanks!!!
Heru: It’s a very fantastic design,,
