{"action":"opened","issue":{"url":"https://api.github.com/repos/MarvAmBass/docker-mysql/issues/3","labels_url":"https://api.github.com/repos/MarvAmBass/docker-mysql/issues/3/labels{/name}","comments_url":"https://api.github.com/repos/MarvAmBass/docker-mysql/issues/3/comments","events_url":"https://api.github.com/repos/MarvAmBass/docker-mysql/issues/3/events","html_url":"https://github.com/MarvAmBass/docker-mysql/issues/3","id":71786883,"number":3,"title":"My SQL dump is too big.  It keeps failing at about 11%","user":{"login":"chamunks","id":1068374,"avatar_url":"https://avatars.githubusercontent.com/u/1068374?v=3","gravatar_id":"","url":"https://api.github.com/users/chamunks","html_url":"https://github.com/chamunks","followers_url":"https://api.github.com/users/chamunks/followers","following_url":"https://api.github.com/users/chamunks/following{/other_user}","gists_url":"https://api.github.com/users/chamunks/gists{/gist_id}","starred_url":"https://api.github.com/users/chamunks/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/chamunks/subscriptions","organizations_url":"https://api.github.com/users/chamunks/orgs","repos_url":"https://api.github.com/users/chamunks/repos","events_url":"https://api.github.com/users/chamunks/events{/privacy}","received_events_url":"https://api.github.com/users/chamunks/received_events","type":"User","site_admin":false},"labels":[],"state":"open","locked":false,"assignee":null,"milestone":null,"comments":0,"created_at":"2015-04-29T05:57:28Z","updated_at":"2015-04-29T05:57:28Z","closed_at":null,"body":"I've been feeding this SQL dump into this container using a variant of the following.\r\n\r\n  pv mysqlbackup-2015.04.28.sql | mysql -u root -pREDACTED -h $(docker inspect --format='{{.NetworkSettings.IPAddress}}' REDACTED)\r\nI used PV as a suggestion from a thread I found that shows a progress bar of the process.  The import seems to reach about 20 million rows before it fails.  \r\n  http://dba.stackexchange.com/questions/58493/mysql-failing-and-very-slow-on-importing-a-large-file\r\n\r\nReading from this tutorial:\r\n\r\n  https://www.digitalocean.com/community/tutorials/how-to-migrate-a-mysql-database-to-a-new-server-on-ubuntu-14-04\r\n\r\nI exported every bit I could from the previous bare metal which apparently weighs in at about 8gigs.\r\n\r\nFrom the dba.stackexchange.com question it seems that someones made a suggestion to play with configs but theres no obvious way to change other settings in this image.  Could there be some?"}}