drush sql-sync

October 21, 2013 4.2k views
cfranco80
By:
cfranco80
Hi guys! I'm trying to synchronize my database with the commad "drush sql-sync" but apparently I have not improperly set permissions somewhere that tells me the following error. ================================== mv: cannot move `/tmp/name-db.sql-1382384285' to `/tmp/name-db.sql': Operation not permitted Database dump failed ================================== They know how I can solve it? Best regards!
Log In to Comment
6 Answers
etel October 21, 2013
Make sure that your mysql user has the following permissions. This will allow it to lock all of the databases required in the sync.

grant all privileges on your_db.* to your_username@localhost with grant option;
grant reload on *.* to druser2@localhost;
flush privileges;

Let me know if you have issues after doing those steps :)
Reply
kamaln7 MOD October 22, 2013
See if what Etel posted fixes it. If not, what's the output of stat /tmp?
Reply
cfranco80 October 22, 2013
Hello Etel!

Thank you for your help!
I followed the steps you indicated, but still without being able to connect.

This is the message:

Connection Failed
Host 'my.ip.work.station.static.axtel.net' is not allowed to connect to this MySQL server

How to enable/disable MySQL remote access?

Best regards!

Reply
kamaln7 MOD October 23, 2013
@cfranco80: Since you're not running that command locally, you will have to allow your IP address to connect to the MySQL server.

Simply run Etel's commands again replacing 'localhost' with your IP address.

Let me know if that works. :]
Reply
cfranco80 October 28, 2013
Hi Kamal Nasser!

thank you for your response. I am new in VPS manage and I buyed this VPS to learning.

What is Etel´s commands and how to work?

Best regards!
Reply
kamaln7 MOD October 30, 2013
@cfranco80: Etel's commands are the commands she posted above on October 21st, 2013 22:37:

Reply
Have another answer? Share your knowledge.