Error on Mysql Doc website

I try to access thesearchable documentation with user comments: And get: Forbidden You don't have permission to access /doc/en/index.html on this server. Apache/1.3.26 Server at www

Decrypt MYSQL Password

I am using the MySQL password() function for the my passwords on the user names. How do I decrypt the password in PHP to send it in an e-mail. I am making a forgot your password page and want to have the user enter their e-mail and have the password sent to them. Please help! --

mysql server hardware

Can any of you point me to documentation or have a quick summary of how beefy to make a mysql server. Basically we probably won't have more than 50 connections at one time and we will be pushing packets of 2Mb at times. I'm curious if I should go with tons of ram, faster cpu's, a gig nic, or is i

Re: support table synonyms?

In the last episode (Nov 12), Phillip Rhodes said: > I can not find anywhere that says that mysql supports table name > synonyms. > > For example, I have two databases (test1 and test2) in the same mysql > instance. > > In test1 schema, there is a table called "table1" > > I would like to create

special character

Hi, Can naybody tell me how do i ignore special character while insering in mysql database. For example while i m inserting string 'dk\bd\r' it takes \b and \r as diffenrent character, although i can ignore it with one more escape character like this 'dk\\bd\\r'. Field type is Text. Is there any o

Re: limited queries to one returned row

Hi John, thanks for the limit tip! However, I wish to use this as a security tool. I.e. one in which I (as the mysql admin) can do a grant like: "all queries on a specific table from user "apache" must only return 1 record" This would be like forcing a limit of 1 (using the technique below).

Re: support table synonyms?

On 11/12/02 8:59 PM, "Phillip Rhodes" <[EMAIL PROTECTED]> wrote: > I can not find anywhere that says that mysql supports table name synonyms. > > For example, I have two databases (test1 and test2) in the same mysql > instance. > > In test1 schema, there is a table called "table1" > > I would l

Re: How to link tables in MySQL

macrosoft misleads thousands of people by the way they designed access. in your case, they've confused relations with referential integrity. we cringe when that question hits this list, as it does periodically. relational databases don't have hard coded relations. NEVER. furthermore, re

Re: limited queries to one returned row

see if the limit keyword will do what you want. select * from table limit 0, 2000 > Hi all, > > is it possible to limit a result so that only the first record in a query > can be returned for a specific user? > > I want to do this so that someone who does not have intimate knowledge of > a l

support table synonyms?

I can not find anywhere that says that mysql supports table name synonyms. For example, I have two databases (test1 and test2) in the same mysql instance. In test1 schema, there is a table called "table1" I would like to create a synonym whereby I could refer to test1.table1 as test2.table1 wh

Changing character sets and 'myisamchk -dvv'

The MySQL documentation (4.6.1) says: > You can change the character set with the --default-character-set option > when you start the server. The character sets available depend on the > --with-charset=charset and --with-extra-charsets= list-of-charset | complex > | all options to config

Re: Problems

Thanks for the insanely fast reply :) I had a look at those posts and tried viewing the proc list as shown but the login does not show up? Any one else have any ideas? Daniel On 12 Nov 2002 at 19:22, R. Hannes Niedner wrote: > On 11/12/02 7:05 PM, "Daniel Griggs" <[EMAIL PROTECTED]> wrote: >

Development & Production Servers

Hello, I was wondering if anyone knew of any utilities or had any tips on how to keep two databases structurally uptodate with each other. I was thinking of something that could be run at a certain time and it looked at the structure of a development database and compared it to the structure of

Timeout Wainting For Data File

I'm waiting for a unix pipe to be populated when I get the following message from MySQL: ERROR 2013 at line 1 in file: 'script_namel': Lost connection to MySQL server during query The script in question has one statement in it: load data local infile 'pipe_name'.. This only happens if the

Re: Problems

