Old server is MariaDB 10.6 New server is MariaDB 10.3
I mysqldump the old DB which is still the master copy and functioning.
I made sure the new server DB is set to InnoDB (like the old one) using this in the cnf file:
Then with a fresh new maria DB (10.3 mind you), I do:
- Log in and create database newdatabase
- sudo mysql -u root -p newdatabase < media_data_master.dump
The result is:
ERROR 1071 (42000) at line 266: Specified key was too long; max key length is 1000 bytes
The stackoverflow post I linked above talks about VARCHARs being all 255 and that causing the issue. Big problem however is that I don't know how I would ever fix that. The people who use the database are not even in my department, I'm just trying to move the thing to a new server.
I had also tried
create database my_db character set utf8 collate utf8_bin; before I did the import but same problem.
If the old DB is still functional AND our replica appears to still be replicating perfectly, is there something I'm missing here that will allow me to import the dump and avoid this error?