Re: Telnet and ftp problem

Joseph Bueno wrote: > > Your problem seems very strange ! Yes it seems... > How do you start and stop mysql ? With the standard SuSE startup script /sbin/init.d/mysql MySQL is running on port 3306 > BTW, on which OS are you running ? SuSE Linux 6.4 I must add that the telnetd daemon reports

RE: why does it not work

On Mon, 21 May 2001, indrek siitan wrote: > order by rand() didn't work back in 3.22. > > if i remember correctly (if this doesn't work, you can try to search > the list archives), the workaround was: > > SELECT col1,col2,RAND() as r FROM table ORDER BY r LIMIT 1; Thanks. Now I am into anoth

Re: MYSQL performance question

I'm currently running MySQL with tables that contain ~10 million rows. Each row has 50 columns and the table has 27 indexes. The data size of what you're describing doesn't seem so big. There are some arithmatics in the MySQL manual on how much disk space is used per row. If the tables you hav

Re: AIX segmentation fault with PHP, Apache and MySQL

Thanks everyone - it now all goes ! The problem I think was due to using a precompiled binary release of Apache that (I guess) had an exports file pointing to a library in the wrong place... Anyway building everything from sources did the job. Dave At 23:36 20/05/01 -0400, you wrote: >Hmm.

mysqld got signal 11;

Hi, I am running mysql 3.23.33 getting this error about once a day causeing mysql to restart mysqld got signal 11; The manual section 'Debugging a MySQL server' tells yo

Re: MYSQL performance question

limitation about space and speed according to DBMS featuring. since MySQL still have not full SQL 92 feature (transaction, sub select... I think) make it eat a fewer space than other DBMS (oracle or informix) and it can speed up because it did not need to handle more condition. I did not know

Re: Win32 installation problem...

Here is a link that I used to install MySQL on my machine running Win98 http://www.net-language.com/workshops/Default.asp?workshop=21 NOBBY - Original Message - From: "Jason Rackley" <[EMAIL PROTECTED]> To: <[EMAIL PROTECTED]> Sent: Monday, May 21, 2001 6:13 PM Subject: Win32 installat

Table appearing in multiple databases

Is it possible to place the same table in multiple databases, by linking the MYD file from one database to the next? I can see obvious problems with such a technique, so I thought I'd ask here. Thanks, -- Scott F. Crosby E-Mail : [EMAIL PROTECTED] Web : http://www.skroz.net "It's some kind o

Re: mysql crash continued

Hello, I am running MySQL (3.23.xx) on Linux RedHat 6.2 and plan to increase volume of data in the near future. So, I would like to know some db schema , total row and your SQL you used to protect my database. Sommai Fongnamthip At 20:56 21/5/2001 +0300, Sinisa Milivojevic wrote: >Ru

Odd table view

Using Windoze version, latest build. My table has three fields two VCHAR and one BLOB. After inserting into the table two names and two bmp files into the blobs, worked nice thanks to the help I got from here, my table looks like this -

Re: key_reads and opened_tables.

Larry Hotchkiss wrote: > > In the manual, it states "if Key_reads is big, then your key_cahce is > probably too small."so what exactly is BIG??? > Its all about ratios, you just want a hit cache hit, so that your read_requests are a lot larger than your actual reads. | Key_read_

Auto Increment

Dear All I am inputting data into a MySQL database where i have set the primary key as the ID and it is auto-incrementing. I make sure that my input file contains a null or 0 value where it should be auto- incrementing. While entering data using LOAD command, my input file had an error with t

Re: my sql and memory--A confusing issue for a newbie

VVM Ravikumar Sarma Chengalvala wrote: > > Hi, > 1. > How much memory does mysql allocate by default to a > database?Any default table wise memory limitations as > well? Its doesn't allocated very much by default ( < 10M ? ), and there is no per table memory allocation. > 2. > Is mysql's memor

Re: copy from one db's table to another

Jeff Shipman - SysProg wrote: > > I have two databases that have identical table > structures. I would like to copy all data from > the 'tickets' and 'notes' in one db to the > 'tickets' and 'notes' field in the other. How > could I do this? > You could try the lock/flush strategies employed by

Re: Fastest query ?

