MYSQL restore DB

Question

while restoring my DB using MYSQL workbench it creates my_row_number on the tables with AI PK, I need to stop the auto creation since causing issues in my API. If I restore the DB locally works fine only while restoring it on azure

Answer 1

@Ali Jabak From what I understand that the auto-creation of my_row_number during the MYSQL database restore is causing issues with your API.

This seems to be a specific behavior of MYSQL Workbench when interacting with server.

 To prevent the auto-creation of my_row_number, you can try the following steps:

·     Before initiating the restore process, ensure that the AUTO_INCREMENT attribute is not set for the Auto Increment PK columns in the dump file.

• Check the MYSQL Workbench preferences and settings for any options that might influence this behavior and adjust them accordingly.   MySQL :: MySQL Workbench Manual :: 3.2.2 SQL Editor Preferences
• Consider using MYSQL command-line tools for the restore operation, as it might offer more control over the process.

I hope this information helps.

Regards

Geetha