MySQL Tools Giveaway

Aug 3 2009 by Jacob Gube | 75 Comments

MySQL Tools Giveaway

Webyog, a leading provider of data management tools, and Six Revisions have teamed up to offer prizes totaling close to $1,300 USD, to four lucky Six Revisions readers.

Comments now disabled. Stay tuned for giveaway results.

Here are the prizes that will be given away.

A license of MONyog MySQL Monitor and Advisor

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

The first prize is a license to the MONyog Unlimited tool valued at $999. MONyog MySQL Monitor and Advisor is a "MySQL DBA in a box" that helps you manage more MySQL servers, tune current MySQL servers, and fix problems with MySQL database applications before they become serious problems. Check out plenty of screenshots of MONyog here.

Three licenses of SQLyog MySQL GUI

Three licenses of SQLyog MySQL GUI

Three SQLyog MySQL GUI licenses will also be given away (worth $99 each). It is the most powerful MySQL manager and admin tool currently available in the market, combining the features of MySQL Query Browser, Administrator, phpMyAdmin and various other MySQL front-end tools and MySQL GUI tools in a single intuitive interface. Check out SQLyog MySQL GUI screenshots here.

How to participate

To participate, simply comment on one (or more) of the following topics:

  • What are some tips you can share to people working with MySQL databases?
  • How would you benefit from these MySQL tools?
  • Talk about a database administration nightmare that came true.
  • If you use MySQL, why? If not, why not (and what do you use instead)?

Make sure to leave a valid email address when filling out the comment form because this is how we will contact you once you’ve won.

Giveaway details

This giveaway will end on August 10, 2009 after which commenting on this post will be disabled. You can only participate once. Please don’t forget to put a valid email address in the comment form email field so that we can contact you if you’ve won.

About Webyog

Webyog provides best-of-breed data management tools for managing popular open-source databases. They consistently receive top ratings and recommendations by respected third-party media and product reviewers. More than 2 million users worldwide have selected Webyog to help them smartly manage, monitor and optimize their databases.

75 Comments

Tyler

August 3rd, 2009

1. Always think about expansion. So instead of just building the database, think about how easy it would be if you wanted to add a extra field, and then how easy it would be to admin the new field.
2. I have a few big projects coming up, these tools would help so much with managing the databases with these projects.
3. Idiotic mistake of setting ID to TINYINT, allowing only 127 entries before giving me a error, which I had no idea how to fix at the time.
4. Most widely used database, almost every host offers this. Also the documentation and help available is much greater than the rest.

fenderplayer

August 3rd, 2009

Cool…i would wanna take a look at this!!

Jeff Pearce

August 3rd, 2009

I use SQLYog on a daily basis and would love a full version to try out the extra features.
A really nightmare-ish database admin story is from a system migration project where I had to spec the moving of data from the old system to the new. The problem was the old system had over 1700 tables which needed to be condensed to just over 100!!! The migration ended up being cancelled but the analysis was one of the worst database experiences I’ve had.
MySQL is great, I’ve used it on countless WordPress and Joomla projects and have never had an issue with its stability.

Dan

August 3rd, 2009

I find the MySQL Workbench to be an excellent tool for designing tables and relationships in a visual way – it can even reverse engineer an existing database. There’s a commercial version and a GPL version. See here for details: http://dev.mysql.com/workbench/

Zach

August 3rd, 2009

I’d love these tools because phpmyadmin is complete garbage… I need something that will work more efficiently!

Andrew

August 3rd, 2009

Why do I use MySQL? That’s what I learned with, and it seems to be the generally accepted DBMS. Plus, most of the applications I like are MySQL only.

Laks

August 3rd, 2009

mySQL query browser, mySQL workbench, Navicat mySQL, dbVisualizer and now, I have to try webyog??!!

PS: I dont mind :-p!!

neuromancer

August 3rd, 2009

Recently there was a powercut which took out the one of the slave servers for a few minutes as it hadn’t been hooked up to the UPS. However when it came back online the root filesystem had been mounted read only!! At the time there was a high traffic e-commerce site hosted off the cluster which resulted in data inconsistency across the cluster, as all write ops were being held due to ‘error 30 from database engine’….and it took a few hours before we realised what was happening!!! If we had a tool like MonYog in place we could have spotted it earlier and without the sales teams complaining of lost orders!!!

