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
Author by
holyredbeard
Updated on June 05, 2022Comments
-
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!