To work with remote relational databases

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

. Download and Install MySQL Workbench

• Download MySQL Workbench from the official website:
  https://dev.mysql.com/downloads/workbench/
• Follow the installation instructions for your operating system.

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

   • Download MySQL Workbench from the official website:
     https://dev.mysql.com/downloads/workbench/
   • Follow the installation instructions for your operating system.

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.