{"action":"created","issue":{"url":"https://api.github.com/repos/welaika/wordmove/issues/246","labels_url":"https://api.github.com/repos/welaika/wordmove/issues/246/labels{/name}","comments_url":"https://api.github.com/repos/welaika/wordmove/issues/246/comments","events_url":"https://api.github.com/repos/welaika/wordmove/issues/246/events","html_url":"https://github.com/welaika/wordmove/issues/246","id":119096246,"number":246,"title":"Local mysqldump : Return code reports an error (Wordmove::ShellCommandError)","user":{"login":"taliesinpenbardd","id":2260685,"avatar_url":"https://avatars.githubusercontent.com/u/2260685?v=3","gravatar_id":"","url":"https://api.github.com/users/taliesinpenbardd","html_url":"https://github.com/taliesinpenbardd","followers_url":"https://api.github.com/users/taliesinpenbardd/followers","following_url":"https://api.github.com/users/taliesinpenbardd/following{/other_user}","gists_url":"https://api.github.com/users/taliesinpenbardd/gists{/gist_id}","starred_url":"https://api.github.com/users/taliesinpenbardd/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/taliesinpenbardd/subscriptions","organizations_url":"https://api.github.com/users/taliesinpenbardd/orgs","repos_url":"https://api.github.com/users/taliesinpenbardd/repos","events_url":"https://api.github.com/users/taliesinpenbardd/events{/privacy}","received_events_url":"https://api.github.com/users/taliesinpenbardd/received_events","type":"User","site_admin":false},"labels":[],"state":"open","locked":false,"assignee":null,"milestone":null,"comments":2,"created_at":"2015-11-26T19:44:58Z","updated_at":"2015-11-29T14:34:15Z","closed_at":null,"body":"Hey all,\r\n\r\nI've read a lot about mysqldump errors and while some issues were rather similar to mine, I did not find a satisfying solution. As I'm quite new to wordmove, sorry if I ask silly questions.\r\n\r\nI'm on Mac OS 10.11.1 ; I have MAMP installed (but not running), plus - obviously - VVV, vv and wordmove. I'm all good until pushing/pulling.\r\n\r\nAlthough the one with a problem, the database push/pull throws back an error :\r\n```\r\n▬▬ ✓ Pushing Database ▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬\r\nmysqldump --host=myhost.com --user=username --password=password tablename --result-file=/homepages/27/username/htdocs/tests/sitename/wp-content/dump.sql\r\n   remote | mysqldump --host=myhost.com --user=username --password=password tablename --result-file=/homepages/27/username/htdocs/tests/sitename/wp-content/dump.sql\r\n   remote | get: /homepages/27/username/htdocs/tests/sitename/wp-content/dump.sql /Users/username/Local/www/sitename/htdocs/wp-content/staging-backup-1448565861.sql\r\n   remote | delete: /homepages/27/username/htdocs/tests/sitename/wp-content/dump.sql\r\nmysqldump --host=127.0.0.1 --user=root --password=root sitename --result-file=/Users/username/Local/www/sitename/htdocs/wp-content/dump.sql\r\n    local | mysqldump --host=127.0.0.1 --user=root --password=root sitename --result-file=/Users/username/Local/www/sitename/htdocs/wp-content/dump.sql\r\n/Users/username/.rvm/gems/ruby-2.1.2/gems/wordmove-1.3.1/lib/wordmove/deployer/base.rb:136:in `run': Return code reports an error (Wordmove::ShellCommandError)\r\n\tfrom /Users/username/.rvm/gems/ruby-2.1.2/gems/wordmove-1.3.1/lib/wordmove/deployer/base.rb:208:in `save_local_db'\r\n\tfrom /Users/username/.rvm/gems/ruby-2.1.2/gems/wordmove-1.3.1/lib/wordmove/deployer/ssh.rb:17:in `push_db'\r\n\tfrom /Users/username/.rvm/gems/ruby-2.1.2/gems/wordmove-1.3.1/lib/wordmove/cli.rb:60:in `block in push'\r\n\tfrom /Users/username/.rvm/gems/ruby-2.1.2/gems/wordmove-1.3.1/lib/wordmove/cli.rb:36:in `block in handle_options'\r\n\tfrom /Users/username/.rvm/gems/ruby-2.1.2/gems/wordmove-1.3.1/lib/wordmove/cli.rb:34:in `each'\r\n\tfrom /Users/username/.rvm/gems/ruby-2.1.2/gems/wordmove-1.3.1/lib/wordmove/cli.rb:34:in `handle_options'\r\n\tfrom /Users/username/.rvm/gems/ruby-2.1.2/gems/wordmove-1.3.1/lib/wordmove/cli.rb:59:in `push'\r\n\tfrom /Users/username/.rvm/gems/ruby-2.1.2/gems/thor-0.19.1/lib/thor/command.rb:27:in `run'\r\n\tfrom /Users/username/.rvm/gems/ruby-2.1.2/gems/thor-0.19.1/lib/thor/invocation.rb:126:in `invoke_command'\r\n\tfrom /Users/username/.rvm/gems/ruby-2.1.2/gems/thor-0.19.1/lib/thor.rb:359:in `dispatch'\r\n\tfrom /Users/username/.rvm/gems/ruby-2.1.2/gems/thor-0.19.1/lib/thor/base.rb:440:in `start'\r\n\tfrom /Users/username/.rvm/gems/ruby-2.1.2/gems/wordmove-1.3.1/exe/wordmove:6:in `<top (required)>'\r\n\tfrom /Users/username/.rvm/gems/ruby-2.1.2/bin/wordmove:23:in `load'\r\n\tfrom /Users/username/.rvm/gems/ruby-2.1.2/bin/wordmove:23:in `<main>'\r\n\tfrom /Users/username/.rvm/gems/ruby-2.1.2/bin/ruby_executable_hooks:15:in `eval'\r\n\tfrom /Users/username/.rvm/gems/ruby-2.1.2/bin/ruby_executable_hooks:15:in `<main>'\r\n```\r\nFollowing advices from there, I sshed Vagrant and passed the local mysqldump, the one causing problem :\r\n```\r\nvagrant@vvv:~$ mysqldump --host=127.0.0.1 --user=root --password=root tablename --result-file=/Users/username/Local/www/sitename/htdocs/wp-content/dump.sql\r\nmysqldump: Can't create/write to file '/Users/username/Local/www/sitename/htdocs/wp-content/dump.sql' (Errcode: 2)\r\n```\r\nI did ```chmod -R 755 htdocs/``` but that doesn't change anything.\r\n\r\nAny idea on how to solve this ? Now that I know it could work, that's frustrating to be stopped here...\r\n\r\nThanks by advance.\r\n"},"comment":{"url":"https://api.github.com/repos/welaika/wordmove/issues/comments/160419537","html_url":"https://github.com/welaika/wordmove/issues/246#issuecomment-160419537","issue_url":"https://api.github.com/repos/welaika/wordmove/issues/246","id":160419537,"user":{"login":"taliesinpenbardd","id":2260685,"avatar_url":"https://avatars.githubusercontent.com/u/2260685?v=3","gravatar_id":"","url":"https://api.github.com/users/taliesinpenbardd","html_url":"https://github.com/taliesinpenbardd","followers_url":"https://api.github.com/users/taliesinpenbardd/followers","following_url":"https://api.github.com/users/taliesinpenbardd/following{/other_user}","gists_url":"https://api.github.com/users/taliesinpenbardd/gists{/gist_id}","starred_url":"https://api.github.com/users/taliesinpenbardd/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/taliesinpenbardd/subscriptions","organizations_url":"https://api.github.com/users/taliesinpenbardd/orgs","repos_url":"https://api.github.com/users/taliesinpenbardd/repos","events_url":"https://api.github.com/users/taliesinpenbardd/events{/privacy}","received_events_url":"https://api.github.com/users/taliesinpenbardd/received_events","type":"User","site_admin":false},"created_at":"2015-11-29T14:34:15Z","updated_at":"2015-11-29T14:34:15Z","body":"Why does it come that the absolute Mac OS path for a local install works for everything but the database pull/push, and that the absolute path from the Vagrant server works for db push/pull and not for the other push/pulls ?\r\n```\r\nvagrant@vvv:~$ mysqldump --host=127.0.0.1 --user=root --password=root tablename --result-file=/Users/username/Local/www/sitename/htdocs/wp-content/local-backup-1448805242.sql\r\nmysqldump: Can't create/write to file '/Users/username/Local/www/sitename/htdocs/wp-content/local-backup-1448805242.sql' (Errcode: 2)\r\nvagrant@vvv:~$ mysqldump --host=127.0.0.1 --user=root --password=root tablename --result-file=/srv/www/sitename/htdocs/wp-content/local-backup-1448805242.sql\r\n```\r\nIn the latter, the file is well created and weights 558 ko...\r\n\r\nAnyone can help, please ? Need more info ?"}}