.sql file loses characters

Reply

Join Date: Nov 2009
Posts: 1
Reputation: Logical1 is an unknown quantity at this point 
Solved Threads: 0
Logical1 Logical1 is offline Offline
Newbie Poster

.sql file loses characters

 
-1
  #1
17 Days Ago
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
Reply With Quote Quick reply to this message  
Reply

Message:


Thread Tools Search this Thread



About Us | Contact Us | Advertise | DaniWeb | Acceptable Use Policy | RSS Feed

©2003 - 2009 DaniWeb® LLC