Which tool to use for developing Pl/Sql on MySQL?

2010-07-15 Thread alba.albetti
Hi, beginning to work with MySQL I've found there exist two similar tools for browsing the db and developing in Pl/Sql and they are SQL-Front and MySQL Query Browser. Fot not wasting time in learning both can anyone tell me which of these is generally used wordwide? So I make practice with the

Re: Which tool to use for developing Pl/Sql on MySQL?

2010-07-15 Thread Suresh Kuna
Go with MySQL Query Browser On Thu, Jul 15, 2010 at 1:14 PM, alba.albetti alba.albe...@libero.itwrote: Hi, beginning to work with MySQL I've found there exist two similar tools for browsing the db and developing in Pl/Sql and they are SQL-Front and MySQL Query Browser. Fot not wasting time

Re: Which tool to use for developing Pl/Sql on MySQL?

2010-07-15 Thread Martijn Tonies
I use Database Workbench, but might be biased ;-) www.upscene.com - there's a free Lite edition available. With regards, Martijn Tonies Upscene Productions http://www.upscene.com Download Database Workbench for Oracle, MS SQL Server, Sybase SQL Anywhere, MySQL, InterBase, NexusDB and

Re: Which tool to use for developing Pl/Sql on MySQL?

2010-07-15 Thread John Daisley
I think MySQL Query Browser has been replaced by the tool MySQL Workbench. This combines the features of the old MySQL Workbench, MySQL Administrator and MySQL Query Browser. Big improvement on the old individual tools! You can download it from http://wb.mysql.com/ On 15 July 2010 08:44,

Incorrect key file for table '/var/lib/mysql/.tmp/#sql_d57_2.MYI' ??

2010-07-15 Thread Per Jessen
What does this error mean? mysql select ipaddr,reverse,count(distinct domain) from mxdata,domain group by ipaddr; ERROR 126 (HY000): Incorrect key file for table '/var/lib/mysql/.tmp/#sql_d57_2.MYI'; try to repair it /Per Jessen, Zürich -- MySQL General Mailing List For list archives:

Re: Incorrect key file for table '/var/lib/mysql/.tmp/#sql_d57_2.MYI' ??

2010-07-15 Thread Per Jessen
Per Jessen wrote: What does this error mean? mysql select ipaddr,reverse,count(distinct domain) from mxdata,domain group by ipaddr; ERROR 126 (HY000): Incorrect key file for table '/var/lib/mysql/.tmp/#sql_d57_2.MYI'; try to repair it Please ignore. /Per Jessen, Zürich -- MySQL

Re: How to become a DBA on MySQL

2010-07-15 Thread Nilnandan Joshi
Below link might be help you. http://forge.mysql.com/wiki/MySQL_University mailto:nilnand...@synechron.com regards, Nilnandan Jerry Schwartz wrote: Sorry, I wish I did. I've used courses at lvsonline.com for all kinds of things (programming, graphics, etc.), but I didn't see anything about

Why is MySQL always linked to Php?

2010-07-15 Thread alba.albetti
Browsing the Web I've seen that usually companies look for developers working on MySQL and Php. Why are the two things linked? I mean I've not found any requests for just a MySQL developer or DBA (as for example it happens for Oracle), but it's always requested a MySQL/Php expert. I ask for it

Re: Why is MySQL always linked to Php?

2010-07-15 Thread mos
At 09:00 AM 7/15/2010, alba\.albetti wrote: Browsing the Web I've seen that usually companies look for developers working on MySQL and Php. Why are the two things linked? I mean I've not found any requests for just a MySQL developer or DBA (as for example it happens for Oracle), but it's

RE: Why is MySQL always linked to Php?

2010-07-15 Thread Steven Staples
MySQL and PHP go together very well in the web development world. Almost all of PHP websites use MySQL as their database storage engine, as almost all hosting companies have installed PHP and MySQL on their servers. Maybe the jobs you're looking at, are for programmers/developers, who can take

Re: Why is MySQL always linked to Php? The history channel version...

2010-07-15 Thread Andrés Tello
HIstorical convinience: A certification program for oracle or db2 requires a lot of money and time. The facilities oracle and db2 can offer to the dba includes things that the S.O should to. Exaple: raw spaces and table spaces, hot copy, replication, etc... Many of this facilities used to be

Mysql 4 and or Partitions.

2010-07-15 Thread Andrés Tello
Ok... I solved my mistery of the slow 22G table rebuild the kernel to support memory and now things are working. But still quite slow. I do sum() operations over the 22G table. I'm using the latest version of mysql 4... (I WILL migrate soon, I promise), one thing I have notice, is that

RE: Mysql 4 and or Partitions.

2010-07-15 Thread Gavin Towey
Use indexes before thinking about partitions. -Original Message- From: Andrés Tello [mailto:mr.crip...@gmail.com] Sent: Thursday, July 15, 2010 8:44 AM To: mysql Subject: Mysql 4 and or Partitions. Ok... I solved my mistery of the slow 22G table rebuild the kernel to support memory

RE: Why is MySQL always linked to Php?

2010-07-15 Thread Daevid Vincent
-Original Message- From: alba.albetti [mailto:alba.albe...@libero.it] Sent: Thursday, July 15, 2010 7:00 AM To: mysql Subject: Why is MySQL always linked to Php? Browsing the Web I've seen that usually companies look for developers working on MySQL and Php. Why are the two

Re: Why is MySQL always linked to Php?

2010-07-15 Thread Michael Dykman
It's not so much that MySQL goes with PHP as much as PHP goes with MySQL. PHP applications are, for the most part, not that ambitious and mysql is simply the most accessible database with the best developed API. I have developed applications using MySQL as a back end under a huge number of

Re: Why is MySQL always linked to Php?

2010-07-15 Thread Rob Wultsch
On Thu, Jul 15, 2010 at 7:00 AM, alba.albetti alba.albe...@libero.it wrote: Browsing the Web I've seen that usually companies look for developers working on MySQL and Php. Why are the two things linked? I mean I've not found any requests for just a MySQL developer or DBA (as for example it

Myisam advantages

2010-07-15 Thread P.R.Karthik
Hi, I am newbie to mysql can i know the advantages of myisam storage engine and some of its special features. -- Regards Karthik.P.R kart...@mafiree.com