Connecting database and XML pages

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

Re: Hanging on Inserts

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

Re: [CLUG-tech] Starting MySQL

On Mon, 30 Jul 2001, Gavin Philips-Page wrote: Please help: 1. We have installed MySQL source version 3.23.40.tar.gz. Everything installed OK. We ran the command ./bin/mysql_install_db. This worked fine. We then ran /etc/rc.d/init.d/mysql start. The result no such file or directory. We

Connecting MySQL over a Novell network

+ Hi, I try use MySQL with Apache server and PHP language under Windows. I've installed phptriadsetup.zip from local ftp server: ftp://ftp.pik-net.pl/pub/win95/phptriadsetup.zip It works excellently in win98/win2k/linux network. However we have another network, which have no connection with

Re: Building an application for accessing mysql

Hi Mauro I would take Java. My reasons: 1) I know Java better than Visual Basic. 2) It is platform independant. 3) You can use the mm JDBC-driver (a type 4 one) for direkt communication. With Visual Basic you have to communicate with ODBC via MyODBC to MySQL (one more step). I found that ADO

TRY THIS - YOU WILL NOT REGRET!!! (ADV.)

Dear [EMAIL PROTECTED], Dear Friend, DO NOT DELETE IF YOU HAVEN'T READ THIS. Please PRINT - then READ. You will not regret and its fun doing it. Many times so far I ignored E-mails like this (I am sure now that I was wrong). Please just spend 5 min reading this and then decide. I received

Bug with not_flushed_delayed_rows in mysql-4.0 ?

Hi, I have more than 200 Delayed_insert running at the same time on my database (waiting on cond state right now), and I just noticed a strange thing with the not_flushed_delayed_rows variable : | Not_flushed_delayed_rows | 4294967295 | It would be quite annoying if it was true, but no, I've

Re: Connecting MySQL over a Novell network

PC there communicates through Novell 4.11 server, some use Windows protocol. I've used the same installation, and more, one from Apache serverer PC can be connected alternatively to one or to second network. In the first, it works, as I've mentioned earlier, in the second the server sees himself

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

Venu (and others who may have suggestions) No: the server is up and running. Plus, I don't think I was clear enough on the kind of errors I get. Let me try another way... When I try to get a connection to a local, non-running, mySQL server, I get a java.net.ConnectException. That I understand:

how to use mysql

Dear Mr./Mrs, I am a new learner. I have downloaded the (3.23.38 Windows 95/98/NT/2000 Complied Zip file). I have already installed in my computer, but I am failed to use it. My computer is Windows Me. Is it need to set ODBC? IF yes how to set it? and which file should I open creat table

Comparison between tables types

If we need speed, we use ISAM. If we need transaction-base, we can use the others. But is there any comparison among DBD, InnoDB Gemini? And since Gemini is currently having a dispute with mySQL, will the Gemini support cease in near future? == Best Regards Jason Kwok ==

myisamchk

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 to make sure they are alright)? With skip_locking set to ON I would have to make sure none is working on my

Can't start server : Bind on unix socket: Permission denied

Hi Guys, Ahem...er, I've dropped a clanger! I tried to move my datadirectory to another device with more room. And yes, I know NOW that I should have created symbolic links for the databases in question but...well, the rest is history... * First Tech info: Red Hat

mySQL, MS SQL and a push subscription?

Hello, I spent the last days with searching a solution for the following problem: We have to synchronise an MS SQL database in the USA with a mySQL database in germany. The programmer who supports the database in the USA likes to do that via a push-Subscription, which is an MS SQL feature

Re: TRY THIS - YOU WILL NOT REGRET!!! (ADV.)

I do NOT who you are. I do not believe I have ever asked this list, or anyone else to spam me; however, and you'll notice I have post TO THE LIST my response to this email of yours in hopes that two things will happen, one YOU'LL stop this at once, and two anyone else on this list thinking of

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

MySQL returns the autoincrement number - ask it! In php, this is wrapped into mysql_insert_id(); Zbigniew Szczesny schrieb am Montag, 30. Juli 2001, 21:15:37: 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

Un Install Mysql

Hi I have installed mySQL 3.22.32 client server rpms on our co located RAQ 4 server, however due to a few issues with ODBC drivers we have been advised to remove the rpms and install from a pkg file through our site administration. The only problem is I have absolutely no idea how to remove

RE: mySQL, MS SQL and a push subscription?

