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!
This textbox defaults to using Markdown to format your answer.
You can type !ref in this text area to quickly search our full set of tutorials, documentation & marketplace offerings and insert the link!
Make sure that your mysql user has the following permissions. This will allow it to lock all of the databases required in the sync. <br> <br>grant all privileges on your_db.* to your_username@localhost with grant option; <br>grant reload on . to druser2@localhost; <br>flush privileges; <br> <br>Let me know if you have issues after doing those steps :)
See if what Etel posted fixes it. If not, what’s the output of <code>stat /tmp</code>?
@cfranco80: Since you’re not running that command locally, you will have to allow your IP address to connect to the MySQL server. <br> <br>Simply run Etel’s commands again replacing ‘localhost’ with your IP address. <br> <br>Let me know if that works. :]
Become a contributor for community
Get paid to write technical tutorials and select a tech-focused charity to receive a matching donation.
DigitalOcean Documentation
Full documentation for every DigitalOcean product.
Resources for startups and SMBs
The Wave has everything you need to know about building a business, from raising funding to marketing your product.
The developer cloud
Scale up as you grow — whether you're running one virtual machine or ten thousand.
Get started for free
Sign up and get $200 in credit for your first 60 days with DigitalOcean.*
*This promotional offer applies to new accounts only.