Moodle version is? current server and on new server ...
Assuming MySQL ... Mysql version on current server and on new server ...
When you exported the current server's moodle sql, how did you do that ... specifically.
When you created the new db, how did you that ... specifically.
Devil could be in the details.
'spirit of sharing', Ken
I managed to solve the issue, Ken, thank you for the reply
it was a database collation issue
Hi Leah -
I'm running into the same issue for a migration. Can you provide any details on how you fixed it? Specifically was it relatively a few steps or do I need a SQL developer? I'm a VA and am transferring for a client. I'm a programmer but not focused on that right now.
You have to open your database sql file and replace character set utf8mb4 with utf8
It worked for me
I hope it will work for you as well