On 11/12/02 7:05 PM, "Daniel Griggs" <[EMAIL PROTECTED]> wrote: > Hi there, > > I am having trouble with connecting to a Mysql host, the host version is > 3.23.51 on debian stable. After countless re- > reads of the documentation and checking the permissions all I get when I try > to connect rega

Re: Count Rows in two tables

Please forgive me I am new to mySQL, could you give me an example of how I would do this? The two tables are users and staff Thanks Rick - Original Message - From: "Murad Nayal" <[EMAIL PROTECTED]> Cc: <[EMAIL PROTECTED]> Sent: Tuesday, November 12, 2002 6:58 PM Subject: Re: Count Rows

Problems

Hi there, I am having trouble with connecting to a Mysql host, the host version is 3.23.51 on debian stable. After countless re- reads of the documentation and checking the permissions all I get when I try to connect regardless of username and password combinations is "ERROR 2013: Lost connecti

Re: password MYSQL

I tried the first suggestion and it signed in fine. After emptying the cookies in Netscape and then quitting. I tried to connect to http://localhost/phpMyAdmin-2.3.2/index.php and it never asked for a password just gave me: Error MySQL said: Access denied for user: 'root@localhost' (Using pass

RE: Count Rows in two tables

Ah, yes - sorry Alan > -Original Message- > From: [EMAIL PROTECTED] > [mailto:murad@;godel.bioc.columbia.edu]On Behalf Of Murad Nayal > Sent: Wednesday, 13 November 2002 12:58 > Cc: [EMAIL PROTECTED] > Subject: Re: Count Rows in two tables > > > > Alan McDonald wrote: > > > > You can't

Re: Count Rows in two tables

Alan McDonald wrote: > > You can't count the join? > Alan if you count the (unqualified) join you'll end up with the product of the two table counts. Murad > > > -Original Message- > > From: Rick Baranowski [mailto:rickb@;baranconsulting.com] > > Sent: Wednesday, 13 November 2002 12:

Re: Count Rows in two tables

Does it have to be in a single query. You could use a Union query and then total the results in your program. Select Count(Field1) >From Table1 Union Select Count(Field1) >From Table2; >>> "Rick Baranowski" <[EMAIL PROTECTED]> 11/12/02 5:10:14 PM >>> Hello all, Does anybody have a SQL string

Re: Count Rows in two tables

On 11/12/02 5:36 PM, "Alan McDonald" <[EMAIL PROTECTED]> wrote: > You can't count the join? > Alan >> >> Hello all, >> >> Does anybody have a SQL string to count the rows in two different >> tables and >> give you a total number of rows? I have been trying to find an >> answer for a >> couple of

RE: Count Rows in two tables

You can't count the join? Alan > -Original Message- > From: Rick Baranowski [mailto:rickb@;baranconsulting.com] > Sent: Wednesday, 13 November 2002 12:10 > To: [EMAIL PROTECTED] > Subject: Count Rows in two tables > > > Hello all, > > Does anybody have a SQL string to count the rows in

Count Rows in two tables

Hello all, Does anybody have a SQL string to count the rows in two different tables and give you a total number of rows? I have been trying to find an answer for a couple of days and seems like a simple string. Thank you Rick

RE: Installation Help

At 11:45 -0600 11/12/02, Black, Kelly W [PCS] wrote: Make sure you issued the correct GRANT statements at the sql, query. mysql>use mysql; Database Changed mysql> GRANT * ON *.* TO '[EMAIL PROTECTED]' IDENTIFIED BY 'somepassword'; That's not quite right. - GRANT * is not legal, I suspect you m

Re: Impossible SQL ???

Hello, It seems to me that there is a fundamental reason why this can not be accomplished with a single SQL query. The process requires that the search algorithm maintains state between rows. i.e. the decision to keep or discard rows from the table as the algorithm descends down the table is not

Re: Granting rights to more hosts, etc

At 17:46 +0200 11/12/02, Octavian Rasnita wrote: Hi all, I've seen the following command line in a MySQL book, but it doesn't work on my computer running MySQL 3.2 on Windows 2000: grant all on database.* to user@% identified by 'password'; It tells me that there is an error in this command.

