synopsis of the problem (one line)
Description: How-To-Repeat: Fix: Submitter-Id: submitter ID Originator:root Organization: MySQL support: [none | licence | email support | extended email support ] Synopsis: Severity: Priority: Category: mysql Class: Release: mysql-3.23.58 (Source distribution) Environment: System: Linux pluto.shellhost.info 2.4.27-0.3um #1 Thu Sep 2 11:39:16 GMT 2004 i686 i686 i386 GNU/Linux Architecture: i686 Some paths: /usr/local/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/3.2.2/specs Configured with: ../configure --prefix=/usr --mandir=/usr/share/man --infodir=/usr/share/info --enable-shared --enable-threads=posix --disable-checking --with-system-zlib --enable-__cxa_atexit --host=i386-redhat-linux Thread model: posix gcc version 3.2.2 20030222 (Red Hat Linux 3.2.2-5) Compilation info: CC='i386-redhat-linux-gcc' CFLAGS='-O2 -g -pipe -march=i386 -mcpu=i686 -D_GNU_SOURCE -D_FILE_OFFSET_BITS=64 -D_LARGEFILE_SOURCE' CXX='i386-redhat-linux-g++' CXXFLAGS='-O2 -g -pipe -march=i386 -mcpu=i686 -D_GNU_SOURCE -D_FILE_OFFSET_BITS=64 -D_LARGEFILE_SOURCE -fno-rtti -fno-exceptions' LDFLAGS='' LIBC: lrwxrwxrwx1 root root 13 Oct 2 05:35 /lib/libc.so.6 - libc-2.3.2.so -rwxr-xr-x1 root root 1561228 Nov 13 2003 /lib/libc-2.3.2.so -rw-r--r--1 root root 2332200 Nov 13 2003 /usr/lib/libc.a -rw-r--r--1 root root 204 Nov 12 2003 /usr/lib/libc.so lrwxrwxrwx1 root root 10 Nov 30 2003 /usr/lib/libc-client.a - c-client.a Configure command: ./configure '--host=i386-redhat-linux' '--build=i386-redhat-linux' '--target=i386-redhat-linux-gnu' '--program-prefix=' '--prefix=/usr' '--exec-prefix=/usr' '--bindir=/usr/bin' '--sbindir=/usr/sbin' '--sysconfdir=/etc' '--datadir=/usr/share' '--includedir=/usr/include' '--libdir=/usr/lib' '--libexecdir=/usr/libexec' '--localstatedir=/var' '--sharedstatedir=/usr/com' '--mandir=/usr/share/man' '--infodir=/usr/share/info' '--without-readline' '--without-debug' '--enable-shared' '--with-extra-charsets=complex' '--with-bench' '--localstatedir=/var/lib/mysql' '--with-unix-socket-path=/var/lib/mysql/mysql.sock' '--with-mysqld-user=mysql' '--with-extra-charsets=all' '--with-innodb' '--enable-local-infile' '--enable-large-files=yes' '--enable-largefile=yes' '--with-berkeley-db-includes=/usr/include' '--with-berkeley-db-libs=/usr/lib' '--enable-thread-safe-client' 'CFLAGS=-O2 -g -pipe -march=i386 -mcpu=i686 -D_GNU_SOURCE -D_FILE_OFFSET_BITS=64 -D_LARGEFILE_SOURCE' 'CXXFLAGS=-O2 -g -pipe -march=i386 -mcpu=i686 -D_GNU_SOURCE -D_FILE_OFFSET_BITS=64 -D_LARGEFILE_SOURCE -fno-rtti -fno-exceptions' 'build_alias=i386-redhat-linux' 'host_alias=i386-redhat-linux' 'target_alias=i386-redhat-linux-gnu' -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
filed that does not contain text between symbols
Hi, I have some web pages in a database and I want to check to make sure that all of the images have alt tags in them. So what I need to do is ask something like this in psuedocode: select page_name from web_pages where page_body does not contain 'alt=' between 'img' and ''; But I just can't figure out the right syntax. Any ideas? Thanks, bob -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: mysql_fix_privilege_tables again
On Sat, Oct 02, 2004 at 08:25:49PM -0500, Paul DuBois wrote: At 16:31 -0600 10/2/04, Dave Shariff Yadallee - System Administrator a.k.a. The Root wrote: New error WITH password implemented: Apparently the ownership of the mysql database and/or the files in it is not set such that the files are accessible to the Unix account that you're using to run mysqld. For example, perhaps you're running the server as the mysql login user, but the files are owned by root. That's a common problem. Here is an ls -Fail or the mysql directory and the one above it: Script started on Sun Oct 3 06:06:54 2004 doctor.nl2k.ab.ca//usr/contrib/var/mysql$ ls -Fail total 160 7301121 drwx-- 2 mysql wheel 512 Oct 3 06:06 ./ 5904388 drwxr-xr-x 77 root wheel 2048 Oct 2 16:11 ../ 7301139 -rw-rw 1 mysql wheel 274 Jun 11 2003 columns_priv.MYD 7301138 -rw-rw 1 mysql wheel 3072 Jun 11 2003 columns_priv.MYI 7301137 -rw-rw 1 mysql wheel 8778 Jun 11 2003 columns_priv.frm 7301124 -rw-rw 1 mysql wheel 1963 Jun 11 2003 db.MYD 7301123 -rw-rw 1 mysql wheel 3072 Jun 11 2003 db.MYI 7301122 -rw-rw 1 mysql wheel 8982 Jun 11 2003 db.frm 7301133 -rw-rw 1 mysql wheel 0 Jun 11 2003 func.MYD 7301132 -rw-rw 1 mysql wheel 1024 Jun 11 2003 func.MYI 7301131 -rw-rw 1 mysql wheel 8641 Jun 11 2003 func.frm 7301127 -rw-rw 1 mysql wheel 0 Jun 11 2003 host.MYD 7301126 -rw-rw 1 mysql wheel 1024 Jun 11 2003 host.MYI 7301125 -rw-rw 1 mysql wheel 8958 Jun 11 2003 host.frm 7301136 -rw-rw 1 mysql wheel 1140 Jun 11 2003 tables_priv.MYD 7301135 -rw-rw 1 mysql wheel 3072 Jun 11 2003 tables_priv.MYI 7301134 -rw-rw 1 mysql wheel 8877 Jun 11 2003 tables_priv.frm 7301372 -rw-r--r-- 1 root wheel 0 Oct 3 06:06 typescript 7301130 -rw-rw 1 mysql wheel 4387 Aug 9 08:59 user.MYD 7301129 -rw-rw 1 mysql wheel 2048 Aug 9 08:59 user.MYI 7301128 -rw-rw 1 mysql wheel 9148 Jun 11 2003 user.frm doctor.nl2k.ab.ca//usr/contrib/var/mysql$ ls -Fail .. total 19150 5904388 drwxr-xr-x 77 root wheel 2048 Oct 2 16:11 ./ 376960 drwxr-xr-x 23 root wheel 512 Oct 3 05:49 ../ 5904389 -rwx-- 1 mysql wheel 724529 Jun 11 2003 020607* 5975817 drwx-- 2 mysql wheel 512 Apr 18 2003 111/ 8043141 drwx-- 2 mysql wheel 512 Jul 5 18:04 ParticipatoryDemocracy/ 8027270 drwx-- 2 mysql wheel 1536 Oct 2 15:01 TMGDATA/ 5979790 drwx-- 2 mysql wheel 512 Oct 2 14:55 addata/ 5983752 drwx-- 2 mysql wheel 4096 Oct 2 14:55 adriannos/ 6015506 drwx-- 2 mysql wheel 512 Oct 2 14:55 avena/ 6019462 drwx-- 2 mysql wheel 512 Oct 2 14:55 banner/ 6023438 drwx-- 2 mysql wheel 512 Apr 18 2003 bargainboyz/ 6027402 drwx-- 2 mysql wheel 512 Oct 2 14:55 bezko/ 6031365 drwx-- 2 mysql wheel 512 Oct 2 14:55 blueflower/ 7440009 drwx-- 2 mysql wheel 512 Oct 2 14:58 busdir/ 6039305 drwx-- 2 mysql wheel 4608 Oct 2 14:55 catalog/ 6071044 drwx-- 2 mysql wheel 512 Oct 2 14:55 ccdb/ 6075010 drwx-- 2 mysql wheel 512 Oct 2 14:55 cclinks/ 6078986 drwx-- 2 mysql wheel 512 Oct 2 14:55 ccmp/ 6082961 drwx-- 2 mysql wheel 512 Oct 2 14:55 chess/ 6090888 drwx-- 2 mysql wheel 2048 Oct 2 14:55 codeabout/ 6098824 drwx-- 2 mysql wheel 1536 Oct 2 14:55 communityupdates/ 6114695 drwx-- 2 mysql wheel 1024 Oct 2 14:55 consortiamath/ 6122652 drwx-- 2 mysql wheel 512 Oct 2 14:55 darius/ 6126597 drwx-- 2 mysql wheel 512 Apr 18 2003 database01/ 6134535 drwx-- 2 mysql wheel 512 Oct 2 14:55 ddsnews/ 8023297 drwx-- 2 mysql wheel 512 Jun 24 21:03 democracy/ 7527307 drwx-- 2 mysql wheel 2048 Oct 2 14:59 digital4rt/ 7551114 drwx-- 2 mysql wheel11264 Oct 2 14:59 dkpostnuke/ 5904393 -rw-r--r-- 1 mysql wheel0 Oct 2 04:10 doctor.log 5904536 -rw-r--r-- 1 mysql wheel 3044467 Oct 2 03:32 doctor.log.0.gz 5904402 -rw-r--r-- 1 mysql wheel 1082868 Sep 18 04:10 doctor.log.1.gz 5904391 -rw-r--r-- 1 mysql wheel 1100202 Sep 11 03:58 doctor.log.2.gz 5904392 -rw-r--r-- 1 mysql wheel 1563416 Sep 4 02:11 doctor.log.3.gz 5904394 -rwxr-xr-x 1 mysql wheel 1887 Jun 11 2003 doctor.nk.ca.err* 5904395 -rwxr-xr-x 1 mysql wheel 379810 Oct 2 15:57 doctor.nl2k.ab.ca.err* 7642370 drwx-- 2 mysql wheel 1024 Oct 2 14:59 elkisland/ 6646402 drwx-- 2 mysql wheel 1536 Oct 2 14:56 facouncil/ 6654338 drwx-- 2 mysql wheel 2560 Oct 2 14:56 freetradenk/ 7443983 drwx-- 2 mysql wheel 6144 Oct 2 14:59 gamershaven/ 6360707 drwx-- 2 mysql wheel12800 Oct 2 14:56 goatboy/ 7519371 drwx-- 2 mysql wheel 512 Oct 2 14:59 horde/ 7650306 drwx-- 2 mysql wheel10752 Oct
RE: filed that does not contain text between symbols
not sure you can do this just with mysql, I think your gunna need to select the html from the db then send it to something like perl or php and use a regex parser on it. -Original Message- From: Bob Ramsey [mailto:[EMAIL PROTECTED] Sent: 03 October 2004 12:45 To: [EMAIL PROTECTED] Subject: filed that does not contain text between symbols Hi, I have some web pages in a database and I want to check to make sure that all of the images have alt tags in them. So what I need to do is ask something like this in psuedocode: select page_name from web_pages where page_body does not contain 'alt=' between 'img' and ''; But I just can't figure out the right syntax. Any ideas? Thanks, bob -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED] -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
foreign key problem
Two tables: Table1 [innodb] userID. addtlfields. Table2 [innodb] memberID. addtlfields. I created a foreign key in Table2 for memberID to userID set to no action on both delete and update. I get this error when I try to add a record to table 2:Cannot add or update a child row: a foreign key constraint fails I try and remove the foreign key and it won't let me: 1025-Error on rename of './mydatabase/table to './mydatabase/#sql2-695b-c4ac0'(errno: 152) I think can probably forgoe the foreign key , but what's with all the error messages ? Thank you, Stuart -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: filed that does not contain text between symbols
Chris Blackwell wrote: not sure you can do this just with mysql, I think your gunna need to select the html from the db then send it to something like perl or php and use a regex parser on it. Yeah, that's what I was afraid of. Now all I have to do is decide between PERL and PHP for the scripting language. ;) Thanks, Bob -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: foreign key problem
I think I may have discovered one of my issues, is memberID in Table2 was primary key. Should not have been. As far as the error messages in removing key, I'm still unsure. Stuart --- Stuart Felenstein [EMAIL PROTECTED] wrote: Two tables: Table1 [innodb] userID. addtlfields. Table2 [innodb] memberID. addtlfields. I created a foreign key in Table2 for memberID to userID set to no action on both delete and update. I get this error when I try to add a record to table 2:Cannot add or update a child row: a foreign key constraint fails I try and remove the foreign key and it won't let me: 1025-Error on rename of './mydatabase/table to './mydatabase/#sql2-695b-c4ac0'(errno: 152) I think can probably forgoe the foreign key , but what's with all the error messages ? Thank you, Stuart -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED] -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: filed that does not contain text between symbols
You can use regular expression. Santino At 6:45 -0500 3-10-2004, Bob Ramsey wrote: Hi, I have some web pages in a database and I want to check to make sure that all of the images have alt tags in them. So what I need to do is ask something like this in psuedocode: select page_name from web_pages where page_body does not contain 'alt=' between 'img' and ''; But I just can't figure out the right syntax. Any ideas? Thanks, bob -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED] -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Compacting MySQL database
Do MYsql require something similiar to compacting a database in Access ? -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Tying records together across mulitple tables.
I'm not sure , can't resolve in my mind if this is a M2M or something else. I have 5 tables, users may enter multiple records in each table. The only trick is (for me) is how to tie a unified record together across all of them. I'll try to illustrate, and only use 2 tables to keep it brief. Table1 - Bob has 3 records 1st record - Spoken Language is Spanish 2nd record - Spoken Language is French 3rd record - Spoken Language is English Table 2 - Bob has 3 records 1st record - I am Spanish 2nd record - I am French 3rd reocrd - I am English Okay the table strutures: Table1Table2 RecordID (int, autoinc) RecordID (int, autinc) MemberID (int)MemberID (int) Language (varchar)Nationality (varchar) I'm trying to say here is a record , that would form the result of I am Bob, I speak English, I am English I know, this probably sounds a bit weird :) Best way I can come up with right now to illustrate. If someone was searching through records, they would say I found someone who is Spanish and yes, they are Spanish. Not, I found someone who is Spanish and they speak Spanish , French and English. I considered (as this is part of a web site) generating an ID and then passing it into each table entry as the forms (that comprise the process) are submitted. Just to clarify, 5 tables - 5 forms , all part of 1 web entry. Stuart -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
What does mysql_stmt_fetch_column() do ???
Hello, The function mysql_stmt_fetch_column() in MySQL4.1 and higher is undocumented in the Manual: http://dev.mysql.com/doc/mysql/en/mysql_stmt_fetch_column.html So, my question is simple: what does this function do??? Thank you in advance, Boris borfig Figovsky. www.borfig.com
RE: Tying records together across mulitple tables.
Stuart, Can you give more information about the other tables as well? I followed what you are trying to do until you mentioned: snip If someone was searching through records, they would say I found someone who is Spanish and yes, they are Spanish. Not, I found someone who is Spanish and they speak Spanish , French and English. /snip Does this mean that you only want each person to speak only one language? As you can see, you lost me. But from what I am thinking you are trying to do, it is more of a design and normalization issue. If you could give more information about all of the tables, maybe we/someone could help you come up with a non-M2M design. Regards, David Bevan GetAnyIdeas Web Design P. 416.452.9410 F. 416.570.4529 E. [EMAIL PROTECTED] W. http://www.getanyideas.com I'm not sure , can't resolve in my mind if this is a M2M or something else. I have 5 tables, users may enter multiple records in each table. The only trick is (for me) is how to tie a unified record together across all of them. I'll try to illustrate, and only use 2 tables to keep it brief. Table1 - Bob has 3 records 1st record - Spoken Language is Spanish 2nd record - Spoken Language is French 3rd record - Spoken Language is English Table 2 - Bob has 3 records 1st record - I am Spanish 2nd record - I am French 3rd reocrd - I am English Okay the table strutures: Table1Table2 RecordID (int, autoinc) RecordID (int, autinc) MemberID (int)MemberID (int) Language (varchar)Nationality (varchar) I'm trying to say here is a record , that would form the result of I am Bob, I speak English, I am English I know, this probably sounds a bit weird :) Best way I can come up with right now to illustrate. If someone was searching through records, they would say I found someone who is Spanish and yes, they are Spanish. Not, I found someone who is Spanish and they speak Spanish , French and English. I considered (as this is part of a web site) generating an ID and then passing it into each table entry as the forms (that comprise the process) are submitted. Just to clarify, 5 tables - 5 forms , all part of 1 web entry. Stuart -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED] -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
[OT] HP DL760G2 vs Opteron for large DB on Linux
Hi all, I am looking to purchase hardware for a large database running MySQL or Oracle on Linux. Was thinking of the Opteron for its good scalability and memory bandwidth until my friend told me that the DL760 from HP that uses the F8 (from Intel Profusion) chipset allowing up to 8 CPUs and memeory up to 32GB. I have always though that the Xeons cannot go beyond 4 CPUs and 4GB but this changes the equation. Has anyone got experience with this server or similar ones? How is the performance for running databases, esp in terms of large RAM usage? -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]