root password setting error, can you help?
Hi, How do I set the root password after installing MySQL server and client? I followed the after installation instructions,@they don'T work. mysqladmin -p password 'new-password' I don't get it. Thx for helping JP __ Do You Yahoo!? Get personalized email addresses from Yahoo! Mail - only $35 a year! http://personal.mail.yahoo.com/ - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: Replication
On Thu, May 31, 2001 at 09:18:48PM +0200, Warren van der Merwe wrote: Hi there I have three sites, each runnin MYSQL. I want to replicate the data between all three. I know I cannot do this with the standard replication in MYSQL, because all three sites will add their own records and the manual says the slave cannot insert entries it's self. Actually, you can do that with replication. You just have to get it right. :-) Think of it as a replication ring. Imagine 3 servers: A, B, and C. B is a slave of A. C is a slave of B. A is a slave of C. You can insert a record into one, and it will make it to the other two. The server-id in the binary log prevents this setup from causing an infinite loop. The trick is making sure that you don't have inserts which try to stomp on each other. Generally this means that you can't use AUTO_INCREMENT columns without taking extra precautions. You need to ensure that server A can't generate the same ID that any other server would generate. If this isn't obvious (not sure how much you already know about replication), just say so. We can go into more detail. Jeremy -- Jeremy D. Zawodny, [EMAIL PROTECTED] Technical Yahoo - Yahoo Finance Desk: (408) 349-7878Fax: (408) 349-5454Cell: (408) 439-9951 MySQL 3.23.29: up 6 days, processed 41,479,099 queries (73/sec. avg) - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: Data Replication
On Thu, May 31, 2001 at 11:25:08PM -0500, Duane Stark wrote: Hello all! I have two servers (both running mysql and freebsd) .. I also have data replication setup on them.. My question to you is this.. Both servers are phyiscally located in different locations.. a) When the data is replicated between the two servers, is it encrypted? It is not. b) if not, what's the easiest way to encrypt it? Using an SSH tunnel. It's mentioned here: http://www.mysql.com/doc/S/e/Security.html but not in very concrete terms. You might search the mail archives. Using SSH to tunnel MySQL connections is a pretty popular topic. Perhaps a manual patch is in order, too... (Just need to find the time.) Jeremy -- Jeremy D. Zawodny, [EMAIL PROTECTED] Technical Yahoo - Yahoo Finance Desk: (408) 349-7878Fax: (408) 349-5454Cell: (408) 439-9951 MySQL 3.23.29: up 6 days, processed 41,554,722 queries (73/sec. avg) - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: root password setting error, can you help?
They do work. Just need to follow instruction a little more closely, though I will agree with, the instructions do trip up many beginners. Remove the -p switch. It is only used if you have already set a password but since you haven't ... Also quotes around new-password aren't required. - Original Message - From: Jean-Philippe Durrios [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: Friday, June 01, 2001 14:21 Subject: root password setting error, can you help? Hi, How do I set the root password after installing MySQL server and client? I followed the after installation instructions,@they don'T work. mysqladmin -p password 'new-password' I don't get it. Thx for helping JP __ Do You Yahoo!? Get personalized email addresses from Yahoo! Mail - only $35 a year! http://personal.mail.yahoo.com/ - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: sessions problems
Thanks, Will try that out. Adrian On Thu, 31 May 2001, g_gosho wrote: You can try this link: http://www.bonev.com/s there is PHP session handling librarary and documentation how to use it - Original Message - From: Adrian D'Costa [EMAIL PROTECTED] To: php general list [EMAIL PROTECTED] Cc: Mysql Mailing List [EMAIL PROTECTED] Sent: Wednesday, May 30, 2001 10:22 PM Subject: sessions problems Hi, I am trying to use session instead of cookies as my targeted customers are either behind a firewall or disable cookies. My system php 4.0.1pl2 rh 7.0 What would be the best way to use a session. I a database to store the session id and then delete it on exit or expiry. I hope someone can help me? I start of by registering a session in session.php ? session_start(); ? I pass the session id using a href=test.php??=$SID?Click here/a This works fine. I do not want any one to go to the test.php with out a proper session id. In the test.php I have: ? session_start(); ? Some html text and a log out link. I do I test that the session id created in session.php is the same as the one in test.php. If it is wrong I want the viewer to go back to the sessions.php page and then come to the test.php. In the logout.php I have: ? session_destroy(); ? According the manual this should destroy all sessions. I get any error saying that the session what not started and cannot be destroyed. So I added ? session_start(); session_destroy(); ? No errors but, if I use the url in the browser's history I still can go to the test.php page which I don't want. Regards Adrian - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
MySQL-DBI-perl-bin , error
Hi, Thx Rolf for your help I did setup the password Now, I have installed the RPM called mysql-DBI-perl-bin...rpm But when I want to install the MySQL-bench...rpm it asks me for the MySQL-DBI-perl..rpm Can someone tell me how to solve this probem? thx JP __ Do You Yahoo!? Get personalized email addresses from Yahoo! Mail - only $35 a year! http://personal.mail.yahoo.com/ - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Crossdatabase queries
Hello, I have a following problem: I created two simple tables and a query that uses both of them. This works perfectly. See the example below. The question is: is the same query possible when the two tables are located in diffrent databases. What I mean: Is it possible to write a crossdatabase queries in MySQL? thank you in advance Adam create table FIELD_DESC ( field_id SMALLINT NOT NULL, description VARCHAR (80), PRIMARY KEY (field_id) ); insert into FIELD_DESC (field_id,description) values (1,Description of the field \First name\ on the user registration page); insert into FIELD_DESC (field_id,description) values (2,Description of the field \Last name\ on the user registration page); create table FIELD_TXT ( language_id SMALLINT NOT NULL, field_id SMALLINT NOT NULL, text_value VARCHAR(30), PRIMARY KEY (language_id,field_id) ); insert into FIELD_TXT (language_id,field_id,text_value) values (1,1,Vorname:); insert into FIELD_TXT (language_id,field_id,text_value) values (2,1,First name:); insert into FIELD_TXT (language_id,field_id,text_value) values (1,2,Nachname:); insert into FIELD_TXT (language_id,field_id,text_value) values (2,2,Last name:); SELECT fd.description, ft.text_value FROM FIELD_DESC fd, FIELD_TXT ft WHERE fd.field_id = ft.field_id; - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
mysqlhotcopy ..
i have no idea on how to run mysqlhotcopy in the query tool
or it is not suppose to run in query
tool.
is this correct ?
mysqlhotcopy db_name
'/downloads/backupDB/'
if i want it to backup in my c:\downloads\backupDB
folder ??
/---\
Confidential and/ or privileged information may be contained in this
e-mail and any attachments transmitted with it ('Message'). If you are
not the addressee indicated in this Message (or responsible for
delivery of this Message to such person),you are hereby notified that
any dissemination, distribution, printing or copying of this Message or
any part thereof is prohibited. Please delete this Message if received
in error and advise the sender by return e-mail. Opinions, conclusions
and other information in this Message that do not relate to the
official business of this company shall be understood as neither given
nor endorsed by this company.
This mail is certified Virus Free by *ProtectNow! (InternetNow Sdn Bhd)
*Scanner Engine powered by Norman Virus Control
\--/
-
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/ (the list archive)
To request this thread, e-mail [EMAIL PROTECTED]
To unsubscribe, e-mail [EMAIL PROTECTED]
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Urgent:MySql problem
Hello, I am working on RH Linux 7.0 MySql is not working at all. My MySql files are under /usr/bin. It gives the following error on running any mysql command Can't connect to localMySql server through socket 'var/lib/mysql/mysql.sock'(111) Please Help me. Thank You Sachin
Re: What's the best os?
JZ On Fri, Jun 01, 2001 at 01:45:24AM -0400, David Freeman wrote: The server is a quad xeon lh4, it will host a web site written in php, and using a mysql database which holds 125,000 squ's and descriptions. The server's only job is to host this site. JZ Assuming you'll use Apache 2.x one day, I'd lean away from FreeBSD JZ until the threading issues are resolved. I could envision you running JZ 1 threaded MySQL server and 1 threaded Apache server. Under FreeBSD JZ (today), you'd have 2 idle CPUs and 2 busy CPUs because it'd never JZ spread the threads from each server across the CPUs the way you'd JZ like. AFAIK you can compile mysql on FreeBSD with LinuxThreads (they have been ported on FreeBSD). In this case threads will spread across the CPUs as on Linux. -- -=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=- | Ilya Martynov (http://martynov.org/)| | GnuPG 1024D/323BDEE6 D7F7 561E 4C1D 8A15 8E80 E4AE BE1A 53EB 323B DEE6 | | AGAVA Software Company (http://www.agava.com/) | -=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=- - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: help!!!!
What OS? Where do you enter the commands to install mySQL?? I know it's a stupid question, but please, enlighten me. - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Newbie querry................
Hello everybody, I am learning sql but i am not new to programming. I have a small problem, any help on this will be great. :) I have table name category,..with the following details SQL desc category; NameNull?Type --- LANGUAGE_ID NOT NULL NUMBER(3) CATEGORY_ID NOT NULL NUMBER(3) CATEGORY_NAME NOT NULL VARCHAR2(50) the language_id of this table is related to another table named language...which has the following details SQL desc language; NameNull?Type --- LANGUAGE_ID NOT NULL NUMBER(3) LANGUAGE_NAME NOT NULL VARCHAR2(50) when I am retriving language_id from category tableI get a number, instead of the number I want to get the language name from the language table. Thanks in advance Vinay Talwar [EMAIL PROTECTED] [EMAIL PROTECTED] - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
char() problem
database,sql,query Hi! I really need to know this: I have a column defined as char(2), default 'no', not null. When I create new entry into the table, I skip entering value into mentioned column because I expect to be filled with the default value, that is 'no'. But that doesn't happen! Why? Thanks! Bye
Trouble with select! Please Help!!!
On Fri, 1 Jun 2001 11:38:05 +0200 Toth Dalibor [EMAIL PROTECTED] wrote: database,sql,query Hi! I really need to know this: I have a column defined as char(2), default 'no', not null. When I create new entry into the table, I skip entering value into mentioned column because I expect to be filled with the default value, that is 'no'. But that doesn't happen! Why? Thanks! Bye -- --- Regards Dimiter Atanasov TRTechnologies office phone ++359 2 9 816 454 Celular ++359 88 694 733 URL: http://www.need.bg e-mail: [EMAIL PROTECTED] - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Trouble with select! Please Help!!!
Hello to all! I'm useing MySql 3.23.33 for unknown-freebsdelf4.2 when i trt to select anything from command line mysql select * from base.table where name like '%%'; i resieve many unuseful results (all DB) it happends with diferent words it does not matter in what kind of encoding i do this Any ideas how to fix this? - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
How to Configure MySQL with JRUN
We want to Configure MySQL database to JRUN as a jdbc datasource (Native). If Anybody knows ,Please give reply. _ Chat with your friends as soon as they come online. Get Rediff Bol at http://bol.rediff.com - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
I'm after an mysql_info() example
After reading the manual and doing vaious searchs around the net, I'm damned if I can work out the syntax for mysql_info(). Could anyone give me an example please? feelin' a bit dumb Howard Picken (Server, SQL, Query... etc) [EMAIL PROTECTED] - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: I'm after an mysql_info() example
On Fri, Jun 01, 2001 at 09:26:08PM +1000, Howard Picken wrote: After reading the manual and doing vaious searchs around the net, I'm damned if I can work out the syntax for mysql_info(). Could anyone give me an example please? In what programming language? Greetz, Peter. - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: I'm after an mysql_info() example
Using PHP4 and Mysql After reading the manual and doing vaious searchs around the net, I'm damned if I can work out the syntax for mysql_info(). Could anyone give me an example please? feelin' a bit dumb Howard Picken (Server, SQL, Query... etc) [EMAIL PROTECTED] - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
InnoDB website is now at www.innodb.com
Sorry, the website is now at www.innodb.com It should redirect users from www.innobase.fi, but that does not seem to work now. Thank you for the notice. Heikki Innobase Oy At 04:44 PM 5/31/01 -0700, you wrote: On Tue, May 22, 2001 at 07:26:40PM +0300, Heikki Tuuri wrote: Hi! I wrote a short new section 9 to the InnoDB manual at http://www.innobase.fi Hm. The vritual server hosting that appears not to be configured correctly. Is there another name the server is known by? Jeremy -- Jeremy D. Zawodny, [EMAIL PROTECTED] Technical Yahoo - Yahoo Finance Desk: (408) 349-7878Fax: (408) 349-5454Cell: (408) 439-9951 MySQL 3.23.29: up 6 days, processed 39,710,147 queries (73/sec. avg) - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: Some minor MySQL v.3.23.38 fixes and Help corrections
Roberto de Martin Serqueira writes:
Hi
I'm forwarding you the attached file MYSQL_3.23.38_FIXES.ZIP which contains files
with some minor improvements
and fixes done by me, updated to MySQL version 3.23.38, and presenting the following:
- Directory \LIBMYSQL:
- file ERRMSG.C: included section of code with client error messages translated
also to Portuguese idiom
(only German and English before), being controlled by the definition or not of
keyword PORTUGUESE
in files GLOBAL.H or MY_GLOBAL.H . The default idiom remains English, of course.
- file LIBMYSQL.DEF: added exportation statements for functions
mysql_change_user, mysql_character_set_name
and mysql_real_escape_string, which were missing and so not present in
LIBMYSQL.DLL. The list of exportations
of MySQL functions was also ordered alphabetically in that file for easy
visual localization.
- Directory \SHARE\PORTUGUESE:
- files ERRMSG.TXT and ERRMSG.SYS: all translations of error messages to
Portuguese idiom were revised,
completed and/or improved and are tracking now exactly the current English
version (several string length formats
were old).
Notes for correction of MySQL HELP FILES v.3.23.38
- The descriptions of use of MySQL API functions mysql_odbc_escape_string,
mysql_refresh and
mysql_thread_safe (not mysql_thread_save, as referenced wrongly somewhere else in
help file) are missing.
- The description of MySQL API function mysql_fetch_row presents the following
prototype:
MYSQL_ROW mysql_fetch_row(MYSQL_RES *result), but the correct one is
MYSQL_ROW * mysql_fetch_row(MYSQL_RES *result) (missing pointer indication in
returned result)
- There is no indication in description of MySQL API function mysql_reload, that it
is pertinent only to
MySQL C API but that it doesn't exist in MySQL API provided by LIBMYSQL.DLL (but
could be implemented by
function mysql_refresh and the corresponding GRANT parameter).
I hope these fixes and observations can be of some value to improve even more the
excellent MySQL Project.
Regards,
Roberto de Martin Serqueira
Hi!
Mailing list manager has stripped your attachments.
Please make a single zip file and upload it to:
ftp://support.mysql.com:/pub/mysql/Incoming
and let us know a file name.
Thanks in advance.
Regards,
Sinisa
__ _ _ ___ == MySQL AB
/*/\*\/\*\ /*/ \*\ /*/ \*\ |*| Sinisa Milivojevic
/*/ /*/ /*/ \*\_ |*| |*||*| mailto:[EMAIL PROTECTED]
/*/ /*/ /*/\*\/*/ \*\|*| |*||*| Larnaca, Cyprus
/*/ /*/ /*/\*\_/*/ \*\_/*/ |*|
/*/^^^\*\^^^
/*/ \*\Developers Team
-
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/ (the list archive)
To request this thread, e-mail [EMAIL PROTECTED]
To unsubscribe, e-mail [EMAIL PROTECTED]
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: Can get safe_msqld to run in background!!
Joseph Bueno writes:
Hi,
[EMAIL PROTECTED] wrote:
I know this is bound to be something REALLY simple, but I can't seem to get
safe_mysqld to run in background (Solaris 7/MySQL 3.23.37)
If I try, as the root user, to start safe_mysqld from the /usr/local/mysql
directory thus...
./bin/safe_mysqld --user=mysql
...I get the following message...
[1] + Stopped (SIGTTOU)./bin/safe_mysqld --user=mysql
^
This means that the process (safe_mysqld) is blocked because it is trying
to write some message to your terminal while it is running in background.
You should try something like :
./bin/safe_mysqld --user=mysql /tmp/safe_mysqld.log 21
Regards
--
Joseph Bueno
NetClub/Trader.com
Hi!
A diagnosis is quite correct, only MySQL daemon does not write
anything to console or stdout or stderr.
It is probably a problem with mismatched version of MySQL for that
Solaris.
Regards,
Sinisa
__ _ _ ___ == MySQL AB
/*/\*\/\*\ /*/ \*\ /*/ \*\ |*| Sinisa Milivojevic
/*/ /*/ /*/ \*\_ |*| |*||*| mailto:[EMAIL PROTECTED]
/*/ /*/ /*/\*\/*/ \*\|*| |*||*| Larnaca, Cyprus
/*/ /*/ /*/\*\_/*/ \*\_/*/ |*|
/*/^^^\*\^^^
/*/ \*\Developers Team
-
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/ (the list archive)
To request this thread, e-mail [EMAIL PROTECTED]
To unsubscribe, e-mail [EMAIL PROTECTED]
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: problem wtih mysql GUI
D. Veerasamy writes:
Dear Sir/ Madam
Can you please help me with the GUI client running under linux.
I'm having an error message saying:
Can't connect to local MySQL server through socket (111)
Thanking you.
-
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/ (the list archive)
Hi!
Beside Ralf's comments, please follow the instructions from the
README, here is the relevant excerpt.
When you start it for the first time, click on ``Options'' button, fill up
all entries correctly and click on ``Save'' button. From then on, you will
logon automatically to the running server on every mysqlgui startup.
Take care to put the right value in ``Ask for password'' button. Also, if
you have problems with location of socket files on *nix, enter a full path
of the socket file in the ``SQL command on the start-up''. This input field
is used on Windoze if you wish to specify that named pipe option.
Regards,
Sinisa
__ _ _ ___ == MySQL AB
/*/\*\/\*\ /*/ \*\ /*/ \*\ |*| Sinisa Milivojevic
/*/ /*/ /*/ \*\_ |*| |*||*| mailto:[EMAIL PROTECTED]
/*/ /*/ /*/\*\/*/ \*\|*| |*||*| Larnaca, Cyprus
/*/ /*/ /*/\*\_/*/ \*\_/*/ |*|
/*/^^^\*\^^^
/*/ \*\Developers Team
-
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/ (the list archive)
To request this thread, e-mail [EMAIL PROTECTED]
To unsubscribe, e-mail [EMAIL PROTECTED]
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: Bug in my sql ......mysql.exe?
Hi, I donot think it is supposed to show the number of rows deleted or it should not show anything at all.I agree if it is not a bug,at least it is an unwanted thing . When it always shows the affected number of rows as zero though it actually deletes a million records,it must be removed or made oK REgards, Ravi --- Adrian D'Costa [EMAIL PROTECTED] wrote: Ravi, That is not a bug. It works like that. I use linux the same here. Adrian On Thu, 31 May 2001, VVM Ravikumar Sarma Chengalvala wrote: Hi, i) I am using mysql.exe. ii) I could observe a small bug.Whenever I use a delete or update command,it always gives a message on my console window stating that zero rows affected.Ofcourse the actual statement works fine.Only the post command message on console window misleads me many times. Regards, Ravi Do You Yahoo!? Get your free @yahoo.co.uk address at http://mail.yahoo.co.uk or your free @yahoo.ie address at http://mail.yahoo.ie Do You Yahoo!? Get your free @yahoo.co.uk address at http://mail.yahoo.co.uk or your free @yahoo.ie address at http://mail.yahoo.ie - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: ACT2 Conversion
Hi guys, Are we talking about Symantec's ACT product? Cheers, Mikel Rolf Hopkins wrote: I've never heard of ACT2 but if you can export the data to a delimited text file, you could import it into mysql. You may have to edit the file a bit though. - Original Message - From: James McLaughlin [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: Friday, June 01, 2001 4:03 Subject: ACT2 Conversion Has anyone had any luck or seen any HOWTO docs for converting a ACT2 DB to MySQL? We are moving away from prop windows software and into web based DB administration. Any help would be terrific. THanks Kat - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Alternative for storing results...
Hi. I'm using the C API to access mySQL database (trying to reuse a lot of existing software, mixing an old database mySQL, but it's not the point). Due the way the old database (named Ideafix) run the keys sometimes the translated query produce too many rows (running out ot memory) although I need just one. I would like to know if there's any way to get one row at a time returning quickly (not efficient, of course) but it would work. How I would must to do this ? By now I use: result = mysql_store_result(connection); row = mysql_fech_row(result); ... Thanks. Regards. [EMAIL PROTECTED] ARGENTINA. - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
RE: Problem running old database with 3.23.30-gamma
Tried that. mysql ALTER TABLE Craft type=MYISAM; ERROR 1016: Can't open file: 'Craft.ISD'. (errno: 138) I have tried to run the mysql_convert_table_format script but I can't find any examples and I cannot get it to work either. I'm quite sure it's operator error in this case. We have pulled the database off the tape onto three different machines and it runs fine everywhere but this one. I have re-extracted on this machine several times. I don't think the tape is bad, it works fine elsewhere. I don't think the extraction is the problem, I've done it several times here and the same way as elsewhere. I know I must be missing something - - I just can't figure out what! Bev -Original Message- From: Rolf Hopkins [mailto:[EMAIL PROTECTED]] Sent: Thursday, May 31, 2001 9:34 PM To: Beverly Baird; [EMAIL PROTECTED] Subject: Re: Problem running old database with 3.23.30-gamma What if you did try upgrading myism tables? I remember reading something about ism tables not being supported in the future anyway. - Original Message - From: Beverly Baird [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: Friday, June 01, 2001 2:33 Subject: Problem running old database with 3.23.30-gamma Hello, I have a database, called mace, that was collected under 3.21.?? It runs under 3.22.26a It runs under 3.23.28-gamma But what I need it to function with is 3.23.30-gamma When I try to run with 3.23.30-gamma I get the following: % mysql mace Reading table informatin for completino of table and column names You can turn off this feature to get a quicker start up with -A Didn't find any fields in table 'Contact' Didn't find any fields in table 'Craft' Didn't find any fields in table 'CraftActiveSensor' Didn't find any fields in table 'DataType' Didn't find any fields in table 'Environmental' Didn't find any fields in table 'NasSensor' Didn't find any fields in table 'Navigation' Didn't find any fields in table 'NonAcoustic' Didn't find any fields in table 'RawData' Didn't find any fields in table 'Sensor' Didn't find any fields in table 'RawData' Didn't find any fields in table 'Wavetrain' Welcome to the MySQL monitor. Commands end with ; or \g. Your MySQL connection is is 637 to server version 3.23.30-gamma Type 'help;' or '\h' for help. Type '\c' to clear the buffer. mysql If I start with a different database and then type mysql use mace; I get the same Didn't find any . . . . messages. If I type show tables; it displays all the tables happily. But queries yield mysql select count(*) from Craft; ERROR 1016: Can't open file: 'Craft.ISD'. (errno: 138) At first I thought it was an ISD, ISM / MSD, MSI problem. But the fact that I can install the same database on different machines (sparc and linux) and it works under 3.22. and 3.23. databases makes me think that's not the problem. (I believe the switch to MyISAM was at 3.23?) And it's supposed to be backwards compatible, and seems to be. The machine that is the problem is a linux box running RedHat 6.2. Thanks in advance Beverly Baird Digital System Resources 703-263-2849 [EMAIL PROTECTED] - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
BACKUP/RESTORE speed and delayed index creation.
Hello mysql, Today I played a little bit with two different ways of backup - first one is to use BACKUP TABLE (which works for myisam only) and the second one is SAVE DATA/LOAD DATA. In both cases if I'm not mistaken the file is wrote by mysqld server so there is no communication overhead. The table was about 3mil of rows 250MB in size, has 2 indexes. So the speeds are: BACKUP TABLE: backup: 26sec restore: 3min.15sec SAVE DATA/LOAD DATA dump: 4.5min restore: 40min Then I tried to drop all indexes from the table and tried to do restore again it went in: 31min The output from backup was 250MB, save file - 400MB. These speeds was really strange for me, I did't expect so huge difference in speads, as I don't see there it should get from. The save data outfile operation should be quite fast as the speed of text parsing should be the real limit, also the really surprising was so slow speed of import data from text, even with no indexes on the table if we would look at the speed it's only about 1000 rows per second which is quite slow. -- Best regards, Peter mailto:[EMAIL PROTECTED] - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
help please
hello all: how can i run multiple instances of mysql server? i also looked at mysqld_multi but i guess there is a problem with that too. here is the error what it gave: ABORT: Bad GNR: mysql2 See mysqld_multi --help i also defined GNR in /etc/my.cnf Any idea why the error? ...Rohit
Redirection to www.innodb.com seems to work now: please report if you have problems
Hi! Redirection from www.innobase.fi to www.innodb.com now works from my own computer. Please report to me if it does not work from your computer. The official InnoDB website is now www.innodb.com My email address still stays the same [EMAIL PROTECTED], but also that will probably change to [EMAIL PROTECTED], as soon as my host gets it defined. Regards, Heikki Tuuri Innobase Oy (bait for the mail filter: sql database) - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
mysql hosting. how to do with quotas.
does anyone setting up mysql with quotas?? i need it for hosting. -- %whois -R NULL-RIPN PGP: http://null.magelan.ru/null.asc Pager: +7 095 974-0003, #30369 - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: BACKUP/RESTORE speed and delayed index creation.
Hi! At 05:44 PM 6/1/01 +0400, you wrote: Hello mysql, Today I played a little bit with two different ways of backup - first one is to use BACKUP TABLE (which works for myisam only) and the second one is SAVE DATA/LOAD DATA. In both cases if I'm not mistaken the file is wrote by mysqld server so there is no communication overhead. The table was about 3mil of rows 250MB in size, has 2 indexes. So the speeds are: BACKUP TABLE: backup: 26sec restore: 3min.15sec SAVE DATA/LOAD DATA dump: 4.5min restore: 40min Then I tried to drop all indexes from the table and tried to do restore again it went in: 31min The output from backup was 250MB, save file - 400MB. These speeds was really strange for me, I did't expect so huge difference in speads, as I don't see there it should get from. The save data outfile operation should be quite fast as the speed of text parsing should be the real limit, also the really surprising was so slow speed of import data from text, even with no indexes on the table if we would look at the speed it's only about 1000 rows per second which is quite slow. The speed 1000 rows per second is really too little. I tried an InnoDB table with 1 000 000 rows, with 2 integer columns, on the first column a primary key. mysql select * from t25 into outfile 'testout2'; Query OK, 100 rows affected (4.47 sec) mysql load data infile 'testout2' into table t30; Query OK, 100 rows affected (22.23 sec) Records: 100 Deleted: 0 Skipped: 0 Warnings: 0 Thus for these small rows it is 45 000 rows/second on Linux-2.4 2-CPU Xeon 450 Mhz. What is your table definition like? What is the OS and file system? Regards, Heikki -- Best regards, Peter mailto:[EMAIL PROTECTED] - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Dates not compared properly, part II
As soon as the new month rolled over, it happened again. The problem went away sometime in mid-May. The only difference between the current problems and the old is that we're now running 3.23.38. Any ideas? Chris -- Forwarded message: From [EMAIL PROTECTED] Tue May 1 14:37:53 2001 Date: Tue, 1 May 2001 14:37:53 -0500 From: Christopher P. Lindsey [EMAIL PROTECTED] To: [EMAIL PROTECTED] Subject: Dates not compared properly? Message-ID: [EMAIL PROTECTED] Mime-Version: 1.0 Content-Type: text/plain; charset=us-ascii X-Mailer: Mutt 1.0.1i Content-Length: 2290 Lines: 63 Howdy all... I've run into a strange date problem as of midnight, May 1, 2001 on my i686 Linux machine running mySQL 3.23.37. For some reason, queries can no longer compare dates properly: mysql select count(*) from hit where date NOW()-1135560; +--+ | count(*) | +--+ | 2633 | +--+ 1 row in set (2.05 sec) mysql select count(*) from hit where date NOW()-1145560; +--+ | count(*) | +--+ |0 | +--+ 1 row in set (2.05 sec) mysql select NOW()-1135560,NOW()-1145560; +++ | NOW()-1135560 | NOW()-1145560 | +++ | 2001057384 | 2001047384 | +++ 1 row in set (0.00 sec) mysql describe hit; ++--+--+-+-+---+ | Field | Type | Null | Key | Default | Extra | ++--+--+-+-+---+ | dig_id | int(10) unsigned | | MUL | 0 | | | date | timestamp(14)| YES | | NULL| | | ip | varchar(16) | YES | | NULL| | | site | varchar(255) | YES | | NULL| | ++--+--+-+-+---+ NOW() is being expanded properly, yet for some reason the comparison of hit.date with NOW()-n fails when n is larger than an abitrary number. As it becomes later and later in the day, n becomes larger and larger (so eventually it will reach 1970 and everything will work again). I've optimized the tables, but don't really have any other good ideas. For now, I'm just doing select count(*) as hits, substring(date,1,8) as foo from hit where ip NOT like x.x.x.% AND ip != x.x.x.x group by foo order by foo desc limit 10; to get the count of most recent hits instead of the faster select count(*) as hits, substring(date,1,8) as whee from hit where date NOW() - 1000 AND ip NOT like 64.5.98.% AND ip != 141.142.22.95 group by whee order by whee desc; Any ideas? Thanks, Chris P.S. For those who are curious, the database tracks views of plant photos on my Web site in real-time, including sites that have inlined. - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: help please
At 7:19 PM +0530 6/1/01, Rohit Peyyeti wrote: hello all: how can i run multiple instances of mysql server? i also looked at mysqld_multi but i guess there is a problem with that too. here is the error what it gave: ABORT: Bad GNR: mysql2 See mysqld_multi --help i also defined GNR in /etc/my.cnf Unfortunately, you haven't shown us *how* you defined it, so we can't tell whether or not what you did is correct Any idea why the error? ...Rohit -- Paul DuBois, [EMAIL PROTECTED] - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Help me with mysql_store_result()
Hello, mysql: Can anyone say if exist some function in the C API that do not store all the requested rows before returning but it returns inmediatly for each one and the storing be in the remote server. Thanks a lot ! [EMAIL PROTECTED] - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
RE: what's the problem????
Hi Jeff Can you give us a bit more step by step info Then we will pont you the right way.. Simon -Original Message- From: Jeff Davidson [mailto:[EMAIL PROTECTED]] Sent: 01 June 2001 18:13 To: [EMAIL PROTECTED] Subject: what's the problem We have installed the mySQL binary onto Windows 2000 from a CD. (We think we installed it) What next?? We've messed around with dos commands with no luck. We are obviously missing something vital??? What is it??? Help!!! Thanks - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: what's the problem????
On Fri, Jun 01, 2001 at 12:12:47PM -0500, Jeff Davidson wrote: We have installed the mySQL binary onto Windows 2000 from a CD. (We think we installed it) What next?? We've messed around with dos commands with no luck. We are obviously missing something vital??? You are clearly missing the documentation. It's probably installed on your system, but I don't know where. Fortunately, I do know where it is at on the Web: http://www.mysql.com/doc/ Good luck, Jeremy -- Jeremy D. Zawodny, [EMAIL PROTECTED] Technical Yahoo - Yahoo Finance Desk: (408) 349-7878Fax: (408) 349-5454Cell: (408) 439-9951 MySQL 3.23.29: up 7 days, processed 44,302,739 queries (72/sec. avg) - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: Question for a MYSQL expert (I assume this list has some)...
What you are asking to do is not built into MySQL :( Mysql matintains its own internal database locking that would not be shared amongs the other computers, if you have multiple machines reading a writing to the same database file you will corrupt it in short order. Your best bet in such an environment (IMHO) would be to better arrange your database(s) so that they can be logicaly split amongst multiple computers. You can still use the common drive array as long as you don't have multiple computers assigned to the same database. For example we have some systems that devide sessiontracking, order management, catalog images, separately. We have another system that that has databases split along a logical divider and a single database that acts as an index server. For example if you are managing a collaboration software type database break your projects to different servers by the letter they start with, or simply round robin their creation across multiple servers and maintain a single server that has the index containing which project is on which server. Back up all of the servers independantly and you're ready to do.. You can get pretty big doing it like this. Maintenance is a little higher than for a single master database, but again, mysql doesn't do that, so if you want to use mysql think differently. It may be possible to maintain multiple read servers and a single master write/update server while attached to the same database, but the way I see it this wont' work either given the way MySQL caches indexes and the servers will cache the file system (databases). Quite frankly ebay, Microsoft, apple and amazon are not using MySQL in environments that require multiple servers to accomplish single data management tasks. Kenneth Kopelson wrote: I am hoping there are people who use MySQL for serious business applications on this list. If so, please answer my question :) If not, will someone please direct me to a source of expert information? HERE IS MY QUESTION: I have need for multiple servers to share the same database files. We are implementing a site that will have hundreds of thousands of users at the same time, so we need a large pool of Linux servers that are load-balanced. Then, all these servers, each of which will run Apache and MySQL (or another database if MySQL just can't handle the load), needs to access the single large RAID disk array through a giga-bit network connection. Certainly, this is not uncommon, as any large database driven website needs to have a similar setup (like eBay, Microsoft, Apple, Amazon, etc.). The servers need to be setup in a cluster to provide the required high-availability. Also, replication will NOT work, as we need changes to the database to be immediately available to everyone else, and managing 100 or more replicated databases would be a nightmare. So, how do we get support in MySQL so that multiple instances of the mysqld daemon running on separate machines can all access the same database files located on a central server? I can see how the file system of the central database server could be exported through NFS (or something similar) so that all the machines in the cluster can access the database files. I also imagine the daemons would need to have some sort of locking mechanism to avoid stepping on each other. Any help in this matter would be greatly appreciated. Thanks - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: what's the problem????
Hi Have you installed the service in the CSM (console service manager) yet ? Go to the command prompt and type [mysql_dir]\bin\mysqld-nt --install (mysqld-max-nt for MySQL MAX). Afterwards start the service by either going to the CSM and starting it or by typing net start mysql from the command prompt. Regards, Jorge MySQL Development Team __ ___ __ __ / |/ /_ __/ __/ __ \/ / Jorge del Conde [EMAIL PROTECTED] / /|_/ / // /\ \/ /_/ / /__ MySQL AB, http://www.mysql.com/ /_/ /_/\_, /___/\___\_\/ Mexico City, Mexico ___/ - Original Message - From: Jeff Davidson [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: Friday, June 01, 2001 12:12 PM Subject: what's the problem We have installed the mySQL binary onto Windows 2000 from a CD. (We think we installed it) What next?? We've messed around with dos commands with no luck. We are obviously missing something vital??? What is it??? Help!!! Thanks - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: char() problem
On Fri, 1 Jun 2001, Toth Dalibor wrote: I really need to know this: I have a column defined as char(2), default 'no', not null. When I create new entry into the table, I skip entering value into mentioned column because I expect to be filled with the default value, that is 'no'. But that doesn't happen! Why? What version are you using? mysql CREATE TABLE tmp (id INT, v CHAR(2) DEFAULT 'no' NOT NULL); Query OK, 0 rows affected (0.00 sec) mysql INSERT INTO tmp (id) VALUES(1); Query OK, 1 row affected (0.01 sec) mysql SELECT * FROM tmp; +--++ | id | v | +--++ |1 | no | +--++ 1 row in set (0.00 sec) mysql SELECT VERSION(); +-+ | VERSION() | +-+ | 3.23.37-log | +-+ Andreas Karl Wittwer Phone: +49-7052-92206 FAX: +49-7052-92208 Mobil: +49-172-542 541 4 - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: Question for a MYSQL expert (I assume this list has some)...
Kenneth Kopelson wrote: So, how do we get support in MySQL so that multiple instances of the mysqld daemon running on separate machines can all access the same database files located on a central server? I can see how the file system of the central database server could be exported through NFS (or something similar) so that all the machines in the cluster can access the database files. I also imagine the daemons would need to have some sort of locking mechanism to avoid stepping on each other. Also... MySQL is open source, so the easiest way to get support for a feature it doesn't have is to get together a group of people to write it. I would start with InnoDB format tables since table level locking would probably kill you on a such a large distributed environment. - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: Problem running old database with 3.23.30-gamma
On Fri, Jun 01, 2001 at 09:13:45AM -0400, Beverly Baird wrote: Tried that. mysql ALTER TABLE Craft type=MYISAM; ERROR 1016: Can't open file: 'Craft.ISD'. (errno: 138) I have tried to run the mysql_convert_table_format script but I can't find any examples and I cannot get it to work either. I'm quite sure it's operator error in this case. Can the user which `mysqld' is running as actually read the files? Check the file ownership and permissions. Also, you might check to see what error 138 is (using the perror program that comes with MySQL). Jeremy -- Jeremy D. Zawodny, [EMAIL PROTECTED] Technical Yahoo - Yahoo Finance Desk: (408) 349-7878Fax: (408) 349-5454Cell: (408) 439-9951 MySQL 3.23.29: up 7 days, processed 44,312,186 queries (72/sec. avg) - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
MySQL remote connect
Hello all, I'm running MySQL on SuSE Linux 7.0. I've been unable to connect to MySQL from a client on a remote system (both systems behind the firewall) using a username/pw set up locally using the GRANT ALL ON *.* TO user@% identified by password command. I know this is a big security hole to grant universal permissions in this way, but I'm just trying to connect from anywhere else but locally, which i can do. When trying to connect, I get the host malacoda.local is not allowed to connect to this MySQL server. Malacoda.local being the remote system that is set up in the local hosts file on the Linux system. It's my understanding that setting up universal access using the grant command will allow my to connect from anywhere regardless of host name or IP addresss. Is there any other place, port setting, etc. I need to configure to get this darned thing to work? Best, Peter Bethke - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: mysqlhotcopy ..
On Fri, Jun 01, 2001 at 03:35:57PM +0800, Alice wrote: i have no idea on how to run mysqlhotcopy in the query tool or it is not suppose to run in query tool. is this correct ? mysqlhotcopy db_name '/downloads/backupDB/' It's a stand-alone tool. If you run it without any command-line arguments, it will give you usage information (like all good tools do). Jeremy -- Jeremy D. Zawodny, [EMAIL PROTECTED] Technical Yahoo - Yahoo Finance Desk: (408) 349-7878Fax: (408) 349-5454Cell: (408) 439-9951 MySQL 3.23.29: up 7 days, processed 44,321,200 queries (72/sec. avg) - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
what's the problem????
Friday June 01 2001 12:12, Jeff Davidson wrote to All: JD We have installed the mySQL binary onto Windows 2000 from a CD. JD (We JD think we installed it) What next?? We've messed around with JD dos JD commands with no luck. We are obviously missing something vital??? JD What is it??? Help!!! Thanks Read the documents??? KS KARICO Business Services Toronto, ON Canada http://www.karico.ca ... Earth is a great funhouse without the fun. - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
deceptively simple question
I know that when it comes to deleting users from the user table, I could revoke all privileges and use an SQL 'delete from' command, but I wonder if there's an easier script/method for dropping a user? I've been combing the manual for a couple days and while I can create users and grant/revoke privileges, simply deleting them has eluded me. -- ***+*** *** [] *** *** Peter H. Burris, [] [EMAIL PROTECTED] *** *** Unix System Admin [] phone: 301.614.5110 *** *** CODE 922, Bldg 33 [] pager: 301.647.2752 *** *** [] *** ***+*** - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: what's the problem????
At 12:12 PM -0500 6/1/01, Jeff Davidson wrote: We have installed the mySQL binary onto Windows 2000 from a CD. (We think we installed it) What next?? We've messed around with dos commands with no luck. We are obviously missing something vital??? What is it??? Help!!! Thanks If you're installing from a CD, then presumably whoever put the distribution there included some instructions with it. What kind of CD is it - from someone like NuSphere or AbriaSoft? -- Paul DuBois, [EMAIL PROTECTED] - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: Question for a MYSQL expert (I assume this list has some)...
Thank you Steve, I appreciate your response :) I have considered modifying MySQL to do what I have asked for, but I didn't want to do that until I verified it wasn't already available somewhere. I'll bet this feature is something that others would be interested in as well. On the note of what eBay and others are using, do you have a suggestion of a database that would do what we are wanting, and also be as efficient as MySQL is? I really like MySQL's many features like regular expressions in queries, the fact that you can easily retrieve the auto-increment value that was used on an INSERT (not an easy task on others DBs I have used), and many other features. Perhaps an open-source project to add shared DB capabilities would be something worth starting. I myself am a C++ developer with over 23 years experience, so maybe I can join with some others who are interested, and we can start a project. If anyone on this list would be interested in discussing the possibilities of joining in such an effort, please let me know. -Ken At 11:47 AM 6/1/01 -0600, Steve Ruby wrote: Kenneth Kopelson wrote: So, how do we get support in MySQL so that multiple instances of the mysqld daemon running on separate machines can all access the same database files located on a central server? I can see how the file system of the central database server could be exported through NFS (or something similar) so that all the machines in the cluster can access the database files. I also imagine the daemons would need to have some sort of locking mechanism to avoid stepping on each other. Also... MySQL is open source, so the easiest way to get support for a feature it doesn't have is to get together a group of people to write it. I would start with InnoDB format tables since table level locking would probably kill you on a such a large distributed environment. - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
importing text files
i want to import a series of text files into a MySQL database.. can anyone point in the direction of good documenation on this?.. thanks in advance.. - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Displaying MySQL database with DATE_FORMAT
Hi,
I've developed a simple search engine for a site I'm working on. Its
purpose is to display community events based on the users input criteria.
The problem is, if I use the DATE_FORMAT command to alter the appearance of
the events dates and times - then MySQL begins at the top of the list using
the exact order of dates and times, rather than listening to the initial
query and taking only the relevant dates and times.
However, if I leave out the DATE_FORMAT and TIME_FORMAT commands, it works
perfectly, just without the nice friendly display. Any thoughts?
Here is a sample of my script:
if (!$db)
{
echo Error: Could not connect to database. Please try again later.;
exit;
}
$query = select * from comcal2001 where .$searchtype. like
'%.$searchterm.%';
$result = mysql_query($query, $db);
$resultdate = mysql_query (SELECT DATE_FORMAT(EventStartDate, '%W %M
%D %Y') AS EventStartDate FROM comcal2001);
$resulttime = mysql_query (SELECT TIME_FORMAT(EventStartTime, '%r')
AS EventStartTime FROM comcal2001);
if (!$result)
echo Error running query: $querybr.mysql_error($db);
else
$num_results = mysql_num_rows($result);
$num_rows = mysql_numrows($result);
echo pNumber of Events found: .$num_rows./p;
for ($i=0; $i $num_rows; $i++)
{
$row = mysql_fetch_array($result);
echo pb.($i+1).. Event: ;
echo ($row[EventName]);
echo /bbrMonth: ;
echo ($row[EventMonth]);
echo brLocation: ;
echo ($row[EventLocation]);
echo brCity: ;
echo ($row[EventCity]);
echo , ;
echo ($row[EventState]);
echo brTime: ;
$rowtime = mysql_fetch_array($resulttime);
echo ($row[EventStartTime]);
echo brDate: ;
$rowdate = mysql_fetch_array($resultdate);
echo ($row[EventStartDate]);
echo brDescription: ;
echo ($row[EventDescription]);
echo brCost: ;
echo ($row[EventCost]);
echo /p;
}
?
Thanks
-Tim
-
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/ (the list archive)
To request this thread, e-mail [EMAIL PROTECTED]
To unsubscribe, e-mail [EMAIL PROTECTED]
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Logging/Stats individual entries..
Hi, I was wondering if someone knew of a way to keep stats of records that were being used from a Table in a DB.. i.e. I have a table with URL's in them and when a search is done, it returns a certain number of records.. I want to know, which exact record the user click's on and uses, not the query itself.. Is there some counting method of sorts implemented in such a way? The only way I have been able to think of is JavaScript.. Is there any other way possible to do this? Thanks.. - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: importing text files
On Fri, Jun 01, 2001 at 03:08:53PM -0400, Longo, Joseph wrote: i want to import a series of text files into a MySQL database.. can anyone point in the direction of good documenation on this?.. Search for LOAD DATA in the manual: http://www.mysql.com/doc/ Jeremy -- Jeremy D. Zawodny, [EMAIL PROTECTED] Technical Yahoo - Yahoo Finance Desk: (408) 349-7878Fax: (408) 349-5454Cell: (408) 439-9951 MySQL 3.23.29: up 7 days, processed 44,789,874 queries (72/sec. avg) - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: Displaying MySQL database with DATE_FORMAT
I think your doing FAR more work than you need to. I'm also not getting
what you mean by it not paying attention to the initial query.
I suggest you combine those 3 queries into one, just like this:
SELECT somefield1, somefield2, DATE_FORMAT(EventStartDate, '%W %M %D %Y') AS
FormattedEventStartDate, TIME_FORMAT(EventStartTime, '%r') AS
FormattedEventStartTime FROM comcal2001 WHERE blah
- Original Message -
From: Tim Thorburn [EMAIL PROTECTED]
To: [EMAIL PROTECTED]
Sent: Friday, June 01, 2001 12:08 PM
Subject: Displaying MySQL database with DATE_FORMAT
Hi,
I've developed a simple search engine for a site I'm working on. Its
purpose is to display community events based on the users input criteria.
The problem is, if I use the DATE_FORMAT command to alter the appearance
of
the events dates and times - then MySQL begins at the top of the list
using
the exact order of dates and times, rather than listening to the initial
query and taking only the relevant dates and times.
However, if I leave out the DATE_FORMAT and TIME_FORMAT commands, it works
perfectly, just without the nice friendly display. Any thoughts?
Here is a sample of my script:
if (!$db)
{
echo Error: Could not connect to database. Please try again later.;
exit;
}
$query = select * from comcal2001 where .$searchtype. like
'%.$searchterm.%';
$result = mysql_query($query, $db);
$resultdate = mysql_query (SELECT DATE_FORMAT(EventStartDate, '%W %M
%D %Y') AS EventStartDate FROM comcal2001);
$resulttime = mysql_query (SELECT TIME_FORMAT(EventStartTime, '%r')
AS EventStartTime FROM comcal2001);
if (!$result)
echo Error running query: $querybr.mysql_error($db);
else
$num_results = mysql_num_rows($result);
$num_rows = mysql_numrows($result);
echo pNumber of Events found: .$num_rows./p;
for ($i=0; $i $num_rows; $i++)
{
$row = mysql_fetch_array($result);
echo pb.($i+1).. Event: ;
echo ($row[EventName]);
echo /bbrMonth: ;
echo ($row[EventMonth]);
echo brLocation: ;
echo ($row[EventLocation]);
echo brCity: ;
echo ($row[EventCity]);
echo , ;
echo ($row[EventState]);
echo brTime: ;
$rowtime = mysql_fetch_array($resulttime);
echo ($row[EventStartTime]);
echo brDate: ;
$rowdate = mysql_fetch_array($resultdate);
echo ($row[EventStartDate]);
echo brDescription: ;
echo ($row[EventDescription]);
echo brCost: ;
echo ($row[EventCost]);
echo /p;
}
?
Thanks
-Tim
-
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/ (the list archive)
To request this thread, e-mail [EMAIL PROTECTED]
To unsubscribe, e-mail [EMAIL PROTECTED]
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
-
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/ (the list archive)
To request this thread, e-mail [EMAIL PROTECTED]
To unsubscribe, e-mail [EMAIL PROTECTED]
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: myisamchk --sort-records extremely slow
- Original Message - From: Jeremy Zawodny [EMAIL PROTECTED] On Wed, May 30, 2001 at 11:32:16PM -0400, Michael Villalba wrote: I have a rather large MyISAM table (~230 million rows) running under MySQL 3.23.30. It has 10 columns and 3 indices. The data and index files each occupy about 10GB. My problem is that sorting the rows using myisamchk --sort-records takes an extremely long time. The last sort took 95 hours (that's right...almost four days). The machine is a four-processor Sun E450 with 4GB of memory. The OS is Solaris 2.7. The database files reside on a 12-disk SCSI RAID 5 array. The machine was essentially idle with the exception of the sort job. The previous time I ran myisamchk --sort-records, the table had ~170 million rows, and it only took 12 hours. The specific command I used in both cases was: myisamchk -O sort_buffer_size=1024M -O key_buffer_size=1024M -O read_buffer_size=64M -O write_buffer_size=64M --sort-records=2 95 hours to sort and reindex 10 GB of data does not seem reasonable. Anyone have any idea what's going on here? Off the top of my head, I'd suggest increasing the size of the read and write buffers. If you run vmstat (or something similar) when the sort is going on, do you see lots of CPU use, lots of I/O, both, neither? You won't get much help from the other 3 CPUs, but you should be able to get a lot done with 4GB of RAM. Thanks Jeremy. Next time I'll increase the sizes of the read and write buffers, but I'm still curious why a 35% increase in data would result in 8 times the execution time. The only thing I did differently between the 12 hour run and the 4-day run was that for the latter I did not sort the index tree blocks first (myisamchk --sort-index). Do you think that would make a difference? During the latest run I monitored mpstat. The processor that the myisamchk process happened to be on always had a low idle time, but user time was only ~20% and system time was ~10%. Wait time was of course the balance. Michael
JOIN-problems
Hi there, I have five tables in the database: customers, orders, ordercontents, products and payments. The problem is that I should get a list which shows some kind of a ledger list (shows who has paid and so on). My first try looks like this: SELECT orders.OrderID, customers.Name, SUM(ordercontents.Amount * products.Price) AS TotalSum, SUM(payments.PaidFIM) AS TotalPaid FROM orders LEFT JOIN customers ON (customers.CustID = orders.CustID) LEFT JOIN payments ON (payments.OrderID = orders.OrderID) LEFT JOIN ordercontents ON (ordercontents.OrderID = orders.OrderID) LEFT JOIN products ON (products.ProdID = ordercontents.ProdID) WHERE orders.Cancelled=0 AND ordercontents.Removed=0; That's it... I hope that you understood the structure. Also there should be noticed that the order can have many different products ordered (listed on ordercontents -table) and also that there can be many separated payments for same order. Now this query works, but it doesn't return correct amounts for TotalPaid and TotalSum -columns. Thanks for help, - Ville Mattila, Ikaalinen, Finland - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Newbie Needs Help
- Original Message - From: Glenn Emery To: [EMAIL PROTECTED] Sent: Friday, June 01, 2001 3:46 PM Subject: Newbie Needs Help Hi All, I am not sure this is the correct list for this but here goes...If not the correct list any idea where I might find some help? I have a site that is working everywhere except on a submition page and I keep getting an error that states ADODB.Connection.1 error '80004005' SQLState: 42000 Native Error Code: 1064 [TCX][MyODBC]You have an error in your SQL syntax near '' at line 1 /profile/chemistrymatch/final.asp, line 633 I'm working with the latest stable MySQL I've attached the final.asp page that is throwing out the error Thank You! - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: myisamchk --sort-records extremely slow
Thanks for your detailed and comprehensive response, Steve. I should have mentioned that the RAID 5 array is provided by an A1000 RAID unit. It is configured to have one logical unit. Both the MySQL data and temporary directories are on the A1000. All 12 drives in the A1000 are 18 GB Seagates (same model). All the drives were delivered with the unit. The E450 has 4 400MHz processors installed. It has one additional Symbios controller. - Original Message - From: Steve Brazill [EMAIL PROTECTED] To: Michael Villalba [EMAIL PROTECTED] Cc: [EMAIL PROTECTED] Sent: Thursday, May 31, 2001 12:38 PM Subject: Re: myisamchk --sort-records extremely slow Perhaps the physical layout of your disk drives are contributing to the 'slowness'... - Are the 12 drives making up the SCSI RAID 5 array the only drives in the system ? - Do you have the O/S and/or the 'temp' area being used by MySQL on different drive devices than the RAID array ? (is the 'temp' area a 'RAID 5' partition ?) - How many SPARC CPU's (and what 'speed') are installed in the system ? - What are the 'size' of the disk drives ? Are they all identical drive models ? - How many Symbios SCSI controller cards (besides the initial 'onboard' controller) are installed in the system ? If you are reading, and writing, the data to and from the same 12 drives that make up the RAID 5 array, you would see an I/O bottlekneck (though, with 4 gigabytes of RAM, it should be able to 'buffer' a lot of the I/O transactions). Not only is 'writing' to RAID 5 arrays slow, the more devices (above 8) used in a RAID-5 array, the longer it takes for all drives to 'respond' to any SCSI commands (and I doubt that the 'block' or 'data segment' reads/writes are spread across all 12 drives). AND, if you originally created the RAID array with less drives, and have been 'extending' it, the 'parity' sectors would only be located on the original drives in the array, which take the 'brunt' of the parity calculation 'writes'... The Sun E450 is capable of having a total of 5 SCSI controller 'paths' (visibly seen as 5 SCSI cables) when 2 additional Symbios 'dual path' SCSI controllers are installed. Though the system can hold a total of 20 disk drives, it's very limited to how they can be arranged for performance and availability (see the crude chart below). The only efficient (and safe) manner of drive installation and configuration in an E450, is to create 5 drive 'arrays' using disks that are installed on each of the 'paths'. This allows concurrent controller access and spreads the 'bandwidth' over all 5. And, if 1 controller 'chip' fails, the RAID remains intact (though if an entire Symbios 'card' fails, you'd lose 2 paths/drives and the data as well). If your table(s) have grown larger than a 5 drive array (when if 'raided' would only equal 4 drives in disk space), you'd have to 'break' the method described above, or use MySQL's ability to 'stripe' the database across different partitions. If you can fit individual tables within the 5 drive arrays, have you considered locating the different tables on separate arrays ?? Sun E450 drive bay configuration: Drive slots 18 19 16 17 SCSI Controller 3 4 14 15 12 13 10 11 8 9 SCSI Controller 1 2 6 7 4 5 SCSI controller 0 (on-board chip) 2 3 0 1 Preferred drive configuration: O/S (Solaris partitions) - mirrored on drives 0 1 Data - RAID 5 array on drives 2, 6, 10, 14, 18 Data - RAID 5 array on drives 3, 7, 11, 15, 19 Indexes - Mirrored drives 4 12, 8 16 (note: each 'half' of the mirror is located on a different SCSI 'card' as well as 'path', to protect against an entire 'card' failing) Temp - Mirrored drives 5 13 - Original Message - Sent: Thursday, May 31, 2001 8:55 AM Subject: Re: myisamchk --sort-records extremely slow In the last episode (May 30), Michael Villalba said: I have a rather large MyISAM table (~230 million rows) running under MySQL 3.23.30. It has 10 columns and 3 indices. The data and index files each occupy about 10GB. My problem is that sorting the rows using myisamchk --sort-records takes an extremely long time. The last sort took 95 hours (that's right...almost four days). The machine is a four-processor Sun E450 with 4GB of memory. The OS is Solaris 2.7. The database
Re: What's the best os?
On 01 Jun 2001 00:30:20 -0400, David Freeman wrote: My question is, what is the best OS for a heavy usage, multi-processor mysql database driven web site. We could use almost anything, but we would prefer to use a free OS such as freebsd or Linux based OS. Some people reported better performance for MySQL on Linux than on Solaris, using the same hardware (Sparc). While i don't think there's much difference between Linux and FreeBSD, i would expect Linux-2.4 to handle SMP and threads a little bit better than FreeBSD. But this is close to religious war... I would reccomend Linux with kernel 2.4. You should use a journalised filesystem, of course. Now, while ReiserFS does better when it comes to handling lots of small files, XFS is better at ensuring high I/O rates, especially for simultaneous access to large files in heavy-loaded SMP environments, because that's what it was designed for. So, it's better suited for databases, such as MySQL. XFS-1.0 is already available for Linux (kernel 2.4), and it's fully stable. You can download it from here: http://oss.sgi.com/projects/xfs/ Or, if you prefer, get an ISO image containing a modified Red Hat 7.1 kit, able to install itself directly on XFS, from here: http://oss.sgi.com/projects/xfs/1.0_installer.html -- Florin Andrei - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: What's the best os?
On Fri, Jun 01, 2001 at 12:28:17PM +0400, Ilya Martynov wrote: JZ On Fri, Jun 01, 2001 at 01:45:24AM -0400, David Freeman wrote: JZ Assuming you'll use Apache 2.x one day, I'd lean away from FreeBSD JZ until the threading issues are resolved. I could envision you running JZ 1 threaded MySQL server and 1 threaded Apache server. Under FreeBSD JZ (today), you'd have 2 idle CPUs and 2 busy CPUs because it'd never JZ spread the threads from each server across the CPUs the way you'd JZ like. AFAIK you can compile mysql on FreeBSD with LinuxThreads (they have been ported on FreeBSD). In this case threads will spread across the CPUs as on Linux. Funny you mention that... It comes up once in a while, but almost everytime it's someone saying I've heard that you can... I've yet to meet someone who does it and likes it. I'm not saying it's bad, but it just seems like one of those things that people suggest but don't actually have experience with. Jeremy -- Jeremy D. Zawodny, [EMAIL PROTECTED] Technical Yahoo - Yahoo Finance Desk: (408) 349-7878Fax: (408) 349-5454Cell: (408) 439-9951 MySQL 3.23.29: up 7 days, processed 46,316,122 queries (73/sec. avg) - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: What's the best os?
On Fri, Jun 01, 2001 at 03:50:30PM -0700, Florin Andrei wrote: On 01 Jun 2001 00:30:20 -0400, David Freeman wrote: My question is, what is the best OS for a heavy usage, multi-processor mysql database driven web site. We could use almost anything, but we would prefer to use a free OS such as freebsd or Linux based OS. Some people reported better performance for MySQL on Linux than on Solaris, using the same hardware (Sparc). While i don't think there's much difference between Linux and FreeBSD, i would expect Linux-2.4 to handle SMP and threads a little bit better than FreeBSD. But this is close to religious war... Actually, it has little to do with religion and lots to do with fact. I work in what's almost completely a FreeBSD shop. We have core FreeBSD developers on staff. But we still use Linux for our SMP MySQL servers. When FreeBSD catches up, I'll glady switch [back] to it. :-) Jeremy -- Jeremy D. Zawodny, [EMAIL PROTECTED] Technical Yahoo - Yahoo Finance Desk: (408) 349-7878Fax: (408) 349-5454Cell: (408) 439-9951 MySQL 3.23.29: up 7 days, processed 46,319,862 queries (73/sec. avg) - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: Unicode
My mysql server is English but I have a chinese/english front end and users type in both Chinese English. - Original Message - From: md [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: Friday, June 01, 2001 21:22 Subject: Unicode Does anybody use mysql with Chinese or other Unicode based language. Any Japanese or Chinese MYSQL users out there? If so, please bounce me back a message. Mark Diener - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
FW: ezmlm response
hello everyone... I am very new to mysql and I needed some help creating 1 admin account for 4 computers. This is the error I keep getting. mysql grant all on *.* to admin@% identified by password; ERROR 1064: You have an error in your SQL syntax near '% identified by password' at line 1 mysql I tried this on win2k and also redhat linux 7.0 - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
FW: ezmlm response
-Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]] Sent: Friday, June 01, 2001 9:54 PM To: [EMAIL PROTECTED] Subject: ezmlm response Hi! This is the ezmlm program. I'm managing the [EMAIL PROTECTED] mailing list. This is a generic help message. The message I received wasn't sent to any of my command addresses. --- Administrative commands for the mysql-digest list --- I can handle administrative requests automatically. Please do not send them to the list address! Instead, send your message to the correct command address: To subscribe to the list, send a message to: [EMAIL PROTECTED] To remove your address from the list, send a message to the address in the List-Unsubscribe header of messages from the list. If you don't know how to display headers and haven't changed E-mail addresses since subscribing, you'll be successful with an e-mail to: [EMAIL PROTECTED] Send mail to the following for info and FAQ for this list: [EMAIL PROTECTED] [EMAIL PROTECTED] Similar addresses exist for the digest list: [EMAIL PROTECTED] [EMAIL PROTECTED] To get messages 123 through 145 (a maximum of 100 per request), mail: [EMAIL PROTECTED] To get an index with subject and author for messages 123-456 , mail: [EMAIL PROTECTED] They are always returned as sets of 100, max 2000 per request, so you'll actually get 100-499. To receive all messages with the same subject as message 12345, send an empty message to: [EMAIL PROTECTED] The messages do not really need to be empty, but I will ignore their content. Only the ADDRESS you send to is important. You can start a subscription for an alternate address, for example [EMAIL PROTECTED], just add a hyphen and your address (with '=' instead of '@') after the command word: [EMAIL PROTECTED] To stop subscription for this address, mail: [EMAIL PROTECTED] In both cases, I'll send a confirmation message to that address. When you receive it, simply reply to it to complete your subscription. If despite following these instructions, you do not get the desired results, please contact my owner at [EMAIL PROTECTED] Please be patient, my owner is a lot slower than I am ;-) --- Enclosed is a copy of the request I received. Return-Path: [EMAIL PROTECTED] Received: (qmail 4413 invoked from network); 2 Jun 2001 01:53:27 - Received: from rly-ip02.mx.aol.com (152.163.225.160) by www.mysql.com with SMTP; 2 Jun 2001 01:53:27 - Received: from tot-th.proxy.aol.com (tot-th.proxy.aol.com [152.163.213.1]) by rly-ip02.mx.aol.com (8.8.8/8.8.8/AOL-5.0.0) with ESMTP id VAA07481 for [EMAIL PROTECTED]; Fri, 1 Jun 2001 21:56:08 -0400 (EDT) Received: from solomont5pxb2m (AC982C83.ipt.aol.com [172.152.44.131]) by tot-th.proxy.aol.com (8.10.0/8.10.0) with SMTP id f521u6d19770 for [EMAIL PROTECTED]; Fri, 1 Jun 2001 21:56:07 -0400 (EDT) From: daddius [EMAIL PROTECTED] To: [EMAIL PROTECTED] Subject: RE: mysql Digest 1 Jun 2001 17:44:04 - Issue 1314 Date: Fri, 1 Jun 2001 22:03:00 -0400 Message-ID: [EMAIL PROTECTED] MIME-Version: 1.0 Content-Type: text/plain; charset=iso-8859-1 Content-Transfer-Encoding: 7bit X-Priority: 3 (Normal) X-MSMail-Priority: Normal X-Mailer: Microsoft Outlook IMO, Build 9.0.2416 (9.0.2910.0) X-MimeOLE: Produced By Microsoft MimeOLE V5.00.3018.1300 In-Reply-To: [EMAIL PROTECTED] Importance: Normal X-Apparently-From: [EMAIL PROTECTED] hello everyone... I am very new to mysql and I needed some help creating 1 admin account for 4 computers. This is the error I keep getting. mysql grant all on *.* to admin@% identified by password; ERROR 1064: You have an error in your SQL syntax near '% identified by password' at line 1 mysql I tried this on win2k and also redhat linux 7.0 - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: FW: ezmlm response
At 10:13 PM -0400 6/1/01, daddius wrote: hello everyone... I am very new to mysql and I needed some help creating 1 admin account for 4 computers. This is the error I keep getting. mysql grant all on *.* to admin@% identified by password; ERROR 1064: You have an error in your SQL syntax near '% identified by password' at line 1 mysql Put quotes around the % character: mysql grant all on *.* to admin@% identified by password; -- Paul DuBois, [EMAIL PROTECTED] - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: deceptively simple question
At 2:17 PM -0400 6/1/01, Peter H. Burris wrote: I know that when it comes to deleting users from the user table, I could revoke all privileges and use an SQL 'delete from' command, but I wonder if there's an easier script/method for dropping a user? I've been combing the manual for a couple days and while I can create users and grant/revoke privileges, simply deleting them has eluded me. That's indeed how you do it. REVOKE doesn't remove the account record from the user table, so you must DELETE it explicitly to remove not just the account's privileges, but the account itself as well. -- ***+*** ***[] *** *** Peter H. Burris, [] [EMAIL PROTECTED] *** *** Unix System Admin [] phone: 301.614.5110 *** *** CODE 922, Bldg 33 [] pager: 301.647.2752 *** ***[] *** ***+*** -- Paul DuBois, [EMAIL PROTECTED] - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: help please
Hello: This is how i defined in conf file: [mysqld_multi] mysqld=/usr/bin/safe_mysqld mysqladmin=/usr/bin/mysqladmin user=multi_admin password=multipass [mysqld2] socket=/var/lib/mysql/mysql.sock2 port=3308 pid-file=/var/run/mysqld/mysqld.pid2 datadir=/var/lib/mysql2 language=/usr/share/mysql/english Thanks! Rohit Peyyeti - Original Message - From: Paul DuBois [EMAIL PROTECTED] To: Rohit Peyyeti [EMAIL PROTECTED]; [EMAIL PROTECTED] Sent: Friday, June 01, 2001 8:47 PM Subject: Re: help please At 7:19 PM +0530 6/1/01, Rohit Peyyeti wrote: hello all: how can i run multiple instances of mysql server? i also looked at mysqld_multi but i guess there is a problem with that too. here is the error what it gave: ABORT: Bad GNR: mysql2 See mysqld_multi --help i also defined GNR in /etc/my.cnf Unfortunately, you haven't shown us *how* you defined it, so we can't tell whether or not what you did is correct Any idea why the error? ...Rohit -- Paul DuBois, [EMAIL PROTECTED] - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
