Re: sessions problems

Thanks, Will try that out. Adrian On Thu, 31 May 2001, g_gosho wrote: > You can try this link: http://www.bonev.com/s > > there is PHP session handling librarary and documentation how to use it > > - Original Message - > From: "Adrian D'Costa" <[EMAIL PROTECTED]> > To: "php general

Re: root password setting error, can you help?

They do work. Just need to follow instruction a little more closely, though I will agree with, the instructions do trip up many beginners. Remove the -p switch. It is only used if you have already set a password but since you haven't ... Also quotes around new-password aren't required. -

Re: Data Replication

On Thu, May 31, 2001 at 11:25:08PM -0500, Duane Stark wrote: > > Hello all! > > I have two servers (both running mysql and freebsd) .. I also have > data replication setup on them.. My question to you is this.. Both > servers are phyiscally located in different locations.. a) When the > data is r

Re: Replication

On Thu, May 31, 2001 at 09:18:48PM +0200, Warren van der Merwe wrote: > Hi there > > I have three sites, each runnin MYSQL. I want to replicate the data > between all three. I know I cannot do this with the standard > replication in MYSQL, because all three sites will add their own > records and

root password setting error, can you help?

Hi, How do I set the root password after installing MySQL server and client? I followed the after installation instructions,@they don'T work. mysqladmin -p password 'new-password' I don't get it. Thx for helping JP __ Do You Yahoo!? Get per

Re: problem with Grant

Yes i did that , after that i restart my server, But still it didn't load the new settings. Kindly help. Thanks Damnish - Original Message - From: "oltra jean-michel" <[EMAIL PROTECTED]> To: <[EMAIL PROTECTED]> Sent: Friday, June 01, 2001 2:52 AM Subject: Re: problem with Grant > > Have

Re: What's the best os?

On Fri, Jun 01, 2001 at 01:45:24AM -0400, David Freeman wrote: > > The server is a quad xeon lh4, it will host a web site written in > php, and using a mysql database which holds 125,000 squ's and > descriptions. The server's only job is to host this site. Assuming you'll use Apache 2.x one day,

RE: What's the best os?

The server is a quad xeon lh4, it will host a web site written in php, and using a mysql database which holds 125,000 squ's and descriptions. The server's only job is to host this site. Thanks for the responce. dave freeman -Original Message- From: Jeremy Zawodny [mailto:[EMAIL PROTECT

Re: What's the best os?

On Fri, Jun 01, 2001 at 12:30:20AM -0400, David Freeman wrote: > I am putting together a new web server to serve our new web site. > We expect a-lot of traffic on this site, so we have purchased a HP > LH4 quad xeon 550 2mb cache server. The site will use the mysql > database to hold about 125,0

Re: help!!!!

The *nix prompt or the DOS prompt, depending on your OS. - Original Message - From: "Jeff Davidson" <[EMAIL PROTECTED]> To: <[EMAIL PROTECTED]> Sent: Friday, June 01, 2001 12:24 Subject: help Where do you enter the commands to install mySQL?? I know it's a stupid question, but p

Re: problem with Grant

Have you tried 'flush privileges' after having set root password? jean-michel On Thu, 31 May 2001, Damnish wrote: > I am using MySql on linux. > I can start mysqld by "safe_mysqld --user=mysql --skip-grant-tables & > But when i try to start it withour --skip-grant-tables, it said A

Re: What's the best os?

On Fri, Jun 01, 2001 at 12:30:20AM -0400, David Freeman wrote: > I am putting together a new web server to serve our new > web site. We expect a-lot of traffic on this site, so we have purchased > a HP LH4 quad xeon 550 2mb cache server. The site will use the mysql > database to

Re: BDB tables bugs

Hello Michael, Thursday, May 31, 2001, 11:19:03 PM, you wrote: MW> Hi! >> "Peter" == Peter Zaitsev <[EMAIL PROTECTED]> writes: Peter>> Hello bugs, Peter>> mysql 3.23.38 Peter>> Linux diamond 2.4.4.SuSE-12-4GB-SMP #8 SMP Sat May 19 21:24:05 MSD Peter>> 2001 i686 unknown Peter>> SUSE 7.1 (G

Re: TIMESTAMP

At 8:40 PM -0700 5/31/01, Roland Hannes Niedner wrote: >Hi everybody, > >I am new to the list so if my question was answered recently I do apologize >but I could not find the answer neither in the archive or the manual. >Problem: I try to load data into a table using LOAD DATA LOCAL INFILE. >I

What's the best os?

Hi group, I am putting together a new web server to serve our new web site. We expect a-lot of traffic on this site, so we have purchased a HP LH4 quad xeon 550 2mb cache server. The site will use the mysql database to hold about 125,000 squ's with descriptions, and notes for ea

Data Replication

Hello all! I have two servers (both running mysql and freebsd) .. I also have data replication setup on them.. My question to you is this.. Both servers are phyiscally located in different locations.. a) When the data is replicated between the two servers, is it encrypted? b) if not, what's the e

