|
|
| Home->Business & Finance->Database->Mysql Data Manager |
 Mysql Data Manager  ($37.00)  (0.080MB)
|
 Description:
The program is intended to remotely manage mysql databases and user access over the Internet using web browser based interface. Mysql Data Manager is an ALL-INCLUSIVE web based mysql front end with a powerful interface for management, development and support of databases on the web.
THE PROGRAM INCORPORATES THE FOLLOWING MAIN FUNCTIONS:
SQL SCRIPTING
CREATE AND ALTER TABLES
SEARCH RECORD
IMPORT DATA
EXPORT DATA
ADMIN FUNCTIONS
ACCESS MANAGEMENT
BACKUP
RESTORE
EDIT DATA
PRINT DATA
DATA DICTIONARY
VIEW/EDIT FILES
WHO ARE THE PROGRAM USERS:
Those who have a web site with MYSQL or need to manage MYSQL on the web.
ADVANTAGES:
Easy installation. You don't need to be root user in order install and run this Mysql Client. Only single file must be uploaded. Setup is done using visual interface.
Easy in use. No programming skills are needed. Easy and intuitive interface.
Very high performance/cost ratio.
Platform independence. This is Perl Script.
Excellent reliability and efficiency. The program generates only pure HTML code. It does not use client side scripting and images. All you see on the screen is built from standard HTML elements. That means also compatibility with all web browsers, higher rate of page downloading and lower traffic.
Ability to operate in multi-user environment as universal control panel for wide range of database applications and services.
Local connection to databases located on the remote server. Global access over the Internet.
MAIN FEATURES:
Create and alter tables and indices.
IMPORT data from text files generated by other applications.
EXPORT query and search results and entire table into text files to use with other applications.
User account management allows to create new accounts, grant and revoke privileges on multiple user accounts on any number of objects: databases, tables and columns.
A variable `{user}' can be used in database name to be substituted with user name for each account.
Search records using multiple search criteria.
User can define columns and number of records per page to be displayed and a column to order by.
Any number of resulting records can be edited or deleted.
Two ways to edit data:
- Editing of selected records from search result (unquoted expressions are supported), directly or by uploading file from local computer.
- Editing in spreadsheets using 'Update' function.
In both cases all data types are supported.
Two ways to insert data:
- Using 'Insert' or 'Search/Modify' function (unquoted expressions are supported), directly or by uploading file from local computer.
- Using 'Update' function.
All data types are supported.
Compose "SELECT" query, joining several tables.
Generate Printable Output.
Output compatibility with Microsoft Office programs (MS Excel, MS Word, etc.)
Create, save and edit SQL scripts containing multiple queries, and use them as Shortcuts.
Backup and Restore facilities:
- Create, save, download, upload, preview and execute backup files in either plain text or compressed format.
- You can choose to include into backup file only table structure or only data or both.
- Compressing of saved backup files using either zip or gzip.
Provide each user with dedicated subdirectory for storing of backup files and SQL scripts.
Mysql GUI allows to assign maximum total size of the saved backup files and SQL scripts per user.
Customize `look and feel'
Setting up using visual interface .
SYSTEM/SOFTWARE REQUIREMENTS (SERVER):
Any web server.
Perl 5.
Perl modules: DBI, DBD::mysql.
Optionally: zip and gzip utilities.
SYSTEM/SOFTWARE REQUIREMENTS (CLIENT):
Any web browser configured to enable cookie.
Editor's Rating:
|
|
|
All the Soft - Software Downloads