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!
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.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?
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*
SerjikSerjikI 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 .
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 VaghelaI 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! :)
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.
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).
Open MySQL Administrator, then go in menu Tools > Options
In the pop up windows select 'Connection' on the left and hit the button 'NewConnection'.
Fill in your connection values: username, password,host... and Save it.
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)
Now you can create a backup and schedule it, and the schedule will work like a charm.
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