I have downloaded a database from an existing Wordpress installation from another server. I would now like to import the database into a new Wordpress installation in my droplet.
I have uploaded the file to: /var/www/website/_downloads/database.sql.zip
Any help would be greatly appreciated, thanks!
If you are installing the database through the terminal;
use <name_of_database>;
source <path_of_.sql>
first take the backup of wordpress database from another server using below command
mysqldump -u root -p databasename > database.sql #it will create file database.sql in current directory.
Not copy that file to new server and use below command to import the database.
mysql -u root -p databasename < database.sql
you can also unzip the /var/www/website/_downloads/database.sql.zip file and directly import using below command.
mysql -u root -p database name < /var/www/website/_downloads/database.sql
provide the root password to complete import.