September 12th, 2008
2 Great Web Based Alternatives to PHPMyAdmin
PHPMyAdmin has many features, but it’s slow. Personally I think I use around 30% of what it has to offer. So I searched around for other lighter and faster alternatives and found not one, but two.
1. SQL Buddy
Features:
- no setup (works out of the box )
- reduced load time, because it’s AJAX based
- import – export, which is a must
- it’s open – source
2. PHP Mini Admin
Features:
- single file package, extremely portable
- it has all the basic features: insert, select, create, etc.
- it’s open – source
- import – export
http://phpminiadmin.sourceforge.net/
If you enjoyed this article then help spread the word and please follow us on Twitter or subscribe to our RSS feed.
Subscribe to our RSS feedFollow us on Twitter
on Friday 12, 2008
Nice post! I also did one tool who is doing similar stuff it is called:MySql Lite Administrator you can find more on http://code.google.com/p/mysql-lite-administrator/
on Friday 12, 2008
Thank you for the finds. I will check them out later. Meanwhile, I find MS-SQL to be more productive.
on Friday 12, 2008
I have jsut installed SQL Buddy for use on my server but I find it to be too condensed and error-prone so I am afraid that phpMyAdmin is still number 1 for me.
on Friday 12, 2008
Thanks for the update ‘Bull3t’, but how about the other one that the article talks about?
on Friday 12, 2008
SQL Buddy doesn’t support IE6, maybe that’s the problem. I hate IE6 I hope it will be discontinued soon.
on Friday 12, 2008
Well if you are not hell bent on using “web-based” tools, then SQLyog is a nice alternative. Actually, I prefer a native client compared to web-based admin software for serious MySQL stuff.
on Friday 12, 2008
Yes. I used it a lot, but I switched to Mac and sadly it doesn’t support it. There’s Navicat lite version for Mac, but I don’t feel it…
on Friday 12, 2008
@Vladimir,
I checked your tool. Its really nice.
on Friday 12, 2008
Got any recommendations on a mysql admin program thats NOT web based? Ive been looking for something light and simple that can simply be run from any machine.
on Friday 12, 2008
Check out my article on desktop MySQL GUIs here: http://blog.primalskill.com/?p=52
on Friday 12, 2008
[quote]@Vladimir,
I checked your tool. Its really nice.[/quote]
That is hilarious!
on Friday 12, 2008
Just installed SQL Buddy. It’s great! I was getting a long list of PHP Notices outputted when I would export, but adding a .htaccess file in the sqlbuddy directory that contained this solved the problem: # supress php errors php_flag display_startup_errors off php_flag display_errors off php_flag html_errors off php_value docref_root 0 php_value docref_ext 0
on Friday 12, 2008
Hi dude Jeremy is absolutely rite. Even i found and was suggested
Sqlyog the best db management tool. Too friendly tool. No doubt in
trying and using it.
on Friday 12, 2008
“Got any recommendations on a mysql admin program thats NOT web based? Ive been looking for something light and simple that can simply be run from any machine.” I’ve used the freeware community edition of SQLYog now for a few years. I love it.
FEATURES: http://www.webyog.com/en/sqlyog_feature_list.php
DIRECT DOWNLOAD: http://www.webyog.com/en/download_form.php?url=http://www.webyog.com/downloads/SQLyog714.exe
on Friday 12, 2008
You could use Navicat it supports Windows, Linux and Mac OS X.
A lite version is also available.
on Friday 12, 2008
The free verson SQLYog has very little functionality – it is nearly useless. I’m using MySQL Administrator and MySQL Query, but I wish there was something better. If anyone know of anything, please let me know.
Rob
on Friday 12, 2008
Thx for sharing.
on Friday 12, 2008
Tanks. Really cool an useful tools