CODEWITHSUNDEEP
phpmysqldatabasewordpress
Imlastrebor
Imlastrebor

Reputation: 327

Moving MySQL database from local MAMP server to host's server

I've developed WP site locally using MAMP. I know how to transfer WP site to server using FTP but problem is how I get MySQL DB to server. Before I've done this in cPanel and that's easy. Now there's no option to use cPanel or phpMyAdmin on the host. I can get connection to server with FTP and SHH. So is it possible to move DB from MAMP to server somehow? If not what should I do?

Thanks in advance!

Upvotes: 2

Views: 482

Answers (1)

Adam
Adam

Reputation: 141

You could FTP the export of your SQL dump file to your live server, then if you have SSH access and can connect to the MySQL command line, you could import your SQL dump file. This article should be helpful:

https://stackoverflow.com/questions/17666249/how-do-i-import-an-sql-file-using-the-command-line-in-mysql

You didn't specify what type of live server you're running, that information would be helpful!

Upvotes: 2

Related Questions