Remote DB Editor for MySQL

[bahattab]

Remote DB Editor for MySQL

http://www.atyafonline.com/vb/imgcache/1428.png Easy to use by graphical interface
Remote DB Editor for MySQL offers an intuitive interface for management of table contents, queries and for backup.

http://www.atyafonline.com/vb/imgcache/1428.png Databases and tables in a tree structure
For overview all databases and tables are displayed in a tree structure.
In addition the number of data records is displayed behind the table to make changes recognizable easily.

http://www.atyafonline.com/vb/imgcache/1428.png simultaneously management of several databases
You can create several database profiles and therefore manage numerous databases simultanously.

http://www.atyafonline.com/vb/imgcache/1428.png Access to every (!) MySQL database by HTTP (PHP script)
You can access every MySQL database on a web server.
For this purpose a PHP-script created by MySQL Remote Editor according to your instructions must be loaded to your web server.
You can customize a PHP-script to access several databases with only one script. Therefore it is not necessary to create several PHP-scripts for different databases.

http://www.atyafonline.com/vb/imgcache/1428.png Zipped and/or encrypted transmission
All data can be transmitted zipped. Thereby data transmission is quite speeded up.
Data can be sent to server encrypted (blowfish) for security reasons.

http://www.atyafonline.com/vb/imgcache/1428.png Easy and fast edit of table contents
Data is not edited in a table but in a form that is created automatically for every table.
Data (records) can be created, changed or deleted.
A data record doesn't have to be sent directly to server after every single change - like in a web browser- , but it is sent after finishing all changes within the data records.

http://www.atyafonline.com/vb/imgcache/1428.png Management of your SQL queries
Queries can be managed separately and they are displayed in a tree structure too.

http://www.atyafonline.com/vb/imgcache/1428.png Backup functions
Arbitrary backups of several tables can be created and restored in other databases when required.

http://www.atyafonline.com/vb/imgcache/1428.png System requirements
On client computer


http://www.atyafonline.com/vb/imgcache/1429.pngOperating system: Windows 95/98/ME or Windows NT 4.0/2000/XP


http://www.atyafonline.com/vb/imgcache/1429.pngVisual Basic 6 Runtime library (can be downloaded here)


http://www.atyafonline.com/vb/imgcache/1429.pngIf access shall occur by MySQL C- API "libmySQL.dll", the free file from MySQL-HP (http://www.mysql.com/) is required.


On web server

http://www.atyafonline.com/vb/imgcache/1429.pngPHP 3/4 (with mCrypt and zLib-library for encryption and compression)

http://www.atyafonline.com/vb/imgcache/1429.pngDatabase drivers (DAO,ODBC,etc) are not required

http://www.atyafonline.com/vb/imgcache/1428.png Prize
MySQL Remote Editor is distributed as shareware.
MySQL Remote Editor can be used for 14 days for free.

Private use (and educational sector)): 29 Euro
Commercial use: 50 Euro




http://www.atyafonline.com/vb/imgcache/1428.pngView of databases and tables


http://www.atyafonline.com/vb/imgcache/1430.png


http://www.atyafonline.com/vb/imgcache/1429.pngTables and databases are displayed in the tree structure on the left. (incl. number of existing data records)

http://www.atyafonline.com/vb/imgcache/1429.pngCurrent table is displayed on the right.


http://www.atyafonline.com/vb/imgcache/1428.pngEdit tables


http://www.atyafonline.com/vb/imgcache/1431.png



http://www.atyafonline.com/vb/imgcache/1429.pngThen table can be edited. Changes are stored intermediately.

http://www.atyafonline.com/vb/imgcache/1429.pngSyntax is checked in real time for correctness. The different colours indicate autoincrement fields or primary or other key fields.


http://www.atyafonline.com/vb/imgcache/1428.pngEdit and mangage tables


http://www.atyafonline.com/vb/imgcache/1432.png


http://www.atyafonline.com/vb/imgcache/1429.pngChanges are displayed appropriately. Changes can also be displayed and saved as SQL queries if required.

http://www.atyafonline.com/vb/imgcache/1429.pngFinally, changes can be sent to MySQL-DB as update, insert or delete queries.


http://www.atyafonline.com/vb/imgcache/1428.pngManagement of queries


http://www.atyafonline.com/vb/imgcache/1433.png


http://www.atyafonline.com/vb/imgcache/1429.pngEven queries can be managed.

http://www.atyafonline.com/vb/imgcache/1429.pngSELECT - Queries can be edited over more than one table, if fields with primary keys have been selected.

http://www.atyafonline.com/vb/imgcache/1428.pngBackup (Dump) and Restore of databases and tables



http://www.atyafonline.com/vb/imgcache/1434.png


http://www.atyafonline.com/vb/imgcache/1429.png Dumps/Backups of single tables or complete databases can be created and restored

http://www.atyafonline.com/vb/imgcache/1429.pngBackup can be restored to other databases.






http://www.richtsoft.com/