"az mysql flexible-server import create" - InvalidImportSourceDetails from Azure blob

[geremy42]

Describe the bug

I need to migrate multiple onprem mysql databases to Azure Database for MySQL flexible server.
The dumps (corresponding to .sql script files) are then stored in an Azure Storage account.

The storage account allows public access without any restriction. Regarding authentication, the command is run with my personal account, granted as "Storage Blob Data Contributor".

I got 'Import source storage is not accessible.' error during provisioning without any more information

Related command

az mysql flexible-server import create -g rsg-test -n mysql02 --version 8.0.21 --sku-name Standard_D4ds_v4 --tier GeneralPurpose --location francecentral --public-access 0.0.0.0 --storage-size 200 --storage-auto-grow Enabled --data-source-type azure_blob --data-source https://storagemysql.blob.core.windows.net/dumps --admin-user "username" --admin-password "password"

Errors

Checking the existence of the resource group 'rsg-test'...
Resource group 'rsg-test' exists ? : True
IOPS is 900 which is either your input or free(maximum) IOPS supported for your storage size and SKU.
Creating MySQL Server 'mysql02' in group 'rsg-test'...
Your server 'mysql02' is using sku 'Standard_D4ds_v4' (Paid Tier). Please refer to https://aka.ms/mysql-pricing for pricing details
(InvalidImportSourceDetails) Import source details provided are not valid for import from storage. Error details: 'Import source storage is not accessible.'.
Code: InvalidImportSourceDetails
Message: Import source details provided are not valid for import from storage. Error details: 'Import source storage is not accessible.'.

Issue script & Debug output

(InvalidImportSourceDetails) Import source details provided are not valid for import from storage. Error details: 'Import source storage is not accessible.'.
Code: InvalidImportSourceDetails
Message: Import source details provided are not valid for import from storage. Error details: 'Import source storage is not accessible.'.

Expected behavior

The Azure Flexible MySQL server is provisionned and filled with mysql databases dumps stored in a container from an Azure storage account.

Environment Summary

"azure-cli": "2.71.0",
"azure-cli-core": "2.71.0",
"azure-cli-telemetry": "1.1.0",
"extensions": {
"aks-preview": "0.5.121",
"azure-devops": "0.25.0",
"azure-firewall": "0.14.4",
"communication": "1.11.1",
"containerapp": "1.0.0b4",
"maintenance": "1.3.0"

Additional context

No response

[yonzhan]

Thank you for opening this issue, we will look into it.

[microsoft-github-policy-service]

Thanks for the feedback! We are routing this to the appropriate team for follow-up. cc @ambhatna, @savjani.

[sivasam-MSFT]

Hi @geremy42,

The import command from blob storage requires some pre-checks and steps. All the steps to use the command are listed in the below article.
https://learn.microsoft.com/en-us/azure/mysql/migrate/migrate-external-mysql-import-cli

If you intend to import the onprem mysql using the dumps files, then please follow the steps listed in the below article.

https://learn.microsoft.com/en-us/azure/mysql/migrate/mysql-on-premises-azure-db/05-migration-methods

Regards
Siva