Solved

Is there a free alternative to MySql Administrator for Linux that supports stored procedures?

Posted on 2008-06-17
13
446 Views
Last Modified: 2012-05-05
I'm curious of moving my php development to it's native environment - Linux...
XAMPP (package of apache/php/mysql etc) is succesfully installed and the only thing that's stopping me is that the Linux version of MySql Administrator s.. , is not very good. (strange 'cause windows version is).

Are thare any good free (of charge) alternatives around? They must support stored procedures and views.
0
Comment
Question by:davidsperling
  • 7
  • 6
13 Comments
 
LVL 10

Expert Comment

by:bluefezteam
ID: 21800744
Heard positive comments regarding SQLyog

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

Alternatively you pay for what you get so free stuff can be limited, you could try Navicat which has received rave reviews from friends and collegaues working with PHP and MySQL
0
 
LVL 10

Accepted Solution

by:
bluefezteam earned 500 total points
ID: 21800747
30 day demo to see if it suits your needs:
http://www.navicat.com/download.html
0
 
LVL 4

Author Comment

by:davidsperling
ID: 21800826
Thanks, I'll try out SQLyog.

$129 to replace the defective Linux-MA!? Think I'll rather stick to win :-)
(If it's not darn good)
0
What is SQL Server and how does it work?

The purpose of this paper is to provide you background on SQL Server. It’s your self-study guide for learning fundamentals. It includes both the history of SQL and its technical basics. Concepts and definitions will form the solid foundation of your future DBA expertise.

 
LVL 4

Author Comment

by:davidsperling
ID: 21801152
Hmm i see no Linux version for SQLyog-community, only source. The enterprise version is quite expensive...
0
 
LVL 10

Expert Comment

by:bluefezteam
ID: 21801201
0
 
LVL 10

Expert Comment

by:bluefezteam
ID: 21801269
yeah navicat is available for none commercial use... so as long as its for personal use and you aren't profitting commercially you are fine.

When you're in a situation to profit commercially you won't mind giving them some cash to upgrade.
Non Commercial - LINUX download
http://www.navicat.com/download.php?id=3

As they suggest though, install the 30 day demo to see the difference between the Lite and the Pro version, you may only need lite - and that's free
0
 
LVL 10

Expert Comment

by:bluefezteam
ID: 21802346
hope that's worked for you - look forward ot the points ;0)
0
 
LVL 4

Author Comment

by:davidsperling
ID: 21811549
Navicat Lite can't backup/restore database... :-(
0
 
LVL 10

Expert Comment

by:bluefezteam
ID: 21814916
but if you leave MySql Administrator you could use that to backup?

Using for the improved GUI in Navicat for everything else??? They are both interfaces to the same system
0
 
LVL 10

Expert Comment

by:bluefezteam
ID: 21814983
meant to say if you leave MySql Administrator installed!
0
 
LVL 4

Author Comment

by:davidsperling
ID: 21844201
Actually backup/restore is one of the things that sucks with the Linux version of MySql Administrator. It did not behave like the windows version with the same settings. The win version have no proplems restoring to Linux server, so it's not an OS issue.

Maybe you could use Navicat Lite and use command line for backup restore...
0
 
LVL 4

Author Comment

by:davidsperling
ID: 21846257
Ok, I'll take the silence for an answer... There are no good free MySQL admin tools for linux. Navicat Lite is the best shot in conjunction w/ command line.
0
 
LVL 4

Author Comment

by:davidsperling
ID: 21846272
-
0

Featured Post

Ransomware-A Revenue Bonanza for Service Providers

Ransomware – malware that gets on your customers’ computers, encrypts their data, and extorts a hefty ransom for the decryption keys – is a surging new threat.  The purpose of this eBook is to educate the reader about ransomware attacks.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

As a database administrator, you may need to audit your table(s) to determine whether the data types are optimal for your real-world data needs.  This Article is intended to be a resource for such a task. Preface The other day, I was involved …
Load balancing is the method of dividing the total amount of work performed by one computer between two or more computers. Its aim is to get more work done in the same amount of time, ensuring that all the users get served faster.
Established in 1997, Technology Architects has become one of the most reputable technology solutions companies in the country. TA have been providing businesses with cost effective state-of-the-art solutions and unparalleled service that is designed…
Although Jacob Bernoulli (1654-1705) has been credited as the creator of "Binomial Distribution Table", Gottfried Leibniz (1646-1716) did his dissertation on the subject in 1666; Leibniz you may recall is the co-inventor of "Calculus" and beat Isaac…

820 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question