Skip to content

Latest commit

 

History

History
15 lines (11 loc) · 908 Bytes

README.md

File metadata and controls

15 lines (11 loc) · 908 Bytes

Importing PATSTAT 2024b into MySQL

Imports the European Patent Office (EPO) 2024b database PATSTAT (https://www.epo.org/en/searching-for-patents/business/patstat) into MySQL.

Instructions

  • Unzip every tlsXXX_partYY.zip found in the PATSTAT archives into a single folder.
  • Run 01_create_DB_and_tables.sql to create the database and tables.
  • Open 02_import_data_files.sql and change the SET PATH TO DATA FOLDER chunk to the directory containing the unzipped PATSTAT csv files. you may want to uncomment some of the sections in this code.
  • Run 02_import_data_files.sql to import the data. This may take some time. You may want to comment out unneeded tables.
  • Run 03_row_counts.sql to check if the row counts match the ones reported by PATSTAT.
  • Run 04_indexation.sql to create indices. You may want to modify this according to your own needs.