help!!!!

Where do you enter the commands to install mySQL?? I know it's a stupid question, but please, enlighten me.

MySQL BOF @ OpenSource Convention...

MySQL folks, At last year's Open Source Convention, I arranged a last-minute BOF (Birds of a Feather) session one evening. Many of the core MySQL developers (and other folks in the audience) answered questions about MySQL problems, performance tuning tips, missing features, future development, a

TIMESTAMP

Hi everybody, I am new to the list so if my question was answered recently I do apologize but I could not find the answer neither in the archive or the manual. Problem: I try to load data into a table using LOAD DATA LOCAL INFILE. Into a table containing a TIMESTAMP(14) field. The loading wor

Re: Large table crash recovery

Greetings list, I have a semi large table (~10gig) that when I run a select query from the table it gives me an errno 145. So I run myisamchk on the table, as it is a myisam table. However, my problem is, when I run myisamchk it tells me that the table has about 20 million data records, th

Re: DBD and locking

On Tue, May 29, 2001 at 04:26:01PM -0400, Seth Hall wrote: > > What if the queries were updates instead of inserts? Would I need > or be able to lock the tables then? Why do you think you need table locks in the first place. I'm not sure that I ever really understood why you needed them. > Can

Re: DBD and locking

On Thu, May 24, 2001 at 10:52:36PM -0400, Seth Hall wrote: > > Is locking not necessary on BDB tables? Does transaction support > get rid of the need for table locking? Probably, yes. It depends on your application. Jeremy -- Jeremy D. Zawodny, <[EMAIL PROTECTED]> Technical Yahoo - Yahoo Finan

Optimizing Mysql for CGI Search Engine

Hi all, I have been using Mysql to power my online database search engine(CGI). IT contains more than 500K rows of records(12 columns). Is there a trick to optimize Mysql Table( by using Index , temporary table??) so that the search engine could get the result in shorter time? Should I conside

Re: ACT2 Conversion

I've never heard of ACT2 but if you can export the data to a delimited text file, you could import it into mysql. You may have to edit the file a bit though. - Original Message - From: "James McLaughlin" <[EMAIL PROTECTED]> To: <[EMAIL PROTECTED]> Sent: Friday, June 01, 2001 4:03 Subject

Re: Problem running old database with 3.23.30-gamma

What if you did try upgrading myism tables? I remember reading something about ism tables not being supported in the future anyway. - Original Message - From: "Beverly Baird" <[EMAIL PROTECTED]> To: <[EMAIL PROTECTED]> Sent: Friday, June 01, 2001 2:33 Subject: Problem running old databa

Re: problem wtih mysql GUI

1. Check that the connection is correct. 2. Check that the mysql server is running and that the socket file exists. 3. Check that the socket file is in the correct place and has the correct permissions. - Original Message - From: "D. Veerasamy" <[EMAIL PROTECTED]> To: <[EMAIL PROTECTED]>

