Re: beginner stuff; cant create database

2003-02-04 Thread Stefan Hinz, iConnect \(Berlin\)
Wiley, E:\mysqladmin create TestDB mysqladmin: CREATE DATABASE failed; error: 'Can't create database 'testdb'. (err no: 13)' Error 13 means permission denied. Check if the MySQL has write access to E:\. BTW, I don't think E:\ is a very good place to store your databases. I would recommend at

Re: datadir and socket

2003-02-04 Thread Stefan Hinz, iConnect \(Berlin\)
Fax: +49 30 7970948-3 - Original Message - From: Alex Shi [EMAIL PROTECTED] To: Stefan Hinz, iConnect (Berlin) [EMAIL PROTECTED]; mysql group [EMAIL PROTECTED] Sent: Monday, February 03, 2003 10:39 PM Subject: Re: datadir and socket Hi Stefan, Thanks a lot! With your help my issue

Re: datadir and socket

2003-02-03 Thread Stefan Hinz, iConnect \(Berlin\)
Message - From: Alex Shi [EMAIL PROTECTED] To: Stefan Hinz, iConnect (Berlin) [EMAIL PROTECTED]; mysql group [EMAIL PROTECTED] Sent: Monday, February 03, 2003 3:27 AM Subject: Re: datadir and socket There are three my.cnf you should look for: 1) /etc/my.cnf = global options 2) datadir

Re: database mirroring in mysql

2003-02-03 Thread Stefan Hinz, iConnect \(Berlin\)
: Inbal Ovadia [EMAIL PROTECTED] To: 'Stefan Hinz, iConnect (Berlin)' [EMAIL PROTECTED]; Inbal Ovadia [EMAIL PROTECTED]; [EMAIL PROTECTED] Sent: Monday, February 03, 2003 12:43 PM Subject: RE: database mirroring in mysql Hi and thanks for the reply. After I read all about replication, I have a little

Re: date issue

2003-02-03 Thread Stefan Hinz, iConnect \(Berlin\)
Daniel, (you posted this question twice, but I will only answer it once ;-) have a month string January from a get query string like so ?month=January , and i need to check a range of results within an endate so i need WHERE end_date $_GET['month'] , You could use the DATE_FORMAT() function

Re: restoring lost data

2003-02-03 Thread Stefan Hinz, iConnect \(Berlin\)
Peter, sorry to say, but I guess your data have gone to Nirvana. Is there any logs of the database commmands There is. It's called binlog (binäre update log), and you can turn it on by starting the server like mysqld --log-bin (or put log-bin in the [myslqd] section of your my.cnf / my.ini).

Re: # of connected user

2003-02-02 Thread Stefan Hinz, iConnect \(Berlin\)
Mustafa, How i list connected users(active) to mysql server? mysql SHOW PROCESSLIST; ++---+---+--+-+---+ | Id | User | Host | db | Command | Time | ++---+---+--+-+---+ | 2 | superuser | localhost | test |

Re: Making Lin/Win share DataSource

2003-02-02 Thread Stefan Hinz, iConnect \(Berlin\)
Berlin (Germany) Tel: +49 30 7970948-0 Fax: +49 30 7970948-3 - Original Message - From: JD [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: Saturday, February 01, 2003 5:18 AM Subject: Making Lin/Win share DataSource On Fri, 2003-01-31 at 06:39, Stefan Hinz, iConnect (Berlin) wrote

Re: New user on OS X

2003-02-02 Thread Stefan Hinz, iConnect \(Berlin\)
Gary, [h24-85-217-157:/usr/local/bin] garydr% mysqldump -h localhost -u root bpw_dbbpw_db_backup.sql bpw_db_backup.sql: Permission denied. This means that MySQL is not allowed to write in this directory. Which directory? ;-) Well, as you don't specify a path, bpw_db_backup.sql will be created

Re: Re: host.frm

2003-02-02 Thread Stefan Hinz, iConnect \(Berlin\)
Paul, I have the same problem, the file does exist and the ownership is the mysql user, but the entry in the log file still says it cant find this file when starting mysql daemon. And the manual said: If you don't set up the grant tables, the following error will appear in the log file when

Re: datadir and socket

2003-02-02 Thread Stefan Hinz, iConnect \(Berlin\)
Alex, However, for local connections, say connections from a locally hosted web site via PHP, or a command line connection issued from shell, it Remote connections are made through TCP/IP. That's why you get the sock error only for local connections. will return following error message:

Re: database mirroring in mysql

2003-02-02 Thread Stefan Hinz, iConnect \(Berlin\)
Inbal, Is there a possibility, in MySql, to define a mirror to my database, Yes. In MySQL, it's called replication, and it's quite easy to setup. More info: http://www.mysql.com/doc/en/Replication.html Regards, -- Stefan Hinz [EMAIL PROTECTED] Geschäftsführer / CEO iConnect GmbH

Re: TIMESTAMP field is updated unintentionally