Jocelyn Fournier wrote: > > Hi, > > I wonder which of the following queries is faster : > > $result=mysql_query("SELECT lastauteur FROM forum ORDER BY date DESC LIMIT 1"); > > or : > > $max=mysql_query("SELECT max(date) FROM forum"); > list($max)=mysql_fetch_row($max); > $result=mysql_query("

Re: MYSQL performance question

Shane Anderson wrote: > > I would like to know the limitations of Mysql with extremely large tables. I > need to store 20+ million records. Each record would contain only 4-6 fields > and would not be longer than 128 bytes of information. The records could be > divided among several tables, but a

Re: Telnet into MySQL

Okok, my bad!! What I meant to say was that I needed a Telnet program with SSH so that I could log into the shell of my web hosting provider and thereby access MySQL from shell. At 05:46 PM 5/21/2001 -0500, you wrote: >At 4:04 PM -0600 5/21/01, <[EMAIL PROTECTED]> wrote: >>Any good ones for

unaunthenticated user?

Hi~~~ My SHOW PROCESSLIST's output | 22 | unauthenticated user | 10.169.xxx.xxx || Connect | | login | what 'unauthenticated user' means? who is he? anonymous user? Thank you for your advanced answer! database --MIME Multi-part separator--

secure connection (SSL/SSH tunneling) with windows client

Hi, I know this has been discussed a lot. I did read the mail archive and found lots of interesting info. Although I have a problem. We're developing a windows software that has to exchange sensitive data with a mySQL server. I read about implementing a SSH tunnel. It works well, although I h

Re: Telnet into MySQL

Before you listen to anyone else (and spend any money on a commercial SSH client) download and try "PuttySSH", which is a free 'telnet like' SSH client (it WILL do straight telnet if you want it to) that works fabulously (at least for me at home and work for the past year). You can also downloa

sql to select 2 entries/name?

Hello list, I have a table in a database that has a field named 'artist'. There are multiple entries of the same artist/band. Example: deftones iggy pop kiss deftones glassjaw deftones kiss new found glory kiss There's 3 entries for deftones and 4 entries for kiss. What I need to do is selec

Re: count(*) on different tables

As far as I know, they should be the same. The only case in which I can see count(colname) would be slower is if it doesnt count rows that contain null values for that column (this is only a guess, I dont know if count does that or not). ryan > Would count(*) show the same performance as count(1

Re: Telnet into MySQL

Take a look at the posts from Paul and others... You can't connect directly to MySQL using telnet without knowning the MySQL communication protocol... There are many MySQL client programs -- a good one for Windows is urSQL available from http://www.urbanresearch.com/ursql You might also want to

Re: Telnet into MySQL

Ahh come on.. I want to make things difficult Normaly I never think about Telnet but for Fun on a borring Monday I decided hmmm let's play. If I do any thing it normaly through an ASTA Server and Client. Cool stuff. Cheers -Original Message- FROM: Paul DuBois TO: [EMAIL PROTECTED],

My sql and myISAM

Hi, Do someone have answers to these questions: 1. Maximum table size myISAM type tabes can handle? 2. Default maximum database size for a particular database. Your help will be highly appreciated. Regards, Ravi Do You Yahoo!? Get you

Re: Telnet into MySQL

At 4:04 PM -0600 5/21/01, <[EMAIL PROTECTED]> wrote: >Any good ones for the Windozes version..When I use just regular ol >Telnet I get Smiley and clovers and hearts and the version. That's exactly why you don't Telnet to the MySQL server. You're seeing information that's part of the binary clie

Re: Telnet into MySQL

I vote for VanDyke's CRT as well -- lots of features and ~ $30 (US) for the license. - Original Message - From: <[EMAIL PROTECTED]> To: <[EMAIL PROTECTED]> Sent: Monday, May 21, 2001 3:04 PM Subject: Re: Telnet into MySQL > > Any good ones for the Windozes version..When I use just regul

Re: Telnet into MySQL

hahah Check out SecureCRT it's a wonderful product and well worth the price. [EMAIL PROTECTED] wrote: > > Any good ones for the Windozes version..When I use just regular ol Telnet I get >Smiley and clovers and hearts and the version. > > Cheers > > -Original Message- > FROM: Eric Fi

Re: count(*) on different tables

That's really cool Thanks siomara >From: "Eric Fitzgerald" <[EMAIL PROTECTED]> >To: "Siomara Pantarotto" <[EMAIL PROTECTED]>, <[EMAIL PROTECTED]> >Subject: Re: count(*) on different tables >Date: Mon, 21 May 2001 14:08:00 -0700 > >Well, let's do a test: > >mysql> CREATE TABLE testcount (produc

RE: Compute SQL Function Not Supported

In your original message, you said "You will get a summary of prices by type in your results." and that is what my query gives you. It returns the sum of the price columns from any rows that are eliminated by the GROUP BY clause. What do you want it to return? > Please strike previous message the

Re[2]: Telnet into MySQL

Hello Eric, Tuesday, May 22, 2001, 12:23:24 AM, you wrote: EF> I really prefer SecureCRT from VanDyke software myself. Perfect blend of EF> features and simplicity for my needs. It has a shareware version that does EF> expire, but the license is cheap for it. Go to www.vandyke.com and downloa

Re: Telnet into MySQL

Any good ones for the Windozes version..When I use just regular ol Telnet I get Smiley and clovers and hearts and the version. Cheers -Original Message- FROM: Eric Fitzgerald TO: Angerer, Chad, 'Tim Thorburn', [EMAIL PROTECTED] DATE: Mon 5/21/01 15:58 SUBJECT: Re: Telnet into MySQL I

Re: Telnet into MySQL

At 3:21 PM -0500 5/21/01, Tim Thorburn wrote: >Hello, > >Can someone here recommend a good Telnet program (with SSH) that I >can use to connect to my servers MySQL database? > >Preferably something shareware/freeware - but if it must be >purchased, I'm not against that. > >Thank you > >-Tim Unl

Re: Telnet into MySQL

On Mon, May 21, 2001 at 05:13:44PM -0400, Peter L. Berghold wrote: > On Mon, May 21, 2001 at 03:21:10PM -0500, Tim Thorburn spake thusly: > *] Can someone here recommend a good Telnet program (with SSH) that I can use > *] to connect to my servers MySQL database? > *] Seeing your mailclient (X-

Re: Telnet into MySQL

I really prefer SecureCRT from VanDyke software myself. Perfect blend of features and simplicity for my needs. It has a shareware version that does expire, but the license is cheap for it. Go to www.vandyke.com and download the shareware version to give it a try. - Original Message - Fr

About MyODBC Some Common Errors

In ODBC documents some common error section is says - If you are connecting to a server with a character set that isn't compiled into the MySQL client library (the defaults are: latin1 big5 czech euc_kr gb2312 gbk sjis tis620 ujis ) then you need to install the mysql character definitions fr

RE: Telnet into MySQL

Tera Term Pro -Original Message- From: Tim Thorburn [mailto:[EMAIL PROTECTED]] Sent: Monday, May 21, 2001 1:21 PM To: [EMAIL PROTECTED] Subject: Telnet into MySQL Hello, Can someone here recommend a good Telnet program (with SSH) that I can use to connect to my servers MySQL database?

Re: Telnet into MySQL

On Mon, May 21, 2001 at 03:21:10PM -0500, Tim Thorburn spake thusly: *] Can someone here recommend a good Telnet program (with SSH) that I can use *] to connect to my servers MySQL database? *] Tim, You don't use telnet to connect to the MySQL database... You use the mysql client -- -+-+

