How to transfer database from old host to Digitalocean
I am currently having a wordpress website at cloudways and I want to migrate to digitalocean. I successfully installed wordpress using easyengine (nginx) and I transferred wp-content to the new server here.
I am stuck at migrating the database. As I can understand the default location for databases is at
/var/lib/mysql. How can I transfer my old database here using an
I used this command
mysql -h localhost -u xtmdntvrds -p xtmdntvrds < xtmdntvrds.sql but when I insert password it gives me
ERROR 1045 (28000): Access denied for user 'xtmdntvrds'@'localhost' (using password: YES)
The password is correct for sure because I can see it in
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.