Migrate mysql (cleardb) database manually in new azure portal
Thanks for taking time in reading this post. Today you will be learning how to migrate MySQL database manually in a Clear-db shared hosted server in new azure portal (https://portal.azure.com)
In order to complete this task, you need to have the following:
- I assume you already have an active azure subscription through which you can make service purchases such as clear-db MySQL databases. If you don't have one, you can sign up from here
Now, in order to migrate MySQL database:
- Create new MySQL (clear-db) database as per your required pricing tier as described in this blog here.
- Download backup file .SQL from existing production database as described in this blog here.
- Restore MySQL database to new production database using the backup file .SQL downloaded from existing production database as described in this blog here.