Re: changing the UNIX user for mysql server startup

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.

SELECT all except ... ?

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: recursive queries

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 any

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

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 th

MySQL newb trying to write a trigger...

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 disability...u

Re: Mysqldump segmentation fault(core dumped)

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`.`i

Re: Optimize: 14 hours and still running!

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 O

Mysqldump segmentation fault(core dumped)

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 nam

Rpm installation problem

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 MySQL-standard-debuginfo-5.0.16-0.rhel3.i386.

changing the UNIX user for mysql server startup

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 t

RE: Alter MyISAM table to adjust max_rows and Avg_row_length

> -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 li

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 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 setti

RE: Optimize: 14 hours and still running!

> -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

Re: Optimize: 14 hours and still running!

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 1.6

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 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 host

Alter MyISAM table to adjust max_rows and Avg_row_length

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 Avg_row_

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

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

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

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 12/8/05,

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

-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: transaction with bdb table gives error "Lock table is out of available locks"

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: mysqldump dumping a table but not all columns?

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: http://dev.mysql.com/doc/refman/5.0/en/select.html

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

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 PER

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

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 i

Re: Question

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: mysqldump dumping a table but not all columns?

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 PROTECTED

Re: SSH tunnel for Mysql

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 to

Re: recursive queries

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 >

DBManager Professional 3.2.0 Released

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 plen

recursive queries

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 0429

Re: SSH tunnel for Mysql

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!