clisp interface for mysql

I notice a few of the Mysql developers list lisp and clisp on their pages. Is there mysql client code for clisp development? -- --- Dennis Sacks [EMAIL PROTECTED] - Before posting, please check: http://www.mysql.com/manua

Question concerning SHARED DATABASE

I have need for multiple servers to share the same database files. We are implementing a site that will have hundreds of thousands of users at the same time, so we need a large pool of Linux servers that are load-balanced. Then, all these servers, each of which will run Apache and MySQL (or

Re: ORDER weirdness... (help?)

> SELECT RTRIM(CONCAT(parents, ' ')) AS parents, name FROM Categories ORDER BY > parents, name; > > Note: > > SELECT RTRIM(parents) AS parents, name FROM Categories ORDER BY parents, > name; > > works SOMETIMES, but not in every case. Ammending this, as I did a little more testing.. U

ORDER weirdness... (help?)

I'm experiencing a little weirdness that I was hoping some one could clear up for me. Take the following query of tab-separated category parents: SELECT parents, name FROM Categories ORDER BY parents, name; In a sample statement, this results in something like: +++ | pa

Re: xml support?

I wrote a really cheesy tutorial that demonstrates a simple way to export the results of a query to XML. It's located at http://www.phpdeveloper.org/tutout.php?num=20 Would it be useful to add an option to mysqldump to also write an xml document? I've considered trying to tackle that too :) R

'Overlays' for record layouts

For MySQL databases, is there any ability (or method) to construct 'record layouts' which would provide alternate fields within the record ? I'd like to create a "codes" table, where different types of reference 'codes' would be stored (i.e. "payment terms", "tax authorities", "credit card types

ACT2 Conversion

Has anyone had any luck or seen any HOWTO docs for converting a ACT2 DB to MySQL? We are moving away from prop windows software and into web based DB administration. Any help would be terrific. THanks Kat - Before posting, pl

Replication

Hi there I have three sites, each runnin MYSQL. I want to replicate the data between all three. I know I cannot do this with the standard replication in MYSQL, because all three sites will add their own records and the manual says the slave cannot insert entries it's self. So, I want to basically

PHP & Mysql weirdness

Here's a good one: When doing an update on a table from the CLI, the query is done in under a second (0.01 of a second actually). When I do the _exact_ same query from PHP, the update takes up to 3 minutes. The table is large (>1GB, 400k rows) but simple (5 columns, one primary key which is

RE: Insert Automatically [pass on command line]

> >then run: > >mysql -u user -p password --database database < file.sql > > Except don't put a space between -p and your password. :-) Better yet just -p and don't put your password on the command line. ;-) - Before posting,

Problem running old database with 3.23.30-gamma

Hello, I have a database, called mace, that was collected under 3.21.?? It runs under 3.22.26a It runs under 3.23.28-gamma But what I need it to function with is 3.23.30-gamma When I try to run with 3.23.30-gamma I get the following: % mysql mace Reading table informatin for completino of ta

RE: Insert Automatically

Hi, You can write a script file and run it. Regards, Ravi --- KAMRY <[EMAIL PROTECTED]> wrote: > > > database,sql,query > > > > Hi guys, I appreciate it if some can help here > > Is it possible to do a script file like in Oracle > with statements like > these: > > insert into countrie

RE: Insert Automatically

At 12:55 PM -0500 5/31/01, Johnny Withers wrote: >make your file with valid sql in it.. > >then run: >mysql -u user -p password --database database < file.sql Except don't put a space between -p and your password. :-) > >- >Johnny Withers >[EMAIL PROTECTED] >p. 601.853.0211 >

Re: MySQL Server hosting: Linux or Win2K?

