importing database to digitalocean

May 28, 2016 1.5k views
MySQL WordPress Ubuntu

i have a database downloaded on my computer

i want to import that database into digital ocean but i cant do it

there are tutorials explaining that but i am confused.

can anyone explain ?

What are the commands for this?

1 Answer

Then log out of the MySQL shell and type the following on the command line:

mysql -u [username] -p [databasename] < /home/newdb.sql

replace [username] with your mysql username and [databasename] with your database name and "/home/newdb.sql" is your mysql dump with location.

Have another answer? Share your knowledge.