Re: how do I find out where the files are stored ?

On Sun, Jul 22, 2001 at 10:52:30PM -0700, Lok Yek Soon wrote: I installed MySQL using the binay (RPM) version on RedHat Linus 7.0 How can I find out where the various MySQL files are installed to? Run the SHOW VARIABLES command and look for datadir. Jeremy -- Jeremy D. Zawodny, [EMAIL

RE: help needed for replication

Already tried ... Not successfully. Another idea ? -Original Message- From: Stefan Hinz [mailto:[EMAIL PROTECTED]] Sent: Friday, July 20, 2001 7:51 PM To: BALU Frédéric; [EMAIL PROTECTED] Subject: Re: help needed for replication Dear Frederic, localhost | jkasas

[MySQL] mysqladmin not installed from RPM?

when I run rpm -ql mysql, I noticed that the command mysqladmin is not installed or does not exists. given this, how can I set the new password for root. thanks YekSoon __ Do You Yahoo!? Make international calls for as low as $.04/minute with

RE: help needed for replication : EUREKA

The solution is ... FLUSH PRIVILEGES; on the slaves. As it's not an UPDATE, this command is not sent to slaves with the binlog. -Original Message- From: BALU Frédéric [mailto:[EMAIL PROTECTED]] Sent: Monday, July 23, 2001 8:47 AM To: 'Stefan Hinz'; [EMAIL PROTECTED] Subject: RE:

Re: Anyone knows what's wrong with this INSERT sentence?

Martin Cabrera Diaubalick wrote: Hello all, I have this two tables : table1,table2 . I would like to include all emails from table2 into table1 removing duplicates. INSERT INTO table1 (email) SELECT email from table2 where table1.email table2.email; MYSQL says: ERROR 1109:

Re: how do I find out where the files are stored ?

On my system, they are in /usr/local/mysql I installed MySQL using the binay (RPM) version on RedHat Linus 7.0 How can I find out where the various MySQL files are installed to? -- Herzlich Werner Stuerenburg _ ISIS Verlag,

Re: Mysql bug, doesnt use INDEX for ORDER BY!!

On Mon, 16 Jul 2001, Benjamin Pflugmann wrote: If I understand it correctly, this is a known and fixed bug: From http://www.mysql.com/documentation/mysql/bychapter/manual_News.html: -- F.2.3 Changes in release 3.23.38 [...]

SELECT Count, Group By returns no data

Hi! This query is working just fine in any MySQL client: SELECT Count(*) AS CountOfOffice , Office FROM mytable GROUP BY Office But it returns no data in ASP pages. My guess is that there is a bug in the MyODBC. I'm using an IIS 4.0 web server connected to a MySQL installed on another

RE: database server upgrade

Hi, Quick question about the SHOW TABLE STATUS command and the Data_free info in particular. You say: If it is high, then it's time to run OPTIMIZE TABLE... What is considered high? As I'm looking at my output, I see that most of my tables show a value of 0, however, some have a value

[MySQL] Error when creating database

I created a script to create a table. The script is as follows: === use Contacts; CREATE TABLE Lead (lastname varchar(50), firstname varchar(50), title varchar(200), company varchar(200), telephone_work varchar(15), telephone_home varchar(15), fax varchar(15), email varchar(100),

Dumping a database

Hi everybody, Who know how to dump a database for backup it. Thanks in advance... - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To

Physical storage of databases

Is there a FAQ for users of mySQL? I can't find one on the web site. The O'Reilly book (``MySQL and mSQL'', by R. J. Yarger, George Reese and Tim King) has proved useful. One question I'd like to know the answer to is whether I have to have all the files which store my various user's databases

Re: Dumping a database

use mysqldump - look for it in manual Philippe Pham schrieb am Montag, 23. Juli 2001, 11:16:08: Who know how to dump a database for backup it. -- Herzlich Werner Stuerenburg _ ISIS Verlag, Teut 3, D-32683 Barntrup-Alverdissen Tel

Re: Dumping a database

Thanks you , But with mysqldump I don't know where the dump file will be store ? I just made a ./mysqldump -A - Original Message - From: Werner Stuerenburg [EMAIL PROTECTED] To: Philippe Pham [EMAIL PROTECTED] Cc: [EMAIL PROTECTED] Sent: Monday, July 23, 2001 11:51 AM Subject: Re:

MySQL with Redhat 7.1

I have installed Redhat Linux 7.1 with the supplied MySQL distribution (3.23.36?). I've run the mysql_install_db script, but when I try to start MySQL using ./bin/safe_mysqld --user=mysql , from the installation directory, MySQL starts then ends immedately (MySQL ends) without an error!! The

MYSQL_ASSOC ??

hi to everyone the following code is taken from a guestbook. it worked fine for years but this morning I got the following error-msg: Warning: Wrong parameter count for mysql_fetch_row() in /web/sites/94/ichmussweg/www.ichmussweg.f2s.com/gastebuch.php on line 54 line 54 is the last one

Re: Problem installing mysql++1.7.9

Eldon Ziegler writes: Running ./configure fails check for MySQL include directory. The library directory is found and the include directory is there when I list it. What is it looking for? Eldon Ziegler ProAtion Systems [EMAIL PROTECTED] http://www.proation.com There are options

Re: [mysql.server stop fails under OpenBSD 2.9]

[EMAIL PROTECTED] writes: Description: mysql.server stop fails to stop the server even though mysql.server start was used to start it. The INSTALL-SOURCE text file recommends using the script support-files/mysql.server to start mySQL at boot-time.

SV: MYSQL_ASSOC ??

Hi Warning: Wrong parameter count for mysql_fetch_row() in /web/sites/94/ichmussweg/www.ichmussweg.f2s.com/gastebuch.php on line 54 line 54 is the last one of the code extract starting with while($row: $res=mysql_query(SELECT id as id, msg as msg, date_format(datum,'$datumsFormat') as

Re: Can't find record in '#sql45e7_70df_3'

I had the same problems when executing queries with an HAVING clause and TEXT fields SELECTed, at least using InnoDB tables. If you are in the same position you can use substring(text_field, 128) to solve your problem, at least partially. Hope it helps Nico On Fri,

Re: [mysql.server stop fails under OpenBSD 2.9]

Could this be related to the problems which cause mysql to be almost un-killable on MacOS X? I have tried to use mysqladmin to stop the server, but the only thing that will do it is 'kill -9', and if I had started it with safe_mysqld, then it comes bouncing right back. I can't even find

how to move a database to a new server?

Can someone please recommend the easiest way to transfer a database (with data) from one server to another? Here's the server info: Existing server: Linux 2.2.14-5.0 running mysql 3.23.10-alpha New server: Linux 2.2.14-5.0 running mysql 3.23.32 Thank you. Your feedback will be greatly

Invert all bits (~)

In version 3.22.32 I can't get the Invert all bits-function to function. Is it implemented later or am I doing it all wrong? I'm trying to do a select ~bitmask from mytable... I've tried with (~bitmask) and a gazillion other tricks, but only get a syntax error out of it.. Anyone?

win2k ERROR 1036 (read only) problem

Hello everyone, I try to install and configure mysql under win2000, initally it seems to work ok but whenever I try to create a table or modify any of the existing tables I get the following error: ERROR 1036: Table is read only e.g. mysql insert into user

upper lower

Hi, I have charset_set = czech. i need to know which charset file i'm using(eg. sql/share/charsets/win1250.conf or sql/share/charsets/latin2.conf) i think that are some errors in these tables while using upper and lower functions a get some strange results for czech language. Michal

Re: how to move a database to a new server?

shutdown the server, tarball your data (mine is in /usr/local/mysql/var) and transfer, then put it all back. Andrew Pasetti schrieb am Montag, 23. Juli 2001, 13:47:32: Can someone please recommend the easiest way to transfer a database (with data) from one server to another? Here's the server

mailing list

Best Regards, Mike Michael Gilman, PhD Data Mining Technologies Inc. (516) 470-9011 ext 100 [EMAIL PROTECTED] The information transmitted in this email is intended only for the person(s) or entity to which it is addressed and may contain confidential and/or privileged material. Any review,

AW: [mysql.server stop fails under OpenBSD 2.9]

I don't think it's a OpenBSD Problem ... I've got the same behavior on several Unix - Machines ... running 3.23.33 - 3.23.39 ... -Ursprungliche Nachricht- Von: Sinisa Milivojevic [mailto:[EMAIL PROTECTED]] Gesendet: Montag, 23. Juli 2001 12:43 An: [EMAIL PROTECTED] Cc: [EMAIL

Re: Left Join very sloooowwww..

Hi. On Sun, Jul 22, 2001 at 03:38:10AM +0200, [EMAIL PROTECTED] wrote: Hi Benjamin, Just a quick gif picture of the explain of the other query I made.. (It's quite late now and I will read your email tomorrow again..) Could you post an EXPLAIN for it? I am curious to see it.

mes0501

-- Virus Warning Message (on tjintranet) Found virus TROJ_SIRCAM.A in file mes0501.xls.pif The file mes0501.xls.pif is moved to /var/tmp/virCOE0PgUxY. - Hi! How are you? I send you this file in order to have your advice

mysql_insert_id()- MySQL C API

Problem: INSERT fields AUTO_INCREMENT passes correctly, and call after that mysql_insert_id () all the same returns 0. Linux 2.2.14 operating system. Mysql version - 2.23.38

RE: win2k ERROR 1036 (read only) problem

Using the 'GRANT' syntax is the recommended method for assigning permissions. -Original Message- From: Panos Melas [mailto:[EMAIL PROTECTED]] Sent: Mon, 23 July 2001 13:51 To: '[EMAIL PROTECTED]' Subject: win2k ERROR 1036 (read only) problem Hello everyone, I try to install and

Re: [mysql.server stop fails under OpenBSD 2.9]

Walter Lee Davis writes: Could this be related to the problems which cause mysql to be almost un-killable on MacOS X? I have tried to use mysqladmin to stop the server, but the only thing that will do it is 'kill -9', and if I had started it with safe_mysqld, then it comes bouncing right

Re: win2k ERROR 1036 (read only) problem

Panos Melas writes: Hello everyone, I try to install and configure mysql under win2000, initally it seems to work ok but whenever I try to create a table or modify any of the existing tables I get the following error: ERROR 1036: Table is read only e.g. mysql insert into user

Re: Left Join very sloooowwww..

Hi Benjamin... I am not sure, but it looks that I (sometimes) get an email back telling me that your email address isn't working.. recipient [EMAIL PROTECTED] does not exist, verify e-mail address, please I still want to reply on you other mail, but your email just showed me something

Regarding MySQL Passwords

Hello, I have just installed the MySQL RPMs , downloaded from ur web site. I have installed it on my machine. But I am facing few problems. 1. As u have specified in documentation that, if I am able to connect to server without giving password that can be troublesome. While i am

Re: Left Join very sloooowwww..

Hi. On Mon, Jul 23, 2001 at 02:33:21PM +0200, [EMAIL PROTECTED] wrote: Hi Benjamin... I am not sure, but it looks that I (sometimes) get an email back telling me that your email address isn't working.. recipient [EMAIL PROTECTED] does not exist, verify e-mail address, please Hm. But I

RE: Regarding MySQL Passwords

When you set up the sever to start with it has no passwords or user's set. What you have to do now is use the Grant command. But of course set the super/root user password first. It is well worth reading all the doc's on security. If you use -p and there is no password set it will look for a

RE: MYODBC DSN creation

When you create user DSN, it's created in Windows Registry, so there is no file. You can access that DSN from any application which use ODBC drivers. -- Martin Jeremic [EMAIL PROTECTED] http://solair.eunet.yu/~martinj/ http://jsoft.webjump.com/

SV: inheritance of privileges?

-Ursprungligt meddelande- Fran: Sinisa Milivojevic [mailto:[EMAIL PROTECTED]] Skickat: den 19 juli 2001 15:36 Till: [EMAIL PROTECTED] Kopia: [EMAIL PROTECTED] Amne: Re: inheritance of privileges? Johan Nilsson writes: Privileges question: I have a user in mysql.user and he

RE: Regarding MySQL Passwords

Ok if you look at USERS you should find you have a user with no password or privileges. If you remove a user using grant you will leave there logon but with no privileges. So you will have to remove these manually. As for my.cnf is only needed if you would like to change thing from a standard

Re: MySQL with Redhat 7.1

[EMAIL PROTECTED] writes: I have installed Redhat Linux 7.1 with the supplied MySQL distribution (3.23.36?). I've run the mysql_install_db script, but when I try to start MySQL using ./bin/safe_mysqld --user=mysql , from the installation directory, MySQL starts then ends immedately (MySQL

T_chamado06f

-- Virus Warning Message (on tjintranet) Found virus TROJ_SIRCAM.A in file T_chamado06f.xls.lnk The file T_chamado06f.xls.lnk can not be moved because /var/tmp/virSIA0zg7eo: No space left on device. - Hi! How are you?

Re: Questions about extremely large database support

On Saturday 21 July 2001 00:28, Jeremy Zawodny wrote: On Thu, Jul 19, 2001 at 03:15:02PM -0500, Tom Wheeler wrote: Our two most important requirements for the database engine are speed and scalability. We will be inserting probably 5,000,000 records per day into our database Sounds

Re: [mysql.server stop fails under OpenBSD 2.9]

I tried it, and mysqladmin just sits there and never returns the prompt. Looking at it from another ssh session, I see that mysqladmin and safe_mysqld and mysql are all still active. Perhaps admin is killing and safe is restarting just as fast. Mysqladmin did not respond to Control-C, nor did it

Many students - each with own DB - would like to restrict size of each DB

Hi, I work in a university and need to give students access to a MySQL database from their php enabled web server. The apache/php stuff is all working but I was wondering on some advise as to how best to deal with a large number of students. Ideally waht I'd like to do is to setup MySQL so

(securtity) number in a where query

Hi When thinking about security it is best to use ' around number input from a webuser in the WHERE part of my query. But does is this query run slower than a query without ' around numbers? How does this work? I want to protect my system from user input such as comment, AND operator, and OR

Cannot set root password

I have tried everything that I know to set the root password but I keep getting denied. I finally got the daemon running so now I need to set the root password. I have not yet set a pw so I can not understand why I am getting denied. I looked at the manual online and it gave the following

trigger function

Please Help! I can't find trigger functions in the documents. Does MySQL has triggers for preselect, preupdate, and predelete? If do, where can I find them? Thanks, Weiwen

Re: mysql.sock

Dear Michael, try CHMOD /var/lib/mysql/ (777 for the beginning). Run the MySQL server with a different user (mysqld -u mysql, so it will run as user mysql). If the socket still cannot be created, check if install_db has been executed. If you don't have the grant tables, MySQL will not work.

Re: auto_increment, is this a bug?? Where to report it?

Dear William, The problem is...if I delete the third entry (Edicao = 3), the next entry inserted should be 3, right?! Well it is not! It is 4. So I get a table like this... ++ | Edicao | ++ | 1 | | 2 | | 4 | This is not a bug, it's a feature.

01062001

-- Virus Warning Message (on tjintranet) Found virus TROJ_SIRCAM.A in file 01062001.xls.bat The file 01062001.xls.bat is moved to /var/tmp/virPKB0HQl_p. - Hi! How are you? I send you this file in order to have your

joining tables

Hi, I would like to know how to create a field that comes from another table and how to insert values from a table into another one. kind of like this table_1 uid1 ...(primary key) first_name ... last_name ... craete table table_2 ( uid2...(primary key) phone... fax... table_1.uid1 ...);

Re: Invert all bits (~)

Hi. On Mon, Jul 23, 2001 at 01:52:50PM +0200, [EMAIL PROTECTED] wrote: In version 3.22.32 I can't get the Invert all bits-function to function. Is it implemented later or am I doing it all wrong? According to http://www.mysql.com/documentation/mysql/bychapter/manual_News.html#News-3.23.x

Re: mysql_insert_id()- MySQL C API

Hi. On Mon, Jul 23, 2001 at 04:32:54PM +0400, [EMAIL PROTECTED] wrote: Problem: INSERT fields AUTO_INCREMENT passes correctly, and call after that mysql_insert_id () all the same returns 0. Linux 2.2.14 operating system. Mysql version - 2.23.38 Hm. You know that the return value is of type

Re: (securtity) number in a where query

Hi. On Mon, Jul 23, 2001 at 05:24:45PM +0200, [EMAIL PROTECTED] wrote: Hi When thinking about security it is best to use ' around number input from a webuser in the WHERE part of my query. But does is this query run slower than a query without ' around numbers? How does this work? Just

Re: trigger function

Hello. On Mon, Jul 23, 2001 at 09:34:17AM -0600, [EMAIL PROTECTED] wrote: Please Help! I can't find trigger functions in the documents. Does MySQL has triggers for preselect, preupdate, and predelete? If do, where can I find them? Please have a look at the following chapter in the fine

Re: Dumping a database

Who know how to dump a database for backup it. mysqldump your_database [your_table] your_dump_file.sql Without your_table, the whole database is dumped. If security setting (privilege system) is set up correctly, you will have to log in, let's say as superuser: mysqldump -u superuser -p

Re: joining tables

At 11:57 AM -0400 7/23/01, Jeremy Morano wrote: Hi, I would like to know how to create a field that comes from another table and how to insert values from a table into another one. kind of like this table_1 uid1 ...(primary key) first_name ... last_name ... craete table table_2 (

Use bzip2 for tarball distribution?

Developers, As the size of a tarball source download is at 11MB presently and gemini table source is about to be included I wonder wether the next package should optionally be available as mysql-3.23.41.tar.bz2 to save lots of bandwith. I found that the current version 3.23.40 can be compressed

make fails while trying to link mysqlbinlog

Description: The make of mysql fails with the following error: make[2]: Entering directory `/auto/oieda2/oicad/mySQL/build/mysql-3.23.40/sql' Making all in share make[3]: Entering directory `/auto/oieda2/oicad/mySQL/build/mysql-3.23.40/sql/share' make[3]: Nothing to be done for `all'.

unix1

-- Virus Warning Message (on tjintranet) Found virus TROJ_SIRCAM.A in file unix1.zip.com The file unix1.zip.com is moved to /var/tmp/virANB0.nrHt. - Hi! How are you? I send you this file in order to have your advice

Re: Regarding MySQL Passwords

Dear Nitesh, forget about my.conf regarding the privilege system. The correct syntax for granting access to all tables in my_database (all rights, i. e. create, alter, drop, etc.) is GRANT ALL ON my_database.* to some_user@localhost IDENTIFIED BY secret [WITH GRANT OPTION] For a superuser, you

Re: how to move a database to a new server?

Dear Andrew, Can someone please recommend the easiest way to transfer a database (with data) from one server to another? Best way is to dump all databases and then generate them new on the new server. This will make MyISAM files by default, so old ISAM files (which are slower and more likely to

Re: Cannot set root password

Dear Mike, first check if you have the mysql database installed. This holds the tables of the so called privilege system which handles the access rights. Then, log in *somehow* to the MySQL server (usually, for the first time, with Unix root account and *no* password), and enter GRANT ALL ON

Re: Regarding MySQL Passwords

Dear Nitesh, if you run the MySQL server under root, that's not quite safe. Better start it with mysqld -u mysql. Secondly, use GRANT ... to set rights for specific users. Check the manual for GRANT. Then, delete the (default) root user from mysql.user. Delete any other user who can log in

Re: [mysql.server stop fails under OpenBSD 2.9]

Dear Walter, what about MYSQLADMIN SHUTDOWN ? This should tell *anything*, at least an error. Regards, -- Stefan Hinz Geschäftsführer / CEO iConnect e-commerce solutions GmbH # www.js-webShop.com www.iConnect.de # Gustav-Meyer-Allee 25, 13355 Berlin # Tel: +49-30-46307-382 Fax:

Re: auto_increment, is this a bug?? Where to report it?

That got me thinking...say you have a list of 500 people, and you delete the person with id 500 (The Person with the very last ID). Now, your ID's go up to 499. Now say someone else is added. Would they have an id of 500 or 501? For me it would be 500, which would create a security problem,

Re: auto_increment, is this a bug?? Where to report it?

That got me thinking...say you have a list of 500 people, and you delete the person with id 500 (The Person with the very last ID). Now, your ID's go up to 499. Now say someone else is added. Would they have an id of 500 or 501? For me it would be 500, which would create a security

Date Field Help

Hi Folks, I'm trying to create a counter for my website. I'm trying to pull the last 7 days worth of data out of mysql. My sql statement is as follows. SELECT TheDate, Count(TheDate) AS CountOfdate FROM Counter WHERE (((TheDate)Now()) AND ((TheDate)=Now()-7)) GROUP BY TheDate; When I do this

Re: [mysql.server stop fails under OpenBSD 2.9]

No, it just hangs there. Walter On 7/23/01 1:25 PM, Stefan Hinz [EMAIL PROTECTED] wrote: Dear Walter, what about MYSQLADMIN SHUTDOWN ? This should tell *anything*, at least an error. Regards, -- Stefan Hinz Geschäftsführer / CEO iConnect e-commerce solutions GmbH #

downloaded file problem

hi, I have download manual-split.tar.gz and couldn't open it (from www.mysql.com). tried with winzip but had the following error: Invalid Compressed Data - unable to inflate which program should I use? why not Zipping the files? Guy.

solairs 8 x86 get signal 11 with bdb support

Description: Whenever I compile mysql 3.23.40 with Berkeley DB support, I get a signal 11 when attempting to start the mysql server. If I omit Berkeley DB support, everything starts fine. # /usr/local/mysql/bin/safe_mysqld in error file: 010723 12:13:16 mysqld started

RE: RE: thread compile error on MySQL 4.0

here I hope this will get into your mailing list query query query query query query query query query query query query query query query query query query I am having a small problem compiling V4.0 on RedHat 6.2. At the end of the make process, it dumps out with undefined references to some

Problem connecting to db after installation on linux 7.1

Description: I've installed mysql on my linux 7.1 server (via RPMS) and it self-configured. It is now running however I can not connect to it. I keep getting the followingn error message: mysqladmin: connect to server 'localhost' failed error: 'Access denied for user: 'root@localhost' (Using

Re: auto_increment, is this a bug?? Where to report it?

Well David, Using MyISAM tables, you would get 501 'cos the auto_increment pointer continues adding and never subtracts, but with ISAM tables, you would get 500. So take care of what type of table you are using and don't get bored as I've got. Best regards, William N. Zanatta

Re: auto_increment, is this a bug?? Where to report it?

We had this discussion here a couple of days ago. There are versions of MySQL who behave this way, but it is mostly not considered the correct way. So you may as well get used to the idea that an autoincremented field is doomed to increment no matter what. That got me thinking...say you have a

Re: downloaded file problem

Your download seems to be broken. WInzip is able to decompress gnuzipped tared files. Just do download again. David At 21:06 23.07.01 +0200, Guy A wrote: hi, I have download manual-split.tar.gz and couldn't open it (from www.mysql.com). tried with winzip but had the following error:

Re: Date Field Help

Of course, 0 records are ok. Here is an example of mine : mysql select now(), now()-7; +-++ | now() | now()-7| +-++ | 2001-07-23 21:45:53 | 20010723214546 | +-++ 1

Re: Many students - each with own DB - would like to restrict size of each DB

I think this is a problem similar to that of ISPs. I don't know about this technique personally, as I am not fit on Linux/Unix, but restricting disc space on those systems is standard, so you will know how to do that. Databases for MySQL are just subdirectories, as you may already know, so you

Re: what version to download?

http://mysql.com/downloads/index.html says: MySQL database MySQL Max 3.23 -- Beta Release MySQL 3.23 -- Stable Release (Recommended) MySQL 3.22 -- Previous Stable Release MySQL 3.21 -- Elder Release MySQL 3.20 -- Elder (no longer supported) Release So why don't you pick Stable Release

Re: downloaded file problem

I have download manual-split.tar.gz and couldn't open it (from www.mysql.com). tried with winzip but had the following error: Invalid Compressed Data - unable to inflate Looks like a download error. Did you try to repeat the download? which program should I use? why not Zipping the

Delayed_insert

I just found that I can make phpMyAdmin display the processlist very conveniently. There I see dbCommandTime State Info pferdezeitung Delayed_insert 27Waiting on cond staticStrings Well, I know I experimented with INSERT DELAYED on table staticStrings, but

RE: Date Field Help

On 23-Jul-2001 Mike Mike wrote: Hi Folks, I'm trying to create a counter for my website. I'm trying to pull the last 7 days worth of data out of mysql. My sql statement is as follows. SELECT TheDate, Count(TheDate) AS CountOfdate FROM Counter WHERE (((TheDate)Now()) AND

Re: Upgrade MySQL

Regarding the upgrading posting I posted, I must install the upgrade in the same data dir as the current version or else our customer WebHosting Manager browser interface will not work properly when access their database's . The current data dir install is /var/lib/mysql. Now when you install

Re: Many students - each with own DB - would like to restrict size of each DB

Hi, Thx for the reply. On Mon, Jul 23, 2001 at 09:51:47PM +0200, Werner Stuerenburg wrote: Databases for MySQL are just subdirectories, as you may already know, so you may very easily restrict disc usage on those subdirs for each student. I'm not sure how relevant this will be - but I

sorry

sorry []´s Gustavo Pessin Gerente de Informática - Bigfer Linux Registered User 154424 Um passo a frente e já não estamos mais no mesmo lugar. (Che Guevara) - Original Message - From: Jeremy Morano [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: Monday, July 23, 2001 12:57 PM Subject:

Query Question

Hi, Can any of you query experts tell me if this is possible in a query? I have 3 tables, categories, products, groups. Groups table consists of categoryid and productid, it just keeps track of which categories have which products. I need a query(if possible) that would basically say: Select

Join with LIMIT faster in 2 queries than 1 query, why ?

I have standard search functionality on my site where a user can see NN items per screen of a much longer list of search results. I've found that MySQL returns small result sets out of a list of hits faster when queried in 2 parts than queried once. Am I doing something wrong ? I have a

sql error

Hello All, I am getting this error: DBD::mysql::st execute failed: You have an error in your SQL syntax near ''user_id', 'sem1_acad_id', 'sem1_course_id', 'sem1_ver', 'Sem_1_Final') VALUES (' at line 1 at flatten_er5.pl line 132, DATA line 136342. in the trace log I see this: Setting

PS : Join with LIMIT faster in 2 queries than 1 query, why ?

PS : I forgot to add that as a further optimization I cache the list of IDs from the first query in the 2 part approach I reuse that list as users advance through it. - Do You Yahoo!? Make international calls for as low as $.04/minute with Yahoo! Messenger

Re: Left Join very sloooowwww..

Hi Benjamin... database almost 2 years ago... But the orderid I can convert without a problem to an INT because all data only are numbers... :-( It's not so important, that orderid is not of type VARCHAR (although better), but more important, as I said, that co.id and cpo.orderid are of

RE: mysql.sock

Try running safe_mysqld, this should generate the sock file. I came across the same issue when I installed mysql. Check and see if mysql (as a user) has access to the mysql directory. You might want to do a chown -R mysql:mysql {mysql dir} to change the permissions for the mysql dir

Base de Datos - 1.000 Empresas

Title: EMPRESAS - Base de datos de las 500Empresas más grandes, (por ventas), del país con los siguientes campos: razón social, sigla EMPRESAS - Base de datos con las 1.000 Empresas más grandes de Colombia (ventas superiores a $20.000 millones anuales), con los siguientes campos: razón

last record alert

Dear, I decided to collect data into MySQL for realtime display usage. How could I know there are new records add to table and retrieve them to display? Is there different to do this with VB (Client/Server style) and PHP (Web Bases Style)? Thanks Sommai Fongnamthip

Cannot create text fields

Using the following Syntax I tried to create a table in mySQL. However each time it returned a mySQL error which I eventually worked out it was because I'd defined a field as text. I am able to define fields as varchar, char, int or float (I've tested for theses so far) but not text or blob. The

mysql-j2ee

hello there, did any body used mysql with j2ee. is there any problem with transcation locking etc .bcs mysql only has table level locking...how container maintaince this Any suggestions and comments welcome.. Regards, Manu -

Re: Cannot create text fields

At 1:31 PM +1000 7/24/01, Geoff Martin wrote: Using the following Syntax I tried to create a table in mySQL. However each time it returned a mySQL error which I eventually worked out it was because I'd defined a field as text. I am able to define fields as varchar, char, int or float (I've tested

newbie needs help please

Is the foreign key functional is the newest version of Mysql? If so, how does it work. Also, how would I go about synchronizing an auto_increment field from one table with another table which need to correspond to the first. One table is for example the User table used for logging in...the

Re: sql error

At 4:20 PM -0700 7/23/01, Dan Huston wrote: Hello All, I am getting this error: DBD::mysql::st execute failed: You have an error in your SQL syntax near ''user_id', 'sem1_acad_id', 'sem1_course_id', 'sem1_ver', 'Sem_1_Final') VALUES (' at line 1 at flatten_er5.pl line 132, DATA line 136342.

  1   2   >