On Wed, May 30, 2001 at 10:04:26AM +0100, [EMAIL PROTECTED] wrote: > I am still in the early stages of developing my first SQL > application, and I have chosen MySQL because I only need very > straightforward facilities, but I really want reliability, including > particularly Replication. I am cu

RE: Insert Automatically

Dear Kal, On Thu, 31 May 2001, KAMRY wrote: > database,sql,query > > Is it possible to do a script file like in Oracle with statements like > these: > > insert into countries (id,country,country2) values(IDDI, "Venezuela", ""); > insert into countries (id,country,country2) values(IDDI, "Vietnam",

problem wtih mysql GUI

Dear Sir/ Madam Can you please help me with the GUI client running under linux. I'm having an error message saying: Can't connect to local MySQL server through socket " (111) Thanking you. - Before posting, please check: h

RE: Insert Automatically

make your file with valid sql in it.. then run: mysql -u user -p password --database database < file.sql - Johnny Withers [EMAIL PROTECTED] p. 601.853.0211 c. 601.209.4985 -Original Message- From: KAMRY [mailto:[EMAIL PROTECTED]] Sent: Thursday, May 31, 2001 1:07 PM

RE: Insert Automatically

database,sql,query Hi guys, I appreciate it if some can help here Is it possible to do a script file like in Oracle with statements like these: insert into countries (id,country,country2) values(IDDI, "Venezuela", ""); insert into countries (id,country,country2) values(IDDI, "Vietnam",

Re: Installation

On Thu, May 31, 2001 at 04:50:54PM +0200, Evan James Dembskey wrote: > Hi, > > This is more of a UNIX question I think, but the UNIX list sent me > over here... > > when running gunzip on mysql-3.23.38-dec-osf5.1-alphaev6.tar.gz > under a DEC Alpha box I get the following problems. What gives? >

mySQL and VBscript

Here's the code we have: Set objConn = Server.CreateObject("ADODB.Connection") objconn.Mode = adModeReadWrite objConn.Open "dsn=myDSN" ... vLastIndex = objConn.Execute("SELECT LAST_INSERT_ID()").Fields(0).Value Here's what we got Explorer just prompts: Microsoft OLE DB Provider for ODBC D

Re: MySQL installation problem

On Thu, May 31, 2001 at 06:27:38PM +0800, yewei wrote: > Hi Dear Sir/Mdm, > > I've encountered a problem when I run 'scripts/mysql_install_db' > command. The error message is following: > > Starting mysql server > ./bin/safe_mysqld: /my/gnu/bin/hostname: not found > ./bin/safe_mysqld: /my/gnu/b

Re: MySQL Version and Solaris

On Thu, May 31, 2001 at 10:19:41AM -0400, A. Krosunger wrote: > Hello resident gurus and gods > > Couple of questions: > > 1. Has anyone successfully compiled 3.23.38 under Solaris 2.6 (sparc)? > I'm having problems... I've compiled it on both Sparc and Intel without problems--until I tried to

Re: Solaris and MySQL 3.23

On Thu, May 31, 2001 at 09:52:26AM -0400, Donahue,Rob wrote: > Hello, > > I have an interesting problem... I use a toolkit that comes with MySQL > 323.29. While it works on one server out of the box (it is pre-compiled > and no libraries are shipped) which is a Solaris 2.6 server another Solaris

Re: xml support?

On Thu, May 31, 2001 at 12:40:45PM +0100, Steve Menday wrote: > > I am trying to find out whether mysql has any support for xml? Can > anyone help me please? Please cc replies to [EMAIL PROTECTED] > What sort of "support"? XML is just text. You can store and retrieve

Re: missing mysqladmin

Hi ! all I have the solution to my problem. The Mysql-3.23.37-1.i386 and Mysql-3.23.38-1.i386.rpm pakages don't have the Mysql-client included. Once I downloaded it and installed everything works fine. Thanks - Original Message - From: [EMAIL PROTECTED] <[EMAIL PROTECTED]> To: <[EMAIL PR

Re: myisamchk --sort-records extremely slow

Perhaps the physical layout of your disk drives are contributing to the 'slowness'... - Are the 12 drives making up the SCSI RAID 5 array the only drives in the system ? - Do you have the O/S and/or the 'temp' area being used by MySQL on different drive devices than the RAID array ? (is the 'tem

REPLICATION problem (bad magic number)

>Description: Problem with setup replication between 2 hosts. Log file on slave hosts says: 010531 12:25:40 Slave: reconnected to master '[EMAIL PROTECTED]:3306',replication resumed in log 'FIRST' at position 4 010531 12:25:40 Error reading packet from server: Binlog has

Re: A blob question

Hello avegaaraya, Thursday, May 31, 2001, 6:12:09 PM, you wrote: ann> I'm using mysql in win9x, and I want to know how to load a JPG image into a table ann> __ ann> Get your own FREE, personal Netscape Webmail account today at http

Re: Can get safe_msqld to run in background!!

Hi, [EMAIL PROTECTED] wrote: > > I know this is bound to be something REALLY simple, but I can't seem to get > "safe_mysqld" to run in background (Solaris 7/MySQL 3.23.37) > > If I try, as the "root" user, to start "safe_mysqld" from the "/usr/local/mysql" > directory thus... > > ./bin/safe_my

Re: ASP and my sql??

Hi, I would go for a CGI As Sinisa has already stated, it would make your data-retrieval front-end faster and more OS independent. Regards, Jorge MySQL Development Team __ ___ __ __ / |/ /_ __/ __/ __ \/ / Jorge del Conde <[EMAIL PROTECTED]> / /|_/ / // /\ \/ /_/ / /__

Which Source Dist. to use

Title: Blank Database. I have a Cobalt Cache Raq2 with a MIPS processor, which source distribution or rpm files should I use. Vien HuynhleClearsail Communications  

Convert.dbf file

Hi, I want to convert my .dbf file to MySQL table and I wonder if dbf2mysql is able to convert the index file (.cdx) linked to the my .dbf table? Thanks, Michael Michael Grimard Concepteur Logiciel/Software Designer MAX Technologies [EMAIL PROTECTED] tel:(450)443-3332 #524

Re: myisamchk --sort-records extremely slow

In the last episode (May 30), Michael Villalba said: > I have a rather large MyISAM table (~230 million rows) running under > MySQL 3.23.30. It has 10 columns and 3 indices. The data and index > files each occupy about 10GB. > > My problem is that sorting the rows using myisamchk --sort-records

missing mysqladmin

Hi! After installation on a RH Linux Box, mysqladmin is missing. Any idea ? Thanks

startup mysqld with --chroot-option in my.cnf

Hello everybody I'm terribly new in the field but making huge progresses. I'm trying to set up a secure LAMPS-Server with RH 6.2, MySQL 3.23.38, PHP 4.0.5 and Apache 1.3.20 with OpenSSL. My problem is: how do I start mysqld with the chroot-option? Seems to work fine when starting as root, impossi

A blob question

I'm using mysql in win9x, and I want to know how to load a JPG image into a table __ Get your own FREE, personal Netscape Webmail account today at http://webmail.netscape.com/

Some minor MySQL v.3.23.38 fixes and Help corrections

Hi   I'm forwarding you the attached file MYSQL_3.23.38_FIXES.ZIP which contains files with some minor improvements and fixes done by me, updated to MySQL version 3.23.38, and presenting the following:   - Directory \LIBMYSQL:       - file ERRMSG.C: included section of code with client er

Installation

Hi, This is more of a UNIX question I think, but the UNIX list sent me over here... when running gunzip on mysql-3.23.38-dec-osf5.1-alphaev6.tar.gz under a DEC Alpha box I get the following problems. What gives? # gunzip < mysql-3.23.38-dec-osf5.1-alphaev6.tar.gz | tar xf - tar: ././@LongLink :

**Urgente** I can't compile mysql

I'am use OpenBSD 2.8 and try compile various version of mysql but the same compile error appears when I try make it. The error: mysql.o: Definition of symbol '_time_teste' (multiply defined) readline.o: Definition of symbol '_time_teste' (multiply defined) sql_string.o: Definition of symbol '_

DISTINCT and HAVING

Hi! When I use DISTINCT and HAVING in the same query, DISTINCT does not seem to work. Is that right, or might I have done something wrong? Regards, Benjamin Boksa -- Benjamin Boksa [EMAIL PROTECTED] side by site GmbH & Co. KG Druckgestaltung & Webdesign Barbarastr. 3-9 (Block 6) D-50735 K

MySQL Version and Solaris

Hello resident gurus and gods Couple of questions: 1. Has anyone successfully compiled 3.23.38 under Solaris 2.6 (sparc)? I'm having problems... 2. Which version of MySQL should I use under 2.6? Binary or source? I currently am running mysql 3.21.33b on an Ultra 10 Sparc. Yes, its time for

Bug in my sql ......mysql.exe?

Hi, i) I am using mysql.exe. ii) I could observe a small bug.Whenever I use a delete or update command,it always gives a message on my console window stating that zero rows affected.Ofcourse the actual statement works fine.Only the post command message on console window misleads me many times. Re

Solaris and MySQL 3.23

Hello, I have an interesting problem... I use a toolkit that comes with MySQL 3.23.29. While it works on one server out of the box (it is pre-compiled and no libraries are shipped) which is a Solaris 2.6 server another Solaris 2.6 server it barfs and gives me the: ld.so.1: bin/mysql: fatal: lib

mysql jdbc driver

Hi, I'm using mm.mysql driver version 2.0.4 and jdk.1.3. Actually I'm trying to us it because it keeps on giving me Not suitable driver error. For test I used the JDBCBench.java. try { Class.forName("org.gjt.mm.mysql.Driver");

location of database files

Hi folks. I am trying figure out a way to use my.cnf files (general or user, preferably the later) to set the datadirs for individual users to their home directories on our nfs network, while leaving the mysql users database in the default location at /user/local/mysql/var. We don't want to h

Re: MySQL++ for Visual Basic

Robert Vetter wrote: > D'Arcy Rittich wrote: > > > > > Actually you dont't need a ocx. You can call the MySQL API functions, > > > which are in a dll file. > > > > > > Robert > > > > Do you have any examples of that with VB? > > No, I don't. But you can take a look at an example written in C. > >

Can get safe_msqld to run in background!!

I know this is bound to be something REALLY simple, but I can't seem to get "safe_mysqld" to run in background (Solaris 7/MySQL 3.23.37) If I try, as the "root" user, to start "safe_mysqld" from the "/usr/local/mysql" directory thus... ./bin/safe_mysqld --user=mysql & ...I get the following m

Re: Probs with dbf2mysql

Daniel Hollweg wrote: > Dear audience, > > I encountered a problem in creating the install file from dbf2mysql > downloaded from mysql.com. I changed the Makefile according to my system. I > run Linux Mandrake 7.2 Kernel 2.18. > Whe I run a make in the directory the following errormessage is r

RE: MySQL/PHP/Apache on PPC

Hi, What I am wanting to know is, am I best off installing MySQL/PHP/Apache on Windows98 (emulated on G4 Mac/OS 9.1) or should I hold off for an installation on a separate partition of LinuxPPC. I have tried installing on the Win98 emulator but there are loads of errors. I don't know much

Re:my sql and ASP??

Hi, I have checked up MYSQLX at www.scibit.com but it ties me down to IIS.I cannot use it to apache etc... I am curious to know about any more available components.! Regards, Ravi Do You Yahoo!? Get your free @yahoo.co.uk a

Re: ASP and my sql??

VVM Ravikumar Sarma Chengalvala writes: > Hi everyone, > 1) > Thanks for all your ideas. > 2) > Infact I am already using C-API for data retrieval > from mySQL and I want to provide admin utility to my > application which runs on a web server.I donot want to > use ODBC.It tends to bind my applicat

