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
Got any screenshots or a
Got any screenshots or a demo? What are its advantages over using something like phpMyAdmin?
By the way, I tried to edit
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
The captcha is from a new spam filtering system I am trying.
I must have to play with the config a little
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
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
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
Hugo wrote:So a simpler and
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
Thanks Tony, logged in and can see link
@ Chris, thanks for that link as well, I wasn't aware of those tools :?
limited server access
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:
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?
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
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.