Creating backup of database in Query Browser

Question

I want to create a backup of my mysql database that's created in Query Browser, but I just can't figure out how.

This isn't about setting up automatic backup of the db, it's about saving the whole database to a file, so that I can send it to a friend who needs to have look at it (it's only local access so far).

What I have found so far on the net is that I should click Tools -> MySQL Administrator. The problem is that MySQL Administrator is greyed out and unclickable. So, is it the right way to go through MySQL Administrator and if so, how can I make it clickable?

Thanks in advance!

You can create backup through query. And that way you could do that against a button click in c#, java or php etc... I have done it for backing up data and can guide you for full db backup as well — Sami
– Sami, Commented Sep 25, 2012 at 18:27

juergen d · Accepted Answer · 2012-03-11 20:59:48Z

8

You don't need the query browser to backup your DB. Use MySQL Dump:

mysqldump -u root -p dbname > outfile.sql

answered Mar 11, 2012 at 20:59

juergen d

205k40 gold badges303 silver badges377 bronze badges

Sign up to request clarification or add additional context in comments.

Collectives™ on Stack Overflow

Creating backup of database in Query Browser

1 Answer 1

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Related