I need to make a modification to the database. I would like to know how to back up MySQL WorkBench, and how do I restore it in case of errors.
Also if possible I would like some good habits tips to accomplish this kind of task, and some tips!
I need to make a modification to the database. I would like to know how to back up MySQL WorkBench, and how do I restore it in case of errors.
Also if possible I would like some good habits tips to accomplish this kind of task, and some tips!
Go to the menu Server
, Data Export
.
InObjectSelection
,selectthebankyouwanttoBkpfrom.UnderOptions,selecttheoptionyouwanttosave:ExporttoDump
orExporttoSelf-ConteinedFile
.SelectthepathyouwantandclickStartExport.
For you to import, select Data Import
from the menu.
Select the type of import and the path where you saved the file .sql
Select the DB where you want to restore and click on Start Import