{"action":"created","issue":{"url":"https://api.github.com/repos/sebastianfeldmann/phpbu/issues/64","repository_url":"https://api.github.com/repos/sebastianfeldmann/phpbu","labels_url":"https://api.github.com/repos/sebastianfeldmann/phpbu/issues/64/labels{/name}","comments_url":"https://api.github.com/repos/sebastianfeldmann/phpbu/issues/64/comments","events_url":"https://api.github.com/repos/sebastianfeldmann/phpbu/issues/64/events","html_url":"https://github.com/sebastianfeldmann/phpbu/issues/64","id":156227838,"number":64,"title":"mysqludmp failed; can't create/write to file","user":{"login":"ZaphodBBX","id":7113277,"avatar_url":"https://avatars.githubusercontent.com/u/7113277?v=3","gravatar_id":"","url":"https://api.github.com/users/ZaphodBBX","html_url":"https://github.com/ZaphodBBX","followers_url":"https://api.github.com/users/ZaphodBBX/followers","following_url":"https://api.github.com/users/ZaphodBBX/following{/other_user}","gists_url":"https://api.github.com/users/ZaphodBBX/gists{/gist_id}","starred_url":"https://api.github.com/users/ZaphodBBX/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/ZaphodBBX/subscriptions","organizations_url":"https://api.github.com/users/ZaphodBBX/orgs","repos_url":"https://api.github.com/users/ZaphodBBX/repos","events_url":"https://api.github.com/users/ZaphodBBX/events{/privacy}","received_events_url":"https://api.github.com/users/ZaphodBBX/received_events","type":"User","site_admin":false},"labels":[{"url":"https://api.github.com/repos/sebastianfeldmann/phpbu/labels/question","name":"question","color":"cc317c"}],"state":"open","locked":false,"assignee":{"login":"sebastianfeldmann","id":9250358,"avatar_url":"https://avatars.githubusercontent.com/u/9250358?v=3","gravatar_id":"","url":"https://api.github.com/users/sebastianfeldmann","html_url":"https://github.com/sebastianfeldmann","followers_url":"https://api.github.com/users/sebastianfeldmann/followers","following_url":"https://api.github.com/users/sebastianfeldmann/following{/other_user}","gists_url":"https://api.github.com/users/sebastianfeldmann/gists{/gist_id}","starred_url":"https://api.github.com/users/sebastianfeldmann/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/sebastianfeldmann/subscriptions","organizations_url":"https://api.github.com/users/sebastianfeldmann/orgs","repos_url":"https://api.github.com/users/sebastianfeldmann/repos","events_url":"https://api.github.com/users/sebastianfeldmann/events{/privacy}","received_events_url":"https://api.github.com/users/sebastianfeldmann/received_events","type":"User","site_admin":false},"milestone":null,"comments":8,"created_at":"2016-05-23T08:41:22Z","updated_at":"2016-05-23T11:08:44Z","closed_at":null,"body":"Hi,\r\n\r\nWhen trying an phpbu backup I get a mysql dump error:\r\nException 'phpbu\\App\\Exception' with message 'mysqldump failed:mysqldump: Got error: 1: Can't create/write to file '/tmp/mysql/mysqldump-20160523-0830.sql.dump/Afwezigheden.txt' (Errcode: 13) when executing 'SELECT INTO OUTFILE'\r\n\r\nI know this is most likely a permissions error, but I can't get it to work, I have even tried setting chmod 777 -R on the target dir, I have changed the owner/group to mysql user, I have executed phpbu command as mysql user,...\r\n\r\nWeird thing is the tool does create an Afwezigheden.sql file. But refuses to create the Afwezigheden.txt file. (I'm using the filePerTable option).\r\n\r\nSo I'm kind of running out of idea's. Anyone have a possible solution to this problem?\r\n"},"comment":{"url":"https://api.github.com/repos/sebastianfeldmann/phpbu/issues/comments/220951446","html_url":"https://github.com/sebastianfeldmann/phpbu/issues/64#issuecomment-220951446","issue_url":"https://api.github.com/repos/sebastianfeldmann/phpbu/issues/64","id":220951446,"user":{"login":"sebastianfeldmann","id":9250358,"avatar_url":"https://avatars.githubusercontent.com/u/9250358?v=3","gravatar_id":"","url":"https://api.github.com/users/sebastianfeldmann","html_url":"https://github.com/sebastianfeldmann","followers_url":"https://api.github.com/users/sebastianfeldmann/followers","following_url":"https://api.github.com/users/sebastianfeldmann/following{/other_user}","gists_url":"https://api.github.com/users/sebastianfeldmann/gists{/gist_id}","starred_url":"https://api.github.com/users/sebastianfeldmann/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/sebastianfeldmann/subscriptions","organizations_url":"https://api.github.com/users/sebastianfeldmann/orgs","repos_url":"https://api.github.com/users/sebastianfeldmann/repos","events_url":"https://api.github.com/users/sebastianfeldmann/events{/privacy}","received_events_url":"https://api.github.com/users/sebastianfeldmann/received_events","type":"User","site_admin":false},"created_at":"2016-05-23T11:08:43Z","updated_at":"2016-05-23T11:08:43Z","body":"For me, this config\r\n```xml\r\n<backup>\r\n    <source type=\"mysqldump\">\r\n        <option name=\"user\" value=\"root\" />\r\n        <option name=\"databases\" value=\"dbname\" />\r\n        <option name=\"filePerTable\" value=\"true\" />\r\n    </source>\r\n    <target dirname=\"backup/mysql\" filename=\"mysql-%Y%m%d-%H%i.sql\" compress=\"bzip2\" />\r\n</backup>\r\n```\r\nresults in this\r\n```\r\nphpbu 3.1-dev\r\n\r\nRuntime:       PHP 7.0.2-1~dotdeb+8.1\r\nConfiguration: /var/phpbu/phpbu.xml\r\n\r\nTime: 1.87 seconds, Memory: 2.00Mb\r\n\r\nOK (1 backup, 0 checks, 0 crypt, 0 syncs, 0 cleanups)\r\n```\r\n\r\nWhen I run `phpbu --simulate` I get something like this\r\n```\r\nphpbu 3.1-dev\r\n\r\nRuntime:       PHP 7.0.2-1~dotdeb+8.1\r\nConfiguration: /var/phpbu/phpbu.xml\r\n\r\nbackup: [mysqldump] *******************************************************\r\nbackup data:\r\n/usr/bin/mysqldump --user='root' 'dbame' --tab='/var/phpbu/backup/mysql/dump-20160523-1100.sql.dump'\r\n(/bin/tar -jcf '/var/phpbu/backup/mysql/dump-20160523-1100.sql.bz2' -C '/var/phpbu/backup/mysql' 'dump-20160523-1100.sql.dump' && rm -rf '/var/phpbu/backup/mysql/dump-20160523-1100.sql.dump')\r\nok\r\n```\r\nthe important part is\r\n```\r\nmysqldump --user='root' 'dbame' --tab='/var/phpbu/testdump'\r\n```\r\nCan you create a directory `/var/phpbu/testdump` manually and execute the query above to see if it works without phpbu"}}
{"actor":{"display_login":"sebastianfeldmann"}}