Backup in MySQL WorkBench

6

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!

    
asked by anonymous 28.04.2015 / 20:06

1 answer

5

Go to the menu Server , Data Export .

InObjectSelection,selectthebankyouwanttoBkpfrom.UnderOptions,selecttheoptionyouwanttosave:ExporttoDumporExporttoSelf-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

    
28.04.2015 / 20:35