Can login to my default DB, but not an additional one

Dear sirs, Possible (minor?) bug? I'm a newbie to MySQL and MySQLGUI, but I have a fair amount of experience w/Paradox and MS Access. I am using www.phpwebhosting.com to host my web site (www.Rebates4Sure.com). I can telnet to Rebates4Sure.com, login in, and use a command "mysql -q" and succ

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

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 bas

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 e

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 th

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 p

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 patch

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 P

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

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 for

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 al

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 ar

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: "Wer

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 th

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

Re: Writing 100+ fields with Perl DBI

On Tue, 31 Jul 2001, Nelson Goforth wrote: > > 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: 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: Wer

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/ (th

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 fi

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 file

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 __

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 -

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 S

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 buil

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

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 S.A

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

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 ab

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 PROTE

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 tabl

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 tabl

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.

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 rig

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). Un

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. Chee

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 PROT

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) http://lists.m

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

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 sur

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 po

Re: MySQL GUI

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 take a look since there is no

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 my

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

010731 13:25:51 Can't init databases

When I try to start the mysql I get : C:\mysql\bin>mysqld 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) http:

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, A

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

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

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). >

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? Tha

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 e

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

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 loo

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: 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 cas

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 help

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 ed

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 rest

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 -

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 whi

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 chm

mysql "account"? account on "mysql"?

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 p

Re: query about the default port number of mysql server

Alok Kaushik 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. 3306 -- _/_/ _/_/_/ - Rafał Jank [EMAIL PROTECTED] - _/ _/ _/ _/ _/ Wirtualna

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: 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 push-Sub

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

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: http://www.mysql.com/manua

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

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 i

mysql@lists.mysql.com

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

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 d

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 th

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

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 doi

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 (

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

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

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

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

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:

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 him

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

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 this

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 s

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 o

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"