How to copy or duplicate a database using MySQL Workbench 6.3 CE

How to copy or duplicate a database using MySQL Workbench 6.3 CE

[Anton]

Thank you very much!Very accessible explained.

[aldenbeats]

Thanks, very helpful! Just wanted to add - if you use a single self containing file, you only have to change the database name in one file. This simplifies the process for databases with a large number of tables.

[rootoxygen]

thanks a lot its the easiest way and the best way

[Paradize.]

Thank you so much, this helped a lot!
Thats exactly what i wanted to know! :]

[BappuDebNath]

Thanks a ton. I was looking for this for a long time.

[agitatedindians]

thank you very much, it really helped a

[kirruvreddy]

Is it possible to copy from one Server to another server all together? i.e Take the dump/export of a Database from one server & use the same .SQL dump file to load into a different server?

[noumab]

Choukrran ikteer , Thank you very much for all your explications :)
Great work ...Keep it UP ;)

[stefanmarjanovic]

Great work, thanks a lot! Keep it up :)

[AdarshSingh-mekf]

Not a good solution
What if I have 1000 tables ?

[vaiku]

Not good, imaging having sevral tables, good luck with that

[alhaadidol]

Thank you so much, this helped a lot!
Thats exactly what i wanted to know! :]