RE: Import DBF data into MySQL table

> Is there a way to directly import DBF data into MySQL table > or do I HAVE to convert it into CSV (Using EXCEL) or some > other method? Not as far as i know, but there are some tools out there. Do a google for "dbf2mysql". Regards, TomH -- PROSOFT EDV-Loesungen GmbH & Co. KGphone: +49

multiple return values from SP or workaround ?

Is there any way to return multiple result variables from a stored procedure? And I guess the answer is NO. Or does anyone know how I can Concatenate (using the CONCAT function) to glue together my multiple results into one string that then can be post processed in perl. EG: query on table

PHP MySQL (Intel Compiler) Problem

Dear Friends, I am trying to compile PHP with MySQL support in an HP DL380 server (Xeon Processors). The MySQL is build with Intel Compiler. I am getting the following problem / error : --- /usr/local/mysql/lib/libmysqlclient.a(libmysql.o)(.text+0x1ade): In function `st

RE: how to create a user with limited privileges

Hi Rajashik, This is documented very well in the manual at http://dev.mysql.com/doc/mysql/en/GRANT.html#IDX1697 You would want the GRANT statement and only allow them SELECT privileges on the tables you wish them to view. eg. GRANT SELECT on test.* to user@"somehost.%" IDENTIFIED BY "password";

how to create a user with limited privileges

Hi all, I would like to know the mysql command to do the following: Create a user (who will access mysql database), with privilaeges so that, he can only retrieve the information in the data base (values in the tables), he should not be able to alter, update, delete any table values. Kindly h

hosted application data design

Hi all, I'm designing a hosted application that many clients will access. I've got all sites running off one PHP code base quite nicely, and now I'm hoping to reduce the multiple databases down to just one shared DB. (Note: at this stage, all accounts are fictional, so there's no legacy data t

Re: UPDATE string segment?

Wow! That works. Thanks a bunch! While we're at it, I have one more hang-up: Is there a (DISTINCT?) statement that will select the distinct folder path(s) of every entry in the table? For instance, if I have three files: "/Volumes/External HD/aFolder/aFile.pdf" "/Volumes/External HD/aFolder/a

mysql Architecture

Hi All, I would like to know some information about the MySql architecture. All the other databases have some info about their architecture in the documentation. But I havent found any documentation on the mysql architecture. Please refer me some websites or download liks where I can get some inf

Re: UPDATE string segment?

You can use the replace string function: update table set file_path=replace(file_path,'aFolder','aFolder/aChildFolder'); In each update aFolder will be replaced by the new path. John Mistler wrote: I have a column that holds hard disk file location info such as: "/Volumes/External HD/aFolder/aFil

Re: Server hanging

Back in 3.23.x we used to see MySQL hang on a corrupt table (typically caused by an improper shutdown). A kill -9 was needed to stop the process, upon restart we'd run a mysqlcheck (MyISAM tables) and repair the table. We didn't see anything obvious in the logs except the last query, which was

RE: Replication bug?

David, I haven't ever attempted to delete the slave user on the master, and since I only run replication on 4.1 boxes and not 4.0 boxes, I won't be able to help much. But I would probably submit it to http://bugs.mysql.com and they can verify that it is a bug. But they will probably not recommend

UPDATE string segment?

I have a column that holds hard disk file location info such as: "/Volumes/External HD/aFolder/aFile.pdf" "/Volumes/External HD/aFolder/anotherFile.pdf" etc. . . (many files located in the same folder) Can anyone suggest a single statement (or multiple) that would update every file location locate

Replication bug?

Hi Folks, We are trying to put a monitoring solution in place at a client and have come up against something during testing. If the replication user disappears off the master and the slave cannot log in, the Slave_IO_Thread still shows running and no error in the last error number field. Does anyb

Replication failed

Hi, I've set up a master-slave MySQL configuration. When I do: LOAD DATA FROM MASTER on the slave I get the following error: ERROR 1189: Net error reading from master . Errorlog displays: create_table_from_dump: failed in handler::net_read_dump() The master logs displays nothing. A few databas

RE: tuning suggestion for large query

Thanks Mike. Seems like even with handler, the big query process is still consuming all my RAM and swap and being killed with error 'VM: killing process mysql __alloc_pages: 0-order allocation failed (gfp=0x1d2/0)' I would like to find a startup parameter either for client or server to limit per

Re: tuning suggestion for large query

At 10:40 AM 9/1/2004, you wrote: Hi, We have a job that do 'select * from big-table' on a staging mysql database, then dump to data warehouse, it is scheduled to run once a day, but may be run manually. Also we have several other small OLTP database on the same server. When the big job run, it w

Re: bad "too many connections" error (os x)

This also may caused by the TTL of the http socket and the launched zombie forks by the http/php server ( the FIN_WAIT_2 problem!!). Thats what it happend to me . I dunno who waited for who, and became zombie, was it MySQL waiting for timeout or was socket wating to timeout. You can test this e

Import DBF data into MySQL table

Ave, Is there a way to directly import DBF data into MySQL table or do I HAVE to convert it into CSV (Using EXCEL) or some other method? Thanks. -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

Re: another insert/select for multiple tables... (or, determining previous auto-increment ID)

Yes, LAST_INSERt_ID(). It's connection-specific, not db-specific. Because it is connection-specific, your 2-users issue is avoided. See the manual for the details . Michael Eve Atley wrote: The question: Is there anything in MySQL that

Re: another insert/select for multiple tables... (or, determining previous auto-increment ID)

Since you should still have the same information that you used to create your entry in the candidate table you can do something like: SELECT @candidateID := Candidate_ID FROM candidate WHERE Last_Name = '$lastname' AND First_Name = '$firstname' AND Middle_Initial = '$middle' IN

DESPERATE: Disconnect from Database Question

Hi folks, heres a real stupid question, but Im baffled. I am running MySQL v . 4.1.3b-beta-nt , JVM 1.4.2_05-b04 by SUN, Tomcat 5.0.27,Windows 2000 Server Im attempting to run SERVLETS for my application. I have a HTML form to kick off my application in Tomcat App Manager.

another insert/select for multiple tables... (or, determining previous auto-increment ID)

The question: Is there anything in MySQL that will allow me to determine, accurately, the last auto-incremented field from a particular database, so I can then insert based upon this into another table? What if 2 users input at the same time? Please see the 'long explanation' for further details.

Re: Table dump into binary

Have you looked at the manual? The program mysqldump jumps to mind: http://dev.mysql.com/doc/mysql/en/mysqldump.html Shawn Green Database Administrator Unimin Corporation - Spruce Pine Seena Blace <[EMAIL PROTECTED]> 09/01/2004 02:04 PM To [EMAIL PROTECTED] cc [EMAIL PROTECTED], Seena Blac

Re: Table check and tips

My comments intermixed below :-) Stuart Felenstein <[EMAIL PROTECTED]> wrote on 09/01/2004 12:30:19 PM: > While I currently have about a dozen tables, I'd like > to throw this one up for any opinions, suggestion, > warnings, things I may not be saying. It's not a > started entity - schema diagr

Re: insert/select for multiple tables...

Bruce, Sorry, I guess I wasn't clear. I understood what you were asking, and I thought I answered it. Your search of the mysql docs and google found nothing about multiple-table inserts because you can't do that. I think the mysql manual page I referenced is clear: INSERT Syntax INSERT [LOW_

Server hanging

Hello, I had a problem with our MySQL server-4.0.18 where it suddenly stoped working. Even a KILL command didn´t killed the mysqld process. I looked for any error message in the file /usr/local/mysql/hostname.err, but I couldn´t see any error message about such time. Does anyone knows what could

Table dump into binary

how to take binary/ascii dump of table? [EMAIL PROTECTED] wrote:AFAIK, MySQL servers can only talk to other MySQL servers and that is only through the replication protocol/connections. Beyond that you will need to make your server-to-server connections through some kind of external client. Ca

RE: insert/select for multiple tables...

At 10:52 -0700 9/1/04, bruce wrote: michael... it was meant as an example, to convey what i want to do, which is do a simltaneaous insert into multiple tables at the same time. the syntax concerning the left join/elements to be inserted was not intended to be syntacticly (sp?) correct!!! and as i s

Re: 4.1.4-gamma cannot compile

At 16:14 +0800 9/1/04, Unreal HSHH wrote: got thie error and broken when making mysql 4.1.4-gamma automake-1.7: not found WARNING: `automake-1.7' is needed, and you do not seem to have it handy on your system. You might have modified some files without having the proper tools fo

