none
restoration of backup from non azure SQL database RRS feed

  • Question

  • we have database  on Axure which we have successfully replicated schema from our previous server now we want to restore data over it script is too long we cant run it in console or either in management studio further in your console we dint find any option for restoring database backups by uploading dump files please guide us we need to fix it on ASAP basis we are on restrict deadlines would be great if you guys do it on our behalf and let us know the process for future
    Saturday, November 30, 2019 9:37 PM

All replies

  • Hello sohaib6030,

    Welcome to the MSDN Forums and thank you for your interest in Azure Database for MySQL

    You can use MySQL utilities such as mysqldump and mysqlpump to dump and load databases into an Azure MySQL Database.

    Please check this document for instructions on using Import and Export techniques 

    For complete, Step-by-step guidance please see this link

    -

    If this answers your query, do click “Mark as Answer” and Up-Vote for the same which might be beneficial to other community members reading this thread .

    And, if you have any further query do let us know. 

    Monday, December 2, 2019 3:49 AM
    Moderator
  • Hi Sohaib6030,

    We are not in a capacity to directly complete this type of work for you. You can, however, engage a 3rd party technology practice that can complete this work on your behalf. If there is some help that you require to step through the information that Kalyan has provided, I could help you.

    You can use mysqldump to upload and write to your Azure Database for MySQL instance. If there is a requirement to upload to Azure, you can accomplish this by uploading data to an Azure Storage account and then access this via an Azure Portal utilities, if you are using the portal to complete your tasks. I was unable to get clear instructions from your question to understand what is being attempted.

    Regards,

    Mike

    Tuesday, December 3, 2019 7:43 PM
    Moderator
  •  

    Just checking in to see if the above answer(s) helped.

     

    If this answers your query, do click “Mark as Answer” and Up-Vote for the same which might be beneficial to other community members reading this thread .

    And, if you have any further query do let us know. 

    Friday, December 6, 2019 9:17 AM
    Moderator