Copy Database

I have a database on my tower that I need to try to copy to my laptop. I have mysql workbench on both machines. Any way to copy the entire scheme from the tower to the laptop?

use mysqldump to create an sql backup

then run the sql into your target database

Thanks r937, this was the first time I’ve needed to do this. I figured it out using the admin options in Mysql workbench.

Damn why don’t I think of stuff like that…backup and install from backup on new db…

Good stuff.