How to import database in MySQL from Windows machine to my DO droplet
I have a Joomla website which I need to migrate from shared hosting to DO droplet having CentOS 7 installed on it.
I have already taken the whole website backup including the database on my Windows 7 machine.
I have tried to create the necessary environment by installing Apache, MySQL, PHP.
I have also created an empty database and the username having the same name as that in the configuration.php file.
Now, before i move Joomla files to a new location, I need to have the newly created empty database replaced/restored/populated with the old(backed-up) database.
So, how do I migrate and restore that database to DO droplet?
I am using Putty as an SSH client to connect to my DO server.