2003-02-01 Thread Stefan Hinz, iConnect \(Berlin\)
Marco, mysql update T_ORDH set STATUS=2 where PK_ID=26272; ERSTELL_DATUM is set to the current date. I know that a timestamp takes the current time, if set it to NULL, but since I'm not touching it, it shouldn't change, should it? A quick workaround is mysql update T_ORDH set STATUS=2,

Re: partitionong MyISAM tables??

2003-02-01 Thread Stefan Hinz, iConnect \(Berlin\)
Prasanth, Is there any way to partition MyISAM tables in mysql? i have a huge table and want to partition it. An easy way to slice it into chunk would be: CREATE TABLE tblPart_1 SELECT * FROM tblFull LIMIT 0,1000; CREATE TABLE tblPart_2 SELECT * FROM tblFull LIMIT 1000,1000; CREATE TABLE

Re: Making Lin/Win share DataSource

2003-02-01 Thread Stefan Hinz, iConnect \(Berlin\)
30 7970948-3 - Original Message - From: Sherzod Ruzmetov [EMAIL PROTECTED] To: Stefan Hinz, iConnect (Berlin) [EMAIL PROTECTED]; JD [EMAIL PROTECTED]; [EMAIL PROTECTED] Sent: Saturday, February 01, 2003 2:04 AM Subject: RE: Making Lin/Win share DataSource Wow, one hell of a discussion

Re: line breaks

2003-02-01 Thread Stefan Hinz, iConnect \(Berlin\)
Tarik, - what is the stored character code of the enter key in the text field, i am figuring out to find that character and replace it with the br element, for the exact display, The character is \n (the new line character). If you use PHP and have magic_quotes=on in your php.ini, PHP will

Re: timing

2003-01-31 Thread Stefan Hinz, iConnect \(Berlin\)
Mary, The Production server has MYSQL 3.23 and an older version of MYODBC then I have. They run in 8 minutes on my test server , about 4 minutes each. Printing to a PDF driver. On the Production Server they take HOURS to run and print. Maybe this won't help too much, but I've experienced

Re: [ mysqlimport ]

2003-01-31 Thread Stefan Hinz, iConnect \(Berlin\)
Elby, I created a file.sql with mysqldump. mysqldump my_db my_table file.sql What I do to get this file with the mysqlimport? mysqlimport ?? You do this with mysql in batch mode, not with mysqldump: shell mysql your_database file.sql Regards, --

Re: Making Lin/Win share DataSource

2003-01-31 Thread Stefan Hinz, iConnect \(Berlin\)
JD, my answer may seem ridiculous, too, but with the following setup you should be able to use MySQL databases and tables both under Linux and Windows on the same machine. About the only thing you need is access to the MySQL data directory from both Linux and Windows. Regardless of the operating

Re: Question about Table_Options

2003-01-31 Thread Stefan Hinz, iConnect \(Berlin\)
Jonathan, The O'Reilly Managing Using MySQL show on page 288 a table been created with two options ...)AUTO_INCREMENT = 1, TYPE=InnoDB; But the MySQL manual says or:- table_options: TYPE = {BDB | HEAP | ISAM | InnoDB | MERGE | MRG_MYISAM | MYISAM } or AUTO_INCREMENT = # Oh, I stumbled

Re: MySql, PHP and Javascript

2003-01-31 Thread Stefan Hinz, iConnect \(Berlin\)
Steve, this list is not the right place to ask JavaScript questions. Please check out an appropriate list at http://php.net/. But, anyway, it's possible to mix JS and PHP, no problem. Regards, -- Stefan Hinz [EMAIL PROTECTED] Geschäftsführer / CEO iConnect GmbH http://iConnect.de

Re: Difference between MySQL versions

2003-01-31 Thread Stefan Hinz, iConnect \(Berlin\)
Vikram, Can someone point me to amn (exhaustive) list of features in MySQL Max that are not present in MySQL Standard? Or any other documentation that lists the differences between the two? http://www.mysql.com/products/mysql/index.html (not too exhaustive, though) Regards, -- Stefan Hinz

Re: Getting Images in and out of a Blob

2003-01-30 Thread Stefan Hinz, iConnect \(Berlin\)
Mike, Has anyone done any work with getting images into and out of a MYSQL database? I have used mysql for some time, but never stored an image in a blob field. I am curious on how to insert the image from a web form upload, and how to display the picture on another HTML page. You might

Re: mysql.sock is missing - Please....

2003-01-30 Thread Stefan Hinz, iConnect \(Berlin\)
Thomas, I installed MySQL on my server and after reboot i got the error message when starting mysql: ERROR 2002: Can't connect to local MySQL server through socket '/var/run/mysqld/mysqld.sock' (2) Is mysqld up and running? Try ps xa | grep mysqld. Regards, -- Stefan Hinz [EMAIL

Re: Error 1148 by remote mysql +execute +insert

