auto-increment and mysqldump

2001-05-31 Thread Matt Templeton
I've read the documentation but can't seem to find a clear answer to this... If I set up a table that has and auto-increment ID table and insert a number of records that are incremented in sequence. Then I delete, say the 5th and the 8th row and do a full (database creation and data)

Re: sessions problems

2001-05-31 Thread g_gosho
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 list [EMAIL PROTECTED] Cc: Mysql Mailing List [EMAIL PROTECTED] Sent: Wednesday, May 30,

password assign for localhost

2001-05-31 Thread Alice
at the moment, i am still connect to local host without a password. i did try to using query to update the MySQL db and update the user table on it for the user where it is 'root' my asp prog did connected to my db which have the connection string that the password is blank. but with the

Re: auto-increment and mysqldump

2001-05-31 Thread Jeremy Zawodny
On Wed, May 30, 2001 at 11:33:50PM -0700, Matt Templeton wrote: I've read the documentation but can't seem to find a clear answer to this... If I set up a table that has and auto-increment ID table and insert a number of records that are incremented in sequence. Then I delete, say the 5th

Re: myisamchk --sort-records extremely slow

2001-05-31 Thread Jeremy Zawodny
On Wed, May 30, 2001 at 11:32:16PM -0400, Michael Villalba wrote: 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

RE: FW: FW: fascinating. bug

2001-05-31 Thread Dawn H
Hi, folks, The quote below - jonbad.txt is the 'view source' of a page in IE5.0. Just a minute later, after refreshing, the same person on the same browser got jongood.txt - without any changes being made to the page on the server. For some reason PHP is not doing right. Any ideas? A cookie

Re: User Sign-up/Log-in

2001-05-31 Thread Jeremy Zawodny
On Wed, May 30, 2001 at 11:20:02PM -0400, Randall Fitzgerald wrote: I am just wondering about the code to do a query for a string and then see if that string exists or not. like finding the string for $user in a DB when $user would be inserted into a table named users as username to see fi

Re: Java Applet for Mysql

2001-05-31 Thread Jeremy Zawodny
On Thu, May 31, 2001 at 09:30:11AM +0800, David Tan Teck Siang wrote: Can anyone here recommend a link to the FREE and the most simple Java source code for MYSQL query without using Java runtime?? I'm confused. How do you plan to do this without a Java runtime? Have you looked on

RE: password assign for localhost

2001-05-31 Thread David Lidström
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

Re: password assign for localhost

2001-05-31 Thread Alice
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 31, 2001

COUNT and WHERE

2001-05-31 Thread Ben Smith
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

Again MySQL and LOG

2001-05-31 Thread Mohammad Shoja
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

Re: FW: FW: fascinating. bug

2001-05-31 Thread Rene Tegel
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, after

Re: Java Applet for Mysql

2001-05-31 Thread David Tan Teck Siang
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] Sent:

Re: FW: FW: fascinating. bug

2001-05-31 Thread Colin Faber
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 below - jonbad.txt

Probs with dbf2mysql

2001-05-31 Thread Daniel Hollweg
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.

Re: Too much CPU Usage

2001-05-31 Thread Felix Schueren
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

RE: Too much CPU Usage

2001-05-31 Thread Simon Green
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: SELECT question.

2001-05-31 Thread Scott Alexander
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 me all

MySQL installation problem

2001-05-31 Thread yewei
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

DROP TABLE problem!

2001-05-31 Thread Vili Germic
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

RE: DROP TABLE problem!

2001-05-31 Thread Simon Green
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

xml support?

2001-05-31 Thread Steve Menday
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] mailto:[EMAIL PROTECTED] Thanks for any help Steve - Before posting, please check:

Re: MySQL++ for Visual Basic

2001-05-31 Thread Robert Vetter
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

Re: DROP TABLE problem!

2001-05-31 Thread Miguel Angel Solórzano
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

problem with Grant

2001-05-31 Thread Damnish
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 .

MySQL/PHP/Apache on PPC

2001-05-31 Thread Tommy Beavitt
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

Re: ASP and my sql??

2001-05-31 Thread VVM Ravikumar Sarma Chengalvala
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

join your mailinglist, learn and share database (Mysql)

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

Re: ASP and my sql??

2001-05-31 Thread Sinisa Milivojevic
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 application

Re:my sql and ASP??

2001-05-31 Thread VVM Ravikumar Sarma Chengalvala
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

RE: MySQL/PHP/Apache on PPC

2001-05-31 Thread Jon Haworth
Hi, snip 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. /snip I don't

Re: Probs with dbf2mysql

2001-05-31 Thread Gerald Clark
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

Can get safe_msqld to run in background!!

2001-05-31 Thread Adrian . Davis
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

Re: MySQL++ for Visual Basic

2001-05-31 Thread Eric Grau
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. Robert The MyVbQL

location of database files

2001-05-31 Thread Sean O'Brien
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

mysql jdbc driver

2001-05-31 Thread Dacian Herbei
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);

Solaris and MySQL 3.23

2001-05-31 Thread Donahue,Rob
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:

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

2001-05-31 Thread VVM Ravikumar Sarma Chengalvala
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.

MySQL Version and Solaris

2001-05-31 Thread A. Krosunger
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

DISTINCT and HAVING

2001-05-31 Thread Benjamin Boksa
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

**Urgente** I can't compile mysql

2001-05-31 Thread mens
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

Installation

2001-05-31 Thread Evan James Dembskey
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 :

