![]() ![]() Results: Following results are displayed:Ĭlick on finish button and you can see the copied database in your destination location. Copy Database: It will ask for the password, Enter the password and it will start copying database:ĥ. If there are some tables with MyISAM storage engine in your existing schema, you can transfer them to INNoDB by checking the checkbox at the bottom of the wizard as you can see in the screenshot. You can select all or one according to your requirements: Schema Selection: All the schema available on the source machine is displayed If the connection is successful, it will show Connection Succeeded message. You can test connection of both hosts by clicking on Test Connections button in the bottom left corner. If you want to copy the database from remote to your local then add the remote host in Source Connection and localhost in your Target Connection box. ![]() Connection Selection: Now select your source and destination location to copy database: You will see schema transfer wizard on your screen as below:Ģ. Select Database: Schema Transfer Wizard from the Mysql workbench menu bar.
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |