Re: Hanging on Inserts

2001-07-30 Thread DS
Hi All, Well, it looks like nobody has any ideas about this. Not quite sure what the readership is but I was hoping someone might hae an Idea. If I could buy you a beer for helping I would. If anyone knows a consultant that could answer this question ( or someone here want to give an answer for $

Connecting database and XML pages

2001-07-30 Thread annemarie . hartvigsen
Hi, I have a mySQL database. I also have a web server: Apache-Tomcat-Cocoon. I want to make web pages written in XML, transformed to HTML or WML by the help of Cocoon. These pages will serve as an interface to the database. What is the best way to connect the database with the XML pages? My user

RE: Valuable information

2001-07-30 Thread Manuel Barrientos
WHAT KIND OF SHIT IS THIS? I think it is a shame to take advantage of a list to spread this type of trash. Does it have anything to do with mysql, databases,...? NO. I repeat: IT'S A SHAME > -- > De: Heidi Fredel[SMTP:[EMAIL PROTECTED]] > Para: [EMAIL PROTECTED] > Asunto:

RE: permissions, Help for Newbie, question

2001-07-30 Thread ididdy
say i am running a server with mysql and phpmyadmin and i have some dbs (including of course the mysql db)... so when someone says to "set them up a 'MySQL account'" what exactly do they mean? and how do i do it? TIA At 9:41 PM -0500 7/30/01, [EMAIL PROTECTED] wrote: >Hi Nicole, >I guess the

123box.co.uk mail delivery system

2001-07-30 Thread mailer-demon
recipient [EMAIL PROTECTED] () does not exist, verify e-mail address, please --- Original message: >Your message cannot be posted because it appears to be either spam or >simply off topic to our filter. To bypass the filter you must include >one of the following words in you

Mysql Restore Table Command

2001-07-30 Thread Leon D. McClatchey
Hello;-) I recently lost the entire mysql Database when my harddrive crashed, fortunately, I thought, I had backed up all of the tables via "Backup tables Address,Travel, etc to '/apps/back/mysql/database';" The command worked, (once I created the directory and gave read/write power to mysql

Re: Ayuda Urgente

2001-07-30 Thread James Wroten
Tal vez hay un error en term.h, linea 1060. Vea la linea siguiente de su cartita: /usr/include/term.h:1060: syntax error before `,' y otras similares. Probe otra copia de term.h, si otra maquina esta disponible. atentamente, Diego --- "[EMAIL PROTECTED]" <[EMAIL PROTECTED]> wrote: > Me baje l

RE: permissions, Help for Newbie, Nicole

2001-07-30 Thread admin-list
Hi Nicole, I guess the first issue is to be certain that you have the correct password and a MySQL account set up. If you have a shell account try something like mysql -u[your user name] -p[your password]. Sometimes ISP's will use different passwords for MySQL than the standard log in, we often

Re: Clean up datadir

2001-07-30 Thread Mike Blezien
Thanks Gerald, it's on a RH/Linux 6.2 - 2.4.6 kernel, MySQL 3.23.40-log 20G HD >>On Mon, 30 Jul 2001 20:40:08 -0500, "Gerald R. Jensen" <[EMAIL PROTECTED]> >wrote: >>Mike: >> >>Sort of depends on the OS/File System and the available space on your >>drive(s). >> >>If you have plenty of spa

[Mysql] Perl's DBI Installation

2001-07-30 Thread TestMonster
Hi, I have tried all night to install the perl5's DBI modue, DBI-0.68.tar.gz. Unfortunately, it failed to work for my system (Linux 6.0). (*_*) The first command I issued #perl ./Makefile.PL seemed OK but the second command: #make ( I received the incompatible pointer type error) I also tried

Parsing text file into mysql database.

2001-07-30 Thread Kit Kerbel
While parsing into a mysql database using php, I have successfully entered data into the database from an uploaded txt file. My problem surrounds the fact that in between every data filled record in the database, is an empty record. What causes this? my test code is attached. thanks, kit

mysql@lists.mysql.com

2001-07-30 Thread noise
>Description: on build, "${BUILDIR}/sql/gen_lex_hash hangs and produces no output. program failed to terminate in 3 hours. program was cancelled manually. mysql will not build. >How-To-Repeat: >Fix: >Submitter-Id: >Originator:noise >Organization: >MySQL support:

Re: Clean up datadir

2001-07-30 Thread Gerald R. Jensen
Mike: Sort of depends on the OS/File System and the available space on your drive(s). If you have plenty of space, and are running Linux / Unix, I wouldn't worry about it. If you are running Windows NT, clean the mess up, then run something like DisKeeper to manage hard drive and page file frag

permissions, Help for Newbie, Nicole

2001-07-30 Thread Nicole Lancaster
Hello, First of all, let me say I am a complete novice when it comes to PHP and MySQL. I am trying to install PHPNuke and I get this error when I try to access it: Warning: MySQL Connection Failed: Access denied for user: 'me@localhost' (Using password: YES) in /home/www/me/nuke/html/mainfile.ph

Re: double quotes and single quotes

2001-07-30 Thread sjs
I also would like the answer to this question.. Can you tell I am a newbie? Trim() takes out the whitespace, but not touch the quotes. Would addslashes() do the trick? Or is there another format to do it automatically if a quote is in the information? Sorry Mark, didn't mean to jump into your q

Re: ADO/ODBC question

2001-07-30 Thread Bob Hall
On Mon, Jul 30, 2001 at 12:18:02PM +0100, Christopher Thorpe wrote: > Hi all quick question > > if I use a query such as the one below > > INSERT INTO usq (usq_id,usq_querystring) VALUES(NULL,'test'); > SELECT LAST_INSERT_ID(); > > how do I push this two part query through an ADO command object

Clean up datadir

2001-07-30 Thread Mike Blezien
Hi all, we just setup up on a new server and have transferred a bunch of databases and tables to the new server. All is working well... so far - so good! :) My question is, during this process we did a multiple of create/delete many db and and a whole bunch of tables. Do we need to do any sort o

RE: Wild-card search problem

2001-07-30 Thread winnecon
Turned out to be a data problem after all - a single, unreadable (at least to me) just after each linefeed character. That explains everything. To all those who helped out, my sincerest thanks. Brett >I just tested the following on a table I have with a "name" field >(prj_id in my case): > >

Hanging on Inserts

2001-07-30 Thread DS
Hi All, I have a problem that came out of nowhere and seems only to affect inserts and only on 2 tables. The machine is a linux box w/ 2gig of memory and 2 pentium gig procs.. Mysql 3.23 One script that locks the tables, does an insert in one query to a table that is 120,000 record and another

Re: Two databases / One Server

2001-07-30 Thread linux
The way I am starting my second mysql server is like this : socket=/tmp/mysqld-new.sock --port=3307 --pid-file=/tmp/rep-mysql I am not sure how the first mysql server is starting, it is the one that comes installed with plesk. Jeff- Original Message - From: "Sonia Van Tassel" <[EMAIL PR

RE: mysqld under FreeBSD

2001-07-30 Thread Haapanen, Tom
What hostname are you providing JSP? If you want to replicate the behaviour of your mysql command, it needs to be "localhost" or 127.0.0.1, not the network name of your server. If you are using the server name, then you need to use mysql command the same way, too: ./mysql -u root -h servername -

RE: Wild-card search problem

2001-07-30 Thread Carsten H. Pedersen
> Unfortunately, the problem is not in any one script. It is a > universally repeatable error and happens even when using MySQL in the > command line. > > I tried the suggested SQL query below, but it returned the same > result as before. (Only the first record.) > SELECT name,keywords,descr

Re: Two databases / One Server

2001-07-30 Thread Sonia Van Tassel
Hi Jeff, I think we are both kind of correct. If you are interested in connecting remotely then you need to set up a different port and socket, if you only wish to connect to your localhost then I think you can start the daemon with a --skip-networking option and specify a new location for your

importing data from msql...

2001-07-30 Thread Josh Burroughs
I have a little problem. I'm trying to convert a fairly large database from msql (v1.0.16) to MySQL. Using msqldump worked fine on the smaller databases in this project, and MySQL imported them just fine. However on the larger ones it chokes and segfaults. This is likely because of the rather aged

mysql timing out? HELP!!!!

2001-07-30 Thread Graham Nichols
Hi, I have a customer who has a html page containing two frames on server A. The content files for these frames are on server B. He wants to keep his URL which is directed to server A, but server B has mysql and php support so we have to do this to accomodate him. It is working (kind of) but th

RE: Backup of all Databases

2001-07-30 Thread Sebastiaan J.A. Kamp
Lectori Salutem, as Stefan states here (und natürlich ganz richtig, Stefan) mysqldump is *the* way to backup, and it will create large files. However, since you get clear-text human readable text in the outfile -being all the mySQL commands needed to recreate the database(s)- they're easy to comp

Re: Converting an old Foxpro dos database to mysql/php

2001-07-30 Thread Armando Cerna
Do you happen to have a url on how to do this especially the foxpro portion I don't know to much about it On Mon, 30 Jul 2001, Christopher R. Jones wrote: > The simplest thing to do is to run the foxpro database and export the > records to a text file. Run the SHOW STRUCTURE command to list th

RE: Wild-card search problem

2001-07-30 Thread Christopher R. Jones
I just tested the following on a table I have with a "name" field (prj_id in my case): select prj_id from master_projects where prj_id like "R%" LIMIT 0, 30; Works perfectly in the mysql shell; >Unfortunately, the problem is not in any one script. It is a universally >repeatable error and

Re: Converting an old Foxpro dos database to mysql/php

2001-07-30 Thread Christopher R. Jones
The simplest thing to do is to run the foxpro database and export the records to a text file. Run the SHOW STRUCTURE command to list the table structures and then set up a new mysql database that mimics the foxpro table structure. >I have an old database that is running on foxpro that is use

Re: Two databases / One Server

2001-07-30 Thread linux
Ok clear this up a little for me, Gerald says: If you are connecting to localhost, it is using the socket, not the port. According to Sonia's reference I need to specify both a different socket and a different port, but according to Gerald I must specify one or the other. so which one is it.

Re: permissions - again

2001-07-30 Thread Nicole Lancaster
- Original Message - From: Carsten H. Pedersen <[EMAIL PROTECTED]> To: Robert Roberts <[EMAIL PROTECTED]>; <[EMAIL PROTECTED]> Sent: Saturday, July 28, 2001 6:31 PM Subject: RE: permissions - again > > My assumption: > > mysql> GRANT SELECT, INSERT, UPDATE ON client_db.* > >

Re: Two databases / One Server

2001-07-30 Thread Sonia Van Tassel
Hi, Look at this (Installing Second MySQL Server on Shared Host): http://www.bitmechanic.com/mail-archives/mysql/current/1550.html Sonia On Mon, 30 Jul 2001 [EMAIL PROTECTED] wrote: > Date: Mon, 30 Jul 2001 13:07:09 -0700 > From: [EMAIL PROTECTED] > To: [EMAIL PROTECTED] > Subject: Two datab

RE: Wild-card search problem

2001-07-30 Thread winnecon
Unfortunately, the problem is not in any one script. It is a universally repeatable error and happens even when using MySQL in the command line. I tried the suggested SQL query below, but it returned the same result as before. (Only the first record.) SELECT name,keywords,description from da

Converting an old Foxpro dos database to mysql/php

2001-07-30 Thread Armando Cerna
I have an old database that is running on foxpro that is used for sales and order entry at my work and I was wondering how I would go about porting it to a *nix enviorment. The first step is the port the dbf files I think so I grabbed a copy of dbf2mysql and tried messing around with it and when

Ayuda Urgente

2001-07-30 Thread [EMAIL PROTECTED]
Me baje los archivos fuentes de Mysql ejecuto el .configure y todo bien cuenado ejecuto make me da el siguiente error: ... strcont.o strcend.o bchange.o bmove.o bmove_upp.o longlong2str.o ctype-latin1.o dbug.o ranlib .libs/libmysqlclient.a creating libmysqlclient.la (cd .libs && rm -f libmysqlc

Ayuda Urgente

2001-07-30 Thread [EMAIL PROTECTED]
Me baje los archivos fuentes de Mysql ejecuto el .configure y todo bien cuenado ejecuto make me da el siguiente error: ... strcont.o strcend.o bchange.o bmove.o bmove_upp.o longlong2str.o ctype-latin1.o dbug.o ranlib .libs/libmysqlclient.a creating libmysqlclient.la (cd .libs && rm -f libmysqlc

RE: Wild-card search problem

2001-07-30 Thread Sam Masiello
Is it only pulling up the first record in a script that you are writing (like in a PHP script) or does it also exhibit this behavior if you enter your query from the mysql command line interface? If it is the former, I would imagine there is a problem with your script. HTH Sam Masiello Softwar

Re: Two databases / One Server

2001-07-30 Thread Gerald Clark
If you are connecting to localhost, it is using the socket, not the port. You must set up each server to use a different socket, and connect to that socket. [EMAIL PROTECTED] wrote: > Hello, > > Trying to install two mysql database servers on one Redhat linux machine. > The first mysql server

RE: How to know which row was affected with a querry ???

2001-07-30 Thread Plytas, George
look up mysql_insert_id() in the php documentation. Check out the documentation as it appears on the www.php.net site http://www.php.net/manual/en/function.mysql-insert-id.php hope that helps George -Original Message- From: Zbigniew Szczesny [mailto:[EMAIL PROTECTED]] Sent: Monday, Jul

Re: best version

2001-07-30 Thread btjones
Any of the 3.22.xx versions should work fine under FreeBSD 2.2.8. I had several light- and medium-load productions systems running in that configuration and I never had a problem with mySQL. I was even able to get early versions of 3.23.xx running under it, with some minor code changes. I've no

Two databases / One Server

2001-07-30 Thread linux
Hello, Trying to install two mysql database servers on one Redhat linux machine. The first mysql server is on port 3306 and I am trying to run the second mysql server on port 3307 but whenever I try to access the second mysql server via port 3307, I still end up accessing the first mysql database

Connection error

2001-07-30 Thread BansariPandya
I am trying to connect mysql with JDBC driver. I am getting error "connection failure : Bad handshake". Please let us know the cause of the error and how to solve it. Thanks. Upasana. - Before posting, please check: http

Wild-card search problem

2001-07-30 Thread winnecon
-- I have searched through all of the MySQL documentation I can get my hands on, but still have no explanation for the following "wild-card search" problem. I enter the following query: SELECT name,keywords,description from database_t where 1 and name like "p%" LIMIT 0, 30; -- or -- SELECT

How to know which row was affected with a querry ???

2001-07-30 Thread Zbigniew Szczesny
Hello ! I have a following problem while scripting MySQL with PHP4: Imagine the user may add a record to a table. How can I know precisely what was the number (auto increment primary key) given by MySQL to this new inserted row ??? You may presume there are many simultaneus users adding rows,

Mysql_navigator Script Problems

2001-07-30 Thread Leon D. McClatchey
Hello, I was doing the mysql data entry via kmysql which allows me to build forms and then Enter the data according to the script that I create which runs when I hit the submit problem. I tried to do something similar via mysql_navigator and it dies. The script (which are valid mysql command

Re: Innodb table size

2001-07-30 Thread Xavier Leoncini
Hi, From what I can measure we get only the 70% filling. The data is sorted in ascending order, however there is a catch in the sense that the first colummn consist of all identical variables (this is kept to maintain some consistency with our organization), and thus we have set the primary ke

Re: Backup of all Databases

2001-07-30 Thread Stefan Hinz
Dear Claudemir, you can use mysqldump --all-databases > my_dump_file.sql which will make restore possible on *any* operating system. It creates quite a big file (because of all the create / insert statements) - which might be slow to transfer to / from an internet machine. It's a bit faster

Re: Help!!

2001-07-30 Thread Stefan Hinz
Dear Ivan, read the chapter about the privilege system in the MySQL manual (manual_Privilege_system.html#Privilege_system)! Regards, -- Stefan Hinz Geschäftsführer / CEO iConnect e-commerce solutions GmbH # www.js-webShop.com www.iConnect.de # Gustav-Meyer-Allee 25, 13355 Berlin #

Re: Privilege settings

2001-07-30 Thread Stefan Hinz
Dear Mike, read the chapter about the privilege system in the MySQL manual (manual_Privilege_system.html#Privilege_system)! You'd better use the GRANT command to grant rights to users (which are stored in mysql.user) or to users who only have access to special databases and tables (which are sto

Re: Database design question

2001-07-30 Thread Leon D. McClatchey
On Saturday 28 July 2001 15:09, Scott Goldstein wrote: > I'm new to MySQL and database design and I have a questions concerning > entities with common attributes. > > Suppose I have two entities, foo and bar with the following attributes: > > foo: (id, A, B, C, D, F) > bar: (id, A, B, C, X, Y) We

Re: mysql-max-nt, missing files in the intel/windows distrib

2001-07-30 Thread Miguel Angel Solórzano
At 15:09 30/07/2001 -0500, steph wrote: Hi, The 3.23.39 distribution was substituted by 3.23.39a because the setup program doesn't rewrite the share directory. That is the reason for your error message. To fix: stop the server, remove the share directory and run again the setup program. Regards

Re: Help!!

2001-07-30 Thread Jeremy Zawodny
On Mon, Jul 30, 2001 at 12:13:51PM -0500, Ivan Chavez wrote: > > I need help to know where configure the users and passwords that can > accesar to my databases, this in a Linux Net Hat 6.1 Did you read the documentation or installation notes that came with MySQL? Jeremy -- Jeremy D. Zawodny,

Re: Privilege settings

2001-07-30 Thread Sinisa Milivojevic
Mike Blezien writes: > > Ok, now I understand, the "global" would refer to the privileges set in the > mysql db user table then,..correct?? :) and the privileges set in the db table > are specific to that particular database. Sound right?? > > thanks > > > Mike(mickalo)Blezien > =-=-=-=-=-=-=-

What ODBC version to download?

2001-07-30 Thread Tobias Bohlin
Refer to: http://www.mysql.com/downloads/api-myodbc.html I am running Yellow Dog Linux on a Macintosh Power PC. This means, in practice, that the rpm:s I downloaded for MySQL had suffix *.ppc.rpm Now I am interested in fiddling about with ODBC and C++. Can I use any of the source distros above?

Re: Privilege settings

2001-07-30 Thread Mike Blezien
Ok, now I understand, the "global" would refer to the privileges set in the mysql db user table then,..correct?? :) and the privileges set in the db table are specific to that particular database. Sound right?? thanks >>> trying to figure out the relationship of the mysql User and db tables. No

Re: Backup of all Databases

2001-07-30 Thread Jeremy Bussard
Greetings, If you have the hardware to spare, setup a replication server and run your backups against that server. It's clean, you can shutdown your database completely on the slave and perform backups however you want. I use it both at home and at work and get wonderful results. Hope

Re: Privilege settings

2001-07-30 Thread Sinisa Milivojevic
Mike Blezien writes: > Hi all, > > trying to figure out the relationship of the mysql User and db tables. Now when > a database is created and privileges are assigned to the new db, the db table is > updated and the user table is updated, but in the privilege columns of the user > table, all are

Backup of all Databases

2001-07-30 Thread Claudemir F. Martins
Hello I took a look at the discussion of database backup, however I still have a doubt: I have 30 databases and I'd like to backup all databases at a time (including the mysql database). Is there a good way to backup all databases at a time ? To save the directory /var/lib/mysql which conta

Re: Innodb table size

2001-07-30 Thread Heikki Tuuri
Hi! Sorry, InnoDB does not have key compression. Every row has a 6-byte trx id, a 7-byte roll ptr, and a header of 6 bytes. In addition, every field uses 1 byte as a pointer to it. Calculating: 180 million x (6 + 7 + 6 + 2 + 4) bytes = 4.5 GB Since every page is filled only 15/16 full even if

Re: mysql 3.23.40-Solaris8-Gcc3.0 error compiling with gemini

2001-07-30 Thread Sinisa Milivojevic
Faine, Mark writes: > I'm trying to intall mysql 3.23.40 on Solaris 8 ( GCC 3.0 ) but I'm having a > little difficulty. Whenever it gets to the gemini directory it errors out > with the following: > > /usr/local/bin/gcc -DHAVE_CONFIG_H -I. -I. -I.. -I../incl -I../msgs-O3 > -DDBUG_OFF -O6 -DH

Re: Security problem with 3.23.38

2001-07-30 Thread Sinisa Milivojevic
Robert Cross writes: > > > I wrote: > >Try first granting USAGE on *.* to both users with 'identified by ...' > >and then try granting database rights. > > Thanks Sinisa, that works perfectly. I've now got a wonderful small and > fast database > that I can let the users into! > > Bob Cross. Y

Privilege settings

2001-07-30 Thread Mike Blezien
Hi all, trying to figure out the relationship of the mysql User and db tables. Now when a database is created and privileges are assigned to the new db, the db table is updated and the user table is updated, but in the privilege columns of the user table, all are set to 'N' but the appropriate pr

Help!!

2001-07-30 Thread Ivan Chavez
Hello!! I need help to know where configure the users and passwords that can accesar to my databases, this in a Linux Net Hat 6.1 Thank you - Before posting, please check: http://www.mysql.com/manual.php (the manua

Re: Backup / Import Questions

2001-07-30 Thread j.urban
Because the --opt option builds an output script of SQL commands that can be run to CREATE TABLES and INSERT data. You're on the right track, but using mysqlimport only makes sense based on the options that were used with mysqldump... Based on what you've done, you can re-create the entire datab

RE: *** HELP *** mySQL connectivity problems

2001-07-30 Thread SIMONIN Alexandre
Thanks, But it doesn't help me finding out what the problem is (have a look at the code below: it basically does the same as your example). Let me just clarify: the application works all OK when mySQL runs on WinNT and when I access to my files locally. The problem comes up when porting my appli

Re: Backup / Import Questions

2001-07-30 Thread Steve Brazill
"mysqldump" creates an 'SQL' script, which you 'run' to recreate the tables and data within them. Something like this should do the trick... mysql -u root -p password NewDataBaseName < file.mysql - Original Message - From: <[EMAIL PROTECTED]> To: <[EMAIL PROTECTED]> Sent: Monday, J

RE: *** HELP *** mySQL connectivity problems

2001-07-30 Thread Venu A
Check the following link, which has the simple MyJDBC sample to connect to MySQL server and to do some basic operations. http://lists.mysql.com/cgi-ez/ezmlm-cgi?1:mss:80228:200107:popciohjmlbbolpak ege If you need any further assistance, please let us know. Thanks in advance venu > -Original

Backup / Import Questions

2001-07-30 Thread KPortsmout
Hi, I have built a database with 7 tables in it, the time has come when I need to create a suitable backup system so off I went to my manuals. I read through the mysqldump command and everything seemed straight forward. I ran the following... mysqldump -uroot -ppassword --opt Database > fil

FW: *** HELP *** mySQL connectivity problems

2001-07-30 Thread SIMONIN Alexandre
> -Original Message- > From: SIMONIN Alexandre > Sent: Monday, July 30, 2001 2:41 PM > To: '[EMAIL PROTECTED]' > Subject: *** HELP *** mySQL connectivity problems > > Hi, > > I'm running mySQL 2.0.4 and Tomcat 4.0 on Cobalt/Linux. I'm using mm 2.0.4 > > > When tryin

skip_locking

2001-07-30 Thread Lukas Feiler
I am working on Linux (Intel, SuSE 7.2 Pro.) And that's the question: Is it save to set skip_locking to "OFF" in order to make my cron job work (it is executing myisamchk on some tables)? With skip_locking set to "ON" I would have to make sure none is working on my tables (making some calls or u

Re: double quotes and single quotes

2001-07-30 Thread Hannes Niedner
On 7/30/01 7:38 AM, "Mark Lo" <[EMAIL PROTECTED]> wrote: > Hi, > > I have a problem with double quotes and single quotes in mysql command, > if I let my user > input the form data and it contains double quotes, the values cut off at > the double quote. > > How to override the problem ?? > >

Re: Availability of mysql/pam authentication module

2001-07-30 Thread sachin shetty
There is a pam-mysql.tar.gz file that I found on http://www.tcx.se/ , however, it is more than broken according to the author. - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists

Re: Availability of mysql/pam authentication module

2001-07-30 Thread Jeremy Zawodny
On Mon, Jul 30, 2001 at 11:19:42AM -0400, sachin shetty wrote: > Hello > > I would like to know what I need to do in order to have my passwd/shadow > files in a Mysql database? What did Google say? http://www.google.com/search?q=mysql+pam+authentication Jeremy -- Jeremy D. Zawodny, <[EMAIL

Re: Rare crash

2001-07-30 Thread Michael Widenius
Hi! > "Sasha" == Sasha Pachev <[EMAIL PROTECTED]> writes: >> 2) select bigblob where optimized_index_clause order by >> optimized_index_clause limit 6650,50 >> >> Problem: I used to think that since the start number is high in the limit, >> that it was slow because the data was not often

Re: [Compiler error for MySQL 3.23.40 - Forte C++ and Solaris X86]

2001-07-30 Thread Michael Widenius
Hi! [EMAIL PROTECTED] writes: >> >Description: >> I'm comiling with GNU make and tar, and Forte C++ v6 r2. >> >> The compiler is current, as is the Solaris. >> >> My configuration line looks like: >> >> ./configure --prefix=/usr/local/mysql --with-innodb >> >> I'm getting the following

Availability of mysql/pam authentication module

2001-07-30 Thread sachin shetty
Hello I would like to know what I need to do in order to have my passwd/shadow files in a Mysql database? Thanks Sachin - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.

Re: Database Security

2001-07-30 Thread David Mintz
On Mon, 30 Jul 2001, Claudemir F. Martins wrote: > How can I made a Database secure by using an PHP Interface ? > > I Mean .If I use a PHP interface there are passwords included in the PHP > config files in the directory that must be readable for all (755). > > Is there a good way to prote

Re: Innodb table size

2001-07-30 Thread Xavier Leoncini
Sander Pilon wrote: >Lose (some of) the keys!? Keys, especially on small rows (where a key >introduces a lot of overhead), can take a significant percentage of >space. > >Turn on key compression? (dunno if innodb supports that) > >Other then that I wouldn't know. But live with the fact that keys

Building an application for accessing mysql

2001-07-30 Thread r.mauro
I'm new to mysql and I have to implement an app for accessing a mysql database. What works best, Java or Visual Basic ??? Thanks for any info Rui Mauro __ http://www.IOL.pt Todo o mundo passa por aqui! - Before pos

mysqld daemon ended on first connection

2001-07-30 Thread Darren Tew
Hi, My server just crashed yesterday nite. After I got it up and running again, I couldn't get connection to MySQL database. Mysqld processes are checked and verified running upon booting up. But it just went dead after I tried to get a connection thru mysqladmin!! It just says error connect

RE: Innodb table size

2001-07-30 Thread Sander Pilon
Lose (some of) the keys!? Keys, especially on small rows (where a key introduces a lot of overhead), can take a significant percentage of space. Turn on key compression? (dunno if innodb supports that) Other then that I wouldn't know. But live with the fact that keys introduce overhead. It will

double quotes and single quotes

2001-07-30 Thread Mark Lo
Hi, I have a problem with double quotes and single quotes in mysql command, if I let my user input the form data and it contains double quotes, the values cut off at the double quote. How to override the problem ?? Thank you Eric Chan

Innodb table size

2001-07-30 Thread Xavier Leoncini
Hello, I was wondering if someone could help me; When I load about 6Gb of raw data into a innodb table the size used by the table is about 14G. I noticed in preleminary tests that the sized used depends a lot on the number of rows in the case described above the data has about 180 millions rows,

Re: Database Security

2001-07-30 Thread Petr Svacek
Hi, You can 1. set the permissions to 700. 2. chown of the script to nobody/wwwuser or whoever is the user used for the daemon httpd. You need root access to do this. Petr Svacek - |<[EMAIL PROTECTED]>

Database Security

2001-07-30 Thread Claudemir F. Martins
Hello. How can I made a Database secure by using an PHP Interface ? I Mean .If I use a PHP interface there are passwords included in the PHP config files in the directory that must be readable for all (755). If a user get access to the directory (FTP) he/she will read the password and t

mysql 3.23.40-Solaris8-Gcc3.0 error compiling with gemini

2001-07-30 Thread Faine, Mark
I'm trying to intall mysql 3.23.40 on Solaris 8 ( GCC 3.0 ) but I'm having a little difficulty. Whenever it gets to the gemini directory it errors out with the following: /usr/local/bin/gcc -DHAVE_CONFIG_H -I. -I. -I.. -I../incl -I../msgs-O3 -DDBUG_OFF -O6 -DHAVE_CURSES_H -I/export/home6/tem

Re: Security problem with 3.23.38

2001-07-30 Thread Robert Cross
I wrote: >> I've got a wierd problem with 3.23.38, built from source, running on RedHat >> v6.2 (Intel). Put simply the wildcard character for user access doesn't >> work. From my reading of the docs any of the following: >> grant all on mtdb.* to user1 identified by "bozo1"; >> grant

Re: myvbql dll, help please!

2001-07-30 Thread Ken Menzel
Hi Stephen, I see no one answered this and I was away. Please check www.icarz.com/mysql/index.html for more documentation examples and an address to ask for help. Ken - Original Message - From: "Stephen Sherlock" <[EMAIL PROTECTED]> To: "mySQL List" <[EMAIL PROTECTED]> Sent: Thursday, J

RE: Help required for OLEDB on win32 for MySQL(linux)

2001-07-30 Thread Bruce Stewart
Asit, Did you ever solve your problem? - I have the same... Bruce -Original Message- From: Miguel Angel Solórzano [mailto:[EMAIL PROTECTED]] Sent: Thu, 07 June 2001 21:42 To: asit; [EMAIL PROTECTED] Subject: Re: Help required for OLEDB on win32 for MySQL(linux) At 20:56 07/06/2001 +05

Re: Security problem with 3.23.38

2001-07-30 Thread Sinisa Milivojevic
Robert Cross writes: > > I've got a wierd problem with 3.23.38, built from source, running on RedHat > v6.2 (Intel). Put simply the wildcard character for user access doesn't > work. From my reading of the docs any of the following: > > grant all on mtdb.* to user1 identified by "bozo1"; >

mysql-max-nt, missing files in the intel/windows distrib

2001-07-30 Thread steph
Hello, I am working on a windows 2000 server, SP 1. Until now, I used mysql 3.23. 2? with no problem I just downloaded 3.23.39 max, I stop the mysql service, then I installed it in the same directory: c:\mysql Last, I tried to start again the service (so mysqld-nt.exe) But it doesn't want to s

Security problem with 3.23.38

2001-07-30 Thread Robert Cross
I've got a wierd problem with 3.23.38, built from source, running on RedHat v6.2 (Intel). Put simply the wildcard character for user access doesn't work. From my reading of the docs any of the following: grant all on mtdb.* to user1 identified by "bozo1"; grant all on mtdb.* to user2@"

RE: space

2001-07-30 Thread David Patton
ln -s /home/dbname /var/lib/mysql/dbname chown mysql:mysql /home/dbname -Original Message- From: Brian Thompson [mailto:[EMAIL PROTECTED]] Sent: Sunday, July 29, 2001 4:55 PM To: [EMAIL PROTECTED] Subject: space I have my /var/ partition set to 400mb, but I need about 4 gigs for a mysql

Mysql Driver

2001-07-30 Thread Selva Prakash
Hi, I am trying to install a package in free bsd. and that package come with a perl file which checks the configuration.. when i run the perl file, it gives mysql driver not found. but i have installed mysql and am abel to login etc etc. what could be the problem? -- K.S.Selv

strange myodbc problem

2001-07-30 Thread Conor McTernan
Hey there, Sorry for posting to this list, but I'm not so sure it's a myodbc problem exclusively. I am currently trying to get a mysql database to work with lotus approach. The plan is to port a current .dbf database over to mysql, and so far I have not had many problems. Until now. I am not s

Mysql Driver

2001-07-30 Thread Selva Prakash
Hi, I am trying to install a package in free bsd. and that package come with a perl file which checks the configuration.. when i run the perl file, it gives mysql driver not found. but i have installed mysql and am abel to login etc etc. what could be the problem? -- K.S.Se

Valuable information

2001-07-30 Thread Heidi Fredel
Dear Friend: AS SEEN ON NATIONAL TV : ''Making over half million dollars every 4 to 5 months from your home for an investment of only $25 US Dollars expense one time'' THANKS TO THE COMPUTER AGE AND THE INTERNET! = BE A MILLIONAIRE LIKE OTHERS WI

Special Deal This Week Only !!!

2001-07-30 Thread free
--

Re: MySQLGUI for X

2001-07-30 Thread Sinisa Milivojevic
[EMAIL PROTECTED] writes: > Dear Sir, > Does a graphical sql client for MySQL exist that runs under X-Windows ? > Many thanks, > == > Geoff Davis > [EMAIL PROTECTED] (work) [ PGP key available on request ] > [EMAIL PROTECTED] (home) > +27-82-8705586 (mob

ADO/ODBC question

2001-07-30 Thread Christopher Thorpe
Hi all quick question if I use a query such as the one below INSERT INTO usq (usq_id,usq_querystring) VALUES(NULL,'test'); SELECT LAST_INSERT_ID(); how do I push this two part query through an ADO command object and how do I get the variable back from the select part of the query... alternative

  1   2   >