Why Experts Exchange?

Experts Exchange always has the answer, or at the least points me in the correct direction! It is like having another employee that is extremely experienced.

Jim Murphy
Programmer at Smart IT Solutions

When asked, what has been your best career decision?

Deciding to stick with EE.

Mohamed Asif
Technical Department Head

Being involved with EE helped me to grow personally and professionally.

Carl Webster
CTP, Sr Infrastructure Consultant
Ask ANY Question

Connect with Certified Experts to gain insight and support on specific technology challenges including:

Troubleshooting
Research
Professional Opinions
Ask a Question
Did You Know?

We've partnered with two important charities to provide clean water and computer science education to those who need it most. READ MORE

troubleshooting Question

Using mysql to backup database - weird characters in the dump file

Avatar of TriCannon
TriCannon asked on
MySQL Server
11 Comments1 Solution325 ViewsLast Modified:
I am using mysqldump. When I open up the dump file that it created using notepad, parts of the file look like this:

Uë*O\0Š‡ã=ãúw{r€bÊð½|0ë÷(2âðÁ}ò±.ðÀ^<ò[®Ý(¶Bڐìÿ‘¶Ã*5¸ÔgJÚ¨ü3¶ñC+þE$P2´H4iÿ‡šñ ï<CŽLIØ^*Cïèļ5ÅÔ\0 ´b¹3û¯ƒD™ksœ”—ÞÂ5¼âèZF{³‡z0Àa6£e”JJ+ìdÌë¹tãÚ0«\råMþÜ‹`‘…¢²\r5.ê±ÐdÊ•—õ<¥Ž¯{ÅN¿®&Ü4ðëJ…Ø¥EtA¹ØŠçßøàG!ü¥jN³8bµ¢A†ŸWA5\nóµó¬¯Ï_€è5í¨.Î-Îk¯¬* Ï,R°„¸¾¬Ë´\"3]Z8W¯cÓJUêõ¼qkÏP÷›þ,ù¾sÉ·¡ôD£üÈ¡~a¤’\nº¶ž›DD¯A tÛ”eÝÒÑø®ŸÜX·?½¬ZYé\'Ñ£^F_ã>ó,á‘n=ÛñYÊBì¿SÎ_ÃMÙ{ã\'–½¥Û>Z}Þ£p{¤‚Àû•{owùª!_Þ…3æâ÷Ò^Ôme!=¶”ªmQü®‚´¤Ã¬jr\\9„÷áÞƒGï9„wf\\ìíÂuaåÜCVZŸ†¢ÀJ1»Û`mÞ˜ç:æ9éîî~‚ø³·;#xwûÑâ2(,Í؏%·0ӏºlÊìÍ„ÏÏ‚XøÔ;ŠÞ½5„ ügXmD‘Pí`|gßàü@}«g$™{”      ç5`ÑîÕŠ¶¨Y$JdY¿¼E‚K‹h˜=:\"òrÅqà7ÌÊOŠB+ðü’¼O6Ò%¤e®}Aún,eR.Ëx1¢;bÏe*q¸ÎDõ2P`ÁJö e“„6BJ?PóÏYeŒeâ¡‚5)ì°Û %ݐX,\Zg@o¿H:ƒ¬VNo¶Ï      {j—¦×Då69懋œRù‰€9]en«\'hësMG®hþlTbyï*ñÚ‘ÃÓl^ýVƒY¹¹*«CÖúŠœ¦·kl2CEž¢Òž;H°‘™¼9¨q‚?‘ĐfãfF˜æ~p¯õÖ¦¡t`]×’Nt€9êÿת0-yu-•Mk_}];6ÆÃj|ëL•`&ü\\Ä«£ì9ŠªÝ[ZÅ>N…!ê[\Zª@ÅQíî\"Fìlíí<x¿bÄV}KYâ3Nýá6Þf¯ºÉò+з“r5aâ3thÐsôÜõ¥‰Ï>„4ñµÕR± ›„þFW)µÁ\Zx%Bm±lÂ-µ`²ËF(š”ú¨÷ù¨¥‰å¡´Pº\0ˆ½Ùb)sï9×Ú¢Jþ9`5Œbó«rQ;)÷EY,²Ã£ÀÔøe×dÖzÌcŸÅv¤*’eïqŠŸ‰ó2\r¹½z³Ÿ¦&ŽjÖ-ö¢µÉˆ~!i£Œ¦IéÆ•ð“õyDœt4êþY•?à·I>bCŠì]‹Òjb[\"ç!7@‡D/-¸ÃAµ“rJÕ>ÚhzÁ¨käÎïÅS¯Àwšõ6§h×\"¦†^\0x9&ëZ´Ø«¥ÇèÝÓ1@ä„ÚÖeƒÉpTµ×¤V אS»À`šBK´™…LïGáµn5žX{JÛD·0ž][õIK?F’¿ªouâ—Ý¥ƒ\nûò5Æ\rÊŠï/EC’Oëç\ZӏܟN\'ÃÕS›gJè¡£F‰Là DÀ¨²\r:Y>QÝg<c‡pæ?#]      ƒì{×c®’˜ÿŠ9ÑŽ¿v\'`N-åã _yL\n!B~?Í9Ç™~b¿œÁQ„öÀz¸€gøz+Üsu)ø.B™À¬«7I¸‡£¢ºÜ§ZPÛhñtbB°˜„T®¡¤ê|دÎ,úïšÎÁÈ,3QA’bäĈ’      m8Ýü8¨H:‡V-aÑ\Z£¡;kÜF‹ðùA±V‰R²Þxç$6$§sɯ¿A÷ÒL.M¢7 Øâ’>²F6®>͐*ù

Most of the file is in readable English, though. What's the deal with this? Is this normal? Will the import work without a problem?

Here is my command:

mysqldump --opt --user root --password=1q2w3e4r wikidb > sql.dump
ASKER CERTIFIED SOLUTION
Avatar of Nem Schlecht
Nem SchlechtFlag of United States of America imageIT Engineering Manager
Commented:
This problem has been solved!
Unlock 1 Answer and 11 Comments.
See Answers