2003-01-29 Thread Stefan Hinz, iConnect \(Berlin\)
Dirk, you're right. LOCAL is disabled by default with all newer versions of MySQL (server and client). One can enable LOCAL by _compiling_ MySQL with --enable-local-infile, but this is not possible for binaries, of course. The manual says you can enable LOCAL with --local-infile=1, either for

Re: MySQL error (Errcode: 13)

2003-01-28 Thread Stefan Hinz, iConnect \(Berlin\)
Dhanashri, ALTER TABLE `timesheet` ADD `phase_desc` VARCHAR( 50 ) Error on rename of '.\etime\timesheet.MYI' to '.\etime\#sql2-64c-19.MYI' (Errcode: 13) I had the same kind of problem with ALTER TABLE and MySQL 4.0.5 under Win2K. Errorcode 13 means it's a permission problem. I never solved

Re: my.ini

2003-01-28 Thread Stefan Hinz, iConnect \(Berlin\)
Vicente, language=spanish You could try language=c:/mysql/share/spanish. With my 4.0.7 on Win2K, both works. Regards, -- 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

Re: Help with SELECT, JOIN and WHERE query

2003-01-28 Thread Stefan Hinz, iConnect \(Berlin\)
Victor, good shot! I thought of this one in the first place: SELECT u.user_id FROM user_profile u LEFT JOIN team_member t ON u.user_id = t.user_id WHERE t.team_id 2 But unfortunately, it will yield: +-+-+ | user_id | team_id | +-+-+ |1000 | 1 | |

Re: Language errors