join your mailinglist, learn and share database (Mysql)

Join your mailinglist, learn and share database (Mysql,SQL). == ¿ì¸® ÀÎÅͳÝ, Daum Æò»ý ¾²´Â ¹«·á E-mail ÁÖ¼Ò ÇѸÞÀÏ³Ý Áö±¸ÃÌ ÇÑ±Û °Ë»ö¼­ºñ½º Daum FIREBALL http://www.daum.net - B

Re: ASP and my sql??

Hi everyone, 1) Thanks for all your ideas. 2) Infact I am already using C-API for data retrieval from mySQL and I want to provide admin utility to my application which runs on a web server.I donot want to use ODBC.It tends to bind my application mostly to windows.Currently I am considering the fll

MySQL/PHP/Apache on PPC

Hi, [newbie, Mac G4] I am migrating from Filemaker Pro to MySQL. I have bought a book, PHP and MySQL Web Development, which I am studying in parallel with an Open University course, Relational Databases. This has given me a bit of a feel for SQL. I am quite au fait with relational concepts bu

problem with Grant

Hi I am using MySql on linux. I can start mysqld by "safe_mysqld --user=mysql --skip-grant-tables & But when i try to start it withour --skip-grant-tables, it said Access Denied @localhost. I have updated the mysql.user table and mysql.host table, still i can't connect it .

