Menu
I'm using mysql workbench to try and migrate from 1 mysql database on my VPS to another on my DS; However the database names are different and I cannot change the database names due to restrictions.
When trying to migrate from the VPS to the DS I get an error because the two database names are different.
Is it possible in mysql workbench to set this up correctly as I can't seem to find it.
453
To copy a MySQL database from a server to another, you use the following steps: Export the database on the source server to a SQL dump file. Copy the SQL dump file to the destination server. Import the SQL dump file to the destination server.
List item First, create a new database using CREATE DATABASE statement. Second, export all the database objects and data of the database from which you want to copy using mysqldump tool. Third, import the SQL dump file into the new database.
Yes, you can do it in manual editing step. From view combobox select All Objects, then double click on target schema name and rename it.
89
If you love us? You can donate to us via Paypal or buy me a coffee so we can maintain and grow! Thank you!
Donate Us With
