Back up Database

Introduction

This topic describes how to back up database with MySQL.

•Open command line box (Start > Run > enter cmd and press OK button)

•Enter one of following command depending of your configuration (we assume version 8.0 is installed):

cd "C:\Program Files\MySQL\MySQL Server 8.0\bin\"

cd "C:\Program Files (x86)\MySQL\MySQL Server 8.0\bin\"

•Enter following command:

mysqldump [databasename] --opt --user [username] --password="[password]" > [backupfile.sql]

[username] - this is your database username

[password] - this is your database password

[databasename] - the name of your database

[backupfile.sql] - the file to which the backup should be written.

example:

mysqldump dbipt_rc73_22813 --opt --user root --password="mypwd" > c:\dmp_dbipt_rc73_22813.sql

•Open MySQL Workbench

•Click Manage Import / Export under Server Administration on the right of the Workbench window.

•Click on Data Export on left side

•Select your database to export

•Select Export to Self-Contained File option

•Change path of sql script if needed.

•Press Start Export button