RE: insert/select for multiple tables...

michael... it was meant as an example, to convey what i want to do, which is do a simltaneaous insert into multiple tables at the same time. the syntax concerning the left join/elements to be inserted was not intended to be syntacticly (sp?) correct!!! and as i stated, searching through mysql doc

4.1.4 still reports itself as 4.1.3b-beta

I have tried several instals (Windows XP), using binaries from several of the mirrors, over a 4.1.3b-beta-log version. No errors reported during any install, but it still reports itself as the 4.1.3b-beta-log version - both in MySQL Administrator (v 1.0.12) and at the command line opening of m

Re: insert/select for multiple tables...

bruce wrote: hi... trying to figure out how to structure an insert/select for a multiple table situation... sort of... insert table1, table2 (table1.item1, table1.item2, table2.item1,...) select a.q1, b.q2 from a1 left join a2 on a2.t=a1.t where a2.r='4'; i can't seem to figure out the sy

Re: bad "too many connections" error (os x)

This would make sense since they all the connections are coming from the same website. But if this is true, then why can't we connect using 'mysqladmin -uroot'? Shouldn't that work from any host? Thanks, Michael On Sep 1, 2004, at 9:08 AM, Victor Pendleton wrote: Is it a too many connections o

Re: Database connectivity

AFAIK, MySQL servers can only talk to other MySQL servers and that is only through the replication protocol/connections. Beyond that you will need to make your server-to-server connections through some kind of external client. Can Oracle act as a client to foreign databases? If it cannot, I bel

