I’ve moved an sql file onto my pythonanywhere acc. Username: mar0093
Path: home/mar0093/database/pickledb_pyany.sql
I want to create a database on pythonanywhere with this file. I’ve tried the following line from the help forum in my database console:
use mar0093$pickledb_pyany; source home/mar0093/database/pickledb_pyany.sql;
I get the error:
ERROR 1273 (HY000): Unknown collation: 'utf8mb4_0900_ai_ci'
and underneath that I get the following for each of my tables.
ERROR 1146 (42S02): Table 'mar0093$pickledb_pyany.znt' doesn't exist
Where znt is just one of my tables.
I’ve also tried going straight through the bash console but I get a similar error. Running this line:
(my-virtualenv) 02:46 ~/database $ mysql -u mar0093 -h mar0093.mysql.pythonanywhere-services.com
'mar0093$pickledb_pyany' < pickledb_pyany.sql
I get this error:
ERROR 1273 (HY000) at line 25: Unknown collation: 'utf8mb4_0900_ai_ci'
Any help would be greatly appreciated.