deploy a MySQL database on the remote server

Question

I have a local MySQL databases and I want to deploy it on the remote server.

There is some tool in PhpMyAdmin to synchronize local and remote databases, however is very slow if you have large databases, as in my case.

Is there a better and a faster way ? Such as shell through ssh, or something else ?

this is how to get the remote db to your localhost PC, but I need to put my local db to the remote server. — EKK
– EKK, Commented Mar 10, 2011 at 12:33
You should rephrase your question. You are not trying to synchronize your DBs, you are trying to copy and deploy a snapshot. For synchronization, look to mysql replication. — MatthieuP
– MatthieuP, Commented Mar 11, 2011 at 12:50
True, I am trying to copy it. I have rephrased my question, thanks correcting me. — EKK
– EKK, Commented Mar 12, 2011 at 5:16

EKK · Accepted Answer · 2011-03-11 12:46:35Z

3

Fond a solution:

mysqldump -u my_local_db_username --password=my_local_db_password --host=localhost -C my_local_db_name | ssh [email protected]_domain.com "mysql -u my_remote_db_username --password=my_remote_db_password my_remote_db_name"

source: here

answered Mar 11, 2011 at 12:46

EKK

4,1489 gold badges33 silver badges46 bronze badges

Sign up to request clarification or add additional context in comments.

Collectives™ on Stack Overflow

deploy a MySQL database on the remote server

1 Answer 1

Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related