0

MySQL 5.7

I am exporting my db from my web host using phpmyadmin. This produces a single .sql file.

When I check the export with Notepad+, there are special characters in the file.

e.g. in my source db the following text;

The cost is £40 per person.

Is changed in the sql file to;

The cost is £40 per person.

The charset on the source db are all either utft or utf8mb4

DO I need to change any specific setting on the source db to ensure that there are no special characters during export? Currently I am leaving all the phpmyadmin settings default.

Improve this question

1 Answer 1

Reset to default
0

You should try using --hex-blob when you run the mysqldump

Since you are using phpmyadmin, look around in the Advanced tab to see if there is a HEX Blob Option. The mysqldump should also have directives present to preserve the intended character set info.

Improve this answer
1
  • Thanks for the suggestion but I am not using mysqldump, I am logged into my we host's control panel and opening phpmyadmin. In the export tab I can't see anything related to hex-blob, only the standard export options e.g. charset (which is set to utf-8), compression, add statements etc.
    – TheOrdinaryGeek
    Commented Feb 10, 2023 at 9:31

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service and acknowledge you have read our privacy policy.

Not the answer you're looking for? Browse other questions tagged or ask your own question.