MySQL Server Administrator Support

MySQL Server Administrator is a full featured GUI to fully administer a MySQL Server.

It is integrated into the Dreamweaver engine and can communicate with a remote MySQL server, altering tables, creating fields, index, drop an entire Database, run raw SQL query...

Note : This extension doesn't require UltraDev.

Current available version : 0.11.1

NOTE : If you're upgrading from v0.10.0, make sure you remove the extension before installing this new one.

New feature in v. 0.11.1

1. The extension is now a floater. So you can keep it open while working, then using it whenever you need to.
2. Added the possibility to Delete/Update a record directly from raw SQL queyr result.
3. The refresh button now works for fields, table and database.
4. Starting at v0.11.0 profiles you've created are not any more erased when installing a new version. Though, v0.10 profiles will be erased.
5. Many bug fixes

The modification to make it a floater necessitated a major overhaul of all the code, and now, everything is much betterly stored in your configuration folder.

The project is in beta right now, but as of version 0.11.0, the following features are working :

• Server :
  - Scan entire server, retrieve whole Database, Table and fields
  - Multiple profiles for server and database supported
  - Select the port you want to connect to.

• Database :
  - Create Database
  - Drop Database
  - View status of tables whitin the database 
• Tables :
  - Create a new table (all-in-a-whole)
  - All MySQL table Types supported (MyISAM, GEMINI,BDB,...) 
  - Edit table properties (Type, Checksum, delay key write, packed key...) 
  - Drop Tables
  - Browse the table
  - Insert into table
• Fields : (All MySQL Field Type supported)
  - New Field
  - Alter Field
  - Drop Field
• Index :
  - Currently supported type : Primary Key, INDEX,UNIQUE,FULLTEXT
  - Create new Index of any type
  - Alter any index
  - Delete any index
• RAW SQL :
  - run your raw SQL Query and see your query results...
  - Your SQL queries are now stored in the History. You can view them, edit them and then execute.
  - Delete any selected rows from the result
  - Update any record.

Note : The Delete/Update options are available depending on the ability for the extension to retrieve the exact row information you want to delete/update. These conditions are :

- Make sure all the fields come from the same table
- Make sure you have all the primary key's fields selected in your query.
The two buttons on the top of the result list are greyed out if the option is unavailable, otherwise they will show in plain color.

Installation :

Thanks to an agreement with MySQL, this extension now ship with all the files that are needed !

ScreenShots :

http://www.maehdros.com/image/screenshot3.gif
http://www.maehdros.com/image/screenshot4.gif
http://www.maehdros.com/image/screenshot2.gif
http://www.maehdros.com/image/screenshot1.gif
http://www.maehdros.com/image/screenshot5.jpg

Disclaimer:
This is a beta extension provided for free that you can use at your own risk. DMXzone nor the author of this extension is responsible for the possible damage of this extension to your DW installation or to your web applications. Back up your configuration folder before installing this extension is a good habit. This extension is provided 'as is' and we do not guarantee that it will ever be finished. Unless the author has given you the explicit permission you are not allowed to redistribute this extension or make your own new extension out of it. This extension is unsupported, bugs and questions can be posted using the "Discuss" button.