Re: Where can I get innodb monitoring tools?

At 18:11 +0900 11/12/02, Chung Ha-nyung wrote: innodb manual (http://www.innodb.com/ibman.html) mentions about innodb monitoring tools, e.g. innodb_tablespace_monitor. But they don't seem to be included in mysql 4.0.4. Should I buy them or can get somewhere else, like innodb homepage? Section 9.

Re: Impossible SQL ???

Hello. What you wrote does not obviously fit to your previous description. On Tue 2002-11-12 at 16:25:40 -0700, [EMAIL PROTECTED] wrote: > > The problem is that I need all the records between the two occurances of > identical values in field 2, with no records which occur before or after > those

Re: Why does safe_mysqld runs as root?

Black, Kelly W [PCS] wrote: Get on out there with your bad self Michael !! Oh yeah :-) Long day, mind you, http://www.tuxedo.org/~esr/faqs/smart-questions.html came to mind, but I refrained myself (the first time). SQL ... QUERY ... KEYWORD ... STUPID ... SPAM ... SYSTEM ... SUICIDE ... H

RE: Why does safe_mysqld runs as root?

Get on out there with your bad self Michael !! :) ~KB -Original Message- From: Michael T. Babcock [mailto:mbabcock@;fibrespeed.net] Sent: Tuesday, November 12, 2002 3:23 PM To: David Kramer Cc: '[EMAIL PROTECTED]' Subject: Re: Why does safe_mysqld runs as root? David Kramer wrote: >By

Re: Impossible SQL ???

Thanks for the reply, but it isn't quite what is needed. The problem is that I need all the records between the two occurances of identical values in field 2, with no records which occur before or after those two occurances. For example, the following table with 3 fields: 11 10 2

Re: How to link tables in MySQL

John Meyer wrote: AFAIK, MySQL doesn't have any sort of referential integrity checks with fields. conceptually, you can do it, and write your program to force it, but the database itself doesn't have it. Or you can use REFERENCES with InnoDB tables; http://www.mysql.com/doc/en ... search fo

Re: Why does safe_mysqld runs as root?

David Kramer wrote: By boot sequence Im guessing you mean my different run levels? rcX.d? Im guessing that I need to set the user value within the start-up script it self rather than my.cnf??? I thought my.cnf was the config file that the start-up scripts reference, by me setting a the attribut

RE: Why does safe_mysqld runs as root?

At 12:36 -0800 11/12/02, David Kramer wrote: Thats what stumps me, I guess I am, but I have changed the ownership of all mysql files to mysql and set the user to mysql in my my.cnf file. By your In *your* my.cnf file? Which file is that? /etc/my.cnf or something else? You may be placing the

Re: Impossible SQL ???

Hi. On Tue 2002-11-12 at 13:43:09 -0700, [EMAIL PROTECTED] wrote: > I can't seem to come up with a solution to the following SQL query, and have > a project dependent on a solution. I'd rather not load the whole database > and then parse it in the code. > > With the following Database structure:

RE: delayed inserts and messages in the .err log

Check if mysqld or some other process uses all available memory. If not you may have to use 'ulimit' to allow mysqld to use more memory or you can add more swap space", If it persists, use vmstat 1 ~Kelly W Black -Original Message- From: Jeremy Zawodny [mailto:Jeremy@;Zawodny.com] Sent

RE: Why does safe_mysqld runs as root?

