Mysql taking up 100% of the CPU???

2001-12-12 Thread Brown
hi, i'm running a dual p3 800 machine running freebsd when i do a top, mysql seems to be taking up 100% of one of the CPU's any ideas? Thanks - Before posting, please check: http://www.mysql.com/manual.php (the manual)

sql limitation

2001-12-12 Thread Sommai Fongnamthip
Hi, I was ask for some limitation of SQL command for MySQL (may be this is my mistake). Somebody tell me that GROUP BY clause or ROUND function would not work correctly in some case. Should you help me to group or summary data within the less time (I did not like to use loop to summar

Re: Browser caching problem OR mysql/perl code?

2001-12-12 Thread Gordan Bobic
On Thursday 13 Dec 2001 03:42, Jack A. Fobel wrote: > Hello, > > Coming from an ASP world, I'm trying to learn how to break the browser from > caching. I am using variables and their values in the querystring to > update a mysql database with perl. I am also re-querying the database to > pull bac

problem on starting mysql server

2001-12-12 Thread Dipali Chittar
Hi I am a newbie and when installing mysql-4.0.0 on RedHat Linux I get an error message on mysql start: /etc/rc.d/init.d/mysql start I get a message: touch:creating /usr/local/var/dipalic.err:No such file or directory. Starting mysqld daemon with databases from /usr/local/var /usr/local/bin/my

Re: Inches and Degrees

2001-12-12 Thread Steve Edberg
Well, as far as the inches and fractions thereof go, you could always normalize your data to the smallest measurement - for example: if the smallest increment is 1/32 of an inch, store all measurements in terms of 32nds. So, 1" => 32, 1-5/32" => 37, and so on. Then you could store the values i

POSTGRESQL VS MYSQL

2001-12-12 Thread Randy Johnson
Hello, I was wondering if anybody new of any articles out there that benchmarked mysql and postgresql recently.I have a few that have favored and have not seen any other ones that favor mysql accept for the benchmarks on the mysql website Thanks Randy

MySQL Alpha Linux binary distribution: Core dumped on AlphaServer 1200

2001-12-12 Thread Ron Jamison
Hi, I'm trying to use the available MySQL Linux Alpha binary distribution on this AlphaServer: Linux jive.shadowtrance.com 2.4.9-12smp #1 SMP Tue Oct 30 17:54:45 EST 2001 alpha unknown Running RedHat 7.1 Alpha Deluxe, Using MySQL 3.23.46 from: http://prdownloads.sourceforge.net/mysql/mysql-

Re: LEFT JOIN trouble. Please help.

2001-12-12 Thread Aleksandar Bradaric
Hi, > I have two tables and I want create third one with LEFT JOIN > First table table1 containts field AA as a primary key (AA is NOT NULL). > Second table table2 containts field AA as a primary key (AA is NOT NULL) > too. > Ex: > CREATE TABLE a (PRIMARY KEY(AA)) > SELECT table1.AA FROM table2

Re: NOT NULL field accepting NULL

2001-12-12 Thread Paul DuBois
On Thu, Dec 13, 2001 at 09:50:11AM +0530, sreedhar wrote: > Hello, > > CREATE TABLE tblTEST(field1 VARCHAR(20) NOT NULL, field2 VARCHAR(20) NOT > NULL); > > INSERT INTO tblTEST (field1) VALUES (NULL); > INSERT INTO tblTEST (field2) VALUES (NULL); > INSERT INTO tblTEST (field1,field2) VALUES (NUL

MySQL determination of hostname?

2001-12-12 Thread Shon Stephens
How does MySQL determine hostnames when checking access permissions? I assume it uses whatever methods are available to the system (/etc/hosts, NIS, DNS, etc...). Will it use those services in the order they are listed in nsswitch.conf (Solaris)? What about for determining its local hostname?

Re: NOT NULL field accepting NULL

2001-12-12 Thread sreedhar
Hello, CREATE TABLE tblTEST(field1 VARCHAR(20) NOT NULL, field2 VARCHAR(20) NOT NULL); INSERT INTO tblTEST (field1) VALUES (NULL); INSERT INTO tblTEST (field2) VALUES (NULL); INSERT INTO tblTEST (field1,field2) VALUES (NULL,'HELLO'); not accepting NULL values; but INSERT INTO tblTEST (field1)

Browser caching problem OR mysql/perl code?

2001-12-12 Thread Jack A. Fobel
Hello, Coming from an ASP world, I'm trying to learn how to break the browser from caching. I am using variables and their values in the querystring to update a mysql database with perl. I am also re-querying the database to pull back the record. I was hoping to pull back the updated record but

Inches and Degrees

2001-12-12 Thread Jonathan Duncan
I am creating a database for a website that sells tools. Unfortunately they aren't measured in metric. Most of the measurements look something like: 1 1/16" 3/8" 3/16" 1 5/32" 45º 10º 2 7/16" These aren't pretty numbers to enter into a database. The simple way would be to enter them as CHAR's

JOIN and Table Full error

2001-12-12 Thread Mayo, Chuck
Hi all, I'm pretty new with MySQL and am trying to implement my first join. All works as expected until I try to order the output with an "order by" clause; select * from Players,Roster where Roster.playerId=Players.id order by Players.plast limit 1,10 and I receive an error from the MySQL in

Fw: mysql questions

2001-12-12 Thread Kelly
> Taken from an email from Mike(mickalo)Blezien <[EMAIL PROTECTED]> > > >If you use the 'skip-show-database' in the [mysqld] group in the my.cnf > file, > >this will give you the same results at start up > >[mysqld] > >skip-show-database > >This will then disable any user from viewing other databa

Fw: Each user have only see databases they have access too

2001-12-12 Thread Kelly
> I guess I gave up too quickly. Thanks for the info. :) > > Kelly > > - Original Message - > From: "Mike(mickalo)Blezien" <[EMAIL PROTECTED]> > To: "Kelly" <[EMAIL PROTECTED]> > Cc: <[EMAIL PROTECTED]> > Sent: Wednesday, December 12, 2001 7:35 PM > Subject: Re: Each user have only see da

Re: mysql questions

2001-12-12 Thread Kelly
Taken from an email from Mike(mickalo)Blezien <[EMAIL PROTECTED]> >If you use the 'skip-show-database' in the [mysqld] group in the my.cnf file, >this will give you the same results at start up >[mysqld] >skip-show-database >This will then disable any user from viewing other databases they do not

Re: Each user have only see databases they have access too

2001-12-12 Thread Kelly
I guess I gave up too quickly. Thanks for the info. :) Kelly - Original Message - From: "Mike(mickalo)Blezien" <[EMAIL PROTECTED]> To: "Kelly" <[EMAIL PROTECTED]> Cc: <[EMAIL PROTECTED]> Sent: Wednesday, December 12, 2001 7:35 PM Subject: Re: Each user have only see databases they have

