search

veekun / pokedex

more than you ever wanted to know about Pokémon
MIT License
1.44k stars 637 forks source link

How do i export the data to a MySql Database? #175

Closed clinton2111 closed 8 years ago

clinton2111 commented 8 years ago

Hello, there first all thanks for all the time and effort to create something as amazing as this. I've followed all the instructions as you've said in this wiki https://github.com/veekun/pokedex/wiki/Getting-Data , but the issue is I cannot seem to get it to export to a MySQL database.Everytime i execute 'pokedex load -e mysqldb://root:@localhost/pokedex' I keep getting a 'Can't load plugin: sqlalchemy.dialects:mysqldb' . My PHPMyAdmin doesn't have a password as I'm just developing this on my local system as a fun project.I have installed the mysqldb plugin and the code exports fine to SQLite. Any help is gratefully accepted.

clinton2111 commented 8 years ago

After a little more 'googling' I found out that the proper syntax is 'pokedex load -e mysql+mysqldb://username:password@host/database'. A noob mistake I'm sure. But thanks again for the awesome dataset :)