topic Re: Restoration of data dump in SQL database

Restoration of data dump

LB-Tech — Thu, 02 Jan 2025 09:05:04 GMT

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.

Re: Restoration of data dump

Anonymous — Fri, 03 Jan 2025 01:39:14 GMT

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:

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.
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.
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

Re: Restoration of data dump

LB-Tech — Fri, 03 Jan 2025 05:36:57 GMT

Any other way without using azure databases for mysql?

Re: Restoration of data dump

StrahinjaRodic — Tue, 11 Mar 2025 15:03:15 GMT

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