RE: compile errors
# uname -a Linux linuxbox 2.4.16 #2 Wed Nov 28 12:24:51 PST 2001 i586 unknown # rpm -qa | grep -i libc glibc-2.2.4-20 glibc-devel-2.2.4-20 compat-glibc-6.2-2.1.3.2 glibc-common-2.2.4-20 # /usr/bin/gcc -v Reading specs from /usr/lib/gcc-lib/i386-redhat-linux/3.1/specs Configured with: ../configure --prefix=/usr --mandir=/usr/share/man --infodir=/usr/share/info --enable-shared --enable-threads=posix --disable-checking --host=i386-redhat-linux --with-system-zlib Thread model: posix gcc version 3.1 20011127 (Red Hat Linux Rawhide 3.1-0.10) -Original Message- From: Sinisa Milivojevic [mailto:[EMAIL PROTECTED]] Sent: Tuesday, December 11, 2001 3:57 AM To: [EMAIL PROTECTED] Cc: [EMAIL PROTECTED] Subject: RE: compile errors Gill, Vern writes: Still need help with this one Anyone, anyone? trying to compile mysql-3.23.46, getting this error. Can't find any reference to it anywhere. Please help; gcc -O3 -DDBUG_OFF -O9 -rdynamic -o isamchk isamchk.o sort.o libnisam.a ../mysys/libmysys.a ../dbug/libdbug.a ../strings/libmystrings.a -lpthread -lz -lcrypt -lnsl -lm -lpthread ../mysys/libmysys.a(mf_tempfile.o): In function `create_temp_file': mf_tempfile.o(.text+0xcd): undefined reference to `mkstemp64' collect2: ld returned 1 exit status make[2]: *** [isamchk] Error 1 make[2]: Leaving directory `/src/mysql-3.23.46/isam' make[1]: *** [all-recursive] Error 1 make[1]: Leaving directory `/src/mysql-3.23.46' make: *** [all-recursive-am] Error 2 Vern H. Gill State Director Director of Marketing Conejo Valley Jaycees http://www.conejovalleyjaycees.org What is compiler version and what OS and version. Seems like Linux, in which case you have improper installation with glibc missing the above symbol. -- Regards, __ ___ ___ __ / |/ /_ __/ __/ __ \/ /Mr. Sinisa Milivojevic [EMAIL PROTECTED] / /|_/ / // /\ \/ /_/ / /__ MySQL AB, Fulltime Developer /_/ /_/\_, /___/\___\_\___/ Larnaca, Cyprus ___/ 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: compile errors
Still need help with this one Anyone, anyone? -Original Message- From: Gill, Vern [mailto:[EMAIL PROTECTED]] Sent: Saturday, December 08, 2001 6:32 PM To: '[EMAIL PROTECTED]' Subject: RE: compile errors Still not compiling. New issue now... # rpm -q gcc gcc-3.1-0.10 ./configure --cache-file=config.cache --with-mysqld-user=mysql --localstatedir=/usr/local/mysql/var --prefix=/usr/local/mysql --with-unix-socket-path=/usr/local/mysql/lock/mysql.sock --without-berkeley-db --without-bench --enable-shared --without-mit-threads --enable-thread-safe-client make Making all in libmysql_r make[2]: Entering directory `/src/mysql-3.23.46/libmysql_r' /bin/sh ../libtool --mode=compile kgcc -DDEFAULT_CHARSET_HOME=\/usr/local/mysql\ -DDATADIR=\/usr/local/mysql/var\ -DSHAREDIR=\/usr/local/mysql/share/mysql\ -DDONT_USE_RAID -I./../include -I../include-I./.. -I.. -I..-O3 -DDBUG_OFF -O9 -c libmysql.c mkdir .libs kgcc -DDEFAULT_CHARSET_HOME=\/usr/local/mysql\ -DDATADIR=\/usr/local/mysql/var\ -DSHAREDIR=\/usr/local/mysql/share/mysql\ -DDONT_USE_RAID -I./../include -I../include -I./.. -I.. -I.. -O3 -DDBUG_OFF -O9 -c libmysql.c -fPIC -DPIC -o .libs/libmysql.lo libmysql.c: In function `mysql_real_connect': libmysql.c:1300: warning: passing arg 5 of `gethostbyname_r' from incompatible pointer type libmysql.c:1300: too few arguments to function `gethostbyname_r' libmysql.c:1300: warning: assignment makes pointer from integer without a cast make[2]: *** [libmysql.lo] Error 1 make[2]: Leaving directory `/src/mysql-3.23.46/libmysql_r' make[1]: *** [all-recursive] Error 1 make[1]: Leaving directory `/src/mysql-3.23.46' make: *** [all-recursive-am] Error 2 Any help available? -Original Message- From: Gill, Vern [mailto:[EMAIL PROTECTED]] Sent: Wednesday, December 05, 2001 8:05 PM To: '[EMAIL PROTECTED]' Subject: FW: compile errors HELP!! Can someone PLEASE help me with this issue? -Original Message- From: Gill, Vern [mailto:[EMAIL PROTECTED]] Sent: Wednesday, December 05, 2001 12:47 AM To: '[EMAIL PROTECTED]' Subject: FW: compile errors Anyone able to help with this? Or am I just stuck...? -Original Message- From: Gill, Vern [mailto:[EMAIL PROTECTED]] Sent: Friday, November 30, 2001 6:47 PM To: '[EMAIL PROTECTED]' Subject: compile errors trying to compile mysql-3.23.46, getting this error. Can't find any reference to it anywhere. Please help; kgcc -O3 -DDBUG_OFF -O9 -rdynamic -o isamchk isamchk.o sort.o libnisam.a ../mysys/libmysys.a ../dbug/libdbug.a ../strings/libmystrings.a -lpthread -lz -lcrypt -lnsl -lm -lpthread ../mysys/libmysys.a(mf_tempfile.o): In function `create_temp_file': mf_tempfile.o(.text+0xcd): undefined reference to `mkstemp64' collect2: ld returned 1 exit status make[2]: *** [isamchk] Error 1 make[2]: Leaving directory `/src/mysql-3.23.46/isam' make[1]: *** [all-recursive] Error 1 make[1]: Leaving directory `/src/mysql-3.23.46' make: *** [all-recursive-am] Error 2 Vern H. Gill State Director Director of Marketing Conejo Valley Jaycees http://www.conejovalleyjaycees.org - 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: compile errors
Still not compiling. New issue now... # rpm -q gcc gcc-3.1-0.10 ./configure --cache-file=config.cache --with-mysqld-user=mysql --localstatedir=/usr/local/mysql/var --prefix=/usr/local/mysql --with-unix-socket-path=/usr/local/mysql/lock/mysql.sock --without-berkeley-db --without-bench --enable-shared --without-mit-threads --enable-thread-safe-client make Making all in libmysql_r make[2]: Entering directory `/src/mysql-3.23.46/libmysql_r' /bin/sh ../libtool --mode=compile kgcc -DDEFAULT_CHARSET_HOME=\/usr/local/mysql\ -DDATADIR=\/usr/local/mysql/var\ -DSHAREDIR=\/usr/local/mysql/share/mysql\ -DDONT_USE_RAID -I./../include -I../include-I./.. -I.. -I..-O3 -DDBUG_OFF -O9 -c libmysql.c mkdir .libs kgcc -DDEFAULT_CHARSET_HOME=\/usr/local/mysql\ -DDATADIR=\/usr/local/mysql/var\ -DSHAREDIR=\/usr/local/mysql/share/mysql\ -DDONT_USE_RAID -I./../include -I../include -I./.. -I.. -I.. -O3 -DDBUG_OFF -O9 -c libmysql.c -fPIC -DPIC -o .libs/libmysql.lo libmysql.c: In function `mysql_real_connect': libmysql.c:1300: warning: passing arg 5 of `gethostbyname_r' from incompatible pointer type libmysql.c:1300: too few arguments to function `gethostbyname_r' libmysql.c:1300: warning: assignment makes pointer from integer without a cast make[2]: *** [libmysql.lo] Error 1 make[2]: Leaving directory `/src/mysql-3.23.46/libmysql_r' make[1]: *** [all-recursive] Error 1 make[1]: Leaving directory `/src/mysql-3.23.46' make: *** [all-recursive-am] Error 2 Any help available? -Original Message- From: Gill, Vern [mailto:[EMAIL PROTECTED]] Sent: Wednesday, December 05, 2001 8:05 PM To: '[EMAIL PROTECTED]' Subject: FW: compile errors HELP!! Can someone PLEASE help me with this issue? -Original Message- From: Gill, Vern [mailto:[EMAIL PROTECTED]] Sent: Wednesday, December 05, 2001 12:47 AM To: '[EMAIL PROTECTED]' Subject: FW: compile errors Anyone able to help with this? Or am I just stuck...? -Original Message- From: Gill, Vern [mailto:[EMAIL PROTECTED]] Sent: Friday, November 30, 2001 6:47 PM To: '[EMAIL PROTECTED]' Subject: compile errors trying to compile mysql-3.23.46, getting this error. Can't find any reference to it anywhere. Please help; kgcc -O3 -DDBUG_OFF -O9 -rdynamic -o isamchk isamchk.o sort.o libnisam.a ../mysys/libmysys.a ../dbug/libdbug.a ../strings/libmystrings.a -lpthread -lz -lcrypt -lnsl -lm -lpthread ../mysys/libmysys.a(mf_tempfile.o): In function `create_temp_file': mf_tempfile.o(.text+0xcd): undefined reference to `mkstemp64' collect2: ld returned 1 exit status make[2]: *** [isamchk] Error 1 make[2]: Leaving directory `/src/mysql-3.23.46/isam' make[1]: *** [all-recursive] Error 1 make[1]: Leaving directory `/src/mysql-3.23.46' make: *** [all-recursive-am] Error 2 Vern H. Gill State Director Director of Marketing Conejo Valley Jaycees http://www.conejovalleyjaycees.org - 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
FW: compile errors
Anyone able to help with this? Or am I just stuck...? -Original Message- From: Gill, Vern [mailto:[EMAIL PROTECTED]] Sent: Friday, November 30, 2001 6:47 PM To: '[EMAIL PROTECTED]' Subject: compile errors trying to compile mysql-3.23.46, getting this error. Can't find any reference to it anywhere. Please help; kgcc -O3 -DDBUG_OFF -O9 -rdynamic -o isamchk isamchk.o sort.o libnisam.a ../mysys/libmysys.a ../dbug/libdbug.a ../strings/libmystrings.a -lpthread -lz -lcrypt -lnsl -lm -lpthread ../mysys/libmysys.a(mf_tempfile.o): In function `create_temp_file': mf_tempfile.o(.text+0xcd): undefined reference to `mkstemp64' collect2: ld returned 1 exit status make[2]: *** [isamchk] Error 1 make[2]: Leaving directory `/src/mysql-3.23.46/isam' make[1]: *** [all-recursive] Error 1 make[1]: Leaving directory `/src/mysql-3.23.46' make: *** [all-recursive-am] Error 2 Vern H. Gill State Director Director of Marketing Conejo Valley Jaycees http://www.conejovalleyjaycees.org - 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
FW: compile errors
HELP!! Can someone PLEASE help me with this issue? -Original Message- From: Gill, Vern [mailto:[EMAIL PROTECTED]] Sent: Wednesday, December 05, 2001 12:47 AM To: '[EMAIL PROTECTED]' Subject: FW: compile errors Anyone able to help with this? Or am I just stuck...? -Original Message- From: Gill, Vern [mailto:[EMAIL PROTECTED]] Sent: Friday, November 30, 2001 6:47 PM To: '[EMAIL PROTECTED]' Subject: compile errors trying to compile mysql-3.23.46, getting this error. Can't find any reference to it anywhere. Please help; kgcc -O3 -DDBUG_OFF -O9 -rdynamic -o isamchk isamchk.o sort.o libnisam.a ../mysys/libmysys.a ../dbug/libdbug.a ../strings/libmystrings.a -lpthread -lz -lcrypt -lnsl -lm -lpthread ../mysys/libmysys.a(mf_tempfile.o): In function `create_temp_file': mf_tempfile.o(.text+0xcd): undefined reference to `mkstemp64' collect2: ld returned 1 exit status make[2]: *** [isamchk] Error 1 make[2]: Leaving directory `/src/mysql-3.23.46/isam' make[1]: *** [all-recursive] Error 1 make[1]: Leaving directory `/src/mysql-3.23.46' make: *** [all-recursive-am] Error 2 Vern H. Gill State Director Director of Marketing Conejo Valley Jaycees http://www.conejovalleyjaycees.org - 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
Changing data
how would I change in all rows data that is; 00 to 000-000- or (000) 000- Can this even be done with mysql? Thank you in advance... Vern H. Gill State Director Director of Marketing Conejo Valley Jaycees http://www.conejovalleyjaycees.org - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
RE: Changing data
Okay, so if it won't work with more than one space, are thos records doomed to upper only or First letter capitalized? -Original Message- From: Jonathan Hilgeman [mailto:[EMAIL PROTECTED]] Sent: Monday, December 03, 2001 11:10 AM To: 'Gill, Vern' Cc: '[EMAIL PROTECTED]' Subject: RE: Changing data Try the following 2 queries. UPDATE table SET name=concat(ucase(left(name,1)), lcase(SUBSTRING(name,2))); UPDATE table SET name=concat(left(name, INSTR(name, ' ')), ucase(mid(name,INSTR(name, ' ')+1,1)), substring(name FROM INSTR(name, ' ')+2)) WHERE INSTR(name, ' ') 0; The first query will capitalize the first letter of every entry and make the rest lower case. The second query will find the first blank, then capitalize the proceeding letter. Note that for names that have more than one space in them (PRO SPORTS TEAM), this won't work. But you can find those records that have more than one space in them by running THIS query: SELECT * FROM table WHERE name REGEXP .* .* .* - Jonathan -Original Message- From: Gill, Vern [mailto:[EMAIL PROTECTED]] Sent: Monday, December 03, 2001 10:45 AM To: 'Jonathan Hilgeman' Subject: RE: Changing data Cool. Thank everyone for help with that. Now, one more question; Can I use MySQL to change the data's case? I.E.; PROS TEAM - Pros Team PINEAPPLES - Pineapples RAPID PRINTING - Rapid Printing -Original Message- From: Jonathan Hilgeman [mailto:[EMAIL PROTECTED]] Sent: Monday, December 03, 2001 8:27 AM To: 'Gill, Vern'; '[EMAIL PROTECTED]' Subject: RE: Changing data Try this query: UPDATE table SET phone = concat((,left(phone,3),) ,mid(phone,3,3),-,mid(phone,6,4)); It should convert 00 to (000) 000-. Take a look at this page if you want details on how it works: http://www.mysql.com/doc/S/t/String_functions.html - Jonathan -Original Message- From: Gill, Vern [mailto:[EMAIL PROTECTED]] Sent: Monday, December 03, 2001 3:23 AM To: '[EMAIL PROTECTED]' Subject: Changing data how would I change in all rows data that is; 00 to 000-000- or (000) 000- Can this even be done with mysql? Thank you in advance... Vern H. Gill State Director Director of Marketing Conejo Valley Jaycees http://www.conejovalleyjaycees.org - 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: SHOW TABLES; show nothing
Well, according to several subsequent messages, including http://lists.mysql.com/cgi-ez/ezmlm-cgi?1:msn:67549:ololjemolklapaobokil; that does NOT appear to be the problem, as it also happens on other distros, with other environments and compilers... Any ideas from any MySQL developers listening? -Original Message- From: Benjamin Pflugmann [mailto:[EMAIL PROTECTED]] Sent: Monday, December 03, 2001 4:22 PM To: Quentin Bennett Cc: 'Gill, Vern'; [EMAIL PROTECTED] Subject: Re: SHOW TABLES; show nothing Hi. I remember this beeing reported once before. The answer supposed that it was a problem with the compiler shipped with Red Hat. The mail is: http://lists.mysql.com/cgi-ez/ezmlm-cgi?1:mss:67476:ololjemolklapaobokil (and the next in thread). If this is indeed the case, a simple fix is to use the binary provided on www.mysql.com. Bye, Benjamin. On Tue, Dec 04, 2001 at 08:19:27AM +1300, [EMAIL PROTECTED] wrote: Hi, Try myisamchk'ing you mysql tables. Regards Quentin -Original Message- From: Gill, Vern [mailto:[EMAIL PROTECTED]] Sent: Monday, 3 December 2001 5:40 p.m. To: [EMAIL PROTECTED] Subject: SHOW TABLES; show nothing [...] mysql SHOW DATABASES; +--+ | Database | +--+ | | | | | | | | | | | | | | +--+ 7 rows in set (0.00 sec) [...] -- [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
SHOW TABLES; show nothing
mysql CREATE TABLE faxblast (company VARCHAR(100), phone VARCHAR(12), fax TINYINT (10) UNSIGNED, state CHAR(2), description VARCHAR(80), sic VARCHAR(7)); Query OK, 0 rows affected (0.09 sec) mysql SHOW TABLES; Empty set (0.00 sec) mysql DESCRIBE faxblast - ; +-+--+--+-+-+---+--- --+ | Field | Type | Null | Key | Default | Extra | Privileges | +-+--+--+-+-+---+--- --+ | company | varchar(100) | YES | | NULL| | select,insert,update,references | | phone | varchar(12) | YES | | NULL| | select,insert,update,references | | fax | tinyint(10) unsigned | YES | | NULL| | select,insert,update,references | | state | char(2) | YES | | NULL| | select,insert,update,references | | description | varchar(80) | YES | | NULL| | select,insert,update,references | | sic | varchar(7) | YES | | NULL| | select,insert,update,references | +-+--+--+-+-+---+--- --+ 6 rows in set (0.01 sec) mysql use mysql Database changed mysql use pcdocrx Database changed mysql DESCRIBE faxblast; +-+--+--+-+-+---+--- --+ | Field | Type | Null | Key | Default | Extra | Privileges | +-+--+--+-+-+---+--- --+ | company | varchar(100) | YES | | NULL| | select,insert,update,references | | phone | varchar(12) | YES | | NULL| | select,insert,update,references | | fax | tinyint(10) unsigned | YES | | NULL| | select,insert,update,references | | state | char(2) | YES | | NULL| | select,insert,update,references | | description | varchar(80) | YES | | NULL| | select,insert,update,references | | sic | varchar(7) | YES | | NULL| | select,insert,update,references | +-+--+--+-+-+---+--- --+ 6 rows in set (0.00 sec) mysql SHOW TABLES; Empty set (0.00 sec) Someone please explain to my why this is happening? In fact, could someone explain this too?; # mysql -p Welcome to the MySQL monitor. Commands end with ; or \g. Your MySQL connection id is 66 to server version: 3.23.28-gamma Type 'help;' or '\h' for help. Type '\c' to clear the buffer mysql SHOW DATABASES; +--+ | Database | +--+ | | | | | | | | | | | | | | +--+ 7 rows in set (0.00 sec) mysql SHOW TABLES; ERROR 1046: No Database Selected mysql use mysql Database changed mysql SHOW TABLES; Empty set (0.00 sec) mysql quit Bye [root@localhost /tmp]# ls /usr/local/var/ total 20k 4.0k drwx--2 root root 4.0k Dec 2 20:20 PC_Doctor_RX.orig/ 4.0k drwx--2 root root 4.0k Dec 2 11:02 mysql/ 4.0k -rw-r--r--1 root root5 Nov 29 16:26 mysqld.pid 4.0k drwx--2 root root 4.0k Dec 2 20:29 pcdocrx/ 4.0k drwx--2 root root 4.0k Nov 30 12:01 ulog/ Vern H. Gill State Director Director of Marketing Conejo Valley Jaycees http://www.conejovalleyjaycees.org - 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
compile errors
trying to compile mysql-3.23.46, getting this error. Can't find any reference to it anywhere. Please help; kgcc -O3 -DDBUG_OFF -O9 -rdynamic -o isamchk isamchk.o sort.o libnisam.a ../mysys/libmysys.a ../dbug/libdbug.a ../strings/libmystrings.a -lpthread -lz -lcrypt -lnsl -lm -lpthread ../mysys/libmysys.a(mf_tempfile.o): In function `create_temp_file': mf_tempfile.o(.text+0xcd): undefined reference to `mkstemp64' collect2: ld returned 1 exit status make[2]: *** [isamchk] Error 1 make[2]: Leaving directory `/src/mysql-3.23.46/isam' make[1]: *** [all-recursive] Error 1 make[1]: Leaving directory `/src/mysql-3.23.46' make: *** [all-recursive-am] Error 2 Vern H. Gill State Director Director of Marketing Conejo Valley Jaycees http://www.conejovalleyjaycees.org - 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