Re: MySQL 4.0.7-gamma: Bugs affecting the privilege system

Alexander, > - After having set up both machines completely, I installed the Win32 > binary distribution of MySQL 4.0.7-gamma. Although I did not upgrade > from an earlier version, the privileges tables still have the old > structure without the new columns introduced with MySQL 4.0.2-beta! > Furt

Re: MySQL Help Needed Please

/usr/local/bin/safe_mysqld --user=mysql How do I re-point mysql to look for my old database, I guess that's the problem right? Thank you Stefan Best Regards, Anton -Original Message- From: Stefan Hinz, iConnect (Berlin) [mailto:[EMAIL PROTECTED]] Sent: Saturday, Janua

Re: problem with drop table

Francesco, > ERROR &: Error on delete of .'\camcomm.tmpge.MYI' > The problem persists. I don't know the reason of this error. > I ask if a new version of Mysql (the version 4.0.7 i s released) is better. Most probably. I had problems like that with 4.0.3 and 4.0.4, but not yet with 4.0.7 (all und

Re: MySQL Help Needed Please

nz <[EMAIL PROTECTED]> Geschäftsführer / CEO iConnect GmbH <http://iConnect.de> Heesestr. 6, 12169 Berlin (Germany) Tel: +49 30 7970948-0 Fax: +49 30 7970948-3 - Original Message - From: "Anton Zavrin" <[EMAIL PROTECTED]> To: "'Stefan Hinz, iConnec

Re: aide

Demba, the list language is English, so please don't post in French. I will try to answer your question, anyway. > Que dois je faire pour lancer MYSQL afain de > l'utiliser sans problème sous Windows 98. Did you make sure that the MySQL _server_ is up and running? The error you're reporting is

Re: is it a bug?

Luca, > the result was: ",1,2,.,n". > but today doesn't works anymore > now the result is ".n" where n is the last max(id) value in the result set. I did a similar query on this table; mysql> DESCRIBE gehalt; +---+--+--+-+-+---+ | Field | Type

Re: MySQL Help Needed Please

Anton, first thing, try: ps [whatever options] | grep mysqld The daemon (database server) is called mysqld, not mysql. Regards, -- Stefan Hinz <[EMAIL PROTECTED]> Geschäftsführer / CEO iConnect GmbH Heesestr. 6, 12169 Berlin (Germany) Tel: +49 30 7970948-0 Fax: +49

Re: Field \ Table Types - Beginner

John, > My data is made of Names, Dates and occasionally images. From the web > side the vast majority of queries will be made on the surname so I'm > thinking that I should create a full text index on the surname field ? > as that will enable fast searching on the field ? You will only want to d

Re: LOAD DATA LOCAL

Egor, >> Any hints how to make LOAD DATA LOCAL work in spite of this >> "improvement"? > Stefan, currently I have no Windows box on hands, to check it out on Win32, but I > remember that it works for me at least on 4.0.6 with local-infile=1 in > my.cnf. as far as I remember from MySQL trainings

Re: auto increment question

Kevin, > I have a table with an ID column and a viewed column. I would like the > viewed column to increment by one each time the row is updated. > Stats > === > ID > views UPDATE Stats SET Views = Views + 1 WHERE ID = (selected row) Or is there more behind this question? Regards, -- Stef

Re: PHP and MySQL bug

Nuno, > $r=MYSQL_QUERY("SELECT n,u,m,h FROM d WHERE id='$id'"); > > /* Some code including "mysql_num_rows" and "mysql_fetch_array($r, > MYSQL_NUM)" > And the another query: > */ > > MYSQL_QUERY("UPDATE d SET h='$h' WHERE id='$id'"); > > /* i don't know why but this doesn't work!*/ It doesn't wor

Re: LOAD DATA LOCAL

