RE: Root pass
Hi Not sure here, but you have logged in as 'admin' on the system. Unless you su to root mysql will use the same user. try either [admin admin]$ su -l to log in to the system as root and then 'mysql -p' to log into mysql or stay as admin but log into mysql as root, under mysql [admin admin]$ mysql -u root -p The clue is in the line ERROR 1044: Access denied for user: '@localhost' to database 'mysql' which would read 'root@localhost' if you were logged in as root HTH, if not come back to me Peter --- Excellence in internet and open source software --- Sunmaia www.sunmaia.net [EMAIL PROTECTED] tel. 0121-242-1473 --- > -Original Message- > From: Page Works Web Solutions [mailto:[EMAIL PROTECTED]] > Sent: 30 June 2002 08:14 > To: [EMAIL PROTECTED] > Subject: Root pass > > > Hi all, >Yet another 3am night and I still can't get my MySql to work. I > installed MySql on a cobalt Raq 4 server running Linux. I can telnet into > the mysql directory, but can not seem to change the root pass. I've > searched every place except the one that as the answer to my > question. What > am I doing wrong. Below is the session if you can help. > > > > [admin admin]$ mysql > Welcome to the MySQL monitor. Commands end with ; or \g. > Your MySQL connection id is 16 to server version: 3.23.37 > > Type 'help;' or '\h' for help. Type '\c' to clear the buffer > > mysql> show databases > -> ; > +--+ > | Database | > +--+ > | mysql| > | test | > +--+ > 2 rows in set (0.00 sec) > > mysql> use test; > Database changed > mysql> use mysql; > ERROR 1044: Access denied for user: '@localhost' to database 'mysql' > mysql> bin/mysqld -Skip-grant > -> USE mysql; > ERROR 1064: You have an error in your SQL syntax near > 'bin/mysqld -Skip-grant > USE mysql' at line 1 > > > > Thanks in advance for any help. :) > Shawn > > > - > 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 newbie is having troubles starting mysqld on a new installation of version 4.01
>Description: I think that when I installed mysql, I ran out of room on the /var file system >How-To-Repeat: bash-2.05$ /usr/sbin/mysqld --datadir=/home/mysql InnoDB: Error: data file ./ibdata1 is of different size InnoDB: than specified in the .cnf file! InnoDB: Could not open data files 020630 1:55:08 Can't init databases bash-2.05$ ls /home/mysql angel.err ibdata1 mysql mysql.sock test bash-2.05$ ls /home/mysql_safe --datadir=/home/mysql ls: unrecognized option `--datadir=/home/mysql' Try `ls --help' for more information. bash-2.05$ /usr/bin/mysql_safe --datadir=/home/mysql bash: /usr/bin/mysql_safe: No such file or directory bash-2.05$ /usr/bin/mysqld_safe --datadir=/home/mysql Starting mysqld daemon with databases from /home/mysql 020630 01:56:20 mysqld ended bash-2.05$ >Fix: The installation RPM should test that the filesystems have enough free space before beginning. Is there a switch to the RPM to force placement of the database on a different file system? >Submitter-Id: [EMAIL PROTECTED] >Originator:MySQL server >Organization: >MySQL support: none >Synopsis: mysqld won't start after installation >Severity: non-critical >Priority: low >Category: mysql >Class: change-request >Release: mysql-4.0.1-alpha (Official MySQL RPM) >Environment: Linux angel 2.4.7-10 #1 Thu Sep 6 17:21:28 EDT 2001 i586 unknown bash-2.05$ df -hl FilesystemSize Used Avail Use% Mounted on /dev/hda4 2.8G 1.6G 1.0G 60% / /dev/hda1 11M 2.7M 8.1M 25% /boot none 19M 0 18M 0% /dev/shm /dev/hda3 95M 70M 20M 78% /var /dev/hdb1 18G 13G 5.4G 70% /home /dev/cdrom595M 596M 0 100% /mnt/cdrom bash-2.05$ rpm -q redhat-release redhat-release-7.2-1 System: Linux angel 2.4.7-10 #1 Thu Sep 6 17:21:28 EDT 2001 i586 unknown Architecture: i586 Some paths: /usr/bin/perl /usr/bin/make /usr/bin/gmake /usr/bin/gcc /usr/bin/cc GCC: Reading specs from /usr/lib/gcc-lib/i386-redhat-linux/2.96/specs gcc version 2.96 2731 (Red Hat Linux 7.1 2.96-98) Compilation info: CC='gcc' CFLAGS='-O6 -fno-omit-frame-pointer -mpentium' CXX='gcc' CXXFLAGS='-O6 -fno-omit-frame-pointer -felide-constructors -fno-exceptions -fno-rtti -mpentium' LDFLAGS='' LIBC: lrwxrwxrwx1 root root 13 Dec 16 2001 /lib/libc.so.6 -> libc-2.2.4.so -rwxr-xr-x1 root root 5716491 Sep 4 2001 /lib/libc-2.2.4.so -rw-r--r--1 root root 27304836 Sep 4 2001 /usr/lib/libc.a -rw-r--r--1 root root 178 Sep 4 2001 /usr/lib/libc.so Configure command: ./configure --disable-shared --with-mysqld-ldflags=-all-static --with-client-ldflags=-all-static --without-berkeley-db --with-innodb --enable-assembler --with-mysqld-user=mysql --with-unix-socket-path=/var/lib/mysql/mysql.sock --prefix=/ --with-extra-charsets=complex --exec-prefix=/usr --libexecdir=/usr/sbin --sysconfdir=/etc --datadir=/usr/share --localstatedir=/var/lib/mysql --infodir=/usr/info --includedir=/usr/include --mandir=/usr/man --with-embedded-server --enable-thread-safe-client '--with-comment=Official MySQL RPM' - 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: Load problems with 3.23.51
On Sat, Jun 29, 2002 at 10:47:47PM -0700, Steven Roussey wrote: > > Tomorrow I'll try doing my own compile with gcc3.1. Note the other > guy that had the same problem that went away after he compiled it > himself: Even gcc 2.95.3 or .4 will work well based on what I've seen. We can still sustain > 1,000 qps during busy times with my custom-built binary. 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.51: up 31 days, processed 675,953,685 queries (249/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
Max_data_length question...
Hello, While looking at SHOW TABLE STATUS, I noticed that all my dynamic tables seem to have a Max_data_length of 4,294,967,295 bytes. Is this true - that any dynamic tables are limited to 4GB in size? My fixed tables do not show this problem, and report that their Max_data_length is 4+ billion records times their record length (as expected). I'm using mysql version 3.23.41 on Red Hat Linux 7.2. Thanks, -Hank __ Do You Yahoo!? Yahoo! - Official partner of 2002 FIFA World Cup http://fifaworldcup.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: Root pass
Hi shawn, You have probably have % in the user and host of the user table, so mysql client let you in without a username. To be able to use mysql database, you have to login as the root user. Just type, mysql -u root -p and see if you can login in that way. Besides, you have to restart mysqld from your unix shell prompt, you can't do it inside the mysql client .. I hope this helps, Gurhan - Original Message - From: "Page Works Web Solutions" <[EMAIL PROTECTED]> To: <[EMAIL PROTECTED]> Sent: Sunday, June 30, 2002 3:14 AM Subject: Root pass > Hi all, >Yet another 3am night and I still can't get my MySql to work. I > installed MySql on a cobalt Raq 4 server running Linux. I can telnet into > the mysql directory, but can not seem to change the root pass. I've > searched every place except the one that as the answer to my question. What > am I doing wrong. Below is the session if you can help. > > > > [admin admin]$ mysql > Welcome to the MySQL monitor. Commands end with ; or \g. > Your MySQL connection id is 16 to server version: 3.23.37 > > Type 'help;' or '\h' for help. Type '\c' to clear the buffer > > mysql> show databases > -> ; > +--+ > | Database | > +--+ > | mysql| > | test | > +--+ > 2 rows in set (0.00 sec) > > mysql> use test; > Database changed > mysql> use mysql; > ERROR 1044: Access denied for user: '@localhost' to database 'mysql' > mysql> bin/mysqld -Skip-grant > -> USE mysql; > ERROR 1064: You have an error in your SQL syntax near > 'bin/mysqld -Skip-grant > USE mysql' at line 1 > > > > Thanks in advance for any help. :) > Shawn > > > - > 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
Soliciting best approach for storing passwords . . .
Folk, I need some input on how best to store username/password combinations online. My preference would be to store a one-way encrypted value, but that is not possible in this situation. The constraint is that we have to make provision for giving the user's password back to the user after a "forgot my password" link has been clicked. (Oh, a secondary input would be on the best way to accomplish the password return to the user .) Normally, I store passwords as a one-way hash, then encrypt input to see if it matches, but I can't do that this time: I have to store a clear text or decryptable value. I've seen several approaches to this, but don't see any clear 'best practice'. Right now I'm leaning toward a multiple table design, but I have no real idea if this is a better model than a single table design. I'd really appreciate input from some of you who have wrestled with this problem before. If it matters, the development box is Win2K/IIS5, PHP 4.0.5, MySQL 3.23.32, and the implementation box is *nix/Apache 1.3.22, PHP 4.1.1, MySQL 3.23.47. I'd appreciate any suggestions for a best resolution. Thanks. Make a good day . . . . . . barn ~ If you're not confused, you're not paying attention ~ - 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 List bug?
Mysql list serve manager, Could this be a bug in the mysql listserv. Tedd Richards tried to unsubscribe and I am getting the confirmation e-mail to confirm that I really want to un-subscribe, when, I haven't emailed an unsubscribe request in the frist place. - Original Message - From: <[EMAIL PROTECTED]> To: <[EMAIL PROTECTED]> Sent: Saturday, June 29, 2002 8:04 AM Subject: confirm unsubscribe from [EMAIL PROTECTED] > Hi! This is the ezmlm program. I'm managing the > [EMAIL PROTECTED] mailing list. > > To confirm that you would like > >[EMAIL PROTECTED] > > removed from the mysql mailing list, please send an empty reply > to this address: > Usually, this happens when you just hit the "reply" button. > If this does not work, simply copy the address and paste it into > the "To:" field of a new message. > > I haven't checked whether your address is currently on the mailing list. > To see what address you used to subscribe, look at the messages you are > receiving from the mailing list. Each message has your address hidden > inside its return path; for example, [EMAIL PROTECTED] receives messages > with return path: [EMAIL PROTECTED] > > Some mail programs are broken and cannot handle long addresses. If you > cannot reply to this request, instead send a message to > <[EMAIL PROTECTED]> and put the entire address listed above > into the "Subject:" line. > > > --- Administrative commands for the mysql list --- > > I can handle administrative requests automatically. Please > do not send them to the list address! Instead, send > your message to the correct command address: > > To subscribe to the list, send a message to: ><[EMAIL PROTECTED]> > > To remove your address from the list, send a message to the address > in the "List-Unsubscribe" header of messages from the list. If you don't > know how to display headers and haven't changed E-mail addresses since > subscribing, you'll be successful with an e-mail to: ><[EMAIL PROTECTED]> > > Send mail to the following for info and FAQ for this list: ><[EMAIL PROTECTED]> ><[EMAIL PROTECTED]> > > Similar addresses exist for the digest list: ><[EMAIL PROTECTED]> ><[EMAIL PROTECTED]> > > To get messages 123 through 145 (a maximum of 100 per request), mail: ><[EMAIL PROTECTED]> > > To get an index with subject and author for messages 123-456 , mail: ><[EMAIL PROTECTED]> > > They are always returned as sets of 100, max 2000 per request, > so you'll actually get 100-499. > > To receive all messages with the same subject as message 12345, > send an empty message to: ><[EMAIL PROTECTED]> > > The messages do not really need to be empty, but I will ignore > their content. Only the ADDRESS you send to is important. > > You can start a subscription for an alternate address, > for example "[EMAIL PROTECTED]", just add a hyphen and your > address (with '=' instead of '@') after the command word: > <[EMAIL PROTECTED]> > > To stop subscription for this address, mail: > <[EMAIL PROTECTED]> > > In both cases, I'll send a confirmation message to that address. When > you receive it, simply reply to it to complete your subscription. > > If despite following these instructions, you do not get the > desired results, please contact my owner at > [EMAIL PROTECTED] Please be patient, my owner is a > lot slower than I am ;-) > > --- Enclosed is a copy of the request I received. > > Return-Path: <[EMAIL PROTECTED]> > Received: (qmail 25046 invoked from network); 29 Jun 2002 15:04:54 - > Received: from mtiwmhc22.worldnet.att.net (204.127.131.47) > by www.mysql.com with SMTP; 29 Jun 2002 15:04:54 - > Received: from dell866 ([12.77.147.176]) by mtiwmhc22.worldnet.att.net > (InterMail vM.4.01.03.27 201-229-121-127-20010626) with ESMTP > id <20020629151310.JATW20395.mtiwmhc22.worldnet.att.net@dell866> > for <[EMAIL PROTECTED]>; > Sat, 29 Jun 2002 15:13:10 + > Message-ID: <01ee01c21f7f$84589260$1300a8c0@dell866> > From: "Teddy" <[EMAIL PROTECTED]> > To: <[EMAIL PROTECTED]> > Subject: > Date: Sat, 29 Jun 2002 11:13:22 -0400 > MIME-Version: 1.0 > Content-Type: multipart/alternative; > boundary="=_NextPart_000_01EB_01C21F5D.FB47C700" > X-Priority: 3 > X-MSMail-Priority: Normal > X-Mailer: Microsoft Outlook Express 5.00.2919.6600 > X-MimeOLE: Produced By Microsoft MimeOLE V5.00.2919.6600 > > This is a multi-part message in MIME format. > > --=_NextPart_000_01EB_01C21F5D.FB47C700 > Content-Type: text/plain; > charset="iso-8859-1" > Content-Transfer-Encoding: quoted-printable > > > > --=_NextPart_000_01EB_01C21F5D.FB47C700 > Content-Type: text/html; > charset="iso-8859-1" > Content-Transfer-Encoding: quoted-printable > > > > charset=3Diso-8859-1"> > > > > > > > --=_NextPart_000_01EB_01C21F5D.FB47C700-- > - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/
RE: Load problems with 3.23.51
Results of Michael Bacarella's request (too big for dist list, so only Michael and Michael/Monty got the full reply, this is shortened for the list so a possible light bulb can go off): 3.23.51: > ps -eo pid,tt,user,fname,tmout,f,wchan PID TT USER COMMAND TMOUT F WCHAN 1 ?root init - 100 do_select 2 ?root keventd - 040 context_thread 3 ?root ksoftirq - 040 ksoftirqd 4 ?root ksoftirq - 040 - 5 ?root kswapd - 040 kswapd 6 ?root bdflush - 040 bdflush 7 ?root kupdated - 040 kupdate 8 ?root mdrecove - 040 md_thread 17 ?root kjournal - 040 end 92 ?root khubd- 040 end 192 ?root kjournal - 040 end 193 ?root kjournal - 040 end 685 ?root syslogd - 040 do_select 690 ?root klogd- 140 do_syslog 710 ?rpc portmap - 140 do_poll 738 ?rpcuser rpc.stat - 140 do_select 923 ?root xinetd - 140 do_select 963 ?root sendmail - 140 do_select 994 ?root crond- 040 nanosleep 1044 ?xfs xfs - 140 do_select 1080 ?daemon atd - 040 nanosleep 1112 ?root miniserv - 040 do_select 1117 tty2 root mingetty - 100 read_chan 1118 tty3 root mingetty - 100 read_chan 1119 tty4 root mingetty - 100 read_chan 1120 tty5 root mingetty - 100 read_chan 1121 tty6 root mingetty - 100 read_chan 1285 tty1 root mingetty - 100 read_chan 14125 ?root sshd - 140 do_select 409 ?root php - 000 inet_wait_for_connect 9097 ?root sshd - 140 - 9099 pts/0root bash - 100 wait4 9164 pts/0root safe_mys - 100 wait4 9192 pts/0mysqlmysqld - 100 - 9194 pts/0mysqlmysqld - 040 do_poll 9195 pts/0mysqlmysqld - 040 rt_sigsuspend 9196 pts/0mysqlmysqld - 040 - 9197 pts/0mysqlmysqld - 040 rt_sigsuspend 9198 pts/0mysqlmysqld - 040 rt_sigsuspend 9199 pts/0mysqlmysqld - 040 - 9200 pts/0mysqlmysqld - 040 - 9201 pts/0mysqlmysqld - 040 - 9202 pts/0mysqlmysqld - 040 - 9203 pts/0mysqlmysqld - 040 - 9204 pts/0mysqlmysqld - 040 rt_sigsuspend 9205 pts/0mysqlmysqld - 040 - 9206 pts/0mysqlmysqld - 040 - 9207 pts/0mysqlmysqld - 040 - 9208 pts/0mysqlmysqld - 040 rt_sigsuspend 9209 pts/0mysqlmysqld - 040 rt_sigsuspend 9210 pts/0mysqlmysqld - 040 - 9211 pts/0mysqlmysqld - 040 unix_stream_data_wait 9212 pts/0mysqlmysqld - 040 - 9213 pts/0mysqlmysqld - 040 - 9214 pts/0mysqlmysqld - 040 - 9215 pts/0mysqlmysqld - 040 tcp_data_wait 9216 pts/0mysqlmysqld - 040 - 9217 pts/0mysqlmysqld - 040 - 9218 pts/0mysqlmysqld - 040 rt_sigsuspend 9219 pts/0mysqlmysqld - 040 - 9220 pts/0mysqlmysqld - 040 - 9221 pts/0mysqlmysqld - 040 - 9222 pts/0mysqlmysqld - 040 - 9223 pts/0mysqlmysqld - 040 - 9224 pts/0mysqlmysqld - 040 - 9225 pts/0mysqlmysqld - 040 - 9226 pts/0mysqlmysqld - 040 - 9227 pts/0mysqlmysqld - 040 - 9228 pts/0mysqlmysqld - 040 - 9229 pts/0mysqlmysqld - 040 - 9230 pts/0mysqlmysqld - 040 - 9231 pts/0mysqlmysqld - 040 - 9232 pts/0mysqlmysqld - 040 - 9233 pts/0mysqlmysqld - 040 - 9234 pts/0mysqlmysqld - 040 - 9235 pts/0mysqlmysqld - 040 - 9236 pts/0mysqlmysqld - 040 - 9237 pts/0mysqlmysqld - 040 - 9238 pts/0mysqlmysqld - 040 - 9239 pts/0mysqlmysqld - 040 - 9240 pts/0mysqlmysqld - 040 - 9241 pts/0mysqlmysqld - 040 - 9242 pts/0mysqlmysqld - 040 - 9243 pts/0mysqlmysqld - 040 - 9244 pts/0mysqlmysqld - 040 - 9245 pts/0mysqlmysqld - 040 - 9247 pts/0mysqlmysqld - 040 - 9248 pts/0mysqlmysqld - 040 - 9249 pts/0mysqlmysqld - 040 - 9250 pts/0mysqlmysqld - 040 tcp_data_wait 9251 pts/0mysqlmysqld - 040 tcp_data_wait 9252 pts/0mysqlmysqld - 040 - 9254 pts/0mysqlmysqld - 040 - 9255 pts/0mysqlmysqld - 040 - 9256 pts/0mysqlmysqld - 040 - 9258 pts/0mysqlmysqld - 040 - 9259 pts/0m
Re: Max_data_length question...
The default at table creation is 4GB. You can change the default vaule via an ALTER TABLE. You will need to alter AVG_ROW_LENGTH and MAX_ROWS. MAX_DATA_LENGTH is the product of the two. http://www.mysql.com/doc/T/a/Table_size.html Regards, Bhavin. - Original Message - From: "Henry Hank" <[EMAIL PROTECTED]> To: "mysql mailing list" <[EMAIL PROTECTED]> Sent: Sunday, June 30, 2002 7:05 AM Subject: Max_data_length question... > > Hello, > > While looking at SHOW TABLE STATUS, I noticed that all my dynamic tables seem > to have a Max_data_length of 4,294,967,295 bytes. Is this true - that any > dynamic tables are limited to 4GB in size? My fixed tables do not show this > problem, and report that their Max_data_length is 4+ billion records times > their record length (as expected). I'm using mysql version 3.23.41 on Red Hat > Linux 7.2. > > Thanks, > -Hank > > > > > __ > Do You Yahoo!? > Yahoo! - Official partner of 2002 FIFA World Cup > http://fifaworldcup.yahoo.com > > - > Before posting, please check: >http://www.mysql.com/manual.php (the manual) >http://lists.mysql.com/ (the list archive) > > To request this thread, e-mail <[EMAIL PROTECTED]> > To unsubscribe, e-mail <[EMAIL PROTECTED]> > Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php > - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
need you expertise
Hi again, first of all thx for the precious help given to me. Well it seems i have problems again. Everytime i try to access "mysql" it returns: "ERROR 1045: Access denied for user:'hasv@localhost' (Using password: NO)" How can i put it to work? Any clue? I'm new to this so i apollogize if this is a very basci thing. Thxs in advance Hugo Veiga - 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
SQL - Fulltext search
Hi! I have a table called 'candidate_skill' id (autoincrement) candidateID (link to candidate), skill (tinytext) Query: SELECT * FROM candidate_skill WHERE candidateID='2' Result: 134 | 2 | Powerpoint 223 | 2 | PHP 313 | 2 | Lotus Notes Is it possible to do a fulltext search. I want to search for skills. Something like this: +php +powerpoint ...and then get a list of all candidates that have php and powerpoint as a skill. Is there a way to do this? Best regards /Peter - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
storing various files in mysql
I need to store small files in mySql. Some are binary and some are not, can they be stored the same way ? eg: Read them in as binary and store them in a blob ? I can't figure out how to store binary data in mySql using ADODB, c# ? I read in the binary data as a byte array. I then convert that to a string and insert it into mySql in the normal fashion. mySql complains about this ? can anyone help ? thanks Craig - 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: Soliciting best approach for storing passwords . . .
Barn. I asked the same question couple of weeks ago and all the answers I got pointed to one way encryption. Actually, I had the same need that you, but understood that it was better to reset the password when a "Forgot password" was made, send it to the user and ask them to change the password at the next login. I suppose you have the same problem that I had... few users who would get angry if such thing is asked to do. But then I realize that if I used a very common "words" list to generate random passwords, they might even learn that password without changing it. After all the responses I've get regarding this issue, I never got the answer to how do a two way encrypting so, if this doesn't help you... > -Original Message- > From: databarn [mailto:[EMAIL PROTECTED]] > Sent: Sunday, June 30, 2002 10:36 AM > To: MySQL > Subject: Soliciting best approach for storing passwords . . . > > Folk, > I need some input on how best to store username/password combinations > online. My preference would be to store a one-way encrypted value, but > that is not possible in this situation. The constraint is that we have to > make provision for giving the user's password back to the user after a > "forgot my password" link has been clicked. > > (Oh, a secondary input would be on the best way to accomplish the password > return to the user .) > > Normally, I store passwords as a one-way hash, then encrypt input to see > if it matches, but I can't do that this time: I have to store a clear > text or decryptable value. I've seen several approaches to this, but > don't see any clear 'best practice'. Right now I'm leaning toward a > multiple table design, but I have no real idea if this is a better model > than a single table design. I'd really appreciate input from some of you > who have wrestled with this problem before. > > If it matters, the development box is Win2K/IIS5, PHP 4.0.5, MySQL > 3.23.32, and the implementation box is *nix/Apache 1.3.22, PHP 4.1.1, > MySQL 3.23.47. > > I'd appreciate any suggestions for a best resolution. Thanks. > > > > Make a good day . . . > . . . barn > ~ > If you're not confused, you're not paying attention > ~ > > > > - > 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: need you expertise
you will need to give it the password flag and then type in the password when prompted for one. mysql -u hasv -p Regards, Bhavin. - Original Message - From: "Hugo Veiga" <[EMAIL PROTECTED]> To: <[EMAIL PROTECTED]> Sent: Sunday, June 30, 2002 9:54 AM Subject: need you expertise > Hi again, > > first of all thx for the precious help given to me. > > Well it seems i have problems again. > Everytime i try to access "mysql" it returns: > "ERROR 1045: Access denied for user:'hasv@localhost' (Using password: > NO)" > > How can i put it to work? Any clue? I'm new to this so i apollogize if > this is a very basci thing. > > Thxs in advance > > Hugo Veiga > > > > > - > 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: Soliciting best approach for storing passwords . . .
Hi Just to throw another thought in If you do change the password and send it to them, you have to allow for the fact that their email could have changed - left work, service provider went bust etc etc, or somebody could just enter their email for a joke 8*} and get their password reset. I have seen systems where old and new passwords work until you confirm the new one, which is a halfway house, but more programming. The fact is that security is difficult, not technically, but from a human perspective. People are a security risk and educating users in proper security is the best answer, though a lost cause sometimes :) regarding two way encryption see http://www.mysql.com/doc/M/i/Miscellaneous_functions.html and ENCODE(str,pass_str) BFN Peter --- Excellence in internet and open source software --- Sunmaia www.sunmaia.net [EMAIL PROTECTED] tel. 0121-242-1473 --- > -Original Message- > From: César Aracena [mailto:[EMAIL PROTECTED]] > Sent: 30 June 2002 21:42 > To: 'databarn'; 'MySQL' > Subject: RE: Soliciting best approach for storing passwords . . . > > > Barn. > > I asked the same question couple of weeks ago and all the answers I got > pointed to one way encryption. Actually, I had the same need that you, > but understood that it was better to reset the password when a "Forgot > password" was made, send it to the user and ask them to change the > password at the next login. > > I suppose you have the same problem that I had... few users who would > get angry if such thing is asked to do. But then I realize that if I > used a very common "words" list to generate random passwords, they might > even learn that password without changing it. > > After all the responses I've get regarding this issue, I never got the > answer to how do a two way encrypting so, if this doesn't help you... > > > -Original Message- > > From: databarn [mailto:[EMAIL PROTECTED]] > > Sent: Sunday, June 30, 2002 10:36 AM > > To: MySQL > > Subject: Soliciting best approach for storing passwords . . . > > > > Folk, > > I need some input on how best to store username/password combinations > > online. My preference would be to store a one-way encrypted value, > but > > that is not possible in this situation. The constraint is that we > have to > > make provision for giving the user's password back to the user after a > > "forgot my password" link has been clicked. > > > > (Oh, a secondary input would be on the best way to accomplish the > password > > return to the user .) > > > > Normally, I store passwords as a one-way hash, then encrypt input to > see > > if it matches, but I can't do that this time: I have to store a clear > > text or decryptable value. I've seen several approaches to this, but > > don't see any clear 'best practice'. Right now I'm leaning toward a > > multiple table design, but I have no real idea if this is a better > model > > than a single table design. I'd really appreciate input from some of > you > > who have wrestled with this problem before. > > > > If it matters, the development box is Win2K/IIS5, PHP 4.0.5, MySQL > > 3.23.32, and the implementation box is *nix/Apache 1.3.22, PHP 4.1.1, > > MySQL 3.23.47. > > > > I'd appreciate any suggestions for a best resolution. Thanks. > > > > > > > > Make a good day . . . > > . . . barn > > ~ > > If you're not confused, you're not paying attention > > ~ > > > > > > > > - > > 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
high level: enabling transactions in mysql-max with WebLogic TX datasource?
One thing that I find a little confusing is the notion of transactional behavior in mySQL. I read that it's possible to enable transactions in mySQL-max, however, it's never really been clear to me exactly what I'm supposed to do, or whether I have to do anything. If I'm using a transactional datasource in WebLogic, on top of mySQL, I need to make sure mySQL supports that transactional behavior. Is there a section of the mySQL documentation, or some other documentation, which explains these issues clearly? -- === David M. Karr ; Java/J2EE/XML/Unix/C++ [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
text formatting
hello, I have a web from that allows a user to submit a resume in text format. How do i make mysql respect the formatting of the text document so that it is pulled from the database as it was inserted? right now everything comes back as one paragraph. thanks, blue - 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: need you expertise
Hi, If you are sure that the user hasv exists in mysql, then either type mysql -u hasv -p so that the mysql client will prompt you for a password, or in your home directory, create my.cnf file and type [client] password=yourpassword Gurhan - Original Message - From: "Hugo Veiga" <[EMAIL PROTECTED]> To: <[EMAIL PROTECTED]> Sent: Sunday, June 30, 2002 12:54 PM Subject: need you expertise > Hi again, > > first of all thx for the precious help given to me. > > Well it seems i have problems again. > Everytime i try to access "mysql" it returns: > "ERROR 1045: Access denied for user:'hasv@localhost' (Using password: > NO)" > > How can i put it to work? Any clue? I'm new to this so i apollogize if > this is a very basci thing. > > Thxs in advance > > Hugo Veiga > > > > > - > 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: text formatting
This should be handled before the data is even inserted into mysql. Have your scripting language that you use in the form handle this to have the resume formatted in the way you'd like and then have it insert the data into mysql. Gurhan - Original Message - From: "Blue Presley" <[EMAIL PROTECTED]> To: <[EMAIL PROTECTED]> Sent: Sunday, June 30, 2002 5:34 PM Subject: text formatting > hello, > I have a web from that allows a user to submit a resume in text format. How > do i make mysql respect the formatting of the text document so that it is > pulled from the database as it was inserted? right now everything comes > back as one paragraph. > > thanks, > blue > > > - > 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: Soliciting best approach for storing passwords . . .
Thanks, César, But this is not an option that is negotiable for me. The client mandate is very clear, and the reason behind it has a strong business case from their standpoint. I'm not about to get them to change their minds . . . they and I have been over this way too many times already. Make a good day . . . . . . barn ~ It is my ambition to say in ten sentences what others say in a whole book. - Friedrich Nietzsche ~ (sql, query) > I asked the same question couple of weeks ago and all the answers I got > pointed to one way encryption. Actually, I had the same need that you, > but understood that it was better to reset the password when a "Forgot > password" was made, send it to the user and ask them to change the > password at the next login. . . . > After all the responses I've get regarding this issue, I never got the > answer to how do a two way encrypting so, if this doesn't help you... - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: text formatting
I'm using (and new to) PHP. any suggestions as to what functions, if any exist, that would be appropriate for pre-formatting? thx, blue - Original Message - From: "Gurhan Ozen" <[EMAIL PROTECTED]> To: "Blue Presley" <[EMAIL PROTECTED]>; <[EMAIL PROTECTED]> Sent: Sunday, June 30, 2002 6:02 PM Subject: Re: text formatting > This should be handled before the data is even inserted into mysql. Have > your scripting language that you use in the form handle this to have the > resume formatted in the way you'd like and then have it insert the data into > mysql. > Gurhan > > - Original Message - > From: "Blue Presley" <[EMAIL PROTECTED]> > To: <[EMAIL PROTECTED]> > Sent: Sunday, June 30, 2002 5:34 PM > Subject: text formatting > > > > hello, > > I have a web from that allows a user to submit a resume in text format. > How > > do i make mysql respect the formatting of the text document so that it is > > pulled from the database as it was inserted? right now everything comes > > back as one paragraph. > > > > thanks, > > blue > > > > > > - > > 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: Soliciting best approach for storing passwords . . .
Thanks, Peter, Yeah, I had looked at ENCODE()/DECODE() and ABS_ENCRYPT()/ABS_DECRYPT() as possible tools, as well as some inherent PHP functionality. My real question is more about database design than about the mechanics of encryption. But I do appreciate the feedback. Make a good day . . . . . . barn ~ Save a tree. Eat a beaver. ~ (sql, query) > regarding two way encryption see > > http://www.mysql.com/doc/M/i/Miscellaneous_functions.html > > and > > ENCODE(str,pass_str) > - 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: text formatting
I haven't seen the rest of the thread, but form data looses all formatting. Line breaks will remain but HTML ignores them look at nl2br() to convert them to HTH Peter --- Excellence in internet and open source software --- Sunmaia www.sunmaia.net [EMAIL PROTECTED] tel. 0121-242-1473 --- > -Original Message- > From: Blue Presley [mailto:[EMAIL PROTECTED]] > Sent: 30 June 2002 23:31 > To: [EMAIL PROTECTED] > Subject: Re: text formatting > > > I'm using (and new to) PHP. any suggestions as to what functions, if any > exist, that would be appropriate for pre-formatting? > > thx, > blue > - Original Message - > From: "Gurhan Ozen" <[EMAIL PROTECTED]> > To: "Blue Presley" <[EMAIL PROTECTED]>; <[EMAIL PROTECTED]> > Sent: Sunday, June 30, 2002 6:02 PM > Subject: Re: text formatting > > > > This should be handled before the data is even inserted into mysql. Have > > your scripting language that you use in the form handle this to have the > > resume formatted in the way you'd like and then have it insert the data > into > > mysql. > > Gurhan > > > > - Original Message - > > From: "Blue Presley" <[EMAIL PROTECTED]> > > To: <[EMAIL PROTECTED]> > > Sent: Sunday, June 30, 2002 5:34 PM > > Subject: text formatting > > > > > > > hello, > > > I have a web from that allows a user to submit a resume in > text format. > > How > > > do i make mysql respect the formatting of the text document so that it > is > > > pulled from the database as it was inserted? right now > everything comes > > > back as one paragraph. > > > > > > thanks, > > > blue > > > > > > > > > - > > > 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 > - 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: text formatting
Hi, Yes there are number of functions you can use in php. I don't know what you really want to do, i assume that you want the resumes viewed over the web, in that case you can use nl2br() function to indicate a new line.. Take a look at the following pages: http://www.php.net/manual/en/ref.strings.php http://www.php.net/manual/en/ref.regex.php Gurhan - Original Message - From: "Blue Presley" <[EMAIL PROTECTED]> To: <[EMAIL PROTECTED]> Sent: Sunday, June 30, 2002 6:31 PM Subject: Re: text formatting > I'm using (and new to) PHP. any suggestions as to what functions, if any > exist, that would be appropriate for pre-formatting? > > thx, > blue > - Original Message - > From: "Gurhan Ozen" <[EMAIL PROTECTED]> > To: "Blue Presley" <[EMAIL PROTECTED]>; <[EMAIL PROTECTED]> > Sent: Sunday, June 30, 2002 6:02 PM > Subject: Re: text formatting > > > > This should be handled before the data is even inserted into mysql. Have > > your scripting language that you use in the form handle this to have the > > resume formatted in the way you'd like and then have it insert the data > into > > mysql. > > Gurhan > > > > - Original Message - > > From: "Blue Presley" <[EMAIL PROTECTED]> > > To: <[EMAIL PROTECTED]> > > Sent: Sunday, June 30, 2002 5:34 PM > > Subject: text formatting > > > > > > > hello, > > > I have a web from that allows a user to submit a resume in text format. > > How > > > do i make mysql respect the formatting of the text document so that it > is > > > pulled from the database as it was inserted? right now everything comes > > > back as one paragraph. > > > > > > thanks, > > > blue > > > > > > > > > - > > > 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 > - 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: need your attn: can mysql support japanese and korean simultaneously in same database
> > hello everyone > i am working on a project in which db is mysql and it should support > japanese and korean simultaneously I have mysql 3.23.36 running on > red_hat_linux_7.1_sea-wolf and default ecoding for mysql is sjis > > Kindly tell meif is it possible to make a database support japanese and > korean both languages simultaneously I don't really know much, but from what I understand, the answer to your question is probably not. If you want to sort and collate both at the same time, in the same tables, you'll need the Unicode support that is scheduled for ver. 4.1. You can store both at the same time. (You may have some problems with the drivers, but it appears that those problems can be fixed or worked around.) You can also search, if you don't care about missing a few sometimes, or if you can write a little external code to pick up some oddball cases. Or, you might consider keeping the Japanese and Korean data in separate tables on separate servers. From what I understand, that should be possible. > if you can sugest any other package or addin for this, that would > also be > helpful ??? > -- Joel Rees <[EMAIL PROTECTED]> - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: text formatting
Thanks guys, nl2br works perfectly for preserving my new lines! I've checked over the php string function list and am still experimenting with some options. However, do you know of any function that will preserve tabs and spacing (used for centering text, etc) in case your wondering, i'm letting people submit their resumes to a mysql database. it has to be in text format so that they can be properly searched. if anyone knows of a better way to do this (ie, using .pdf files) and still enabling them to be searched, plz let me know. thx blue - Original Message - From: "Gurhan Ozen" <[EMAIL PROTECTED]> To: "Blue Presley" <[EMAIL PROTECTED]>; <[EMAIL PROTECTED]> Sent: Sunday, June 30, 2002 7:35 PM Subject: Re: text formatting > Hi, > Yes there are number of functions you can use in php. I don't know what you > really want to do, i assume that you want the resumes viewed over the web, > in that case you can use nl2br() function to indicate a new line.. > Take a look at the following pages: > http://www.php.net/manual/en/ref.strings.php > http://www.php.net/manual/en/ref.regex.php > > Gurhan > > - Original Message - > From: "Blue Presley" <[EMAIL PROTECTED]> > To: <[EMAIL PROTECTED]> > Sent: Sunday, June 30, 2002 6:31 PM > Subject: Re: text formatting > > > > I'm using (and new to) PHP. any suggestions as to what functions, if any > > exist, that would be appropriate for pre-formatting? > > > > thx, > > blue > > - Original Message - > > From: "Gurhan Ozen" <[EMAIL PROTECTED]> > > To: "Blue Presley" <[EMAIL PROTECTED]>; <[EMAIL PROTECTED]> > > Sent: Sunday, June 30, 2002 6:02 PM > > Subject: Re: text formatting > > > > > > > This should be handled before the data is even inserted into mysql. Have > > > your scripting language that you use in the form handle this to have the > > > resume formatted in the way you'd like and then have it insert the data > > into > > > mysql. > > > Gurhan > > > > > > - Original Message - > > > From: "Blue Presley" <[EMAIL PROTECTED]> > > > To: <[EMAIL PROTECTED]> > > > Sent: Sunday, June 30, 2002 5:34 PM > > > Subject: text formatting > > > > > > > > > > hello, > > > > I have a web from that allows a user to submit a resume in text > format. > > > How > > > > do i make mysql respect the formatting of the text document so that it > > is > > > > pulled from the database as it was inserted? right now everything > comes > > > > back as one paragraph. > > > > > > > > thanks, > > > > blue > > > > > > > > > > > > - > > > > 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 > > > > > - > 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: Increasing number of open_files
Hi Jeremy, Here's the deal -- I let the MySQL number of open file handles default to MySQL's default setting. I also let the linux "max file handles" setting default... I started getting Error 24 (too many open files--from linux) when issuing queries, which rendered MySQL useless and caused "bad" things to happen to my application. I increased the linux and MySQL max open files to 64K (didn't touch "table_cache"). I then proceeded to sweat as I watched the number of MySQL open file handles grow... I think that I've misunderstood the "tabke_cache" AND the "open_files_limit" variables. The first reply from someone on this list gave me the answer (but I initially didn't understand) "the number of open file handles will grow to open_files_limit". Simple right? Unfortunately, by setting the MySQL open_files_limit to be equal to the linux max open files limit, I was setting myself up for another Error 24 situation. I've decreased the setting for MySQL "open_files_limit"... I have "table_cache" set to 1024. Thanks (to you and others that have replied) for the assistance... Sam -Original Message- From: Jeremy Cole [mailto:[EMAIL PROTECTED]] Sent: Sunday, June 30, 2002 8:42 PM To: Sam Taylor Cc: MySQL Mailing List Subject: Re: Increasing number of open_files Hi Sam, > I'm running a Java (JSP/Servlets/mmJDBC) web application that is using > MySQL, and over the course of a few days I see the number of open files > increasing... after 4 days of usage the number was at 17,000+. What is > typical for MySQL? What are other people seeing for "open_files"? This sounds like you have misunderstood the variable ``table_cache'' and set it way too high. The ``table_cache'' variable is a number of tables, not bytes or kilobytes or anything else. What have you set it's value to? By default it's 64, and most people need not raise it higher than perhaps 1024 or 2048. Regards, Jeremy -- MySQL Training in San Francisco! Visit http://www.mysql.com/training/ __ ___ ___ __ / |/ /_ __/ __/ __ \/ /Mr. Jeremy Cole <[EMAIL PROTECTED]> / /|_/ / // /\ \/ /_/ / /__ MySQL AB, Senior Trainer and Consultant /_/ /_/\_, /___/\___\_\___/ Clarksville, Tennessee USA <___/ 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: text formatting
Hi Try eregreplace(tab, 4 spaces) Peter --- Excellence in internet and open source software --- Sunmaia www.sunmaia.net [EMAIL PROTECTED] tel. 0121-242-1473 --- > -Original Message- > From: Blue Presley [mailto:[EMAIL PROTECTED]] > Sent: 01 July 2002 02:33 > To: [EMAIL PROTECTED] > Subject: Re: text formatting > > > Thanks guys, nl2br works perfectly for preserving my new lines! I've > checked over the php string function list and am still experimenting with > some options. However, do you know of any function that will > preserve tabs > and spacing (used for centering text, etc) > > > in case your wondering, i'm letting people submit their resumes to a mysql > database. it has to be in text format so that they can be properly > searched. if anyone knows of a better way to do this (ie, using > .pdf files) > and still enabling them to be searched, plz let me know. > > thx > blue > - Original Message - > From: "Gurhan Ozen" <[EMAIL PROTECTED]> > To: "Blue Presley" <[EMAIL PROTECTED]>; <[EMAIL PROTECTED]> > Sent: Sunday, June 30, 2002 7:35 PM > Subject: Re: text formatting > > > > Hi, > > Yes there are number of functions you can use in php. I don't know what > you > > really want to do, i assume that you want the resumes viewed > over the web, > > in that case you can use nl2br() function to indicate a new line.. > > Take a look at the following pages: > > http://www.php.net/manual/en/ref.strings.php > > http://www.php.net/manual/en/ref.regex.php > > > > Gurhan > > > > - Original Message - > > From: "Blue Presley" <[EMAIL PROTECTED]> > > To: <[EMAIL PROTECTED]> > > Sent: Sunday, June 30, 2002 6:31 PM > > Subject: Re: text formatting > > > > > > > I'm using (and new to) PHP. any suggestions as to what functions, if > any > > > exist, that would be appropriate for pre-formatting? > > > > > > thx, > > > blue > > > - Original Message - > > > From: "Gurhan Ozen" <[EMAIL PROTECTED]> > > > To: "Blue Presley" <[EMAIL PROTECTED]>; <[EMAIL PROTECTED]> > > > Sent: Sunday, June 30, 2002 6:02 PM > > > Subject: Re: text formatting > > > > > > > > > > This should be handled before the data is even inserted into mysql. > Have > > > > your scripting language that you use in the form handle this to have > the > > > > resume formatted in the way you'd like and then have it insert the > data > > > into > > > > mysql. > > > > Gurhan > > > > > > > > - Original Message - > > > > From: "Blue Presley" <[EMAIL PROTECTED]> > > > > To: <[EMAIL PROTECTED]> > > > > Sent: Sunday, June 30, 2002 5:34 PM > > > > Subject: text formatting > > > > > > > > > > > > > hello, > > > > > I have a web from that allows a user to submit a resume in text > > format. > > > > How > > > > > do i make mysql respect the formatting of the text > document so that > it > > > is > > > > > pulled from the database as it was inserted? right now everything > > comes > > > > > back as one paragraph. > > > > > > > > > > thanks, > > > > > blue > > > > > > > > > > > > > > > > - > > > > > 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 > > > > > - > 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:/
MAX vs plain vanilla mysql
Hi Probably a stupid question, but which is best to have on ones server, the "old" mysql, or max. I.O.W, if you install MAX and never use innodb or berkeley tables, will it be equivalent to a normal mysql installation wrt performance and stability? I'm asking from an ISP's point of view, if that makes any difference ( obviously if from developer it will depend on the needs of the app..) 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
Mysql vs MySQL max
Hi Probably a stupid question, but which is best to have on ones server, the "old" mysql, or max. I.O.W, if you install MAX and never use innodb or berkeley tables, will it be equivalent to a normal mysql installation wrt performance and stability? I'm asking from an ISP's point of view, if that makes any difference ( obviously if from developer it will depend on the needs of the app..) Thanks sql, 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
Mysql 4.0
Hi All In MySql 3.23.51 , i was able to add values into the child table I have created a table parent and also another table child where parentid column in child is a foreign key to the id column in parent table It was possible that i have no entries in parent table , and i was able to insert null values for parentid in child table.. This was a feature in 3.23.51 whereas this was not available in 3.23.49 When i tried MySQL 4.0.1 , i was shocked to see that i was not able to insert null values in the child table which was supported in 3.23.51 Any ideas -Arul sql,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: SQL - Fulltext search
I would use WHERE skill LIKE "%powerpoint%" OR skill LIKE "%PHP%" but that is because I don't know the better way, which must be there, I feel it .. anybody? -- Alle door mij verzonden email is careware. Dit houdt in dat het alleen herlezen en bewaard mag worden als je goed omgaat met al het leven op aarde en daar buiten. Als je het hier niet mee eens bent dien je mijn mailtje binnen 24 uur terug te sturen, met opgaaf van reden van onenigheid. All email sent by me is careware. This means that it can only be reread and kept if you are good for all the life here on earth and beyond. If you don't agree to these terms, you should return this email in no more than 24 hours stating the reason of disagreement. -Oorspronkelijk bericht- Van: Peter Engström [mailto:[EMAIL PROTECTED]] Verzonden: zondag 30 juni 2002 20:32 Aan: [EMAIL PROTECTED] Onderwerp: SQL - Fulltext search Hi! I have a table called 'candidate_skill' id (autoincrement) candidateID (link to candidate), skill (tinytext) Query: SELECT * FROM candidate_skill WHERE candidateID='2' Result: 134 | 2 | Powerpoint 223 | 2 | PHP 313 | 2 | Lotus Notes Is it possible to do a fulltext search. I want to search for skills. Something like this: +php +powerpoint ...and then get a list of all candidates that have php and powerpoint as a skill. Is there a way to do this? Best regards /Peter - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php - 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: SQL - Fulltext search
Pada Mon, 1 Jul 2002 09:01:13 +0200 "Wouter van Vliet" <[EMAIL PROTECTED]> menulis : > I would use > > WHERE skill LIKE "%powerpoint%" OR skill LIKE "%PHP%" > where skill REGEXP "powerpoint" or skill REGEXP "php" -- #ifdef STUPIDLY_TRUST_BROKEN_PCMD_ENA_BIT 2.4.0-test2 /usr/src/linux/drivers/ide/cmd640.c sql,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
