Member Avatar for Logical1
Logical1 0 Newbie Poster

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

  • 1 Contributor
  • 0 Replies
  • 48 Views
Be a part of the DaniWeb community

We're a friendly, industry-focused community of developers, IT pros, digital marketers, and technology enthusiasts meeting, networking, learning, and sharing knowledge.