Hi, We have to synchronise an MS SQL database in the USA with a mySQL database in germany. The programmer who supports the database in the USA likes to do that via a push-Subscription, which is an MS SQL feature (not a very save feature I read!?). So, my question is: Is there a way to do

synopsis of the problem (one line)

Description: How-To-Repeat: Fix: Submitter-Id: submitter ID Originator:root Organization: MySQL support: [none | licence | email support | extended email support ] Synopsis: Severity: Priority: Category: mysql Class: Release:

Re: Hanging on Inserts

DS writes: 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

Server Starting Problem

Hi, i am working on Linux and when i try to start mysql server, iget an error /usr/libexec/mysqld: Can't find file: './mysql/host.frm' (errno: 13) what is that file abt? -- K.S.Selva Prakash Tachyon Technologies Pvt Ltd. -

query about the default port number of mysql server

I am installing mysql on red het linux from .rpm distribution.Would you please tell me that what is the default port number of mysql sql server on it. thank you alok - Before posting, please check:

how to make a column of a table unique

hi, i want a column only holding unique rows. do i have to declare this column as a primary key, or is there another possibility? thx bastian -- Externe Mail[EMAIL PROTECTED]31.07.200113:01

Re: mySQL, MS SQL and a push subscription?

Sebastian Frost writes: Hello, I spent the last days with searching a solution for the following problem: We have to synchronise an MS SQL database in the USA with a mySQL database in germany. The programmer who supports the database in the USA likes to do that via a

Re: query about the default port number of mysql server

On Tue, 31 Jul 2001 17:04:33 +0530, Alok Kaushik [EMAIL PROTECTED] wrote: I am installing mysql on red het linux from .rpm distribution.Would you please tell me that what is the default port number of mysql sql server on it. thank you alok port = 3306 Mike(mickalo)Blezien

Re: Can't start server : Bind on unix socket: Permission denied

