filmov
tv
MySQL : Backup MySQL database structure using workbench

Показать описание
How to backup the MySQL database Metadata ( structure) via MySQL Workbench in .sql format
************************************************************************************
Prerequisites :
MYSQL workbench installed locally
MYSQL server installed on a remote linux server (192.168.1.51)
previldeged user ( mysqlbackup51 ) already created and priv to take backup of all schema and objects.
Connect mysql servers via MYSQL WORKBENCH ( MYSQL Connection created )
***********************************************************************
IP userid password
************************************************************************************
Prerequisites :
MYSQL workbench installed locally
MYSQL server installed on a remote linux server (192.168.1.51)
previldeged user ( mysqlbackup51 ) already created and priv to take backup of all schema and objects.
Connect mysql servers via MYSQL WORKBENCH ( MYSQL Connection created )
***********************************************************************
IP userid password