2003-01-27 Thread Stefan Hinz, iConnect \(Berlin\)
Vicente, How can I change my error language in SQL (MySQL)? Have I to introduce a new set-variable in my.ini? In the [mysqld] section of my.cnf / my.ini, type: language=spanish Alternatively, you can start mysqld with the --language=spanish option. Regards, -- Stefan Hinz [EMAIL

Re: Language errors

2003-01-27 Thread Stefan Hinz, iConnect \(Berlin\)
- Original Message - From: Vicente Valero [EMAIL PROTECTED] To: Stefan Hinz, iConnect (Berlin) [EMAIL PROTECTED]; [EMAIL PROTECTED] Sent: Monday, January 27, 2003 1:06 PM Subject: Re: Language errors Hi, I've tried this, but it hasn't effect. In WinMySQLadmin 1.4, section Variables, language

Re: SELECTing across a Network

2003-01-27 Thread Stefan Hinz, iConnect \(Berlin\)
Obafemi, Please can someone tell me how to run a SELECT between databases on a network. With MySQL, this is not possible. AFAIK there are no plans to implement this in the near future, or to implement this feature at all. Customers using MS SQL Server asked me the same thing, as MS SQL Server

Re: Adding a user problem

2003-01-27 Thread Stefan Hinz, iConnect \(Berlin\)
Devin, GRANT ALL PRIVILEGES ON devin.* TO dmiller@% IDENTIFIED BY password; The command returns a Query ok and 0 rows affected. However, when I try to login with dmiller (mysql -u dmiller -p) I get a 1045 Access denied error. With mysql -u dmiller -p, the hostname will be localhost (the

Re: Segmentation fault when scanning mysqld port

2003-01-26 Thread Stefan Hinz, iConnect \(Berlin\)
Manuel, Benjamin, /usr/local/mysql/3.23.55/bin/safe_mysqld: line 280: 1757 Segmentation fault And again, this looks like the SuSE bug to me. Here's my posting about an error like this on Red Hat: cite who=myself Synopsis: Server crashes on remote connection I'm not a Unix guru but I

Re: Segmentation fault when scanning mysqld port

2003-01-26 Thread Stefan Hinz, iConnect \(Berlin\)
iConnect GmbH http://iConnect.de Heesestr. 6, 12169 Berlin (Germany) Tel: +49 30 7970948-0 Fax: +49 30 7970948-3 - Original Message - From: Manuel Kiessling [EMAIL PROTECTED] To: Stefan Hinz, iConnect (Berlin) [EMAIL PROTECTED] Cc: Benjamin Pflugmann [EMAIL PROTECTED]; [EMAIL

Re: Is there anything like Query Analyser for MySQl

2003-01-26 Thread Stefan Hinz, iConnect \(Berlin\)
Scott, I was wondering, is there a program simialar to MS SQL server - Query Analyser, where you can write sql queries to query MySQl databases? It's called EXPLAIN. More info: http://www.mysql.com/doc/en/EXPLAIN.html Regards, -- Stefan Hinz [EMAIL PROTECTED] Geschäftsführer / CEO

Re: Client History

2003-01-25 Thread Stefan Hinz, iConnect \(Berlin\)
Darren, Where does the mysql client store the query history information? .mysql_history in your home directory, for example. Under Win it doesn't get stored, AFAIK. Regards, -- Stefan Hinz [EMAIL PROTECTED] Geschäftsführer / CEO iConnect GmbH http://iConnect.de Heesestr. 6, 12169 Berlin

Re: upgrade mySQL

2003-01-25 Thread Stefan Hinz, iConnect \(Berlin\)
Lewell, ERROR 1064 at line 1: You have an error in your SQL syntax. Check the manual that corresponds to your mySQL server version for the right syntax to use near 'mysql_fix_privilege_tables' at line 1 The script your speaking of is a Unix shell script, and there is nothing like that in

Re: question about date range

2003-01-25 Thread Stefan Hinz, iConnect \(Berlin\)
Chuck, select * from orderheader where orderid like '$date' ; The $date variable equals 20030124% Am I right to suppose your query doesn't work? Did you try something like: $sql = select * from orderheader where orderid like '$date'; print $sql; in your application? If have not enough

Re: Displaying news across several pages

2003-01-25 Thread Stefan Hinz, iConnect \(Berlin\)
Pag, as Rich said: select * from mytable limit 10,10 select * from mytable limit 20,10 In your PHP (?) application, you would have this like: select * from mytable limit $start,$range You could set up range (e.g. in config.inc.php) to whatever you want for the site, and you would add $range

Re: order by birthday not year

2003-01-25 Thread Stefan Hinz, iConnect \(Berlin\)
Mike, example birthday=1972/02/14 How do i tell mysql to order by the day (14) only so that I can list same birthday in a month in acending order. If your birthdays are stored in a DATE column, your example would be 1972-02-14. In this case, you can use the date functions of MySQL. Here are

Re: Windows InnoDB

2003-01-25 Thread Stefan Hinz, iConnect \(Berlin\)
Darren, Is the InnoDB table type available on Windows? Yes. If you want it to be the default table type, start the server with --default-table-type=innodb. Note that you will have to use a newer version of MySQL ( 3.23.somewhat). In 3.23.x, you will have to enable InnoDB, in 4.0.x, it's enabled

Re: Cannot connect from WInXp MYSQL server - help

2003-01-25 Thread Stefan Hinz, iConnect \(Berlin\)
Scott, most probably, you've got a glibc problem on your Red Hat box. Try upgrading to a newer version of glibc, and if the problem (mysqld dies when trying to connect from anywhere else than localhost) has gone, I was right :) (There was a very similar question a couple of days ago on this

Re: insert query

2003-01-24 Thread Stefan Hinz, iConnect \(Berlin\)
Murthy, how to insert only blank spaces into a field using insert query. Its getting trimmed off. If you are using VARCHAR for this, you're right. It's a documented behaviour of MySQL (Values are not padded; instead, trailing spaces are removed when values are stored. (This space removal

Re: updating tables

2003-01-24 Thread Stefan Hinz, iConnect \(Berlin\)
a question: i need also to change structure of the master table (have only a primary key) or the changes made on the updatable_table are enough? regards, fabrizio On Fri, 24 Jan 2003 00:10:19 +0100 Stefan Hinz, iConnect \(Berlin\) [EMAIL PROTECTED] wrote: Fabrizio, please send

Re: smallest dumpfiles in Windows in one step?

2003-01-24 Thread Stefan Hinz, iConnect \(Berlin\)
Andrew, Good morning everyone Thanks for your optimism. It's 5 o'clock in the afternoon, here in Berlin ;) I tried the following in Windows; but stopped mysqldump after the resulting file exceeded 1GB: mysqldump -q -C -uusername -ppassword dbname dbname.dmp Well, Unix seems to be so much

Re: Install on WIN2k

2003-01-23 Thread Stefan Hinz, iConnect \(Berlin\)
Norris, ERROR 2003: Can't connect to MySQL server on 'localhost' (10061) I remember this well but I don't remember what I did to fix it. Not to be impolite, but I'd say you should simply start the MySQL server :) Check system control administration services if there is a service called

Re: [ current date ]

2003-01-23 Thread Stefan Hinz, iConnect \(Berlin\)
Elby, I want to construct a table, and in this table I have a column (date type) that if I insert blank date, the MySQL automaticly insert the current date of system. You can use a TIMESTAMP column for this. If you insert NULL (or even nothing at all) it will be set to the current date and

Re: updating tables

2003-01-23 Thread Stefan Hinz, iConnect \(Berlin\)
Fabrizio, please send the table structures of table_1 and table_2 (DESCRIBE ...) so we can do more for you than just guess what the problem might be. REPLACE seems good in the first place, but if it just INSERTs then there's a problem with the (primary) keys. Regards, -- Stefan Hinz [EMAIL

Re: Install on WIN2k

2003-01-23 Thread Stefan Hinz, iConnect \(Berlin\)
- From: Norris, Joseph [EMAIL PROTECTED] To: 'Stefan Hinz, iConnect (Berlin)' [EMAIL PROTECTED]; Norris, Joseph [EMAIL PROTECTED]; Mysql_List (E-mail) [EMAIL PROTECTED] Sent: Thursday, January 23, 2003 5:20 PM Subject: RE: Install on WIN2k Stefan, I have checked these things. To re-state

Re: Problem (server crashes) with Version 3.23.54 on remoteconnections

2003-01-23 Thread Stefan Hinz, iConnect \(Berlin\)
Martin, Larry, Synopsis: Server crashes on remote connection I'm not a Unix guru but I experienced the same sympton on SuSE Linux 8.0/8.1, and I heard of people reporting the same of Red Hat Linux 7.x/8.x. MySQL runs stable, you can connect from localhost via socket and tcp/ip, but as

Re: Which is the difference?

2003-01-22 Thread Stefan Hinz, iConnect \(Berlin\)
Octavian, seems like LAST_INSERT_ID() will not always return the correct value. If you use ANSI-SQL INSERT, the function works fine. If you use MySQL extended INSERT (i.e. with more than one record per insert statement), the function will return the ID of the _first_ record inserted with an

Re: 4.1 features

2003-01-22 Thread Stefan Hinz, iConnect \(Berlin\)
Daniel, you can find a list of the new features here: http://www.mysql.com/doc/en/News-4.1.x.html Regards, -- 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 -

Re: Table joins are slow things to deal with. . .

2003-01-22 Thread Stefan Hinz, iConnect \(Berlin\)
Steve, ([Defendant] Query WITH a join - 8.79 seconds! EXPLAIN SELECT Defendants.CaseNumber FROM Defendants, Cases WHERE Cases.CaseNumber = Defendants.CaseNumber AND Filed = 1999-01-01 AND (Defendant LIKE owen% OR Defendant LIKE pitts% OR Defendant LIKE general%); First thing that comes into

Re: Indian Languages Support

2003-01-22 Thread Stefan Hinz, iConnect \(Berlin\)
Dear Velmani, what do you mean with Indian? AFAIK there are 36 languages spoken in India. Do you mean English? ;-) Regards, -- 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

Re: Which is the difference?

2003-01-22 Thread Stefan Hinz, iConnect \(Berlin\)
[EMAIL PROTECTED] To: Stefan Hinz, iConnect (Berlin) [EMAIL PROTECTED] Cc: Octavian Rasnita [EMAIL PROTECTED]; MySQL [EMAIL PROTECTED] Sent: Wednesday, January 22, 2003 7:29 PM Subject: Re: Which is the difference? Hello. On Wed 2003-01-22 at 08:53:23 +0100, [EMAIL PROTECTED] wrote: seems

Re: Joins are damn slow. . .

2003-01-21 Thread Stefan Hinz, iConnect \(Berlin\)
Steve, SQL joins are damn slow! I have a simple database of about 37,000 records in [Court Cases] and 2,000,000 records in [Defendants] (soon to be more). Please post the structures of your 2 tables (at least, the relevant parts), and the join query that gets so slow. Otherwise, we can only

Re: Copy database question

2003-01-21 Thread Stefan Hinz, iConnect \(Berlin\)
Tom, I have Database 1, table userdata, field username I need to copy the above mentioned data to: Database2, Table chat_data, field nick in phpMyAdmin 2.3.3pl1 you can accomplish this as follows: 1. Choose Database 1 in the left frame. 2. Click table userdata in the left frame. 3. Click the

Re: Whats between a varchar text ??

2003-01-21 Thread Stefan Hinz, iConnect \(Berlin\)
Craig, I want to have users give a description in a form and varchar(255) wont give me enough space so I thought I would use text(650) but it seems the 'text' type wont take the limit of (650), it simply offers the user (65535): way too much. In MySQL, you have TINYTEXT (2**8 = 256, like

Re: Mysql and Database Link

2003-01-21 Thread Stefan Hinz, iConnect \(Berlin\)
Frank, Yep Jermey are right what he says - Anyone know about using Database link in Mysql??? This is not built in. You will have to do this within your application. You can also use some of the MySQL helper apps for this, like mysqldump in combination with mysql (the command line tool), like

Re: simple windows client for mysql

2003-01-21 Thread Stefan Hinz, iConnect \(Berlin\)
Dave, I am looking for an easy to use, easy to install mysql client which would enable users to query my database. What about a web browser? It's most probably installed on all laptops. You could use some simple PHP script (not as mighty as phpMyAdmin, I would suggest) to convert SQL queries

Re: Text field question

2003-01-20 Thread Stefan Hinz, iConnect \(Berlin\)
Robyn, Could anyone please tell me how I write an SQL statement to seperate text from one field into multiple fields based on a aprticular character (i.e. tab/comma/space). For example, I have a text field containing: Text=Robyn Bailey Brisbane I understand you have all of this in just ONE

Re: query problem

2003-01-20 Thread Stefan Hinz, iConnect \(Berlin\)
Jon, Where can I look to see the Warnings? MySQL 4.1 will come with an enhanced error/warnings reporting system where you can use SHOW ERRORS and SHOW WARNINGS (see http://www.mysql.com/doc/en/SHOW_WARNINGS.html for details). If you don't have 4.1 (as most of us) you can tell the server to log

Re: How to generate my.cnf based on existing configuration?

2003-01-20 Thread Stefan Hinz, iConnect \(Berlin\)
Jannie, /etc/my.cnf. But there is no my.cnf file at that directory. So my question is:How to generate my.cnf based on existing configuration? You can see the server options for the MySQL server by issuing mysqld --print-defaults The output is pretty ugly, but it will show you all settings

Re: Is it normal?

2003-01-20 Thread Stefan Hinz, iConnect \(Berlin\)
Octavian, mysql create table test(id float); mysql insert into test values(1.123), (3.1495); mysql select * from test where id=1.123; Empty set (0.00 sec) Shouldn't this last query show me the record that has the id=1.123? Well ... 1.123 is greater than 1.123, see: mysql select id from

Re: New Beginner to List

2003-01-20 Thread Stefan Hinz, iConnect \(Berlin\)
Doll, My web server only accommodates mysql. I wouldn't say only, though :) Now, what do I need to do get this table operational for my website? I wanted to create a search program for users. Use PHP. It's easy to learn and works smoothly with MySQL. You will find lots of examples how to

Re: hot to obtain metadata on tables

2003-01-19 Thread Stefan Hinz, iConnect \(Berlin\)
Nedim, I am new to MySql. I need to obtain information about tables including the names and types of each column, the primary keys etc. SHOW TABLE STATUS; To see only tables starting with t: SHOW TABLE STATUS LIKE 't%'; http://www.mysql.com/doc/en/SHOW_TABLE_STATUS.html Regards, -- Stefan

Re: mysql

2003-01-19 Thread Stefan Hinz, iConnect \(Berlin\)
Hi, but the commnads don't work unless i have ./ infront of the command for example: mysqladmin won't work unless its written ./mysqladmin. If you're logged in as root, log out and log in as another Linux user. (I'm a Windoze fan, but AFAIK root must type ./ for command for security reasons.)

Re: A mysql php question

2003-01-19 Thread Stefan Hinz, iConnect \(Berlin\)
Ryan, this line is not correct: $line = mysql_fetch_array($result, MYSQL_ASSOC); Instead, you will need to loop through the result set, like: while($row = mysql_fetch_array($result)) { for($i=0; $i mysql_num_fields($result); $i++) { echo $row[$i]; } } You can find more info

Re: Substraction

2003-01-19 Thread Stefan Hinz, iConnect \(Berlin\)
Brian, create table test(id int unsigned); insert into test values(10); select 15 - id from test; The result is 18446744073709551611 instead of -5. Trying to confirm this with MySQL 4.0.7 on a Win2K box: mysql create table test(id int unsigned); Query OK, 0 rows affected (0.56 sec)

Re: MySQL PHP

2003-01-18 Thread Stefan Hinz, iConnect \(Berlin\)
Ryan, Eric, Did u compile PHP with mysql support enabled?as in did your configure line have something like this ./configure --with-mysql=/path/to/mysql? You can test this by writing a file (named whatever you want, I call it phpinfo.php) with one single line like this: ?=phpinfo()? Check in

Re: PRIMARY KEY

2003-01-18 Thread Stefan Hinz, iConnect \(Berlin\)
Rob, If you don't have a PRIMARY KEY and some applications ask for the PRIMARY KEY in your tables, MySQL will return the first UNIQUE key, How does any application ask for the PRIMARY KEY? Is this an ODBC call, or are their command line and built-in functions? I couldn't find this in the

Re: PRIMARY KEY

2003-01-18 Thread Stefan Hinz, iConnect \(Berlin\)
http://iConnect.de Heesestr. 6, 12169 Berlin (Germany) Tel: +49 30 7970948-0 Fax: +49 30 7970948-3 - Original Message - From: Rob Pecherer [EMAIL PROTECTED] To: Stefan Hinz, iConnect (Berlin) [EMAIL PROTECTED] Sent: Saturday, January 18, 2003 7:57 PM Subject: RE: PRIMARY KEY

Re: Authenticating users

2003-01-16 Thread Stefan Hinz, iConnect \(Berlin\)
Cesar, your PHP problem is here: $query1 = SELECT * FROM r2k_admin WHERE adminuser = $user; It's supposed to be WHERE adminuser = '$user' , because $user is a string. Regards, -- Stefan Hinz [EMAIL PROTECTED] Geschäftsführer / CEO iConnect GmbH http://iConnect.de Heesestr. 6, 12169

Re: Password problem

2003-01-15 Thread Stefan Hinz, iConnect \(Berlin\)
Neil, GRANT ALL PRIVILEGES ON newsletter.* TO newsletter IDENTIFIED BY 'testPass'; FLUSH PRIVILEGES; I then tried to access the databse via the command-line client: /usr/local/mysql/bin/mysql -u newsletter -ptestPass newsletter And I get this error: ERROR 1045: Access denied for user:

Re: Populating one table with data from another

2003-01-14 Thread Stefan Hinz, iConnect \(Berlin\)
Michael, I have a table, products containing a 944 rows. One of the fields is fgNumber, I have another table, categoryRelatedToProducts which also has an fgNumber field and currently has no data. I'd like to add all 944 fgNumbers to the categoryRelatedToProducts table. INSERT INTO

Re: How to insert entire text file in a table column

2003-01-13 Thread Stefan Hinz, iConnect \(Berlin\)
Haisam, I want to insert into content an entire text document. How do I do that without puting the entire content into a variable, let's say in perl, and then writing the INSERT statement. In MySQL, you have the LOAD_FILE() function to do this:

Re: MySQL y claves foraneas

2003-01-13 Thread Stefan Hinz, iConnect \(Berlin\)
Vicente, the language on this list is English. I will try to answer your question, anyway. The patch you're speaking of is no patch, but another table handler in MySQL. Native tables are MyISAM, and MySQL has a number of alternative tables it can handle. One of them is InnoDB. In MySQL, you can

Re: Archive and retrieval in MySQL

2003-01-13 Thread Stefan Hinz, iConnect \(Berlin\)
Ahmed, 1. How can i trigger a database archive when a certain data base limit is reached in a table. Ex: when 1,00,000 records is reached, archive to file and clean table. You will have to wait for MySQL 5.0. This version will have SQL triggers. 2. How can i restore multiple files into

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

2003-01-13 Thread Stefan Hinz, iConnect \(Berlin\)
: Victoria Reznichenko [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: Monday, January 13, 2003 2:55 PM Subject: re: Re: MySQL 4.0.7-gamma: Bugs affecting the privilege system On Wednesday 08 January 2003 22:32, Stefan Hinz iConnect \(Berlin\) wrote: Have you tried to reproduce them? Bug #1

Re: Upgrading to version 4.

2003-01-13 Thread Stefan Hinz, iConnect \(Berlin\)
Maximo, My company's website is running version 3.23.53a, and the main client that uses MySQL is PHP 4.2.3. Will mysql_connect() no longer work in PHP? Although this manual entry is talking about the C API functions, I assume PHP uses these to communicated with MySQL. Perhaps I might be

Re: Removing users

2003-01-13 Thread Stefan Hinz, iConnect \(Berlin\)
Ed, That would work but is there no way to completely remove their record? With REVOKE, you can partially or totally revoke privileges from users. What you can't do with REVOKE (in MySQL) is to erase a user completely. For this, you will have to DELETE FROM mysql.user WHERE User =

Re: MySQL LOAD_FILE problems

2003-01-11 Thread Stefan Hinz, iConnect \(Berlin\)
Herbert, Using MySQL, I have a problem where I am attempting to upload a 16.4MB file into a BLOB field, but the insert fails with a ERROR 1030: Got error 139 from table handler BLOB can store data up to 64 KB only. Use MEDIUMBLOB (up to 16 MB) or LONGBLOB (up to 4 GB). For MEDIUMBLOB, be

Re: install problem... (permissions?)

2003-01-11 Thread Stefan Hinz, iConnect \(Berlin\)
Christopher, 030111 13:41:11 /usr/local/libexec/mysqld: Can't find file: './mysql/host.frm' (errno: 13) Did you run the install_db script? If not, MySQL can't find the grant tables. See http://www.mysql.com/doc/en/Post-installation.html for details. Regards, -- Stefan Hinz [EMAIL

Re: Copying MySql database to others

2003-01-10 Thread Stefan Hinz, iConnect \(Berlin\)
, -- 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: Frank Peavy [EMAIL PROTECTED] To: Stefan Hinz, iConnect (Berlin) [EMAIL PROTECTED]; [EMAIL

Re: file permissions problem on ALTER TABLE

2003-01-10 Thread Stefan Hinz, iConnect \(Berlin\)
Dirkjan, I am using MySQL 3.23.54 on Windows XP (with SP1). Today, I encountered a weird problem: when trying to ALTER a TABLE, MySQL said that it no permissions to rename the *.myi file for that table. Last 3.23 I used was 3.23.49, and I didn't have an ALTER TABLE problem, neither on Win98,

Re: Copying MySql database to others

2003-01-09 Thread Stefan Hinz, iConnect \(Berlin\)
30 7970948-0 Fax: +49 30 7970948-3 - Original Message - From: Frank Peavy [EMAIL PROTECTED] To: Stefan Hinz, iConnect (Berlin) [EMAIL PROTECTED]; [EMAIL PROTECTED] Sent: Thursday, January 09, 2003 3:37 AM Subject: Re: Copying MySql database to others Thanks everyone for your input

Re: Resetting the auto_increment to start from 1

2003-01-09 Thread Stefan Hinz, iConnect \(Berlin\)
- Original Message - From: Paul DuBois [EMAIL PROTECTED] To: Stefan Hinz, iConnect (Berlin) [EMAIL PROTECTED]; Octavian Rasnita [EMAIL PROTECTED]; MySQL [EMAIL PROTECTED] Sent: Thursday, January 09, 2003 1:49 AM Subject: Re: Resetting the auto_increment to start from 1 At 20:39 +0100 1/8/03, Stefan

Re: Re: Load local data infile problem

2003-01-09 Thread Stefan Hinz, iConnect \(Berlin\)
Message - From: Jennifer Goodie [EMAIL PROTECTED] To: Stefan Hinz, iConnect (Berlin) [EMAIL PROTECTED]; Charles Mabbott [EMAIL PROTECTED]; 'Prathmesh J. Mahidharia' [EMAIL PROTECTED]; [EMAIL PROTECTED] Sent: Wednesday, January 08, 2003 11:21 PM Subject: RE: Re: Load local data infile problem

Re: Case Problems...

2003-01-09 Thread Stefan Hinz, iConnect \(Berlin\)
Nick, CREATE DATABASE LookAtMe; the database is created but as: lookatme This is not a bug, but a feature. By default, MySQL 4.0.x has lower_case_table_names set to 1. If you want to change this behaviour, put this in the [mysqld] section of your c:\my.cnf or c:\winnt\my.ini file, and restart

Re: remote connect crash

2003-01-09 Thread Stefan Hinz, iConnect \(Berlin\)
Dmitry, MySQL server segmentation faults when remote mysql client tries to connect on source and binary distributions. Local client connect does not cause any problems whatsoever. I had the same sort of problem with MySQL 3.23.5x servers on SuSE Linux 8.0/8.1, and some newsgroup postings

Re: Load local data infile problem

2003-01-09 Thread Stefan Hinz, iConnect \(Berlin\)
GmbH http://iConnect.de Heesestr. 6, 12169 Berlin (Germany) Tel: +49 30 7970948-0 Fax: +49 30 7970948-3 - Original Message - From: Paul DuBois [EMAIL PROTECTED] To: Stefan Hinz, iConnect (Berlin) [EMAIL PROTECTED]; Charles Mabbott [EMAIL PROTECTED]; 'Prathmesh J. Mahidharia' [EMAIL

Re: Load local data infile problem

2003-01-08 Thread Stefan Hinz, iConnect \(Berlin\)
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: Charles Mabbott [EMAIL PROTECTED] To: 'Stefan Hinz, iConnect (Berlin)' [EMAIL PROTECTED]; 'Prathmesh J

Re: Resetting the auto_increment to start from 1

2003-01-08 Thread Stefan Hinz, iConnect \(Berlin\)
Octavian, I've read the following in a MySQL book: It's a rather old book, which deals with MySQL 3.23, and not with MySQL 4.x. DELETE FROM tbl_name WHERE 1 0; In MySQL 3.23, this was a workaround to force the server to delete a table row by row. By default, 3.23 would on DELETE FROM tbl

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

2003-01-08 Thread Stefan Hinz, iConnect \(Berlin\)
: RE: MySQL 4.0.7-gamma: Bugs affecting the privilege system Hi Stefan, -Original Message- From: Stefan Hinz, iConnect (Berlin) Alexander, - After having set up both machines completely, I installed the Win32 binary distribution of MySQL 4.0.7-gamma. Although I did

Re: Copying MySql database to others

2003-01-08 Thread Stefan Hinz, iConnect \(Berlin\)
Frank, I need to copy a MySql Production database to QA. What is the best method of doing this? Do I need to write SQL queries or is there another quicker method? There are alot of possibilities to accomplish this fast. From the command line? shell mysqldump -uusername -ppassword

Re: Load local data infile problem

2003-01-07 Thread Stefan Hinz, iConnect \(Berlin\)
Prathmesh, I have just installed mysql and am facing problems with the Load data local infile problem. I went through the manual and did all that was said like including the command --enable-local-infile and --local-infile[=1], but it does not seem to work. I posted the same problem a

Re: re[2]: Backups mechanism

2003-01-07 Thread Stefan Hinz, iConnect \(Berlin\)
Richard, I agree with the post... I feel there should be an inbuilt backup routine. AFAIK there's going to be a hot backup routine build into MySQL 4.1. At this moment, my net connection has gone done, but you should find it at http://www.mysql.com/doc/en/News-4.1.0.html. Regards, -- Stefan

Re: Query mysql on another server

2003-01-07 Thread Stefan Hinz, iConnect \(Berlin\)
Paul, Dave, If I understood the initial question correctly, your first suggestion is not what he wants. I think he's talking about accessing two servers from the same connection, which is not possible: [snip] You can't write a SQL statement that refers to tables hosted by another server.

Re: LEFT JOIN function locking up when using large database

2003-01-06 Thread Stefan Hinz, iConnect \(Berlin\)
Rob, as Jennifer stated, the problem is that your query doesn't use indexes. SELECT something to select FROM table1 LEFT JOIN table2 ON (table1.ID = table2.table1_ID) WHERE some condition; some condition would be of interest here. If MySQL can't use indexes here, it will have to scan all of

Re: problem with drop table

2003-01-05 Thread Stefan Hinz, iConnect \(Berlin\)
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 under

  1   2   >