Re: SSH tunnel for Mysql

2005-12-08 Thread Karam Chand
If you are looking for a client to connect to MySQL using SSH tunnel, try out SQLyog. It has SSH Tunneling. Karam --- Jerry Swanson [EMAIL PROTECTED] wrote: How to create ssh tunnel for Mysql? TH __ Do You Yahoo!? Tired of spam? Yahoo! Mail

recursive queries

2005-12-08 Thread Duncan Miller
Title: DIY MTB Is there any built in or other support for recursive queries . I suspect not, but wonder what is considered the best approach. With stored procedures being supported in 5.0 is that the way to handle these. Thanks -- Duncan Miller [EMAIL PROTECTED] www.diymtb.com.au

DBManager Professional 3.2.0 Released

2005-12-08 Thread DBTools Software
DBTools Software is pleased to announce the new DBManager Professional Enterprise Edition 3.2.0. This release is not only a bug fix, but also brings a lot of improvements and new features. Check it ot the change log: New Features and Improvements a.. Query Builder Completely Redesigned with

Re: recursive queries

2005-12-08 Thread SGreen
Duncan Miller [EMAIL PROTECTED] wrote on 12/08/2005 06:40:55 AM: Is there any built in or other support for recursive queries . I suspect not, but wonder what is considered the best approach. With stored procedures being supported in 5.0 is that the way to handle these. Thanks --

Re: SSH tunnel for Mysql

2005-12-08 Thread Cal Evans
Jerry, SQLYog is great, I use it all the time. I've been on the BETA team for 3 years now and I buy at least one copy at every company I work for. Well worth the money if you are a serious MySQL developer. However, to answer your question, google for putty.exe. The docs explain to you how

Re: mysqldump dumping a table but not all columns?

2005-12-08 Thread sheeri kritzer
The mysqldump utility allows granularity up to tables, not columns. But you can use SELECT ... INTO OUTFILE to export the data: http://dev.mysql.com/doc/refman/5.1/en/select.html and then LOAD DATA INFILE (or LOAD DATA LOCAL INFILE) to import it. -Sheeri On 12/7/05, Test USER [EMAIL

Re: Question

2005-12-08 Thread sheeri kritzer
Hi Brandon, Not everyone on this list has worked with Sybase. An explanation of @@error and @@rowcount might be helpful. That being said, I think you want SHOW ERRORS: http://dev.mysql.com/doc/refman/5.1/en/show-errors.html (note there's also a SHOW WARNINGS that show you a deeper debug level:

Re: transaction with bdb table gives error Lock table is out of available locks

2005-12-08 Thread sheeri kritzer
Hi Marco, My hint is to read the BDB section of the manual: http://dev.mysql.com/doc/refman/5.0/en/bdb-start.html specifically the part that says: With the bdb_max_lock variable, you can specify the maximum number of locks that can be active on a BDB table. The default is 10,000. You should

Re: DBD::mysql will make but won't test on Solaris10...

2005-12-08 Thread Jake Peavy
Well I tried removing -lmtmalloc from the LIBS line. Like before, I was able to make but not make test. This time I just get a different error after test. I could look into solving this error, but is this just treating the symptoms though? Ideas welcome, TIA, F # /usr/local/bin/make test

Re: mysqldump dumping a table but not all columns?

2005-12-08 Thread Gleb Paharenko
Hello. As far as I know - it is impossible with mysqldump. You may want to use SELECT INTO OUTFILE to produce files with certain columns or create tab-separated files with --tab option and load specific columns using LOAD DATA INFILE. See:

Re: transaction with bdb table gives error Lock table is out of available locks