Re: Each user have only see databases they have access too

2001-12-12 Thread Mike(mickalo)Blezien
Kelly, If you use the 'skip-show-database' in the [mysqld] group in the my.cnf file, this will give you the same results at start up [mysqld] skip-show-database This will then disable any user from viewing other databases they do not have access too. >On Wed, 12 Dec 2001 19:35:29 -0600, "Kell

Re: Each user have only see databases they have access too

2001-12-12 Thread Kelly
My apologies, I was writing that from work, without immediate access to a box running mysql. I tried it just now and have been having problems attempting to put it into a config file. So far, I've only been able to get it to work by passing --safe-show-database to the service as it starts. If/when

Re: Password encryption

2001-12-12 Thread sherzodR
When you're insering a new password: INSERT INTO user SET password=PASSWORD('secret'); But you can't retrieve the original password. If a user forgets/looses his/her password, just reset a password with something else, and send him/her that new password And when you want to check an inputted p

Re: 4 G table limit?

2001-12-12 Thread Tim Wood
> In the last episode (Dec 13), Tim Wood said: > > Does anyone out there know of any > > - future plans by the mysql development crew to increase table size > > limits by eg using their own custom filesystem type? > > You mean the MyISAM RAID table extension, or the Innodb tablespace > format?

Re: matching an option from SET list

2001-12-12 Thread Benjamin Pflugmann
Hi. On Wed, Dec 12, 2001 at 02:39:07PM +, [EMAIL PROTECTED] wrote: > Hello > > I've got a problem selecting values that match an option from a SET column. > > My two columns are set up as follows: > > res_places SET('North','West','South') > res_places_re SET('Aber

RE: No Database Encryption

