Python Scrapy Tutorial - 17 - Storing data in MySQL Database
n this video we are going to learn how to store our scraped data inside a MySQL database. Now before watching this video make sure that you have watched previous two videos in which we cover how to store data inside an sqlite database because a lot of the concepts that I teach in those videos are going to be used in this video. And I don't want to go over them again.
Now the first thing we need to do is install MySQL on our computer. You can go to this link if you are on windows to install MySQL. But if you are using Linux you can check this link out to install and use MySQL. I am going to covering only the windows part of installation because the Linux installation is pretty easy.
Now just click on this link to start the installation. I am going through this installation pretty quickly because it's simple. While installing make sure that you choose the developer's default option because we want everything installed on our computer including Connectors, routers, servers and MySQL Work Bench which is a GUI software to connect and handle various connections.
Also when you are asked to choose the root password. You can choose whatever you want but make sure that you remember the root password because we are going to be using the same password everywhere. If you forget this password it's going to be difficult to reset it.
Steps -
1) Install MySQL https://dev.mysql.com/downloads/insta...
Linux - https://support.rackspace.com/how-to/...
Make sure you go with default options.
Remember the root password
2) Install MySQL-connector-python
2) Create a new connection using Mysql workbench
3) Create a new database myquotes using SQL workbench
4) Write the code in Pipelines
5) Scrape the data
6) Show the data in SQL Workbench
Next video - Storing data in a MongoDB database
• Python Scrapy Tutorial - 18 - Storing...
Full playlist - • Python Web Scraping & Crawling using ...
Subscribe - / @buildwithpython
Website - www.buildwithpython.com
Instagram - / buildwithpython
#python