OT: Re: MySQL field data type for ISBN numbers
At 21:08 2003-08-10, you wrote: On Sun, Aug 10, 2003 at 05:25:05PM -0700, James Johnson wrote: I have a MySQL database for books. The ISBN field is set as varchar(15) and I've put a test ISBN number in of 1--111-11. Note that ISBN numbers are a maximum of 13 characters, not 15. Ten digits, three dashes. If you really want to save space, the last digit is just a check digit and can always be determined through a formula on the other digits, so as long as you verify every ISBN before you INSERT it, you can save another digit. Hmmm...And how do You come up with an 'X' as the last digit, as many books on the shelves around me do? I'll snip the rest, since I agree with it all... SQL -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: MYSQL INDEX CREATION...
On Wed, Jul 16, 2003 at 03:49:51PM -0700, Cory Lamle wrote: Contents are Direct Alliance Corporation CONFIDENTIAL - I have a table with 10 cols. 8 of which all need to be searched on independently of each other. Does creating 8 separate indexes for that table affect the speed of how mysql searches each index? In other words would keeping my indexes to only 4 separate indexes be anymore efficient on a table search than If I had 8 separate ones? It's hard to say without a concrete example to look at. Can we see the proposed table structure and a sample query or two? -- Jeremy D. Zawodny | Perl, Web, MySQL, Linux Magazine, Yahoo! [EMAIL PROTECTED] | http://jeremy.zawodny.com/ MySQL 4.0.13: up 6 days, processed 214,100,517 queries (397/sec. avg) -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: replication problem
On Wednesday 06 August 2003 11:50 am, Andy Smith wrote: There is one more thing I can think of to check... Can you send me a copy of the master.info file. I've had to manually change it before after changing the master in the my.cnf file. I found out later that you could do CHANGE MASTER TO I assume you mean from the slave. This is a newly set up slave specifically for this purpose, so all I did was use CHANGE MASTER.. myself. $ cat mysql/master.info angora-bin.001 20102800 127.0.0.1 repl removed 3306 60 Looks fine to me. :( Looks fine to me as well Are you still getting the 1200 error when you try SLAVE START ? -- Walter Anthony System Administrator National Electronic Attachment Atlanta, Georgia 1-800-782-5150 ext. 1608 If it's not broketweak it CONFIDENTIALITY NOTICE The information contained in this email may contain legally privileged and confidential information intended only for the use of the individual noted above. If you are not the intended recipient or employee or agent of the entity listed above, you are hereby notified that any reading, disclosure, distribution, or copying of this email communication in any way, or the taking of any action in relation to this communication, is strictly prohibited. If you have received this email in error, please immediately notify the sender and contact our Privacy Officer at (800) 782-5150 ext: 1601. If you were not the intended recipient, please delete it from your files. Thank you for your compliance. -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
ERROR 1045: Access denied
Hi programmers, Good morning ;-) I think something is wrong, Running windows I believe first I have to set some password, Which creates some user, Then I can grant the required privileges, for some databases. However granting privileges after setting password seems to reset some Other access, === C:\temp\Menagerie_01mysql -u root -p** mysql Welcome to the MySQL monitor. Commands end with ; or \g. Your MySQL connection id is 3 to server version: 4.1.0-alpha-max-debug Type 'help;' or '\h' for help. Type '\c' to clear the buffer. mysql set password for 'elmasri'@'localhost'=password('navathe'); Query OK, 0 rows affected (0.02 sec) mysql set password for 'elmasri'@'%'=password('navathe'); Query OK, 0 rows affected (0.00 sec) mysql grant all on company.* to 'elmasri'@'localhost' identified by 'navathe'; Query OK, 0 rows affected (0.02 sec) mysql grant all on company.* to 'elmasri'@'%' identified by 'navathe'; Query OK, 0 rows affected (0.00 sec) mysql quit Bye C:\temp\Menagerie_01mysql -u elmasri -pnavathe company ERROR 1045: Access denied for user: '[EMAIL PROTECTED]' (Using password: YES) === However if I use only the grant statement, I don't need any set password statement, Both setting password and granting all privileges - ERROR 1045: Access denied But Why ? === C:\temp\Menagerie_01mysql -u root -p* mysql Welcome to the MySQL monitor. Commands end with ; or \g. Your MySQL connection id is 12 to server version: 4.1.0-alpha-max-debug Type 'help;' or '\h' for help. Type '\c' to clear the buffer. mysql grant all privileges on company.* to 'monty'@'localhost' identified by 'python' with grant option; Query OK, 0 rows affected (0.00 sec) mysql quit Bye C:\temp\Menagerie_01mysql -u monty -ppython company Welcome to the MySQL monitor. Commands end with ; or \g. Your MySQL connection id is 13 to server version: 4.1.0-alpha-max-debug Type 'help;' or '\h' for help. Type '\c' to clear the buffer. mysql show tables - ; +---+ | Tables_in_company | +---+ | blabla| +---+ 1 row in set (0.01 sec) mysql drop table blabla; Query OK, 0 rows affected (0.00 sec) mysql show tables; Empty set (0.00 sec) mysql create table blabla ( fname varchar(15) not null )type=innodb; Query OK, 0 rows affected (0.00 sec) mysql show tables; +---+ | Tables_in_company | +---+ | blabla| +---+ 1 row in set (0.00 sec) mysql Yours Sincerely Morten Gulbrandsen -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
UnixODBC Perf Question
Has anyone had much luck with UnixODBC on RedHat Linux. I've recently moved a 100 Gb MySQL database from Win2000 Server to a RedHat 9 server and installed UnixODBC to access it. It appears that the performance is dramatically slower using the same application, pointed to the RedHat server. The performance of command line queries works as expected on the Linux box. I have to use ODBC to access the data (unless anyone knows of a SAS Access for MySQL module in development--hint, hint, nudge, nudge). TIA. -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: NT service starts, but I still have to start server manually.
Hi Tony, First, as I just saw that everything is on C:\. In this case you wont even need the two settings basedir and datadir as far as my understanding goes. I remember that after having registered the service itself mysqld --install, I used the command net start mysql to start the service. I am not sure anymore if I had to go to the services and set it to automatic startup mode or not. I have no Windows machine installed right now to quickly check it. Also I did this on Windows 2000, but I believe thats more or less the same ;-) - I hope nobody is flaming me for that statement. ;-) Thats all really I can remember 1) mysqld --install 2) net start mysql 3) checking if the mysql servie is set to automatic startup in the services processlist. I hope that this helps a bit. Le me know how it went. Best regards Nils Valentin Tokyo/Japan 2003 8 11 19:50Tony Groves : Nils - Thanks for your response. Everything is on the C: drive, in the default locations. C:\winnt\my.ini consists of the following: [client] port=3306 [mysqld] port=3306 basedir = c:/mysql/ datadir = c:/mysql/data/ innodb_data_home_dir = c:/mysql/ibdata/ innodb_log_group_home_dir = c:/mysql/iblogs/ innodb_data_file_path = ibdata1:10M:autoextend set-variable = lower_case_table_names=0 [WinMySQLAdmin] Server=C:/mysql/bin/mysqld-max-nt.exe All the file paths referred to there exist. The MySQL service runs using the system account, and uses the following ImagePath value: c:\mysql\bin\mysqld-max-nt.exe This is the same command that I use to start the server as an application. It is strange that the service starts but does not work, while an application program using the same command does work. Any more suggestions would be gratefully acepted. Thanks a lot. Tony Groves. - Original Message - From: Nils Valentin [EMAIL PROTECTED] To: Jason Kushmaul [EMAIL PROTECTED]; [EMAIL PROTECTED] Cc: [EMAIL PROTECTED] Sent: Monday, August 11, 2003 9:52 AM Subject: Re: NT service starts, but I still have to start server manually. Hi Tony, Just out of interest. The NT installation itself and the MySQL server are both installed on the C:\ drive ? In case the MySQL server would be installed not on C:\ but f.e on E:\, then I would perhaps have a solution. In case the mysql server is installed in another drive (and only then), then you have to tell this to the MySQL server by setting the option --basedir or in the my.cnf file like [mysqld] basedir=E:/mysql But only then really. Another possibility would be that the installed service is pointing to the wrong location. I had this when I uninstalled the previous version,but forgot to unregister the service. The new installation was installed, but I did not get the service up and running, as it was pointing to the old installation (which was removed ;-) Best regards Nils Valentin Tokyo/Japan 2003 8 11 16:58Jason Kushmaul : Is there a C:\my.cnf? If not try copying a distributed my-medium,large,small.cnf it to C:\winnt\my.ini. I had this problem on windows NT4, It seemed that everytime I created the file C:\my.cnf, it would get renamed to C:\my_cnf.bak, but no C:\my.cnf would exist. I read somewhere that this happens when you do not have C:\winnt\my.ini. It fixed my problem of mysql appearing to start, but it wasn't... - Original Message - From: Tony Groves [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: Sunday, August 10, 2003 5:32 PM Subject: NT service starts, but I still have to start server manually. I have installed MySQL (latest version) on my Windows NT4 (SP6) machine and have started testing it. The MySQL service starts successfully at boot time as expected, but I can never connect to the database until I start the server manually - it makes no difference whether the service is already running or not, and whether it had been started automatically or manually. Any ideas, anybody? -- MySQL Windows Mailing List For list archives: http://lists.mysql.com/win32 To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED] -- --- Valentin Nils Internet Technology E-Mail: [EMAIL PROTECTED] URL: http://www.knowd.co.jp Personal URL: http://www.knowd.co.jp/staff/nils -- --- Valentin Nils Internet Technology E-Mail: [EMAIL PROTECTED] URL: http://www.knowd.co.jp Personal URL: http://www.knowd.co.jp/staff/nils -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: Dropping primary key/unique key
Nils Valentin [EMAIL PROTECTED] wrote: Hi Victoria, Victoria Reznichenko wrote: Nils Valentin [EMAIL PROTECTED] wrote: I have a problem understanding why MySQL is deleting a unique key instead of a primary key. from Documentation: DROP PRIMARY KEY drops the primary index. If no such index exists, it drops the first UNIQUE index in the table. When I do it then I get this: mysql desc uksample4; +---+--+--+-+-+---+ | Field | Type | Null | Key | Default | Extra | +---+--+--+-+-+---+ | id| int(11) | | UNI | 0 | | | name | char(30) | YES | | NULL| | | tel | char(20) | | PRI | | | +---+--+--+-+-+---+ 3 rows in set (0.00 sec) mysql alter table uksample4 drop primary key ; Query OK, 0 rows affected (0.24 sec) Records: 0 Duplicates: 0 Warnings: 0 mysql desc uksample4; +---+--+--+-+-+---+ | Field | Type | Null | Key | Default | Extra | +---+--+--+-+-+---+ | id| int(11) | | | 0 | | | name | char(30) | YES | | NULL| | | tel | char(20) | | PRI | | | +---+--+--+-+-+---+ 3 rows in set (0.00 sec) It deletes the unique key (id) instead of he primary key (tel). Did I do something wrong ? MySQL 4.0.14 Your example worked fine for me. Could you provide a test case? I know that the example worked as decribed above, thank you for confirming it. :-) My Question is, why would it not drop the primary key, but the unique key instead ?? Which command would delete the primary key ? MySQL drops primary key for me. That is why I ask you about test case. -- For technical support contracts, goto https://order.mysql.com/?ref=ensita This email is sponsored by Ensita.net http://www.ensita.net/ __ ___ ___ __ / |/ /_ __/ __/ __ \/ /Victoria Reznichenko / /|_/ / // /\ \/ /_/ / /__ [EMAIL PROTECTED] /_/ /_/\_, /___/\___\_\___/ MySQL AB / Ensita.net ___/ www.mysql.com -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: Problem with merge tables in 4.1
In the last episode (Aug 06), Pierre-Luc Soucy said: I was working on some merge tables this morning and it worked fine, but after a few unsuccessful table creation requests (I was making some tests), I could not alter or select from a table for the following reason: mysql create table test_table (country CHAR(2) NOT NULL) TYPE=MERGE UNION=(countries); Query OK, 0 rows affected (0.00 sec) mysql select * from test_table; ERROR 1016: Can't open file: 'test_table.MRG'. (errno: 143) $ perror 143 Error code 143: Unknown error: 143 143 = Conflicting table definitions in sub-tables of MERGE table Does your countries table layout match that of test_table? -- Dan Nelson [EMAIL PROTECTED] -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: MySQL field data type for ISBN numbers
On Sun, Aug 10, 2003 at 05:25:05PM -0700, James Johnson wrote: I have a MySQL database for books. The ISBN field is set as varchar(15) and I've put a test ISBN number in of 1--111-11. Note that ISBN numbers are a maximum of 13 characters, not 15. Ten digits, three dashes. If you really want to save space, the last digit is just a check digit and can always be determined through a formula on the other digits, so as long as you verify every ISBN before you INSERT it, you can save another digit. Heck, if you wanted to, you could store the ISBN as components. A TINYINT for the country/region, a MEDIUMINT for each of publisher and publication, and a SET for the last digit. Instead of 13 bytes per ISBN, you could shrink it to slightly more than 4 bytes. Of course, unless you're dealing with millions of books, or functions that require queries-by-publisher, it probably isn't worth the effort. Can someone tell me why this SQL query isn't working? The advice already given is exactly what I'd submit, so I won't bother repeating it. The only thing I'll add is ... in addition to having your PHP script print the $query to the browser, you might want to have it print mysql_error() to see if the db reported anything nasty. I usually go with constructs like: $q = SELECT ... WHERE ...; if (!$r = mysql_query($q)) { $err=db failure: . mysql_error(); } if (!$err) { if (!$row = mysql_fetch_array($r)) { $err=query failure: . mysql_error(); } } if (!$err) { // do something useful with $row[] } else { print ERROR: tt . $err . /tt\n; } It's especially useful if you have a bunch of things that all depend on the successful completion of previous commands, be they related to MySQL or anything else. -- Paul Chvostek [EMAIL PROTECTED] it.canadahttp://www.it.ca/ Free PHP web hosting!http://www.it.ca/web/ -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: libmysqlclient.so.10 is needed by (installed) mod_auth_mysql-1.11-12
-BEGIN PGP SIGNED MESSAGE- Hash: SHA1 Hi, On Mon, 11 Aug 2003, System wrote: Hello All, Redhat 9.0 Mysql 3.23.56 == Running I want to upgarde to 4.0.13 but this is the error it says: [EMAIL PROTECTED] downloads]# rpm -Uvh MySQL-server-4.0.13-0.i386.rpm warning: MySQL-server-4.0.13-0.i386.rpm: V3 DSA signature: NOKEY, key ID 5072e1f5 error: Failed dependencies: libmysqlclient.so.10 is needed by (installed) mod_auth_mysql-1.11-12 libmysqlclient.so.10 is needed by (installed) perl-DBD-MySQL-2.1021-3 libmysqlclient.so.10 is needed by (installed) php-mysql-4.2.2-17.2 If i install with -i will it install with the backward compatibility, it should not break those dependencies. Any comments ? You need to install MySQL-shared-compat in addition to MySQL-server - this will satisfy the library dependencies. http://www.mysql.com/doc/en/Linux-RPM.html Bye, LenZ - -- Lenz Grimmer [EMAIL PROTECTED] Senior Production Engineer MySQL GmbH, http://www.mysql.de/ Hamburg, Germany For technical support contracts, visit https://order.mysql.com/?ref=mlgr -BEGIN PGP SIGNATURE- Version: GnuPG v1.2.2-rc1-SuSE (GNU/Linux) Comment: For info see http://quantumlab.net/pine_privacy_guard/ iD8DBQE/N3VCSVDhKrJykfIRAvzOAJ9Io3UPSR8o2lNPULN7pX043FW5iACdHefi +u+kj+2kBkLeonbeJhzPhBM= =eQL6 -END PGP SIGNATURE- -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: Using a foreign character set in MYSQL
This isn't a complete answer but it may point you in the right direction... I had some experience of using localized text (most of the popular languages) in a database a couple of years ago. That was using Oracle but the lessons are the same. Initially Oracle was not UTF-8 enabled. Alot of text could be stored using the latin character set. We'd use the \u notation or something similar for the special characters. Eventually we had Oracle UTF-8 enabled so we could just load in the special characters (such as Japanese and Chinese) from a UTF-8 text document. Note, I used the TextPad 4.5 program. It's SaveAs option enables you to save files using UTF-8 encoding. I'm no MySQL expert, but the different lanaguage setting in MySQL seem to mainly apply to its error messages. To my knowledge, MySQL does not yet offer full UTF-8 support so you might have to store the special characters using the \u notation or something similar. You might need a utility program to generate the text file codes easily. Someone in our office wrote one in Java. Skim through the following which I found after a quick search on google... http://darkstar.ist.utl.pt/mysql/doc/en/Charset-Unicode.html http://ldp.kernelnotes.de/HOWTO/Unicode-HOWTO.html http://www.cogsci.ed.ac.uk/~richard/unicode-sample.html www.unicode.org It's an excellent question. One that's on my todo list to work out fully! - Original Message - From: Vikram Vaswani [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: Monday, August 04, 2003 5:48 PM Subject: Using a foreign character set in MYSQL Hello all. I am working with MySQL 4.0. I have a requirement to create a data-driven Web page to display Chinese text from a MySQL table. I'm completely new to this, can someone tell me exactly what I need to do to make this happen? 1. For example, how do I insert the Chinese text from my source (a Word doc) into a MySQL table without corrupting it? When I try copying and pasting it into the mysql client command-line, the data gets trashed. 2. Once it's in, how do I get it back out into my application without corrupting it? I'm using PHP 4.3 for the Web site. 3. If I need to make changes to the data from the command-line client, how can I do it, especially if the query involves using a Chinese-language string? For example, update langdata set menutitle='SOME_MENU_TITLE_IN_CHINESE' where menutitle='SOME_OLD_MENU_TITLE_IN_CHINESE' Looked at the online manual but am sorry to say it didn't really help much. I tried starting the server with --character-set=big5 but it didn't seem to make much difference... Thanks! Vikram -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED] --- Outgoing mail is certified Virus Free. Checked by AVG anti-virus system (http://www.grisoft.com). Version: 6.0.506 / Virus Database: 303 - Release Date: 01/08/2003 -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: Quick ones to speed up acces!
Thanks alot roger. Right now i m going through the indexes and Full text search stuff. I'll surely let u know any improvement in the performance after i m done. Binay - Original Message - From: Roger Davis [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: Monday, August 11, 2003 5:49 PM Subject: RE: Quick ones to speed up acces! MySQL does not use an index when you do %blah%. It would use the index for blah% however. See the following reference. http://www.mysql.com/doc/en/MySQL_indexes.html I would suggest you alter your tables to use a FullText Search. http://www.mysql.com/doc/en/Fulltext_Search.html Roger -Original Message- From: Binay Agarwal [mailto:[EMAIL PROTECTED] Sent: Sunday, August 10, 2003 7:53 PM To: Roger Davis; [EMAIL PROTECTED] Subject: Re: Quick ones to speed up acces! Thanks Roger for quick response. Herebelow the structure of my table and query. CREATE TABLE npg_search ( sno int(11) NOT NULL auto_increment, fileid varchar(255) NOT NULL, caption text, headline varchar(255), specialins varchar(255), keywords varchar(255) NOT NULL, cat varchar(50) NOT NULL, byline varchar(255), credit varchar(255), source varchar(255), date date, city varchar(100), state varchar(100), country varchar(100) NOT NULL, orgtransref varchar(100), copyright varchar(255), extratxt text, prints tinyint(4), extrastr varchar(255), bylinetitle varchar(255), addedon timestamp(14), PRIMARY KEY (sno), INDEX (fileid, keywords, cat, country)); As shown columns fileid,keywords,cat and country are indexed. Query is: Select * from table where keywords like '%blah%' or caption like '%blah%' or headline like '%blah%' or cat like '%blah%' Please help me out. Binay - Original Message - From: Roger Davis [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: Monday, August 11, 2003 4:57 PM Subject: RE: Quick ones to speed up acces! It's called indexing and your queries should return in under 1 sec unless you are pulling all your records and all your data. Show us your Queries and you table structure and I am sure we can help. Roger -Original Message- From: Binay Agarwal [mailto:[EMAIL PROTECTED] Sent: Sunday, August 10, 2003 7:08 PM To: [EMAIL PROTECTED] Subject: Quick ones to speed up acces! Hi everybody! I am querying from a table containing more than 40,000 records. Earlier when the records were 10,000 it was taking 9 sec and now after 1 year and 40,000 records its taking 30 sec. Code is the same. I am pretty sure that it has something to do with database only. No body can think of spending 30 secs for retrieving values from tables unless it's very huge in the sense of millions of records. I don know whether I have to modify my database or do some sort of restructuring or reindexing so as to make it fast enough. Is there some methods or optmization which can be applied to this database which hasn't been touched since design to enhance the spped. If there are some quick ones but valued alottt please let me know. Thanks in advance Binay --- Incoming mail is certified Virus Free. Checked by AVG anti-virus system (http://www.grisoft.com). Version: 6.0.507 / Virus Database: 304 - Release Date: 8/4/2003 --- Outgoing mail is certified Virus Free. Checked by AVG anti-virus system (http://www.grisoft.com). Version: 6.0.507 / Virus Database: 304 - Release Date: 8/4/2003 -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED] --- Incoming mail is certified Virus Free. Checked by AVG anti-virus system (http://www.grisoft.com). Version: 6.0.507 / Virus Database: 304 - Release Date: 8/4/2003 --- Outgoing mail is certified Virus Free. Checked by AVG anti-virus system (http://www.grisoft.com). Version: 6.0.507 / Virus Database: 304 - Release Date: 8/4/2003 -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED] -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: the logic of full text search
No, there are just a few rows in my table, as I am still developing the program. Will it be better when the table is in regular use (and the number of rows will increase)? Sj I am trying to understand the logic of full text search in mysql. I'm not using mysql 4. The search work OK, be it thast I get hits on certain words, whilst other words are discarded for some reason or other. Why is that. An example: I search in a text field for the word organisation. I get hits. When I search for the word scenario nothing is found. But I can see the word in the paragraphs by myself? Is there an explanation for this? AIUI, if a word occurs too many times (in more than x% of rows, I can't remember the logic used) then it's treated as a stop word. This means that words that appear in almost every row (like the, you etc) which would have no value to a search are ignored. I believe this is what's causing your problem. Do you have many records in the table you're doing a fulltext search on? IME it tends to work better with plenty of rows to work with. HTH! David P -- David Precious http://www.preshweb.co.uk/ -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
preserving indexes
Hi Every night. I dump the schema of a table, drop it, create the table, and load it up with data. I'm using phpMyAdmin for the most part. I notice that the index cardinality shows up as None in phpMyAdmin for each index I have. If I drop the index and re-create it, all of the indexes show their correct cardinality. I don't think phpMyAdmin is at fault because searching on the table before I fix it is sluggish until afterwards. Is the a command I could run that would re-index everything after I dump the data into the table? Or what is going on? thanks. -- Chris Edwards Web Application Developer Outer Banks Internet, Inc. 252-441-6698 [EMAIL PROTECTED] http://www.OuterBanksInternet.com -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
mysqld_multi on Linux RedHat 9
Hello, mysqld_multi doesn't start the two groups if I gave this command imediately after stopping them. Thanks Anticipated, Iulian . -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
RE: Help with count(*)
what ever happend to a unique primary key like userID ? User is not the primary key. This is a logging table so the primary key is likely to be a timestamp of some sort. Read the question. -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
RE: mysql LOAD DATA INFILE
[snip] I see you still have the word LOCAL in there. Did you try and remove it? To do that in PHPMyAdmin you will need to run the import so you get the error message and then copy and paste it into the SQL section of the PHPMyadmin tool. Delete the world LOCAL and then run the query. It should work. [/snip] Good catch Donald...I missed tha -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: Recreating MySQL server gone away Error
Anubrata Chakrabarti [EMAIL PROTECTED] wrote: Thanks! I did that and started mysql as : safe_mysqld --interactive_timeout=10 But it DOESN't go away after 10 secs. Show me the output of SHOW VARIABLES LIKE %timeout%. On Fri, 1 Aug 2003, Victoria Reznichenko wrote: Anubrata Chakrabarti [EMAIL PROTECTED] wrote: According to the manual mysql server goes away automatically after 8 hrs (by default). I changed wait_timeout and tried to recreate the problem but no luck! I can access the server even after 8 inactive hrs. If you use mysql command line client hich runs in the interactive mode, you should change value of interactive_timeout variable. -- For technical support contracts, goto https://order.mysql.com/?ref=ensita This email is sponsored by Ensita.net http://www.ensita.net/ __ ___ ___ __ / |/ /_ __/ __/ __ \/ /Victoria Reznichenko / /|_/ / // /\ \/ /_/ / /__ [EMAIL PROTECTED] /_/ /_/\_, /___/\___\_\___/ MySQL AB / Ensita.net ___/ www.mysql.com -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: Error 127, some questions
What OS/kernel are you running? Thanks. Richard Gabriel Director of Technology, CoreSense Inc. (518) 306-3043 x3951 - Original Message - From: Terence [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: Monday, August 11, 2003 2:28 AM Subject: Error 127, some questions Dear List, We have several tables experiencing table error 127 quite often, sometimes several times per day. I have read the relevant posts recently, including http://www.mysql.com/doc/en/Repair.html Forgive me for my lack of technical expertise in these questions: 1) The SQL statements are all INSERTS (using all fields - see below for table structure), so is it possible, say when a client server goes down during an insert, that somehow the data only gets inserted half-way? 2) From other posts, it seems that one common column is a date or timestamp field. Could this be the problem? 3) There are no (very few - once a month for statistical reporting) selects done on the tables, so we don't know when the problem occurs, so is there a way to monitor the tables? 4) It only affects my tables with more than 10k-20k inserts per day. 5) Is moving to InnoDB a way to possible solve the above? 6) We occasionally experience Mysql server has gone away - due to network congestion, could this cause problems? I am using MyISAM tables, MySQL version 3.23-49a. CREATE TABLE /*!32300 IF NOT EXISTS*/ vine ( id int(25) unsigned NOT NULL auto_increment, username varchar(50) , url text , timeaccess datetime , remote_addr varchar(30) , include varchar(50) , PRIMARY KEY (id), UNIQUE id (id), INDEX others (include,username) ); Thanks alot for your help. Rgds Terence -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED] -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
RE: Mysqld dead subsys locked
try have a look at /var/lock/subsys/ see if there is a lock file for mysql... if there is try remove it and start mysql again... hope this help Cheers, Clive -Original Message- From: Robert Morgan [mailto:[EMAIL PROTECTED] Sent: Monday, 11 August 2003 12:21 PM To: mysqllist Subject: Fw: Mysqld dead subsys locked - Original Message - From: Robert Morgan To: mysqllist Sent: Monday, August 11, 2003 1:50 PM Subject: Mysqld dead subsys locked Shut down my Linux PC running MySqld and rebooted this morning and cannot get mysqld up. In services when I click on mysqld I get the message Mysqld dead subsys locked when i restart the server it says mysql succesfully restarted, but it isnt. When I try to stop the server it comes back with an error message failed to shutdown. So I rebooted and during shutdown- shutdown mysql.failed and- mysql killall...failed. Anyone have any ideas as to how I can sort this? would a reinstall of Mysql work? would I lose legacy data doing this? Bob -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Foreign Keys
I am using MYSQL 4. I understand that it allows for foreign keys. Could someone show me an example of how to declare a foriegn key. I tried a combination of statements but I always got a syntax error. Here is what I am trying for example ... Create table x ( ID INT NOT NULL AUTO_INCREMENT PRIMARY KEY, whatever int )Type=Innodb; Create table y ( IDTr INT NOT NULL, constraint FOREIGN KEY IDTr REFERENCES x(ID) )Type=Innodb; How would I create a foreign key linking IDTr to x(ID)? Cheers. Cheers. __ Do you Yahoo!? Yahoo! SiteBuilder - Free, easy-to-use web site design software http://sitebuilder.yahoo.com -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: the logic of full text search
Hi, I am trying to understand the logic of full text search in mysql. I'm not using mysql 4. The search work OK, be it thast I get hits on certain words, whilst other words are discarded for some reason or other. Why is that. An example: I search in a text field for the word organisation. I get hits. When I search for the word scenario nothing is found. But I can see the word in the paragraphs by myself? Is there an explanation for this? AIUI, if a word occurs too many times (in more than x% of rows, I can't remember the logic used) then it's treated as a stop word. This means that words that appear in almost every row (like the, you etc) which would have no value to a search are ignored. I believe this is what's causing your problem. Do you have many records in the table you're doing a fulltext search on? IME it tends to work better with plenty of rows to work with. HTH! David P -- David Precious http://www.preshweb.co.uk/ -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Foreign Keys
I am using MYSQL 4. I understand that it allows for foreign keys. Could someone show me an example of how to declare a foriegn key. I tried a combination of statements but I always got a syntax error. Here is what I am trying for example ... Create table x ( ID INT NOT NULL AUTO_INCREMENT PRIMARY KEY, whatever int )Type=Innodb; Create table y ( IDTr INT NOT NULL, constraint FOREIGN KEY IDTr REFERENCES x(ID) )Type=Innodb; How would I create a foreign key linking IDTr to x(ID)? Cheers. __ Do you Yahoo!? Yahoo! SiteBuilder - Free, easy-to-use web site design software http://sitebuilder.yahoo.com -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
lookup and reverse_lookup UDF problem
I, like others, am having trouble getting the two UDF's mentioned above to work correctly. I successfully compiled MySQL 4.0.14 dynamically with the -rdynamic flag on Linux 8. I have also compiled the udf_example.cc file using the -shared option. Everything seems to go OK when I'm using the CREATE FUNCTION command to add the avaiable UDF's until I get to lookup and reverse_lookup. On these two, I get the following error message: ERROR 1127: Can't find function 'reverse_lookup' in library ERROR 1127: Can't find function 'lookup' in library I checked the func table in the mysql database, and I see where it created the entries for the other functions, so I know it's not a permissions problem. Has anyone out there run into this one and found an answer?
Re: Is there trigger function in MySQL ?
Steve: What you are talking about is Stored Procedures ... not available in the current stable version of MySQL. Stored Procedures are, however, being implemented in MySQL Version 5.0's development tree. This version is still in heavy development ... I wouldn't use it on a production server. Gerald Jensen - Original Message - From: Steven Wu [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: Friday, August 08, 2003 12:49 PM Subject: Is there trigger function in MySQL ? Hi: It seems to me that there is no trigger function in MySQL but I am not sure. Recently, I have a project which need the trigger function when MySQL database server receive a alert information and wake up some procedure. Is there any other method to do the same functionality of trigger as in ORACLE databse ? Steven Wu -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Newbie SQL question
I'm coming from a Filemaker Pro background and have very little SQL experience. I'm trying to write an SQL statement to extract data from two tables. One table has the Team IDs, Team Names for all the high school football teams in the state. The other table has the schedules for all the games. The schedules table has Game_ID, Team_ID, Opponent_ID and Game_Date fields. I've got the SQL statement to return the data that I'm looking for, except, I only get team IDs. I want team names. This is the MySQL statement: mysql select Teams.Team_Name as 'Team Name',Schedules.Team_ID,Schedules.Opponent_ID,Schedules.Game_Date from Schedules,Teams where Teams.id=140 and (Teams.id=Schedules.Team_ID or Teams.id=Schedules.Opponent_ID) order by Game_Date; and here are the results. +-+-+-++ | Team Name | Team_ID | Opponent_ID | Game_Date | +-+-+-++ | Lawrence County | 140 | 88 | 2003-08-28 | | Lawrence County | 163 | 140 | 2003-09-05 | | Lawrence County | 140 | 237 | 2003-09-12 | | Lawrence County | 140 | 161 | 2003-09-19 | | Lawrence County | 263 | 140 | 2003-09-26 | | Lawrence County | 129 | 140 | 2003-10-03 | | Lawrence County | 153 | 140 | 2003-10-10 | | Lawrence County | 140 | 284 | 2003-10-17 | | Lawrence County | 323 | 140 | 2003-10-24 | | Lawrence County | 140 | 26 | 2003-10-31 | +-+-+-++ 10 rows in set (0.01 sec) This is exactly what I want, but, I want to be able to query the Teams table to give me the Team_Name for both the Team_ID (which is the Home team) and the Team_Name for the Opponent_ID (the visiting team). I'm assuming I'd have to have a nested search, but I really don't even know enough about SQL to ask an intellegent question here. Can someone point me in the right direction? Thanks, Keith Warren Systems Editor The Clarion-Ledger -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: Tomcat+MySQL. Intermitent DbcpException: Server configuration denies access to data source
-BEGIN PGP SIGNED MESSAGE- Hash: SHA1 Monica Ferrero wrote: Hi! I'm not sure if this is the most adequate mySQL list for this post. If not, please indicat me which one I should use... I'm using Tomcat 4.1.24 with Apache 2 and MySQL 4.0.13. I have the mysql- connector-java-2.0.14-bin.jar in commons/lib. The application runs normally, and usually about once or twice a day I get this exception org.apache.commons.dbcp.DbcpException: java.sql.SQLException: Server configuration denies access to data source. Once the exception occurs, it happens for every request and Tomcat needs restarting. Before getting this exception, I used to run out of connections, and therefore I added to the server.xml parameter namelogAbandoned/name valuetrue/value /parameter parameter nameremoveAbandoned/name valuetrue/value /parameter I guess it could be related... I include the exception and my server.xml file. Any help appreciated. Monica [snip] ResourceParams name=jdbc/allukmasterDB parameter namefactory/name valueorg.apache.commons.dbcp.BasicDataSourceFactory/value /parameter parameter namemaxActive/name value500/value /parameter parameter namemaxIdle/name value30/value /parameter [snip] Hi! Any reason you need to support _500_ active connections? MySQL will not let you do this out of the box (the limit is set to 100 'max_connections'), you'll need to re-configure MySQL to support more, see: http://www.mysql.com/doc/en/Too_many_connections.html If you cross the default limit, you'll get the 'access denied' exception you are getting. One of the main concepts behind connection pooling is to put a cap on resource usage, 500 connections is awfully high for a properly designed application...You should be able to get by with 25 or less in a well-constructed Java app. You might find my 'connection pooling with Connector/J' article helpful, see: http://www.mysql.com/articles/connection_pooling_with_connectorj.html Regards, Mark - -- Mr. Mark Matthews MySQL AB, Software Development Manager, J2EE and Windows Platforms Office: +1 708 557 2388 www.mysql.com Are you MySQL Certified? http://www.mysql.com/certification/ -BEGIN PGP SIGNATURE- Version: GnuPG v1.2.1 (MingW32) Comment: Using GnuPG with Thunderbird - http://enigmail.mozdev.org iD8DBQE/N8TJtvXNTca6JD8RAg0kAKC6R1MgttLGvo7gHfqUbD6Kyh4WRwCgjlwY P3dPqZbPkZ0ku98fN7pfpWk= =T3xw -END PGP SIGNATURE- -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
RE: mysql LOAD DATA INFILE
Ah. No wonder it dinna work. Neither did specifying the columns as Jay suggested. I also have no choice but to do it through the browser - I don't have command line access on the server. :\ -Mike -Original Message- From: Donald Tyler [mailto:[EMAIL PROTECTED] Sent: Friday, August 08, 2003 4:08 PM To: [EMAIL PROTECTED] Subject: RE: mysql LOAD DATA INFILE Oh and just a note. This solution won't work if you are uploading the file to the server through the browser. You will need to put the file on the server and adjust the commands PATH accordingly. -Original Message- From: Donald Tyler [mailto:[EMAIL PROTECTED] Sent: Friday, August 08, 2003 3:07 PM To: '[EMAIL PROTECTED]' Subject: FW: mysql LOAD DATA INFILE I see you still have the word LOCAL in there. Did you try and remove it? To do that in PHPMyAdmin you will need to run the import so you get the error message and then copy and paste it into the SQL section of the PHPMyadmin tool. Delete the world LOCAL and then run the query. It should work. -Original Message- From: Mike At Spy [mailto:[EMAIL PROTECTED] Sent: Friday, August 08, 2003 2:59 PM To: Donald Tyler; [EMAIL PROTECTED] Subject: RE: mysql LOAD DATA INFILE Sorry, that is the error - my mistake. I am getting this: LOAD DATA LOCAL INFILE '/tmp/php9GOwvw' INTO TABLE `this_one` FIELDS TERMINATED BY ';' LINES TERMINATED BY '\r\n' I am using phpMyAdmin 2.3.3 - would an upgrade to the latest version remedy the issue? Thanks, -Mike -Original Message- From: Donald Tyler [mailto:[EMAIL PROTECTED] Sent: Friday, August 08, 2003 3:42 PM To: [EMAIL PROTECTED] Subject: RE: mysql LOAD DATA INFILE PHPMyAdmin uses the LOAD DATA LOCAL INFILE command. Just remove the word LOCAL and it should work fine. -Original Message- From: Mike At Spy [mailto:[EMAIL PROTECTED] Sent: Friday, August 08, 2003 2:35 PM To: [EMAIL PROTECTED] Subject: mysql LOAD DATA INFILE When I come across this error: The used command is not allowed with this MySQL version Does this mean that I need a whole different verison of MySQL, or just a different compile? The command was 'LOAD DATA INFILE' and I was doing it through phpMyAdmin. Thanks, -Mike -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED] -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED] -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED] -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: the logic of full text search
Sjef Janssen [EMAIL PROTECTED] wrote: No, there are just a few rows in my table, as I am still developing the program. Will it be better when the table is in regular use (and the number of rows will increase)? How many rows in the table? how many rows contain the search word? I am trying to understand the logic of full text search in mysql. I'm not using mysql 4. The search work OK, be it thast I get hits on certain words, whilst other words are discarded for some reason or other. Why is that. An example: I search in a text field for the word organisation. I get hits. When I search for the word scenario nothing is found. But I can see the word in the paragraphs by myself? Is there an explanation for this? AIUI, if a word occurs too many times (in more than x% of rows, I can't remember the logic used) then it's treated as a stop word. This means that words that appear in almost every row (like the, you etc) which would have no value to a search are ignored. I believe this is what's causing your problem. Do you have many records in the table you're doing a fulltext search on? IME it tends to work better with plenty of rows to work with. -- For technical support contracts, goto https://order.mysql.com/?ref=ensita This email is sponsored by Ensita.net http://www.ensita.net/ __ ___ ___ __ / |/ /_ __/ __/ __ \/ /Egor Egorov / /|_/ / // /\ \/ /_/ / /__ [EMAIL PROTECTED] /_/ /_/\_, /___/\___\_\___/ MySQL AB / Ensita.net ___/ www.mysql.com -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: timeout?
-BEGIN PGP SIGNED MESSAGE- Hash: SHA1 Maciej Bobrowski wrote: Hi, We have a java server connected to mysql v. 4.1.0. It connects and remains connected (it should). Some people work on it from about 7 a.m till about 3 p.m. In the morning when we come to work, we can see the link failure. It seems like after some hours (?) the mysql server disconnect any client if he was still connected and didn't do anything. Is there any variable which could define something like timeout or I should add something to the my.cnf? In previous mysql releases we didn't have such a problem.. Regards, Maciej Bobrowski Hi! Please read http://www.mysql.com/documentation/connector-j/index.html#id2802490 (the 'Troubleshooting' section of the manual, which is also included in the README that comes with the JDBC driver). It is not good practice to rely on database connections to 'stay connected' when developing multi-tier systems. The JDBC spec provides no guarantees for a connection to remain 'valid' and 'connected.'. Your code needs to have mechanisms for handling communications errors with the database (that's why exceptions were invented, and Sun made sure to specify that SQLExceptions have a lot of information in them via getSQLState() and getVendorErrorCode() so that your code can determine what is an appropriate action to take). Regards, -Mark - -- Mr. Mark Matthews MySQL AB, Software Development Manager, J2EE and Windows Platforms Office: +1 708 557 2388 www.mysql.com Are you MySQL Certified? http://www.mysql.com/certification/ -BEGIN PGP SIGNATURE- Version: GnuPG v1.2.1 (MingW32) Comment: Using GnuPG with Thunderbird - http://enigmail.mozdev.org iD8DBQE/MmaXtvXNTca6JD8RAoiaAJ94MNT+9TT4pLWY0cYDhilGh1tFRwCeP0e8 w6AIIqUvzngVVFUPZYqkVCg= =Zgzi -END PGP SIGNATURE- -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
order by rand()
Hey all... I did a quick check of the archives, but didn't see anything recent about this... I use PHP and mySQL, and am supposed to be able to randomize the order in which the rows are held when retrieved using ORDER BY RAND(). This isn't working for me... it's on a third-party server over which I have little control, but the params are as follows: php 4.0.3pl1, mysql 3.22.32. I've read of problems with this on Win32 systems, but this runs on linux using apache. Any assistance would be appreciated. Thank you, Marc -=-=-=-=- No testimony is sufficient to establish a miracle unless the testimony be of such a kind that its falsehood would be more miraculous than the fact which it endeavours to establish. - David Hume -=-=-=-=-
Re: Quick ones to speed up acces!
Thanks Roger for quick response. Herebelow the structure of my table and query. CREATE TABLE npg_search ( sno int(11) NOT NULL auto_increment, fileid varchar(255) NOT NULL, caption text, headline varchar(255), specialins varchar(255), keywords varchar(255) NOT NULL, cat varchar(50) NOT NULL, byline varchar(255), credit varchar(255), source varchar(255), date date, city varchar(100), state varchar(100), country varchar(100) NOT NULL, orgtransref varchar(100), copyright varchar(255), extratxt text, prints tinyint(4), extrastr varchar(255), bylinetitle varchar(255), addedon timestamp(14), PRIMARY KEY (sno), INDEX (fileid, keywords, cat, country)); As shown columns fileid,keywords,cat and country are indexed. Query is: Select * from table where keywords like '%blah%' or caption like '%blah%' or headline like '%blah%' or cat like '%blah%' Please help me out. Binay - Original Message - From: Roger Davis [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: Monday, August 11, 2003 4:57 PM Subject: RE: Quick ones to speed up acces! It's called indexing and your queries should return in under 1 sec unless you are pulling all your records and all your data. Show us your Queries and you table structure and I am sure we can help. Roger -Original Message- From: Binay Agarwal [mailto:[EMAIL PROTECTED] Sent: Sunday, August 10, 2003 7:08 PM To: [EMAIL PROTECTED] Subject: Quick ones to speed up acces! Hi everybody! I am querying from a table containing more than 40,000 records. Earlier when the records were 10,000 it was taking 9 sec and now after 1 year and 40,000 records its taking 30 sec. Code is the same. I am pretty sure that it has something to do with database only. No body can think of spending 30 secs for retrieving values from tables unless it's very huge in the sense of millions of records. I don know whether I have to modify my database or do some sort of restructuring or reindexing so as to make it fast enough. Is there some methods or optmization which can be applied to this database which hasn't been touched since design to enhance the spped. If there are some quick ones but valued alottt please let me know. Thanks in advance Binay --- Incoming mail is certified Virus Free. Checked by AVG anti-virus system (http://www.grisoft.com). Version: 6.0.507 / Virus Database: 304 - Release Date: 8/4/2003 --- Outgoing mail is certified Virus Free. Checked by AVG anti-virus system (http://www.grisoft.com). Version: 6.0.507 / Virus Database: 304 - Release Date: 8/4/2003 -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED] -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]