Sid

August 3rd, 2009

I use Heidi SQL. Brilliant! I also love MySQL’s own free tools.

Sandra

August 3rd, 2009

@Zach, I disagree about phpmyadmin being complete garbage just because you need something more complete. phpMyAdmin has been a saving grace for quick simple checks and changes when I didn’t have access to my own computer.

Kent

August 3rd, 2009

I would use these tools on my web startup.

Kevin Quillen

August 3rd, 2009

Always always make sure you know if you are working on a local or live database before dropping it. Along with that, make sure you have daily database backups running on whatever OS you are using- it will save your life. Using a server management tool like Virtuamin could be a lifesaver here.

James

August 3rd, 2009

I use MySql due to its platform portability and community support. I could benefit from these tools as I am currently implementing a rollover infrastructure and would love to use one of these tools to create synchronous DBs.

Jeremy

August 3rd, 2009

I’ve used SQLyog for about 5 years now. It makes database administration so easy! I manage several databases across several servers, so I love the tools that enable me to copy structure and/or data across different servers. I look forward to using the full version some day to see what else it can do. I also look forward to being able to monitor performance with MONyog.

Antonio Touriño

August 3rd, 2009

I use MySQL because it’s simple to use and has been a staple in web development for many years. The wealth of information available online for it is amazing. If it can be done in MySQL, someone probably has tired it and documented it online. I have used SQLyog MySQL Enterprise before and I can heartily recommend it. It’s a very impressive and useful tool if you use MySQL on a daily basis.

AstroMan

August 3rd, 2009

1) My advice for those coding with PHP and MySQL couple is to learn and use a PHP Framework like CakePHP. There are plenty of useful functions included in this framework to work with MySQL
2) I’m using MySQL since my first line of code…These tools would help me to manage more and more databases !
3) I don’t really remember about a database administration nightmare that came true. But yes, after some hours of intensive coding, i dropped the wrong table (fulled of data of course…)
4) I’m using MySQL because it’s plateform independent, easy to install/configure/use…and it’s free !

Thanks SixRevisions for this great giveaway !

Isabel

August 3rd, 2009

You guys might want to check out MONyog by the same folks.

Tara Deschenes

August 3rd, 2009

Cool tools! Lots of benefits, especially the GUI tool. I use the mySQL GUI tools, but they are lacking in many ways. Thanks for the opportunity to win some of these.

technitrox

August 3rd, 2009

I use mysql for running a communitys. this tools will be helpful for me to manage, backup & restore mysql databases.

Michael Sinclair

August 3rd, 2009

When working with MySQL databases (or any relational DBMS for that matter), think about your indexes! Don’t index everything and don’t not index anything. If all else fails, think about the information you’re looking for as if you’re reading a book. What would you expect to find in the table of contents or index to find what it is you’re looking for.

I love SQLyog, and have been using the community edition for quite some time. I would love to get my hands on the more powerful edition to increase my productivity.

I’ve used MySQL for close to 10 years now. It’s the first DBMS I was introduced to while working with web-based applications and I’ve loved it ever since. It gets the job done and it gets it done well. I’ve even started dabbling with federated tables.

One database nightmare that I can still recall quite vividly occurred about two years ago. I was working on a virtual pet game, responsible for all of the coding & database administration. My boss at the time decided they wanted to do a little bit of house-cleaning on players’ inventories. Long story short, I had to try to piece together the remnants of the lost items using a recent backup and a log of transfers. There were around 50,000 accounts at the time and lots of activity between many of them. That was a nightmare and a half.

Jason

August 3rd, 2009

If you’re going to be working with MySQL, know what you want to build before you build it. It will help you immensely.

Bert

August 3rd, 2009

phpMyAdmin is a great tool, but I’d love to try the SQLyog MySQL GUI.
I’ve always used MySQL and will probably stick with it for a long time..

Shaun

August 3rd, 2009

