Join 1M+ other developers and:
- Get help and share knowledge in Q&A
- Subscribe to topics of interest
- Get courses & tools that help you grow as a developer or small business owner
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?
These answers are provided by our Community. If you find them useful, show some love by clicking the heart. If you run into issues leave a comment, or add your own answer to help others.×