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

Posted July 30, 2014 1.8k 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?


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.

Submit an Answer
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.