Creating backup of database in Query Browser

11,869

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

mysqldump -u root -p dbname > outfile.sql
Share:
11,869
holyredbeard
Author by

holyredbeard

Updated on June 05, 2022

Comments

  • holyredbeard
    holyredbeard almost 2 years

    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!