PHP Script to copy database from one server to another

Question

I have a scenario where I need to copy production database to my dev database on daily basis. Both are different servers. What I have thought of writing a cronjob that will do the stuff. I have written a php script. I am connecting to remote production server via sshpass, taking its dump and then populating that dump.

exec("sshpass -p 'mypassword' ssh root@IP_ADDRESS:PORT");
exec("mysqldump -u root -p DB > production_dump.sql");
exec("mysql -u root -p test < production_dump.sql");

But at first line it throws error of stating

ssh: Could not resolve hostname IP_ADDRESS:PORT: Name or service not known

I have tried given solution on internet but non of them worked. Can any on please explain what I am doing wrong?

It looks like you wrote bash script wrapped in PHP? Why not make it pure bash? — Marcin Orlowski
– Marcin Orlowski, Commented Oct 22, 2019 at 14:10
@MarcinOrlowski because I am not very familiar with that and didn't know how can I achieve that in above scenario like running it as cron job — Awais Qarni
– Awais Qarni, Commented Oct 22, 2019 at 14:11
See stackoverflow.com/questions/1895185/… and stackoverflow.com/questions/13928116/… and stackoverflow.com/questions/26434604/… — aynber
– aynber, Commented Oct 22, 2019 at 14:16

aynber · Accepted Answer · 2019-10-22 14:13:38Z

1

Your command is failing because it's not formatted right. You need to use one of the following formats:

sshpass -p 'mypassword' ssh root@IP_ADDRESS PORT
sshpass -p 'mypassword' ssh root@IP_ADDRESS -p PORT
sshpass -p 'mypassword' ssh ssh://root@IP_ADDRESS:PORT

However, I'm not sure if the rest of the script will work, especially if it starts asking for a password. A bash script would be the way to go.

answered Oct 22, 2019 at 14:13

aynber

23.2k9 gold badges57 silver badges69 bronze badges

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

Collectives™ on Stack Overflow

PHP Script to copy database from one server to another

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