Free mysql administrator backup software for linux

MySQL Administrator is a powerful visual administration console that enables you to easily administer your MySQL environment and gain significantly better visibility into how your databases are operating.
MySQL Administrator now integrates database management and maintenance into a single, seamless environment, with a clear and intuitive graphical user interface.
By using MySQL Administrator you will be able to:
- Achieve higher database availability through improved management
- Reduce errors through visual database administration
- Lower database administration costs through improved productivity
- Deliver a more secure environment through easier privilege management
MySQL Administrator enables developers and DBAs to easily perform all the command line operations visually including configuring servers, administering users, and dynamically monitoring database health.
Other common administrative tasks such as monitoring replication status, backup and restore, and viewing logs can also be performed through the MySQL Administrator graphical console.
User Administration in Minutes
Administering users, granting privileges and viewing user privilege information has never been easier! Now you can leverage the full power of MySQLs user management and privilege capabilities to fully protect your MySQL server host using an integrated graphical user administration console.
For example, a form-based interface provides a simple method for adding users, assigning passwords and including user profile information. Plus, assigning and revoking global, database, and table/column privileges is as easy as adding and removing privilege items from an available list. Finally, an explorer interface provides a hierarchical view allowing you to easily view user privileges by privilege type.
Single View Dynamic Health Monitoring
Dynamic health monitoring gives you an immediate view into the key indicators of the health of your MySQL environment. Dynamic graphs enable you to easily view percentage of memory usage, connection usage, hit rates, as well as the number of SQL queries on an ongoing basis, as your system runs.
The Disk Health tab gives you an overview of the amount of hard disk space, tablespace, and log files being used. You can also use the visual health monitoring feature to get a hierarchical view into status and server variables such as the number of outstanding connections, number of bytes sent and received by clients, buffer allocations size and more.
Quickly Optimize MySQL
MySQL Administrator now allows you to easily view and setup key parameters so you can quickly optimize the performance of MySQL. Using a graphical forms-based environment, you quickly fine tune general and advanced parameters. For example you can set memory usage parameters and configure server start-up parameters related to the MyISAM and InnoDB table types.
Rapid Disaster Prevention and Recovery
Now you can rapidly create consistent backups and restore data by simply visually selecting the schemas and tables you want to back/restore from your hierarchical data directory. The graphical environment gives you additional visibility into Tabletype, Rows, Data Length, and Update time.
Server Information At-a-Glance
The server information section of MySQL Administrator allows you to quickly view basic information about the server and client. This view gives you immediate visibility into items such as server status, client and server version numbers and IP address, as well as connection information.
View Replication Status
Now you can quickly set up replication to increase the robustness and speed of your MySQL environment. The replication features within MySQL Administrator allow you to easily view the network topology of your replication master and slaves. Plus, the graphical environment provides additional visibility into IP addresses and logfiles.
View Server Logs from a Centralized Administration Environment
Now you can view all the MySQL log files including error logs, binary logs, and InnoDB logs from a single, centralized administration environment so you can diagnose server problems quicker and track database changes.
Service Control
Gain complete control of service creation and overcome the time consuming task of installing and setting up services. Plus, start and stop MySQL servers and view corresponding log messages.
Browse Catalog
Browse your catalog and view corresponding tables with columns, all indices and users with privileges to access selected databases. From here you can monitor and optimize tables.
Cross Platform
MySQL Administrator will initially be available for Microsoft Windows and Linux, and be compatible with MySQL version 4.0 or later.

Virtual Administrator Daemon is set of Perl scripts and modules which can help with remote server management. It uses XML input/otput, and can be run by (x)inetd.
It can receive multiple commands to execute, and it has been built to provide support for a scalable system administration environment.
Since it takes XML, clients can be developed in a different set of environments with easy integration into the server.
Enhancements:
- This release added support for standalone/daemon mode, SSL support and a default SSL certificate, a default timeout of 30 seconds while reading or writing sockets, more refined log messages, and new < mode >< /mode >, < ip >< /ip >, < port >< /port >, and < listen >< /listen > configuration elements.

