Submitted by Tony on Thu, 2008-05-01 04:03

Sometime last decade I built a web interface to MySQL using PHP. At first it basically managed records, allowed you to add, delete and modify table data etc. Over time it has evolved into a full database management system that depending on your privileges and settings allows you to:

  • Create or delete a database

  • Create, drop or rename tables

  • Alter table structure

  • Add or drop keys and indexes

  • Add, remove or change the properties of columns

  • Add, modify, search or delete table records

  • Manage users and privileges

  • Backup and restore databases

  • Save queries and results

  • Optimise tables

The main purpose was to make management of MySQL data easy.
The 3.0 version has just been released and can be downloaded freely from http://appcreator.com/tablemgr.php once you have an account.
This version has had some major new features and any feedback on it's use with different MySQL versions will be appriciated.

Get it while it's free Smile

  • Tony's blog

Got any screenshots or a

Submitted by Tyssen on Thu, 2008-05-01 04:34.

Got any screenshots or a demo? What are its advantages over using something like phpMyAdmin?

By the way, I tried to edit

Submitted by Tyssen on Thu, 2008-05-01 04:35.

By the way, I tried to edit my comment above a couple of seconds after posting it cos I noticed a typo and got the spam flag and had to fill in the captcha.

The captcha is from a new

Submitted by csscr on Thu, 2008-05-01 05:08.

The captcha is from a new spam filtering system I am trying.
I must have to play with the config a little Smile

When I first started developing it PHPMyAdmin was not installed on the server I was using and looked to be hard to install. The MySQL Table Manager was developed so it could be dropped into a web directory and away you go.

So a simpler and more

Submitted by Hugo on Thu, 2008-05-01 06:53.

So a simpler and more straightforward approach to essential functions? I've always found myphpadmin clunky and awkward to use, never been a fan of it it seems an after thought for those that aren't willing to be l33t and work from the CLI; I gaze with envy at the interface for MSSQL at times Smile

I'll give this a bash when I have a moment.

Ah nice redesign of Appcreator Tony, couldn't find download though? do I have to be logged in other than my forum login?

Yes you need to create an

Submitted by csscr on Thu, 2008-05-01 06:59.
Yes you need to create an account or use an OpenID if you have one. If you are logged in here you should see a link below.

Hugo wrote:So a simpler and

Submitted by Chris..S on Thu, 2008-05-01 13:23.

Hugo wrote:
So a simpler and more straightforward approach to essential functions? I've always found myphpadmin clunky and awkward to use, never been a fan of it it seems an after thought for those that aren't willing to be l33t and work from the CLI; I gaze with envy at the interface for MSSQL at times Smile

MySQL provides GUI tools. All you need is a user with remote access to the DB or some method of remoting into a GUI on the machine itself.

Thanks Tony, logged in and

Submitted by Hugo on Thu, 2008-05-01 22:29.

Thanks Tony, logged in and can see link Smile

@ Chris, thanks for that link as well, I wasn't aware of those tools :?

limited server access

Submitted by csscr on Fri, 2008-05-02 02:10.

This is really most useful when you have limited access to a server. Many host restrict access to just ftp and shell access. If that's the case you can upload the MySQL Table Manager and manage your database.

I'm getting this error:

Submitted by eddy on Mon, 2008-05-26 12:52.

I'm getting this error:

PHP Warning: Call-time pass-by-reference has been deprecated; If you would like to pass it by reference, modify the declaration of sort(). If you would like to enable call-time pass-by-reference, you can set allow_call_time_pass_reference to true in your INI file in E:\ereg-association.eu\wwwroot\tablemgr\settings.php on line 82[center]

Also, can you tell me what is the advantage over PHPMyAdmin?

error fixed

Submitted by csscr on Mon, 2008-05-26 23:07.

Hi Eddy,
Thanks for pointing out that error, it has been fixed and new files uploaded.

The main benefit of the MySQL Table Manager is it's simplicity. It is very simple to set up and use.

hi frends, i am mysql tool

Submitted by eddy.db on Mon, 2008-07-28 15:30.

hi frends, i am mysql tool user, i need to manage my databases so while searching i came around sqlyog which is best at its functionality and features also. I like to recommend to all.