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:

  1. Create new MySQL (clear-db) database as per your required pricing tier as described in this blog here.
  2. Download backup file .SQL from existing production database as described in this blog here.
  3. Restore MySQL database to new production database using the backup file .SQL downloaded from existing production database as described in this blog here.