MySQL/porting/data/mysql-admin

from HTYP, the free directory anyone can edit if they can prove to me that they're not a spambot
Jump to navigation Jump to search

MySQL Admin was a GUI utility which provided administrative functions for MySQL, with data operations being (iirc) handled by a separate GUI application. Both areas of functionality have now been rolled into MySQL Workbench, which is (iirc) proprietary freeware. There is at least one open-source package -- Beekeeper Studio -- which can provide the same functionality and is not limited to MySQL backends.

These specific instructions only apply to this obsolete software, but the general process remains similar on most tools.

Backing up

  1. Choose a place on your hard drive for storing the file; create any folders needed.
  2. Run mysql-admin (this can be done from the command line)
  3. Connect to mysql. You'll need the server address, a username with read permissions, and the password for that user.
    • Note: mysql-admin seems to have trouble actually using passwords you've stored, so you may have to type in the password each time. Hopefully they will fix this soon.
    • Another note: the current version of mysql-admin doesn't like connecting to mysql versions prior to 4.0, but it did connect and backup my v3.23. It appears prone to sudden crashing on certain operations, so avoid poking around in the menu while backing up or restoring.
  4. Press the "backup" icon/button on the left.
  5. Check the 'Add DROP TABLE' box on the "Output File Options" box on the "Advanced Options" tab, as with the phpmyadmin backup.
  6. Steps from that point on are pretty intuitive, except for the scheduler (which still has me confused). Apparently mysql-admin can set itself up to do backups automatically, using the cron scheduler, but this hasn't been working; at first glance, it looks like it could be a permissions problem. (If you retrieve email from your localhost POP3 server, you will see error messages from the cron scheduler if it couldn't run something it was supposed to run.)
  7. The first time through, you will probably want to save the backup configuration to a Backup Project, for quick reuse later. I had trouble once, however, with the "Backup Now" button greying out after doing this; I'm not sure what caused it.

Restoring

There's a "restore backup" button right under the "backup" button, and I presume the process is also fairly intuitive. Unfortunately, on my system (Ubuntu 4.x), pressing this button instantly causes mysql-admin to close, with no warning (presumably a crash/bug). This may be a problem with Ubuntu, as I have had similar problems with other applications that worked fine in other versions of Linux (I have not tried testing mysql-admin in other Linux distros). --Woozle 14:04, 8 May 2006 (EDT)

Retrieved from "https://htyp.org/mw/index.php?title=MySQL/porting/data/mysql-admin&oldid=28917"