LinuxQuestions.org
Download your favorite Linux distribution at LQ ISO.
Go Back   LinuxQuestions.org > Forums > Linux Forums > Linux - Newbie
User Name
Password
Linux - Newbie This Linux forum is for members that are new to Linux.
Just starting out and have a question? If it is not in the man pages or the how-to's this is the place!

Notices


Reply
  Search this Thread
Old 12-03-2016, 05:26 PM   #1
ceantuco
Member
 
Registered: Mar 2008
Location: New York
Distribution: Debian
Posts: 809

Rep: Reputation: 88
Question MySQL reporting tool


Hello Guys,

Could any of you recommend a free reporting tool for MySQL server databases? I would like to create a simple report for a database that contains one table with three fields. I googled' a few but they seem way to complex for what i am trying to achieve.

Please advise

Thanks!
 
Old 12-03-2016, 07:59 PM   #2
frankbell
LQ Guru
 
Registered: Jan 2006
Location: Virginia, USA
Distribution: Slackware, Ubuntu MATE, Mageia, and whatever VMs I happen to be playing with
Posts: 19,409
Blog Entries: 28

Rep: Reputation: 6166Reputation: 6166Reputation: 6166Reputation: 6166Reputation: 6166Reputation: 6166Reputation: 6166Reputation: 6166Reputation: 6166Reputation: 6166Reputation: 6166
This article should help: http://www.databasejournal.com/featu...ing-tools.html

A search for "mysql reports" will turn up much more.
 
Old 12-04-2016, 10:07 AM   #3
ceantuco
Member
 
Registered: Mar 2008
Location: New York
Distribution: Debian
Posts: 809

Original Poster
Rep: Reputation: 88
Thank you for the link. I was actually looking for a recommendation; hoping someone here might now of tool to get the job done. Thanks! Downloaded and installed Navi but it crashes after start up. Thanks.
 
Old 12-04-2016, 10:27 AM   #4
TB0ne
LQ Guru
 
Registered: Jul 2003
Location: Birmingham, Alabama
Distribution: SuSE, RedHat, Slack,CentOS
Posts: 26,816

Rep: Reputation: 8003Reputation: 8003Reputation: 8003Reputation: 8003Reputation: 8003Reputation: 8003Reputation: 8003Reputation: 8003Reputation: 8003Reputation: 8003Reputation: 8003
Quote:
Originally Posted by ceantuco View Post
Hello Guys,
Could any of you recommend a free reporting tool for MySQL server databases? I would like to create a simple report for a database that contains one table with three fields. I googled' a few but they seem way to complex for what i am trying to achieve.
Well, can you tell us what you're trying to achieve?? Since we don't know, it's hard to guess. What kind of report are you wanting? What's your goal?

MySQL reporting could mean you want statistics on the MySQL system itself, or a report on the user-entered data into a table/tables ON the MySQL server. And what KIND of report? Excel/CSV? Graph? Presented via web, email?? How often is this report going to be run? Kind of an open ended question....

You could use the mysql command line and use the "--into-outfile" directive, fields separated by ",", enclosed by """, and type in your query, and get a CSV file from the data, suitable for import into Excel, where you can graph/sort yourself.

Provide details and we may be able to help.
 
Old 12-05-2016, 03:14 PM   #5
ceantuco
Member
 
Registered: Mar 2008
Location: New York
Distribution: Debian
Posts: 809

Original Poster
Rep: Reputation: 88
Okay. MYSQL database contains a table with four fields ('ID', 'Name', 'Date' and 'Taken'). Every time a certain action occurs in my system, a shell script inserts data into those fields. I would like to use a tool such as 'Crystal Reports' but that I can install on my Raspberry pi or other linux system to connect to MYSQL database and create a report based on that table's data that would look like:

ID Name Date Taken
1 John 20160101 yes
1 John 20160102 no

Please advise

Thank you
 
Old 12-05-2016, 03:20 PM   #6
szboardstretcher
Senior Member
 
Registered: Aug 2006
Location: Detroit, MI
Distribution: GNU/Linux systemd
Posts: 4,278

Rep: Reputation: 1694Reputation: 1694Reputation: 1694Reputation: 1694Reputation: 1694Reputation: 1694Reputation: 1694Reputation: 1694Reputation: 1694Reputation: 1694Reputation: 1694
Fairly simple time series in a mysql database?

Then why not use rrdtool? or even graphite?
 
Old 12-05-2016, 03:26 PM   #7
Habitual
LQ Veteran
 
Registered: Jan 2011
Location: Abingdon, VA
Distribution: Catalina
Posts: 9,374
Blog Entries: 37

Rep: Reputation: Disabled
try http://community.jaspersoft.com/proj...eport-designer

Last edited by Habitual; 12-05-2016 at 03:28 PM.
 
Old 12-07-2016, 03:00 PM   #8
ceantuco
Member
 
Registered: Mar 2008
Location: New York
Distribution: Debian
Posts: 809

Original Poster
Rep: Reputation: 88
Thank you both for your responses. I found a good way of accomplish what I needed. Downloaded LibreBase, installed MySQL base plugin, connected to database and created simple report.
Attached Thumbnails
Click image for larger version

Name:	report.png
Views:	13
Size:	14.5 KB
ID:	23711  
 
Old 12-07-2016, 03:14 PM   #9
Habitual
LQ Veteran
 
Registered: Jan 2011
Location: Abingdon, VA
Distribution: Catalina
Posts: 9,374
Blog Entries: 37

Rep: Reputation: Disabled
Quote:
Originally Posted by ceantuco View Post
Thank you both for your responses. I found a good way of accomplish what I needed. Downloaded LibreBase, installed MySQL base plugin, connected to database and created simple report.
Good job, and well done!
Glad to have helped.
 
Old 12-07-2016, 03:21 PM   #10
ceantuco
Member
 
Registered: Mar 2008
Location: New York
Distribution: Debian
Posts: 809

Original Poster
Rep: Reputation: 88
Thank you!
 
  


Reply


Thread Tools Search this Thread
Search this Thread:

Advanced Search

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is Off
HTML code is Off



Similar Threads
Thread Thread Starter Forum Replies Last Post
[SOLVED] System reporting tool vintage2010 Linux - Newbie 2 04-20-2011 02:31 PM
squid reporting tool shan_nathan Linux - Server 5 11-26-2009 07:16 AM
free reporting tool for squid jomy Linux - Networking 4 11-26-2009 06:09 AM
reporting tool ~= crystal reports chapzilla Linux - Newbie 1 08-11-2003 11:38 PM
Reporting Tool Bheki Linux - Newbie 0 05-21-2002 01:48 AM

LinuxQuestions.org > Forums > Linux Forums > Linux - Newbie

All times are GMT -5. The time now is 02:42 PM.

Main Menu
Advertisement
My LQ
Write for LQ
LinuxQuestions.org is looking for people interested in writing Editorials, Articles, Reviews, and more. If you'd like to contribute content, let us know.
Main Menu
Syndicate
RSS1  Latest Threads
RSS1  LQ News
Twitter: @linuxquestions
Open Source Consulting | Domain Registration