Forum Discussion

LB-Tech's avatar
LB-Tech
Helper I
1 year ago

Restoration of data dump

Hi,
I have a backup file dump MYSQL Administrator dump 1.4 so in which db can I restore this dump.
I cannot do in mysql workbench and not either in SSMS also so lease suggest me some other DB to restore this data dump.

SQL database

3 Replies

  • Anonymous's avatar
    Anonymous
    Not applicable
    1 year ago

    Hi  LB-Tech ,

     

    Azure Database for MySQL is a managed database service that supports MySQL databases. You may try as follows to restore your dump file:

    1. Create an Azure Database for MySQL instance:

      • Go to the Azure portal and create a new Azure Database for MySQL instance.
      • Configure the necessary settings such as server name, resource group, and pricing tier.

    2. Upload your dump file:

      • Use Azure Storage to upload your dump file. You can use Azure Blob Storage for this purpose.
      • Once uploaded, you can access the file from your Azure Database for MySQL instance.

    3. Restore the dump file:

      • Connect to your Azure Database for MySQL instance using a MySQL client such as MySQL Workbench or the MySQL command-line tool.
      • Use the mysql command to restore the dump file. For example: 
        mysql -h <your-server-name>.mysql.database.azure.com -u <your-username>@<your-server-name> -p <your-database-name> < <path-to-dump-file>

     

     

     

    Best regards.
    Community Support Team_Caitlyn

  • LB-Tech's avatar
    LB-Tech
    Helper I
    1 year ago

    Any other way without using azure databases for mysql?

  • StrahinjaRodic's avatar
    StrahinjaRodic
    Microsoft Employee
    1 year ago

    Hey, LB-Tech, would you like to restore MySQL dump into Microsoft Fabric or you had something else on your mind here?