MySQL Manager Connection Config Problem
Hello. I'm running MySQL 3.23.29a-gamma on RH Linux 7.0. I would like to administer my database from a Win98se client on the same network and installed EMS's MySQL Manager 1.8. This appears to be an excellent tool and can't wait to get started. Unfortunately I'm having a problem getting the connection configuration setup correctly. Note that accessing the database from the Linux side works perfectly. The local NIC on my Linux server is assigned 192.168.0.1 and my Win98 workstation is 192.168.0.12. In the Configuration Info dialog, I enter 192.168.0.1 for Host, Port 3306, User Name Root, Password [mypass] and Database mysql. I know that MySQL Manager sees my MySQL server because it reports that Host '192.168.0.12' is not allowed to connect to this MySQL server. The weird thing about this message is that I'm trying to connect to 192.168.0.1 and not 192.168.0.12. It seems this is a permissions issue. Any suggestions would be appreciated. - 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 Manager Connection Config Problem
Hello. I'm running MySQL 3.23.29a-gamma on RH Linux 7.0. I would like to administer my database from a Win98se client on the same network and installed EMS's MySQL Manager 1.8. This appears to be an excellent tool and can't wait to get started. Unfortunately I'm having a problem getting the connection configuration setup correctly. Note that accessing the database from the Linux side works perfectly. The local NIC on my Linux server is assigned 192.168.0.1 and my Win98 workstation is 192.168.0.12. In the Configuration Info dialog, I enter 192.168.0.1 for Host, Port 3306, User Name Root, Password [mypass] and Database mysql. I know that MySQL Manager sees my MySQL server because it reports that Host '192.168.0.12' is not allowed to connect to this MySQL server. The weird thing about this message is that I'm trying to connect to 192.168.0.1 and not 192.168.0.12. It seems this is a permissions issue. Any suggestions would be appreciated. - 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
Please help with weird sorting problem
I have a bit of a problem. I need to do something kinda odd that I'm hoping to get help with...except for any suggestions of changing my table structure. This might seem weird but I need to try and make it work as it is. I have a table called pwdata that looks like the following: id field value thread 0 3 perkins 1 1 2 mark1 2 6 colorado1 3 3 rogers 2 4 2 bill2 5 6 texas 2 6 3 adams 3 7 2 nancy 3 8 7 summer 4 9 8 rain4 10 3 stemm 5 11 2 ethan 5 12 6 kansas 5 13 6 utah6 14 3 murray 6 15 2 bill6 15 9 sales 6 I need a list of threads where field is equal to one or more of three values (2 or 3 or 6 in this example) and be able to sort by any of these fields. If I use something like this: SELECT c0.thread, c1.value, c2.value FROM pwdata AS c0 LEFT JOIN pwdata AS c1 ON c0.thread = c1.thread LEFT JOIN pwdata AS c2 ON c0.thread = c2.thread WHERE c1.field IN (2,3,6) AND c2.field=3 GROUP BY c0.thread ORDER BY c2.value I get a three column return with a row for each unique thread sorted by whatever value I assign to c2.field. This works great except where I try to sort by a field that does not exist in all of the threads. I need it to show me the total number of rows (five: threads 1,2, 3,5,6 for the example above) regardless of how I sort. For example, by setting c2.field above to 3 it shows five columns and sorts them by the value of field 3. If I set it to 2 it shows five columns and sorts them by the value of field 2. If, however, I set c2.field to 6 it only shows 4 columns and sorts them. I can see why, but I am desperately seeking a query with the structure above that I can search by a set of three and sort by any of them. It is relatively straight forward for me to pull the thread info I need, but there does not appear to be much in the way of sorting options. I'm hoping there might be some way to work with the same table in a different way with Left Joins so to preserve the number of returned rows by creating 'null' values for the missing values in each thread. I'm not sure if this made any sense... Any ideas? Quinn - 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
Problem with compiling a MySQL client in C language
Hello, Is anyone using Borland's C compiler with Windows (XP) ? I am trying to compile/link a very simple MySQL client written in C, using MySQL include files and mysqlclient library, but it does not want to work. What command line(s) should I use to have it compiled right ? By advance, thank you. Regards from Belgium, Jean-Marc - 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
FREE traffic to your website !
Hi, My name is Mike and I have visited your web site at: http://www.mysql.com/downloads/gui-mysqlgui.html I love it. So I have decided to write to you. I thought that because generating traffic is so critical for any website, you could be interested in some information I have about FREE web traffic. If you want to read it, simply reply to this email with a blank message and I will email it to you. Have a great day, Mike. - 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
Binary install failure on SCO 5.0.6 - missing dynamic link libraries
Neither of the two binary mysql-max 3.23.41 from the MySQL website will run on my system after installation. Both configure and mysql_install_db fail due to missing dynamic link libraries /usr/lib/libdl.so.1 and libnsl.so.1. The system does have libdl.so and libnsl.so. The source distribution wont compile; I have GNU compiler 2.95.2 along with the OpenServer Linker and Application Development Libraries installed. The most prominent compiler error appears to be related to missing UnixWare thread libraries, implying that it needs not just the proprietary SCO OpenServer development system, but the combined OpenServer/Unixware system. I was going to try and compile FSUpthreads to see if that would substitute, but that failed as well. I had not tried to install the package on SCOs skunkware site, as it was 3.21 without transaction support. However, I tried that next, found that both FSUpthreads 3.5 and 3.9 packages were available at the skunkware site, and it installed and ran after installing FSUpthreads 3.5. Neither of the two libraries above was present in /usr/lib after the install. I havent yet had time to try compiling the source distribution again, now that I have found FSUpthreads. 1) Why does the binary distribution fail? Would expect it to run with libraries available on any OpenServer System. 2) Would recompiling the source distribution with the GNU compiler after installing FSUpthreads 3.9 be successful? My office server runs OpenServer only because a critical financial application runs on only SCO or AIX, actually using an older dbms backend (Unify). The server is the only system on the LAN with DAT backup, hence the choice of SCO for mysql. I do plan to lobby the vendor to switch to linux and mysql. The other alternative if a current mysql-max distribution wont run on SCO is to run it on a WinXP system on the LAN, and copy the data directories to the server each night with one of the SAMBA utilities. The office LAN and planned mysql application are small enough that this approach wont impair performance. David P. Lurie Rheumatology Associates, P.C. 106 Woodlawn Drive Johnson City, TN 37604 (423) 929-3358 voice - 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: FREE traffic to your website !
Doesn't this figure... the spamming bastards are now wasting time in user groups. What a dumbass. Matt - Original Message - From: [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: Sunday, September 08, 2002 7:26 AM Subject: FREE traffic to your website ! Hi, My name is Mike and I have visited your web site at: http://www.mysql.com/downloads/gui-mysqlgui.html I love it. So I have decided to write to you. I thought that because generating traffic is so critical for any website, you could be interested in some information I have about FREE web traffic. If you want to read it, simply reply to this email with a blank message and I will email it to you. Have a great day, Mike. - 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
select * into outfile
Hello! I have one subroutine in Perl (DBI) that prepares and executes SELECT-like queries and fetches the output from them. When I submit SELECT * INTO OUTFILE query, then $sth-fetchrow_array() generates Error: Error 19 (fetch() without execute()) How to avoid it? How can this subroutine distinguish SELECT * INTO OUTFILE queries in order not to fetch the result? Thanks! Ioannis Livassov - 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: select * into outfile
you need to execute your query first you can avoid execute by using the just 'do' or else you'll need to execute your query before getting results Tom - Original Message - From: edatanew.com [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: Monday, September 09, 2002 12:35 AM Subject: select * into outfile Hello! I have one subroutine in Perl (DBI) that prepares and executes SELECT-like queries and fetches the output from them. When I submit SELECT * INTO OUTFILE query, then $sth-fetchrow_array() generates Error: Error 19 (fetch() without execute()) How to avoid it? How can this subroutine distinguish SELECT * INTO OUTFILE queries in order not to fetch the result? Thanks! Ioannis Livassov - 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
build error on hp-ux 11.00
I think the report is in rather good detail so not to lose any more of your time here it is. bug uname -a HP-UX student B.11.00 U 9000/800 122901547 unlimited-user license bug pwd /var/tmp/vsurlan bug ll total 0 bug wget -c ftp://ftp.ntua.gr/pub/databases/mysql/Downloads/\ MySQL-4.0/mysql-4.0.3-beta.tar.gz --22:18:17-- ftp://ftp.ntua.gr:21/pub/databases/mysql/Downloads/MySQL-4.0/mysql -4.0.3-beta.tar.gz = `mysql-4.0.3-beta.tar.gz' Connecting to ftp.ntua.gr:21... connected! Logging in as anonymous ... Logged in! == TYPE I ... done. == CWD pub/databases/mysql/Downloads/MySQL-4.0 ... done. == PORT ... done.== RETR mysql-4.0.3-beta.tar.gz ... done. Length: 11,106,600 (unauthoritative) 0K - .. .. .. .. .. [ 0%] . . . 10800K - .. .. .. .. .. [100%] 22:18:56 (288.40 KB/s) - `mysql-4.0.3-beta.tar.gz' saved [11106600] bug gunzip * bug tar xf * tar: ././@LongLink - cannot create . . [about 50 lines skiped] . tar: ././@LongLink - cannot create bug bug ll total 107364 -- 1 vsurlanstudent1 101 Jan 1 1970 @LongLink drwx-- 33 vsurlanstudent1 1024 Sep 7 22:19 mysql-4.0.3-beta -rw--- 1 vsurlanstudent1 54927360 Sep 7 22:18 mysql-4.0.3-beta.tar bug df -k . /var/tmp (/dev/vg00/lvol9 ) : 179442 total allocated Kb 70680 free allocated Kb 108762 used allocated Kb 60 % allocation used bug rm *tar bug df -k . /var/tmp (/dev/vg00/lvol9 ) : 179442 total allocated Kb 124360 free allocated Kb 55082 used allocated Kb 30 % allocation used bug cd mysql-4.0.3-beta/ bug export CC=cc bug export CXX=aCC bug export CFLAGS=-Ae +DAportable +O2 -D_REENTRANT bug export CXXFLAGS=-Aa +DAportable +O2 -D_REENTRANT bug ./configure --prefix=/var/tmp/vsurlan/mysql\ --enable-thread-safe-client --enable-assembler --with-pthread \ --with-mysqld-user=vsurlan --without-debug --with-low-memory \ --with-embedded-server --without-docs --without-bench checking build system type... hppa2.0w-hp-hpux11.00 checking host system type... hppa2.0w-hp-hpux11.00 checking target system type... hppa2.0w-hp-hpux11.00 checking for a BSD compatible install... /opt/imake/bin/install -c checking whether build environment is sane... yes checking whether make sets ${MAKE}... yes checking for working aclocal... missing checking for working autoconf... missing checking for working automake... missing checking for working autoheader... missing checking for working makeinfo... found checking whether to enable maintainer-specific portions of Makefiles... no checking whether build environment is sane... yes checking whether make sets ${MAKE}... (cached) yes checking for mawk... no checking for gawk... no checking for nawk... no checking for awk... awk checking for gcc... cc checking for C compiler default output... a.out checking whether the C compiler works... yes checking whether we are cross compiling... no checking for executable suffix... checking for object suffix... o checking whether we are using the GNU C compiler... no checking whether cc accepts -g... yes checking whether we are using the GNU C++ compiler... no checking whether aCC accepts -g... yes checking how to run the C preprocessor... cc -E cc: warning 422: Unknown option - ignored. cc: NLSPATH is /opt/ansic/lib/nls/msg/%L/%N.cat:/opt/ansic/lib/nls/msg/C/%N.cat: cc: CCOPTS is not set. cc: INCLUDIR is INCLUDIR=/usr/include checking C Compiler version... cc aCC: HP ANSI C++ B3910B A.03.25 checking C++ compiler version... aCC checking for as... /usr/ccs/bin/as checking for ranlib... ranlib checking for non-GNU ld... /usr/bin/ld checking if the linker (/usr/bin/ld) is GNU ld... no checking for BSD-compatible nm... /usr/bin/nm -p checking whether ln -s works... yes loading cache /dev/null within ltconfig checking whether we are using GNU C... no checking for object suffix... o checking for executable suffix... no checking for cc option to produce PIC... +Z checking if cc PIC flag +Z works... yes checking if cc supports -c -o file.o... yes checking if cc supports -c -o file.lo... yes checking if cc static flag -Wl,-a -Wl,archive works... -Wl,-a -Wl,archive checking if the linker (/usr/bin/ld) is GNU ld... no checking whether the linker (/usr/bin/ld) supports shared libraries... yes checking command to parse /usr/bin/nm -p output... failed checking how to hardcode library paths into programs... relink checking for /usr/bin/ld option to reload object files... -r checking dynamic linker characteristics... hpux11.00 dld.sl checking if libtool supports shared libraries... yes checking whether to build shared
Re: Have A problem
Hi Chuck, or take a look at the LEFT() function. =dn Try : SELECT * FROM yourtable WHERE word LIKE 'D%'; Regards, Jocelyn - Original Message - From: Chuck PUP Payne [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: Sunday, September 08, 2002 2:42 AM Subject: Have A problem Hi, I got a small problem I can't seem to do a sql statement that will pick on the first letter of word in a feild. I have over 700 record in a database, but I like to be able only to see those that let say start with D. How can I do a statement that will let me do that. Chuck Payne Magi Design and Support. - 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: Problem compiling mysql-3.23.52
-BEGIN PGP SIGNED MESSAGE- Hash: SHA1 On Sunday 08 September 2002 02:25, Javier Suarez wrote: Im having a problem compiling the version of the subject, the problem is with the gethotsbyname function and the message is the next: libmysql.c: In function `mysql_real_connect': libmysql.c:1325: warning: passing arg 5 of `gethostbyname_r' from incompatible pointer type libmysql.c:1325: too few arguments to function `gethostbyname_r' libmysql.c:1325: warning: assignment makes pointer from integer without a cast make[2]: *** [libmysql.lo] Error 1 make[2]: Leaving directory `/opt/src/apache/mysql-3.23.52/libmysql' make[1]: *** [all-recursive] Error 1 make[1]: Leaving directory `/opt/src/apache/mysql-3.23.52' make: *** [all-recursive-am] Error 2 The system is Suse 8.0 and the Glibc is the glibc-2.2.5-38 Any solution or should I install the RPM from Suse? :-( Make sure that the GNU C++ compiler (package gpp) is installed and run configure again. Bye, LenZ - -- For technical support contracts, visit https://order.mysql.com/?ref=mlgr __ ___ ___ __ / |/ /_ __/ __/ __ \/ /Mr. Lenz Grimmer [EMAIL PROTECTED] / /|_/ / // /\ \/ /_/ / /__ MySQL AB, Production Engineer /_/ /_/\_, /___/\___\_\___/ Hamburg, Germany ___/ www.mysql.com -BEGIN PGP SIGNATURE- Version: GnuPG v1.0.7 (GNU/Linux) iD8DBQE9e3aTSVDhKrJykfIRAj0WAJ9VlTx71gxGy5hfEIseDnfTrlcTowCfS6UR 2+G02aOAx0r9JCilji0Zyxo= =PdX6 -END PGP SIGNATURE- - 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: select * into outfile
Yes, I can do that, but the subroutine is the same that execute other SELECT-like statements. It does: prepare execute fetch result print Then it must understand when SELECT * INTO OUTFILE must be executed and do not try to fetch data. Is there any criteria that say that there is no data to fetch? thanks. Ioannis Livassov - Original Message - From: Tom Gao [EMAIL PROTECTED] To: edatanew.com [EMAIL PROTECTED]; [EMAIL PROTECTED] Sent: Sunday, September 08, 2002 6:50 PM Subject: Re: select * into outfile you need to execute your query first you can avoid execute by using the just 'do' or else you'll need to execute your query before getting results Tom - Original Message - From: edatanew.com [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: Monday, September 09, 2002 12:35 AM Subject: select * into outfile Hello! I have one subroutine in Perl (DBI) that prepares and executes SELECT-like queries and fetches the output from them. When I submit SELECT * INTO OUTFILE query, then $sth-fetchrow_array() generates Error: Error 19 (fetch() without execute()) How to avoid it? How can this subroutine distinguish SELECT * INTO OUTFILE queries in order not to fetch the result? Thanks! Ioannis Livassov - 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
Problem compiling a MySQL client in C language
Hello, Is anyone using Borland's C compiler with Windows (XP) ? I am trying to compile/link a very simple MySQL client written in C, using MySQL include files and mysqlclient library, but it does not want to work. What command line(s) should I use to have it compiled right ? By advance, thank you. Regards from Belgium, Jean-Marc - 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 to cleanly uninstall
On Saturday 07 September 2002 10:48, you wrote: You could do something like: linux:/home/db/TMPOUT # rpm -e MySQL-4.0.3-0.i386.rpm error: package MySQL-4.0.3-0.i386.rpm is not installed Don't add the RPM on the end. Also, what does: * rpm -qa | grep MySQL ...show. It will be in there. Use that name. mysql,query DSL linux:/home/db/TMPOUT # rpm -q mysql package mysql is not installed linux:/home/db/TMPOUT # rpm -qa | grep MySQL MySQL-shared-4.0.3-0 MySQL-client-4.0.3-0 MySQL-devel-4.0.3-0 MySQL-4.0.3-0 linux:/home/spiros/TMPOUT # mypc@linux:~ /usr/bin/mysql ERROR 2002: Can't connect to local MySQL server through socket '/var/lib/mysql/mysql.sock' (2) mypc@linux:~ /usr/bin/mysqld_safe /usr/bin/mysqld_safe: my_print_defaults: command not found The file /usr/sbin/mysqld doesn't exist or is not executable Please do a cd to the mysql installation directory and restart this script from there as follows: ./bin/mysqld_safe. @linux:~ Does this mean the rpm is no good? What next - 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
LOAD DATA not a valid command?
I just installed Max v3.23.52-nt and it is working. However, in following the tutorial, I created a text file and tried to use the Load Data command, which returned an error: ERROR 1148: The used command is not allowed with this MySQL version I need to convert a large Access DB to mySQL and I was hoping I could do this in a LOAD DATA command. 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
Null to a value...
Hi again, I need to change cross 600 records that have 'Null' in the field and I need to change it a value. What is the sql statement that will let me change that field. Chuck Payne Magi Design and Support - 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: Replication problem: slave can't log into master
On Thu, Sep 05, 2002 at 09:52:05AM -0400, Jamie Beu wrote: I am attempting to setup MySQL replication between the ctiadb1 (master) server and the ctiadb2 (slave) server. When I look at the mysql.log file on the slave, I see the following (repeated every 60 seconds): 020904 12:00:30 Slave thread: error connecting to master: Access denied for user: '[EMAIL PROTECTED]' (Using password: YES) (0), retry in 60 sec 020904 12:01:30 Slave thread: error connecting to master: Access denied for user: '[EMAIL PROTECTED]' (Using password: YES) (0), retry in 60 sec I already typed the following on the Master server: grant file on *.* to 'repl'@'%' identified by 'replctia'; flush privileges; Perhaps the master.info file on the slave is wrong. Try removing it and restatring the slave. -- Jeremy D. Zawodny | Perl, Web, MySQL, Linux Magazine, Yahoo! [EMAIL PROTECTED] | http://jeremy.zawodny.com/ MySQL 3.23.51: up 33 days, processed 671,118,015 queries (231/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
RE: Null to a value...
-BEGIN PGP SIGNED MESSAGE- Hash: SHA1 Chuck, If you need to change NULLs to a value all you need do is: UPDATE table_name SET field_name = 'your_value' WHERE field_name IS NULL; HTH, Bryant Hester - -Original Message- From: Chuck PUP Payne [mailto:[EMAIL PROTECTED]] Sent: Sunday, September 08, 2002 2:35 PM To: [EMAIL PROTECTED] Subject: Null to a value... Hi again, I need to change cross 600 records that have 'Null' in the field and I need to change it a value. What is the sql statement that will let me change that field. Chuck Payne Magi Design and Support - - 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 -BEGIN PGP SIGNATURE- Version: PGPfreeware 7.0.3 for non-commercial use http://www.pgp.com iQA/AwUBPXuqlUlWu7/HFp4nEQLU+QCfUCU6cSEmIdmU9TdXs+gSd5RaSjcAn2ri 3c5Mom7FPV/gxGUQnOwuXrqb =tUOk -END PGP SIGNATURE- - 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
Reindex a table.
Well I am glad for the help :). I am get an old table clean up but need to re-index my table. I think there is on small problem. It's is ISAM table and not myISAM. Chuck Payne Magi Design and Support Mysql and sql - 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 Manager Connection Config Problem
Hello. I'm running MySQL 3.23.29a-gamma on RH Linux 7.0. I would like to administer my database from a Win98se client on the same network and installed EMS's MySQL Manager 1.8. This appears to be an excellent tool and can't wait to get started. Unfortunately I'm having a problem getting the connection configuration setup correctly. Note that accessing the database from the Linux side works perfectly. The local NIC on my Linux server is assigned 192.168.0.1 and my Win98 workstation is 192.168.0.12. In the Configuration Info dialog, I enter 192.168.0.1 for Host, Port 3306, User Name Root, Password [mypass] and Database mysql. I know that MySQL Manager sees my MySQL server because it reports that Host '192.168.0.12' is not allowed to connect to this MySQL server. The weird thing about this message is that I'm trying to connect to 192.168.0.1 and not 192.168.0.12. It seems this is a permissions issue. Any suggestions would be appreciated. - 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: MySQL Manager Connection Config Problem
Hi Generally root is only allowed access from local host for security. Either use a GRANT statement to give access from the host you are using or create another user with the appropriate permissions. Not sure about the IP missmatch. HTH Peter --- Excellence in internet and open source software --- Sunmaia www.sunmaia.net tel. 0121-242-1473 --- -Original Message- From: John Hanley [mailto:[EMAIL PROTECTED]] Sent: 08 September 2002 20:13 To: [EMAIL PROTECTED] Subject: MySQL Manager Connection Config Problem Hello. I'm running MySQL 3.23.29a-gamma on RH Linux 7.0. I would like to administer my database from a Win98se client on the same network and installed EMS's MySQL Manager 1.8. This appears to be an excellent tool and can't wait to get started. Unfortunately I'm having a problem getting the connection configuration setup correctly. Note that accessing the database from the Linux side works perfectly. The local NIC on my Linux server is assigned 192.168.0.1 and my Win98 workstation is 192.168.0.12. In the Configuration Info dialog, I enter 192.168.0.1 for Host, Port 3306, User Name Root, Password [mypass] and Database mysql. I know that MySQL Manager sees my MySQL server because it reports that Host '192.168.0.12' is not allowed to connect to this MySQL server. The weird thing about this message is that I'm trying to connect to 192.168.0.1 and not 192.168.0.12. It seems this is a permissions issue. Any suggestions would be appreciated. - 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: MySQL Manager Connection Config Problem
Odds are you have not granted your 'root' user rights to login from a node on the network. Instea dof using root, I would suggest you create another user with rights to login across the network. - Original Message - From: John Hanley [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: Sunday, September 08, 2002 3:12 PM Subject: MySQL Manager Connection Config Problem Hello. I'm running MySQL 3.23.29a-gamma on RH Linux 7.0. I would like to administer my database from a Win98se client on the same network and installed EMS's MySQL Manager 1.8. This appears to be an excellent tool and can't wait to get started. Unfortunately I'm having a problem getting the connection configuration setup correctly. Note that accessing the database from the Linux side works perfectly. The local NIC on my Linux server is assigned 192.168.0.1 and my Win98 workstation is 192.168.0.12. In the Configuration Info dialog, I enter 192.168.0.1 for Host, Port 3306, User Name Root, Password [mypass] and Database mysql. I know that MySQL Manager sees my MySQL server because it reports that Host '192.168.0.12' is not allowed to connect to this MySQL server. The weird thing about this message is that I'm trying to connect to 192.168.0.1 and not 192.168.0.12. It seems this is a permissions issue. Any suggestions would be appreciated. - 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
MySQL inserting into db (used load data)
I got the file using load data infile (transfer) [root@atsome host]# mysql -uroot db file.sql ERROR 2006 at line 1: MySQL server has gone away When i try to do this command it issues this error, whay is that? I also tried doing integritycheck on my db. No problem actually. Thanks, Louie... - 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
newbie questions...
Hi, I'm new to this list, and have a few basic MySql questions: * Is it safe to convert a timestamp field to a datetime one? ie: will this 'touch' each row and stuff up the ordering (hopefully not!). * I'm building a BBS application that needs to keep track of 'child counts'. Currently, I'm using integer 'count' fields for this and manually updating 'parent' counts where necessary. Would it be better to just use 'count(*)' instead where possible? Would this be slower? If I index the fields to be counted, would this end up wasting/saving disk-space? Finally...MySql is GREAT! I have a complete BBS application up and running, coded 'from scratch' with no prior SQL knowledge based just on the MySql package and docs. Of course, its now in dire need of cleaning up! Sincerely, Mark Sibly, Blitz Research Ltd - 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
How to retrieve Insert Into Select From records effected
Hello, How can I determin what erros occur from an Insert into select from statement? Namely, I'm looking for any duplicate record errors. It is important to inform the user (in a web browser) whether or not a particular insert would fail. Must I perform a lookup first, or is there a way to capture this error, or look up a list of errors for the last SQL command. Thanks, Karl - 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
Upgrading
Hi! I have a number of tables in development in 3.22.32 (running in apache_1.3.12 on a linux kernel) I'd really like to upgrade to 3.23.49a but my installs in both rpm and binary have not succeeded in taking over from my previous install. I've read quite a bit at the mysql.com site, but haven't found the appropriate documentation ... my last attempt was by downloading MySQL-3.23.49-1.src.rpm, 0. Turn off current Web Server (/etc/rc.d/init.d/httpd stop) 1. cp MySQL-3.23.49-1.src.rpm into /usr/local 2. rpm --recompile MySQL-3.23.49-1.src.rpm 3. mysql-3.23.49a-pc-linux-gnu-i686]# ./bin/safe_mysqld// To start MySQL use it This returns: Starting mysqld daemon with databases from /usr/local/m ysql-3.23.49a-pc-linux-gnu-i686/data 020908 15:53:33 mysqld ended And the Mysql database driven website works... Yet, when I want to go into line commands (to alter tables for easy searching) using: mysql-3.23.49a-pc-linux-gnu-i686]# ./bin/mysql I get ERROR 2002: Can't connect to local MySQL server through socket '/tmp/mysql.sock' (111) There is no file by that name there... Well thankyou for any help :-) Richard - 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: Upgrading
Update: Now, after rebooting the server, the site can't connect...that's more like it ;) -Original Message- From: Richard W. Berriman [mailto:[EMAIL PROTECTED]] Sent: Sunday, September 08, 2002 4:43 PM To: [EMAIL PROTECTED] Subject: Upgrading Hi! I have a number of tables in development in 3.22.32 (running in apache_1.3.12 on a linux kernel) I'd really like to upgrade to 3.23.49a but my installs in both rpm and binary have not succeeded in taking over from my previous install. I've read quite a bit at the mysql.com site, but haven't found the appropriate documentation ... my last attempt was by downloading MySQL-3.23.49-1.src.rpm, 0. Turn off current Web Server (/etc/rc.d/init.d/httpd stop) 1. cp MySQL-3.23.49-1.src.rpm into /usr/local 2. rpm --recompile MySQL-3.23.49-1.src.rpm 3. mysql-3.23.49a-pc-linux-gnu-i686]# ./bin/safe_mysqld// To start MySQL use it This returns: Starting mysqld daemon with databases from /usr/local/m ysql-3.23.49a-pc-linux-gnu-i686/data 020908 15:53:33 mysqld ended And the Mysql database driven website works... Yet, when I want to go into line commands (to alter tables for easy searching) using: mysql-3.23.49a-pc-linux-gnu-i686]# ./bin/mysql I get ERROR 2002: Can't connect to local MySQL server through socket '/tmp/mysql.sock' (111) There is no file by that name there... Well thankyou for any help :-) Richard - 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
Single User Application Install
I wrote an application that will be using MYSQL as the backend database. The software will be meant to run on a single non networked, Windows machine. Does anyone have any ideas on how I might install the MYSQL server software and the odbc drivers without having the user installing it and configuring it on their own? I want the install to be seamless and easy. (Even know it is easy already) My application will already have it's own setup and this is where I would like to copy any necessary files for the mysql server and odbc. Any help or suggestions will be appreciated. Aaron - 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
LOAD DATA LOCAL INFILE not allowed this version?
The command LOAD DATA LOCAL INFILE C:\\MO10.txt INTO TABLE stud1 fields terminated by / lines terminated by '\r\n'; produces: ERROR 1148 at line 1: The used command is not allowed with this MySQL vers Could someone explain why?? I'm running version MYSQL Ver 11.18 Distrib 3.23.51, for Win95/Win98 (i32) under WinXP Home standalone (i.e., no network, just one machine). I used to do this routinely under Win Me. Thanks in advance, Uriel - 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 DATA LOCAL INFILE not allowed this version?
One can disable all LOAD DATA LOCAL commands in the MySQL server by starting mysqld with --local-infile=0. In the case that LOAD DATA LOCAL INFILE is disabled in the server or the client, you will get the error message (1148): The used command is not allowed with this MySQL version http://www.mysql.com/doc/en/LOAD_DATA_LOCAL.html -Original Message- From: Uriel Wittenberg [mailto:[EMAIL PROTECTED]] Sent: 08 September 2002 16:24 To: [EMAIL PROTECTED] Subject: LOAD DATA LOCAL INFILE not allowed this version? The command LOAD DATA LOCAL INFILE C:\\MO10.txt INTO TABLE stud1 fields terminated by / lines terminated by '\r\n'; produces: ERROR 1148 at line 1: The used command is not allowed with this MySQL vers Could someone explain why?? I'm running version MYSQL Ver 11.18 Distrib 3.23.51, for Win95/Win98 (i32) under WinXP Home standalone (i.e., no network, just one machine). I used to do this routinely under Win Me. Thanks in advance, Uriel - 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
Escaping characters in select query problem...
I am having trouble with an sql query. I have a table with a column that has an '#' sign in the name. The problem is I can't seem to escape the column name to be able to select it. IE: select test#1 from test or select `test#1` from test Both don't work and i get the error Unknown column 'test' in 'field list'. Anyone know what I can do to fix it? Thx.. Mike _ Join the worlds largest e-mail service with MSN Hotmail. http://www.hotmail.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: Replications...
Jeremy Zawodny ([EMAIL PROTECTED]) wrote: On Sun, Sep 08, 2002 at 03:30:35AM +, Sam Przyswa wrote: Jeremy Zawodny ([EMAIL PROTECTED]) écrivait: On Fri, Sep 06, 2002 at 03:52:24PM +, Sam Przyswa wrote: Hi, Does the next MySQL 4.x version will support cross replications between several master servers in cluster ? Multi-master replication works as well in 4.x as it does in 3.23.xx. Does multi-master mean master to master, imagine you have 3 MySQL servers, A, B, C, with a load balancer in front end, if we make an update on A, is it possible to replicate/sync the change on B and C ? You want to do this? Thanks for the link, there is a lot of interesting things ! http://jeremy.zawodny.com/mysql/managing-mysql-replication_files/slide0121.htm Just make B a slave of A, C a slave of B, and A a slave of C. This is a good approach. Beware of using auto-increments in that scanario, though. You'll be rather surprised and frustrated as explained in the manual. We are thinking about a parallel replication by use the Spread Toolkit (www.spread.org) to broadcast the writes queries on all the servers in the same time and only once with the guaranty that the messages are well received by each server, and load balance the read queries. Then we can have a very scalable clustering solution with a minimum network load. What do you think about this concept, perhaps we can find a workaround for the auto-increment problem. Many thanks for your advices. Sam. - 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: Replications...
On Sun, Sep 08, 2002 at 11:53:41PM +, Sam Przyswa wrote: Jeremy Zawodny ([EMAIL PROTECTED]) wrote: Does multi-master mean master to master, imagine you have 3 MySQL servers, A, B, C, with a load balancer in front end, if we make an update on A, is it possible to replicate/sync the change on B and C ? You want to do this? Thanks for the link, there is a lot of interesting things ! http://jeremy.zawodny.com/mysql/managing-mysql-replication_files/slide0121.htm Just make B a slave of A, C a slave of B, and A a slave of C. This is a good approach. Except that it's fragile. One machine can go down and break the cycle unforunately. :-( Beware of using auto-increments in that scanario, though. You'll be rather surprised and frustrated as explained in the manual. We are thinking about a parallel replication by use the Spread Toolkit (www.spread.org) to broadcast the writes queries on all the servers in the same time and only once with the guaranty that the messages are well received by each server, and load balance the read queries. Then we can have a very scalable clustering solution with a minimum network load. Yeah, putting Spread support in MySQL for something like that might not be a bad idea. What do you think about this concept, perhaps we can find a workaround for the auto-increment problem. I've talked with two of the MySQL developers (Monty and Nick) about solving auto-increment problem. After my Replication talk at OSCON 2002, we kicked around some ideas that seemed quit promising. I just don't know when they'll be implemented. Hopefully Nick has them on his TODO list. :-) Jeremy -- Jeremy D. Zawodny | Perl, Web, MySQL, Linux Magazine, Yahoo! [EMAIL PROTECTED] | http://jeremy.zawodny.com/ MySQL 3.23.51: up 33 days, processed 671,775,990 queries (230/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
Re: NEWBIE: normalization question/help/lost :)
After a year of doing database programming, try to actually normalize. Read a couple online tutorials (phpbuilder, devshed) and the book mysql 2nd edition and it just can't seem to stick. Understanding the concept/theory but freeze up every time I try to implement. Trying to go from 0NF--3NF (though I can't even really get to 1NF :) ... not worried about 4NF or 5NF. Anybody want to help walk me through this or point to any GOOD FULL EXAMPLES of normalizing a database. I highly reccomend 'Database Design for Mere Mortals' by Michael J. Hernandez ISBN: 0-201-69471-9 or 'Data Databases: Concepts in Practice' by Joe Celko ISBN: 1-55860-432-4 They have both added much to my understandinf of RDBMs and information management. -- /* All outgoing email scanned by Norton Antivirus 2002 */ Amer Neely, Softouch Information Services W: www.softouch.on.ca E: [EMAIL PROTECTED] V: 519.438.5887 Perl | PHP | MySQL | CGI programming for all data entry forms. We make web sites work! - 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: MySQL inserting into db (used load data)
I had that once and it was due to the fact that the data I was trying to put into the database was bigger the 1M (1M is the default) per insert I had to start mysqld with ' -O max_allowed_packet=3M' On Mon, 9 Sep 2002, louie miranda wrote: I got the file using load data infile (transfer) [root@atsome host]# mysql -uroot db file.sql ERROR 2006 at line 1: MySQL server has gone away When i try to do this command it issues this error, whay is that? I also tried doing integritycheck on my db. No problem actually. Thanks, Louie... - 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: Can't link with C API
Ben Goodwin said: [Charset iso-8859-1 unsupported, filtering to ASCII...] Based on the prefix for your MySQL installation (--prefix=/usr/local/mysql '), you're not using the right paths. You need to set the -Idirectory to be where your mysql.h file is, and the -Ldirectory to be where your libmysqlclient.so (or .a if compiling static) file is. I'd recommend trying the following values MYSQLFLAGS = -I/usr/local/mysql/include/mysql MYSQLLIBS = -L/usr/local/mysql/lib/mysql -lmysqlclient That may not be quite right - check for the locations of the above-mentioned files and adjust if need be. That path isn't where mysql is installed. I checked the paths; my makefile has the correct path. CC can find the header files, and the linker can find the lib (using truss I can see the linker open the file). I'm not sure where the --prefix cam frome. Is that a compile-time option? I didn't actually compile the MySQL DB myself. I downlaoded the Solaris tar. Thanks for your help! Steve Cogorno Sun Microsystems - 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: Can't link with C API
rm said: Steve, in this line: MYSQLLIBS = -L /work/doctools/mysql-3.23.52/lib -lmysqlclient Try eliminating the space between -L and /work/ that format always works for me using gcc. Other than that, I don't see anything that looks wrong. Thanks for the suggestion. I just modified the makefile and tried again. no luck. I don't know what it could be! Steve Cogorno Sun Microsystems - 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 DATA LOCAL INFILE not allowed this version?
I'm not doing that. I'm doing C:mysql -r -N fall02 \mysqluw\mysql.txt (i.e. using the mysql command from DOS, and running a batch file) And I didn't change any configuration defaults since installing mySQL on this machine. - Original Message - From: Sqlcoders.com Programming Dept [EMAIL PROTECTED] To: Uriel Wittenberg [EMAIL PROTECTED]; Mysql [EMAIL PROTECTED] Sent: Monday, September 09, 2002 8:31 AM Subject: RE: LOAD DATA LOCAL INFILE not allowed this version? One can disable all LOAD DATA LOCAL commands in the MySQL server by starting mysqld with --local-infile=0. In the case that LOAD DATA LOCAL INFILE is disabled in the server or the client, you will get the error message (1148): The used command is not allowed with this MySQL version http://www.mysql.com/doc/en/LOAD_DATA_LOCAL.html -Original Message- From: Uriel Wittenberg [mailto:[EMAIL PROTECTED]] Sent: 08 September 2002 16:24 To: [EMAIL PROTECTED] Subject: LOAD DATA LOCAL INFILE not allowed this version? The command LOAD DATA LOCAL INFILE C:\\MO10.txt INTO TABLE stud1 fields terminated by / lines terminated by '\r\n'; produces: ERROR 1148 at line 1: The used command is not allowed with this MySQL vers Could someone explain why?? I'm running version MYSQL Ver 11.18 Distrib 3.23.51, for Win95/Win98 (i32) under WinXP Home standalone (i.e., no network, just one machine). I used to do this routinely under Win Me. Thanks in advance, Uriel - 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: Single User Application Install
Can't your deployment package include all the required files? Visual Basic does this nicely. .b -- ben joyce // [EMAIL PROTECTED] // +44 (0)7958 933718 Quoting Aaron [EMAIL PROTECTED]: I wrote an application that will be using MYSQL as the backend database. The software will be meant to run on a single non networked, Windows machine. Does anyone have any ideas on how I might install the MYSQL server software and the odbc drivers without having the user installing it and configuring it on their own? I want the install to be seamless and easy. (Even know it is easy already) My application will already have it's own setup and this is where I would like to copy any necessary files for the mysql server and odbc. Any help or suggestions will be appreciated. Aaron - 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 - This mail sent through IMP: http://horde.org/imp/ - 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 to cleanly uninstall
Spiros, linux:/home/db/TMPOUT # rpm -q mysql package mysql is not installed linux:/home/db/TMPOUT # rpm -qa | grep MySQL MySQL-shared-4.0.3-0 MySQL-client-4.0.3-0 MySQL-devel-4.0.3-0 MySQL-4.0.3-0 linux:/home/spiros/TMPOUT # Ok. mypc@linux:~ /usr/bin/mysql ERROR 2002: Can't connect to local MySQL server through socket '/var/lib/mysql/mysql.sock' (2) mypc@linux:~ /usr/bin/mysqld_safe /usr/bin/mysqld_safe: my_print_defaults: command not found The file /usr/sbin/mysqld doesn't exist or is not executable Please do a cd to the mysql installation directory and restart this script from there as follows: ./bin/mysqld_safe. @linux:~ Does this mean the rpm is no good? What next Possibly. What version of Linux are you using? DSL -- Con te partiro, su navi per mari Che io lo so, no, no non esistono piu Con te io li vivro. (Sartori F, Quarantotto E) - 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: Replications...
Jeremy Zawodny ([EMAIL PROTECTED]) wrote: http://jeremy.zawodny.com/mysql/managing-mysql-replication_files/slide0121.htm Just make B a slave of A, C a slave of B, and A a slave of C. This is a good approach. Except that it's fragile. One machine can go down and break the cycle unforunately. :-( Yes, this is the problem and why a spread solution should be more robust, we have just to find a procedure to re-sync a node after a crash. We are thinking about a parallel replication by use the Spread Toolkit (www.spread.org) to broadcast the writes queries on all the servers in the same time and only once with the guaranty that the messages are well received by each server, and load balance the read queries. Then we can have a very scalable clustering solution with a minimum network load. Yeah, putting Spread support in MySQL for something like that might not be a bad idea. Perhaps we can use the binary log mechanism in output and input with Spread to broadcast the changes, then the load balancer send the queries on the pool servers and only the write queries should be broadcasted by the server who received it, then each server become master or slave or both since Spread has ordered messages. First we have thinking to use Spread to manage locks and thread communications among nodes in a cluster to use distributed filesystem but it's a big deal ! I've talked with two of the MySQL developers (Monty and Nick) about solving auto-increment problem. After my Replication talk at OSCON 2002, we kicked around some ideas that seemed quit promising. I just don't know when they'll be implemented. Hopefully Nick has them on his TODO list. :-) Good ! Perhaps we can begin a new project... Sam. - 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
can't install mysql-4.0.3 with innodb
Hello I just installed mysql 4.0.3-beta for innoDB 1.I deleted my existing mysql4.0.3, my.ini and my.cnf files 2.I created a new my.cnf file and copied to c:\winnt directory The contents being # Example mysql config file. # Copy this file to c:\my.cnf to set global options # # One can use all long options that the program supports. # Run the program with --help to get a list of available options # This will be passed to all mysql clients [client] #password=my_password port=3306 #--uncommented-- #socket=MySQL # Here is entries for some specific programs # The following values assume you have at least 32M ram # The MySQL server [mysqld] port=3306 #socket=MySQL skip-locking set-variable= key_buffer=16M set-variable= max_allowed_packet=1M set-variable= table_cache=64 set-variable= sort_buffer=512K set-variable= net_buffer_length=8K set-variable= myisam_sort_buffer_size=8M server-id = 1 # Uncomment the following if you want to log updates #log-bin # Uncomment the following rows if you move the MySQL distribution to another # location #basedir = d:/mysql/ #datadir = d:/mysql/data/ # Uncomment the following if you are NOT using BDB tables #skip-bdb # Uncomment the following if you are using BDB tables #set-variable = bdb_cache_size=4M #set-variable = bdb_max_lock=1 # Uncomment the following if you are using Innobase tables #---uncommented on 09/09/2002 and autoextend is added. minimum size is set at 300M innodb_data_file_path = ibdata1:300M:autoextend:max:1000M innodb_data_home_dir = e:\mysql\ibdata innodb_log_group_home_dir = e:\mysql\iblogs innodb_log_arch_dir = e:\mysql\iblogs set-variable = innodb_mirrored_log_groups=1 set-variable = innodb_log_files_in_group=3 set-variable = innodb_log_file_size=5M set-variable = innodb_log_buffer_size=8M innodb_flush_log_at_trx_commit=1 innodb_log_archive=0 set-variable = innodb_buffer_pool_size=16M set-variable = innodb_additional_mem_pool_size=2M set-variable = innodb_file_io_threads=4 set-variable = innodb_lock_wait_timeout=50 [mysqldump] quick set-variable= max_allowed_packet=16M [mysql] no-auto-rehash # Remove the next comment character if you are not familiar with SQL #safe-updates [isamchk] set-variable= key_buffer=20M set-variable= sort_buffer=20M set-variable= read_buffer=2M set-variable= write_buffer=2M [myisamchk] set-variable= key_buffer=20M set-variable= sort_buffer=20M set-variable= read_buffer=2M set-variable= write_buffer=2M [mysqlhotcopy] interactive-timeout 3.From %MYSQL_HOME%\bin I executed the following %MYSQL_HOME%\bin\mysqld-max-nt --remove output is The service doesn't exists! 4.%MYSQL_HOME%\bin\mysqld-max-nt.exe --install Service successfully installed. 5.Then I did the following %MYSQL_HOME%\bin\mysqld-max --standalone But even after half an hour nothing happened. I did not receive any thing like InnoDB: The first specified datafile c:\ibdata\ibdata1 did not exist: InnoDB: a new database to be created! InnoDB: Setting file c:\ibdata\ibdata1 size to 209715200 - as stated in the mysql manual Can somebody help me , what I am doing wrong? Regards - 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: Can't link with C API
That path isn't where mysql is installed. I checked the paths; my makefile has the correct path. CC can find the header files, and the linker can find the lib (using truss I can see the linker open the file). I'm not sure where the --prefix cam frome. Is that a compile-time option? I didn't actually compile the MySQL DB myself. I downlaoded the Solaris tar. The --prefix came from your mysqlbug information (near the bottom). Can you type this command in and paste the exact output here? /usr/bin/ldd /work/doctools/mysql-3.23.52/lib/libmysqlclient.so It might also be helpful to cut-n-paste the entire output of 'make' so we can verify things look the way they should. Note: You should also have '-R /work/doctools/mysql-3.23.52/lib' since Solaris is not going to search that directory for the MySQL library at runtime. Add that to your MYSQLLIBS section. This won't fix the compilation issue, but you'll need it to run the 'TEST' program. -=| Ben - 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 to cleanly uninstall
Thanks It's 2.4.18 So, I will try to unistall and install from the tarball, yes? Spiros, linux:/home/db/TMPOUT # rpm -q mysql package mysql is not installed linux:/home/db/TMPOUT # rpm -qa | grep MySQL MySQL-shared-4.0.3-0 MySQL-client-4.0.3-0 MySQL-devel-4.0.3-0 MySQL-4.0.3-0 linux:/home/spiros/TMPOUT # Ok. mypc@linux:~ /usr/bin/mysql ERROR 2002: Can't connect to local MySQL server through socket '/var/lib/mysql/mysql.sock' (2) mypc@linux:~ /usr/bin/mysqld_safe /usr/bin/mysqld_safe: my_print_defaults: command not found The file /usr/sbin/mysqld doesn't exist or is not executable Please do a cd to the mysql installation directory and restart this script from there as follows: ./bin/mysqld_safe. @linux:~ Does this mean the rpm is no good? What next Possibly. What version of Linux are you using? DSL -- Con te partiro, su navi per mari Che io lo so, no, no non esistono piu Con te io li vivro. (Sartori F, Quarantotto E) - 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 to cleanly uninstall
Hmmm, (mysql, query) Thanks That's OK. It's 2.4.18 Sorry, I meant distribution...eg is it RedHat, Slackware ;-? So, I will try to unistall and install from the tarball, yes? It wouldn't hurt. How did you install it in the first place? DSL -- Con te partiro, su navi per mari Che io lo so, no, no non esistono piu Con te io li vivro. (Sartori F, Quarantotto E) - 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