How do you take a Full back up in MySQL (as like in SQL server via SSMS)

Hello:
I just need to take a one time Full bakcup of a MySQL database. I dont know PHP and Linux or all the there LAMP stack utilities.
I am a SQL server DBA and just needs to ensure I back up a small database in MySQL workbench.

Is there any gui inteface to take that small backup?
I looked up online and many suggestions go to the route of PHP and other command line ways, but I am looking for a gui from the Workbench, something like r-click , tasks, bakcup (like in SSMS)

Thank you.
noamco36Asked:
Who is Participating?

[Product update] Infrastructure Analysis Tool is now available with Business Accounts.Learn More

x
I wear a lot of hats...

"The solutions and answers provided on Experts Exchange have been extremely helpful to me over the last few years. I wear a lot of hats - Developer, Database Administrator, Help Desk, etc., so I know a lot of things but not a lot about one thing. Experts Exchange gives me answers from people who do know a lot about one thing, in a easy to use platform." -Todd S.

gnemiCommented:
from shell:
mysqldump -u user -p -A > server_dump.sql

to restore:
mysql -u user -p -A < server_dump.sql

For doing the backup in workbench:

http://database.blogs.webucator.com/2010/11/05/creating-database-backups-in-mysql-workbench/
0
noamco36Author Commented:
thank you,
I tried the workbench link and done the export.
after it finished I opened the file location and I see all the backed up "MySQL" tables in a (.sql) format! When I double click on them, SQLserver opens with the query window of that backup. does that make sense?! They should really open with Mysql.




thanks.
0
gnemiCommented:
.sql can be opened by either

You likely have the default application for .sql set to SQLserver.

You can import by selecting the 'Import from Disk' tab in the data dump section of workbench.
0

Experts Exchange Solution brought to you by

Your issues matter to us.

Facing a tech roadblock? Get the help and guidance you need from experienced professionals who care. Ask your question anytime, anywhere, with no hassle.

Start your 7-day free trial
It's more than this solution.Get answers and train to solve all your tech problems - anytime, anywhere.Try it for free Edge Out The Competitionfor your dream job with proven skills and certifications.Get started today Stand Outas the employee with proven skills.Start learning today for free Move Your Career Forwardwith certification training in the latest technologies.Start your trial today
MySQL Server

From novice to tech pro — start learning today.