FIXED. For those that don't know go through the searchable archive of this mailing list (http://lists.mysql.com) ... I should have done in the first case! Anyway, if ever you get the socket error described below it's just a case of setting your permissions correctly. chmod 700 datadir (e.g

Placing directory structure under GNU GPL

I wonder whether the default directory structure of all future mysql releases could also be GPL'led. That would prevent others from placing the releases on directories of their own choice. This would be a very useful restriction, as then changing OSes would be lot easier, rather than remember

mysql Mirroring

Hi, Just a quick high level design question? Is mirroring only a one way action? i.e. one in use database and one backup database? Or is it possible to use both databases and they'll both update each other? Regards Marty -

Re: Placing directory structure under GNU GPL

On Tue, Jul 31, 2001 at 06:48:07PM +0400, System Administrator wrote: I wonder whether the default directory structure of all future mysql releases could also be GPL'led. That would prevent others from placing the releases on directories of their own choice. The GPL does not impose any

client/server

Hello! I'm a newbie at mysql and i'm looking for a client program for win23 that can accsess a mysql database and create and alter tables. The mysql database is placed on a linux box in my lan, and im not too keen of sitting in console. The linux box also holds the apache server,with php but i

Query Not Using Indexing

I'm running MySQL v3.22.32. Here's my problem I run the following select query and both CompanyRep and PostalCodeInfo tables are not using my Indexing. Why? How can I get these two tables to use indexing to speed up my query. You can look at my indexing on the two tables below the query. Any

Re: mysql account? account on mysql?

On Tuesday 31 July 2001 08:40, [EMAIL PROTECTED] wrote: 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? In alomost all cases

Replace delayed on a slave

When a replace delayed into ... query gets executed by the replication thread on a slave database server it doesn't seem to end up the delayed queue (v3.23.33). Can someone confirm this? Is there a work around or pending fix? Thanks.

Re: client/server

hi *, take a look at http://phpwizard.net/phpMyAdmin/ it's a great tool using your apache and php. Andreas - Original Message - From: [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: Tuesday, July 31, 2001 4:37 PM Subject: client/server Hello! I'm a newbie at mysql and i'm looking

Re: client/server

Check out urSQL from http://www.urbanresearch.com/ursql. On Tue, 31 Jul 2001 [EMAIL PROTECTED] wrote: Hello! I'm a newbie at mysql and i'm looking for a client program for win23 that can accsess a mysql database and create and alter tables. The mysql database is placed on a linux box in

RE: client/server

Hello! I'm a newbie at mysql and i'm looking for a client program for win23 that can accsess a mysql database and create and alter tables. The mysql database is placed on a linux box in my lan, and im not too keen of sitting in console. The linux box also holds the apache server,with php but i

makefile

Hi I am using Linux7.1 operation system. I would like to install Mysql on this system. I downloaded the Linux(intel libc6 systems)[pc-linux-gnu-i686]. Is it correct? I installed it many time, but they couldn't find the makefile. How can I slove this problem? Could you give me some suggestions?

RE: how to use mysql

Hi ! -Original Message- From: yuen ting chiu [mailto:[EMAIL PROTECTED]] Sent: Tuesday, July 31, 2001 2:25 AM To: [EMAIL PROTECTED] Subject: how to use mysql Dear Mr./Mrs, I am a new learner. I have downloaded the (3.23.38 Windows 95/98/NT/2000 Complied Zip file). I have

MySQL GUI

I am having problems with the MySQL GUI for Win32. On my Win2000 Pro machine my unzipper ( Aladdin Expander) cannot write to the target directory specified in the archive because it does not exist. Any ideas? David Damstra One Protocol, Inc. [EMAIL PROTECTED] 616.732.6300 616.732.6301 Fax

japanese character import in mysql

Hi i have problems importing a japanese Accessdatabase into a mysqlserver. the System is running with a german character set and if i import the data out of the Accessatabase there are only questionmarks in it. any advice is welcome Mit freundlichen Grüssen / Kind regards Burkard Endres i-te

Myisamchk's Error 22

I'm running MySQL 3.23.39 on RedHat 7.1. When I run myisamchk on my tables I always get: error: 22 when opening MyISAM-table ... After searching through the mailing lists I can find some people with the same question, but not any answers. Anyone out there solve know about this problem? TiA,

010731 13:25:51 Can't init databases

When I try to start the mysql I get : C:\mysql\binmysqld 010731 13:25:51 Can't init databases C:\mysql\bin What can I do ? Pessin - Before posting, please check: http://www.mysql.com/manual.php (the manual)

RE: MyOdbc to unix

Re my previous message about tech support and access from windoze to unix. follows is the response i recieved from them: Can you provide the command line sequence sent to the servers in terms of user, pass, db name, hostname, etc? remember that the hostname is localhost for mysql. From there we

HELP PLEASE mysql will not start

Hello, I am getting this error in the .err file 010731 9:48:22 Can't start server: Bind on TCP/IP port: Address already in use 010731 9:48:22 Do you already have another mysqld server running on port: 3306 ? 010731 9:48:22 Aborting Everything was working fine then I installed phpshop and

show create table

Hi, since which version was the show create table syntax introduced? I'm planning to implement it in MySQL-Front for the database-export-options, but I have to check the version first. Greetings, Ansgar Becker - Before

php portals using mysql

Hello All, Fairly new to the list, but I have lurking for a while and finally came up with the gumption to ask a question. Currently, I am looking for a php based portal system that utilizes MySQL (dont they all?) as a backend database. With the recent security alert with PHPnuke, I am not

Re: Server Starting Problem

The mysql directory and files are not owned by mysql. chown -R mysql /var/lib/mysql ( or whatever ) Selva Prakash wrote: Hi, i am working on Linux and when i try to start mysql server, iget an error /usr/libexec/mysqld: Can't find file: './mysql/host.frm' (errno: 13) what is that file

Re: show create table

Version 3.23.20 On Tue, 31 Jul 2001, Ansgar Becker wrote: since which version was the show create table syntax introduced? - Before posting, please check: http://www.mysql.com/manual.php (the manual)

msg from MAILER-DAEMON@web.mysql.com

This is one of several similar messages I received today. Someone to take care of it? Hi. This is the qmail-send program at web.mysql.com. I'm afraid I wasn't able to deliver your message to the following addresses. This is a permanent error; I've given up. Sorry it didn't work out. [EMAIL

RE: php portals using mysql

There was an issue with PHP-Nuke but it has been fixed in the newest release. Alot of the problem was Admin not changing and setting permissions on the site and database. Security is only as good as you make it! My portal with MySQL runs excellent and I'll never use anything else again.

Writing 100+ fields with Perl DBI

In my application I'm writing up to 120 fields of data in one swoop (the results of a sort of survey). I'm using Perl DBI with MySQL. Each survey has several fields of data like 'name' (stored as parameters in the CGI object $asmt) and then up to 100 actual survey questions (Q1, Q2, etc).

Fw: Bug with not_flushed_delayed_rows in mysql-4.0 ?

- Original Message - From: Fournier Jocelyn [Presence-PC] To: [EMAIL PROTECTED] Sent: Tuesday, July 31, 2001 10:42 AM Subject: Bug with not_flushed_delayed_rows in mysql-4.0 ? Hi, I have more than 200 Delayed_insert running at the same time on my database (waiting on cond state

Increase business with wealthy Russian clients

MOSCOW INTERNATIONAL WINTER WORKSHOP 06 September 2001 The Russian travel market continues to expand with many destinations posting increases of more than 15% this summer. The Russian Travel market is a lucrative market and the Travel Companies are looking for new offers for their clients.

Re: Query Not Using Indexing

Adam Douglas writes: I'm running MySQL v3.22.32. Here's my problem I run the following select query and both CompanyRep and PostalCodeInfo tables are not using my Indexing. Why? How can I get these two tables to use indexing to speed up my query. You can look at my indexing on the two tables

Re: Query Not Using Indexing

Adam Douglas writes: I'm running MySQL v3.22.32. Here's my problem I run the following select query and both CompanyRep and PostalCodeInfo tables are not using my Indexing. Why? How can I get these two tables to use indexing to speed up my query. You can look at my indexing on the two tables

Re: MySQL GUI

David Damstra writes: I am having problems with the MySQL GUI for Win32. On my Win2000 Pro machine my unzipper ( Aladdin Expander) cannot write to the target directory specified in the archive because it does not exist. Any ideas? David Damstra One Protocol, Inc. [EMAIL PROTECTED]

Re: MySQL GUI

Michael Collins writes: What is MySQL GUI exactly? Is it like the MySQL module to Webmin for viewing the database schema and manipulate table and column names? As well as view the row details. Is it more capable or equivalent? How about as compared to phpMyAdmin? I have not been able to

Help optimizing server ...

Hello, I need some help for database optimization ... is there any documentation about tuning server parameters except this one in MySQL-documentation which ist not very detailed I think especially in case of effects on server or threads. TIA Stephan

Problem compiling on HPUX 10.20

Hi list members, After ./configure --prefix=/usr/local/mysql I do a make and when change dir to mit-pthreads, I got following err msg: Making all in mit-pthreads Make: Must be a separator on rules line 26. Stop. Thanks for any help. Ing. Gustavo A. Edelstein Tech. Mgr. Equiplus Argentina

Fw: client/server

Hello again! Is there no way a program like netadmin could alter databases .. and create tables? i really like the looks of that GUI I dont wanna install mysql on the win2k box.. i'd like to keep it on the linux box.. /Lasse

Re: MySQL GUI

Perhaps Marc Liyanage would be willing to do it? He already has some great packages available for easy install to Mac OS X: http://www.entropy.ch/software/macosx/ BTW, thanks Marc! Michael At 10:36 PM +0300 7/31/01, Sinisa Milivojevic wrote: If there is a kind soul that would like to

Problem compiling on HPUX 10.20

Hi list members, After ./configure --prefix=/usr/local/mysql I do a make and when change dir to mit-pthreads, I got following err msg: Making all in mit-pthreads Make: Must be a separator on rules line 26. Stop. Thanks for any help. Ing. Gustavo A. Edelstein Tech. Mgr. Equiplus Argentina

client/server

Hello again! Is there no way a program like netadmin could alter databases .. and create tables? i really like the looks of that GUI I dont wanna install mysql on the win2k box.. i'd like to keep it on the linux box.. /Lasse

Can MySql runs on the Stratus B11.0 HP-UX 64 bits machine

Hello, We have a Stratus HP-UX 64 bits (version B11.0) machine, I would like to know if MySQL can run on the Stratus Box. If it can, will it cause any problem? Can MySQL be configured to the 64 bits to run on the Stratus? Thanks in advance. Connie

Re: Database Security

You can protect the directory your file lives in with .htaccess Claudemir F. Martins schrieb am Montag, 30. Juli 2001, 17:17:53: 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

Re: Using symbolic links for databases and tables

What about having symbolic links in the same directory as the original file? I have a situation where a broken Windoze application has different queries embedded, with some using tablename(lower case), and some using TABLENAME(upper case). The database actually resides on a Linux server, so

Capture SHOW VARIABLES to fie

Is there a way to redirect the output of a MySQL statement like SHOW VARIABLES to a file? Thanks Frank - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/

Re: msg from MAILER-DAEMON@web.mysql.com

Don't know. I receive messages, but some of my posts were not delivered with that obscure reason. Looks like an error of the mailinglist daemon to me. Adam Douglas schrieb am Dienstag, 31. Juli 2001, 21:12:06: Why can I not post to the mailinglist? -Original Message- From: Werner

Re: Writing 100+ fields with Perl DBI

On Tue, 31 Jul 2001, Nelson Goforth wrote: snip And this works fine for the text file - but from what I've seen I probably can't carry over the iteration through the (up to) 100 actual survey questions. I named the MySQL fields 'q1', 'q2', anticipating some way to do a loop, but I can't

RE: Query Not Using Indexing

-Original Message- From: Sinisa Milivojevic [mailto:[EMAIL PROTECTED]] Sent: Tuesday, July 31, 2001 1:27 PM To: [EMAIL PROTECTED] Cc: [EMAIL PROTECTED] Subject: Re: Query Not Using Indexing Adam Douglas writes: I'm running MySQL v3.22.32. Here's my problem I run the following

RE: MyOdbc to unix

Hi ! -Original Message- From: Glyndower [mailto:[EMAIL PROTECTED]] Sent: Tuesday, July 31, 2001 9:49 AM To: [EMAIL PROTECTED] Subject: RE: MyOdbc to unix Re my previous message about tech support and access from windoze to unix. follows is the response i recieved from them:

Fwd: Re: msg from MAILER-DAEMON@web.mysql.com

Hi, Personnaly, I receive : recipient [EMAIL PROTECTED] does not exist, verify e-mail address, please From [EMAIL PROTECTED], and no way to send my mail to the list. Something is definitively wrong with the mailing list. Jocelyn Fournier Presence-PC - Original Message - From: Werner

Re: Writing 100+ fields with Perl DBI

I don't see the problem. If you have a table with 120 columns and need to populate it, do you not want to do it with one insert statement? What else? I am not very familiar with perl, but in php it would be easy for me to construct the insert statement: You can read the columns names into one

Re: Left Join very sloooowwww..

Hi Benjamin, Sorry for the late reply and not giving you any more replies.. Was away some days... Thanks for all the help on my query question.. Indeed like you said, the query now probably is as fast as he will ever get... And that is fast indeed, there isn't any waiting period anymore... I

How to change path to /etc/my.cnf (or ignore it)

On a system running two separate instances of mysqld (different versions) I need to have one of them (special version for one customer) ignore the system-wide /etc/my.cnf file. I would prefer to have the /etc/my.cnf file for this new instance located somewhere else. The version I'm building

Fwd: RE: Re: msg from MAILER-DAEMON@web.mysql.com

Dies ist eine weitergeleitete Nachricht Von: Adam Douglas [EMAIL PROTECTED] An: 'Werner Stuerenburg' [EMAIL PROTECTED] Datum: Mittwoch, 1. August 2001, 00:40:33 Betreff: msg from [EMAIL PROTECTED] ===8==Original-Nachricht=== should I unsubscribe and then resubscribe to

Re: client/server

At 9:39 PM +0200 7/31/01, lasse wrote: Hello again! Is there no way a program like netadmin could alter databases .. and create tables? i really like the looks of that GUI I dont wanna install mysql on the win2k box.. i'd like to keep it on the linux box.. Check out these: phpMyAdmin

Compiling error

Hello I'm tryig to compile MySQL on a Linux with kernel 2.0.34 and libc5 but configure fails. It says I don't have Linuxthreads installed, it may be truth, I don't remember intalling them, but then I went to mysql.com/Downloads/Linux and downloaded the only thing I saw there that was not a

account?

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

RE: MyOdbc to unix

Hi ! -Original Message- From: Glyndower [mailto:[EMAIL PROTECTED]] Sent: Tuesday, July 31, 2001 9:49 AM To: [EMAIL PROTECTED] Subject: RE: MyOdbc to unix Re my previous message about tech support and access from windoze to unix. follows is the response i recieved from them:

Re: Parsing text file into mysql database.

with the sircam virus going around, i'm not into opening attachments. my guess is that you are running into the cr/lf problem. windows terminates lines with a cr/lf. unix uses only a lf. so when you read the windows file, the cr terminates a record and then the lf terminates the interspersed

Re: Writing 100+ fields with Perl DBI

You are correct, of course, Werner. I was thinking along the wrong path - of trying to write AS I looped (as I was doing with the text file), rather than using the loop to build the INSERT statement and THEN writing to the database. Christopher Jones also provided me with a sample of very

Max Quota?

Can I stablish a quota for every database in MySQL? If this is possible, how can I do this? For example, I want 50mb for the x database, and 200mb for 2x database. Any help would be appreciated. PROSSES, Roberto Ramírez. Tel-Fax. 8115 3197 y 99