By boot sequence Im guessing you mean my different run levels? rcX.d? Im guessing that I need to set the user value within the start-up script it self rather than my.cnf??? I thought my.cnf was the config file that the start-up scripts reference, by me setting a the attribute user=mysql under [my

Re: Windows cnf file location

At 20:51 + 11/12/02, Jannie Qu wrote: Hi, John, my.cnf is used as config file on windows. By default it is at, e.g. c:\winnt your boot system directory. Not quite. In the Windows system directory, the filename is my.ini. In C:\, the filename is my.cnf. In the MySQL data directory, the fil

Re: Windows cnf file location

Is there a good or bad reason to create the config file in the MySQL folder? On production servers which logs do you turn on? Typically what things do you set on in the config file on a production server? Thank you. At 10:37 PM 11/12/2002 +0200, you wrote: Hi! On Tue, 12 Nov 2002, John Chang

Re: delayed inserts and messages in the .err log

On Tue, Nov 12, 2002 at 02:18:44PM -0800, [EMAIL PROTECTED] wrote: > This is just a "should I be concerned" question. I am getting a few > messages in the mysql error log about delayed inserts and the database not > being able to obtain a lock. The database is averaging about 250 queries > per

delayed inserts and messages in the .err log

This is just a "should I be concerned" question. I am getting a few messages in the mysql error log about delayed inserts and the database not being able to obtain a lock. The database is averaging about 250 queries per second. We are using delayed inserts for most every insert and the data

RE: How to link tables in MySQL

FROM table1 t1 LEFT JOIN table2 t2 ON t1.field=t2.field -Original Message- From: John Meyer [mailto:johnmeyer_1978@;yahoo.com] Sent: Wednesday, November 13, 2002 8:14 AM To: MySQL Mailinglist Subject: RE: How to link tables in MySQL AFAIK, MySQL doesn't have any sort of referential inte

Re: last_insert_id()

This looks like the same problem I have with MS Access. It seems MS Access uses the SELECT id FROM table_name WHERE is IS NULL, and this syntax clears the last insert ID field. My solution is here: --- One Line URL, might wrap --- http://groups.google.com/groups?hl=en&safe=off&threadm=9ehc8i%2

RE: How to link tables in MySQL

AFAIK, MySQL doesn't have any sort of referential integrity checks with fields. conceptually, you can do it, and write your program to force it, but the database itself doesn't have it. John Meyer P.S. shouldn't it be table1.fieldA -Original Message- From: R. Hannes Niedner [mailto:han

Re: Impossible SQL ???

On 11/12/02 12:43 PM, "Charlie" <[EMAIL PROTECTED]> wrote: > I can't seem to come up with a solution to the following SQL query, and have > a project dependent on a solution. I'd rather not load the whole database > and then parse it in the code. > > With the following Database structure: > Field

RE: last_insert_id()

The .Neta Adapter.. does it make a persistent connection? If the connection drops between the first insert and the call to select, then the return would be zero Alan > -Original Message- > From: Cain O'Sullivan [mailto:cos@;iinet.net.au] > Sent: Wednesday, 13 November 2002 16:13 > To: [EM

Re: password MYSQL

Hi! First, try connecting from the command-line mysql client. mysql -u root -p -h ser.ver.ip.addr Then enter your password (if you don't have a root password you can dismiss -p) Also, if that works, try resetting cookies from your browser, as phpMyAdmin relies on cookie authentication. Iikka On

Re: mysqldump performance

Jannie Qu wrote: Does anyone of you know the performance of mysqldump to backup tables? Depends on locking, of course, but pretty similar to select * on * ... (if such were possible). -- Michael T. Babcock C.T.O., FibreSpeed Ltd. http://www.fibrespeed.net/~mbabcock --

Re: Why does safe_mysqld runs as root?

David Kramer wrote: Thats what stumps me, I guess I am, but I have changed the ownership of all mysql files to mysql and set the user to mysql in my my.cnf file. By your comment below I guess I need to change it somewhere else? where? Where is mysql being started from? Are you familiar wit

Re: How to link tables in MySQL

You can still use Access to build your queries then click the SQL button and you'll have the the code for the command line. Access SQL is a little different but you should still be able to get an idea on how to do it. - Ed >>> tmb <[EMAIL PROTECTED]> 11/12/02 12:41:49 PM >>> 1 - any way to search

Re: How to link tables in MySQL

On 11/12/02 12:41 PM, "tmb" <[EMAIL PROTECTED]> wrote: > 2 - In MS Access you have to graphically connect the > table id fields to tell Access how the tables relate. > > How do you do this In MySQL... from the command line > I'm sure... just a code snippit or reference to one > would be nice...

Re: Windows cnf file location

> Where is the config file for MySQL on windows? Is that where I tell it to > use a log file? By default is it off? Thank you. Under Linux, MySQL server executables and eight MySQL utulities read options from /etc/my.cnf, and under Windows they read from c:\windows\my.ini and c:\my.cnf, in that

Re: Windows cnf file location

Hi, John, my.cnf is used as config file on windows. By default it is at, e.g. c:\winnt your boot system directory. It's not a log file. From: John Chang <[EMAIL PROTECTED]> To: [EMAIL PROTECTED] Subject: Windows cnf file location Date: Tue, 12 Nov 2002 15:27:05 -0500 Where is the config fil

password MYSQL

I just changed the root password for MYSQL from the default and now it gives me the error Access is denied when I try to connect using phpMyadmin. It doesn't even ask for a password. How can I login in? Thank you. - Before

Re: Insert many records

I know I can do it by application. But I would like to know if are there other way to do the same. sql, query [EMAIL PROTECTED] escreve: In a message dated 12/11/2002 18:46:08 GMT Standard Time, [EMAIL PROTECTED] writes: Hi, How can I insert many records (for instance: 1.000.000)

Re: Granting rights to more hosts, etc

Octavian Rasnita wrote: Hi all, I've seen the following command line in a MySQL book, but it doesn't work on my computer running MySQL 3.2 on Windows 2000: grant all on database.* to user@% identified by 'password'; grant all on database.* to 'user'@'%' identified by 'password'; It tell

Impossible SQL ???

I can't seem to come up with a solution to the following SQL query, and have a project dependent on a solution. I'd rather not load the whole database and then parse it in the code. With the following Database structure: Field0 Integer Autonumber Field1 Integer Unique Field2 Integer not uniqu

Re: Newbie to the list ...no [MYSQL] in the subject sql query not problem.???

- Original Message - From: <[EMAIL PROTECTED]> To: "working4aliving" <[EMAIL PROTECTED]> Sent: Tuesday, November 12, 2002 12:29 PM Subject: Re: Newbie to the list ...no [MYSQL] in the subject??? > Your message cannot be posted because it appears to be either spam or > simply off topic to

How to link tables in MySQL

1 - any way to search archives of MySQL list? 2 - In MS Access you have to graphically connect the table id fields to tell Access how the tables relate. How do you do this In MySQL... from the command line I'm sure... just a code snippit or reference to one would be nice... Thanks for any help -

Re: Windows cnf file location

Hi! On Tue, 12 Nov 2002, John Chang wrote: > Where is the config file for MySQL on windows? Is that where I tell it to > use a log file? By default is it off? Thank you. For example, in c:\winnt\my.ini or in c:\my.cnf You can specify a custom config file location to mysqld with the --defaults

RE: Why does safe_mysqld runs as root?

Thats what stumps me, I guess I am, but I have changed the ownership of all mysql files to mysql and set the user to mysql in my my.cnf file. By your comment below I guess I need to change it somewhere else? where? Thanks, DK -Original Message- From: Jeremy Zawodny [mailto:Jeremy@;Zawo

Windows cnf file location

Where is the config file for MySQL on windows? Is that where I tell it to use a log file? By default is it off? Thank you. - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.

mysqldump performance

Hi, all sql, query. Does anyone of you know the performance of mysqldump to backup tables? Thank you, Jing _ Tired of spam? Get advanced junk mail protection with MSN 8. http://join.msn.com/?page=features/junkmail --

RE: yo

Hola Roberto, Si tu vas a http://www.free-translator.com/ y le ponse http://www.mysql.com/documentation/mysql/full/ en Systran, traducira la documentacion de MySQL a la lengua que seleciones. Entonces asi lo puedes grabar en to computadora y ya vas a tener por donde empezar. Se va a demorar un p

Re: Why does safe_mysqld runs as root?

On Tue, Nov 12, 2002 at 12:06:36PM -0800, David Kramer wrote: > Im curious as to why safe_mysqld runs as root? I have changed the > owenership and group to mysql and my my.cnf file looks like: Because you start it as root, maybe? -- Jeremy D. Zawodny | Perl, Web, MySQL, Linux Magazine, Yaho

Why does safe_mysqld runs as root?

Im curious as to why safe_mysqld runs as root? I have changed the owenership and group to mysql and my my.cnf file looks like: [mysqld] user=mysql port=3306 socket=/var/lib/mysql/mysql.sock [mysql_server] user=mysql port=3306 socket=/var/lib/mysql/mysql.sock Any thoughts are welcome. Thanks mu

RES: Insert many records

Try to use AccessDump. It generate multiples INSERT, one for each row. It´s so good. http://www.intranet2internet.com/public/default.asp Lucky Jacob -Mensagem original- De: Alexander Burbello [mailto:burbello@;pop.com.br] Enviada em: terça-feira, 12 de novembro de 2002 16:29 Para: [EM

Re: yo

Hi, Maybe on IRC(UNDERNET) is possible to have chance to find MySQL tutorials in spanish. Regards, Gelu _ G.NET SOFTWARE COMPANY Permanent e-mail address : [EMAIL PROTECTED] [EMAIL PROTECTED] - Ori

limited queries to one returned row

Hi all, is it possible to limit a result so that only the first record in a query can be returned for a specific user? I want to do this so that someone who does not have intimate knowledge of a large (>10 records) table cannot issue commands to grab *all* of the data. Thanks ahead of time f

"Waiting on cond"?

I was wondering if someone could tell me what "Waiting on cond" meant in a process state. We have a build system that is continuously running our unit test suite over new checkins. Earlier today I got an alert that steps were beginning to timeout. I looked into it and in each case it (the build

yo

Hola: Yo no sé como trabaja mysql, lo instalé pero necesito un manual o un tutorial en Castellano (español), que me indique como usarlo, como crear tablas,etc. muchas gracias. Pd. la versión que instalé es par windows.

yo

Hola: Yo no sé como trabaja mysql, lo instalé pero necesito un manual o un tutorial en Castellano (español), que me indique como usarlo, como crear tablas,etc. muchas gracias. - Before posting, please check: http://ww

Problem in using MySQLGUI 1.7.5-2

Hi, I'm Edison Xavier. I have installed the MySQL 3.23.52 on an RedHat 8.0. In the local client (running on the same machine as the server) I can connect using any registered user like this: mysql -u xavier -p This connection occours perfectly. I have installed the MySQLGUI 1.7.5-2 on my workst

Re: Insert many records

You could pu tmany records in a file and use mysql -u user -p http://www.mysql.com/doc/en/LOAD_DATA.html -Corey Tisdale The Grill Store & More --- "Alexander Burbello" <[EMAIL PROTECTED]> wrote: >Hi, > >How can I insert many records (for instance: 1.000.000) without to do this >by application

Column "aliasing"

I would like to add a column in one of my tables that is an exact copy of (or alias) for another column, except that it has a different name. Why? I'm joining two tables that were previously separate and I want to use 1 main idexing column (e.g. the same numbering scheme). However a whole lot

RE: Newbie Question - Query works in access but not MySQL

That did it. Thank you very much. - Ed >>> "Mark Armer" <[EMAIL PROTECTED]> 11/12/02 9:12:15 AM >>> How about if you rewrite the statement to: > SELECT Products.PartNumber, Sum(tblInvTransaction.Qty) AS SumOfQty > FROM Products LEFT JOIN tblInvTransaction ON Products.ProductID = > tblInvTra

Re: why is this slow?

Hi. On Tue 2002-11-12 at 10:24:34 +0800, [EMAIL PROTECTED] wrote: > At 04:47 PM 11/11/2002 +0800, Thomas Seifert wrote: > >Are you using MySQL-3.23.x? > >AFAIK it doesn't use a key for ORDER BY (MySQL-4.x does). > >Maybe thats the cause? > > > > Yes. Im using 3.23.52(nt). I just upgraded it from

Insert many records

Hi, How can I insert many records (for instance: 1.000.000) without to do this by application? Are there a loop sintax like PL/SQL? Regards sql, query - Before posting, please check: http://www.mysql.com/manual.php (the

RE: Problem compiling mysqlgui 1.7.5

See the file INSTALL_BINARY ~KB -Original Message- From: Pierre [mailto:pierre@;epinetworx.com] Sent: Tuesday, November 12, 2002 1:45 AM To: [EMAIL PROTECTED] Subject: Problem compiling mysqlgui 1.7.5 Hi, I try to compile mysqlgui-src-1.7.5 on my GNU/Linux system with gcc-3.2 but with

RE: Installation Help

Make sure you issued the correct GRANT statements at the sql, query. mysql>use mysql; Database Changed mysql> GRANT * ON *.* TO '[EMAIL PROTECTED]' IDENTIFIED BY 'somepassword'; #note that will give FULL access...see the docs to restrict this. mysql> FLUSH PRIVILEGES; 0 Rows Affected. ~Kelly W.

RE: How to port MS Access to MySQL ??

I used MyAccess and it worked very well. One thing I didn't like was that in any table/field name that contained a space, the space was converted to an underscore. I would've rathered it just removed the space so I wrote some VBA to remove all the spaces from field and table names then let MyAccess

RE: unable to start mysql

Don't re-install.. Fix the problem Try issuing shell>cd /usr/local/mysqlversion shell>./configure ~K Black -Original Message- From: mod_perl [mailto:shine_perl@;spectrum.net.in] Sent: Monday, November 11, 2002 10:23 PM To: [EMAIL PROTECTED] Subject: unable to start mysql hi all, when

RE: slow queries

Make sure when you are creating the database that U_Number | int(9) unsigned | | PRI | NULL is U_Number | numeric() | | PRI | NULL -Original Message- From: Petre Agenbag [mailto:internet@;boesmanland.com] Sent: Tuesday, November 12, 2002 4:27 AM To: [E

RE: Solaris 2.6

You don't have a compiler installed? Hmmm. This seems tough to believe. Try issuing 'which cc' ~K Black -Original Message- From: leaddog1 [mailto:jsobeck@;lead-dog.net] Sent: Tuesday, November 12, 2002 6:44 AM To: [EMAIL PROTECTED] Subject: Solaris 2.6 Is there any version of MySQL wi

RE: mysql_install_db hangs

Make sure some previous version of MySql isn't running. I have seen this on systems which had the OS installed version of MySql, and I had to issue shell> /sbin/service mysql stop shell> cd /usr/local/mysqlversion shell> ./bin/mysqld_safe -user=theuserid Hope this helps... ~Kelly W. Black ---

RE: How stable is MySQL 4.x vs 3.23.x?

I have been using the MySql 4.x MAX with absolutely NO problems. It's being used on heavily operated servers, and I upgraded to 4.x for it's incredible index speeds and it's VERY reliable to me. In fact, in our local benchmarks it's kicking the living crap out of Oracle on sql, query. :) ~Kelly

Granting rights to more hosts, etc

Hi all, I've seen the following command line in a MySQL book, but it doesn't work on my computer running MySQL 3.2 on Windows 2000: grant all on database.* to user@% identified by 'password'; It tells me that there is an error in this command. How can I use a wildcard in this command? Can I giv

Re: how do i savely delete replication bin-logs ?

(This is a repost of an ealier answer): Here's one which takes log rotation a step further than mysql provides for. It is run on the slaves to keep track of their position and then run on the master to purge up to the earliest slave position. This is useful because you can't reliably get all the

re: RE: query crushes server

Eugene, Monday, November 11, 2002, 9:40:20 PM, you wrote: EB> mysqld-nt.exe has genrated errors and will be closed by Windows. EB> You will need to restart the program. EB> An error log is being created. EB> select distinct a.* from gnrlasoc a, tasks b where a.row_key_1 = b.prim_key; EB> The num

RE: Installation Help

Did you set up root as a user inside of MYSQL? Eventhough root has permission it must be set up as a user inside of MySQL. >>> "Phil Iovino" <[EMAIL PROTECTED]> 11/12/02 09:13AM >>> I believe root has all permissions. I'm using Webmin to verify it. I started it with -u root but still got the sa

re: access denied

Inbal, Monday, November 11, 2002, 7:10:49 PM, you wrote: IO> I am working with mysql, in windows, visual c++. IO> I am trying to run this query from c++ program: IO> select * into outfile 'table_name.txt' FIELDS TERMINATED BY '\t' ESCAPED BY IO> '\0' LINES TERMINATED BY '\r' from table_name IO>

SunOS 5.6

Hi, I am looking to install MySQL on SunOS 5.6 (SunOS 5.6 Generic_105181-23 sun4u sparc SUNW,Ultra-4) can anyone tell me which version will work and which binary to download. Thanks. Matt. - Before posting, please check: ht

RE: Installation Help

I believe root has all permissions. I'm using Webmin to verify it. I started it with -u root but still got the same error. Since I installed with the RPM didn't it give root permission? -Original Message- From: Scott Pippin [mailto:spippin@;mtctrains.com] Sent: Tuesday, November 12, 200

RE: Newbie Question - Query works in access but not MySQL

How about if you rewrite the statement to: > SELECT Products.PartNumber, Sum(tblInvTransaction.Qty) AS SumOfQty > FROM Products LEFT JOIN tblInvTransaction ON Products.ProductID = > tblInvTransaction.ProductID > Where ((Products.PartNumberLike "%A-000%") AND > (Products.Obsolete<>-1)) > GROUP B

Re: Installation Help

Scott Pippin [EMAIL PROTECTED] >>> "Phil Iovino" <[EMAIL PROTECTED]> 11/12/02 08:13AM >>> >I'm trying to install MySQL under RedHat 8. I installed the MySQL >3.23.53a-1 and MySQL-client 3.23.53a-1 RPMs. >Per the instructions at >http://www.mysql.com/documentation/mysql/bychapter/manual_Installi

select query error

Hi All, I have a table in mysql as "Attributes", which has 10 recordsin it. If I run the query as "select * from Attributes", it gives me 10 records, but if i run the query as "Select Attribute from Attributes" it gives me 9 records. But this error does not occur every time. It comes very rarely

Installation Help

I'm trying to install MySQL under RedHat 8. I installed the MySQL 3.23.53a-1 and MySQL-client 3.23.53a-1 RPMs. Per the instructions at http://www.mysql.com/documentation/mysql/bychapter/manual_Installing.htm l#Post-installation, I started the server with "/usr/bin/safe_mysqld &" and it appears to

RE: Scrolling Databases

select * from table_name limit 1; or limit 2,1; I hope this helps a bit? Simon -Original Message- From: Beauford [mailto:beauford.2003@;rogers.com] Sent: 12 November 2002 15:04 To: [EMAIL PROTECTED] Subject: Scrolling Databases Hi, I have created a contact database using Mysql and want

Scrolling Databases

Hi, I have created a contact database using Mysql and want to be able to scroll back and forth through the database. Even after I have done a search and found a record, I want to be able to scroll back or forth from that point on. I am using PHP4 to display the results. This may be something easy

  1   2   >