Here’s my MySQL nightmare story. About a year ago, one of my companies top clients told us that if we continued experiencing problems, they would fire us. The next night, a SR VP was messing around with the mysql command line client, and deleted ALL OF THE CLIENT’S DATA. He called me at 3am. By the time I woke up, all data had been erased from the master and slave servers, and a fresh backup was taken of an EMPTY DATABASE! He asked me to restore without informing the client. So I restored from the previous night’s backup and ran the BIN-LOG files within a certain date range. The client was down for a few hours, but we told them it was something else. :)

That’s my nightmare story.

Dave

August 3rd, 2009

I use MySQL primarily because of the massive community that’s grown to help support the product. The MySQL.org website’s forum provides an almost instant way to get answers to whatever problems you encounter. Also, there’s a community of users on IRC that have provided valuable assistance to me when I’ve had questions about tuning my databases and improving my queries.

Pawel

August 3rd, 2009

Don’t optimize your queries from the start. Make simplest query for comparision purposes and then benchmark next queries.

greg

August 3rd, 2009

never used them, but I`d love to test them. Currently using EMS SQL Manager 2007 but it crashed during working with large databases

Mitchell

August 3rd, 2009

MySQL Tip:

Turn on query caching so that the most commonly executed queries run quickly, improving performance. Open up /etc/my.conf and add, modify, or ensure that this line exists: “query_cache_size = 16M”. This will add a 16MB cache. Change the size based on your needs and resources.

Jim Arthur

August 3rd, 2009

I used the SQLyog many years ago and really liked it. For reasons I no longer remember, I moved to Navicat and have not moved beyond that. SQLyog was very easy to use and allowed me a tool that thought in the fashion I was use to thinking, thus, meaning no learning curve. A great plus with any software. I first used MySql becasue it was free and easy to use. Since then I have been placed in positions where I had to use SQL Server. I still prefer MySql but currently have one large progject on MySql and two large projects on SQL Server. Life goes on.

James

August 3rd, 2009

MySQL has LIMIT and OFFSET. Use it. MSSQL sucks at that so badly you’d have to do some weird hacks to do pagination.

ashorlivs

August 3rd, 2009

This topic seems to be the perfect place for my question of the day: does anybody know a tool that does ALTER statements based on a source table and a destination table?
My point is keeping 2 separate database structures similar.

Nils Rasmusson

August 3rd, 2009

I’m primarily a front end designer so when I see an opportunity to use tools that will help me with databases, I definitely get interested. I usually often set up MySQL databases for customers as part of stores and carts but also for making a smarter, dynamic website that the customer can control. From what I’ve seen here, these tools would make my life a lot easier.

Hackhound

August 3rd, 2009

Tip for Fedora, Red Hat and possibly CentOS users who install MySql and WordPress on a system with Apache and SELinux. When you get to the part of the WordPress configuration where WordPress will try and connect to MySql to build the tables it will quite likely give you the error: “Error Establishing a database connection”. The WordPress documents say to double-check you typed in the username and password correctly.

The reason for this error is because in it’s default configuration SELinux will not let Apache access MySql, and the solution can be found here:
https://www.redhat.com/archives/fedora-selinux-list/2004-November/msg00013.html

Shawn

August 3rd, 2009

I have a site with a very large database that seems to be suffering from performance issues. I think having MONyog would be helpful with that. I also handle multiple sites, so SQLyog would be helpful with that.

Thanks for the great giveaways!

JFraser

August 3rd, 2009

How would you benefit from these MySQL tools?

I use SQLyog community edition daily. It is an essential part of my day and is a great product. I mainly use it to build, test and optimise queries for our website. I find it a great and don’t have many issues like I’ve had with other software

It’ll be great to get rid of that upgrade now splash screen :p

thirteen82

August 3rd, 2009

MySQL is the next language that I want to learn to help achieve my goal of being a “well versed web-designer”. Fresh out of school + lots of new time = MySQL learnin’.

Steve Robillard

August 3rd, 2009

Worst admin scenario was after an update of php/mysql all varchar fields began truncating everything after the 30th character. It took days and email to students to resubmit a few scholarship essays to correct.

Best mysql tip install a local development server. It will save lots of time and errors. Next would be to version control your db scripts or use something like rails migrations.

CoryT

August 3rd, 2009

1) Profile your DB to catch poor performing queries. The very first thing you should do is turn on the MySQL slow query log and install mtop. This will give you access to information about the absolute worst offenders.
2) Still searching for a reliable, solid suite of tools to work with mysql db’s. It would save many headaches :)
3) I would have to say during a recent project I suffered many headaches due to development environments having different versions of sprocs and ensuring the correct ones were pushed during an upload. It wasn’t until during the upload we realized some sprocs had different versions so we scrambled to find a scheme compare tool to verify all changes made it to production.
4) 75% of projects I use MSSQL, the other 25% I use MySQL.

Kunal Punjabi

August 3rd, 2009

1. What are some tips you can share to people working with MySQL databases?
In general while working with databases – it i best to think through and spend a good amount of time on the design and schema, to avoid problems from cropping up later.

2. How would you benefit from these MySQL tools?
I’m hoping they would speed up my development, improve efficiency, and help me scale my web applications faster and easier.
I’ll soon be needing to tune my database and MySQL servers.Looking at the screenshots right now and I love the query analyzers, disk info pages, and monitors for connections, indexes, etc. I can see myself using these on a daily basis.

3. Talk about a database administration nightmare that came true.
A: Migration and Administration via PHPMyAdmin = painfully slow. And a nightmare.

If you use MySQL, why? If not, why not (and what do you use instead)?
A: Its what I learned, and there is an active development community for it. I dont like the fact that subqueries arent “built-in” and you need to go to extra lengths to make complex SQL sub-joins work, but otherwise I dont see myself using any other DBMS in he forseeable future.

Matt

August 3rd, 2009

1) Don’t assume ANYTHING. Always take the time to double check your config especially when it comes to access rights on a live DB; yikes. Plan ahead and take the time to design and test schema in a sandbox to optimize performance.

2) I work for a very small company (read: money is tight) which has very high – bordering on unrealistic – expectations of how databases – and hardware for that matter – actually work. That being said though I am sure the majority of people on SR are in the same boat. We have seen a massive explosion in the amount of data we are being required to take in while at the same time making sure that we do not sacrifice performance for the end user’s of our website. As a result there are more and more servers, databases, queries and trends that need to be examined and not nearly enough personnel to do it

Outside of my full-time job though I do a substantial amount of pro-bono work for small businesses as well as for various community organizations. The result of this is a lot of infrastructure all over the place which drastically increases the spin-up time required to (re)initiate work on the various projects. It would be nice to be able to monitor everything from a single place. Neither myself or any of these groups have the money to invest in large amounts of infrastructure so it is important that what they do have works, is monitored, and backs up w/out fail.

3) I get chills just thinking about this. It was very VERY early on in my DBA – heck it was early on in my DB days for that matter. One of our devs – who was just learning to work w/mysql – needed access to our production DB. I was in the middle of putting out a bunch of fires so I hastily granted them all permissions on all DBS. Long story short, they ran a command which dropped the top 5 largest tables in our production database. In addition, thanks to the replication I was so proud of myself for setting up the previous day, that command quickly made its way to our only slave (read: only backup).

Yes I know that I was stupid for an infinite numbers of reasons, so let the razing bergin :) Live and learn right?

4) I use MySQL and I have no desire to use anything else for any projects in my full-time or free-time work. First and foremost, you can’t beat free. Even if you could though, I am not sure that I have come across a better user group than MySQL’s. As evidenced above I don’t always have the (right) answer to a question/problem so it is quite comforting to notice that I can fairly quickly find someone who does.

Mon Villalon

August 3rd, 2009

I’d like to share two very useful mysql queries you may not now
about:

1. Get One Random Record
SELECT * FROM A ORDER BY RAND() LIMIT 1

2. If you have a many to many relationship you can compress
a lot of records into a comma separated value with the very cool
aggregate function GROUP_CONCAT

http://dev.mysql.com/doc/refman/5.0/en/group-by-functions.html#function_group-concat

SELECT  P.* ,
 GROUP_CONCAT( DISTINCT Tags.name ORDER BY Tags.name DESC SEPARATOR ',')
FROM Posts P    
INNER JOIN PostsTags PG ON P.id = PG.post_id
INNER JOIN Tags T ON T.id = PG.tag_id
  GROUP BY T.id

Enjoy =)

Kealoha

August 4th, 2009

If you use MySQL, why? If not, why not (and what do you use instead)?
A. Reliable, free, and lots of support from a community that far exceeds any tech support I’ve encountered for an open source project.

Jay

August 4th, 2009

Why MySQL? It’s opensource, free and lightweight!
Also I prefer building website using PHP + MySQL combo.

Zck

August 4th, 2009

I use oracle and ms sql. Have not really touched mysql because there hasnt really be a need for it. I guess the way mysql being marketed is not that great cause when i hear the name mysql, i think, free, good for small to med business. Maybe if mysql had all the features, tools and support like the big names db’s out there, more organisations would switch to it. Free software doesnt mean too much to an enterpise

Marcelo

August 4th, 2009

One important tip for every MySQL newbie: you must be aware of how big the database may grow and start programming with this idea in mind. If your databases become massively huge and your software wasn’t ready enough to handle such growth, this may surely affect the performance in a lot of ways and you will be handling a huge mess of data.

Another tip: don’t “SELECT *” if you only need to evaluate one or two fields of data. Learn to use LIMIT if you must handle huge lists of data. Learn to use and apply INSERT DELAYED if you must append data to very busy systems. Learn the characteristics of different engine, using MyISAM for searchable data and InnoDB for browsable data.

I can recall one database administration nightmare: another programmer and me were working on a collaborative project designing a CMS for a private enterprise intranet. He was at South Africa and I am at Argentina. We had our own local copies of the scripts+db and the web server ran a production version and a separated sandbox version. The nightmare arose when lots of coffee cannot keep you awake anymore and your last pending work of the day is to consolidate the four database changes via phpMyAdmin and unify script versions. Fortunately, I started using SQLyog and the production db was copied to a different folder and I was able to distinguish the good copy before spreading a great versioning error in the production server that may lead to corruption of years of products and customer data.
If I had fully licensed SQLyog I could auto-backup and sync all the databases from all the websites I admin and save a bunch of hours to share with my kids.

Why do I use MySQL? Well, form the kickstart, after seeing its online documentation and community I guess it was love at first sight :) Due to its ease of use and simplicity, what can I say? I love MySQL.

Monique

August 4th, 2009

I just started with MySQL and PHP(myAdmin). At fist I just started with it, but that didnt end up well… I deleted some stuff…:s so some people where very angry… So the best tip I could give anyone: learn the basics fisrt and dont just try on error.
I would love to win the tool, so it could help me with MySQL.

mate

August 4th, 2009

I use MySql because it is most widely spread DB for web I know. Surely it has its drawbacks compared to other db engines, but its possibilities of usage exceed its shortcomings

Maxime

August 4th, 2009

Learn about indexing! It can improve the speed of your queries! I use MySQL since it’s the perfect database for my PHP project’s needs.

Benjamin M. Strozykowski

August 4th, 2009

I don’t know a whole lot about MySQL optimization, so it would be awesome to get these tools and learn a bit.

I’ve used MySQL and PHPmyAdmin due to their open source nature, having come from an Oracle SQL background. This has let me build applications without needing exceedingly expensive licenses.

Phill Pafford

August 4th, 2009

Q – What are some tips you can share to people working with MySQL databases?
A – There are so many tips but the one that stands out the most for me is the IN command. This little gem will save you so much time if you use it right. EXAMPLE: instead of using something like this ‘SELECT * FROM table_name WHERE this = that OR this = those OR this = more’ you could use ‘SELECT * FROM table_name WHERE this IN (that, those, more)’

Q – How would you benefit from these MySQL tools?
A – Having professional GUI tools make life easier, I would suggest at least using the free community MySQL GUI tools as they offer many uses.

Q – Talk about a database administration nightmare that came true.
A – Database table corruption, this was a nightmare that I had to step into, but after some hard work (and that goodness for some DB backups) was able to recover most if not all the data and optimize it again.

Q – If you use MySQL, why? If not, why not (and what do you use instead)?
A – Why wouldn’t you use MySQL, the community is large and very knowledge able, you can get paid support for enterprise, they offer tons of tutorials/how to’s/ guides/ etc… it’s fast, flexible and stable. I would and do recommend MySQL to all starting out or looking to scale a project.

Ivan Mišić

August 4th, 2009

Put everything on paper before you start building something, consider future upgrades, normalize tables, use proper joins, don’t use tinyint for ID field, use right field length, from time to time optimize database, resolve backup with some script, index jour tables, use triggers and procedures not just jour application, on large tables consider using partitioning available from 5.1 version. MySQL is excellent database if you use it properly and it’s free. Example: your garage can be good place for storage, but if you don’t organize it and think in advance it can be really mess-up when look for something. If you have someone who needs read-only access, create another user with different privileges and access only to that database. Best of all use Google in search for answers.
Sorry for grammar :-) greetings from Croatia.

Glenbot

August 4th, 2009

Wow i didn’t even know such great tools existed for MySQL. I have been using the free GUI tools forever now. This is awesome. Thanks six revisions!

JacekS

August 4th, 2009

I use MySQL almost daily.
My nightmare with it is that, managing quite a few websites I can’t remember all the addresses logins and passwords, sometimes I use wrong set and end up backuping or even clearing wrong database.
I’m looking for something useful to manage all of this.

Jarryd

August 4th, 2009

phpMyAdmin does a great job, but having software to do it instead of relying on a webpage would definitely speed up the process of editing and managing my databases.

Dan

August 5th, 2009

I currently use MS SQL, just because that’s what I’m familiar with. I need to check out MySQL though!

Toesan

August 5th, 2009

That’s such a cool service! I started my site with almost no knowledge of MySQL but since my traffic went up and up throughout the years I saw what effect my n00b queries has, as the scale of database increased in size. I bought a MySQL developers library book to learn more about MySQL. Databases is like the most boring thing ever to read but I enjoyed it. I still have some performance issues though, but redesigning takes up so much time and work :-(

Scott

August 5th, 2009

We just started implementing mysql at work, these would be quite handy.

moontear

August 5th, 2009

1. Use available Frontends for MySQL such as PHPMyAdmin, but don’t neglet the pure beauty of using command line SQL.

2. These tools make it a lot easier to admin databases. One always feels better when doing stuff on your local computer for MysqlYOG. For Monyog one can only say that it is always good to have a monitoring tool available when monitoring multiple databases. One place for all basically – time efficiency.

3. My current nightmare: Hooking up a local Microsoft Access database to a remote MySQL host. ODBC makes this easier, but let’s wait for the fun once I have to deploy my solution to the customer w/o the same setup as my machine… Microsoft Access is OK on it’s owe but let’s not talk about data connectivity.

4. I do use MySQL because almost every webhost offers the possibility. At work I do MS SQL all the time, but try finding a reasonable cheap webhost offering you a windows server with everything performing like it should. MySQL does what it should, but does of course not have all the bells and whistles MSSQL has for example (or Oracle for that matter).

Hope that MySQLYog license finds it’s way to me ;-)

Mark

August 5th, 2009

How would I benefit from MONyog Monitor?

Well I think the Slow Query Log would be the most useful of its features as we had problems after outsourcing one of our sites to a developer. He coded in some pretty awful MySQL queries that caused our servers to overload and crash, but we couldn’t determine which one was the problem with ease.

Raúl

August 5th, 2009

I learnt about the importance of indexes when the system got down several times in a week when our team increase the clients, after enable and look at the log, realize two problems: one for easy the work with time and date when show in the pages, was separate a field datetime and existed one field for date and one for time, a big mistake, cause there wasn’t optimizations in the search, and some fields that were foreign key don’t have a key, we use tables MyISAM in the more working tables ‘cuase are fast than innodb, but at the cost of checking the changes and the tables related. The change was a faster response, when we has CPU at 40% before the new clients to 3 or 4% after the changes with the new clients.
Sorry for the grammar.

dev.My

August 5th, 2009

I use MYSQL instead of other beacause
1.Easy to learn than other
2.Free
3.Better performance, reliability and security than other

lossendae

August 5th, 2009

1. I’m learning to use xPDO (OpenExpedio ), a PDO wrapper which can bring PDO to php4.
It’s a light-weight ORB (object-relational bridge) library that works on PHP 4 and 5, and takes advantage of the newly adopted standard for database persistence in PHP 5.1+, PDO. It implements the very simple, but effective Active Record pattern for data access ?
2. I use an old version of MySQLYog to manage my databases ?
3. Insert 100000+ records via phpmyAdmin.
4. Because it’s free (for my use), it’s the first db that i learned, it is available on most best hosters in my country.

sospartan

August 5th, 2009

we using mysql ,cos it’s best of the open source database and it’s quiet easy to learn . most important reason is better and better day by day.

Jason

August 6th, 2009

Turn on the slow query log and fix them. EXPLAIN the queries to see what’s going on and add indexes.

KodrutZ

August 6th, 2009

I use MySQL because it’s all I need… and WordPress, the CMS I usually install on my websites, works with it, of course!

Sech D

August 7th, 2009

I’ve been using sqlyog for a few years now. It is great tool backup / synchronize databases. I keep a copy of databases on my local machine not only for backup but also for testing purposes.

DemoGeek

August 7th, 2009

I use SQL Server and Oracle at my full-time job but certainly use MySQL for everything else. It’s the open-source and light-weight feeling that keeps me getting back to MySQL. Of course, a tool like SQLYog would certainly make me a die-hard fan of MySQL for sure.

jake

August 8th, 2009

Been using SQLyog since 2004 because it is the only tool that makes sense. i bought my first license last year and is has been great watching the product get sweeter and sweeter.
i use sybase, dbase and oracle at work but for the Xceed Datagrid/WPF/Telerik Openaccess/MySQL project i am working on currently i use SQLyog. I have got a new laptop that is using 64bit vista. just after i had installed MySQL i found that MySQL AB/SUN/Oracle doesn’t do 64bit tools!! i thought no big i will just download SQLyog and it will be business as usual. LO AND BEHOLD!! Not only had my license to recieve updates expired, but also my account at customerarea on webyog was not letting me see my license anymore!! i thought i was well and truely screwed!! then twitter.com/sqlyog replied to my appeal to the higher power (Chirag) by saying my license never expires. i am feeling great now even. Greater since i figured that though my enterprise edition license had expired i could still use community edition (who cares about the nag screens!! keep the App open!!).
thanks SQLyog Team, webyog and Chirag. (Who dat? he be guy tellin us about update in email. Pay for enterprise get email from Chirag)

Gafitescu Daniel

August 8th, 2009

I have user SqlYog Community Edition for quite some time and it is the best product for working with MySql. Looking forward to MONyog

Andrew

August 9th, 2009

I use MySQL because it’s open source and widely used.

I find it stable and I think it has a great future.

Rocket No. 9

August 9th, 2009

I use MySQL for as many projects as possible because it is open source, has a huge installed base, it is robust, and (of course) it’s free.

David Radcliffe

August 10th, 2009

These tools would be cool to try. I’ve only used the free tools until now because – they are free! :)

Prathap.Karumanchi

August 10th, 2009

Webyog is an excellent source for web developers to maintain, design and organize database. When i was learning php/mysql my teacher exposed this wonderful tool (sqlyog) to us which helped us a lot. Thanks to webyog and sixrevision for this offer.

stawil

August 10th, 2009

we all look for powerful software solution for MySQL Database administration and development. i hope this will be the one.

razvantim

August 10th, 2009

I’ve been using SQLYog for years and I must say is the best windows tool for managing mysql dbs. The most thing I like is the migration and backup wizards. Easy and fast

Huy

August 10th, 2009

1. Always think about expansion. So instead of just building the database, think about how easy it would be if you wanted to add a extra field, and then how easy it would be to admin the new field.
2. I have a few big projects coming up, these tools would help so much with managing the databases with these projects.
3. Idiotic mistake of setting ID to TINYINT, allowing only 127 entries before giving me a error, which I had no idea how to fix at the time.
4. Most widely used database, almost every host offers this. Also the documentation and help available is much greater than the rest.