{"action":"created","issue":{"url":"https://api.github.com/repos/airbnb/caravel/issues/585","repository_url":"https://api.github.com/repos/airbnb/caravel","labels_url":"https://api.github.com/repos/airbnb/caravel/issues/585/labels{/name}","comments_url":"https://api.github.com/repos/airbnb/caravel/issues/585/comments","events_url":"https://api.github.com/repos/airbnb/caravel/issues/585/events","html_url":"https://github.com/airbnb/caravel/issues/585","id":159228771,"number":585,"title":"Transfer caravel db into MySQL","user":{"login":"jjdblast","id":3394810,"avatar_url":"https://avatars.githubusercontent.com/u/3394810?v=3","gravatar_id":"","url":"https://api.github.com/users/jjdblast","html_url":"https://github.com/jjdblast","followers_url":"https://api.github.com/users/jjdblast/followers","following_url":"https://api.github.com/users/jjdblast/following{/other_user}","gists_url":"https://api.github.com/users/jjdblast/gists{/gist_id}","starred_url":"https://api.github.com/users/jjdblast/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/jjdblast/subscriptions","organizations_url":"https://api.github.com/users/jjdblast/orgs","repos_url":"https://api.github.com/users/jjdblast/repos","events_url":"https://api.github.com/users/jjdblast/events{/privacy}","received_events_url":"https://api.github.com/users/jjdblast/received_events","type":"User","site_admin":false},"labels":[{"url":"https://api.github.com/repos/airbnb/caravel/labels/question","name":"question","color":"cc317c"}],"state":"open","locked":false,"assignee":null,"assignees":[],"milestone":null,"comments":9,"created_at":"2016-06-08T17:41:13Z","updated_at":"2016-08-03T00:58:11Z","closed_at":null,"body":"I try to load caravel.db into mysql database for a stable control, and I finally success with [this](http://stackoverflow.com/questions/18671/quick-easy-way-to-migrate-sqlite3-to-mysql) guide ,\r\n\r\nAnd then I changed the caravel/config.py with `SQLALCHEMY_DATABASE_URI = 'mysql://XXXX:XXXX@localhost/caravel`, I can create admin user by `fabmanager create-admin --app caravel` and MySQLdatabase successfully updated. \r\n\r\nBut when I try to upgrade database config with `caravel db upgrade`, it's failed with this error :\r\n\r\n![image](https://cloud.githubusercontent.com/assets/3394810/15904212/ae509668-2de2-11e6-8cf8-587615c7c3f4.png)\r\n\r\nAnd then I tried `caravel init`, it's still failed:\r\n\r\n![image](https://cloud.githubusercontent.com/assets/3394810/15904224/b405ceb6-2de2-11e6-924b-6b13031cc131.png)\r\n\r\nAm I handle this right ? Or caravel doesn't support MySQL to save the meta data yet ?\r\n"},"comment":{"url":"https://api.github.com/repos/airbnb/caravel/issues/comments/237099343","html_url":"https://github.com/airbnb/caravel/issues/585#issuecomment-237099343","issue_url":"https://api.github.com/repos/airbnb/caravel/issues/585","id":237099343,"user":{"login":"birdspring","id":19747498,"avatar_url":"https://avatars.githubusercontent.com/u/19747498?v=3","gravatar_id":"","url":"https://api.github.com/users/birdspring","html_url":"https://github.com/birdspring","followers_url":"https://api.github.com/users/birdspring/followers","following_url":"https://api.github.com/users/birdspring/following{/other_user}","gists_url":"https://api.github.com/users/birdspring/gists{/gist_id}","starred_url":"https://api.github.com/users/birdspring/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/birdspring/subscriptions","organizations_url":"https://api.github.com/users/birdspring/orgs","repos_url":"https://api.github.com/users/birdspring/repos","events_url":"https://api.github.com/users/birdspring/events{/privacy}","received_events_url":"https://api.github.com/users/birdspring/received_events","type":"User","site_admin":false},"created_at":"2016-08-03T00:58:11Z","updated_at":"2016-08-03T00:58:11Z","body":"@mahedi0244  You could navigate to the database view and choose your objective database, then input your mysql root password correctly. Don't forget to click the \"test connection\" until it replies \"seems ok!\".\r\nIf that doesn't work,  change every table's owner(yourself) and load the examples and upgrade your db.\r\nHope these can help you."}}
{"actor":{"display_login":"birdspring"}}