Connecting to MySQL
hi, I was trying to connect to MySQL server but after typing in the password, I got "can't connect to local MySQL server through socket '' (111) " I can connect to MySQL server thought regular terminal but for some reason It does not work when I am using MySQL GUI What's wrong with it? Thanks for your help. Doddy Sebastianus - 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 from 3.23.34 to 3.23.37
Estimated gurus. I'd like to know if is it essential to upgrade from 3.23.34 to 3.23.37 or changes are not very important. In case of necessary, how can I do this upgrading?? Downloading binary file or RPM file?? Is there any process to upgrade MySQL automaticaly?? Thank you very much
Re: hang problem with mysql
Vladimir Kukuruzovic writes:
On Friday 20 April 2001 16:25, you wrote:
Hi,
I am using several mysql servers as a support for a high traffic site. The
problem is that from time to time, and during last few days daily :,
mysql hangs. It hangs so bad that even kill -9 can't kill it, the process
is still there. :(
Now, a little info about my setup:
# gcc -v
Reading specs from /usr/lib/gcc-lib/i386-redhat-linux/egcs-2.91.66/specs
gcc version egcs-2.91.66 19990314/Linux (egcs-1.1.2 release)
rh6.2, linux kernel 2.4.3, intel platform, dual PIII/800, 1G ram.
mysql: 3.23.37, but the problems are here even with 3.23.32 :( No special
configure options (just --prefix) :)
any suggestions? where should I look?
Regards, Vladimir
Btw, I upgraded glibc to 2.2.2, and gcc to 2.95.1
and now, when I compile mysql with new glibc, load goes sky high, and anfer a
while mysql hangs again.
Right now, I left glibc to 2.2.2, and started mysql 3.23.36 compiled against
old libraries, and now at least load isn't 40+, and mysql manages to stay
alive longer.
Vladimir
--
Phone numbers: home: +38111459023 mobile: +381641161792
Hi!
Please try our binaries and follow recommandations from the manual on
running multi0ple servers.
Regards,
Sinisa
__ _ _ ___ == MySQL AB
/*/\*\/\*\ /*/ \*\ /*/ \*\ |*| Sinisa Milivojevic
/*/ /*/ /*/ \*\_ |*| |*||*| mailto:[EMAIL PROTECTED]
/*/ /*/ /*/\*\/*/ \*\|*| |*||*| Larnaca, Cyprus
/*/ /*/ /*/\*\_/*/ \*\_/*/ |*|
/*/^^^\*\^^^
/*/ \*\Developers Team
-
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: why doesn't this work? (C code)
Hi!
As our manual clearly describes one connection can be used for one
query at a time, unless you use threads and mutexes.
Regards,
Sinisa
__ _ _ ___ == MySQL AB
/*/\*\/\*\ /*/ \*\ /*/ \*\ |*| Sinisa Milivojevic
/*/ /*/ /*/ \*\_ |*| |*||*| mailto:[EMAIL PROTECTED]
/*/ /*/ /*/\*\/*/ \*\|*| |*||*| Larnaca, Cyprus
/*/ /*/ /*/\*\_/*/ \*\_/*/ |*|
/*/^^^\*\^^^
/*/ \*\Developers Team
-
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: bug report
Andrew Schmidt writes:
Description:
tough one to describe. the step by step example shows all
basicly once a table gets more than 1 row and doing a select with no
result will yield a blank date... gah please see the example =)
How-To-Repeat:
create database tmpdb;
use tmpdb;
create table test (foo int);
insert into test values (1);
select NOW(), count(*) from test where foo in (2);
+-+--+
| NOW() | count(*) |
+-+--+
| 2001-04-20 17:21:29 |0 |
+-+--+
insert into test values (1);
select NOW(), count(*) from test where foo in (2);
+---+--+
| NOW() | count(*) |
+---+--+
| |0 |
+---+--+
notice the date field is blank.
Fix:
how to correct or work around the problem, if known (multiple lines)
Submitter-Id: submitter ID
Originator:Andrew Schmidt
Organization:
organization of PR author (multiple lines)
MySQL support: [none | licence | email support | extended email support ]
Synopsis: synopsis of the problem (one line)
Severity: [ non-critical | serious | critical ] (one line)
Priority: [ low | medium | high ] (one line)
Category: mysql
Class: [ sw-bug | doc-bug | change-request | support ] (one line)
Release: mysql-3.23.37 (Source distribution)
Environment:
machine, os, target, libraries (multiple lines)
System: FreeBSD wrk-112.tor1.targetnet.pvt 4.2-STABLE-20010112-JPSNAP
FreeBSD 4.
2-STABLE-20010112-JPSNAP #0: Thu Jan 11 20:06:54 GMT 2001
[EMAIL PROTECTED]
reebsd.org:/usr/src/sys/compile/GENERIC i386
Some paths: /usr/bin/perl /usr/bin/make /usr/local/bin/gmake /usr/bin/gcc
/usr/
bin/cc
GCC: Using builtin specs.
gcc version 2.95.2 19991024 (release)
Compilation info: CC='gcc' CFLAGS='' CXX='c++' CXXFLAGS='' LDFLAGS=''
LIBC:
-r--r--r-- 1 root wheel 1169222 Jan 11 14:28 /usr/lib/libc.a
lrwxrwxrwx 1 root wheel 9 Jan 19 13:01 /usr/lib/libc.so - libc.so.4
-r--r--r-- 1 root wheel 559420 Jan 11 14:28 /usr/lib/libc.so.4
Configure command:
./configure --localstatedir=/usr/local/var/db/mysql --withou
t-perl --without-debug --without-readline --without-bench --enable-assembler
--e
nable-thread-safe-client
Perl: This is perl, version 5.005_03 built for i386-freebsd
Hi!
Thank you for a repeatable bug report.
Regards,
Sinisa
__ _ _ ___ == MySQL AB
/*/\*\/\*\ /*/ \*\ /*/ \*\ |*| Sinisa Milivojevic
/*/ /*/ /*/ \*\_ |*| |*||*| mailto:[EMAIL PROTECTED]
/*/ /*/ /*/\*\/*/ \*\|*| |*||*| Larnaca, Cyprus
/*/ /*/ /*/\*\_/*/ \*\_/*/ |*|
/*/^^^\*\^^^
/*/ \*\Developers Team
-
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 avoid newline character?
When I load data into a mysql table from a simple tab delimeted textfile I prepared in a regular texteditor (notepad) using the "load data infile" command there is a newline character at the end of the text in every last column. How do I get rid of this newline character or are there alternative methods of quickly loading data into a table. Thanks for your hints and tips. __ Do You Yahoo!? Yahoo! Auctions - buy the things you want at great prices http://auctions.yahoo.com/ - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Upgrading from 3.23.30
In the MySQL documentation section that covers upgrades, it discusses the process of upgrading between major releases. If I am upgrading MySQL within a major version, say from 3.23.30 to 3.23.36, is it as simple as just replacing mysqld? Regards, Gary "SuperID" Huntress === FreeSQL.org offering free database hosting to developers Visit http://www.freesql.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
how do i?
if have a static ip address, apache web server, mysql, myodbc and JDBC all working fine on Windows 98 platform. My basic question is how do i integrate these to have a form on a web page say on my Apache web server, dump the information a user submits into a sql database? I basically need help on getting the apache web server working with some Java servlets that I will write any assistance and I'll be greatful. Thank You, Neil Patel [EMAIL PROTECTED] www.neilesh.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
Installing MySQL on Linux Mandrake
I've loaded Linux for the first time on a PC and wondered if I could get some advise on setting up MySQL on it. I would like to start off with the easiest/simplest method. Is that installing from an RPM? Is there an RPM for the latest stable version? Thanks In Advance, Lee Jenkins
Re: Mysql commands from Linux shell
On Fri, Apr 20, 2001 at 12:03:22PM -0300, Fabio Galarraga wrote: Hi to all: I have a linux script and I need it can execute some mysql commands. Is it possible? If possible, how? http://www.dataloss.nl/dteq/ (you probably want to disable DEBUGging in the Makefile). Greetz, Peter. - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
wrong dependency to db.h
Description: sql/Makefile.in has a dependency to ../bdb/build_unix/db.h at line 621. This file is not presence in mysql-3.23.37. How-To-Repeat: N/A Fix: delete the reference? Submitter-Id: submitter ID Originator:Christian Hammers Organization: Debian GNU/Linux distribution MySQL support: none Synopsis: wrong dependency to db.h in sql/Makefile.in Severity: non-critical Priority: medium Category: mysql Class: sw-bug Release: mysql-3.23.36 (Source distribution) Server: /usr/bin/mysqladmin Ver 8.18 Distrib 3.23.36, for pc-linux-gnu on i586 Copyright (C) 2000 MySQL AB MySQL Finland AB TCX DataKonsult AB This software comes with ABSOLUTELY NO WARRANTY. This is free software, and you are welcome to modify and redistribute it under the GPL license Server version 3.23.36-log Protocol version10 Connection Localhost via UNIX socket UNIX socket /var/run/mysqld/mysqld.sock Uptime: 3 hours 2 min 32 sec Threads: 1 Questions: 1 Slow queries: 0 Opens: 6 Flush tables: 1 Open tables: 0 Queries per second avg: 0.000 Environment: System: Linux lathspell 2.4.2 #4 Don Feb 22 18:51:59 CET 2001 i586 unknown Architecture: i586 Some paths: /usr/bin/perl /usr/bin/make /usr/bin/gcc /usr/bin/cc GCC: Reading specs from /usr/lib/gcc-lib/i386-linux/2.95.4/specs gcc version 2.95.4 20010319 (Debian prerelease) Compilation info: CC='gcc' CFLAGS='-O2 -fomit-frame-pointer -g' CXX='g++' CXXFLAGS='-O2 -fomit-frame-pointer -g -felide-constructors -fno-exceptions -fno-rtti' LDFLAGS='' LIBC: lrwxrwxrwx1 root root 14 17.04 20:05 /lib/libc.so.5 - libc.so.5.4.46 -rw-r--r--1 root root 567684 13.04 21:14 /lib/libc.so.5.4.46 lrwxrwxrwx1 root root 13 27.03 21:14 /lib/libc.so.6 - libc-2.2.2.so -rwxr-xr-x1 root root 1108076 13.04 16:15 /lib/libc-2.2.2.so -rw-r--r--1 root root 2526954 24.03 08:02 /usr/lib/libc.a -rw-r--r--1 root root 178 24.03 08:02 /usr/lib/libc.so -rw-r--r--1 root root 665260 01.09.2000 /usr/lib/libc-client.so.4.7 Configure command: ./configure --prefix=/usr --exec-prefix=/usr --libexecdir=/usr/sbin --datadir=/usr/share --sysconfdir=/etc/mysql --localstatedir=/var/lib/mysql --includedir=/usr/include --infodir=/usr/share/info --mandir=/usr/share/man --enable-shared --with-libwrap --enable-assembler --with-berkeley-db --with-innobase --enable-static --enable-shared --with-raid --without-readline --with-unix-socket-path=/var/run/mysqld/mysqld.sock --with-mysqld-user=mysql --without-bench --with-extra-charsets=all - 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: why doesn't this work? (C code)
On Sat, 21 Apr 2001 14:12:20 +0300 (EEST), Sinisa Milivojevic wrote: As our manual clearly describes one connection can be used for one query at a time, unless you use threads and mutexes. G'day As I said, it worked fine b4 and I got it to work again. I _assumed_ the reason it fell over was because of an unneccessary call to mysql_free_result(). Without actually having looked at MySql's source code, would it be logical to assume that a call to mysql_store_result() would free the 'cursor' resources as it's last act, and mysql_free_result() simply frees the 2D char array result set? If so, then I can't see where the problem would be This is a worry - I use this method (inner and outer cursors) all the time. (I come from using Sybase / embedded SQL - where you can declare cursors and use host variables) I'm only really using MySql because that's what most ISP's seem to provide. If this issue is going to cause me grief, I might have to find an ISP who provides Postgres...:-) 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
Slow replies (DNS problem?)
I read your manual, but the details aren't always covered. I want to add -skip-name-resolution the the my.ini file. That file doesn't seem to be anywhere, although the WinMySqlAdmin tool says yes there is one present. I know I can edit it from the tool, but what would I add to it? I'm using 3.23.36 on Win98 for learning purposes... I'm also having trouble displaying the whole admin -help information, because even though my DOS window has a scrollbar, 50 lines is the maximum number which can be viewed, and the beginning of the information simply disappears, never to to seen again! I'm working my way step by step through the manual. Mysql is installed successfully, up and running, starts stops. I've created a table in the test database, but can't insert data into any of the fields, don't know how to view the structure of the table, and wonder if mysql supports returning schema data using jdbc driver from mark mathews. Fun, but tedious.- pablo alonso, ventura, ca.
Re: Tables relationships
- Original Message - No, MySQL does not help in enforcing referential integrity. You need to do that with your application. In some people's opinion (not mine), it is one of the major drawbacks to using MySQL. I agree. MySQL needs to have RI as its first priority on its TODO list. ps I am a developer and am involved in MySQL for the past one year, and have installed it in around twenty different places with my front end app using MySQL. My main need is RI. Mani. M - 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: how to avoid newline character?
At 5:53 AM -0700 4/21/01, Andreas Antes wrote: When I load data into a mysql table from a simple tab delimeted textfile I prepared in a regular texteditor (notepad) using the "load data infile" command there is a newline character at the end of the text in every last column. How do I get rid of this newline character or are there alternative methods of quickly loading data into a table. Thanks for your hints and tips. It'd help if you showed your LOAD DATA statement, and also indicated what characters are actually at the end of each line of your data file. However, in general, if you specify a LINES TERMINATED BY clause that lists the line termination characters present in your file, the statement should eat those characters and they won't be interpreted as part of your column values. -- Paul DuBois, [EMAIL PROTECTED] - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: SQL Syntax question
Hi there, I'm using mysql 3.22.27 and get error when trying to run this select statement: SELECT custmls.mlsnumber,custmls.streetnumber,custmls.streetdirect, FORMAT(custmls.currentprice,0),custmls.streetnam,custmls.streetaddtl, custmls.municname,custmls.state,custmls.zipcd,custmls.salesassoc, ipix.url,custmls.listagentname,FORMAT(custmls.numrooms,0), FORMAT(custmls.numbedrooms,0),custmls.fullbaths FROM custmls,ipix where custmls.mlsnumber = ipix.mlsnumber AND custmls.listingoffice = 0251 AND (custmls.listingstatus = 'ACT' or custmls.listingstatus = 'A*') AND custmls.scategory = 1 ORDER BY custmls.currentprice The error is: "1064 You have an error in your SQL syntax near 'ON ipix custmls.mlsnumber = ipix.mlsnumber where custmls.listingoffice = 0251 AN' at line 1 " Any ideas? Thanks Pat Sir, the error message was obviously from an SQL statement other than the one you quote above. Since I don't know your table structure, I can't be sure what the problem is, but it looks like you are writing columns and tables as table_name.column_name. This is backwards. It should be column_name.table_name. The alternative is that you are selecting from a boat load of tables that aren't mentioned in the FROM clause. I see two problems with the snippet of SQL quoted in the error message. First of all, the word 'ipix' after ON isn't serving any function, other than to confuse MySQL. Secondly, you are trying to join two tables, but your ON clause joins a column from mlsnumber to another column from mlsnumber. If this is not the error mentioned above, then you need to join a column in mlsnumber to a column in the second table. Bob Hall Know thyself? Absurd direction! Bubbles bear no introspection. -Khushhal Khan Khatak MySQL list magic words: sql query database - 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
Error codes
Can someone point me to the documentation of the error codes returned by Mysql? I mean the ones you get back from DBI via "err". I couldn't find them in the online docs. - 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 XSQL (Solaris/Apache/Jserv)
I'm trying to get the Oracle XSQL servlet to work with MySQL (through the mm.mysql.jdbc-1.2c driver) under Solaris but I keep getting the following error message (using the xsql command-line tool): --- % sh $XSQL/bin/xsql test.xsql test.htm Oracle XSQL Command Line Page Processor 1.0.4.1 (Production) XSQL-007: Cannot acquire a database connection to process page. Cannot disable AUTO_COMMIT --- My configuration is: test.xsql - ?xml version="1.0"? DbTest elt="query" xmlns:xsql="urn:oracle-xsql" connection="xsqlDsin" xsql:query SELECT * AS text FROM text /xsql:query /DbTest XSQLConfig.xml -- ... connection name="xsqlDsin" usernameUSER_NAME/username passwordPASSWORD/password dburljdbc:mysql://host:3306/xsqlDsinTest/dburl driverorg.gjt.mm.mysql.Driver/driver /connection ... jserv.conf -- ApJServAction .xsql /servlets/oracle.xml.xsql.XSQLServlet jserv.properties wrapper.classpath=/xsql/mm.mysql.jdbc-1.2c/org/gjt/mm/mysql/Driver.class - 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
compress problem when using MySQL++
I seem to have a problem similar to others, but none of the suggested solutions seem to solve it. It's the standard "undefined reference to `compress'" while using MySQL++. What am I missing. Many solutions appear to address libmysqlclient. So I'm not sure if the problem is MySQL or MySQL++ oriented (though MySQL is working fine and the MySQL++ examples make fine). $ make metamgrd gcc -c -g -I/usr/local/mysql metamgrd.C gcc -static metamgrd.o sock.o cfgfile.o cfgitem.o err.o -o ./metamgrd -lstdc++ -L/usr/lib/mysql -lz -lmysqlclient -lsqlplus /usr/lib/mysql/libmysqlclient.a(my_compress.o): In function `my_uncompress': my_compress.o(.text+0x97): undefined reference to `uncompress' /usr/lib/mysql/libmysqlclient.a(my_compress.o): In function `my_compress_alloc': my_compress.o(.text+0x126): undefined reference to `compress' collect2: ld returned 1 exit status make: *** [metamgrd] Error 1 I've remade a MySQL++ example for grins and it works fine. # make simple1 c++ -DHAVE_CONFIG_H -I. -I. -I.. -I../sqlplusint -I../sqlplusint -I/usr/local/mysql/include/mysql -g -O2 -c simple1.cc /bin/sh ../libtool --mode=link c++ -g -O2 -L/usr/local/mysql/lib/mysql -o simple1 simple1.o ../sqlplusint/libsqlplus.la -lz -lmysqlclient c++ -g -O2 -L/usr/local/mysql/lib/mysql -o .libs/simple1 simple1.o ../sqlplusint/.libs/libsqlplus.so -lz -lmysqlclient -lz -lmysqlclient -Wl,--rpath -Wl,/usr/local/lib creating simple1 Running simple1 causes a core dump, but I'm guessing that has to do with not having the appropriate db and dbaccess (didn't modify the code). I figured I'd start by using modified parts of the examples in my own app and that that would be just as good a test (if I can make it). I have checked and config.h for MySQL does have HAVE_COMPRESS defined. I've rebuilt MySQL and MySQL++ from scratch (started with the MySQL RPM install when I build the system - first time I've used development stuff from an RPM, so I decided to start from scratch just to make sure). gcc version 2.96 2731 (Red Hat Linux 7.0) Linux 2.2.16-22smp #1 SMP Tue Aug 22 16:39:21 EDT 2000 i686 unknown Help would be greatly appreciated. Thanks, William - 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
WinMySqlAdmin
Using version 3.23.36 on Win98 I see a problem with the new tool. On the databases tab I can view the databases and their tables in a tree view. If, in the right hand pane, I select my table, and wish to view its fields, I expect to see the field names, their datatypes, and other field-related information in a 7-column table-like display below called "Table Columns". Each row of this display corresponds to a field in the table. Those 7 columns are not resizable, but the main problem is that only six columns of information about each field are pulled from my table, therefore the field name of my second field falls into the wrong column in the "Table Columns" display (which incidentally is mis-spelled "previleges". Should be priveleges). Oops! - pablo alonso, ventura, ca.
Information Technique
Salut Mr/Mme, J'ai une question prcise : Comment coder les caractres spciaux (de type , ,..) dans une BDD MySql Le problme c'est que j'ai developp avec JSP un site en utilisant le Systme d'exploitation Windows (les essais taient positifs). Lors de l'hbergement, (Sur adgraphix) les caractres spciaux ne sont pas insrs correctement dans la BDD Par exemple devient ? J'espre avoir une rponse, mme si ngative Merci ___ Do You Yahoo!? -- Pour faire vos courses sur le Net, Yahoo! Shopping : http://fr.shopping.yahoo.com - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Mysql weird problem
Hello, i am developing a shopping cart with perl and mysql. The project almost finished is running fine on WinME with Mysql and Perl and Apache. Its running fine with Opera IE and Netscape. When i transfer the project on my protable running Win98,Opera and IE work but netscape just tries continuouosly to connect but nothing. I have copied exactly the folder of mysql and apache eactly to the same directories on my portable as on the desktop. I don't understand why this happens with netscape. I tried the suggestions in the manual for the DNS problem. Still the same. I start mysql with winmysqladmin-green light comes on ok. Do i need the file my.cnf in the root? Any suggestions please? 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
RE: Mysql weird problem
I think your problem is at the netscapeapache level, not the mysql level. Can you view static html pages served by your local apache with netscape? since netscape, opera, and IE all connect to apache, and then apache calls perl to connect to mysql, I doubt your problem has anything to do with perl or mysql. -Original Message- From: Haris [mailto:[EMAIL PROTECTED]] Sent: Saturday, April 21, 2001 6:11 PM To: [EMAIL PROTECTED] Subject: Mysql weird problem Hello, snip When i transfer the project on my protable running Win98,Opera and IE work but netscape just tries continuouosly to connect but nothing. snip - 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
