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
AIRPORT_DB
into MySQL Workbench
How to Import the -
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/
-
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.
- Download MySQL Workbench from the official website:
-
Download and Unzip
AIRPORT_DB.zip
- Extract the contents of the
AIRPORT_DB.zip
file to a convenient location on your computer.
- Extract the contents of the
-
Open the Data Import Tool
- Launch MySQL Workbench.
- Navigate to the Administration panel.
- Click on Data Import/Restore.
-
Set the Import Options
- Under Import Options, select Import from Dump Project Folder.
- Browse and select the unzipped
AIRPORT_DB
folder.
-
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.
-
Select the Import Type
- Choose Dump Structure and Data to import both the database schema and the data.
-
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.