Version 3.02 of the MySQL Table Manager has been released. Changes are mostly fixing an error when backing up a database and fixing the notification or message system.

Thanks aquinoes for pointing out the error and testing the fix.

As development is done as needed and when time is available, to keep up to date with the MySQL Table Manager you can visit http://appcreator.com/web-development/table-manager and add the feed to your favourite RSS feed reader.

There seemed to be a lot of bots downloading the MySQL Table Manager so you now must be logged in to download. To log in you need an account either an existing OpenID or you can create an account here with just a valid email address.

Once you have an account you will be able to download the files as well as comment in the support forum

Finally I have released version 3 of the MySQL Table Manager. The last version 2.8 was released in October 2003, that's nearly 5 years ago. I apologise for my lack of motivation in getting this one out, and hope you find the new version as useful as I do.

Many new features have been added such as user management, change privileges, backup functionality, ajax edit in place functionality to update fields, optimize tables, save queries, save results.

A new privilege system has been added that restricts functionality based on MySQL privileges and privileges set in the settings file. The privilege system works best with MySQL versions greater then 5.0.2.

To coincide with the release I have added support forums so it will be easier to track and manage support requests. Let me know what works and what fails in different MySQL server versions, operating systems or browsers.

Enjoy.

While testing the next version of Table Manager, which is badly in need of a new name, I once again have started adding new features. I have a simple test plan, basically a list of features or actions that need to be tested in different browser operating system combinations. Most of my testing at this stage has been while using the system to preform tasks for work etc. Occasionally while preforming a task I have an idea of a new feature which would simplify things, other times I come across features that are just plain missing. So my feature list of functionality to test gets longer and I have to start again at the top.

My latest additions have been MySQL user management related, things like adding users, changing passwords setting privileges etc. These are all handy features that I felt should be included so along with adding the functionality you need to check that the flow of menus and pages make sense.

Some of the features need to stand alone others work best when paired with something else and some need both. For example you can create a user as an isolated task but in reality a user without any privileges is a lonely user, so I am adding a button which will take you straight to grant privileges after a user is created.

Usually I develop on Linux then test on windows, this time things are around the other way. I am using my work laptop for the development (from home of course) and testing on my Linux system at home, hopefully I can get a work mac to test on once I have tied down the functionality. In most cases people will upload the system to a directory on there web server which will most likely be a Linux system of sorts with MySQL an PHP and Apache. So I need to throughly test that scenario. Testing on my local Linux box was going fine until I tried the backup functionality which works fine on Windows. At this stage I think it is just a path issue, more testing will tell.

So that's about where I am up to at the moment between work which has been getting really busy, family life and Aikido which is about to get back into full swing after a short break while Sensei visited Japan.

While testing the new version of the Table Manager IE managed to cause me some major headaches. Buttons should be pretty flexible tools for web forms, you can put markup between the opening and closing tags and the value attribute should be sent with the form not the markup or text between the tag opening and ending. So you can have multiple buttons in a form and only send the values of the button that was clicked. Now this would be great if only IE would play nicely.