mysql backup

mysql workbench,


1)  Not on top menu, but on left side bar, click data export,


2) each time, choose only one database,


3) choose export to self-contained file, put file name there



To import,

1)  Not on top menu, but on left side bar, click data import/restore

2)  Choose import from self-contained file,

3) default target schema, choose your database name, if not exist, you can click new button to create one.