I would like to convert a MySQL database, which has
utf8mb4 character set and
How to do that please?
Thank you in advance for your suggestions.
Database Administrators Stack Exchange is a question and answer site for database professionals who wish to improve their database skills and learn from others in the community. It only takes a minute to sign up.Sign up to join this community
I just solved the charset problem by using Notepad++.
The problem was that my php version is 126.96.36.199 and the hosting firm's was 3.3.8. Because of that, it could not work with the
To solve the problem open the exported SQL file, search and replace the
utf8, after that search and replace the
utf8_general_ci. Save the file and import it into your database. After that, change the wp-config.php charset option to
utf8, and the magic starts.
Note that it worked in a Hungarian database.