How to migrate .sql external to my wordpress/ubuntu application?

July 30, 2014 1.5k views

Hi, i'm not a heavy user but i'm trying to user my new blog in this host. Because a friend specialist recommend to me.

I have a Wordpress Blog in another hosting, and i made the backup of mysql (.sql) and the archives, and i want to import this archives and mysql database, to this new installation/droplet.

Anyone can help me with this?


1 Answer

The basic command to restore a MySql database is:

mysql -h localhost -u database_user -p database_name < backup_db.sql.gz 

Check out this tutorial for more information:

How To Migrate WordPress from Shared Hosting to a Cloud Server with Zero Downtime

by Ramesh Jha
If you read through this article you'll have the knowledge to migrate your WordPress site from Shared Hosting to a Cloud Server with zero downtime.
Have another answer? Share your knowledge.