gravatar

Edmonds Commerce are a UK based E-Commerce web development agency. We are based in Shipley which is in Yorkshire near Leeds and Bradford.

Our primary specialism is Magento and Magento2 and other PHP based E-Commerce platforms such as OpenCart.

In terms of technology we are very strong in PHP, MySQL, Linux, HTML, CSS and Javascript.

MySQL DB Admin GUI for Windows / XAMPP

Mar 25, 2008 · 2 minute read
Category: mysqlWindowsxampp

This is post is now quite old and the the information it contains may be out of date or innacurate.

If you find any errors or have any suggestions to update the information please let us know or create a pull request on GitHub

If you are using windows (with XAMPP) to develop your MySQL applications, you might currently be using phpMyAdmin for your DBA tasks. The phpMyAdmin package is an awesome tool and is a must have, however due to the fact that it runs under Apache and PHP - it can be tricky to use when dealing with big database dumps or other heavy processing.

At this stage, you may decide that the best thing to do is to hit the command line. That’s fair enough if you don’t mind using command line applications. If however you fancy keeping it GUI, then I can highly recommend using the free community edition of SQLyog.

This open source community edition is a free version of their main Enterprise Edition software which is paid for. If you are doing a lot of DBA work then you may want to consider supporting this company by handing over some cash for the fully featured software. The enterprise edition can handle external as well as local MySQL database administration, using SSH, SSL or HTTP/HTTPS tunnelling. It features all kinds of GUI functionality for building your database schema and designing queries. For the serious DBA’s out there it may well be worth a look.

For the occasional big DB import / export session on the local windows host though, the community edition does seem to suffice.

You can download both the community and the enterprise edition here:

http://www.webyog.com/en/downloads.php

To compare functionalty check out this page:

http://www.webyog.com/en/sqlyog_feature_matrix.php