Re: DROP TABLE problem!

At 12:37 31/05/2001 +0200, Vili Germic wrote: Hi! The issue mentioned is relative to the Windows security privileges. If the workstation connected or the local user doesn't has privileges to delete files on the /mysql tree, that error message is launches. Click over the MySQL folder icon with th

Re: MySQL++ for Visual Basic

D'Arcy Rittich wrote: > > > Actually you dont't need a ocx. You can call the MySQL API functions, > > which are in a dll file. > > > > Robert > > Do you have any examples of that with VB? No, I don't. But you can take a look at an example written in C. Robert ---

xml support?

Hi, I am trying to find out whether mysql has any support for xml? Can anyone help me please? Please cc replies to [EMAIL PROTECTED] Thanks for any help Steve - Before posting, please check: ht

RE: DROP TABLE problem!

Just one thing I can think of.. Have you got GRANT privileges to drop DB? Simon -Original Message- From: Vili Germic [mailto:[EMAIL PROTECTED]] Sent: 31 May 2001 11:37 To: [EMAIL PROTECTED] Subject: DROP TABLE problem! Hello everybody, MySQL - 3.23.38 Win MyODBC - 2.50.37 I'm usin

DROP TABLE problem!

Hello everybody, MySQL - 3.23.38 Win MyODBC - 2.50.37 I'm using MySQL on local machine with Win2000 plattform, using MyODBC(ver. 2.50.37) to connect to db trought ODBC. Things works well, except for dropping table. I'm using ODBC API in MS Visual C++ 6.0 to connect to ODBC. Trought SQL statement

