Guest post by 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.
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.
I’m not sure I understand your question. If your goal is to compare the data in two MySQL tables, you do not need to load the data into Excel first. Just google on “how to compare MySQL tables” and you’ll find many example SQL statements to do this.
Here’s one approach —
select * from table a where a.common not in (select b.common from table b where a.common = b.common)
then switch up the tables in the query and you can check each table.
thx for this.
Will try.
you should also revise your understanding of what a relational database is. It should never cross your mind to export the data out of the database to compare or do any analysis. I wouldn’t do complex statistical models inside it but most analysis like means and modes, compares any set operations should be done with SQL or what ever database interface your using (unsql, gql orm, pg/*, whatever)