2005-12-08 Thread Jim Winstead
On 12/7/05, Marco Baroetto [EMAIL PROTECTED] wrote: Hi, I have a berkeley db table containing about 5 rows where I do this transaction (pseudocode follows): begin work delete from mytable where myfield='boo' /*delete about 100 rows*/ for (i=0; i=100; i++){ insert into mytable

re: would like more info on INSERT ... VALUES

2005-12-08 Thread James Black
-BEGIN PGP SIGNED MESSAGE- Hash: SHA1 In the manual (http://dev.mysql.com/doc/refman/5.0/en/insert.html) I saw this snippet: If you use an INSERT ... VALUES statement with multiple value lists But, I thnk I am missing some information on the syntax of INSERT ... VALUES. This may be what

Re: would like more info on INSERT ... VALUES

2005-12-08 Thread sheeri kritzer
Hi James, INSERT INTO table (a,b,c) VALUES (1,2,3),(4,5,6); is an example of inserting multiple rows with one insert statement, instead of these 2: INSERT INTO table (a,b,c) VALUES (1,2,3); INSERT INTO table (a,b,c) VALUES (4,5,6); That should give you enough to work with. -Sheeri On

re: would like more info on INSERT ... VALUES

2005-12-08 Thread SGreen
James Black [EMAIL PROTECTED] wrote on 12/08/2005 01:07:15 PM: -BEGIN PGP SIGNED MESSAGE- Hash: SHA1 In the manual (http://dev.mysql.com/doc/refman/5.0/en/insert.html) I saw this snippet: If you use an INSERT ... VALUES statement with multiple value lists But, I thnk I am

Alter MyISAM table to adjust max_rows and Avg_row_length

2005-12-08 Thread Jeff
I've got a table that just hit the 4gig limit for MyISAM tables in a 4.x ver db. I need to alter the table structure and set the max_rows and Avg_row_length to override the default of 4 gig. Problem is I can't find any refernce in the mysql docs that indicates how to decide a setting for

Optimize: 14 hours and still running!

2005-12-08 Thread Nathan Gross
On a 1.6ghz, 1gb ram, Linux machine running Mysql 4.1x. I have an Innodb table with over 20 million records and index size about 3.7 gig, data size 2.2gig (yes, many indexes, more space then the data itself). Last night I tried an Optimize from the Admin gui console (logged in as root at the

Re: Optimize: 14 hours and still running!

2005-12-08 Thread Robert L Cochran
I do not know the answer to this. I do think your machine is slow, and has too little memory. For such a large database you should have a faster processor and more memory. But, I cannot speak to how the Optimize action works. Bob Cochran Greenbelt, Maryland, USA Nathan Gross wrote: On a

RE: Optimize: 14 hours and still running!

2005-12-08 Thread Jeff McKeon
-Original Message- From: Nathan Gross [mailto:[EMAIL PROTECTED] Sent: Thursday, December 08, 2005 13:58 To: mysql@lists.mysql.com Subject: Optimize: 14 hours and still running! On a 1.6ghz, 1gb ram, Linux machine running Mysql 4.1x. I have an Innodb table with over 20 million

Re: Alter MyISAM table to adjust max_rows and Avg_row_length

2005-12-08 Thread Michael Stassen
Jeff wrote: I've got a table that just hit the 4gig limit for MyISAM tables in a 4.x ver db. I need to alter the table structure and set the max_rows and Avg_row_length to override the default of 4 gig. Problem is I can't find any reference in the mysql docs that indicates how to decide a

RE: Alter MyISAM table to adjust max_rows and Avg_row_length

2005-12-08 Thread Jeff
-Original Message- From: Michael Stassen [mailto:[EMAIL PROTECTED] Sent: Thursday, December 08, 2005 14:34 To: Jeff Cc: mysql@lists.mysql.com Subject: Re: Alter MyISAM table to adjust max_rows and Avg_row_length Jeff wrote: I've got a table that just hit the 4gig limit for

changing the UNIX user for mysql server startup

2005-12-08 Thread Perumal, Jai
Hi, We install the mysql version 5.0.16 on Linux Red hat as the root operating system user. After the install we changed the ownership and group to a mysql UNIX user. We tested starting and stopping the mysql server using the mysql UNIX user account and it worked fine. But when we reboot

Rpm installation problem

2005-12-08 Thread Logg, Connie A.
I am trying to install the following rpm on a red hat linux machine. MySQL-client-standard-5.0.16-0.rhel3.i386.rpm MySQL-devel-standard-5.0.16-0.rhel3.i386.rpm MySQL-server-standard-5.0.16-0.rhel3.i386.rpm MySQL-shared-standard-5.0.16-0.rhel3.i386.rpm

Mysqldump segmentation fault(core dumped)

2005-12-08 Thread ISC Edwin Cruz
Hi all! Look: mysql select version(); +---+ | version() | +---+ | 5.0.13-rc | +---+ 1 row in set (0.00 sec) mysql create database test1 charset='utf8'; Query OK, 1 row affected (0.01 sec) mysql use test1; Reading table information for completion of table and column names

Re: Optimize: 14 hours and still running!

2005-12-08 Thread Heikki Tuuri
Nathan, you can use SHOW INNODB STATUS\G to monitor how many rows per second it is inserting to the new, reorganized table. If the workload is disk-bound, it may be as low as 100 rows per second. Then inserting 20 million rows will take 2 days. Best regards, Heikki Oracle Corp./Innobase

Re: Mysqldump segmentation fault(core dumped)

2005-12-08 Thread Dan Nelson
In the last episode (Dec 08), ISC Edwin Cruz said: Hi all! Look: mysql select version(); +---+ | version() | +---+ | 5.0.13-rc | +---+ ... mysql quit Bye apps# mysqldump --databases test1 ... `d`.`idTCiudad`) and (`d`.`TEstado_idTEstado` = `e`.`idTEstado`));

MySQL newb trying to write a trigger...

2005-12-08 Thread Andre Turpin
So I'm trying to write some triggers to help synchronize account information between my master account database and a secondary database where I keep information for radius accounts. My SQL syntax sucks, and I don't have much luck reading the docs on the site (I might have a learning

Re: MySQL newb trying to write a trigger...

2005-12-08 Thread Paul DuBois
At 21:07 -0700 12/8/05, Andre Turpin wrote: So I'm trying to write some triggers to help synchronize account information between my master account database and a secondary database where I keep information for radius accounts. My SQL syntax sucks, and I don't have much luck reading the docs on

Re: recursive queries

2005-12-08 Thread Duncan Miller
I am looking to do a query on a self join table that returns the parent records. Obviously there are ways to do this, but just wondered if there are any functions in MySQL that make this easier, or specific functions available to stored procedures. I have read the manual and couldn't find

SELECT all except ... ?

2005-12-08 Thread Frank Rust
Is there a possibility to select all columns from a table except one or two columns? For example I have a table with 30 columns and want all columns but one column *not*. Do I have to write a very long select statement with 29 column names that i want to get? --

Re: changing the UNIX user for mysql server startup

2005-12-08 Thread Remo Tex
Perumal, Jai wrote: Hi, We install the mysql version 5.0.16 on Linux Red hat as the root operating system user. After the install we changed the ownership and group to a mysql UNIX user. We tested starting and stopping the mysql server using the mysql UNIX user account and it worked fine.