MySQL installation problem

Hi Dear Sir/Mdm, I've encountered a problem when I run 'scripts/mysql_install_db' command. The error message is following: Starting mysql server ./bin/safe_mysqld: /my/gnu/bin/hostname: not found ./bin/safe_mysqld: /my/gnu/bin/hostname: not found ./bin/safe_mysqld: /my/gnu/bin/hostname: not foun

Re: SELECT question.

On 30 May 2001, at 10:14, Paul DuBois wrote: > At 9:41 AM -0700 5/30/01, Richard Reina wrote: > >I am stuck on a select query and was wondering if someone could help. > > I have I've written a database app. that helps me run my business > >(trucking). I need however to write a query that shows m

RE: Too much CPU Usage

Note Try with out pconnect and you will find there is little time lost if any! -Original Message- From: Felix Schueren [mailto:[EMAIL PROTECTED]] Sent: 31 May 2001 10:37 To: Xavi Gracia Cc: [EMAIL PROTECTED] Subject: Re: Too much CPU Usage Hey, looks like you're using pconnects with a

Re: Too much CPU Usage

Hey, looks like you're using pconnects with a high timeout value. You have over 600 processes on the poor machine. 588 of those are sleeping, but they still burn CPU cycles. Either switch your scripts from pconnect to plain connect or lower the timeout value for inactive connections (in your my.c