2001-12-12 Thread Duncan Maitland
> It's only dangerous if a customer can trick your web frontend > into displaying the output of "SELECT * FROM USERS", for > example. If the frontend only uses hardcoded queries, or > quotes every user-supplied parameter, there's no problem. In > fact, you need the password in plaintext to s

Re: concurrent insert documentation clarification

2001-12-12 Thread Benjamin Pflugmann
Hi. On Wed, Dec 12, 2001 at 04:32:27AM -0700, [EMAIL PROTECTED] wrote: > The MySQL documentation says: > > "To ensure that the update log/binary log can be used to re-create the > original tables, MySQL will not allow concurrent inserts during INSERT > SELECT" > > Does this mean: Normally

Re: Password encryption

2001-12-12 Thread tc lewis
you can use the password() mysql function to crypt it. you cannot retrieve the encrypted password -- only compare input (password() the input) against the saved encrypted password. if the resulting text matches, the password is good. if not, the authentication in your application should fail.

Re: Mysql in NFS

2001-12-12 Thread js
As always with these things, horses for courses. In my situation, I have a mysql server mounted off a netapp, It is the backend for a website serving 10m+ page impressions per month. I wanted to put the data on a netapp for easy backup ( I can shutdown the server do a snapshot and bring it bac

Password encryption

2001-12-12 Thread ST Ooi
How can I encrypt password in database and how can I retrieve the encrypted password? Thanks ST Ooi Malaysia - Original Message - From: "Dan Nelson" <[EMAIL PROTECTED]> To: "James McLaughlin" <[EMAIL PROTECTED]> Cc: <[EMAIL PROTECTED]> Sent: Thursday, December 13, 2001 7:06 AM Subject:

Re: No Database Encryption

2001-12-12 Thread Doug Thompson
Yes. 1. Read the manual sections concerning setting up new accounts with special emphasis on passwords. 2. When you thoroughly understand those matters, take the issue to the system administrator and/or management. hth, Doug Only two things are infinite, the universe and human stupidity, an

Re: 4 G table limit?

2001-12-12 Thread Dan Nelson
In the last episode (Dec 13), Tim Wood said: > As mentioned above, I'm a lazy unit, so if possible would like to > avoid restructuring the DB to spread the document body table across > >1 table (thus enabling > 4 G of doc bodies), so am looking for some > easier way to do it (eg upgrading mysql, o

Re: Circular replication

2001-12-12 Thread David Turner
Just tell your boss that if you ever have turnover the former employee will be able to log into all the customers' accounts and do whatever he wants. Dave On Thu, Dec 13, 2001 at 03:29:41AM +1100, Duncan Maitland wrote: > My questions concern a setup where a public server is running at our > host

4 G table limit?

2001-12-12 Thread Tim Wood
Hi 3 months ago starting using mysql to archive a live news feed that our company is paying for. Being a lazy unit, I am putting all the document bodies into one table. After 3 months, that table has grown to 2G - so its a natural enough assumption to assume that in another 3, it will grow to

Re: No Database Encryption

2001-12-12 Thread Dan Nelson
In the last episode (Dec 12), James McLaughlin said: > The new programmer for our company is not using the dataType > "password" or any encryption what so ever for our user accounts > (accounts that our customers use for getting into our system) in our > database. > > Instead he is using the VarC

Re: No Database Encryption

2001-12-12 Thread tc lewis
it's not all that dangerous. it just means that you can read your users' passwords. anyone who can read that db table can become any of your users. password fields are just another safeguard against a "just in case someone gets read access to this" scenario. they also serve to provide more pr

RE: I must be mental but.

2001-12-12 Thread Mike Grabski
There shouldn't be a space after -p , also don't forget to put the user in there, unless you are using the default user (usually "root", although i've noticed on win32 it seems to be 'ODBC') ex: if your password is "test", the command would be mysqladmin -u -ptest newpassword By all means, cor

Why MySQL GUI download don't work?

2001-12-12 Thread Alex Shi
I tried to download MySQL GUI from these links: http://www.mysql.com/Downloads/mysqlgui/mysqlgui-win32-static-1.7.5-2.zip and http://www.mysql.com/Downloads/mysqlgui/mysqlgui-linux-static-1.7.5-1.tar.gz But all these don't work. Alex - Original Message - From: "Matthew Darcy" <[EMAIL P

check table

2001-12-12 Thread rc
is there a way to instruct check table to check all tables without listing each table in the sql statement? - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/

No Database Encryption

2001-12-12 Thread James McLaughlin
The new programmer for our company is not using the dataType "password" or any encryption what so ever for our user accounts (accounts that our customers use for getting into our system) in our database. Instead he is using the VarChar dataType. Can someone explain to me how I can exploit this

Re: Feature request

2001-12-12 Thread Sergei Golubchik
Hi! On Dec 12, Colin Faber wrote: > Hi, > > I've got a feature request which I don't think should be all that hard > to implement (if not already) > > With in the mysql fulltext search system if your search words exist in > more than 50% of the records; it is ignored. > > How about having mys

RE: I must be mental but.

2001-12-12 Thread Matthew Darcy
I compiled without problem mysql on Redhat linux 7.1 I have just started the sever using nohup /usr/local/mysql/libexec/mysqld & This started fine without problem. as I am used to using Oracle and new to mysql I decided to do an mysql_install_db which prompted me saying remember to change pas

MySQL / ODBC BLOB problems

2001-12-12 Thread P.Agenbag
HI I installed MyODBC on an NT server to connect via the internet to my Linux box that runs mysql3.23. I have already populated tables in a db that I am trying to link to the NT server via ODBC, but I am getting errors when trying to do this. The table is created with an id field ( BIGINT (255)

MySQL can not tell differences among some of the Chinese characters

2001-12-12 Thread Alex Shi
Hello, There's a problem with mysql query, which I would like to report to all of you. I'm not sure if it can be taken as a "bug" though. Suppose we have a very simple table with only three or four fields. Let's say the table is "employee", and one of the fields is "name" in varchar or char ty

Re: Problem with bk://work.mysql.com ?

2001-12-12 Thread Fournier Jocelyn [Presence-PC]
Hi, Take a look here : http://www.mysql.com/doc/I/n/Installing_source_tree.html Best Regards, Jocelyn Fournier - Original Message - From: "Alexander Skwar" <[EMAIL PROTECTED]> To: "Fournier Jocelyn [Presence-PC]" <[EMAIL PROTECTED]> Cc: <[EMAIL PROTECTED]> Sent: Wednesday, December 12,

Re: feature request: privileged connection quotas

2001-12-12 Thread Benjamin Pflugmann
Hi. MySQL already reserves one connection to users with the process privilege. So assure that common clients don't have the process privilege and you connect with one that has it and you are done. This is documented here (found no other place): http://www.mysql.com/doc/T/o/Too_many_connections.h

Feature request

2001-12-12 Thread Colin Faber
Hi, I've got a feature request which I don't think should be all that hard to implement (if not already) With in the mysql fulltext search system if your search words exist in more than 50% of the records; it is ignored. How about having mysql return either an error or set something that can b

Re: Problem with bk://work.mysql.com ?

2001-12-12 Thread Matt Wagner
Fournier Jocelyn [Presence-PC] writes: > Hi, > > When I try to do a "bk pull", I have the following unexpected message : > > >bk pull > bk://work.mysql.com:7001: No route to host > > What's wrong ? Hi, It should be fixed now. We were doing an internet connection upgrade (from 10mb to 100mb).

mysql log?

2001-12-12 Thread Takacs Istvan
Hi How can I set up our mysql server to write its logs into a log file? Thanks in advance! Regards Istvan - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.my

Re: Select with multiple records

2001-12-12 Thread DL Neil
Greg, > I have a MySQL database with a table (job_table) containing information > concerning jobs I run. Among the fields on the table are job_id > (varchar(10)), and timestamp (a timestamp). As I run jobs, I add an entry > to the table with the job_id, timestamp, and associated information, so

Bi-Directional Replications on MySQL

2001-12-12 Thread Pedro de la Lastra
Hello all, I'm moving from ASP to PHP & MSSQL to Mysql, but I have some doubt. It is possible in MySQL Bi-Directional Replications? If it's, then I need to find some documentation about it. Where can I find it? TIA Pedro --

lib error?

2001-12-12 Thread Takacs Istvan
Hi I'd like to compile the new PHP 4.1.0, but it always stops at the libmysqlclient.a with these error messages: /usr/lib/mysql/libmysqlclient.a(dbug.o): In function `_db_unlock_file': dbug.o(.text+0xaf4): multiple definition of `_db_unlock_file' /usr/lib/mysql/libmysqlclient.a(ctype-tis620.o)(

Re: High load problem with 3.23.45

2001-12-12 Thread Fournier Jocelyn [Presence-PC]
Hi, I have a similar load problem when I start MySQL-4.0 and there is high number of apache process requesting MySQL connection. I had to shutdown and restart apache otherwise the load often goes up to 200 and more (!!). (there are more than 250 visitors always connected to the server, so it gene

Maximum Entries MySQL Can Hande

2001-12-12 Thread Envex Developments
Hello there, Wondering if anyone could help with a problem. I'm upgrading a customer's server from a text based version of our program, to a MySQL based. There are 2 databases, DB1 and DB2, which contain 5 and 4 tables respectively. The upgrade script I am running simply adds information to 3

multiple select with single command.

2001-12-12 Thread Nissim Lugasy
Are there plans for mysql to have the capabilities to execute single sql statement with nested SELECT . or Is there a way around this for the time being? Thanks - Before posting, please check: http://www.mysql.com/manual

RE: Anti-SPAM (was: A News Group Perhaps)

2001-12-12 Thread Quentin Bennett
Hi, The TurboPower new groups (news://news.turbopower.com) seem to work fine, with little spam. Because they host the news groups themselves, there is no problem with them not being hosted by a particular ISP. It would be really nice to have a new group, but the ground has been covered so many t

Problem with ODBC and BLOB

2001-12-12 Thread P.Agenbag
HI I installed MyODBC on an NT server to connect via the internet to my Linux box that runs mysql3.23. I have already populated tables in a db that I am trying to link to the NT server via ODBC, but I am getting errors when trying to do this. The table is created with an id field ( BIGINT (255)

mysql questions

2001-12-12 Thread Cedric Tardif
Hi all, 2 littles questions. 1. How can i log all connection attempt to the mysql database without logging all the query in the mysql database ? 2. It is possible to prevent user to the 'show database' command, i know they can't use it depending on the right granted but it will be pleasent to

High load problem with 3.23.45

2001-12-12 Thread Arndt Jenssen
Maybe some coding/mysql master out there knows an answer to this tricky problem... We've recently migrated all our mysql servers from 3.23.42 to 3.23.45 without any problems except for one server. That linux server shows after startup of mysql after 1 or 2 minutes an exceptionally high load an

FW: Embedded Server Binary

2001-12-12 Thread sscroggin
> -Original Message- > From: Scroggin, Steve > Sent: Tuesday, December 11, 2001 8:47 AM > To: '[EMAIL PROTECTED]' > Cc: Firemon Support > Subject: Embedded Server Binary > > MySQL Representative: > > Your website states that downloading the binary is better than com

Re: Select with multiple records

2001-12-12 Thread rc
can't you select the latest timestamp? On Wed, 12 Dec 2001, Lindstrom Greg - glinds wrote: > Greetings- > > I have a MySQL database with a table (job_table) containing information > concerning jobs I run. Among the fields on the table are job_id > (varchar(10)), and timestamp (a timestamp). As

Re: Mysql in NFS

2001-12-12 Thread Shakeel Sorathia
For mysql, if your datafiles will not fit in ram, I would highly recommend not putting it on nfs. Mysql doesn't have any data caching, so every query will have to go thru the network to get the data. if, however, you do have enough ram on the machine to store all the datafiles in memory, the

matching an option from SET list

2001-12-12 Thread Wiliam Stephens
Hello I've got a problem selecting values that match an option from a SET column. My two columns are set up as follows: res_places SET('North','West','South') res_places_re SET('Aber','Cardiff','Bangor') And I'm currently using the following MySQL query: SELE

Re: find_in_set syntax

2001-12-12 Thread Wiliam Stephens
At 17:40 11/12/01, you wrote: >Can you provide your table description? > >You have two set colums? One called res_skills and one called >res_skills_ma ? Yeah, Both are SET columns. Wil - Before posting, please check: http:/

Re: Nested Inner Joins

2001-12-12 Thread Bob Hall
On Tue, Dec 11, 2001 at 07:34:11PM -0800, Kendra L Knudtzon wrote: > I am having problems with this nested inner join statement: > > SELECT tblMethodType.MethodType, tblMethodParm.MethodName, > tblParm.ParmName, tblParm.Label, tblParm.Value, tblParm.Unit, tblParm.Tip > FROM tblMethodType INNER JO

Select with multiple records

2001-12-12 Thread Lindstrom Greg - glinds
Greetings- I have a MySQL database with a table (job_table) containing information concerning jobs I run. Among the fields on the table are job_id (varchar(10)), and timestamp (a timestamp). As I run jobs, I add an entry to the table with the job_id, timestamp, and associated information, so the

tunning up my sql

2001-12-12 Thread Hernan Del Boca
Hello, im wondering if anybody can tell me how can i tune up my sql so that can run smoothly... if there is any packet i should install... i have a debian linux in a pentium 3 800 mhz with 256. thanks Hernan - Before posting,

Problem with bk://work.mysql.com ?

2001-12-12 Thread Fournier Jocelyn [Presence-PC]
Hi, When I try to do a "bk pull", I have the following unexpected message : >bk pull bk://work.mysql.com:7001: No route to host What's wrong ? Best Regards, Jocelyn Fournier Presence-PC - Before posting, please check: ht

Re: Question

2001-12-12 Thread Mysql List
How about going to the dir where the mysql database is then just cp * /backupsqldatabase And just the other way when you want to restore then use fix database. Thats what I have done and it seems to work fine. > Hi, > > I am quite new with MySQL and I have a question. How can I easily make a > c

RE: Mysql in NFS

2001-12-12 Thread Matthew Darcy
I have done oracle on NFS and it is not really the best option due to NFS locking. ie a poor network or if the NFS server drops, or the NIS/NIS+ (assuming you are using automount maps) dies this will hold your development/production up no end. Also oracle's table locking (not sure if mysql has th

my.cnf settings

2001-12-12 Thread Mike(mickalo)Blezien
Which group(s) would the following options be put under to enable in the my.cnf. safe_show_database skip_show_database Thx's mysql sql database Mike(mickalo)Blezien =-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-= Thunder Rain Internet Publishing Providing Internet Solutions that work! http://www.thu

Re: varchar to char in table with several varchar's

2001-12-12 Thread Paul DuBois
At 9:32 AM +0100 12/12/01, Willem Bison wrote: >I have a table with several columns of type 'varchar'. How can I change all >columns to fixed width char's ? Doing a 'alter' from varchar to char has no >effect since the column is changed back to varchar. You have to change them all at ones in the

Re: NOT NULL field accepting NULL

2001-12-12 Thread sherzodR
No, it's not accepting NULL if it was declared as NOT NULL. It's just accepting an empty sting ( "" ). CREATE TABLE test (t VARCHAR(10) NOT NULL); INSERT INTO test SET t = NULL; INSERT INTO test SET t = ''; First insert will tell you what you're waiting for. And the second one will do what you

Re: NOT NULL field accepting NULL

2001-12-12 Thread Paul DuBois
At 7:12 PM +0530 12/12/01, sreedhar wrote: >Hi All, > >In MySQL, Even i declared a field as NOT NULL it is accepting nulls .What >might be the >problem. please let me know. > >regards, >sreedhar That's not enough information. Let's see the CREATE TABLE statement, a sample INSERT statement, and t

Re: Circular replication

2001-12-12 Thread Brent Cowgill
even/odd is a little limiting, what happens down the road when another site needs to be added. A better method might be to use a unique session ID for each client site in combination with a generated sequence ID see the white paper at:http://www.ambysoft.com/persistenceLayer.html in particular

Re: Each user have only see databases they have access too

2001-12-12 Thread Mike(mickalo)Blezien
Which group(s) would this go under in the my.cnf ?? >On Wed, 12 Dec 2001 07:27:54 -0600, "Kelly Firkins" <[EMAIL PROTECTED]> >wrote: >>I believe that phpmyAdmin uses the "show databases" syntax to see what is >>available. To prevent it from seeing any db which the user is not >>authorized

RE: user permissions in linux

2001-12-12 Thread Rick Emery
Check out the GRANTS section in the MYSQL manual -Original Message- From: Faizal Mangera [mailto:[EMAIL PROTECTED]] Sent: Wednesday, December 12, 2001 9:38 AM To: [EMAIL PROTECTED] Subject: user permissions in linux Hi, I'm new to both MySQL and LINUX, however still managed to kind of

Mysql in NFS

2001-12-12 Thread Shen, Lei (CIT)
Hi! Dose anyone has a experience to building mysql database in network files system? and php? can you get me some information? thank you -Original Message- From: Marek Kustka [mailto:[EMAIL PROTECTED]] Sent: Wednesday, December 12, 2001 8:23 AM To: [EMAIL PROTECTED] Subject: Embedded MyS

Question

2001-12-12 Thread Ivo Dvorak
Hi, I am quite new with MySQL and I have a question. How can I easily make a copy of a mysql database locally stored on a server where I have all admin rights etc. I did not find such a utility/command in the standard MySQL manual nor in admin utilities I use. I use currently the mysqldump utili

NOT NULL field accepting NULL

2001-12-12 Thread sreedhar
Hi All, In MySQL, Even i declared a field as NOT NULL it is accepting nulls .What might be the problem. please let me know. regards, sreedhar - Before posting, please check: http://www.mysql.com/manual.php (the manual)

Re: changing allowed number of connections

2001-12-12 Thread William R. Mussatto
On Wed, 12 Dec 2001, Jari =?iso-8859-1?Q?M=E4kel=E4?= wrote: > Date: Wed, 12 Dec 2001 13:25:09 +0200 > From: Jari =?iso-8859-1?Q?M=E4kel=E4?= <[EMAIL PROTECTED]> > To: [EMAIL PROTECTED] > Subject: changing allowed number of connections > > Hi, > > Where one can alter the number of connections g

[OT] RE: ADV: Dear Future Millionaire: (very OT in a way)

2001-12-12 Thread Rick Emery
The problem is that you all are close-minded. Here, somebody as taken the time to offer you an opportunity to make millions from the internet, and you insult him. INGRATES...all of you...INGRATES I, for plan to avail myself of this fine opportunity. In a year, I'll be basking on the beaches o

To many processes, 100% CPU usage...HELP

2001-12-12 Thread Charlie Romero
We just upgraded a box (RH 7.2) to current Apache, PHP, and MySQL. We used the MySQL binary for 3.23.46. On the old box which was nearly identical we were running 3.23.43 (I think). The old box didn't have any problems w/ MySQL but this box is having problems. The only real thing that changed wa

Re: Anti-SPAM (was: A News Group Perhaps)

2001-12-12 Thread Thrill
On Wed, 2001-12-12 at 06:49, Carl Troein wrote: > Tony Buckley writes: >> I am not a great fan of Newsgroups - they get spammed too much and messages >> get lost or archived. Some ISPs carry them, some don't. All too hit and >> miss for a resource on which I rely and am very grateful for. > I

RE: [OT] A News Group Perhaps.

2001-12-12 Thread Christopher Schreiber
Actually I setup a vBulletin forum for MySQL over at www.mysqlforums.com and I am the moderator of the MySQL and Server Configuration forums over at www.vbulletin.com/forum/ I've been keeping an archive of the mailing lists, mainly for my own purposes to search through old questions and answers f

Re: connecting to mysql from different computer

2001-12-12 Thread Rodney Broom
Good morning Kamal, From: <[EMAIL PROTECTED]> > More so will i need to open MySQL server on my local machine before running > MySQL client to connect to the remote machine e.g. No. The service (mysqld) is strictly assigned to managing the local database(s) and to serve access to those databas

Re: Each user have only see databases they have access too

2001-12-12 Thread Kelly Firkins
I believe that phpmyAdmin uses the "show databases" syntax to see what is available. To prevent it from seeing any db which the user is not authorized, set the safe_show_database = 1 in the my.ini file (or my.cnf). This will prevent show databases from returning a list of all dbs available. ke

user permissions in linux

2001-12-12 Thread Faizal Mangera
Hi, I'm new to both MySQL and LINUX, however still managed to kind of get them up and running. I installed MySQL whilst I was logged in as ROOT. Now I can only run it when I log is as ROOT. How do change permissions of the other users so they can also run MySQL or create a new user which will

Re: [OT] A News Group Perhaps.

2001-12-12 Thread Etienne Marcotte
Well that's called a forum and it's not at all like a mailing list :-) But yes there could be a forum, but there are already some on the net www.devshed.com have a mySQL part and a Perl part and a PHP part. Plus a forum requires servers, space, web hosting, DNS, maintenance, moderation, programmi

Re: find_in_set syntax

2001-12-12 Thread Etienne Marcotte
mysql> create table gd_records( -> id int unsigned auto_increment, -> res_skills set("skills1","skills2","skills3","skills4","skills5","skills6"), -> res_skills_ma set("skills_ma1","skills_ma2","skills_ma3","skills_ma4","skills_ma5","skills_ma6"), -> primary key(id)); Query OK, 0 r

Re: Default 1 == Default 16777216?

2001-12-12 Thread Philip Molter
On Wed, Dec 12, 2001 at 02:35:15PM +0200, Sinisa Milivojevic wrote: : Philip Molter writes: : > >Description: : > : > When I do this: : > : > mysql>create table test_default ( testint int not null default 1 ); : > mysql>desc test_default; : > : > I get: : > : > +-+-+-

Circular replication

2001-12-12 Thread Duncan Maitland
My questions concern a setup where a public server is running at our hosting company and a local office server is behind a firewall (connected to the net via a somewhat unreliable ADSL). The servers are configured in a circular master-slave relationship but only a limited number of tables in the

I must be mental but.

2001-12-12 Thread Matthew Darcy
I compiled without problem mysql on Redhat linux 7.1 I have just started the sever using nohup /usr/local/mysql/libexec/mysqld & This started fine without problem. as I am used to using Oracle and new to mysql I decided to do an mysql_install_db which prompted me saying remember to change pass

Re: Embedded MySQL server && the outside world

2001-12-12 Thread Sinisa Milivojevic
Marek Kustka writes: > Hi folks, > > does embedded server tcp-listen to the outside world i.e. it could > be used by another app or perhaps been accessed by the same app > using ODBC? > Nope. > OR > > is MySQL C API the only way to control it? > Yes, so far. But other API's could be built o

Re: How to create clients option file !!!

2001-12-12 Thread Sinisa Milivojevic
[EMAIL PROTECTED] writes: > Compliments, > > I was able to uccessful install MySQLGUI version 1.75 on my win 98 running > MySQL server 3.23.43 -max-debug client version 3.23.3 alpha. > > I was also able to connect to the server. At the bottom of the window I saw > one button with plus sign, when

How to create clients option file !!!

2001-12-12 Thread Hamzat Kamal
Compliments, I was able to uccessful install MySQLGUI version 1.75 on my win 98 running MySQL server 3.23.43 -max-debug client version 3.23.3 alpha. I was also able to connect to the server. At the bottom of the window I saw one button with plus sign, when I do mouse over on it there is this p

Re: [OT] A News Group Perhaps.

2001-12-12 Thread Kelly Firkins
I would vote in favor of using vbulletin (www.vbulletin.com) it's got forums for talk like this, web-based, and runs off of the MySQL server as a back-end. An example in action is vbulletin itself or community.installshield.com. Very slick indeed. Kelly FYI, I'm somewhat biased in favor of it

Embedded MySQL server && the outside world

2001-12-12 Thread Marek Kustka
Hi folks, does embedded server tcp-listen to the outside world i.e. it could be used by another app or perhaps been accessed by the same app using ODBC? OR is MySQL C API the only way to control it? Thanks, Marek - Before po

Re: ADV: Dear Future Millionaire: (very OT in a way)

2001-12-12 Thread Carl Troein
Etienne Marcotte writes: > How come this passed the spam filter? > > Which word it had that was on the "mandatory words" list ? EEek! Noo... but that can't be.. or...? Is the whole thing about the MySQL database just a hoax to get people to subscribe to this list so that the people at MySQ

Re: ADV: Dear Future Millionaire:

2001-12-12 Thread Etienne Marcotte
How come this passed the spam filter? Which word it had that was on the "mandatory words" list ? There is no sql, query, database in the text... Etienne Bege John wrote: > > I'll make you a promise. READ THIS E-MAIL TO THE END! - follow what it says to the >letter and you will not worry whe

LEFT JOIN trouble. Please help.

2001-12-12 Thread Ján Fedorek
Hi, I've got this problem: I have two tables and I want create third one with LEFT JOIN First table table1 containts field AA as a primary key (AA is NOT NULL). Second table table2 containts field AA as a primary key (AA is NOT NULL) too. Ex: CREATE TABLE a (PRIMARY KEY(AA)) SELECT table1.AA F

Re: [OT] A News Group Perhaps.

2001-12-12 Thread Etienne Marcotte
also screen what you don't need. I delete everything regarding installation. I don't have solaris and I don't have red hat so 80% of the install questions I can't help. You can set up pretty complex sorting rules. It might take a couple of weeks to set up, but once it's done you should receive on

  1   2   >