mysql workbench tutorials (Sql Development , modelling, server admin export & import)

mysql workbench

3 modules

1.SQL development

2.SQL modelling existing database .. new

3. Server administration (import export change etc)

Migration wizard as same.

Table of Contents

SQL development module.

easy to run queries, create tables, columns etc

visually creating a database (later you can sae it as image , it’s fun to use sql modelling to create databases)

exporting to server by forward engineering.

editing database of server by reverse engineering.

Fine tuning server from desktop

Checking error logs

database import & exports

Step 1: connect to server with mysql root user Password

step 2: click on database export & restoration

#alter the tables modify etc.

#backup a single database or table.

to import

open MySQL dump file ends with .SQL

to export

All databases and & tables listed same as in server.

click on Export

save the path as new database.sql

by default all tables & dbs selected

(you can skip the tables bulk and

add some database tables tables to export.

Select only the required or database tables.

Click finally export.

import new required database to remote server using mysql workbench.

mysql workbench model to sql

export tables from mysql workbench

Prerequisites to run MySQL workbench

Microsoft visual c++ 2019 redistributable