RE: bad "too many connections" error (os x)

Not if the host that is blocked is `localhost`. -Original Message- From: Michael Winston To: Victor Pendleton Cc: '[EMAIL PROTECTED] ' Sent: 9/1/04 11:24 AM Subject: Re: bad "too many connections" error (os x) This would make sense since they all the connections are coming from the same

Re: bad "too many connections" error (os x)

Michael Winston wrote: On Sep 1, 2004, at 9:10 AM, V. M. Brasseur wrote: Michael Winston wrote: Hi- We've been running into a pretty serious problem for the past several versions of mysql 4.0 running on OS X (both client and server). Every once in a while we wake up to find the "too many connec

MySQL 4.0 Installation Fault

Hi, I've used MySQL 3.23 on Redhat 9 for a long time. Recently, I'm thinking of using MySQL 4 because some applications need it. I download a rpm from mysql.com and have it rpm. It can't start and comes up with problem as -== terribly wrong... Bogus stack limit or frame pointer, fp=0xbfffd2b8, st

Re: bad "too many connections" error (os x)

Michael Winston said: > > On Sep 1, 2004, at 9:10 AM, V. M. Brasseur wrote: > >> >> >> Michael Winston wrote: >>> Hi- >>> We've been running into a pretty serious problem for the past several >>> versions of mysql 4.0 running on OS X (both client and server). >>> Every once in a while we wake up t

RE: Database connectivity

What will the connection be used for? Replication? Query between datasources? There are some third party applications such as Golden Gate that have replication products. You could also write the connection yourself in a language such as Java or C. -Original Message- From: Seena Blace To:

Table check and tips

While I currently have about a dozen tables, I'd like to throw this one up for any opinions, suggestion, warnings, things I may not be saying. It's not a started entity - schema diagram but should be clear for the purposes of the email. "Table: Posts" (innodb) -

Re: Database connectivity

Hi, I wanted to setup connectivity between mysql database and oracle database.I have one database in mysql from which all tables data I want to insert real time data into oracle database.How to connect mysql database with oracle database? thanks -

insert/select for multiple tables...