Some minor MySQL v.3.23.38 fixes and Help corrections

2001-05-31 Thread Roberto de Martin Serqueira
Hi I'm forwarding you the attached file MYSQL_3.23.38_FIXES.ZIP which containsfileswith some minor improvements and fixes done by me, updatedto MySQL version 3.23.38, and presenting the following: - Directory \LIBMYSQL: - file ERRMSG.C: included section of code with client error

A blob question

2001-05-31 Thread avegaaraya
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/

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

2001-05-31 Thread Kaspar Cyrill
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,

missing mysqladmin

2001-05-31 Thread [EMAIL PROTECTED]
Hi! After installation on a RH Linux Box, mysqladmin is missing. Any idea ? Thanks

Which Source Dist. to use

2001-05-31 Thread Vien Huynhle
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

Re: ASP and my sql??

2001-05-31 Thread Jorge del Conde
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] / /|_/ / // /\ \/ /_/ / /__

Re: Can get safe_msqld to run in background!!

2001-05-31 Thread Joseph Bueno
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_mysqld

Re: A blob question

2001-05-31 Thread Olexandr Vynnychenko
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

REPLICATION problem (bad magic number)

2001-05-31 Thread oleg
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: myisamchk --sort-records extremely slow

2001-05-31 Thread Steve Brazill
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

Re: missing mysqladmin

2001-05-31 Thread [EMAIL PROTECTED]
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

Re: xml support?

2001-05-31 Thread Jeremy Zawodny
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] mailto:[EMAIL PROTECTED] What sort of support? XML is just text. You can store and retrieve text

Re: Solaris and MySQL 3.23

2001-05-31 Thread Jeremy Zawodny
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: MySQL Version and Solaris

2001-05-31 Thread Jeremy Zawodny
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 make

Re: MySQL installation problem

2001-05-31 Thread Jeremy Zawodny
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:

mySQL and VBscript

2001-05-31 Thread La Rocca Network, Inc.
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

Re: Installation

2001-05-31 Thread Jeremy Zawodny
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? #

RE: Insert Automatically

2001-05-31 Thread KAMRY
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: Insert Automatically

2001-05-31 Thread Johnny Withers
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

problem wtih mysql GUI

2001-05-31 Thread D . Veerasamy
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:

RE: Insert Automatically

2001-05-31 Thread jaab
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, ); insert

Re: MySQL Server hosting: Linux or Win2K?

2001-05-31 Thread Jeremy Zawodny
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

RE: Insert Automatically

2001-05-31 Thread Paul DuBois
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 c.

RE: Insert Automatically

2001-05-31 Thread VVM Ravikumar Sarma Chengalvala
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 countries

Problem running old database with 3.23.30-gamma

2001-05-31 Thread Beverly Baird
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

RE: Insert Automatically [pass on command line]

2001-05-31 Thread Sean O'Brien
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,

PHP Mysql weirdness

2001-05-31 Thread js
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

Replication

2001-05-31 Thread Warren van der Merwe
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

ACT2 Conversion

2001-05-31 Thread James McLaughlin
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,

'Overlays' for record layouts

2001-05-31 Thread Steve Brazill
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,

Re: xml support?

2001-05-31 Thread Gary Huntress
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 :)

ORDER weirdness... (help?)

2001-05-31 Thread Chris Petersen
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: +++ |

Re: ORDER weirdness... (help?)

2001-05-31 Thread xris
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.. Using

Question concerning SHARED DATABASE

2001-05-31 Thread Kenneth Kopelson
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

clisp interface for mysql

2001-05-31 Thread Dennis
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:

Re: problem wtih mysql GUI

2001-05-31 Thread Rolf Hopkins
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] Sent:

Re: Problem running old database with 3.23.30-gamma

2001-05-31 Thread Rolf Hopkins
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 database

Re: ACT2 Conversion

2001-05-31 Thread Rolf Hopkins
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:

Optimizing Mysql for CGI Search Engine

2001-05-31 Thread Tanpy
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

Re: DBD and locking

2001-05-31 Thread Jeremy Zawodny
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 Finance

Re: DBD and locking

2001-05-31 Thread Jeremy Zawodny
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 I

Re: Large table crash recovery

2001-05-31 Thread Aaron Williams
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,

TIMESTAMP

2001-05-31 Thread Roland Hannes Niedner
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

MySQL BOF @ OpenSource Convention...

2001-05-31 Thread Jeremy Zawodny
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,

help!!!!

2001-05-31 Thread Jeff Davidson
Where do you enter the commands to install mySQL?? I know it's a stupid question, but please, enlighten me.

Data Replication

2001-05-31 Thread Duane Stark
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

What's the best os?

2001-05-31 Thread David Freeman
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

Re: TIMESTAMP

2001-05-31 Thread Paul DuBois
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. Into a

Re: BDB tables bugs

2001-05-31 Thread Peter Zaitsev
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 (GLIBC 2.2.x) Peter

Re: What's the best os?

2001-05-31 Thread Michael Bacarella
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: problem with Grant

2001-05-31 Thread oltra jean-michel
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

Re: help!!!!

2001-05-31 Thread Rolf Hopkins
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

Re: What's the best os?

2001-05-31 Thread Jeremy Zawodny
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,000

RE: What's the best os?

2001-05-31 Thread David Freeman
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

Re: What's the best os?

2001-05-31 Thread Jeremy Zawodny
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: problem with Grant

2001-05-31 Thread Damnish
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 you