I used to use phpMyAdmin to manage my MySQL databases, but luckily I found SQLyog which is a fantastic database management tool.
It does all that you would want - backups/alter tables/manage data/copy tables to databases all within a lovely GUI interface.
It's one of the few pieces of software I've ever paid for, but it's been well worth the money.