How to clone a database on the same server with a different name using MySQL Migration Wizard

In this video we will learn How to clone a database on the same server with a different name using mysql workbench - Migration Wizard.

What are the way to clone our database, so we have two option
Export & Import
Drawback : If you have to deal with a huge database you will have a very hard time with this procedure.

MySQL Workbench Migration Wizard
If you are migrating to another database in the same or different server the Migration approach of Workbench works best.

2:32 : STEP-1: Migration wizard Overview
This wizard is used to migrate tables, data from a supported database system. You can use this migration wizard to copy databases from one MySQL instance to another.

4:22 : STEP-2: Source & Target
In this step we will select our source and target database instance.

7:27 : STEP-3: Object Migration
In this step we have an option to select objects to be migrated. and to manually manipulate the database if required.

14:43 : STEP-4: Data Migration
In this step migration wizard will copy data from source database to target database.

15:54 : STEP-5: Report
In this step you will be presented a report page summarising the whole process of migration wizard.

💬 Leave your comments and doubts in the comment section
📌 Save this channel and video for watch later
👍 Like this video to show your support and love ❤️

***********
🤝 BE MY FRIEND

#MySql #Workbench #Migration #Copy

[businessmentorlife]

Thanks a lot! I finally get how to change the name of target database and tables on 12:14 😀👍

[NickMeisher]

Thank you. This worked. 12:14 is key point

[AshutoshKumar-kwmu]

I am not able to edit the target database/object name, for me source and target is coming as same. Am I missing something here.