Probs with dbf2mysql

Dear audience, I encountered a problem in creating the install file from dbf2mysql downloaded from mysql.com. I changed the Makefile according to my system. I run Linux Mandrake 7.2 Kernel 2.18. Whe I run a make in the directory the following errormessage is reported : gcc -O2 -Wall -s -L. -L/us

RE: COUNT and WHERE

if you use an alias in your select clause use the same alias in the having clause so having num > 1 -Original Message- From: Ben Smith [mailto:[EMAIL PROTECTED]] Sent: Thursday, May 31, 2001 11:00 AM To: [EMAIL PROTECTED] Subject: COUNT and WHERE Hello, I have this query select a.matc

Re: FW: FW: fascinating. bug

What does this have to do with mysql? Rene Tegel wrote: > > It would help if you located the piece of source code where the bug might get >involved and post this source code. > > On Thu, 31 May 2001 02:32:22 -0500 > "Dawn H" <[EMAIL PROTECTED]> wrote: > > > Hi, folks, > > > > The quote belo

Re: Java Applet for Mysql

Thanks for the prompt reply. I am new in Java. Can you recommend a online tutorial that related to Database programming(Java) for Mysql Many Thanks :Tanpy - Original Message - From: "Jeremy Zawodny" <[EMAIL PROTECTED]> To: "David Tan Teck Siang" <[EMAIL PROTECTED]> Cc: <[EMAIL PROTECTED

Re: FW: FW: fascinating. bug

It would help if you located the piece of source code where the bug might get involved and post this source code. On Thu, 31 May 2001 02:32:22 -0500 "Dawn H" <[EMAIL PROTECTED]> wrote: > Hi, folks, > > The quote below - > jonbad.txt is the 'view source' of a page in IE5.0. Just a minute later,

Again MySQL and LOG

Thank you all for your suggestions, I'm using tcsh so I resolve this problem like this: mysql -u root dbname < test.sql >&! log and its working on command line but the problem is, it doesnt work when I put mentioned statement into a bach file. for example I create a file (createtables) and its c

COUNT and WHERE

Hello, I have this query select a.match_id, count(a.players_id) as num, a.description from a group by a.players_id, a.match_id order by num desc I only want to see the records where the count of players_id is greater than 1, and in various other DB's i'd use the Having clause, so i tried where

Re: password assign for localhost

ahh .. help, after i follow what u said, and do the update in my password then flush privileges, now i can't even access my database with the password .. . so, how now ??? - Original Message - From: "David Lidström" <[EMAIL PROTECTED]> To: "Alice" <[EMAIL PROTECTED]> Sent: Thursday, May 3

RE: password assign for localhost

You must, after updating the user table, FLUSH PRIVILEGES And you should also set the password using the PASSWORD-command. update mysql.user set password = PASSWORD('abc') where user = 'root' and then FLUSH PRIVILEGES /d -Original Message- From: Alice [mai

Re: MySQL Hang and Freeze

On Thu, May 31, 2001 at 12:37:56AM -0500, Mike Trotzke wrote: > >Have you tried putting the file in some other location (/tmp?) just to > >see if it has any effect? > > I'm not exactly sure what file you mean. But based on your comments, > I tried puting the my.conf file in /tmp and resterting---

  1   2   >