Jon, thanks for trying to help! > Not much help I know, but you are not the only person having this problem. Okay, all you striving folks from MySQL on this list! When are you going to solve this? (The LOCAL feature is not essential to me, but it's a pain in the neck to encounter issues like thi

Re: FAQ hosting site (was "Re: An Idea")

. 6, 12169 Berlin (Germany) Tel: +49 30 7970948-0 Fax: +49 30 7970948-3 - Original Message ----- From: "David T-G" <[EMAIL PROTECTED]> To: "mysql users" <[EMAIL PROTECTED]> Cc: "Stefan Hinz, iConnect (Berlin)" <[EMAIL PROTECTED]> Sent: Wednesday,

Re: load data local infile

Terence, Rich, > > I have tried: > > LOAD DATA LOCAL INFILE "lcopen1.txt" INTO TABLE lcopen; > > but it shows: > > ERROR 1148: The used command is not allowed with this > > MySQL version This is because of security issues, as the manual says: In MySQL 3.23.49 and MySQL 4.0.2, we added some new o

Re: An Idea

: +49 30 7970948-3 - Original Message - From: "JamesD" <[EMAIL PROTECTED]> To: "David T-G" <[EMAIL PROTECTED]>; "mysql users" <[EMAIL PROTECTED]> Cc: "Stefan Hinz, iConnect (Berlin)" <[EMAIL PROTECTED]> Sent: Wednesday, Jan

Re: An Idea

Fax: +49 30 7970948-3 - Original Message - From: "David T-G" <[EMAIL PROTECTED]> To: "mysql users" <[EMAIL PROTECTED]> Cc: "Stefan Hinz, iConnect (Berlin)" <[EMAIL PROTECTED]> Sent: Wednesday, January 01, 2003 1:35 AM Subject: Re: An Idea >

Re: An Idea

David, regarding the MySQL FAQ: > Why should it have to be there? Let anyone with a site set it up and get > it going and see if readers will even care about it, and *then* perhaps > have it move to mysql.com later... MySQL.com would be the natural place for the FAQ. Any other place wouldn't be

Re: Privileges in MySQL 4.0.7 (upgrade)

Dear list, no one has answered my question up to now. Looking through the manual again today, I still can't figure out what to do. > just upgraded from MySQL 4.0.3 to 4.0.7 on my Win2K box at home. The problem is, I still have the _old_ privileges in my mysql tables, not the new ones like super,

Re: An Idea

Stefan Hinz <[EMAIL PROTECTED]> Geschäftsführer / CEO iConnect GmbH <http://iConnect.de> Heesestr. 6, 12169 Berlin (Germany) Tel: +49 30 7970948-0 Fax: +49 30 7970948-3 - Original Message - From: "Peter Lovatt" <[EMAIL PROTECTED]> To: "Stefan Hi

Re: Fatal error

Pikasz, > >...then appear the next error and I don't understand why: > >Fatal error: Call to undefined function: mysql_connect() in > >/var/www/html/vk/vk.php on line 11 Looks like MySQL has not been enabled in your PHP installation. Check with phpinfo() to find out. Regards, -- Stefan Hinz <[

Re: An Idea

Cal, Paul, dear list, thank you, Cal, for your wise words ... > "Here's the FAQ we developed so you don't have to waste our time asking > questions that have already been answered." Go to MySQL.com and type "FAQ" in the search box. This will provide 71 results, some of them with valuable FAQ-lik

Re: MySQL InnoDB

Andrew, > > If i use code at PHP IN ONE PAGE - that uses like : > > SET COMMIT [snip] > > All Actions - work OK - COMMIT & ROLLBACK > > But if i try use every Insert at defferent page (php) [snip] > > p1.php - has > > SET COMMIT; > > INSERT 1 > > > > {go to p2.php} > > INSERT 1 > > ROLLBA

Re: Storing a SHA1 checksum

Benjamin, Philip, > > 1. Use blob instead of varchar. > >Problem: blob type is slower. > > Is that really a problem? Did you measure it? If so, I would be > intersted in the results. As the manual states: "Note that each BLOB or TEXT value is represented internally by a separately allocated o

Re: certification exam

John, > Has anyone been successful in signing up for the certification exam? Yes. I took the exam (still beta at that time) November 26, in Berlin, Germany. > I've entered dates going up to Jume 30,2003 to schedule an exam and all > I get back is exam not available. The V.U.E. registration webs

Re: altering data structure

David, > I don't have a good example, but suppose I have a few tables with some > fields each and I realize that I should make a new table with data from > some columns of some tables. What to do? Do you want to CREATE TABLE tbl_new SELECT (col1, col2, ...) FROM tbl_old? Or do I miss something w

Re: style question: "drop database" in an install script

David, > Or is there perhaps a "RENAME DATABASE" command (I saw RENAME TABLE) in MySQL 4.1, you will find "ALTER DATABASE": http://www.mysql.com/documentation/mysql/bychapter/manual_News.html#News -4.1.0 Regards, -- Stefan Hinz <[EMAIL PROTECTED]> Geschäftsführer / CEO iConnect GmbH

Re: What does this mean? : Warning: thr_alarm queue is full

Chung, > Warning: thr_alarm queue is full > What's this? Is it serious problem? Looking for "thr_alarm" in the MySQL Manual, I find this: If mysqld is compiled with -DUSE_ALARM_THREAD, a dedicated thread that handles alarms is created. This is only used on some systems where there are problem

Re: entering Chr(13) & Chr(10) in insert & update

Kayamboo, (B (B>Is there any way I can insert Chr(13) & Chr(10) along with string (B> characters in a blob field using *insert* or *update* statements. (B (BYou can insert these values (CR/LF) just like any other character, but (Byou have to make sure they have been escaped properly. If

Re: syntax

Samuel, > select sld_vlprov,hist_lanc from sld_lanc,lanc > where sld_lanc.sld_user *= lanc.user_usuario In MySQL, this could simply be: select sld_vlprov,hist_lanc from sld_lanc,lanc where sld_lanc.sld_user = lanc.user_usuario But you can write it like you did, as well: > select * from sld_lan

Re: Increase MySQL Cache Size

Geetika, > If there are multiple caches in MySQL, I would welcome suggestions > pertaining to all or any of them. Thanks! SHOW VARIABLES will show you what caches are set for your MySQL installation. E.g., I do: mysql> select version(); show variables like '%cache%'; +---+ |

Re: wildcard '%' for host in mysql.user table broken

Larry, > GRANT ALL ON dbname.* TO larry@"%" IDENTIFIED BY 'larry123'; > FLUSH PRIVILEGES; > > properly changes the mysql.user table. However, if I subsequently > attempt to use the mysql client like this > > mysql -h -u larry -p dbname > > and enter 'larry123' at the pass

Re: MySQL security flaws uncovered

Csongor, Michael: >> Maybe they're taking the MS route. > I second this. These vulnerabilities are serious, they must be given > more attention. Apache, PHP, RedHat and so on and so on are very careful > with issues like this, all vulnerabilities/exploits are immediately > published through all p

Re: more about using sets

Adam, > I agree entirely. SETS and ENUMS should be avoided by any normal user > (frankly, I think they should be deprecated). They are not portable and > it's just horrific to be changing data with an ALTER statement. To add some more to this discussion, a customer of ours is having problems wi

Re: Large Like Queries

Chris, > SELECT my_id FROM my_table WHERE my_value LIKE '%ABCDEFG%' LIMIT 50; > I know that in a query such as this, mysql does not utilize indexing, so I > was just curious how some others have attempted to speed up this kind of > thing up Maybe this answer won't help too much, but I experie

Re: SQL Question

Darren, > I need to construct a query to find out what customers in the database > have not > booked shipments with us. That means there would be no > records in the shipment table for a given customer id. If I get this right, it should be: SELECT custid, name FROM customers LEFT JOIN shipment O

Re: How can I speed up the Left Join on big tables?

Qunfeng, > A simple left join on two big table took 5 mins to > finish. These lines tell about the cause of the problem: > | table | type | possible_keys | key | key_len | > | s | index | NULL | PRIMARY | 50 | MySQL has no key (index) which it can use to speed up the se

Re: to var or not to var (char, that is)

Dave, > How does one decide whether to define a table with varchar() or char() > field definitions? Use CHAR, if you don't have to care about disk space, and if speed is your first goal. Using CHARs with lots of spaces in the data can be counterproductive, though, because MySQL will have to retur

Re: MySQL crashes with foreign key restraints

Dear Heikki, thanks for the hint! > please upgrade to 4.0.5 and test again. > 4.0.1 is a very old alpha release, and lots of bugs have been fixed since. But please note what I said about 4.0.3: >> P.S. I tried the same with 4.0.3-max-nt on a Win2K box. Here, the server >> doesn't crash, but the

Re: Fastest way to get the number of rows in a table ?

Dear Christophe, >Type: InnoDB >Rows: 603 << 700 != 603 >> > How do you explain the difference between "count(*): 700" and "Rows: 603" You don't have to explain this, the manual does ;-) http://www.mysql.com/documentation/mysql/bychapter/manual_T

Re: porting M$ SQL to mySQL

Dear Falcon, > I am trying to migrate a few MS SQL databases > to mySQL and I need to know what the equivalent mysql > datatypes are for the following MS SQL datatypes: I am not too familiar with MS SQL, so someone please correct me if I'm wrong with this list: > nvarchar -> [NATIONAL] VARCHAR >

Re: Migration from Oracle

Dear Satish, > I want to migrate from Oracle to MySQL. > So I need to import the tables and data from Oracle. > Can anyone suggest any tool which can do this. > Any pointer regarding this will be appreciated. (1) I am not familiar with Oracle, but I assume (oh, that word again) that it has a dump

Re: Update Query problem

Dear Amit, > "update lotjobtemp set duedate = (select duedate from > importparameters);" In MySQL, you need 2 queries for this: SELECT @var:=duedate FROM importparameters; UPDATE lotjobtemp SET duedate = @var; Most probably, you will want to use a WHERE clause for both statments. To make this

Re: help on NOT EXISTS SQL query

Dear Murad, > I know you can emulate an 'exists' subquery with a join. but I just > can't think of a way to emulate a 'not exists' without a subquery. > probably due to my limited sql experience. any hints? You have probably tried something like SELECT ... WHERE IS NOT NULL. To emulate a "not ex

Re: Can't connect error 10061 - nothing but Mascon works remotely.

Dear Daevid, > I don't have mySQL installed on the XP box, so I can't run mysqladmin. I knew your answer to this before I pressed the send button ;-) Do install MySQL on your Win XP box. The installation procedure will not start the MySQL server, so there's nothing to worry about. If you leave t

Re: backrev mysql while retaining data?

Dear Ronald, > Due to some application compatibility issues, I may have to backrev > mysql-3.23.53a-1 to 3.23.52-3. I have only a few weeks' experience > with mysql -- can I do this and retain the current tables and data > contained therein? Backup your databases and tables first. I would sugges

Re: Password protection

Dear Bjoern, > I have completed a new setup on WinXP, with Mysqld-nt as a service, and > assigned a new password to root. However I am able to connect as root > without password, alter and even drop tables and complete databases with > the tool MySQLFront !!! After setting up MySQL under Windows,

Re: MyISAM -> InnoDB

Dear Dan, > I have a database that, I now realize, could use the benefits of > row-locking and non-blocking SELECTs. So, I guess I need to change over > to InnoDB tables. How do I convert my existing data structures (and the > data they contain) into InnoDB tables? ALTER TABLE mytable TYPE=innodb

Re: Can't connect error 10061 - nothing but Mascon works remotely.

Dear Daevid, > Can't connect to MySQL server on 'daevid.com'(10061) Try "mysqladmin ping -h mysql_host_name". This is the most basic thing I can think of to connect to a MySQL server. It should report "mysqld is alive". If even that doesn't work, try "mysqladmin ping -h 192.168.1.1" (or whatever

Re: MySQL user privilages

Dear Ryan, have a look at the manual: http://www.mysql.com/documentation/mysql/bychapter/manual_MySQL_Database_Adm inistration.html#User_Account_Management With the exception of Paul's book on MySQL, you probably won't find a better explanation of the MySQL privilege system. > PLEASE I'M GOING

Re: MySql Feature

Dear Benjamin, dear Michael, > > > 1. I need to know if these features are supported or not by MySql ver > > 4.05a. > > > - Referencial integrity constraint This is supported with InnoDB tables. If you _always_ need referential integrity, simply set InnoDB tables as the default table type in my.c

Re: Problems with upper/lowercase mappings

Dear Andy, > There is no way I can make my client app regard é and É to be > identical, even if I want it to, even if it would seem logical to > you that it should be so. This cannot be changed. So, I'm now at a > loss as how to store and work with this in MySQL. I need to use > some of those c

Re: What are basic db files MySQL creates?

Dear Will, > When I create a new db using MySQL... > What files does MySQL create? CREATE DATABASE mynewone will create a directory called "mynewone" in the MySQL datadir. You can check where this is by issuing "SHOW VARIABLES LIKE 'datadir'" on the SQL command line. HTH! -- Stefan Hinz <[EMAI

Re: Error Message Documents - where to find it?

Dear Jason, > Where can i find documents with the description of mysql error code returned > by the mysql daemon? try the PERROR utility shipped along with the MySQL daemon (in the bin directory), like: PERROR 1064 HTH! -- Stefan Hinz <[EMAIL PROTECTED]> CEO / Geschäftsleitung iConnect Gmb

Re: mysqldump error

Dear Carlos, > ERROR 2013 at line 1: Lost connection to MySQL server during query > I think is problem with the binary, but I don't know why.. an idea may be > install a recent new version from mysql. Which version do you have? Regards, -- Stefan Hinz <[EMAIL PROTECTED]> CEO / Geschäftsleitu

Re: question about mysql_real_escape_string()

Dear Tom, > when i load a binary file (filesize 49Kb) into a blob field, the function is > ok but when the filesize is 1.8Mb, the function fails and my programs > aborts. The communication buffer (between client and server) is set to 1 MByte by default. You can change this either by starting the

Re: C API problems with InnoDB

Dear Heri, > I tracked down the problem and saw that its only happening if I set > autocommit=0. > If I run a second mysql shell I can see all changes immediately. Just the > application itself doesnt. Does the second shell actually perform those changes? In this case, I assume it's got something

Re: Logical Field Type

Dear Curtis, > might be 0 vs 1, T vs F, or Y vs N, or any combination of these. > Is there a MySQL logical field type that will handle any/all of these at > one time? AFAIK you can accomplish this only on the application side. In MySQL, you can work with ENUM('0','1')) or even CHAR(0) NOT NULL (w

Re: How to get mysql owner password?

Dear Jing, > Does any one of you know how to work around this problem and access "mysql" > database? 1. Kill the server (kill -9 mysqld, you will probably need to log in as OS user 'root'). 2. Start the server with the option skip-grant-tables, e. g. mysqld --skip-grant-tables. 3. Connect to th

Re: MySQL 4.0.5(a) is released

Dear Lenz, > Removed variable `safe_show_database' as it was not used anymore. What will ISPs say about this one? They use 'safe_show_database' for their MySQL setups, so their customers on virtual MySQL hosts cannot see other customers' databases. (It's more likely that you won't attack somethin

<    1   2