hi... trying to figure out how to structure an insert/select for a multiple table situation... sort of... insert table1, table2 (table1.item1, table1.item2, table2.item1,...) select a.q1, b.q2 from a1 left join a2 on a2.t=a1.t where a2.r='4'; i can't seem to figure out the syntax for t

Re: bad "too many connections" error (os x)

On Sep 1, 2004, at 9:10 AM, V. M. Brasseur wrote: Michael Winston wrote: Hi- We've been running into a pretty serious problem for the past several versions of mysql 4.0 running on OS X (both client and server). Every once in a while we wake up to find the "too many connections" error coming up

Re: bad "too many connections" error (os x)

I think that there is an error in your code. I have had this problem with a small application I wrote: The problem arises when you don't send the quit command to mysql before dropping tcp. You must send a quit command in every case (if you opened a socket). I can not be more precise because i don'

MySQL/InnoDB-4.1.4 is released

Hi! InnoDB is a MySQL table type that provides foreign key constraints, ACID transactions, row-level locking, consistent (MVCC) non-locking reads, transaction savepoints, and a commercial InnoDB Hot Backup tool to MySQL. InnoDB is included in all MySQL releases, except the commercial 'MySQL Classi

Re: bad "too many connections" error (os x)

Michael Winston wrote: Hi- We've been running into a pretty serious problem for the past several versions of mysql 4.0 running on OS X (both client and server). Every once in a while we wake up to find the "too many connections" error coming up. There really aren't too many connections (we ha

RE: bad "too many connections" error (os x)

Is it a too many connections or Host blocked because of many connection erros? If it is the later you have reached max_connect_errors and need to issue flush-hosts. -Original Message- From: Michael Winston To: [EMAIL PROTECTED] Sent: 9/1/04 11:02 AM Subject: bad "too many connections" erro

bad "too many connections" error (os x)

Hi- We've been running into a pretty serious problem for the past several versions of mysql 4.0 running on OS X (both client and server). Every once in a while we wake up to find the "too many connections" error coming up. There really aren't too many connections (we have our max set to 99) -

Compiling MySQL with OpenSSL on alternate location

All, I am trying to compile MySQL with OpenSSL in an alternate location ( /data/OpenSSL ). When I do that either configure will say that no installation of OpenSSH is there (even with the --with-openssl-includes= and --with-openssl-libs= ), or it will compile without OpenSSL support ( show varia

tuning suggestion for large query

Hi, We have a job that do 'select * from big-table' on a staging mysql database, then dump to data warehouse, it is scheduled to run once a day, but may be run manually. Also we have several other small OLTP database on the same server. When the big job run, it would use all the physical mem and

Re: 1 day 28 min insert

Mikhail Entaltsev wrote: You _could_ try adding an identical primary key to the stat_in table as you have on the 321st_stat table. However, since we need all of the rows from stat_in in the results, I am not sure that it will help speed up the join (because it's a left join). Even though I think th

Compiling MySQL with OpenSSL

All, I am trying to compile MySQL with OpenSSL in an alternate location ( /data/OpenSSL ). When I do that either configure will say that no installation of OpenSSH is there (even with the --with-openssl-includes= and --with-openssl-libs= ), or it will compile without OpenSSL support ( show vali

Re: temporary tables and replication

I believe some versions of 4.0 have problem with auto dropping temporary tables in replication. The easy fix is to drop temporary tables when you are finished with them instead of relying on mysql to do it for you. -- Eric Bergen [EMAIL PROTECTED] On Wed, 1 Sep 2004 08:16:43 -0600, Alfredo Cole

Re: A question of negative numbers..

[EMAIL PROTECTED] wrote: Hi, I have a query that returns a list of numbers ranging from -10 to +10 I would like to be able to have a 2nd column where a result of 5 is 5 but -5 is also 5, so in effect all the negative (and only the negative) results are made positive to find the deviation from zero.

temporary tables and replication

Hi: I'm using MySQL 4.0, and have setup replication with one server and one slave, both running LM 9.1. My application creates a temporary table on the master, which is supposed to be deleted when the connection is closed. When that happens, replication stops with the following message: ERROR:

sort_buffer_size error, or 1034?, I think it's erroring wrong

Greetings- I have the binary dist of 4.0.20 running on a fairly adequate box (dualxeon,6gbRAM). I try to alter a table which has 733k rows and get the following: mysql> ALTER TABLE `CPULoad` CHANGE `TIME` `TIME` VARCHAR( 24 ) NOT NULL; ERROR 1034: sort_buffer_size is to small 'Huh?' I say

Re: mysqldump all tables except 2 in a database

I would use the --tables option of mysqldump. It accepts more than one table name, so all you need to do is make a list of the tables you want dumped. If you are combining --tables with other options (like -B/--databases or -u or -p) make sure the --tables option is the LAST parameter in the li

Re: Multiple JOINs

Rhino wrote: > Okay, you've convinced me that you need some Left Joins ;-) > > I think you'll have to use a mix of Left Joins and Inner Joins. In > the cases where you need a row even if something doesn't exist, like > a subject who has an address but no phone number, use a Left Join. In > any cas

Cannot compile mysql 4.1.x in FreeBSD5.3-BETA2

Compile 4.1.4, gcc -O3 -DDBUG_OFF -pipe -march=pentium4 -fno-omit-frame-pointer -O3 -D_THREAD_SAFE -o myisamchk myisamchk.o -static -D_THREAD_SAFE -D_THREAD_SAFE libmyisam.a ../mysys/libmysys.a ../dbug/libdbug.a ../strings/libmystrings.a -lz -lkse -lcrypt -lm -lkse /usr/lib/libc.a(isnan.o)(.text+0

Problem on InnoDB - Tablespace enough but engine said table full

I have MySQL for heavy duty job . here is my InnoDB table space definition innodb_data_file_path = /data0/ibdata1:10M;/data0/ibdata2:10M;/data0/ibdata3:1082M;/data0/ibdata4:1500M;/data0/ibdata5:1500M;/ data0/ibdata6:1500M;/data0/ibdata7:1500M;/data1/ibdata8:1500M;/data1/ibdata9:1500M;/dat

Re: A question of negative numbers..

ABS(column) ? - Original Message - From: <[EMAIL PROTECTED]> To: <[EMAIL PROTECTED]> Sent: Wednesday, September 01, 2004 6:59 AM Subject: A question of negative numbers.. Hi, I have a query that returns a list of numbers ranging from -10 to +10 I would like to be able to have a 2nd col

MySQL Administrator 1.0.12 and MySQL Query Browser 1.0.7-beta Released

MySQL Administrator 1.0.12 and MySQL Query Browser 1.0.7-beta have been released. MySQL Administrator is a GUI management console for MySQL, with support for tasks such as managing users, configuring MySQL, performing backups, editing table definitions etc. More information at: http://ww

Re: A question of negative numbers..

<[EMAIL PROTECTED]> wrote on 01/09/2004 11:59:58: > is there a function to make negative > numbers positive? ABS(x) See http://dev.mysql.com/doc/mysql/en/Mathematical_functions.html Alec -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:

RE: A question of negative numbers..

Found answer to my own question: Returns the absolute value of X: mysql> SELECT ABS(2); -> 2 mysql> SELECT ABS(-32); -> 32 This function is safe to use with BIGINT values. MySQL Reference Manual (C) 2002 MySQL AB

Re: A question of negative numbers..

abs() - Original Message - From: <[EMAIL PROTECTED]> To: <[EMAIL PROTECTED]> Sent: Wednesday, September 01, 2004 12:59 PM Subject: A question of negative numbers.. Hi, I have a query that returns a list of numbers ranging from -10 to +10 I would like to be able to have a 2nd column whe

A question of negative numbers..

Hi, I have a query that returns a list of numbers ranging from -10 to +10 I would like to be able to have a 2nd column where a result of 5 is 5 but -5 is also 5, so in effect all the negative (and only the negative) results are made positive to find the deviation from zero. so 5, 4, -3, 4, -1,

Re: CHECK TABLE looks up all databases.

Fredrik Carlsson <[EMAIL PROTECTED]> wrote: > I have some questions regarding CHECK TABLE, OPTIMIZE TABLE. When i run > these commands on table1 mysql seems to lock up all other databases, is > it possible to run these things in the "background" so that other > databases can be accessible. No.

Re: How to admin a server that currently has too many connections?

Justin Swanhart <[EMAIL PROTECTED]> wrote: > The problem is that another application has been issuing queries > against the table and those queries have never timed out. So now I > can't kill the connections, because I can't make a database connection > to mysql to even see their thread ids: > >

Re: Optimize table time estimation...

Christopher M Bergeron <[EMAIL PROTECTED]> wrote: > Does anyone know of any guidelines or references that I can refer to > with regard to how long it takes to Optimize tables? I'm running on a > 3GHz x86 [single] processor box with SCSI RAID and lots of ram. The > Mysql db files are approx. 35G (u

Re: 4.1.4-gamma cannot compile

fix by configure with --without-libedit --without-readline On Wed, 1 Sep 2004 16:23:36 +0800, Unreal HSHH <[EMAIL PROTECTED]> wrote: > Run > aclocal; autoheader; autoconf; automake > I got many warning and one error: > > aclocal general some warning: > configure.in:277: warning: underquoted defin

Re: Per Thread CPU usage

Frank <[EMAIL PROTECTED]> wrote: > is it somehow possible to log how much CPU time a thread (or query) > consumed? (this is only for debugging purposes) man mpstat This may help. -- For technical support contracts, goto https://order.mysql.com/?ref=ensita This email is sponsored by Ensita

Re: Crash on Windows XP SP2 when not run as an administrator

On 31 Aug 2004 at 17:33, Todd O'Bryan wrote: > I've tested mysql in my high school lab running from an administrator > and from a student account, both from within the Cygwin terminal, and > at the Windows command prompt. From the administrator account, it runs > fine for hours. From the studen

Re: [PHP] How to Select multiples tables of different database in one query

Warning 2 : it is a mysql example. Whith other DBM, i don't know how to do that, but i think that its exactly the same thing. PHP version : mysql_query($query). Fred. Tariq Murtaza wrote: *Hi All,* Can someone elaborate on How to Select multiples tables of different database in one query, pertic

Re: [PHP] How to Select multiples tables of different database in one query

Not difficult : database db1 database db2 database db3 select db1.table3.column2, db2.table5.column1, db3.table1.column7 FROM db1.table3, db2.table5, db3.table1; You can use alias in FROM on table like this : select alias1.column2, alias2.column1, alias3.column7 FROM db1.table3 AS alias1, db2.ta

Re: Mysql and errno 13 on RedHat

HI again, This multiple mysql proccesses are nothing to worry about - these are the threads that mysql opens to accept incoming connections. You can configure the maximum number of connections and the mysql memory usage in the /etc/my.cnf file. On Wednesday 01 September 2004 02:14, Yannick Warn

Re: Is their still any reason why Stored Procedure calls are not supported in MySql?

Please > Stored procedures are in the works for MySQL 5.0: > > http://dev.mysql.com/doc/mysql/en/TODO_MySQL_5.0.html > > The manual is your friend. Don't quote an entire message/digest to add 3 lines. With regards, Martijn Tonies -- MySQL General Mailing List For list archives: http:

Re: Is their still any reason why Stored Procedure calls are not supported in MySql?

Please > Firstly, >I do appologize for my ignorance in advance. I read the message regarding PRODUCT() and Don't quote an entire digest to write a new message. With regards, Martijn Tonies -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:h

Re: 4.1.4-gamma cannot compile

Run aclocal; autoheader; autoconf; automake I got many warning and one error: aclocal general some warning: configure.in:277: warning: underquoted definition of AC_SYS_COMPILER_FLAG run info '(automake)Extending aclocal' or see http://sources.redhat.com/automake/automake.html#Extending%20acloc

4.1.4-gamma cannot compile

got thie error and broken when making mysql 4.1.4-gamma automake-1.7: not found WARNING: `automake-1.7' is needed, and you do not seem to have it handy on your system. You might have modified some files without having the proper tools for further handling them. Check the `READM