Re: Importing .sql files into database.
On Thursday, 7. March 2002 07:18, Josiah Wallingford wrote: Would the command by mysql -u username -p password dbname filename.sql(mysql) No, just use mysql dbname -uusername -ppaswwod filename.sql Regards Georg - 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: RH 7.2 connections problems w 16 web servers to 2 MySQL servers
On Wed, Mar 06, 2002 at 11:06:18AM -0800, Sam Iam wrote: We have a very high volume site (3 million page views a day) that's run on 16 Apache / PHP web servers 2 MySQL servers. We are using PHP with persistent connections. Each MySQL serves 8 web servers is supposed to act as a failover machine for the other group of 8 web servers. The failover won't work now as if one MySQL goes down the cost of the 8 web servers switching over is so high the other MySQL locks up. Each Apache / PHP server takes up hundreds of connections even when they're idle so we ran into the Linux connection limit of 1000 had to recompile to get past that. Our actual MySQL CPU useage is low but the goes when with the connection overhead when starting up or failing over a bank of machines. Are the Web servers doing write operations on the database, or read-only? If they're read-only, pick up a cheap load-balancer (a 3 year old Alteon will work fine) and load-balance across the 2 MySQL servers. Then you'll get the best utilization. Others have addressed the other issues you raised, it seems... Jeremy -- Jeremy D. Zawodny, [EMAIL PROTECTED] Technical Yahoo - Yahoo Finance Desk: (408) 349-7878 Fax: (408) 349-5454 Cell: (408) 685-5936 MySQL 3.23.47-max: up 27 days, processed 979,505,907 queries (408/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 access rights problem ...
Bonjour, I have a problem with Mysql and access rights : I have a user who has rights to access tables in the database 'membres' : #/ mysqlaccess 192.168.0.1 myuser membres Could not open outputfile ~/mysqlaccess.log for debugging-info mysqlaccess Version 2.06, 20 Dec 2000 By RUG-AIV, by Yves Carlier ([EMAIL PROTECTED]) Changes by Steve Harvey ([EMAIL PROTECTED]) This software comes with ABSOLUTELY NO WARRANTY. Access-rights for USER 'myuser', from HOST '192.168.0.1', to DB 'membres' +-+---+ +-+---+ | Select_priv | Y | | Shutdown_priv | N | | Insert_priv | Y | | Process_priv| N | | Update_priv | Y | | File_priv | N | | Delete_priv | Y | | Grant_priv | N | | Create_priv | Y | | References_priv | Y | | Drop_priv | Y | | Index_priv | Y | | Reload_priv | N | | Alter_priv | Y | +-+---+ +-+---+ NOTE:A password is required for user `myuser' :-( The following rules are used: db: '192.168.0.%','membres','myuser','Y','Y','Y','Y','Y','Y','N','Y','Y','Y' host : 'Not processed: host-field is not empty in db-table.' user : '192.168.0.%','myuser','','N','N','N','N','N','N','N','N','N','N','N','N','N','N' This works fine all day long, but each morning when I come back to work, my web site is no more working and the reason is : ERROR 1044: Access denied for user: '[EMAIL PROTECTED]' to database 'membres' If I test 'mysqlaccess 192.168.0.1 myuser membres' I have the same thing as above. And as soon as I run 'mysqladmin reload' , it corrects the problem and my web site is back. It's 3 days I have this problem. Maybe a program of mine is doing something that Mysql doesn't like each nights, but for me, this shouldn't impact Mysql's access rights. And I don't understand why 'mysqlaccess' is returning the good result but Mysql isn't granting access before I ask to reload access rights ... I had this problem with Mysql-3.23.47, I upgraded to 3.23.49 but I still have the same problem. Any idea ? Regards, Alex. - 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
Data series selection help
I record some stock data into MySQL, I'm looking for the correct syntax for a SELECT statement. SELECT min(Tmin) FROM quotes WHERE low=min(low) In short, I want the time of the occurance of the low for the day, Tmin is time column. Once the low is achieved, all the remaining data for the day has the same low recorded, so I want the first occurance. I tried SELECT min(tmin) FROM quotes WHERE tag='CSCO' HAVING min(low); which at least didn't have syntax errors, but alas did not produce a result. A few pointers? TIA - 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???
please tell me how to install mysql for sco unix 5.0.5??? need file??? thank you !!! __ === ÐÂÀËÃâ·Ñµç×ÓÓÊÏä (http://mail.sina.com.cn) ÐÂÀË·ÖÀàÐÅÏ¢£º¶þÊÖÊг¡×ßÒ»×ߣ¬¸Ã³öÊÖʱ¾Í³öÊÖ£¡ (http://classad.sina.com.cn/2shou/) - 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: [linux-lvm] System Suggestions
We have 10 of the 3ware cards, and while the drive is GPLd and in the kernel, we have not been satisfied with the stability of the system Is there anything that I can avoid while still using the card (ie; specific RAID config)? We haven't had a chance yet to qual the latest firmware, etc., but we went with dumb IDE expansion cards (we're only using 4 ide drives per system) and we're getting better speed (RAID0 or 1+0 depending) than we were off the 3ware card. We are not using XFS, so no comments there. We're also having some problems with Mysql that people keep pointing fingers at LVM for, but at this time we're point right back and saying No! in a firm voice... What kind of problems with MySQL, if you don't mind to summarize? Thank You, Anthony - 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
Syntax question.
Erik, Thursday, March 07, 2002, 12:58:26 AM, you wrote: ES Trying to figure out how to convert Sybase ASA syntax to MySQL. Need to ES select alpha ranges as in: ES SELECT * ES FROM table ES WHERE name LIKE '[A-Z]%' ES but this doesn't work. You should use REGEXP instead LIKE. REGEXP has more scopes. You can read about REGEXP and LIKE at: http://www.mysql.com/doc/P/a/Pattern_matching.html ES Erik Schwartz -- For technical support contracts, goto https://order.mysql.com/ This email is sponsored by Ensita.net http://www.ensita.net/ __ ___ ___ __ / |/ /_ __/ __/ __ \/ /Victoria Reznichenko / /|_/ / // /\ \/ /_/ / /__ [EMAIL PROTECTED] /_/ /_/\_, /___/\___\_\___/ MySQL AB / Ensita.net ___/ www.mysql.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
Importing .sql files into database.
Josiah, Thursday, March 07, 2002, 8:18:58 AM, you wrote: JW I know how to inport a .sql file into mysql by using mysql -u username -p JW password filename.mysql(sql) but how do you import one that is made to go JW into a database you already have created? Would the command by mysql -u JW username -p password dbname filename.sql(mysql) Justa redirect the standard input from a file: mysql database_name -u username -p password filename.sql JW Josiah Wallingford -- For technical support contracts, goto https://order.mysql.com/ This email is sponsored by Ensita.net http://www.ensita.net/ __ ___ ___ __ / |/ /_ __/ __/ __ \/ /Egor Egorov / /|_/ / // /\ \/ /_/ / /__ [EMAIL PROTECTED] /_/ /_/\_, /___/\___\_\___/ MySQL AB / Ensita.net ___/ www.mysql.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
MySQL with Delphi 5.0
José, Thursday, March 07, 2002, 3:08:13 AM, you wrote: JHFT I've already installed MyODBC and configured the driver correctly JHFT (accoriding a book I'm reading) at ODBC User DNS. But, when I run Database JHFT Desktop and gonna make a New Table the option of MySQL does not appear JHFT (according the book appear as show a figure). JHFT Is there lefting something else? I tried to create table with Database Desktop and the table was created :) I developed software on Delphi with MySQL database but I never used Database Desktop. At mysql.com you can find APIs for Delphi, maybe they will be useful for you. Look at: http://www.mysql.com/downloads/contrib.html JHFT Thanks -- For technical support contracts, goto https://order.mysql.com/ This email is sponsored by Ensita.net http://www.ensita.net/ __ ___ ___ __ / |/ /_ __/ __/ __ \/ /Victoria Reznichenko / /|_/ / // /\ \/ /_/ / /__ [EMAIL PROTECTED] /_/ /_/\_, /___/\___\_\___/ MySQL AB / Ensita.net ___/ www.mysql.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
help me???
ld99ba, Thursday, March 07, 2002, 11:22:15 AM, you wrote: l please tell me how to install mysql for sco unix 5.0.5??? l need file??? You can find info how to install MySQL binary distribution at: http://www.mysql.com/doc/I/n/Installing_binary.html Check also the following link. You can find some notes for SCO here: http://www.mysql.com/doc/S/C/SCO.html l thank you !!! -- For technical support contracts, goto https://order.mysql.com/ This email is sponsored by Ensita.net http://www.ensita.net/ __ ___ ___ __ / |/ /_ __/ __/ __ \/ /Egor Egorov / /|_/ / // /\ \/ /_/ / /__ [EMAIL PROTECTED] /_/ /_/\_, /___/\___\_\___/ MySQL AB / Ensita.net ___/ www.mysql.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
Using MyODBC. Does ONE ADO query... Log shows THREE!!
The first query shown in the log is the one I actually tells ADO.Open to run... however just after that one it runs two more (the two tables includes in the first query) select * queries... Why?? This slows down the ADO a lot. Even Jet4.0 doesn't do that on the same query and is therefore about 100 times faster on this particular query. Below is the log... 020307 8:38:03 55 Query SELECT Sum(tblAssignmentProducts.Quantity * tblAssignmentProducts.ModPrice) AS ExtendedPrice, Sum(tblAssignmentProducts.Quantity * tblProducts.Price) AS ExtendedInPrice FROM tblAssignmentProducts INNER JOIN tblProducts ON tblAssignmentProducts.ProductID = tblProducts.ProductID WHERE (tblAssignmentProducts.AssignmentID = 10002) AND (tblAssignmentProducts.ShowRecord = 'True') 55 Query SELECT * FROM tblAssignmentProducts 55 Query SELECT * FROM tblProducts Ruben - 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
UPATE Using Max?
Rutledge, Wednesday, March 06, 2002, 10:01:56 PM, you wrote: Reoen In my application I would like to update a MySQL record where one Reoen column Reoen is the largest value. Do I have to create a separate SELECT sql query Reoen statement Reoen to get that value and then update it? Or, is there a function that Reoen allows me to specify it as part of my WHERE clause. I scanned the Reoen manual and found reference to MAX, which appears to do it and can't get Reoen it working. Reoen The syntax I've tried... Reoen UPDATE PICKING SET COL_1 =3D 'My_VAL' WHERE COL_2=3D'My_VAL2' AND Reoen MAX(AUDIT); ^ It means that selection maximum value from table will be before update. This can be re-written as: SELECT @a:=MAX(audit) FROM picking; UPDATE picking SET col_1= WHERE audit=@a; -- For technical support contracts, goto https://order.mysql.com/ This email is sponsored by Ensita.net http://www.ensita.net/ __ ___ ___ __ / |/ /_ __/ __/ __ \/ /Victoria Reznichenko / /|_/ / // /\ \/ /_/ / /__ [EMAIL PROTECTED] /_/ /_/\_, /___/\___\_\___/ MySQL AB / Ensita.net ___/ www.mysql.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
between
Hi
In mysql I found a problem with between query.
For example
select * from bugdetail where
dbugcreate_date between from_days(to_days('2002-03-01')) and
from_days(to_days('2002-03-04'))
this query shows only those records up to '2002-03-03' instead of
'2002-03-04'
pl. help
Manish
-
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: between
Hi
In mysql I found a problem with between query.
For example
select * from bugdetail where
dbugcreate_date between from_days(to_days('2002-03-01')) and
from_days(to_days('2002-03-04'))
this query shows only those records up to '2002-03-03' instead of
'2002-03-04'
Are all that date calculations necessary?
SELECT * FROM bugdetail WHERE dbugcreate_date BETWEEN '2002-03-01' AND
'2002-03-04'
Would work just as well =)
Also from what you're saying everything seems correctdon't forget the
dates without a time are considered to be at the beginning of that day
So technically you're asking
SELECT * FROM bugdetail WHERE dbugcreate_date BETWEEN '2002-03-01 00:00:00'
AND '2002-03-04 00:00:00'
which will only show result from beginning of march first to the end of
march 3rd. You need to increment the final date by a day to get the fully
results you're seeking.
Sincerely,
Craig Vincent
-
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: Trouble with BOOLEAN fulltext search
Hi!
On Mar 07, Thomas Spahni wrote:
On Wed, 6 Mar 2002, Sergei Golubchik wrote:
mysql SELECT doc FROM plaintext WHERE MATCH(bgetxt) AGAINST('placi*' IN
BOOLEAN MODE);
Empty set (0.00 sec)
It is a bug.
You can - either create a repeatable test case, to be sure,
the bug will be fixed in 4.0.2, ...
Hello Sergei,
here is your testcase. I reduced the dataset to 2 rows containing the word
I'm looking for. I was lucky and the bug persisted. You may save the
appendix to a file like 'testcase.sql' and then pipe it through mysql. For
me this happens:
cat testcase.sql | mysql -t
+-+
| doc |
+-+
| 122 III 150 |
| 84 II 304 |
+-+
The same result should appear twice!
Thank you for a test case !
The bug will be fixed in 4.0.2.
Regards,
Sergei
--
MySQL Development Team
__ ___ ___ __
/ |/ /_ __/ __/ __ \/ / Sergei Golubchik [EMAIL PROTECTED]
/ /|_/ / // /\ \/ /_/ / /__ MySQL AB, http://www.mysql.com/
/_/ /_/\_, /___/\___\_\___/ Osnabrueck, Germany
___/
-
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 text type field
Hi there, I am interested if there any URL I can read more about text type fields in MySQL. I had an argument with a friend who said that if I use text type in a table it will make the system to work to slow. But I realy needed this text field because I wanted to store text more than 256 symbols. And I thought if I make not SELECT * FROM table queries but SELECT field1, field2 FROM table queries and not to select the text field every time there wouldn't be problem. Anybody to know more about this optimization ? Thank in advance. SaS. - 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 series selection help
Hi MySQL, I record some stock data into MySQL, I'm looking for the correct syntax for a SELECT statement. SELECT min(Tmin) FROM quotes WHERE low=min(low) In short, I want the time of the occurance of the low for the day, Tmin is time column. Once the low is achieved, all the remaining data for the day has the same low recorded, so I want the first occurance. I tried SELECT min(tmin) FROM quotes WHERE tag='CSCO' HAVING min(low); which at least didn't have syntax errors, but alas did not produce a result. MIN() etc are group functions, so it is difficult to compare them with (scalar) values from individual rows - hence the failure of the first attempt. The second attempt is missing the intended comparison in the HAVING clause, so the MIN() result is interpreted as boolean and 'this dog don't hunt, Wilbur!'. I'm a little confused about the ambiguities of the MIN( tmin ) in the SELECT clause - perhaps you should post your table schema - if this is relevant. Using a test table I happened to have 'lying around', would this approach fit the bill? SELECT id, type_id, product_id FROM attribute WHERE type_id = 2 HAVING min( product_id ) = product_id; Regards, =dn - 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
To check if column exists before adding to table
Hi! How do i check if a column(name) do not exists in a table before i add it? Like: alter table fruit add aple varchar(20) not null if aple do not exists Best regards Oyvind mysql - 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: MySQL text type field
Hi Alexander, I am interested if there any URL I can read more about text type fields in MySQL. I had an argument with a friend who said that if I use text type in a table it will make the system to work to slow. But I realy needed this text field because I wanted to store text more than 256 symbols. And I thought if I make not SELECT * FROM table queries but SELECT field1, field2 FROM table queries and not to select the text field every time there wouldn't be problem. Anybody to know more about this optimization ? Retrieval from a table with fixed length rows will be faster than a similar row structure involving variable length fields/rows. Was that the tone of your discussion? =dn - 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: MySQL text type field
On Thu, 7 Mar 2002 12:03:05 - DL Neil [EMAIL PROTECTED] wrote: Hi Alexander, I am interested if there any URL I can read more about text type fields in MySQL. I had an argument with a friend who said that if I use text type in a table it will make the system to work to slow. But I realy needed this text field because I wanted to store text more than 256 symbols. And I thought if I make not SELECT * FROM table queries but SELECT field1, field2 FROM table queries and not to select the text field every time there wouldn't be problem. Anybody to know more about this optimization ? Retrieval from a table with fixed length rows will be faster than a similar row structure involving variable length fields/rows. Was that the tone of your discussion? =dn No I was wondering exactly how to construct a table if I need text field and at the same time to satisfy the requirements of a very hi load server - 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: MySQL text type field
Alexander, go ahead and use those fields of type TEXT. Retrieval works like a charm. Building the index on large tables may be slow, but the manual gives some tricks how to speed things up. As soon as you have VARCHAR fields you are into variable record lengths anyway. And you can even have a FULLTEXT index on all your VARCHAR and TEXT fields. Thomas Spahni I made something like second MySQL table which contains only the text fields and when I need to select one I have index relation. But I was not sure is it faster than to have the text fields in the same table or it is only unneeded complexity SaS. - 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: Trouble with BOOLEAN fulltext search
On Wed, 6 Mar 2002, Sergei Golubchik wrote:
mysql SELECT doc FROM plaintext WHERE MATCH(bgetxt) AGAINST('placi*' IN
BOOLEAN MODE);
Empty set (0.00 sec)
It is a bug.
You can - either create a repeatable test case, to be sure,
the bug will be fixed in 4.0.2, ...
Hello Sergei,
here is your testcase. I reduced the dataset to 2 rows containing the word
I'm looking for. I was lucky and the bug persisted. You may save the
appendix to a file like 'testcase.sql' and then pipe it through mysql. For
me this happens:
cat testcase.sql | mysql -t
+-+
| doc |
+-+
| 122 III 150 |
| 84 II 304 |
+-+
The same result should appear twice!
Regards,
Thomas Spahni
-
USE test;
-- MySQL dump 8.19
--
-- Host: localhostDatabase: bge
-
-- Server version 4.0.1-alpha
--
-- Table structure for table 'testcase'
--
DROP TABLE IF EXISTS testcase;
CREATE TABLE testcase (
id int(11) NOT NULL auto_increment,
doc varchar(16) NOT NULL default '',
code int(10) unsigned NOT NULL default '0',
part tinyint(4) NOT NULL default '0',
bgetxt text,
PRIMARY KEY (id),
KEY doc (doc),
KEY code (code),
FULLTEXT KEY bgetxt (bgetxt)
) TYPE=MyISAM;
--
-- Dumping data for table 'testcase'
--
LOCK TABLES testcase WRITE;
INSERT INTO testcase VALUES (8139,'122 III 150',2047148182,1,'122 III 150\n\n31.
Auszug aus dem Urteil der II. Zivilabteilung vom 14. Mai 1996 i.S. Reto\nund Christina
M. gegen Guido und Frida R. (Berufung) Regeste\n\nArt. 731 Abs. 3 ZGB; Ersitzung
einer Grunddienstbarkeit.\n\nGehört ein Grundstück zum unverteilten Nachlass, ist
eine Ersitzung\ndes Alleineigentums durch einen Erben ausgeschlossen. Fällt
eine\nEigentumsersitzung ausser Betracht, kann nach Art. 731 Abs. 3 ZGB auch\neine
Ersitzung einer Grunddienstbarkeit nicht in Frage kommen. Daran ändert\nnichts, dass
die Eigentumsersitzung im Grundbuch vollzogen wurde (E. 2).\n\nEin Teil eines
ungültigen Erbteilungsvertrages kann als\nDienstbarkeitsvertrag selbständigen Bestand
haben, wenn dieser Teil\nhinsichtlich Form und Inhalt den gesetzlichen Anforderungen
an einen\nDienstbarkeitsvertrag entspricht (E. 3).\n\nSachverhalt\n\nA.- Auf den
Grundstücken Parzellen Nr. 204 und 205 in Flims-Dorf steht\nein altes Bündner
Haus, welches seinerzeit Placidus S. gehörte. Bei seinem\nTod im Jahr 1912
hinterliess Placidus S. vier Töchter. Am 18. Januar 1913\nschlossen die vier Töchtern
des Placidus S. die folgende Vereinbarung ab:\n\n\Entelgienscha\n\nDenter las
soras S. ei sentelgiu il savundont.\n\n1. L\'Agnes ha il dretg da cumprar anavos
la mezzadat dil\n curtgin della purteglia engiu, per fr. Duamilli sche quei
daventa\n enteifer il temps da Diesch onns.\n\n2. Tiers la part casa dadens
sauda.\n\na. La stiva cun combra,\n\nb. la combra sura gronda cun la combra
visavi,\n\nc. la combra sisum davart dadens e la combra da carn,\n\nd. ils dus
tschalèrs della part dadens cun comunabel della\n gudiment veulta (Vorplatz),\n\n
e. il locus (Abtritt) sut,\n\nf. igl \Estrich\ dadens,\n\ng. la part
pastrin della \fanteuna Gliott\\n\nh. ils vaus en casa e la veulta vegnen gudi
comunablamein\n [ganze Litera durchgestrichen]\n\nh. il nuel sut,\n\ni.
en clavau la foppa et ils dus ladritschs g!
ronds en
tadim\n cun ina teuna da paglia oradim clavau davart dadens,\n\n3. La part dador
compeglia\n tut ils locals ch\'ein sura buc manai si.\n\n4. Ils vaus en casa e
la veulta, sco era il curtgin e tut posses\n enturn ils bagetgs vegnien gudi
comunablamein.\n\nQuella partgida eis fatgia en preschienscha e cun cuntentienscha
dellas\n suttascrittas soras S. entras igl incombensan\n\nFlem, ils 18 da
Schanèr 1913\n\n(sig. Y.)\n\nN.B. Per partiala midada e definaziun da quei
chei cunteneu sut Ziff.1\n ei fatg ina speziala entelgienscha denter las soras
Agnes, Anna e\n\nChristina, tenor la quala il temps ei fixaus definitiv sin
quindisch\nonns.\n\nL\'Agnes sa dentont haver il platz mo per seza baghegiar sin
quel.\n\n[Letzter Satz durchgestrichen.]\n\nFlem, ils 18 da Schanèr 1913\n\n
(sig. Anna S.\n\nChristina S.\n\nMaria C.-S.\n\nAgnes S.).\\n\nIn
der Folge wurde der Hausteil West von Christina R.-S. und\nder Hausteil Ost von
Anna M.-S. übernommen; im seinerzeitigen\nKauf- und Pfandprotokoll der Gemeinde Flims
wurde diesbezüglich\nnichts verurkundet. Kurz vor Einführung des Liegenschaften-
und\nServitutenregisters am 1. Mai 1956 wurden kraft einer Verfügung\ndes Kreisamtes
Trins vom 7. Februar 1955 \im Ersitzungsverfahren\\nChristina R.-S. als Eigentümerin
der Parzelle 204 (Hausteil West) und\nAnna M.-S. als Eigentümerin der Parzelle 205
(Hausteil Ost) im Grundbuch\nFlims eingetragen.\n\nNach dem Tod von Christina
R.-S. ging der Hausteil West im Jahr 1973\ndurch
Re: Feature idea inspired by bug report
Hi Monty and Sasha, Just a quick not to say that's such a great idea that Monty even thought of it before! Monty and I discussed this last September, I hope we could get something like this in 4.1 Just a vote! Thanks Ken - Original Message - From: Sasha Pachev [EMAIL PROTECTED] To: [EMAIL PROTECTED] Cc: [EMAIL PROTECTED]; [EMAIL PROTECTED] Sent: Wednesday, March 06, 2002 8:42 PM Subject: Re: Feature idea inspired by bug report On Wednesday 06 March 2002 04:35 am, Michael Widenius wrote: Instead of disabling disk based temp tables, we could instead restrict the size of them which should be equally good. ?(By setting the disk size to 0 you would be able to disable them, but we should not recommend this setting). That's even better! -- MySQL Development Team For technical support contracts, visit https://order.mysql.com/ __ ___ ___ __ / |/ /_ __/ __/ __ \/ / Sasha Pachev [EMAIL PROTECTED] / /|_/ / // /\ \/ /_/ / /__ MySQL AB, http://www.mysql.com/ /_/ /_/\_, /___/\___\_\___/ Provo, Utah, USA ___/ - 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 Database Replication Question
All, How can I notify an application running on the slave server that the slave database has just updated itself by means of replication. The reason I ask is that I know MySql currently doesn't support triggers, but my application needs to be notified when an update on the slave has just taken place. Once again, thanks for your time. Thi - 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
Can not connect (again)
Ok people, I'm desperate for the help. I'm going to try to be as detailed as possible, because I need the two year old explanation. I recently installed MySQL on my Cobalt Raq3. I was running fine, created a db, table created a user, gave some permissions, and thought I was rolling along. Somewhere in setting the permissions and using safe_mysql I messed something up. I am now getting an Error 2002 can't connect to local Mysql through socket var/lib/mysql/mysql.socket. I don't know much about the socket file, so if that has something to do with the problem, I'll need a brief explanation. Can someone PLEASE HELP because I'm desperate to get this fixed yesterday. 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
changing the ft_min_word_len variable in 3.23.49
Hello, I don't know if this is possible but I need to change the ft_min_word_len variable from 4 to 2. The machine mysql is running on is Debian so I would like to try to do this without recompiling it if possible. Thanks, Keith ### Keith Elder Email: [EMAIL PROTECTED] AIM: ZZorKKa YIM: keitheld Phone: 1-734-507-1438 Text Messaging (145 characters): [EMAIL PROTECTED] Web: http://www.zorka.com (Howto's, News, and hosting!) With enough memory and hard drive space anything in life is possible! ### - 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 mysql-unsubscribe-##L=##[EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Lock row
Hi, I want to lock a row in a table, and just the row I have selected what's the solution under MySQL Thank's Dominique - 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
Can not connect (again)
Thursday, March 07, 2002, 4:49:57 PM, you wrote: d Ok people, I'm desperate for the help. I'm going to try to be as detailed d as possible, because I need the two year old explanation. I recently d installed MySQL on my Cobalt Raq3. I was running fine, created a db, table d created a user, gave some permissions, and thought I was rolling along. d Somewhere in setting the permissions and using safe_mysql I messed something d up. I am now getting an Error 2002 can't connect to local Mysql through d socket var/lib/mysql/mysql.socket. I don't know much about the socket file, d so if that has something to do with the problem, I'll need a brief d explanation. Can someone PLEASE HELP because I'm desperate to get this d fixed yesterday. dlyles, as I answered you 2 days ago: If your MySQL server is running then you should check location of the socket file and check the socket path in your my.cnf file. Check your privileges on the socket file and on the dir that contains socket file. You can find the description of this error at: http://www.mysql.com/doc/C/a/Can_not_connect_to_server.html d Thank you. -- For technical support contracts, goto https://order.mysql.com/ This email is sponsored by Ensita.net http://www.ensita.net/ __ ___ ___ __ / |/ /_ __/ __/ __ \/ /Egor Egorov / /|_/ / // /\ \/ /_/ / /__ [EMAIL PROTECTED] /_/ /_/\_, /___/\___\_\___/ MySQL AB / Ensita.net ___/ www.mysql.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: Lock row
InnoDB! --Walt -Original Message- From: Dominique DUTENDAS [mailto:[EMAIL PROTECTED]] Sent: Thursday, March 07, 2002 8:02 AM To: MySQL Subject: Lock row Hi, I want to lock a row in a table, and just the row I have selected what's the solution under MySQL Thank's Dominique - 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: To check if column exists before adding to table
* oe-ander How do i check if a column(name) do not exists in a table before i add it? Like: alter table fruit add aple varchar(20) not null if aple do not exists As far as I can see, you have two options: - Do a describe fruit, and check the Field column - Do the alter table..., and check for a error msg The second method is probably best, because you can not be sure if someone have added the column after you do a describe fruit, but before you do your alter table -- Roger query - 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 .sql files into database.
At 12:06 +0200 3/7/02, Egor Egorov wrote: Josiah, Thursday, March 07, 2002, 8:18:58 AM, you wrote: JW I know how to inport a .sql file into mysql by using mysql -u username -p JW password filename.mysql(sql) but how do you import one that is made to go JW into a database you already have created? Would the command by mysql -u JW username -p password dbname filename.sql(mysql) Justa redirect the standard input from a file: mysql database_name -u username -p password filename.sql 1. The database name goes after the options, not before. 2. There can't be any space between -p and the password. mysql -u username -ppassword database_name filename.sql JW Josiah Wallingford - 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 .sql files into database.
At 9:35 -0600 3/7/02, Paul DuBois wrote: At 12:06 +0200 3/7/02, Egor Egorov wrote: Josiah, Thursday, March 07, 2002, 8:18:58 AM, you wrote: JW I know how to inport a .sql file into mysql by using mysql -u username -p JW password filename.mysql(sql) but how do you import one that is made to go JW into a database you already have created? Would the command by mysql -u JW username -p password dbname filename.sql(mysql) Justa redirect the standard input from a file: mysql database_name -u username -p password filename.sql 1. The database name goes after the options, not before. 2. There can't be any space between -p and the password. mysql -u username -ppassword database_name filename.sql JW Josiah Wallingford Hm. Well, after seeing *two* responses with the database name listed prior to the options, I tried invoking mysql that way, and it worked. Don't that beat all. The mysql --help message still says the db name follows the options, but I guess it's actually more forgiving. - 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
data directory
Can the data directory reside on a different machine than the mysql program itself, such as on a maxattach storage device. Thanks, stephen - 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 on Solaris
Hi members, This is my first query :) My query is about installing MySql on Solaris. I am interested in downloading and installing the stable version of MySql on solaris 2.6. I downloaded mysql-3.22.25-solaris7-x86.pkg.tgz and MySQL 3.23. I tried to install the first one (used GNU tar) . I followed the documentation and tried to install the binary. I had various problems. when i ran mysql_install_db, it gives error thast user id mysql not created. make install is giving error saying mysql not intialized. Also when i tried with MySQL 3.23, i was unable to configure and build. I could succesfully download and install MySql for Windows 95, but Solaris has given me a lot of problems. I request members to please send me a doc or explain the installation of MySql on Solaris 2.6. The link http://www.mysql.com/doc/S/o/Solaris_2.7.html does not help me much as you can see. I am interested in downloading and installing the binaries only. Please help me to to get it up and running. In anticipation Best Regards, Anis - 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: MySql on Solaris
Ahmed, Forget about it. I tried to do this, I tried for about two weeks, then got mad and downloaded the src and compile it mysql. It works great. -chad if you do get it working let me know On Thu, 07 Mar 2002 09:14:58 -0700 Ahmed S K Anis [EMAIL PROTECTED] wrote: Hi members, This is my first query :) My query is about installing MySql on Solaris. I am interested in downloading and installing the stable version of MySql on solaris 2.6. I downloaded mysql-3.22.25-solaris7-x86.pkg.tgz and MySQL 3.23. I tried to install the first one (used GNU tar) . I followed the documentation and tried to install the binary. I had various problems. when i ran mysql_install_db, it gives error thast user id mysql not created. make install is giving error saying mysql not intialized. Also when i tried with MySQL 3.23, i was unable to configure and build. I could succesfully download and install MySql for Windows 95, but Solaris has given me a lot of problems. I request members to please send me a doc or explain the installation of MySql on Solaris 2.6. The link http://www.mysql.com/doc/S/o/Solaris_2.7.html does not help me much as you can see. I am interested in downloading and installing the binaries only. Please help me to to get it up and running. In anticipation Best Regards, Anis - 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
Stepping through a MySQL_fetch_array in PHP?
Could anybody please help:
In the query I have included a limit string which allows me to display
individual records page by page. The limit string variable is
incremented/decremented using hyperlinks. I feel it would be better if I
could somehow manually step through the returned
$query_data = mysql_fetch_array($result). Is it possible to create a loop
with a counter to step through the records contained in the array?
// PHP Code
$link_id = db_connect($default_dbname) ;
if(!$link_id) error_message(sql_error()) ;
$query = select count(*) from $user_tablename ;
$result = mysql_query($query) ;
if(!$result) error_message(sql_error()) ;
$query_data = mysql_fetch_row($result) ;
$total_num_user = $query_data[0] ;
if(!$total_num_user) error_message('No records found!') ;
$query = select usernumber, userid, userpassword, username, sex,
nationality, usermail, userprofile, registerdate, date_format(registerdate,
'%M, %e, %Y') as formatted_registerdate, lastaccesstime,
date_format(lastaccesstime, '%M, %e, %Y') as formatted_lastaccesstime from
$user_tablename $order_by_str $sort_order_str $limit_str ;
$result = mysql_query($query) ;
if(!$result) error_message(sql_error()) ;
$query_data = mysql_fetch_array($result) ;
// Table displaying the found records from MySQL database
Thanx
Gavin
Bug ? : Mysql access rights problem ...
Bonjour, I have a problem with Mysql and access rights : I have a user who has rights to access tables in the database 'membres' : #/ mysqlaccess 192.168.0.1 myuser membres Could not open outputfile ~/mysqlaccess.log for debugging-info mysqlaccess Version 2.06, 20 Dec 2000 By RUG-AIV, by Yves Carlier ([EMAIL PROTECTED]) Changes by Steve Harvey ([EMAIL PROTECTED]) This software comes with ABSOLUTELY NO WARRANTY. Access-rights for USER 'myuser', from HOST '192.168.0.1', to DB 'membres' +-+---+ +-+---+ | Select_priv | Y | | Shutdown_priv | N | | Insert_priv | Y | | Process_priv| N | | Update_priv | Y | | File_priv | N | | Delete_priv | Y | | Grant_priv | N | | Create_priv | Y | | References_priv | Y | | Drop_priv | Y | | Index_priv | Y | | Reload_priv | N | | Alter_priv | Y | +-+---+ +-+---+ NOTE:A password is required for user `myuser' :-( The following rules are used: db: '192.168.0.%','membres','myuser','Y','Y','Y','Y','Y','Y','N','Y','Y','Y' host : 'Not processed: host-field is not empty in db-table.' user : '192.168.0.%','myuser','','N','N','N','N','N','N','N','N','N','N','N','N','N','N' This works fine all day long, but each morning when I come back to work, my web site is no more working and the reason is : ERROR 1044: Access denied for user: '[EMAIL PROTECTED]' to database 'membres' If I test 'mysqlaccess 192.168.0.1 myuser membres' I have the same thing as above. And as soon as I run 'mysqladmin reload' , it corrects the problem and my web site is back. It's 3 days I have this problem. Maybe a program of mine is doing something that Mysql doesn't like each nights, but for me, this shouldn't impact Mysql's access rights. And I don't understand why 'mysqlaccess' is returning the good result but Mysql isn't granting access before I ask to reload access rights ... I had this problem with Mysql-3.23.47, I upgraded to 3.23.49 but I still have the same problem. Any idea ? Regards, Alex. - 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
Perl DBI installation. Help!
Hello all, I am new to linux. I was told that I need DBI::DBD to connect to Mysql using perl. So I go to http://www.mysql.com/downloads/api-dbi.html and downloaded DBI-1.18.tar.gz, Msql-Mysql-modules-1.2216.tar.gz. Using gunzip, I unziped the two files. Now I have DBI-1.18.tar and Msql-Mysql-modules-1.2216.tar. What should I do next to install them and test them? Thanks for the help _ Chat with friends online, try MSN Messenger: http://messenger.msn.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: Can not connect (again)
Bonjour, Did you try to connect to the server from network ? Try to force mysql client not to use the socket (what is does when it's connecting to localhost). Try to connect from another server or even from the same server but with the --host=xxx.xxx.xxx.xxx where xxx.xxx.xxx.xxx is the IP of the server (not 127.0.0.0 which is localhost !). This way you should be able to shutdown mysqld safely. When you restart Mysql, it will recreate the socket file. Regards, Alex. d Ok people, I'm desperate for the help. I'm going to try to be as detailed d as possible, because I need the two year old explanation. I recently d installed MySQL on my Cobalt Raq3. I was running fine, created a db, table d created a user, gave some permissions, and thought I was rolling along. d Somewhere in setting the permissions and using safe_mysql I messed something d up. I am now getting an Error 2002 can't connect to local Mysql through d socket var/lib/mysql/mysql.socket. I don't know much about the socket file, d so if that has something to do with the problem, I'll need a brief d explanation. Can someone PLEASE HELP because I'm desperate to get this d fixed yesterday. - 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: Stepping through a MySQL_fetch_array in PHP?
$sql=select * from table where blah=$blah;
$x=mysql_query($sql);
while ($data=mysql_fetch_array($x)) {
echo $data[columnName];
}
I think is what your trying to do...
On Thu, 7 Mar 2002, Gavin Philips-Page wrote:
|Could anybody please help:
|
|In the query I have included a limit string which allows me to display
|individual records page by page. The limit string variable is
|incremented/decremented using hyperlinks. I feel it would be better if I
|could somehow manually step through the returned
|$query_data = mysql_fetch_array($result). Is it possible to create a loop
|with a counter to step through the records contained in the array?
|
|// PHP Code
|$link_id = db_connect($default_dbname) ;
| if(!$link_id) error_message(sql_error()) ;
|$query = select count(*) from $user_tablename ;
|$result = mysql_query($query) ;
|if(!$result) error_message(sql_error()) ;
|$query_data = mysql_fetch_row($result) ;
|$total_num_user = $query_data[0] ;
|if(!$total_num_user) error_message('No records found!') ;
|
|$query = select usernumber, userid, userpassword, username, sex,
|nationality, usermail, userprofile, registerdate, date_format(registerdate,
|'%M, %e, %Y') as formatted_registerdate, lastaccesstime,
|date_format(lastaccesstime, '%M, %e, %Y') as formatted_lastaccesstime from
|$user_tablename $order_by_str $sort_order_str $limit_str ;
|
|$result = mysql_query($query) ;
|if(!$result) error_message(sql_error()) ;
|
|$query_data = mysql_fetch_array($result) ;
|// Table displaying the found records from MySQL database
|
|Thanx
|
|Gavin
|
|
-
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: MySql Database Replication Question
On Thu, Mar 07, 2002 at 08:37:00AM -0600, Thi Cao wrote: All, How can I notify an application running on the slave server that the slave database has just updated itself by means of replication. The reason I ask is that I know MySql currently doesn't support triggers, but my application needs to be notified when an update on the slave has just taken place. Once again, thanks for your time. Hm, that's a little unusual. Could the application look at the output of SHOW SLAVE STATUS once in a while, maybe? -- Jeremy D. Zawodny, [EMAIL PROTECTED] Technical Yahoo - Yahoo Finance Desk: (408) 349-7878 Fax: (408) 349-5454 Cell: (408) 685-5936 MySQL 3.23.47-max: up 28 days, processed 988,263,631 queries (407/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: changing the ft_min_word_len variable in 3.23.49
I actually wound up pulling down a deb-src and changing myisam/ftdefs.h #define MIN_WORD_LEN 2 Compiled a .deb out of it and put it in. Seems to be working. Thank goodness they made this a varible in 4.0. K. * Paul DuBois ([EMAIL PROTECTED]) wrote: Date: Thu, 7 Mar 2002 09:33:09 -0600 To: Keith Elder [EMAIL PROTECTED], [EMAIL PROTECTED] From: Paul DuBois [EMAIL PROTECTED] Subject: Re: changing the ft_min_word_len variable in 3.23.49 At 9:59 -0500 3/7/02, Keith Elder wrote: Hello, I don't know if this is possible but I need to change the ft_min_word_len variable from 4 to 2. The machine mysql is running on is Debian so I would like to try to do this without recompiling it if possible. That's a MySQL 4.x feature. Thanks, Keith ### Keith Elder Email: [EMAIL PROTECTED] AIM: ZZorKKa YIM: keitheld Phone: 1-734-507-1438 Text Messaging (145 characters): [EMAIL PROTECTED] Web: http://www.zorka.com (Howto's, News, and hosting!) With enough memory and hard drive space anything in life is possible! ### - 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 mysql-unsubscribe-##L=##[EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: Stepping through a MySQL_fetch_array in PHP?
Hi Gavin,
I didn't know if you knew this or not but there is a site which
provides lives PHP / MySQL support. Take a look at http://www.phphelpdesk.com . It
is a live PHP support site which helps you get real time answers to PHP problems.
Keith
* Gavin Philips-Page ([EMAIL PROTECTED]) wrote:
User-Agent: Microsoft-Entourage/9.0.2509
Date: Thu, 07 Mar 2002 18:20:31 +0200
Subject: Stepping through a MySQL_fetch_array in PHP?
From: Gavin Philips-Page [EMAIL PROTECTED]
To: MySQL Problems [EMAIL PROTECTED]
Could anybody please help:
In the query I have included a limit string which allows me to display
individual records page by page. The limit string variable is
incremented/decremented using hyperlinks. I feel it would be better if I
could somehow manually step through the returned
$query_data = mysql_fetch_array($result). Is it possible to create a loop
with a counter to step through the records contained in the array?
// PHP Code
$link_id = db_connect($default_dbname) ;
if(!$link_id) error_message(sql_error()) ;
$query = select count(*) from $user_tablename ;
$result = mysql_query($query) ;
if(!$result) error_message(sql_error()) ;
$query_data = mysql_fetch_row($result) ;
$total_num_user = $query_data[0] ;
if(!$total_num_user) error_message('No records found!') ;
$query = select usernumber, userid, userpassword, username, sex,
nationality, usermail, userprofile, registerdate, date_format(registerdate,
'%M, %e, %Y') as formatted_registerdate, lastaccesstime,
date_format(lastaccesstime, '%M, %e, %Y') as formatted_lastaccesstime from
$user_tablename $order_by_str $sort_order_str $limit_str ;
$result = mysql_query($query) ;
if(!$result) error_message(sql_error()) ;
$query_data = mysql_fetch_array($result) ;
// Table displaying the found records from MySQL database
Thanx
Gavin
###
Keith Elder
Email: [EMAIL PROTECTED] AIM: ZZorKKa YIM: keitheld
Phone: 1-734-507-1438
Text Messaging (145 characters): [EMAIL PROTECTED]
Web: http://www.zorka.com (Howto's, News, and hosting!)
With enough memory and hard drive space
anything in life is possible!
###
-
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 mysql-unsubscribe-##L=##[EMAIL PROTECTED]
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
RE: MySql Database Replication Question
Jeremy, I'm not sure I follow. What information from that command would the app be looking for specifically. Maybe you're saying the app should look at the position of the master's binary log file. Is that what you suggest? Thi -Original Message- From: Jeremy Zawodny [mailto:[EMAIL PROTECTED]] Sent: Thursday, March 07, 2002 10:42 AM To: Thi Cao Cc: MySQL Subject: Re: MySql Database Replication Question On Thu, Mar 07, 2002 at 08:37:00AM -0600, Thi Cao wrote: All, How can I notify an application running on the slave server that the slave database has just updated itself by means of replication. The reason I ask is that I know MySql currently doesn't support triggers, but my application needs to be notified when an update on the slave has just taken place. Once again, thanks for your time. Hm, that's a little unusual. Could the application look at the output of SHOW SLAVE STATUS once in a while, maybe? -- Jeremy D. Zawodny, [EMAIL PROTECTED] Technical Yahoo - Yahoo Finance Desk: (408) 349-7878 Fax: (408) 349-5454 Cell: (408) 685-5936 MySQL 3.23.47-max: up 28 days, processed 988,263,631 queries (407/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: MySQL Database Replication
On Wed, 2002-03-06 at 14:26, Thi Cao wrote: When I grant privileges as follows, the slave gets updated: GRANT FILE ON *.* to repl@'%' identified by 'some_password'; Could someone please tell me why I must grant the FILE privilege on all databases for the repl (slave) to be able to update one particular database? MySQL Manual: 4.2.7 Privileges Provided by MySQL: The file privilege gives you permission to read and write files on the server using the LOAD DATA INFILE and SELECT ... INTO OUTFILE statements. Any user to whom this privilege is granted can read or write any file that the MySQL server can read or write. 4.10.3 How To Set Up Replication 2. Set up special a replication user on the master with the FILE privilege and permission to connect from all the slaves. If the user is only doing replication (which is recommended), you don't need to grant any additional privileges. For example, to create a user named repl which can access your master from any host, you might use this command: GRANT FILE ON *.* TO repl@% IDENTIFIED BY 'password'; Thi Cao wrote: Hello everyone, This is my first attempt at MySQL database replication. Can't seem to get it to work yet. The problem reported in the error log of the slave server is as follows: Error reading packet from server: Access denied for user 'repl@slave_host' (Using password: YES) (read_errno 0,server_errno=1045) I believe it has something to do with the way I granted privileges to the user repl. I did the following: GRANT FILE ON dbname.* to repl@'%' identified by 'some_password'; Did you do a FLUSH PRIVILIGES after that? That is needed in some cases. You don't need to flush privileges when using grant/revoke commands. -- dsoares (sql) - 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: 4.0.2 Replication Bug...
On Thursday 07 March 2002 12:42 am, Jeremy Zawodny wrote: My 4.0.2 slave has run through about 14 million queries and it's going well. Good news Do you have any feel for how much slower a debugging version of MySQL is compared to a normal version? ?I ask because my replication heartbeat monitor has noticed this particular slave falling behind on replication a fair amount. ?It usually doesn't get too far behind, but it's certainly farther behind that it's neighbor--which has a slower CPU. Depends on the queries. I would say it could be from 3 to 10 times slower. To know for sure, use BUILD/compile-pentium instead of BUILD/compile-pentium-debug. This will compile a perfectly optimal binary. And could that fact have anything to do with SHOW SLAVE STATUS being slow sometimes? I've figured out what's up with this one, I think. SHOW SLAVE STATUS needs to acquire a simultaneous lock on the I/O thread and on the SQL thread, and it might be a while before both of them will surrender that lock if they are busy. I have been rather conservative and very possibly made the critical region wider that what it should be. I think part of the problem is also in the FreeBSD mutex implementation - the current holder of the mutex surrenders it for only a very short time and it is possible that there could be some starvation issues. I woder if FreeBSD has different mutex types - in this case, we want the kind that puts fairness above speed. -- MySQL Development Team For technical support contracts, visit https://order.mysql.com/ __ ___ ___ __ / |/ /_ __/ __/ __ \/ / Sasha Pachev [EMAIL PROTECTED] / /|_/ / // /\ \/ /_/ / /__ MySQL AB, http://www.mysql.com/ /_/ /_/\_, /___/\___\_\___/ Provo, Utah, USA ___/ - 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: MySQL Database Replication
ds, If I understand you correctly, that also means that the user repl can access the mysql database where all the privilege info is stored and see the permissions, passwords, and such. Yes/No? Thi -Original Message- From: ds [mailto:[EMAIL PROTECTED]] Sent: Thursday, March 07, 2002 11:02 AM To: Thi Cao Cc: MySQL Subject: RE: MySQL Database Replication On Wed, 2002-03-06 at 14:26, Thi Cao wrote: When I grant privileges as follows, the slave gets updated: GRANT FILE ON *.* to repl@'%' identified by 'some_password'; Could someone please tell me why I must grant the FILE privilege on all databases for the repl (slave) to be able to update one particular database? MySQL Manual: 4.2.7 Privileges Provided by MySQL: The file privilege gives you permission to read and write files on the server using the LOAD DATA INFILE and SELECT ... INTO OUTFILE statements. Any user to whom this privilege is granted can read or write any file that the MySQL server can read or write. 4.10.3 How To Set Up Replication 2. Set up special a replication user on the master with the FILE privilege and permission to connect from all the slaves. If the user is only doing replication (which is recommended), you don't need to grant any additional privileges. For example, to create a user named repl which can access your master from any host, you might use this command: GRANT FILE ON *.* TO repl@% IDENTIFIED BY 'password'; Thi Cao wrote: Hello everyone, This is my first attempt at MySQL database replication. Can't seem to get it to work yet. The problem reported in the error log of the slave server is as follows: Error reading packet from server: Access denied for user 'repl@slave_host' (Using password: YES) (read_errno 0,server_errno=1045) I believe it has something to do with the way I granted privileges to the user repl. I did the following: GRANT FILE ON dbname.* to repl@'%' identified by 'some_password'; Did you do a FLUSH PRIVILIGES after that? That is needed in some cases. You don't need to flush privileges when using grant/revoke commands. -- dsoares (sql) - 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: 4.0.2 Replication Bug...
On Thu, Mar 07, 2002 at 09:57:54AM -0700, Sasha Pachev wrote: On Thursday 07 March 2002 12:42 am, Jeremy Zawodny wrote: Do you have any feel for how much slower a debugging version of MySQL is compared to a normal version? ?I ask because my replication heartbeat monitor has noticed this particular slave falling behind on replication a fair amount. ?It usually doesn't get too far behind, but it's certainly farther behind that it's neighbor--which has a slower CPU. Depends on the queries. I would say it could be from 3 to 10 times slower. To know for sure, use BUILD/compile-pentium instead of BUILD/compile-pentium-debug. This will compile a perfectly optimal binary. Okay, it's not a big deal. I was going to just run the debug binary in case things go wrong and you need more detail. And could that fact have anything to do with SHOW SLAVE STATUS being slow sometimes? I've figured out what's up with this one, I think. SHOW SLAVE STATUS needs to acquire a simultaneous lock on the I/O thread and on the SQL thread, and it might be a while before both of them will surrender that lock if they are busy. I have been rather conservative and very possibly made the critical region wider that what it should be. Ah, makes sense. Better safe than sorry. :-) I think part of the problem is also in the FreeBSD mutex implementation - the current holder of the mutex surrenders it for only a very short time and it is possible that there could be some starvation issues. I woder if FreeBSD has different mutex types - in this case, we want the kind that puts fairness above speed. Right. I'll ask some of the FreeBSD folks here when I get a chance. Thanks! Jeremy -- Jeremy D. Zawodny, [EMAIL PROTECTED] Technical Yahoo - Yahoo Finance Desk: (408) 349-7878 Fax: (408) 349-5454 Cell: (408) 685-5936 MySQL 3.23.47-max: up 28 days, processed 989,034,558 queries (407/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: Stepping through a MySQL_fetch_array in PHP?
For $26 a month! That'll buy some excellent reference material instead :)
On Thu, 7 Mar 2002 11:47:51 -0500, Keith Elder [EMAIL PROTECTED] wrote:
Hi Gavin,
I didn't know if you knew this or not but there is a site which
provides lives PHP / MySQL support. Take a look at http://www.phphelpdesk.com . It
is a live PHP support site which helps you get real time answers to PHP problems.
Keith
* Gavin Philips-Page ([EMAIL PROTECTED]) wrote:
User-Agent: Microsoft-Entourage/9.0.2509
Date: Thu, 07 Mar 2002 18:20:31 +0200
Subject: Stepping through a MySQL_fetch_array in PHP?
From: Gavin Philips-Page [EMAIL PROTECTED]
To: MySQL Problems [EMAIL PROTECTED]
Could anybody please help:
In the query I have included a limit string which allows me to display
individual records page by page. The limit string variable is
incremented/decremented using hyperlinks. I feel it would be better if I
could somehow manually step through the returned
$query_data = mysql_fetch_array($result). Is it possible to create a loop
with a counter to step through the records contained in the array?
// PHP Code
$link_id = db_connect($default_dbname) ;
if(!$link_id) error_message(sql_error()) ;
$query = select count(*) from $user_tablename ;
$result = mysql_query($query) ;
if(!$result) error_message(sql_error()) ;
$query_data = mysql_fetch_row($result) ;
$total_num_user = $query_data[0] ;
if(!$total_num_user) error_message('No records found!') ;
$query = select usernumber, userid, userpassword, username, sex,
nationality, usermail, userprofile, registerdate, date_format(registerdate,
'%M, %e, %Y') as formatted_registerdate, lastaccesstime,
date_format(lastaccesstime, '%M, %e, %Y') as formatted_lastaccesstime from
$user_tablename $order_by_str $sort_order_str $limit_str ;
$result = mysql_query($query) ;
if(!$result) error_message(sql_error()) ;
$query_data = mysql_fetch_array($result) ;
// Table displaying the found records from MySQL database
Thanx
Gavin
###
Keith Elder
Email: [EMAIL PROTECTED] AIM: ZZorKKa YIM: keitheld
Phone: 1-734-507-1438
Text Messaging (145 characters): [EMAIL PROTECTED]
Web: http://www.zorka.com (Howto's, News, and hosting!)
With enough memory and hard drive space
anything in life is possible!
###
-
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 mysql-unsubscribe-##L=##[EMAIL PROTECTED]
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Mike(mickalo)Blezien
=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=
Thunder Rain Internet Publishing
Providing Internet Solutions that work!
http://www.thunder-rain.com
Tel: 1(225)686-2002
=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=
-
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 mysql-unsubscribe-##L=##[EMAIL PROTECTED]
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: HEAP Tables Inherit Index?
Hi, On Wed, 2002-03-06 at 15:50, Scalper wrote: If I create a temporary heap table from a select statement, does the new table also inherit the indexes (indices?) from the original table. Or will I think that every CREATE [...] TABLE [...] SELECT does not inherit any indexes (doesn't matter which table type it is). It's a reasonable behavior, but you may test it! A solution is doing the CREATE .. SELECT and then do an ALTER TABLE ADD INDEX... I have to add an index to the temporary table after it is created? For example, if I use: CREATE TEMPORARY TABLE tempstudents TYPE=HEAP SELECT studentid, studentlastname FROM students; assuming that studentid and studentlastname have indexes on them. Will I then have to add indexes to these two fields in the temporary table? Thanks, Craig -- dsoares (sql) - 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: SELECT this IF that
Thank you all for your insight. Here's the query I'm using and it works great! mysql SELECT log.id, if (empnum.fname '', log.id, 'No Record') AS 'fname', if (empnum.lname '', log.id, 'No Record') AS 'lname', SUM(log.hours) AS 'hours' FROM log LEFT OUTER JOIN empnum ON log.id = empnum.id WHERE log.pj = '$pj' GROUP BY id; -Original Message- From: DL Neil [mailto:[EMAIL PROTECTED]] Sent: Tuesday, March 05, 2002 6:42 PM To: Forer, Leif; 'Nathan'; [EMAIL PROTECTED] Subject: Re: SELECT this IF that Leif, I'm not sure what you mean by tbl2's population is a sub-set of that in tbl1. tbl1 contains user id nums and hours each user spent working on a project. tbl2 contains user id nums and the first and last names that correspond to each user id. There are user id nums in tbl1 that do not exist in tbl2 (probably because the users are no longer work here). Hope that helps clarify. The query you suggested is not working the way I hoped it would. I just want to select the hours from tbl1 and the first and last name from tbl2 where the user id from tbl1 is the same as the user id from tbl2. If, the user id in tbl1 does not exist in tbl2 I want MySQL to return 'no record'. NATHAN- Because I'm selecting multiple user ids in the query, some of which exist in both tables, some of which do not, MySQL only returns the entries that exist in both tables with a SELECT tbl1.id, tbl1.data, tbl2.name FROM tbl1, tbl2 WHERE tbl1.id = tbl2.id; That means I'm not getting all the data from tbl1 and I need to get all the data from tbl1 whether or not the id # exists in tbl2. Hope this helps clarify. As you observe to Nathan, if the query is an INNER JOIN (explicit or implicitly) then only the intersection set will appear in the resultset, ie rows which appear in both tables. As well as that, you wanted those rows that appear in one tbl, but not in the other, to be included in the resultset - but dealt with differently. Let's take that as two steps: first off, how to get them included. This means that there are members of tbl1 that are not also members of tbl2 - this is what my earlier talk of populations was about. An OUTER JOIN will include not only members of the intersection/both tables, but members of the populations of both tables that do not have a corresponding/related row in the other table. However if one table contains 'all' the column values and the other only has values in the join-column that are a subset, there's not much point in checking for the situation where its members might not have a corresponding value/row in the other table (which also takes query response time). So if the 'master' table is on the left, and the 'subset' on the right (of the join condition it is called a LEFT OUTER JOIN - if the tables are the other way around with the 'master' on the right...well you get the idea. So run the SELECT with a LEFT OUTER JOIN between the tables. Where there is a row value on the 'left' that has no corresponding value in the table on the 'right' you should see gaps, zeros, or NULLs (varying by data type and MySQL client used). Working correctly so far? Now let's look at the second step: how to get those 'spaces' converted to instead say no record. If the subset table is able to provide a value, you want that value. If the subset table has no row/value to make the join, then you want the 'marker' text: IF( Jsubset.Word '', Jfull.Word, 'no record' ) Please substitute your own column names. This says if the column in the subset (right side) table has some value, use the value (above I've said use the one from the left table, but you could use the one from the right table just as easily if they are the same! On the other hand, if there is no string value because there is no corresponding/join row in the right table (the value is therefore NULL), SQL uses the 'else' portion of the if and plugs no record into the field as a position 'holder'. NB I checked that the code provided works before I sent it to you. Is the way it fits together/works clear now? If not, please present your implementation in SQL and list its short-comings compared to what you really want (not working is gives too little to work on!?), and illustrate with sample data. Regards, =dn ** This e-mail and any files transmitted with it may contain privileged or confidential information. It is solely for use by the individual for whom it is intended, even if addressed incorrectly. If you received this e-mail in error, please notify the sender; do not disclose, copy, distribute, or take any action in reliance on the contents of this information; and delete it from your system. Any other use of this e-mail is prohibited. Thank you for your compliance. - Before posting, please check: http://www.mysql.com/manual.php (the manual)
GUI for MySQL
Hi I am just installing a new MySQL server at the moment. We are using PHPMyAdmin witch is ok as we can limit what each user can do, but some tables do not work with it. We have 2.1.0 at the moment. Do I 1. Just go for the latest PHPMyAdmin 2. Use MySQL GUI (can I restrict what each user can do?) 3. Is there some thing mush better out there? Thanks Simon Green Internet Systems Engineer -- Live Life in Broadband www.telewest.co.uk The information transmitted is intended only for the person or entity to which it is addressed and may contain confidential and/or privileged material. Statements and opinions expressed in this e-mail may not represent those of the company. Any review, retransmission, dissemination or other use of, or taking of any action in reliance upon, this information by persons or entities other than the intended recipient is prohibited. If you received this in error, please contact the sender immediately and delete the material from any computer. - 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
Reset the root Password in MySQL
Hi all, I have just installed MySQL recently. I already set the root password and some databases testing and everything worked fine. However, I accidentally changed the root to anonymous yesterday. After that, I couldn't add new users and do some administration tasks even change password myself. In the website: http://www.bitbybit.dk/mysqlfaq/faq.html , I found FAQ to try to solve my problem. I quote the instruction as follows:- reset the root password? The following procedure will help you reset the root password. Note that while you are doing this, the server is totally open and gives everybody full access to all databases. Stop the server Restart the server with the command-line option -Sg or --skip-grant-tables You can now log in to the server without a password. So can anyone else! Reset the root password with the command mysql - GRANT ALL PRIVILEGES ON *.* TO root@localhost - IDENTIFIED BY the_new_password Exit the client Immediately thereafter, shut down and restart the server as usual. However, I tried many times. I found only if I restart the server with --skip-grant-tables option, the server will promt out ERROR 1047: Unknown Command when I type GRANT ALL PRIVILEGES ON *.* TO root@localhost IDENTIFIED BY the_new_password; Here is my option file /etc/my.cnf: [mysqld] user=root datadir=/var/lib/mysql socket=/var/lib/mysql.sock skip-grant-tables [mysql.server] user=mysql basedir=/var/lib [safe_mysqld] err_log=/var/log/mysqld.log pid-file=/var/run/mysqld/mysqld.pid -end of file I don't know whether the my.cnf is correct or not. Please let me. Thanks for any help or advise. - 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
Changing Default for Not Null to NOTHING
Is there a way for me to NOT have a default value for a column in a table that I define as NOT NULL? EXAMPLE SQL: mysql CREATE TABLE FOO (foo1 int NOT NULL); Query OK, 0 rows affected (0.05 sec) mysql DESCRIBE FOO; +---+-+--+-+-+---+ | Field | Type| Null | Key | Default | Extra | +---+-+--+-+-+---+ | foo1 | int(11) | | | 0 | | +---+-+--+-+-+---+ 1 row in set (0.00 sec) mysql I don't want the default to be 0 (zero) Any ideas? - 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: RH 7.2 connections problems w 16 web servers to 2 MySQL servers
On Thursday, March 7, 2002, at 12:38 AM, Jeremy Zawodny wrote: Are the Web servers doing write operations on the database, or read-only? read-only now. Can you talk a bit about how Yahoo Finance does it as far as # of web servers to MySQL servers ? Apache PHP tuning ? - Sam. - 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
[ANN] Blue World Announces Lasso vs PHP White Paper
Those of you using PHP with MySQL who may be looking for alternatives may be interested in this white paper just released. Enjoy! CC FOR IMMEDIATE RELEASE March 7, 2002 BLUE WORLD ANNOUNCES LASSO VS PHP WHITE PAPER Report highlights differences in performance, ease-of-use, security, architecture, programming features and cost. Bellevue, WA--March 7, 2002--Blue World Communications, Inc.--pioneers of the Web Data Engine(tm)--today announced the publication of a comprehensive white paper report comparing Blue World Lasso Professional 5 to PHP 4.1.x. The 56 page report includes detailed coverage of key topics of interest to Web application developers in search of a high performance, robust, easy to use tool for building powerful data-driven Web applications. Authored by Lasso and PHP expert programmers Lee McNeil and Duncan Cameron, the report provides detailed side-by-side code comparisons, a feature comparison chart and performance benchmarks. The Lasso vs PHP report shows how Lasso Professional 5 beats PHP, said Bill Doerrfeld, CEO of Blue World. This white paper will further increase awareness as to the significant performance, ease-of-use, architecture, security and total cost of ownership benefits of using Lasso over competing offerings such as PHP. Fast, Easy, and Platform Agnostic Lasso outpaced PHP by over 200% in select benchmark tests comparing performance, specifically when executing class libraries. Lasso also beat PHP on all performance tests on Windows and virtually all tests on Macintosh. In all tests involving database access, Lasso proved the faster of the two. And, in cases where under light load PHP scored faster, as the load increased, Lasso consistently performed better than PHP. This is principally due to Lasso's distributed architecture and operation out-of-process from the Web server which positions Lasso Professional 5 as a true Web application server product designed for heavy load. Programming in Lasso vs PHP is also highlighted in the report with numerous side-by-side code comparisons where the amount of code required for Lasso is significantly less involved than that required by PHP in normal coding situations. Lasso's programming language is based on clear naming conventions which aids in getting started and maintaining projects as opposed to a fractured and loosely-defined language in PHP which causes confusion and slows the development process. Lasso operates identically across platforms whereas with PHP, significant functionality is lost migrating from one platform to another. This makes it very difficult to develop on one platform and deploy on another when using PHP. Lasso's platform-agnostic design makes it very easy to develop and deploy on the same or different platforms, easing the development and testing process for Web developers. Secure, Complete Administration, and Database Abstraction Lasso provides a industry-first built-in security system controlling all aspects of serving data-driven Web applications whereas PHP provides no built-in security controls. With PHP, developers need to build their own security system, which would require literally months of coding to match the depth of security features provided by default with Lasso. Lasso provides a complete Web browser based administration interface which controls all aspects of setup and administration. What's more, the administration interface facilitates the creation of MySQL databases right within a Web browser along with instant browsing and editing data within databases with no coding required. PHP provides no administration interface. Communicating with databases is consistent across multiple databases due to the intelligent database abstraction layer provided with Lasso. With PHP, special queries and routines need to be established for each type of data source. Lasso's database abstraction and connection information caching also contributes to better performance over PHP. Robust Architecture and Compiled Apps Lasso Professional 5 provides a robust distributed architecture which facilitates multi CPU configurations. PHP operates in-process within supported Web servers and is based on a process-pooled architecture which suffers under heavy loads. Lasso's multi-threaded single process architecture facilitates the creation of global server-wide application variables which is not possible via PHP. Lasso provides the ability to build and serve compiled, encrypted Web applications called LassoApps. This protects the developer's source code and provides an efficient method of serving Web applications. With PHP, developers must purchase commercial add-on products totalling over $3300 (USD) to receive comparable functionality. More Features and Less Costly Lasso includes a wealth of features not provided in PHP including the ability to automatically schedule events and numerous error handling controls. Lastly, while a basic installation of PHP can be downloaded
User-variables weirdness... initialized or not?
You have this table: id data 3 2 2 1 1 3 This query: SELECT @var, data, @var:=data+(IFNULL(@var,0)) FROM table What would result would you expect the first time you execute the query? I would expect this: NULL, 2, 2 2, 1, 3 3, 3, 6 But this is what you get the first time: NULL, 2, 2 NULL, 1, 1 NULL, 3, 3 and next execution: 3, 2, 5 5, 1, 6 6, 3, 9 Can you explain this? Greetings from Denmark /Stig - 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: MySQL Database Replication
rep1 would gain FILE access to all ( not sure what the really entails ) it would not have SELECT access, so can not read from it mind you if they have enough info to get in with rep1 access, then they could just replicate everything on thier own server and read till thier hearts content -Original Message- From: Thi Cao [mailto:[EMAIL PROTECTED]] Sent: Thursday, March 07, 2002 12:04 PM To: Thi Cao Cc: MySQL Subject: RE: MySQL Database Replication ds, If I understand you correctly, that also means that the user repl can access the mysql database where all the privilege info is stored and see the permissions, passwords, and such. Yes/No? Thi -Original Message- From: ds [mailto:[EMAIL PROTECTED]] Sent: Thursday, March 07, 2002 11:02 AM To: Thi Cao Cc: MySQL Subject: RE: MySQL Database Replication On Wed, 2002-03-06 at 14:26, Thi Cao wrote: When I grant privileges as follows, the slave gets updated: GRANT FILE ON *.* to repl@'%' identified by 'some_password'; Could someone please tell me why I must grant the FILE privilege on all databases for the repl (slave) to be able to update one particular database? MySQL Manual: 4.2.7 Privileges Provided by MySQL: The file privilege gives you permission to read and write files on the server using the LOAD DATA INFILE and SELECT ... INTO OUTFILE statements. Any user to whom this privilege is granted can read or write any file that the MySQL server can read or write. 4.10.3 How To Set Up Replication 2. Set up special a replication user on the master with the FILE privilege and permission to connect from all the slaves. If the user is only doing replication (which is recommended), you don't need to grant any additional privileges. For example, to create a user named repl which can access your master from any host, you might use this command: GRANT FILE ON *.* TO repl@% IDENTIFIED BY 'password'; Thi Cao wrote: Hello everyone, This is my first attempt at MySQL database replication. Can't seem to get it to work yet. The problem reported in the error log of the slave server is as follows: Error reading packet from server: Access denied for user 'repl@slave_host' (Using password: YES) (read_errno 0,server_errno=1045) I believe it has something to do with the way I granted privileges to the user repl. I did the following: GRANT FILE ON dbname.* to repl@'%' identified by 'some_password'; Did you do a FLUSH PRIVILIGES after that? That is needed in some cases. You don't need to flush privileges when using grant/revoke commands. -- dsoares (sql) - 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
How to turn on Slow Query Log?
Hi, I need help in turning on the slow query log option on the my.ini file. I've tried uncommenting it and when I tried to run the nt-max it says it couldn't recognize the option. Here's what I have for my.ini file, any other way I have to type it? Please advise. slow query log#=c:/slowquerylog/slowquery.log Thanks, Martin **Disclaimer** This Memo and any attachments, may be confidential and legally privileged. If you are not the intended recipient and have received this in error, kindly destroy this message and notify the sender. Thank you for your assistance. - 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
Web hosting scalability?
Situation: mass virtual website hosting, with php/perl/python. One master mysql server, one or more replicated slaves. Question: would it be possible/feasible to write a daemon that accepts connections on behalf of mysqld, and depending on what type of query it is (updating or selecting) farm the query out to the appropriate database server? Perhaps it could do some connection pooling as well. The reason: we'd like to keep telling our users to connect to the database server, instead of hoping that they will always write correct code and connect to the appropriate servers, which of course they won't. Any feedback (such as, that's the stupidest idea I've ever heard, why don't you just do _) would be appreciated :) John Masterson Modwest Powerful, Affordable Web Hosting http://www.modwest.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
MySQL ver 3.23.47 install Problem
Dear sir I have a problem to install MySQL for windows on my standalone PC. When I run 'WINMYSQLADMIN.EXE' from dos prompt or windows explorer then it did not run and gives and error message 'Access violation at address 00040298D in module 'WINMYSQLADMIN.EXE'. Read of address ' when I press OK button then a window (WinMySQLadmin 1.3 ) pops up. It should be 'WinMySQLadmin Quick Setup' window for the first time. After going through the help file in MySQL I download wiinsock 2 driver. But after installing the driver it also failed to install. My PC-Config.is P 233, 32 MB SDRAM, WIN95 OSR2, 4GB partition. Please help Sk Islam - 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: [ANN] Blue World Announces Lasso vs PHP White Paper
At 1:19 PM -0500 3/7/02, Chuck \PUP\ Payne wrote: But who wants to pay. Get a clue that's why PHP, PERL, and other Open Source Lang., are widely more used. If you do a true comparison in features, you'll see that a PHP-based solution (with commercial add-ons) costs over three times the cost of Lasso. Then there's also the (TCO) total cost of ownership where due to productivity gains in using Lasso, developers end up saving lots of time (e.g. money) compared with using other tools. Then there's also the fact that when you buy Lasso Professional 5, you're also supporting MySQL AB as each copy purchased puts money in their pockets. And, this is a good thing to ensure the future vitality (and growth) of the MySQL market. It also gives you peace of mind in knowing that you have a commercial license of MySQL, which can help ease liability and other concerns that may otherwise be present in certain organizations who may have concerns using just GPL products. Then there's the issue of quality. With Lasso Professional 5, no stone remains unturned with respect to ensuring Web developers have the highest quality offering both in terms of features, documentation, support materials and more. CC -- - Cathy Cunningham [EMAIL PROTECTED] Lasso Evangelist Blue World Communications, Inc. http://www.blueworld.com/ - Lasso Studio is the easiest way to create a database-driven Web site - Macworld Magazine - 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
Can not connect again
Ok, that worked. I started MySQL. I still don't know how to shutdown mysql, or if that was my problem. Unfortunately, that is the ONLY way I can log into mysql. Anyway, that would be fine, only now I have an ASP script but I am a privelegas idiot, so I don't know how to set a UID and Password. -- D. Lyles Uniquest Designs - 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: Web hosting scalability?
Yep.. this is very feasible.. And there are some packages to do this already. http://www.firstworks.com/sqlrelay.html Is a good package and library/API to implement what you want to do. We have done this in the past for a large community based website. -Original Message- From: John Masterson [mailto:[EMAIL PROTECTED]] Sent: Thursday, March 07, 2002 1:22 PM To: [EMAIL PROTECTED] Subject: Web hosting scalability? Situation: mass virtual website hosting, with php/perl/python. One master mysql server, one or more replicated slaves. Question: would it be possible/feasible to write a daemon that accepts connections on behalf of mysqld, and depending on what type of query it is (updating or selecting) farm the query out to the appropriate database server? Perhaps it could do some connection pooling as well. The reason: we'd like to keep telling our users to connect to the database server, instead of hoping that they will always write correct code and connect to the appropriate servers, which of course they won't. Any feedback (such as, that's the stupidest idea I've ever heard, why don't you just do _) would be appreciated :) John Masterson Modwest Powerful, Affordable Web Hosting http://www.modwest.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: [ANN] Blue World Announces Lasso vs PHP White Paper
Can you provide a NON-BIAS so-called TRUE comparison? I would be curious on what Blueworld has to say. Also, why do you think the TCO is lower with lasso than PHP? I don't get it, there is no cost to own it, just to develop it. And if you develop with PHP correctly, then the TCO is low. Here is my basic TCO comparison: Lasso Software Pro $1199 PHP $0.00 Learning Lasso$2500 PHP $0.00 Development (hr avg) $75 PHP $75/hr. So to me, Lasso isn't worth switching. I would already be $3700 in the hole without even touching it! -Original Message- From: Cathy Cunningham (Blue World Lasso Evangelist) [mailto:[EMAIL PROTECTED]] Sent: Thursday, March 07, 2002 12:37 PM To: Chuck PUP Payne; [EMAIL PROTECTED] Subject: Re: [ANN] Blue World Announces Lasso vs PHP White Paper At 1:19 PM -0500 3/7/02, Chuck \PUP\ Payne wrote: But who wants to pay. Get a clue that's why PHP, PERL, and other Open Source Lang., are widely more used. If you do a true comparison in features, you'll see that a PHP-based solution (with commercial add-ons) costs over three times the cost of Lasso. Then there's also the (TCO) total cost of ownership where due to productivity gains in using Lasso, developers end up saving lots of time (e.g. money) compared with using other tools. Then there's also the fact that when you buy Lasso Professional 5, you're also supporting MySQL AB as each copy purchased puts money in their pockets. And, this is a good thing to ensure the future vitality (and growth) of the MySQL market. It also gives you peace of mind in knowing that you have a commercial license of MySQL, which can help ease liability and other concerns that may otherwise be present in certain organizations who may have concerns using just GPL products. Then there's the issue of quality. With Lasso Professional 5, no stone remains unturned with respect to ensuring Web developers have the highest quality offering both in terms of features, documentation, support materials and more. CC -- - Cathy Cunningham [EMAIL PROTECTED] Lasso Evangelist Blue World Communications, Inc. http://www.blueworld.com/ - Lasso Studio is the easiest way to create a database-driven Web site - Macworld Magazine - 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: [ANN] Blue World Announces Lasso vs PHP White Paper
I think this is should be Learning Lasso$2500 PHP $2500 Dosent matter if the product is free it still costs you time. Can you provide a NON-BIAS so-called TRUE comparison? I would be curious on what Blueworld has to say. Also, why do you think the TCO is lower with lasso than PHP? I don't get it, there is no cost to own it, just to develop it. And if you develop with PHP correctly, then the TCO is low. Here is my basic TCO comparison: Lasso Software Pro $1199 PHP $0.00 Learning Lasso$2500 PHP $0.00 Development (hr avg) $75 PHP $75/hr. So to me, Lasso isn't worth switching. I would already be $3700 in the hole without even touching it! -Original Message- From: Cathy Cunningham (Blue World Lasso Evangelist) [mailto:[EMAIL PROTECTED]] Sent: Thursday, March 07, 2002 12:37 PM To: Chuck PUP Payne; [EMAIL PROTECTED] Subject: Re: [ANN] Blue World Announces Lasso vs PHP White Paper At 1:19 PM -0500 3/7/02, Chuck \PUP\ Payne wrote: But who wants to pay. Get a clue that's why PHP, PERL, and other Open Source Lang., are widely more used. If you do a true comparison in features, you'll see that a PHP-based solution (with commercial add-ons) costs over three times the cost of Lasso. Then there's also the (TCO) total cost of ownership where due to productivity gains in using Lasso, developers end up saving lots of time (e.g. money) compared with using other tools. Then there's also the fact that when you buy Lasso Professional 5, you're also supporting MySQL AB as each copy purchased puts money in their pockets. And, this is a good thing to ensure the future vitality (and growth) of the MySQL market. It also gives you peace of mind in knowing that you have a commercial license of MySQL, which can help ease liability and other concerns that may otherwise be present in certain organizations who may have concerns using just GPL products. Then there's the issue of quality. With Lasso Professional 5, no stone remains unturned with respect to ensuring Web developers have the highest quality offering both in terms of features, documentation, support materials and more. CC -- - Cathy Cunningham [EMAIL PROTECTED] Lasso Evangelist Blue World Communications, Inc. http://www.blueworld.com/ - Lasso Studio is the easiest way to create a database-driven Web site - Macworld Magazine - 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
RE: [ANN] Blue World Announces Lasso vs PHP White Paper
There is a point that if you buy APC-Cache and the encoder you are spending a lot of cache. However there is APC, PHPCache and others that do the job.. but not as well. PHP is mildly flawed in the sense that it is somewhat intentionally crippled so Zend can make a profit from sites that adopt it and get big. However with cacheing of the html and whatnot, you can get around all this and have your costs be at 0 of software.. just time to implement.. -Original Message- From: Todd Williamsen [mailto:[EMAIL PROTECTED]] Sent: Thursday, March 07, 2002 2:11 PM To: 'Cathy Cunningham (Blue World Lasso Evangelist)'; 'Chuck PUP Payne'; [EMAIL PROTECTED] Subject: RE: [ANN] Blue World Announces Lasso vs PHP White Paper Can you provide a NON-BIAS so-called TRUE comparison? I would be curious on what Blueworld has to say. Also, why do you think the TCO is lower with lasso than PHP? I don't get it, there is no cost to own it, just to develop it. And if you develop with PHP correctly, then the TCO is low. Here is my basic TCO comparison: Lasso Software Pro $1199 PHP $0.00 Learning Lasso$2500 PHP $0.00 Development (hr avg) $75 PHP $75/hr. So to me, Lasso isn't worth switching. I would already be $3700 in the hole without even touching it! -Original Message- From: Cathy Cunningham (Blue World Lasso Evangelist) [mailto:[EMAIL PROTECTED]] Sent: Thursday, March 07, 2002 12:37 PM To: Chuck PUP Payne; [EMAIL PROTECTED] Subject: Re: [ANN] Blue World Announces Lasso vs PHP White Paper At 1:19 PM -0500 3/7/02, Chuck \PUP\ Payne wrote: But who wants to pay. Get a clue that's why PHP, PERL, and other Open Source Lang., are widely more used. If you do a true comparison in features, you'll see that a PHP-based solution (with commercial add-ons) costs over three times the cost of Lasso. Then there's also the (TCO) total cost of ownership where due to productivity gains in using Lasso, developers end up saving lots of time (e.g. money) compared with using other tools. Then there's also the fact that when you buy Lasso Professional 5, you're also supporting MySQL AB as each copy purchased puts money in their pockets. And, this is a good thing to ensure the future vitality (and growth) of the MySQL market. It also gives you peace of mind in knowing that you have a commercial license of MySQL, which can help ease liability and other concerns that may otherwise be present in certain organizations who may have concerns using just GPL products. Then there's the issue of quality. With Lasso Professional 5, no stone remains unturned with respect to ensuring Web developers have the highest quality offering both in terms of features, documentation, support materials and more. CC -- - Cathy Cunningham [EMAIL PROTECTED] Lasso Evangelist Blue World Communications, Inc. http://www.blueworld.com/ - Lasso Studio is the easiest way to create a database-driven Web site - Macworld Magazine - 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
Blue World
Does it run on Unix? S -Original Message- From: Cathy Cunningham (Blue World Lasso Evangelist) [mailto:[EMAIL PROTECTED]] Sent: Thursday, March 07, 2002 10:37 AM To: Chuck PUP Payne; [EMAIL PROTECTED] Subject: Re: [ANN] Blue World Announces Lasso vs PHP White Paper At 1:19 PM -0500 3/7/02, Chuck \PUP\ Payne wrote: But who wants to pay. Get a clue that's why PHP, PERL, and other Open Source Lang., are widely more used. If you do a true comparison in features, you'll see that a PHP-based solution (with commercial add-ons) costs over three times the cost of Lasso. Then there's also the (TCO) total cost of ownership where due to productivity gains in using Lasso, developers end up saving lots of time (e.g. money) compared with using other tools. Then there's also the fact that when you buy Lasso Professional 5, you're also supporting MySQL AB as each copy purchased puts money in their pockets. And, this is a good thing to ensure the future vitality (and growth) of the MySQL market. It also gives you peace of mind in knowing that you have a commercial license of MySQL, which can help ease liability and other concerns that may otherwise be present in certain organizations who may have concerns using just GPL products. Then there's the issue of quality. With Lasso Professional 5, no stone remains unturned with respect to ensuring Web developers have the highest quality offering both in terms of features, documentation, support materials and more. CC -- - Cathy Cunningham [EMAIL PROTECTED] Lasso Evangelist Blue World Communications, Inc. http://www.blueworld.com/ - Lasso Studio is the easiest way to create a database-driven Web site - Macworld Magazine - 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: Can not connect (again)
Hi, You are closer.This error is generated only if you wish to connect from the localhost or 127.0.0.1 (i believe).To avoid this inconvenient, in arguments of mysql client,you must put -S path_of_the_mysql.socket.Usualy mysql create the socket file in tmp directory.You can also, made some modification in my.cnf file. I.E. mysql -u mysql(or root) -h localhost -S /tmp/mysql.sock This work ONLY if the mysql daemon is started. And if is not started you can do: safe_mysqld.After this you can verify if the mysql processess are active with ps -ax. Good luck, Gelu - Original Message - From: Egor Egorov [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: Thursday, March 07, 2002 5:18 PM Subject: Can not connect (again) Thursday, March 07, 2002, 4:49:57 PM, you wrote: d Ok people, I'm desperate for the help. I'm going to try to be as detailed d as possible, because I need the two year old explanation. I recently d installed MySQL on my Cobalt Raq3. I was running fine, created a db, table d created a user, gave some permissions, and thought I was rolling along. d Somewhere in setting the permissions and using safe_mysql I messed something d up. I am now getting an Error 2002 can't connect to local Mysql through d socket var/lib/mysql/mysql.socket. I don't know much about the socket file, d so if that has something to do with the problem, I'll need a brief d explanation. Can someone PLEASE HELP because I'm desperate to get this d fixed yesterday. dlyles, as I answered you 2 days ago: If your MySQL server is running then you should check location of the socket file and check the socket path in your my.cnf file. Check your privileges on the socket file and on the dir that contains socket file. You can find the description of this error at: http://www.mysql.com/doc/C/a/Can_not_connect_to_server.html d Thank you. -- For technical support contracts, goto https://order.mysql.com/ This email is sponsored by Ensita.net http://www.ensita.net/ __ ___ ___ __ / |/ /_ __/ __/ __ \/ /Egor Egorov / /|_/ / // /\ \/ /_/ / /__ [EMAIL PROTECTED] /_/ /_/\_, /___/\___\_\___/ MySQL AB / Ensita.net ___/ www.mysql.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
insert problems
Are there any documented reasons why mysql would only enter certain fields and skip others? I am having some strange problems where it seems that data are randomly dropped from inserts via web forms. Have posted before stating a possible cache or proxy problem, but I am still at a loss... - 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] Sorry for the reply.
You know I had wrote but my message was kick by mysql mail list server for spamming, I didn't mean too and I am sorry to everyone on the list. I was trying to express my thought on an e-mail. Again sorry for spamming, all I did was hit reply to all to the Blue World Announces Lasso vs PHP White Paper e-mail. Chuck PUP Payne Sr. System Administrator GDI Engineering, Inc. 2075-E West Park Place Blvd. Stone Mountain, GA 30087 - 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: How to turn on Slow Query Log?
On Thu, Mar 07, 2002 at 09:53:51AM -0800, [EMAIL PROTECTED] wrote: Hi, I need help in turning on the slow query log option on the my.ini file. I've tried uncommenting it and when I tried to run the nt-max it says it couldn't recognize the option. Here's what I have for my.ini file, any other way I have to type it? Please advise. slow query log#=c:/slowquerylog/slowquery.log What's the '#' doing there? -- Jeremy D. Zawodny, [EMAIL PROTECTED] Technical Yahoo - Yahoo Finance Desk: (408) 349-7878 Fax: (408) 349-5454 Cell: (408) 685-5936 MySQL 3.23.47-max: up 28 days, processed 991,703,184 queries (406/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: [ANN] Blue World Announces Lasso vs PHP White Paper
Ah, the keywords with commercial add-ons. Notice the plurality, as well. I wonder which add-ons and how many total add-ons were considered in making this cost estimate. I also wonder if most of us would even need more than one commercial add-on at most. - Jonathan -Original Message- From: Cathy Cunningham (Blue World Lasso Evangelist) [mailto:[EMAIL PROTECTED]] Sent: Thursday, March 07, 2002 12:37 PM To: Chuck PUP Payne; [EMAIL PROTECTED] Subject: Re: [ANN] Blue World Announces Lasso vs PHP White Paper At 1:19 PM -0500 3/7/02, Chuck \PUP\ Payne wrote: But who wants to pay. Get a clue that's why PHP, PERL, and other Open Source Lang., are widely more used. If you do a true comparison in features, you'll see that a PHP-based solution (with commercial add-ons) costs over three times the cost of Lasso. Then there's also the (TCO) total cost of ownership where due to productivity gains in using Lasso, developers end up saving lots of time (e.g. money) compared with using other tools. Then there's also the fact that when you buy Lasso Professional 5, you're also supporting MySQL AB as each copy purchased puts money in their pockets. And, this is a good thing to ensure the future vitality (and growth) of the MySQL market. It also gives you peace of mind in knowing that you have a commercial license of MySQL, which can help ease liability and other concerns that may otherwise be present in certain organizations who may have concerns using just GPL products. Then there's the issue of quality. With Lasso Professional 5, no stone remains unturned with respect to ensuring Web developers have the highest quality offering both in terms of features, documentation, support materials and more. CC -- - Cathy Cunningham [EMAIL PROTECTED] Lasso Evangelist Blue World Communications, Inc. http://www.blueworld.com/ - Lasso Studio is the easiest way to create a database-driven Web site - Macworld Magazine - 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: Blue World
Hi It a Mac and Windows thing At 11:35 07/03/2002 -0800, Dreamtime.net Inc. wrote: Does it run on Unix? S -Original Message- From: Cathy Cunningham (Blue World Lasso Evangelist) [mailto:[EMAIL PROTECTED]] Sent: Thursday, March 07, 2002 10:37 AM To: Chuck PUP Payne; [EMAIL PROTECTED] Subject: Re: [ANN] Blue World Announces Lasso vs PHP White Paper At 1:19 PM -0500 3/7/02, Chuck \PUP\ Payne wrote: But who wants to pay. Get a clue that's why PHP, PERL, and other Open Source Lang., are widely more used. If you do a true comparison in features, you'll see that a PHP-based solution (with commercial add-ons) costs over three times the cost of Lasso. Then there's also the (TCO) total cost of ownership where due to productivity gains in using Lasso, developers end up saving lots of time (e.g. money) compared with using other tools. Then there's also the fact that when you buy Lasso Professional 5, you're also supporting MySQL AB as each copy purchased puts money in their pockets. And, this is a good thing to ensure the future vitality (and growth) of the MySQL market. It also gives you peace of mind in knowing that you have a commercial license of MySQL, which can help ease liability and other concerns that may otherwise be present in certain organizations who may have concerns using just GPL products. Then there's the issue of quality. With Lasso Professional 5, no stone remains unturned with respect to ensuring Web developers have the highest quality offering both in terms of features, documentation, support materials and more. CC -- - Cathy Cunningham [EMAIL PROTECTED] Lasso Evangelist Blue World Communications, Inc. http://www.blueworld.com/ - Lasso Studio is the easiest way to create a database-driven Web site - Macworld Magazine - 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 Regards John, Former MySQL Developer - [EMAIL PROTECTED] http://www.rygannon.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: [ANN] Blue World Announces Lasso vs PHP White Paper
At 12:30 07/03/2002 -0700, [EMAIL PROTECTED] wrote: I think this is should be Learning Lasso$2500 PHP $2500 This may be true if you have no knowledge of either system, but most people on this list have a great deal of experience using PHP and for them that would be money down the drain. Dosent matter if the product is free it still costs you time. Can you provide a NON-BIAS so-called TRUE comparison? I would be curious on what Blueworld has to say. Also, why do you think the TCO is lower with lasso than PHP? I don't get it, there is no cost to own it, just to develop it. And if you develop with PHP correctly, then the TCO is low. Here is my basic TCO comparison: Lasso Software Pro $1199 PHP $0.00 Learning Lasso$2500 PHP $0.00 Development (hr avg) $75 PHP $75/hr. So to me, Lasso isn't worth switching. I would already be $3700 in the hole without even touching it! -Original Message- From: Cathy Cunningham (Blue World Lasso Evangelist) [mailto:[EMAIL PROTECTED]] Sent: Thursday, March 07, 2002 12:37 PM To: Chuck PUP Payne; [EMAIL PROTECTED] Subject: Re: [ANN] Blue World Announces Lasso vs PHP White Paper At 1:19 PM -0500 3/7/02, Chuck \PUP\ Payne wrote: But who wants to pay. Get a clue that's why PHP, PERL, and other Open Source Lang., are widely more used. If you do a true comparison in features, you'll see that a PHP-based solution (with commercial add-ons) costs over three times the cost of Lasso. Then there's also the (TCO) total cost of ownership where due to productivity gains in using Lasso, developers end up saving lots of time (e.g. money) compared with using other tools. Then there's also the fact that when you buy Lasso Professional 5, you're also supporting MySQL AB as each copy purchased puts money in their pockets. And, this is a good thing to ensure the future vitality (and growth) of the MySQL market. It also gives you peace of mind in knowing that you have a commercial license of MySQL, which can help ease liability and other concerns that may otherwise be present in certain organizations who may have concerns using just GPL products. Then there's the issue of quality. With Lasso Professional 5, no stone remains unturned with respect to ensuring Web developers have the highest quality offering both in terms of features, documentation, support materials and more. CC -- - Cathy Cunningham [EMAIL PROTECTED] Lasso Evangelist Blue World Communications, Inc. http://www.blueworld.com/ - Lasso Studio is the easiest way to create a database-driven Web site - Macworld Magazine - 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 Regards John, Former MySQL Developer - [EMAIL PROTECTED] http://www.rygannon.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: How to turn on Slow Query Log?
Never mind with that.. I don't know why it was there, it was created automatically the 1st time you run the windows gui admin. And I had to modify it to log-slow-queries=filename and it turned out ok. Thanks anyway. Regards, Martin |-+ | | Jeremy Zawodny | | | jzawodn@yahoo-in| | | c.com | | || | | 03/07/2002 11:58 | | | AM | | | Please respond to| | | mysql| | || |-+ --| | | | To: [EMAIL PROTECTED] | | cc: [EMAIL PROTECTED] | | Subject: Re: How to turn on Slow Query Log? | --| On Thu, Mar 07, 2002 at 09:53:51AM -0800, [EMAIL PROTECTED] wrote: Hi, I need help in turning on the slow query log option on the my.ini file. I've tried uncommenting it and when I tried to run the nt-max it says it couldn't recognize the option. Here's what I have for my.ini file, any other way I have to type it? Please advise. slow query log#=c:/slowquerylog/slowquery.log What's the '#' doing there? -- Jeremy D. Zawodny, [EMAIL PROTECTED] Technical Yahoo - Yahoo Finance Desk: (408) 349-7878 Fax: (408) 349-5454 Cell: (408) 685-5936 MySQL 3.23.47-max: up 28 days, processed 991,703,184 queries (406/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: [ANN] Blue World Announces Lasso vs PHP White Paper
You think Blue World getting the point yet? Maybe they are thinking twice about spamming mailing lists with their products? Maybe a better target is Microsoft's .NET boards since both products are about the same price -Original Message- From: Jonathan Hilgeman [mailto:[EMAIL PROTECTED]] Sent: Thursday, March 07, 2002 2:00 PM To: '[EMAIL PROTECTED]' Subject: RE: [ANN] Blue World Announces Lasso vs PHP White Paper Ah, the keywords with commercial add-ons. Notice the plurality, as well. I wonder which add-ons and how many total add-ons were considered in making this cost estimate. I also wonder if most of us would even need more than one commercial add-on at most. - Jonathan -Original Message- From: Cathy Cunningham (Blue World Lasso Evangelist) [mailto:[EMAIL PROTECTED]] Sent: Thursday, March 07, 2002 12:37 PM To: Chuck PUP Payne; [EMAIL PROTECTED] Subject: Re: [ANN] Blue World Announces Lasso vs PHP White Paper At 1:19 PM -0500 3/7/02, Chuck \PUP\ Payne wrote: But who wants to pay. Get a clue that's why PHP, PERL, and other Open Source Lang., are widely more used. If you do a true comparison in features, you'll see that a PHP-based solution (with commercial add-ons) costs over three times the cost of Lasso. Then there's also the (TCO) total cost of ownership where due to productivity gains in using Lasso, developers end up saving lots of time (e.g. money) compared with using other tools. Then there's also the fact that when you buy Lasso Professional 5, you're also supporting MySQL AB as each copy purchased puts money in their pockets. And, this is a good thing to ensure the future vitality (and growth) of the MySQL market. It also gives you peace of mind in knowing that you have a commercial license of MySQL, which can help ease liability and other concerns that may otherwise be present in certain organizations who may have concerns using just GPL products. Then there's the issue of quality. With Lasso Professional 5, no stone remains unturned with respect to ensuring Web developers have the highest quality offering both in terms of features, documentation, support materials and more. CC -- - Cathy Cunningham [EMAIL PROTECTED] Lasso Evangelist Blue World Communications, Inc. http://www.blueworld.com/ - Lasso Studio is the easiest way to create a database-driven Web site - Macworld Magazine - 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
Re: InnoDB and hosts.allow/deny
On Wed, Mar 06, 2002 at 06:19:53AM +0100, Eberhard Lisse wrote: Hi, I run SuSe 7.2 and have upgraded to the current suse versions of mysql. Server version 3.23.41-Max-log Protocol version10 Connection linux.lisse.na via TCP/IP TCP port3306 I have added mysqld and mysqld-max to the /etc/hosts.allow and can access the (MyISAM) tables from outside. However, when I configure an InnoDB table it behaves as if the TCP wrapper triggers (same messages to the syslog/syswarn files, not to the mysql logs as when I left it out of the hosts.allow). Hm. That doesn't make a lot of sense. MySQL handles the connections before it knows if you're using InnoDB or not. Jeremy -- Jeremy D. Zawodny, [EMAIL PROTECTED] Technical Yahoo - Yahoo Finance Desk: (408) 349-7878 Fax: (408) 349-5454 Cell: (408) 685-5936 MySQL 3.23.47-max: up 28 days, processed 992,589,408 queries (406/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: [Mysql] Sorry for the reply.
The list has an automatic filter that blocks any message that doesn't contain either sql or query in it. Pain in the butt sometimes -- that's why you'll see sql query at the bottom of a lot of people's emails, or in their signature. --jeff - Original Message - From: Chuck PUP Payne [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: Thursday, March 07, 2002 11:47 AM Subject: [Mysql] Sorry for the reply. You know I had wrote but my message was kick by mysql mail list server for spamming, I didn't mean too and I am sorry to everyone on the list. I was trying to express my thought on an e-mail. Again sorry for spamming, all I did was hit reply to all to the Blue World Announces Lasso vs PHP White Paper e-mail. Chuck PUP Payne Sr. System Administrator GDI Engineering, Inc. 2075-E West Park Place Blvd. Stone Mountain, GA 30087 - 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
Running MySQL as Service on 2000 Server
Hi, Anybody running MySQL on Win 2000 server here? I just installed MySQL 3.23.49-MAX (w/ InnoDB) on a 2000 Server (Dual 1.1 GHz - 1GB RAM - 15GB HD space) and I can run it without any problem from the command line as a standalone. However I couldn't run it as a service even though I already did 'mysqld-max-nt --install' the first time I ran it. Is there anything wrong with MySQL or is it more of permission issue on NT/2000 server. I also attached the my.ini file if it would help. Thanks. Regards, Martin [mysqld] basedir=G:/MySQL datadir=G:/MySQL/data #bind-address= log-slow-queries=h:/slowquery/slowquery.log set-variable=key_buffer=20M innodb_data_home_dir = g:/ibdata innodb_data_file_path = ibdata:2000M;ibdata2:2000M set-variable = innodb_buffer_pool_size=200M set-variable = innodb_additional_mem_pool_size=30M innodb_log_group_home_dir = h:/iblogs innodb_log_arch_dir = h:/iblogs innodb_log_archive=0 set-variable = innodb_log_files_in_group=3 set-variable = innodb_log_file_size=30M set-variable = innodb_log_buffer_size=24M innodb_flush_log_at_trx_commit=1 set-variable = innodb_file_io_threads=10 set-variable = innodb_lock_wait_timeout=50 [WinMySQLAdmin] Server=G:/MySQL/bin/mysqld-max-nt.exe **Disclaimer** This Memo and any attachments, may be confidential and legally privileged. If you are not the intended recipient and have received this in error, kindly destroy this message and notify the sender. Thank you for your assistance. - 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: [ANN] Blue World Announces Lasso vs PHP White Paper
What they need is a PHP-Lasso converter, or offer a dev person to convert your application. Similar to ASP2PHP MYSQL CONTENT: And does Lasso offer MySQL connection pooling? -Original Message- From: John Dean [mailto:[EMAIL PROTECTED]] Sent: Thursday, March 07, 2002 2:59 PM To: [EMAIL PROTECTED]; [EMAIL PROTECTED] Cc: [EMAIL PROTECTED]; [EMAIL PROTECTED]; [EMAIL PROTECTED] Subject: RE: [ANN] Blue World Announces Lasso vs PHP White Paper At 12:30 07/03/2002 -0700, [EMAIL PROTECTED] wrote: I think this is should be Learning Lasso$2500 PHP $2500 This may be true if you have no knowledge of either system, but most people on this list have a great deal of experience using PHP and for them that would be money down the drain. Dosent matter if the product is free it still costs you time. Can you provide a NON-BIAS so-called TRUE comparison? I would be curious on what Blueworld has to say. Also, why do you think the TCO is lower with lasso than PHP? I don't get it, there is no cost to own it, just to develop it. And if you develop with PHP correctly, then the TCO is low. Here is my basic TCO comparison: Lasso Software Pro $1199 PHP $0.00 Learning Lasso$2500 PHP $0.00 Development (hr avg) $75 PHP $75/hr. So to me, Lasso isn't worth switching. I would already be $3700 in the hole without even touching it! -Original Message- From: Cathy Cunningham (Blue World Lasso Evangelist) [mailto:[EMAIL PROTECTED]] Sent: Thursday, March 07, 2002 12:37 PM To: Chuck PUP Payne; [EMAIL PROTECTED] Subject: Re: [ANN] Blue World Announces Lasso vs PHP White Paper At 1:19 PM -0500 3/7/02, Chuck \PUP\ Payne wrote: But who wants to pay. Get a clue that's why PHP, PERL, and other Open Source Lang., are widely more used. If you do a true comparison in features, you'll see that a PHP-based solution (with commercial add-ons) costs over three times the cost of Lasso. Then there's also the (TCO) total cost of ownership where due to productivity gains in using Lasso, developers end up saving lots of time (e.g. money) compared with using other tools. Then there's also the fact that when you buy Lasso Professional 5, you're also supporting MySQL AB as each copy purchased puts money in their pockets. And, this is a good thing to ensure the future vitality (and growth) of the MySQL market. It also gives you peace of mind in knowing that you have a commercial license of MySQL, which can help ease liability and other concerns that may otherwise be present in certain organizations who may have concerns using just GPL products. Then there's the issue of quality. With Lasso Professional 5, no stone remains unturned with respect to ensuring Web developers have the highest quality offering both in terms of features, documentation, support materials and more. CC -- - Cathy Cunningham [EMAIL PROTECTED] Lasso Evangelist Blue World Communications, Inc. http://www.blueworld.com/ - Lasso Studio is the easiest way to create a database-driven Web site - Macworld Magazine - 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 Regards John, Former MySQL Developer - [EMAIL PROTECTED] http://www.rygannon.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: [ANN] Blue World Announces Lasso vs PHP White Paper
Another thread pointed out that this runs on doze and Mac, I would venture to say a lot if not most, on this list are *nix people, so the have gotton bad press and have not targeted the correct userbase. Myself, if you spam me, I will not look at you products. spam kills! John On Thursday 07 March 2002 15:34, Todd Williamsen wrote: You think Blue World getting the point yet? Maybe they are thinking twice about spamming mailing lists with their products? Maybe a better target is Microsoft's .NET boards since both products are about the same price -Original Message- From: Jonathan Hilgeman [mailto:[EMAIL PROTECTED]] Sent: Thursday, March 07, 2002 2:00 PM To: '[EMAIL PROTECTED]' Subject: RE: [ANN] Blue World Announces Lasso vs PHP White Paper Ah, the keywords with commercial add-ons. Notice the plurality, as well. I wonder which add-ons and how many total add-ons were considered in making this cost estimate. I also wonder if most of us would even need more than one commercial add-on at most. - Jonathan -Original Message- From: Cathy Cunningham (Blue World Lasso Evangelist) [mailto:[EMAIL PROTECTED]] Sent: Thursday, March 07, 2002 12:37 PM To: Chuck PUP Payne; [EMAIL PROTECTED] Subject: Re: [ANN] Blue World Announces Lasso vs PHP White Paper At 1:19 PM -0500 3/7/02, Chuck \PUP\ Payne wrote: But who wants to pay. Get a clue that's why PHP, PERL, and other Open Source Lang., are widely more used. If you do a true comparison in features, you'll see that a PHP-based solution (with commercial add-ons) costs over three times the cost of Lasso. Then there's also the (TCO) total cost of ownership where due to productivity gains in using Lasso, developers end up saving lots of time (e.g. money) compared with using other tools. Then there's also the fact that when you buy Lasso Professional 5, you're also supporting MySQL AB as each copy purchased puts money in their pockets. And, this is a good thing to ensure the future vitality (and growth) of the MySQL market. It also gives you peace of mind in knowing that you have a commercial license of MySQL, which can help ease liability and other concerns that may otherwise be present in certain organizations who may have concerns using just GPL products. Then there's the issue of quality. With Lasso Professional 5, no stone remains unturned with respect to ensuring Web developers have the highest quality offering both in terms of features, documentation, support materials and more. CC - 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: [ANN] Blue World Announces Lasso vs PHP White Paper
From: Cathy Cunningham (Blue World Lasso Evangelist) If you do a true comparison in features, you'll see that a PHP-based solution (with commercial add-ons) costs over three times the cost of Lasso. I try to stay out of such discussions, but your marketing-oriented spiel inspired me to point out that most of us in here are developers interested in technical-type things, not PHB'S cost and ease of use-type things. A shell and an editor probably meet most our needs. Announce your product(s), if you must, but move on and leave the bandwidth available for MySQL implementation discussions if you don't mind. Thx, Van -- = Linux rocks!!! http://www.dedserius.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: insert problems
At 01:40 PM 3/7/2002, you wrote: Are there any documented reasons why mysql would only enter certain fields and skip others? I am having some strange problems where it seems that data are randomly dropped from inserts via web forms. Have posted before stating a possible cache or proxy problem, but I am still at a loss... Petre, It could be caused by special characters in one of the fields. If you are using PHP then you need to prepare the text variable's contents before adding it to the SQL statement that updates the table. See AddSlashes, StripSlashes and HTMLSpecialChars in the PHP manual. You should also debug the SQL statements by appending the SQL statement to a text file so you can easily discover what the SQL syntax looks like. I timestamp each line in the debug file so I know when it occurred. The problem should then be obvious. Brent _ Do You Yahoo!? Get your free @yahoo.com address at http://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: [ANN] Blue World Announces Lasso vs PHP White Paper
At 1:47 PM -0700 3/7/02, Van wrote: If you do a true comparison in features, you'll see that a PHP-based solution (with commercial add-ons) costs over three times the cost of Lasso. I try to stay out of such discussions, but your marketing-oriented spiel inspired me to point out that most of us in here are developers interested in technical-type things, not PHB'S cost and ease of use-type things. A shell and an editor probably meet most our needs. Announce your product(s), if you must, but move on and leave the bandwidth available for MySQL implementation discussions if you don't mind. I agree that the principal consideration shouldn't be cost. Some of your colleagues simply stated that they won't even look at the paper because they think everything with PHP is free. All that was announced here was a report comparing Lasso to PHP. Details on what is contained in the report are contained therein. And yes, if someone is going to cast the report off due to their own personal prejudice and make inaccurate remarks here, we feel it only fair to be given the opportunity to correct said misinformation. All the technical details are in the report, and all discussion of costs aside, we'd be delighted to talk tech and get into the nitty gritty of the feature and performance comparisons. Cheers! CC -- - Cathy Cunningham [EMAIL PROTECTED] Lasso Evangelist Blue World Communications, Inc. http://www.blueworld.com/ - Lasso Studio is the easiest way to create a database-driven Web site - Macworld Magazine - 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: Running MySQL as Service on 2000 Server
I have no problem running mySQL as a service on Win2k Server. -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]] Sent: Thursday, March 07, 2002 2:35 PM To: [EMAIL PROTECTED] Subject: Running MySQL as Service on 2000 Server Hi, Anybody running MySQL on Win 2000 server here? I just installed MySQL 3.23.49-MAX (w/ InnoDB) on a 2000 Server (Dual 1.1 GHz - 1GB RAM - 15GB HD space) and I can run it without any problem from the command line as a standalone. However I couldn't run it as a service even though I already did 'mysqld-max-nt --install' the first time I ran it. Is there anything wrong with MySQL or is it more of permission issue on NT/2000 server. I also attached the my.ini file if it would help. Thanks. Regards, Martin [mysqld] basedir=G:/MySQL datadir=G:/MySQL/data #bind-address= log-slow-queries=h:/slowquery/slowquery.log set-variable=key_buffer=20M innodb_data_home_dir = g:/ibdata innodb_data_file_path = ibdata:2000M;ibdata2:2000M set-variable = innodb_buffer_pool_size=200M set-variable = innodb_additional_mem_pool_size=30M innodb_log_group_home_dir = h:/iblogs innodb_log_arch_dir = h:/iblogs innodb_log_archive=0 set-variable = innodb_log_files_in_group=3 set-variable = innodb_log_file_size=30M set-variable = innodb_log_buffer_size=24M innodb_flush_log_at_trx_commit=1 set-variable = innodb_file_io_threads=10 set-variable = innodb_lock_wait_timeout=50 [WinMySQLAdmin] Server=G:/MySQL/bin/mysqld-max-nt.exe **Disclaimer** This Memo and any attachments, may be confidential and legally privileged. If you are not the intended recipient and have received this in error, kindly destroy this message and notify the sender. Thank you for your assistance. - 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: [ANN] Blue World Announces Lasso vs. PHP White Paper
I don't know what you people are talking about. I have not one clue about anything PHP. But, if the software performs better. Is it not better? If at this time I wanted to think about that course of action, if both were going to cost me the same in time and money to learn, and I took that cost to do so, and in the end it took less time to write the code in one product in the other, I would chose that one. Less key strokes, less time spent, less cost in the long run. Over the next 10 years (if the technology lasts that long) if it costs 5000 grand to do the work with Lasso and 1 grand with PHP, where the heck do you think my initial investment would go? Not everyone here is PHP pros, or pros at anything at all for that matter. Some people come here looking for answers and solutions to their database needs. Posting information about products that may assist someone (whether its gaining them money in doing so or not) shouldn't be considered SPAM, but a valuable resource. Posting remarks about this product and doing your own comparisons of value and ability are welcomed. It may help someone make a decision about the product they decide to use. What is the point in SPAMMING replies to someone, more or less telling them to get lost and don't come back to tell us stuff about new technologies, to someone who probably is not monitoring the list? Is that not just a little insane wasting good bandwidth and peoples time? Some of you people who are pros should lighten up a little :) And in purchasing this Lasso product you are supporting MySQL AB. What's wrong about that :) Maybe I am naive, but is PHP going to support MySQL AB financially? -Original Message- From: Todd Williamsen [mailto:[EMAIL PROTECTED]] Sent: Thursday, March 07, 2002 3:35 PM To: 'Jonathan Hilgeman'; [EMAIL PROTECTED] Subject: RE: [ANN] Blue World Announces Lasso vs PHP White Paper You think Blue World getting the point yet? Maybe they are thinking twice about spamming mailing lists with their products? Maybe a better target is Microsoft's .NET boards since both products are about the same price -Original Message- From: Jonathan Hilgeman [mailto:[EMAIL PROTECTED]] Sent: Thursday, March 07, 2002 2:00 PM To: '[EMAIL PROTECTED]' Subject: RE: [ANN] Blue World Announces Lasso vs PHP White Paper Ah, the keywords with commercial add-ons. Notice the plurality, as well. I wonder which add-ons and how many total add-ons were considered in making this cost estimate. I also wonder if most of us would even need more than one commercial add-on at most. - Jonathan -Original Message- From: Cathy Cunningham (Blue World Lasso Evangelist) [mailto:[EMAIL PROTECTED]] Sent: Thursday, March 07, 2002 12:37 PM To: Chuck PUP Payne; [EMAIL PROTECTED] Subject: Re: [ANN] Blue World Announces Lasso vs PHP White Paper At 1:19 PM -0500 3/7/02, Chuck \PUP\ Payne wrote: But who wants to pay. Get a clue that's why PHP, PERL, and other Open Source Lang., are widely more used. If you do a true comparison in features, you'll see that a PHP-based solution (with commercial add-ons) costs over three times the cost of Lasso. Then there's also the (TCO) total cost of ownership where due to productivity gains in using Lasso, developers end up saving lots of time (e.g. money) compared with using other tools. Then there's also the fact that when you buy Lasso Professional 5, you're also supporting MySQL AB as each copy purchased puts money in their pockets. And, this is a good thing to ensure the future vitality (and growth) of the MySQL market. It also gives you peace of mind in knowing that you have a commercial license of MySQL, which can help ease liability and other concerns that may otherwise be present in certain organizations who may have concerns using just GPL products. Then there's the issue of quality. With Lasso Professional 5, no stone remains unturned with respect to ensuring Web developers have the highest quality offering both in terms of features, documentation, support materials and more. CC -- - Cathy Cunningham [EMAIL PROTECTED] Lasso Evangelist Blue World Communications, Inc. http://www.blueworld.com/ - Lasso Studio is the easiest way to create a database-driven Web site - Macworld Magazine - 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/
RE: [ANN] Blue World Announces Lasso vs PHP White Paper
All we're doing here is providing information on a report that was just released and answering questions and clarifying mis-perceptions. Don't you mean All we're doing here is marketing our product to an e-mail list ... ? Sharing information for the betterment of the community is good for us all. And the community sharing their money with Blue World is good for Blue World. I've always believed that the best products and companies are created to satisfy an existing, real demand, not to first create the supply, and then also create artificial, new demand. You really don't see Red Hat or many other UNIX-related systems marketing themselves in magazines a lot (there are SOME ads, but not many), but yet they have so much popularity because those operating systems are good and meet a demand for more stable, faster environments. People come to them, not vice versa. I mean, I've never EVER been hit with an e-mail saying, Come see what Red Hat Linux can do for you. Buy our packaged CDs in Office Depot! Obviously sometimes there's a demand and a product can get released without people realizing that the product can satisfy that demand, and promotion is obviously involved to some degree in everything. But after getting so many REPEATED, negative responses from the list in the past about spam, I'm really surprised that Blue World continues to try and market their product on these lists. It's a I-Don't-Care-How-Many-People-Get-Annoyed-As-Long-As-I-Get-A-Sale attitude, and I think it reflects the quality of service that we'd receive if we signed up, because the company is willfully choosing to ignore large amounts of protest to achieve their own success. Don't you think that if Lasso was a truly incredible product, we'd all be reading more and more messages that say something along the lines of, Oh - in this case, your best bet would be Lasso... ??? Yet I rarely see these messages. Blue World really needs to begin paid marketing in magazines and other forms of media where other commercial products are normally advertised. It would probably closely match your target market (assuming you have done the research to develop an SMP (Strategic Marketing Plan), and you wouldn't tick off everyone on these lists. - Jonathan The sql-database-query-mysql Man - 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: [ANN] Blue World Announces Lasso vs PHP White Paper
Hmm Isn't price one of the the factors in doing a comparision? No matter what project size it is, cost plays a major role. If I can save a client $3000 by using PHP versus using Lasso, I would. It doesn't seem Lasso has a $3000(or more) advantage over PHP/mySQL combo. The thing is that people using PHP know PHP, and that means learning Lasso isn't cost effective now. They would need to train for it and learn the product, and buy it. Maybe if you gave use mysql list users a NFR copy of Lasso, maybe we would consider it and try it out and give our unbias opinion. Another thing is some of us rely on outsourcing our web servers and our hosting providers probably won't let us install and server products on their machines. Is there a workaround for this? I would curious to try out Lasso, but I am not going to drop $1200 into something when PHP is free and is currently more than capable of handling my tasks so far -Original Message- From: Cathy Cunningham (Blue World Lasso Evangelist) [mailto:[EMAIL PROTECTED]] Sent: Thursday, March 07, 2002 2:58 PM To: [EMAIL PROTECTED] Cc: [EMAIL PROTECTED] Subject: Re: [ANN] Blue World Announces Lasso vs PHP White Paper At 1:47 PM -0700 3/7/02, Van wrote: If you do a true comparison in features, you'll see that a PHP-based solution (with commercial add-ons) costs over three times the cost of Lasso. I try to stay out of such discussions, but your marketing-oriented spiel inspired me to point out that most of us in here are developers interested in technical-type things, not PHB'S cost and ease of use-type things. A shell and an editor probably meet most our needs. Announce your product(s), if you must, but move on and leave the bandwidth available for MySQL implementation discussions if you don't mind. I agree that the principal consideration shouldn't be cost. Some of your colleagues simply stated that they won't even look at the paper because they think everything with PHP is free. All that was announced here was a report comparing Lasso to PHP. Details on what is contained in the report are contained therein. And yes, if someone is going to cast the report off due to their own personal prejudice and make inaccurate remarks here, we feel it only fair to be given the opportunity to correct said misinformation. All the technical details are in the report, and all discussion of costs aside, we'd be delighted to talk tech and get into the nitty gritty of the feature and performance comparisons. Cheers! CC -- - Cathy Cunningham [EMAIL PROTECTED] Lasso Evangelist Blue World Communications, Inc. http://www.blueworld.com/ - Lasso Studio is the easiest way to create a database-driven Web site - Macworld Magazine - 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
A sure way to start/connect mysql under Linux
Hi Suppose we have the binary distribution already installed. 1. run mysq_install_db script 2. run mysql_setpermission 3.Go to in /etc/init.d and make 2(two) symbolic link from mysqld script to ... - K12mysqld - OS kill the daemon when shutdown. - S12mysqld - OS start the daemon on boot. ...in rc3.d directory (if your OS boot on text mode) or rc5.d directory (if your OS boot with graphical login). NOTE:After you create this links you must verify(in rc3.d or rc5.d) if this files have the symbol @ in front of the filename.(@K12mysqld or @S12mysqld) If the symbol exist it's OK . If appear the symbol ! GoTo step 3. (OPTIONAL but not recommended(security reason) - you can edit the my.cnf and modify the socket path to /tmp/mysql.sock in mysqld section.In tmp directory all processes are rights to create files) 4. Reboot. This steps are necessary if you can't start the mysql daemon like service with OS utilities (linuxconf under RedHat,yast under SuSe ...etc) Good Luck, Gelu - 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: MS-DOS Window
I tried using 'tee' in MySql but it's not working. mysql tee file.txt; ERROR 1064; You have an error in your SQL syntax near 'tee file' at line 1 I'm running version 3.22.34-shareware-debug on Win98. Is this a problem? Do I need to pick up a more recent version? Thanks, Robbie On Mon, 4 Mar 2002, Gurhan Ozen wrote: Hi Robbie, There are a few ways you can capture the output to a file.. First of all, you can have all your sql statement in a file , say myquery.sql file, and call it from command line and redirect it to a different file such as this: C:\mysql\bin\mysql myquery.sql outputfile.txt Or, you can select your query into a outfile with SELECT INTO OUTFILE 'outfile.txt'; syntax. See http://www.mysql.com/documentation/mysql/bychapter/manual_Reference.html#SEL ECT for this ... OR, you can use the tee command in mysql prompt... Just do : mysqltee outfile.txt mysqlselect blah, blah; mysqlnotee Hope this helps... Gurhan, -Original Message- From: Robbie Martinez [mailto:[EMAIL PROTECTED]] Sent: Monday, March 04, 2002 6:31 PM To: [EMAIL PROTECTED] Subject: MS-DOS Window This may be a simple MS-DOS question, but I'm a UNIX guy and am pretty clueless... I'm trying to capture some mysql command output, but my DOS screen runs out of space. In other words, the data goes beyond what I can scroll up to get. Is there any way for me to either: (1) Redirect output from mysql commands to a file (2) Create a session typescript of mysql (3) Increase the DOS window's scroll memory to a very large size (so I don't lose my data on my screen). 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
error starting mysql
Hi, I assigned rights to a user in mysql, mysql grant all on books.* to bookorama@localhost identified by 'bookorama123'; Then I tried to access mysql in as a regular user, [bookorama@a177 bookorama]$ mysql -u bookorama books -p; Enter password: bookorama123 And I get the following error message, ERROR 1045: Access denied for user: 'bookorama@localhost' (Using password: YES) Would someone please help me how to troubleshoot this? Thanks, Norman - 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: MS-DOS Window
I don't have a problem and I am using 3.23.47 -Original Message- From: Robbie Martinez [mailto:[EMAIL PROTECTED]] Sent: Thursday, March 07, 2002 3:51 PM To: Gurhan Ozen Cc: [EMAIL PROTECTED] Subject: RE: MS-DOS Window I tried using 'tee' in MySql but it's not working. mysql tee file.txt; ERROR 1064; You have an error in your SQL syntax near 'tee file' at line 1 I'm running version 3.22.34-shareware-debug on Win98. Is this a problem? Do I need to pick up a more recent version? Thanks, Robbie On Mon, 4 Mar 2002, Gurhan Ozen wrote: Hi Robbie, There are a few ways you can capture the output to a file.. First of all, you can have all your sql statement in a file , say myquery.sql file, and call it from command line and redirect it to a different file such as this: C:\mysql\bin\mysql myquery.sql outputfile.txt Or, you can select your query into a outfile with SELECT INTO OUTFILE 'outfile.txt'; syntax. See http://www.mysql.com/documentation/mysql/bychapter/manual_Reference.html #SEL ECT for this ... OR, you can use the tee command in mysql prompt... Just do : mysqltee outfile.txt mysqlselect blah, blah; mysqlnotee Hope this helps... Gurhan, -Original Message- From: Robbie Martinez [mailto:[EMAIL PROTECTED]] Sent: Monday, March 04, 2002 6:31 PM To: [EMAIL PROTECTED] Subject: MS-DOS Window This may be a simple MS-DOS question, but I'm a UNIX guy and am pretty clueless... I'm trying to capture some mysql command output, but my DOS screen runs out of space. In other words, the data goes beyond what I can scroll up to get. Is there any way for me to either: (1) Redirect output from mysql commands to a file (2) Create a session typescript of mysql (3) Increase the DOS window's scroll memory to a very large size (so I don't lose my data on my screen). 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 - 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: MS-DOS Window
Yes ... just went to mysql.com and I think the tee functionality was introduced in 3.23.XX -Robbie On Thu, 7 Mar 2002, Todd Williamsen wrote: I don't have a problem and I am using 3.23.47 -Original Message- From: Robbie Martinez [mailto:[EMAIL PROTECTED]] Sent: Thursday, March 07, 2002 3:51 PM To: Gurhan Ozen Cc: [EMAIL PROTECTED] Subject: RE: MS-DOS Window I tried using 'tee' in MySql but it's not working. mysql tee file.txt; ERROR 1064; You have an error in your SQL syntax near 'tee file' at line 1 I'm running version 3.22.34-shareware-debug on Win98. Is this a problem? Do I need to pick up a more recent version? Thanks, Robbie On Mon, 4 Mar 2002, Gurhan Ozen wrote: Hi Robbie, There are a few ways you can capture the output to a file.. First of all, you can have all your sql statement in a file , say myquery.sql file, and call it from command line and redirect it to a different file such as this: C:\mysql\bin\mysql myquery.sql outputfile.txt Or, you can select your query into a outfile with SELECT INTO OUTFILE 'outfile.txt'; syntax. See http://www.mysql.com/documentation/mysql/bychapter/manual_Reference.html #SEL ECT for this ... OR, you can use the tee command in mysql prompt... Just do : mysqltee outfile.txt mysqlselect blah, blah; mysqlnotee Hope this helps... Gurhan, -Original Message- From: Robbie Martinez [mailto:[EMAIL PROTECTED]] Sent: Monday, March 04, 2002 6:31 PM To: [EMAIL PROTECTED] Subject: MS-DOS Window This may be a simple MS-DOS question, but I'm a UNIX guy and am pretty clueless... I'm trying to capture some mysql command output, but my DOS screen runs out of space. In other words, the data goes beyond what I can scroll up to get. Is there any way for me to either: (1) Redirect output from mysql commands to a file (2) Create a session typescript of mysql (3) Increase the DOS window's scroll memory to a very large size (so I don't lose my data on my screen). 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 - 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
making : an allowable character in tables colums
Access can do it, I have queries in access that need to be able to read the data I imported into Mysql from access. Can it be done, if so how TIA Joseph ### Any views in this message are those of the individual sender, except where the sender expressly, and with authority, states them to be the views of Electrolux Home Products Pty. Ltd. ### - 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 mysql-unsubscribe-##L=##[EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: [ANN] Blue World Announces Lasso vs PHP White Paper
G'day Cathy we feel it only fair to be given the opportunity to correct said misinformation. You're forgetting that your original mail was forced upon us by you - in my eyes, your right of reply is dissolved with this action. If you don't like the negative response, don't make the original post. What you needed to do was a brief message saying the comparison was available at x link and I'm sure those interested would have looked. Instead, you p*ssed lots of people off. The lesson here is don't preach to those who might not want to be converted. cheers kim mysql, query - 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
RPM installation fails on RH7.2
Hi I have installed RedHat 7.2 . with Apache and DNS as default. When trying to install MySQL with kpaackage manager I get rpmdepCheck() fialed. I cannot see any required modules missing. Can anyone tel me what is wrong? Olav - 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: [ANN] Blue World Announces Lasso vs PHP White Paper
The lesson here is don't preach to those who might not want to be converted. W.W.J.D. - after Jesus cast the demon Legion out of that one guy, the people in that area asked him to leave and he left without any arguments. Take a hint from the Savior, Blue World. grin - Pastor Jonathan Reverend of all things MySQL DISCLAIMER: I am not really a pastor or reverend. Don't use my words as accurate Biblical reference - the real story can be found somewhere around the beginning to middle of Matthew. And don't drink and drive. And never smoke query or sql. Or just don't smoke. -Original Message- From: Kim Kohen [mailto:[EMAIL PROTECTED]] Sent: Thursday, March 07, 2002 2:36 PM To: [EMAIL PROTECTED] Subject: Re: [ANN] Blue World Announces Lasso vs PHP White Paper G'day Cathy we feel it only fair to be given the opportunity to correct said misinformation. EUREUREUREUR You're forgetting that your original mail was forced upon us by you - in my eyes, your right of reply is dissolved with this action. If you don't like the negative response, don't make the original post. What you needed to do was a brief message saying the comparison was available at x link and I'm sure those interested would have looked. Instead, you p*ssed lots of people off. The lesson here is don't preach to those who might not want to be converted. cheers kim mysql, query - 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
C API BLOB type field lengths returned
Howdy - I've posted this twice before - third time might be the charmer... Can anybody help me? I am using the C API and am returning a result set from a table with a BLOB type item in it. When I populate the BLOB fields initially (with all the same data) the length is returned properly when I issue SELECT * FROM table and decode the result set column metadata. Meaning, that if I put , This Blob's for you! in the column, the value of MYSQL_FIELDS.length = 65535 (max of BLOB type) and MYSQL_FIELDS.max_length = 21. When I update a few rows and put, That's OK man, but you still can't have my BLOB! in a few columns, the values for the length of the fields are returned funny, or at least, I don't understand why they are returning they way they are. Meaning the value of the new column length are all set to MYSQL_FIELDS.length = 65535 (again, max of BLOB type) and MYSQL_FIELDS.max_length = 49. Problem is, this is even on the unchaged rows! Yuk! A little experimentation showed that if I select on only unchanged rows, the length is returned as 21. But, if the result set has one of the changed rows in it, the length of all blob fields is returned as 49, when (at least to me) it should be 21 or 49. In other words, it returns as the BLOB max_length value the value of the longest blob in the result set, NOT the max_length of each row. I inserted (and updated) some records in the table with BLOB contents It's all about the BLOB and I see the same result. It returns not the length of the BLOB for the row, but the length of the longest BLOB field in the result set. We are running MySQL 3.23.46-Max on RedHat 7.2 Question: 1) How do I get the actual length of the BLOB column in the row, without storing a separate column to maintain BLOB length manually? 2) If this is not a problem because there is some other way to tell where the BLOB buffer ends, please let me know. Have A Great Scouting Day Ken Hylton 7826 Falcon Ridge Drive San Antonio, Texas 78239-4032 210-646-9508 (home) 210-949-7261 (work) 210-949-7254 (fax) 210-287-6756 (cell) [EMAIL PROTECTED] mailto:[EMAIL PROTECTED] [EMAIL PROTECTED] 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
Bug or Misunderstanding
Perhaps I misunderstand how the UNION statement is to be used, but the following query doesn't work as I'd expect: SELECT column_id, SUM(column_a) AS positive_a FROM table_a WHERE column_b = 'positive' UNION SELECT column_id, SUM(column_a) AS negative_a FROM table_a WHERE columb_b = 'negative' I would expect to receive three columns back (column_id, positive_a, negative_a), but what I receive is two columns, with the duplicate column_id's and the negative_a results being lumped under the positive_a column. Can anyone point me in the right direction on this? This is MysQL 4.0.1 FreeBSD binary install. -- Mike Miller, BMG Canada Inc. Tel: 416-586-1646 Fax: 416-586-1661 EMail: [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
