Can't Import MySQL Database
I want to use managed database instead of my own digitalocean vps server.
My server is centos and mysql version is 5.5.5.
I want to import mysql .sql file to new database.
I installed “tablesplus” and chose “import” section. my database is 217mb.
when it imports 20mb, then it gives an error.
after that I tried to connect my managed database from my terminal, to import my sql file.
mysql -u doadmin -p blablabla -h blabla-do-user-blabla-0.db.ondigitalocean.com -P 25060 -D defaultdb
but when use it, it return me that error:
ERROR 1045 (28000): Plugin cachingsha2password could not be loaded: dlopen(/usr/local/Cellar/mariadb/10.4.6//usr/local/Cellar/mariadb/10.4.6/lib/plugin/cachingsha2password.so, 2): image not found
I can’t import my existing sql file to managed database.
isn’t there any way to make it?