Linked by snydeq on Mon 1st Aug 2011 14:30 UTC
Databases MySQL toolmaker Daniel Nichter provides a look at 10 must-have free and open source tools for MySQL. 'MySQL has attracted a vibrant community of developers who are putting out high-quality open source tools to help with the complexity, performance, and health of MySQL systems, most of which are available for free,' writes Nichter, who was named 2010 MySQL Community Member of the Year for his work on maatkit. From mydumper, to mk-query-digest, to stalk and collect, the list compiles tools to help back up MySQL data, increase performance, guard against data drift, and log pertinent troubleshooting data when problems arise, each of which is a valuable resource for anyone using MySQL, from a stand-alone instance to a multiple-node environment.
Permalink for comment 483052
To read all comments associated with this story, please click here.
advice needed
by fran on Mon 1st Aug 2011 20:38 UTC
fran
Member since:
2010-08-06

while sql tools is the topic let me be so forward and ask someone advice.

I must want to write a small exel program for increased productivity that involve comparing two pairs of tables of product codes and prices. Mainly to indentify new added products, deleted products and price changes.

My first hurdle. Opening a sql database in excel with tables set out.
I google'd it but cant seem find the right info.

When downloading your sql backup (.sql.gz format)from your server and unzipping it how do I get it into excel format. I did open it by changing the format to .csv but the it don,t show it in table format like it exist inside sql.

Reply Score: 2