Root pass

2002-06-30 Thread Page Works Web Solutions

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




RE: Root pass

2002-06-30 Thread Peter Lovatt

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

2002-06-30 Thread MySQL server

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

2002-06-30 Thread Jeremy Zawodny

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...

2002-06-30 Thread Henry Hank


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

2002-06-30 Thread Gurhan Ozen

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 . . .

2002-06-30 Thread databarn

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 grin /.)

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?

2002-06-30 Thread Bhavin Vyas

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: mysql-return-number[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

 !DOCTYPE HTML PUBLIC -//W3C//DTD HTML 4.0 Transitional//EN
 HTMLHEAD
 META http-equiv=3DContent-Type content=3Dtext/html; =
 charset=3Diso-8859-1
 META content=3DMSHTML 5.50.4522.1800 name=3DGENERATOR
 STYLE/STYLE
 /HEAD
 BODY bgColor=3D#ff
 DIVnbsp;/DIV/BODY/HTML

 --=_NextPart_000_01EB_01C21F5D.FB47C700--



-
Before posting, please check:
   

RE: Load problems with 3.23.51

2002-06-30 Thread Steven Roussey

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/0

Re: Max_data_length question...

2002-06-30 Thread Bhavin Vyas

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

2002-06-30 Thread Hugo Veiga

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

2002-06-30 Thread Peter Engström

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

2002-06-30 Thread Craig Williams

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 . . .

2002-06-30 Thread César Aracena

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 grin /.)
 
 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 mysql-unsubscribe-
 [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

2002-06-30 Thread Bhavin Vyas

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 . . .

2002-06-30 Thread Peter Lovatt

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 grin /.)
 
  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 mysql-unsubscribe-
  [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?

2002-06-30 Thread David M. Karr

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

2002-06-30 Thread Blue Presley

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

2002-06-30 Thread Gurhan Ozen

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

2002-06-30 Thread Gurhan Ozen

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 . . .

2002-06-30 Thread databarn

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

2002-06-30 Thread Blue Presley

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 . . .

2002-06-30 Thread databarn

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

2002-06-30 Thread Peter Lovatt

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 br

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

2002-06-30 Thread Gurhan Ozen

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: text formatting

2002-06-30 Thread Peter Lovatt

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://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