Mysql Assistant is a MySQL viewer. Mysql Assistant requires Ruby-Gtk2 and MySQL/Ruby.

Myassistant is a MySQL viewer using, Ruby, Ruby-Gtk2, MySQL/Ruby and developed on ruby-1.8.4, Mysql-5.0.16, mysql-ruby-2.7, ruby-gtk2-0.14.1.

Currently 3 APIs are provided for MySQL, MySQL/Ruby, Ruby/MySQL, and DBI.
These are 3 different APIs, Please install proper one.

Installation:

untar package anywhere you want.

Security Issue

Myassistant create ".mydb" file which includes "Mysql server name","user name",
"password","database name" with chmod 600 on your home directory.
It could be your security hole, so please notice that.

Fonts

Currently default font is "Sans 12". If you want change it, edit row number 91.

If you have any questions or problems, please let me know.

Magic Mirror Backup works by copying the files and folders on your computer to other computers within your office. In exchange, these other computers also copy their own files onto your computer.
This sharing of backups has quite a few advantages not the least of which are that it is extremely convenient and cost effective. (This symbiotic mechanism for backing up data is often called peer to peer backup or p2p backup.)
There is also an optional off-site component so that you can additionally backup to a remote server to protect against office-wide failures like fire, theft, or hurricanes.
Main features:
- It works with your existing hardware requiring no new hardware investment and providing greater value for your existing investment.
- It will work in conjunction with your existing backup strategy. If you make regular backups to external media, thats great. Use Magic Mirror Backup to add daily backup protection to your critical or frequently changing data.
- It is automatic - you do not need to worry about swapping tapes, Zip Disks, or CD-Rs.
Magic Mirror Backup works by copying the files and folders on your computer to other computers within your office. In exchange, these other computers also copy their own files onto your computer.
This sharing of backups has quite a few advantages not the least of which are that it is extremely convenient and cost effective. (This symbiotic mechanism for backing up data is often called peer to peer backup or p2p backup.)
Here are some of the commonly requested details on how Magic Mirror Backup works:
- Backups are password protected so that, when a password is specified, others in your office will not be able to read your files (without breaking into your account, which would require a great deal of technical expertise and hacking).
- Backups are only sent to computers you select - your backups will not be sent to computers that you have not authorized.
- You select the files and folders for backup. If you want to limit the size of the backups stored on the computers in your office, you can choose to only backup your "My Documents" and email folders, for instance. If, on the other hand, all the computers have plenty of free space, you can expand the backup to cover less critical files as well.

Large Database Backup is a PHP class can be used to backup large MySQL databases into multiple files.

It can list the tables of a given MySQL database and generate SQL statements to create and insert records with the current values of the table rows, as if it was creating a new database. The class stores the generated SQL statements in files.

A full backup process can be split in multiple iterations to not exceed PHP default script execution time limit. Each iteration dumps a limited number of table rows. An iteration can be executed by a script that redirects the page request to itself at the end to proceed to the next iteration.

MySQL Activity Report is a valuable database tuning aid.

The MySQL Activity Report package is a tool to help MySQL database administrators to collect several database parameters and variables. These collected values can be used for server monitoring or performance tuning purposes.

The most important component of the MySQL Activity Report is mysqlard. This daemon collects the data from a MySQL server and stores these values in a Round Robin Database.

The mysqlard package also contains example graphing, cron and php scripts. The cron scripts can be used to keep archives of the generated graphics and the php script shows the generated graphics and tries to give some tuning tips.

DYS Backup is just a small script to backup your system.
You can ajust it to your needs as you like. It is made for me, but you are free to use it in the terms of the GNU General Public License.
Enhancements:
- Backups can be rotated and timestamped.
- Self encryption with GPG can be done.
- Pre and post script functions can be used.
- Package data was added for Red Hat/Fedora.
- Conditional compression of encryption is used.
- The user may choose between bzip2 and gzip.