 |  |  |  |  |  |  |  |
.sql file loses characters
Please support our MySQL advertiser: PostgreSQL or MySQL? Compare and contrast the two most popular open source databases
 |
Hello
New member and pretty ignorant about SQL I should say.
I have made regular backups of mySQL database and now that I need to restore it I see all the characters (UTF-8) characters have changed to wierd characters that make no sense at all.
I am using phpMyAdmin's Export tool which generates a .sql file. But I see no option while saving this file to select UTF-8 or ASCII.
2 questions:
1. HOw can I restore my backup file into proper characers?
2.what can I do in future to avoid this problem and save the .sql file as UTF-8.
Greatly appreciate your attention
L
New member and pretty ignorant about SQL I should say.
I have made regular backups of mySQL database and now that I need to restore it I see all the characters (UTF-8) characters have changed to wierd characters that make no sense at all.
I am using phpMyAdmin's Export tool which generates a .sql file. But I see no option while saving this file to select UTF-8 or ASCII.
2 questions:
1. HOw can I restore my backup file into proper characers?
2.what can I do in future to avoid this problem and save the .sql file as UTF-8.
Greatly appreciate your attention
L
|
Similar Threads
- how to open the backup.sql file in mysql (Python)
- Reading characters from a file (C++)
- Play Music which File name contains Chinese Characters (Visual Basic 4 / 5 / 6)
- getting every 4 characters from a text file (C++)
- Help required with .sql file! (MySQL)
- PHP / SQL Delete From Statement Not working with URL? (PHP)
- file access problem(access and oracle) (C++)
- file wont delete (Windows NT / 2000 / XP)
- Enemy Storage/Selection file (Java)
Other Threads in the MySQL Forum
- Previous Thread: exclude
- Next Thread: How to select the Last row from a table..using Mysql
| Thread Tools | Search this Thread |
You need to join our community in order to build your list of favorite forums. You can visit the forum index for a listing of all forums.
Related Forum Features
Latest MySQL Posts
- Today's Posts
- Unanswered Threads
agplv3 amazon api artisticlicense aws bizspark breathalyzer camparingtocolumns changingprices cmg communityjournalism contentmanagement contractors copyright count court crm database design developer development distinct drupal dui ec2 email enterprise eudora facebook form foss gartner gnu government gpl greenit groklaw groupware hiring hyperic images innerjoins insert ip joebrockmeier join journalism keyword keywords kickfire laptop law legal license licensing linux managing mariadb matchingcolumns metron micromanage microsoft microsoftexchange mindtouch montywidenius mozilla multiple music mysql mysqlcolumnupdating mysqlindex mysqlinternalqueries mysqlquery mysqlsearch news open-xchange opendatabasealliance opengovernment opensource oracle penelope php priceupdating query referencedesign reorderingcolumns resultset saas select sharepoint simpledb sourcecode spotify sql sugarcrm syntax techsupport thunderbird transparency virtualization
