Skip to content
Snippets Groups Projects
Select Git revision
2 results Searching

introduction-to-data-visualization-and-analysis

Bouyahya Zied's avatar
Bouyahya Zied authored
a23b624b
History

To work with remote relational databases

https://relational.fel.cvut.cz/

. Download and Install MySQL Workbench

visit https://relational.fel.cvut.cz/ -> Browse datasets Choose any of the datasets (e.g. Imdb) In MySQL WorkBench, create a new connection Use following credentials:

  • hostname: relational.fel.cvut.cz
  • port: 3306
  • username: guest
  • password: ctu-relational

How to Import the AIRPORT_DB into MySQL Workbench

  1. Download MySQL Community Server from the official MySQL website: https://dev.mysql.com/downloads/mysql/. You can follow the instructions from this link https://www.geeksforgeeks.org/how-to-install-mysql-on-macos/

  2. Download and Install MySQL Workbench

  3. Download and Unzip AIRPORT_DB.zip

    • Extract the contents of the AIRPORT_DB.zip file to a convenient location on your computer.
  4. Open the Data Import Tool

    • Launch MySQL Workbench.
    • Navigate to the Administration panel.
    • Click on Data Import/Restore.
  5. Set the Import Options

    • Under Import Options, select Import from Dump Project Folder.
    • Browse and select the unzipped AIRPORT_DB folder.
  6. Create a Default Target Schema

    • Create a new schema (database) by clicking the New Schema button.
    • Set this new schema as the Default Target Schema.
  7. Select the Import Type

    • Choose Dump Structure and Data to import both the database schema and the data.
  8. Start the Import Process

    • Click Start Import to begin the process.
    • Wait for the import to complete, and verify that all tables and data have been imported successfully.