Mysql Administrator Windows

  1. Install Mysql Administrator Windows
  2. Mysql Administrator Windows 7 64 Bit

Supported platforms: Microsoft Windows, Mac OS X and Linux. MySQL Workbench is a visual database design tool that integrates SQL development, administration, database design, creation and maintenance into a single development environment. It is the successor to DBDesigner 4 from fabFORCE.net and replaces the MySQL GUI Tools Bundle. Jul 26, 2006  Download MySQL Administrator 1.1. Visually manage your MySQL database server. MySQL Administrator is a phenomenal utility that allows you to visually manage a MySQL server. You will no longer depend on phpMyAdmin to work with MySQL. This program integrates database administration and maintenance into.

MySQL Administrator Review

MySQL Administrator is a phenomenal utility that allows you to visually manage a MySQL server.

You will no longer depend on phpMyAdmin to work with MySQL. This program integrates database administration and maintenance into one interface.

With this program you can easily do everything that you used to do by entering the code by hand: server configuration, user admin, table creation and search, etc.

Also, with MySQL Administrator you can be always informed on the health of your server, how much it's being used, as well as its performance. If your performance is low, you can improve it by using the optimization options.

This program has tons of configuration options that you have to become familiar with that deal with aspects such as security, activity log, backups, etc.

Visit MySQL Administrator site and Download MySQL Administrator Latest Version!

Windows

Files which can be opened by MySQL Administrator

To learn what file types can be opened by MySQL Administrator please visit WikiExt.com. WikiExt monitors and provides timely updates for its database in order to have up-to-date information and the latest programs for opening any file types at all times.

Why Download MySQL Administrator using YepDownload?

  • MySQL Administrator Simple & Fast Download!
  • Works with All Windows (64/32 bit) versions!
  • MySQL Administrator Latest Version!
  • Fully compatible with Windows 10

Disclaimer

MySQL Administrator is a product developed by MySQL AB. This site is not directly affiliated with MySQL AB. All trademarks, registered trademarks, product names and company names or logos mentioned herein are the property of their respective owners.
Active2 years, 7 months ago

My question is a bit specific, but I hope someone has experience with the issue.

I'm running a Windows 2008 server with MySql for Windows installed it. It's MySql 5.2 and that package contains 'MySql Administrator'. There you can make backups of a specific database. When I configure the backups and also say that it needs to be done daily around 3 am in the morning, it doesn't work automatically. It's only when I press 'Execute backup now' that I get to save the .SQL file and then the backup itselve works fine. When I ask it to fire automatically nothing is created and not even a log file is being made. I've checked the rights on the selected folder and i've added the user 'Everyone' with all rights to rule out any permission issues. No effect.

I've been Googling for day's and I can't find a solution for this. Does anyone know why my automated backup via the MySQL administrator is not working on MS Windows 2008 and why it isn't even creating a log file?

NehburNehbur

7 Answers

CREATE A USER WITH MINIMUM PERMISSION

CREATE A BATCH FILE LIKE FOLLOWING AND SCHEDULE IT*This will backup file in specified path with db name + date and time*

SerjikSerjik
5,7266 gold badges45 silver badges61 bronze badges

I tried also using version 1.2.17 with win 7. I faced the same problem.MySQL ADMIN is scheduling the backup via the windows scheduler. I realy don't know why but when i scheduled the backup(when i SAVE the new created project) under a user with an ADMIN account it didn't operate. When i scheduled the backup under a standard ACCOUNT it operated fine. to solve this problem i defined a new standard account in WIN 7 . I am logging to win 7 under my primary account and scheduling the backup under the new account . Now it works fine .

elieli

I got Solution , When you create schedule backup that time MySQL Administrator take information your system username and password. That time give proper system username and password

Amit Vaghela
18.5k16 gold badges61 silver badges117 bronze badges
Hitendra DeriyaHitendra Deriya

I guess it might be associated with windows 'cron' jobs. Anyway, this do the trick for me:

Of course you have to do everything by hand but is also better. I got this same issue in PostgreSQL because o windows 'at' is different from linux 'cron'. Since than, I started to do my own 'cron' jobs.

Also check this:http://kedar.nitty-witty.com/blog/scheduled-backup-mysql-administrator-windows-scheduler-odd

Hope it helps! :)

Mário RodriguesMário Rodrigues

I'll post what are my findings for other people to enjoy.

I didn't get the MySQL Administrator backup function to work automatically, instead I used the suggestion of @mOrSa

My findings are these:I've made a batch file using this code:

This makes an .SQL file within the chosen folder with the name format being 'backup_20110825_14:54.sql'. It also deletes all files older than 7 day's in that folder. I have Windows Server 2008, so the file 'forfiles.exe' is standard installed within the system32 folder. If you don't have that program, you can download it somewhere for free.

After that I've set a scheduled task running this batch file in the Windows Task Scheduler. Make sure you have given the appropriate rights in the schedular. It's executed daily.

NehburNehbur

Install Mysql Administrator Windows

The simple trick is to create a stored connection (tested on both Win7 and Win2008 with MySQL Administrator 1.2.17 can download it from here, it's among MySQL GUI tools).

  1. Open MySQL Administrator, then go in menu Tools > Options

  2. In the pop up windows select 'Connection' on the left and hit the button 'NewConnection'.

  3. Fill in your connection values: username, password,host... and Save it.

  4. Close MySQL Administartor and re-open it, butthis time connect by selecting the new stored connection you justcreated on step (3) from the select list (the select list is the 1st field in the login window)

  5. Now you can create a backup and schedule it, and the schedule will work like a charm.

Marco DemaioMarco Demaio
20.8k31 gold badges112 silver badges148 bronze badges

I know it's a old problem but I had the same problem in recent days and searching solutions I couldn't find how to fix my problem but I found some information in my event logs and I remembered I had another connection (obviously, event logs show me that) so I made new connection with the same name which event logs show me and voila, problem fixed.

halfer
15.3k7 gold badges63 silver badges129 bronze badges
Administrator
DanielDaniel

Mysql Administrator Windows 7 64 Bit

Not the answer you're looking for? Browse other questions tagged mysqlwindowsmysqladministrator or ask your own question.