Re: count(*) on different tables

Well, let's do a test: mysql> CREATE TABLE testcount (product INT NOT NULL AUTO_INCREMENT PRIMARY KEY, description VARCHAR(50)); Query OK, 0 rows affected (0.00 sec) **Ran perl script here to populate the table** mysql> SELECT * FROM testcount LIMIT 10; +-+---+ | product | de

Re: Telnet into MySQL

CRT (www.vandyke.com) Tim Thorburn wrote: > Hello, > > Can someone here recommend a good Telnet program (with SSH) that I can use > to connect to my servers MySQL database? > > Preferably something shareware/freeware - but if it must be purchased, I'm > not against that. > > Thank you > > -Tim >

RE: Telnet into MySQL

go to www.ssh.com .. I beleieve there a few nice clients there. Chad -Original Message- From: Tim Thorburn [mailto:[EMAIL PROTECTED]] Sent: Monday, May 21, 2001 3:21 PM To: [EMAIL PROTECTED] Subject: Telnet into MySQL Hello, Can someone here recommend a good Telnet program (with SSH)

Re: count(*) on different tables

Cool but how about if you put a where clause to your select?? SQL> select count(1) from product where productid >3; COUNT(1) -- 7 Would count(*) show the same performance as count(1)??? Siomara >From: "Eric Fitzgerald" <[EMAIL PROTECTED]> >To: "Siomara Pantarotto" <[E

Telnet into MySQL

Hello, Can someone here recommend a good Telnet program (with SSH) that I can use to connect to my servers MySQL database? Preferably something shareware/freeware - but if it must be purchased, I'm not against that. Thank you -Tim ---

Re: Problems with MySQL and Poweredge 6450..

On Monday 21 May 2001 13:50, Cody Swanson wrote: > Hey, > > We just got a new Dell Poweredge 6450 preloaded with redhat 6.2. Our intention > is to move the database off a smaller machine and load it into this one. We > currently have MySQL 3.23.38 using the innobase driver on redhat 6.2 wi

RE: Compute SQL Function Not Supported

Please strike previous message the query should be: SELECT location, date, type, price, FROM products ORDER BY location, date, type Group By location, date, type COMPUTE SUM(price) -Original Message- From: Brandon Lewis [mailto:[EMAIL PROTECTED]] Sent: Monday, May 21, 2001 2:14 PM To: Ch

Re: MYSQL and the Macintosh

Hmm. One way might be to use MacPerl to generate tab delimited files that you could then use to create an Excel document, then mail merge into your Word doc. I could have sworn that there was some kind of ODBC setup with Mac Office, though.. Z On Monday, May 21, 2001, at 02:17 AM, Ray Smith

Change port #

my ISP firewall dosen't allow access to port 3306. How can I change this port assignment? I saw this in the doc but I couldn't find the my.ini file. What affect other than remote access will changing the port have? I need to change it to port 21, or something. mysql -

RE: Compute SQL Function Not Supported

Okay I may have been a bit vague on my description. SELECT location, date, type, price, FROM products ORDER BY location, type, date Group By location, type COMPUTE SUM(price) Is there something similar for compute? -Original Message- From: Chris Bolt [mailto:[EMAIL PROTECTED]] Sent: Mo

Re: count(*) on different tables

Actually, as far as performance goes, it depends on table types. Most of the MySQL table handlers keep an internal count of record numbers. Thus, a select count(*) from table; is as fast as it gets. - Original Message - From: "Siomara Pantarotto" <[EMAIL PROTECTED]> To: <[EMAIL PROTECTE

Problems with MySQL and Poweredge 6450..

Hey, We just got a new Dell Poweredge 6450 preloaded with redhat 6.2. Our intention is to move the database off a smaller machine and load it into this one. We currently have MySQL 3.23.38 using the innobase driver on redhat 6.2 with kernel 2.4.4. This is on a dual PIII650 with 1 gig of r

MYSQL performance question

I would like to know the limitations of Mysql with extremely large tables. I need to store 20+ million records. Each record would contain only 4-6 fields and would not be longer than 128 bytes of information. The records could be divided among several tables, but at what size is the performance hi

Re: count(*) on different tables

Well ... I don't know enough about mysql but it must allow you somehow to specify the column by number as in Oracle and other DBs SQL> select count(*) from product; COUNT(*) -- 10 SQL> select count(1) from product; COUNT(1) -- 10 Once you just want to cou

Re: C API; queries within functions.

> Any pointers on where to look? That line says it all really. Your initiallizing connection as a pointer (denoted by *), you have to treat it accordingly when passing it to functions. Your function init would look something like this: MYSQL_RES doquery (MYSQL *connection, char query[100]) {

RE: CPU usage running mysql

> -Original Message- > From: David Allen [mailto:[EMAIL PROTECTED]] > Sent: lunes, 21 de mayo de 2001 14:36 > To: Simon Green; [EMAIL PROTECTED] > Subject: Re: CPU usage running mysql > > > Hello again! > > Do you know if there is any way I can see what the mysqld is > doing? If it is

RE: Compute SQL Function Not Supported

SELECT type, sum(price) FROM products GROUP BY type ORDER BY type > I take it the Computer SQL Function is not support by MySQL and if not is > there a substitute for it? > > If you are unfamiliar with the command it works like this: > > SELECT type, price > FROM products > ORDER BY type > COMP

Re: count(*) on different tables

If you are using PHP (or anothe controlling language, you could take the results of SHOW TABLES and loop through it either doing a single select for each table or building a select statement that UNIONs the results together. i.e. Select 'Table1' as tableName, count(*) as rowCount from table1 UNI

Fastest query ?

Hi, I wonder which of the following queries is faster : $result=mysql_query("SELECT lastauteur FROM forum ORDER BY date DESC LIMIT 1"); or : $max=mysql_query("SELECT max(date) FROM forum"); list($max)=mysql_fetch_row($max); $result=mysql_query("SELECT lastauteur FROM forum WHERE date='max'");

copy from one db's table to another

I have two databases that have identical table structures. I would like to copy all data from the 'tickets' and 'notes' in one db to the 'tickets' and 'notes' field in the other. How could I do this? Thanks, Jeff Shipman E-Mail: [EMAIL PROTECTED] Systems Programmer Phone: (505) 835

set options (not at safe_mysqld at startup)

Hello All, Is there some way, when mysql server is running, to change an option? I want to change skip_networking to OFF without doing a server restart. Thanks, Brian

my sql and memory--A confusing issue for a newbie

Hi, 1. How much memory does mysql allocate by default to a database?Any default table wise memory limitations as well? 2. Is mysql's memory management and Oracle's memory management similar?Or altogeather different? Regards, Ravi Do Yo

Compute SQL Function Not Supported

I take it the Computer SQL Function is not support by MySQL and if not is there a substitute for it? If you are unfamiliar with the command it works like this: SELECT type, price FROM products ORDER BY type COMPUTE SUM(price) You will get a summary of prices by type in your results.

C API; queries within functions.

Hi! This is probably more of a C inadequacy than a MySQL problem. I'm playing around with C with MySQL (I have to date only interfaced with it in PHP) and I was curious if anyone had any example code which illustrates how you would write functions which return mysql data. For example, in PHP I

Re: Results came from

Eric, I'm using php. The problem is that the "where" may have 100 or so conditions. I was hoping that mysql had some built in function or variable that would return this for me. I guess I'll have to code it in php.. argh. Eric Fitzgerald wrote: > What language are you using to prepare that que

count(*) on different tables

Hi, is it possible to get *one* quick result with the rowcount of each table in one database, without knowing the column-names? this does *not* work: select count(t1.*), count(t2.*) from table1 t1, table2 t2 Manual doesn't say anything about that. Greetings, Ansgar Becker

Re: Results came from

What language are you using to prepare that query? If it's perl, do something like if ($title =~ /Green/) If it's php, do something like if (ereg("Green",$title)) If it's C, cycle the string finding that This is a job for the client truthfully...but if you absolutly MUST do this server side, her

Remote access to MySQL with MySQLGUI on Win32

I am trying to see if I can communicate with a MySQL on Free BSD from the MySQL GUI client on my Windows NT. The GUI client cannot connect because the MySQL seems to be refusing this connection. This does not seem to be server-related, but related to MySQL itself, since, when I try to telnet in p

key_reads and opened_tables.

In the manual, it states "if Key_reads is big, then your key_cahce is probably too small."so what exactly is BIG??? Same thing for opened_tables, it states "if opened_tables is big then your then your table_cache variable is probably too small". Can someone please define BI

question about replication under version 3.23.38 for Unix (database)

HI, everyone, I met a problem about setting up replication(master/slave) of mysql sever on unix boxes. Mysql servers are installed under "/usr/local/" on master and slave and they can be run under "/usr/local/mysql/bin". It seems to me that I have three choices where to put my configuration f

Re: users and passwords...users and passwords...

/mysql/bin/mysql_setpermission can also be handy but if you do stuff manually don't forget to do a /mysql/bin/mysqladmin flush-privileges a bit of manual reading probably wouldn't go amiss either :-) On Monday 07 May 2001 07:54, Daniel Goldin \(E-mail\) wrote: > I've had similiat

Re: Results came from

> Is there anyway to determine which part of the an sql query where blahblah produced the result? ie. select Title from inv where Title LIKE '%Green' OR Title Like '%Blue%' I need to distinguish if the Title was like Green or Blue.. -

Re: mysql crash continued

Rui Barreiros writes: > > hi, > > i've upgraded mysql server with 3.23.38 from mysql, and i have the same > behaviour sinisa if you have some time i could give you access to one of the > machines. :/ > > -- > WEBSOLUT - Soluções Internet > Emailto: [EMAIL PROTECTED] > Personal Info: http://

mysql crash continued

hi, i've upgraded mysql server with 3.23.38 from mysql, and i have the same behaviour sinisa if you have some time i could give you access to one of the machines. :/ -- WEBSOLUT - Soluções Internet Emailto: [EMAIL PROTECTED] Personal Info: http://websolut.net/people/rui.html As informações

Re: table corruption during large import.

Do you 'refresh' your tables before each test ? If so, is it possible that you're writing over the same disk space each time (which would point to a drive surface problem). Is it possible that the larger runs of 'inserts' are using more RAM than the smaller tests, and you're hitting a bad memo

Re: which db server

Can you give more info on what type of system this is ?? Is this really a 'server' type machine, or an HP "Vectra" PC ?? (of the 'XU' series ?) Does it have the onboard SCSI controller (what size drives, and are they SCSI drives ?) - If they're SCSI, you might want to get 4 drives, and m

table corruption during large import.

I am having a heck of a time here. Im running RH 7.0 kernel 2.2.16 on a PII 300, 128meg RAM. Mysql 2.23.32, php 4.04. I have a DB set up that has 4 tables. 3 of the four only have a couple thousand records, but one table will have somewhere between 80k to maybe as many as a million reco

RE: The Syntax to Get JDBC Connection

I usually create a txt file like the following (I used Oracle but you can change to mysql stuffs): jdbc.driver=oracle.jdbc.driver.OracleDriver jdbc.driverType=jdbc:oracle:thin:@ jdbc.host=prokids jdbc.port=1521 jdbc.sid=orcl jdbc.username=scott jdbc.password=tiger Then I have a manager class (

RE: my sql database and locking issues(URGENT)

> 2. > The following is the extract from mysql documentation: > " > In MySQL Version 3.23.7 and above, you can insert rows > into MyISAM tables at the same time other threads are > reading from the table. Note that currently this only > works if there are no holes after deleted rows in the > table

Re: Installing mysql on another directory than c: with windows

Well... I installed mysql in my D: drive (at home) and it works perfectly. I set in the control panel/services to have mysql started automatically when the server is started. When I want to access it direct I just go to D:\Program Files\mysql\bin and type mysql. Yesterday I tested a cgi scrip

my sql database and locking issues(URGENT)

Hi, 1. Does mysql inherently implement locking implicitly? 2. The following is the extract from mysql documentation: " In MySQL Version 3.23.7 and above, you can insert rows into MyISAM tables at the same time other threads are reading from the table. Note that currently this only works if there a

Re: cobalt binary version

> "a" == archive writes: a> any binary version for cobalt qube2 (mips processor) ?? a> have mysql ever tested install at cobalt qube/raq ?? a> how is it done? There used to be a version on the cobalt ftp site in the contrib area. Don't know what's there now, since they seem to be ignoring

Re: Telnet and ftp problem

Rodolfo Baselli wrote: > > Gerald Clark wrote: > > > > You don't use telnet or ftp to connect to the MySQL server. > > You use the client "mysql". > > Yes, I know, I probably mispelled the problem. > Now, I can't telnet the telnet service and ftp the ftp service running > on the MySQL server whe

My Sql and default installation

Hi, I have installed mysql on WIN NT4.0.By default ,will mysql use ISAM as the default? When to opt for BDB? Regards, Ravi Do You Yahoo!? Get your free @yahoo.co.uk address at http://mail.yahoo.co.uk or your free @yahoo.ie address at h

Out of memroy (no more, sorry)

Bonjour, Sorry for the previous email. I had to check more. I had a program of mine eating more than a giga of ram on the server :o( so no problem with Mysql this time :o) Regards, Alex. - Before posting, please c

Out of memroy

Bonjour, Solaris 2.8 on SPARC 4x64bit processor . Mysql-3.23.37 with InnoDB What I was doing : I was altering a lot of table, converting them from InnoDB to MyISAM type (I don't know if this is the cause of my problem ...) Now, on the console here is what happens : [4:52pm]# my

C-API and LOAD DATA

Hi, everybody: I have received no answer to my question and I suppose it is because no one has faced this problem before. Could anyone of you check this benchmark and tell me wether it also occurs in your environment or not? That could help me when looking for the possible

DB access privaleges

I'm trying to make my mysql a little more secure by restricting certain users to certain databases. Looking at the manual, it appears I do what I need to do via the mysql:db table. I was told by several people that mysql:db should contain a list of all databases in mysql... the problem is tha

Re: How to retrieve record-id after 'insert into'?

On Mon, May 21, 2001 at 03:58:10PM +0200, Viktor van den Berg wrote: > > Hi! > > I like to know how to retrieve the record id after an "insert into" query. > I have the table "user" containing two columns: UID (auto_increment) and > USERNAME. After I have added a new user (using "insert into u

Problem with OBDC

is there anyone who can help me with my problem i posted a earlier? i know i shouldn't post this kind of requests, but i REALLY need help. i am on a deadline and having major problems exporting tables from access 2000 to mysql. please help

(solution) RE: mysql start failed.

It runs now. I tried many things, so I'm not sure of what I did in order to make it run, but I think these things where important - always be sure that /var/lib/mysql is 'chowned -R mysql:mysql' - run mysql_install_db to install base tables properly - start manually mysql with : 'safe_mysqld --def

How to retrieve record-id after 'insert into'?

Hi! I like to know how to retrieve the record id after an "insert into" query. I have the table "user" containing two columns: UID (auto_increment) and USERNAME. After I have added a new user (using "insert into user (uid) etc.) I like to know the UID of the new record. I can set the rec

still socket prob.

Read and tried : Does 'ps' or 'pstree' show a mysqld or safe_mysqld process running? If not, have you actually started the MySQL server? I believe you have to run 'mysql.server start' or something similar, though my memories of running MySQL under Linux are somewh

Re: I have a question

>I installed recent version of mySQL,myODBC,PHP on my W2000 machine >yesterday >I can not access to an access file via ODBC >It gives me Warning: SQL error: [Microsoft][ODBC Microsoft Access >Driver] The Microsoft Jet database engine cannot open the file >'(unknown)'. It is already opened exclus

Re: listen to specific address

On Mon, May 21, 2001 at 09:09:29PM +0800, Mark Lo wrote: > > I would like to know how to tell mysql to listen to specific foreign > address. I know I can use --bind-address to tell mysql to listen to > specific local address. But I need mysql to listen to specific foreign > address. HOW TO

RE: mysql start failed.

> -Original Message- > From: Chris Freeman [SMTP:[EMAIL PROTECTED]] > Sent: Monday, May 21, 2001 2:29 PM > To: DEVOS BASTIEN > Subject: Re: mysql start failed. > > oops that was not quite right, > that was a mixture of starting the daemon and connecting to the server all > with o

listen to specific address

Hi, I would like to know how to tell mysql to listen to specific foreign address. I know I can use --bind-address to tell mysql to listen to specific local address. But I need mysql to listen to specific foreign address. HOW TO DO IT. Thank you Mark ---

new reserved word "right" ?

Hi everybody, I wonder if this has been reported before. After upgrading MySQL to the version coming with SuSE 7.1 (3.23.33), I found that all writing operations to the field "right" in my table "Rights" would fail. Strangely enough, trying to fix the problem by enclosing the field name in quote

Re: CPU usage running mysql

Hello again! Do you know if there is any way I can see what the mysqld is doing? If it is taking up 99% of the processor time, it is very busy doing something! I installed the binary version and consequently only have the tools available which came with that distribution. Thanks, David Simon G

Re: Mysql crash

Rui Barreiros writes: > > hi there, from one day to another, my mysql in 2 machines with 2 different > mysql version crashed after a quite long query, > > i've run mysql server with the log option, here are the details: > > in hostname.err: > > mysqld got signal 11; > it's quite strange, i'm

Re: CPU usage running mysql

I wish it was! See my note below, the 7 box runs at about 0.5% but the 2.6 box runs at 99%! David Simon Green wrote: > Is that not 98% idle and mysqld using 5% of the total CPU use! i.e. you are > looking at vary different things? > Simon > > -Original Message- > From: David Allen [mail

Mysql crash

hi there, from one day to another, my mysql in 2 machines with 2 different mysql version crashed after a quite long query, i've run mysql server with the log option, here are the details: in hostname.err: mysqld got signal 11; The manual section 'Debugging a MySQL server' tells you how to use

  1   2   >