Categories
Data Science Programming SQL

How to import data from MySQL database into Pandas Data Frame

It is easy to load CSV data into Python’s Pandas Data Frame. I always think this is also the case for loading MySQL into Data Frame.¬†However, it turns out to be quite troublesome.

Categories
Programming SQL

[MySQL] Reset & Import Database in MySQL using Command Line

Sometimes client’s server doesn’t has PHPMyAdmin installed (and it is 11MB, too big in my opinion), and I have to import database to deploy website from localhost to production server. Thus, I need to find a way to import SQL file directly in command line.