configuring MySQL for raid tables
MySQL's raid function says that it can use multiple drives/directories to put its database in to get over the 2GB limit. How do I configure MySQL to make sure that it knows about the drives when its instructed to create a table as RAID_TYPE = STRIPPED ? Would I put in my.cnf: [mysqld] datadir=/dbdata1:/dbdata2:/dbdata3 Or would I need to create the database and then move the files and use symlinks? Thanks, Jamie Krasnoo [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: Symbolic Links under Windows
Hello Tom, If you're using Windows 2000 it has junction points. It's almost the same as symbolic links in UNIX. Except it works only for directories. Try to find access to Windows 2000 Resource Kit, there should be a utility called linkd.exe. If you running NT 4.0, you can try to apply Service Pack 6(a) (it should give you NTFS 5.0 support), and try run linkd.exe. I haven't tried so, and Microsoft says that junction points is only available under Windows 2000 platform. Have a good time, Andrey Nepomnyaschih [EMAIL PROTECTED] -Original Message- From: Tom Bates [mailto:[EMAIL PROTECTED]] Sent: Sunday, May 20, 2001 1:51 AM To: [EMAIL PROTECTED] Subject: Symbolic Links under Windows I am trying to move my database (the directory) to another location, but the symbolic link option described in the documentation isn't working for me. I'm using the binary distribution of version 3.23.37. I created a text file in the c:\mysql\data directory, called mydb.sym, with the string c:\inetpub\wwwroot\mysite\database\mydb in it, and moved the directory to that location. No good. I even stopped and restarted the mysql service (I'm running on NT), but it still didn't work. What am I missing? Thanks Tom - 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
Error: 1114
Hello, wich is the meaning of this message. I don't have a table named 'SQL521ed_0': Message: General error: The table 'SQL521ed_0' is full SQLState: S1000 ErrorCode: 1114 Thanks Carlos Godoy - 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: Error: 1114
On Sun, 20 May 2001, Carlos Godoy wrote: Hello, wich is the meaning of this message. I don't have a table named 'SQL521ed_0': Message: General error: The table 'SQL521ed_0' is full SQLState: S1000 ErrorCode: 1114 From the very fine manual about the SET syntax: `SQL_BIG_TABLES = 0 | 1' If set to `1', all temporary tables are stored on disk rather than in memory. This will be a little slower, but you will not get the error `The table tbl_name is full' for big `SELECT' operations that require a large temporary table. The default value for a new connection is `0' (that is, use in-memory temporary tables). Thomas - 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: Symbolic Links under Windows
You can also download Junction from http://www.sysinternals.com/ntw2k/source/misc.shtml#junction which does the same thing. sql Hello Tom, If you're using Windows 2000 it has junction points. It's almost the same as symbolic links in UNIX. Except it works only for directories. Try to find access to Windows 2000 Resource Kit, there should be a utility called linkd.exe. If you running NT 4.0, you can try to apply Service Pack 6(a) (it should give you NTFS 5.0 support), and try run linkd.exe. I haven't tried so, and Microsoft says that junction points is only available under Windows 2000 platform. - 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: Running mySQL on a drive other than root
At 20:05 19/5/2001 +0100, James Cox wrote: Hi! Remove the service first: mysqld-nt --remove Create /winnt/my.ini file with the following section and keys: [mysqld] basedir=G:/mysql datadir=G:/mysql/data Install the service: g:\mysql\bin\mysqld-nt --install start the server: net start mysql Regards, Miguel Hi, I have been running an old version of the mySQL-nt server on my Windows 2000 box for some time now. It was installed on C:\ , as suggested in the install instructions. Now, I have a new disk, and so want to put the server on a partition, G:\ . After removing the service - I tried to reinstall it... but try as I might, I can't seem to get the thing to run. any suggestions? Thanks, James Cox __ ___ __ / |/ /_ __/ __/ __ \/ / http://www.mysql.com/ / /|_/ / // /\ \/ /_/ / /__ Miguel Solórzano [EMAIL PROTECTED] /_/ /_/\_, /___/\___\_\___/ São Paulo, Brazil ___/ Development 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
MySQL compile/install problems
Hi, I have HP-UX B.10.20 A 9000/811 2002798330 two-user license and mysql ./mysqladmin Ver 7.11 Distrib 3.22.23b, for hp-hpux10.20 on hppa1.1 instald from depot file. I'd like to upgrade to mysql-3.23.37. Here begin the problems. I try binary distribution from mysql.com. When I start scripts/mysql_install_db the result is: --- Preparing db table Preparing host table Preparing user table Preparing func table Preparing tables_priv table Preparing columns_priv table Installing all prepared tables 010520 14:25:52 Warning: setrlimit couldn't increase number of open files to mo re than 60 010520 14:25:52 Warning: Changed limits: max_connections: 50 table_cache: 64 scripts/mysql_install_db[292]: 12668 Memory fault(coredump) Installation of grant tables failed! Examine the logs in ./data for more information. You can also try to start the mysqld daemon with: ./bin/mysqld --skip-grant You can use the command line tool ./bin/mysql to connect to the mysql database and look at the grant tables: shell ./bin/mysql -u root mysql mysql show tables Try 'mysqld --help' if you have problems with paths. Using --log gives you a log in ./data that may be helpful. The latest information about MySQL is available on the web at http://www.mysql.com Please consult the MySQL manual section: 'Problems running mysql_install_db', and the manual section that describes problems on your OS. Another information source is the MySQL email archive. Please check all of the above before mailing us! And if you do mail us, you MUST use the ./bin/mysqlbug script! After I try to compile souce ditribution. Read carefuly all instuctions but no way without errors: gcc - 2.95.3 --- In file included from /opt/gcc/lib/gcc-lib/hppa1.1-hp-hpux10.20/2.95.3/include/s tdio.h:11, from ../include/global.h:155, from mysql.cc:28: /usr/include/sys/types.h:58: syntax error before `;' /usr/include/sys/types.h:79: syntax error before `;' /usr/include/sys/types.h:100: syntax error before `;' /usr/include/sys/types.h:121: syntax error before `;' /usr/include/sys/types.h:142: syntax error before `;' /usr/include/sys/types.h:268: syntax error before `;' In file included from ../include/global.h:155, from mysql.cc:28: /opt/gcc/lib/gcc-lib/hppa1.1-hp-hpux10.20/2.95.3/include/stdio.h:167: type speci fier omitted for parameter /opt/gcc/lib/gcc-lib/hppa1.1-hp-hpux10.20/2.95.3/include/stdio.h:167: parse erro r before `*' /opt/gcc/lib/gcc-lib/hppa1.1-hp-hpux10.20/2.95.3/include/stdio.h:168: parse erro r before `*' /opt/gcc/lib/gcc-lib/hppa1.1-hp-hpux10.20/2.95.3/include/stdio.h:525: syntax err or before `(' /opt/gcc/lib/gcc-lib/hppa1.1-hp-hpux10.20/2.95.3/include/stdio.h:526: type speci fier omitted for parameter /opt/gcc/lib/gcc-lib/hppa1.1-hp-hpux10.20/2.95.3/include/stdio.h:538: syntax err or before `(' /opt/gcc/lib/gcc-lib/hppa1.1-hp-hpux10.20/2.95.3/include/stdio.h:539: type speci fier omitted for parameter /opt/gcc/lib/gcc-lib/hppa1.1-hp-hpux10.20/2.95.3/include/stdio.h:540: type speci fier omitted for parameter /opt/gcc/lib/gcc-lib/hppa1.1-hp-hpux10.20/2.95.3/include/stdio.h:540: parse erro r before `*' /opt/gcc/lib/gcc-lib/hppa1.1-hp-hpux10.20/2.95.3/include/stdio.h:541: parse erro r before `*' /opt/gcc/lib/gcc-lib/hppa1.1-hp-hpux10.20/2.95.3/include/stdio.h:559: syntax err or before `(' /opt/gcc/lib/gcc-lib/hppa1.1-hp-hpux10.20/2.95.3/include/stdio.h:560: type speci fier omitted for parameter /opt/gcc/lib/gcc-lib/hppa1.1-hp-hpux10.20/2.95.3/include/stdio.h:560: parse erro r before `,' /opt/gcc/lib/gcc-lib/hppa1.1-hp-hpux10.20/2.95.3/include/stdio.h: In function `l ong int fseeko(...)': /opt/gcc/lib/gcc-lib/hppa1.1-hp-hpux10.20/2.95.3/include/stdio.h:560: `a' undecl ared (first use this function) /opt/gcc/lib/gcc-lib/hppa1.1-hp-hpux10.20/2.95.3/include/stdio.h:560: (Each unde clared identifier is reported only once /opt/gcc/lib/gcc-lib/hppa1.1-hp-hpux10.20/2.95.3/include/stdio.h:560: for each f unction it appears in.) /opt/gcc/lib/gcc-lib/hppa1.1-hp-hpux10.20/2.95.3/include/stdio.h:560: `b' undecl ared (first use this function) /opt/gcc/lib/gcc-lib/hppa1.1-hp-hpux10.20/2.95.3/include/stdio.h:560: `c' undecl ared (first use this function) /opt/gcc/lib/gcc-lib/hppa1.1-hp-hpux10.20/2.95.3/include/stdio.h: At top level: /opt/gcc/lib/gcc-lib/hppa1.1-hp-hpux10.20/2.95.3/include/stdio.h:573: type speci fier omitted for parameter /opt/gcc/lib/gcc-lib/hppa1.1-hp-hpux10.20/2.95.3/include/stdio.h:573: parse erro r before `*' /opt/gcc/lib/gcc-lib/hppa1.1-hp-hpux10.20/2.95.3/include/stdio.h:574: parse erro r before `*' /opt/gcc/lib/gcc-lib/hppa1.1-hp-hpux10.20/2.95.3/include/stdio.h:609: parse erro r before `}' In file
RE: Advice needed....
Well I was hoping to be able to do it in SQL, however I do know it can be accomplished in the middleware. I am seriously considering it as my deadline is approaching quickly Dave Carter Chief Web Architect Accelerated Business Technologies, Inc. http://www.abti.cc 717.464.2970 -Original Message- From: clay bond [mailto:[EMAIL PROTECTED]] Sent: Saturday, May 19, 2001 6:51 PM To: [EMAIL PROTECTED] Subject: Re: Advice needed On Sat, 19 May 2001, Dave Carter wrote: I'm converting an Access db to mySQL, and Access allows users to Insert Records into a table AND call them as well in the FROM clause. This is illeagal in ANSI SQL however and therefore illeagal in mySQL, but I don't know really how to get around it. How can I insert only new records that aren't already in a table, without calling the table first? Can this be done in SQL? But you're not working only with SQL, are you? Like transactions or foreign keys, you can easily do this in your middleware, whatever that might be (PHP, Perl, Coldfusion, whatever). Select first, then check to see if it's there, and if it isn't, insert it. A simple if-statement will do the job, so what's the problem? -- /\ \ /ASCII RIBBON CAMPAIGN X AGAINST HTML EMAIL / \AND POSTINGS - 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
Missing symbols in mysqlclient.lib in Win32
Hi, while trying to link the DBD::mysql driver on a Win32 machine I receive the following error message claiming about missing symbols __pctype and ___mb_cur_max in mysqlclient.lib. As you can see from the output below, I am linking against all .lib files in the MySQL distribution. The paths are right. I am not an experienced user, but in particular the symbol __pctype looks like it should be a header definition actually. I am using VC++ 6.0, SP3. Any hint welcome. Thanks, Jochen C:\Perl\bin\Perl.exe myld link -out:blib\arch\auto\DBD\mysql\mysql.dll -dll -nologo -nodefaultlib -release -libpath:C:\Perl\lib\CORE -machine:x86 dbdimp.obj mysql.obj C:\Perl\lib\CORE\perl56.lib c:\Prg\mysql\lib\opt\mysqlclient.lib c:\Prg\mysql\lib\opt\libmysql.lib c:\Prg\mysql\lib\opt\zlib.lib C:\prg\MVS\VC98\lib\oldnames.lib C:\prg\MVS\VC98\lib\kernel32.lib C:\prg\MVS\VC98\lib\user32.lib C:\prg\MVS\VC98\lib\gdi32.lib C:\prg\MVS\VC98\lib\winspool.lib C:\prg\MVS\VC98\lib\comdlg32.lib C:\prg\MVS\VC98\lib\advapi32.lib C:\prg\MVS\VC98\lib\shell32.lib C:\prg\MVS\VC98\lib\ole32.lib C:\prg\MVS\VC98\lib\oleaut32.lib C:\prg\MVS\VC98\lib\netapi32.lib C:\prg\MVS\VC98\lib\uuid.lib C:\prg\MVS\VC98\lib\wsock32.lib C:\prg\MVS\VC98\lib\mpr.lib C:\prg\MVS\VC98\lib\winmm.lib C:\prg\MVS\VC98\lib\version.lib C:\prg\MVS\VC98\lib\odbc32.lib C:\prg\MVS\VC98\lib\odbccp32.lib C:\prg\MVS\VC98\lib\msvcrt.lib -def:mysql.def Creating library blib\arch\auto\DBD\mysql\mysql.lib and object blib\arch\auto\DBD\mysql\mysql.exp mysqlclient.lib(str2int.obj) : error LNK2001: unresolved external symbol __pctype mysqlclient.lib(my_init.obj) : error LNK2001: unresolved external symbol __pctype mysqlclient.lib(charset.obj) : error LNK2001: unresolved external symbol __pctype mysqlclient.lib(default.obj) : error LNK2001: unresolved external symbol __pctype mysqlclient.lib(my_error.obj) : error LNK2001: unresolved external symbol __pctype mysqlclient.lib(str2int.obj) : error LNK2001: unresolved external symbol ___mb_cur_max mysqlclient.lib(my_init.obj) : error LNK2001: unresolved external symbol ___mb_cur_max mysqlclient.lib(charset.obj) : error LNK2001: unresolved external symbol ___mb_cur_max mysqlclient.lib(default.obj) : error LNK2001: unresolved external symbol ___mb_cur_max mysqlclient.lib(my_error.obj) : error LNK2001: unresolved external symbol ___mb_cur_max - 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: NT installation / port issues
I have faced the same problem which took me a very long time to solve. Here are the steps I did hoping it will help you: 1- Install Mysql on d drive and not under c drive. That was clearly stated. 2- In your command line, stop at mysql cd d:\mysql 3- mysqlbin\mysqld-shareware --basedire d:\mysql Directly, you can open you application using Mysql and see if it work Regards Khaled Omar - Original Message - From: Michael Britton [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: Friday, May 18, 2001 5:36 PM Subject: NT installation / port issues System: NT 4.0 mysql Ver. 8.2 Distrib 3.22.34, for Win95/Win98 on i586 I'm unable to access mysql server on port 3306. Error reads: Can't connect to MySQL server on 'localhost' (10061). Does this mean it's not on 3306? How do I get it there? Do I have the wrong version and do I need to download an NT version? Thanks, Michael Britton Mike Britton Web Developer LIPSinc http://www.lipsinc.com http://www.lipsinc.com/ We Have Ways of Making You Talk. - 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
fails to build on ARM architecture
Hello Does anybody know if MySQL can be build on the arm architecture? (This bug was reported against the Debian MySQL packages) bye, -christian- With 3.23.37-3 I'm now seeing a different failure: gcc -DDEFAULT_CHARSET_HOME=\/usr\ -DDATADIR=\/var/lib/mysql\ -DSHAREDIR=\/usr/share/mysql\ -I./../include -I../include -I./.. -I.. -I.. -O3 -DDBUG_OFF -O2 -fomit-frame-pointer -g -c libmysql.c -fPIC -DPIC cc1: warning: -g with -fomit-frame-pointer may not give sensible debugging libmysql.c: In function `mysql_real_connect': libmysql.c:1303: warning: passing arg 5 of `gethostbyname_r' from incompatible pointer type libmysql.c:1303: too few arguments to function `gethostbyname_r' libmysql.c:1303: warning: assignment makes pointer from integer without a cast make[3]: *** [libmysql.lo] Error 1 make[3]: Leaving directory `/build/buildd/mysql-3.23.37/libmysql_r' make[2]: *** [all-recursive] Error 1 make[2]: Leaving directory `/build/buildd/mysql-3.23.37' make[1]: *** [all-recursive-am] Error 2 make[1]: Leaving directory `/build/buildd/mysql-3.23.37' make: *** [build-stamp] Error 2 - 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++ has WEAK class prototyping
Hi, 've just looked to MySQL++ examples, class names are very poorly named (!) Thats fine for small exaple but makes a big mess in large projects. "class Query" for example is SO generic that there is big probability that will collide with other declaration and classes elsewhere and this small "characterization" has further issues. I recommend to rename it some more recognizable like: class CSQLQuery class CMySQLQuery : public CSQLQuery ... The bigger the better. C++ is not RUN-TIME so confortably use long names and be happy reading the code. == am not in conference == - 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++ has WEAK class prototyping
David Webber writes: Hi, 've just looked to MySQL++ examples, class names are very poorly named (!) Thats fine for small exaple but makes a big mess in large projects. class Query for example is SO generic that there is big probability that will collide with other declaration and classes elsewhere and this small characterization has further issues. I recommend to rename it some more recognizable like: class CSQLQuery class CMySQLQuery : public CSQLQuery ... The bigger the better. C++ is not RUN-TIME so confortably use long names and be happy reading the code. == am not in conference == HI! You are quite right about class names. I can not change them now because there are already too many applications based on MySQL++ that it would brake them. But have you taken a look at undef_short include file ?? If you include that file in your source you will get class names that would suit your taste much better. 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
Fulltext Strange Results...
Hello, I did the following query against my indexed table: select * from indexed_table where match(indexed_col) against ('oracle +sybase +london') It returned 16 rows of which only 4 rows included all words. I then did: select * from indexed_table where match(indexed_col) against ('+oracle +sybase +london') It returned 4 rows which is the desired or expected results. I then did: select * from indexed_table where match(indexed_col) against ('+oracle +sybase +london -oracle') Nothing was returned. I then went on to do this: select * from indexed_table where match(indexed_col) against ('oracle and sybase and london') This returned over 200 rows rather than the expected 4. This was done against mySQL v4.0. Can someone please explain the ambiguities. Joe B. * * Visit http://www.computerstaff.net - Computer Jobs at all LEVELS * * - 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
Reformatting a DATESTAMP out of a table into a readable display date with SELECT
I have a column LastUpdated in a table which uses TIMESTAMP to record the date and time of entries. The format of the column is: mysql select LastUpdated from DriveLeadTimes; ++ | LastUpdated| ++ | 20010519161625 | ++ 1 row in set (0.04 sec) When I display the result, I would like reformat it so that it reads: 05-19-2001 16:16:25 - OR - May 19, 2001 04:16:25 Anybody out there that can tell me how this is done? Thanks! Scot Robnett [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
Fulltext and phrases
I have just done this: select * from indexed_table where match(indexed_col) against ('visual basic') This returns rows with either visual or basic. I read phrase searching was allowed in mySQL v4.0? Can someone please advise. * * Visit http://www.computerstaff.net - Computer Jobs at all LEVELS * * - 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: Reformatting a DATESTAMP out of a table into a readable disp
On 20-May-01 Scot Robnett wrote: I have a column LastUpdated in a table which uses TIMESTAMP to record the date and time of entries. The format of the column is: random snips When I display the result, I would like reformat it so that it reads: May 19, 2001 04:16:25 Anybody out there that can tell me how this is done? Thanks! Yes. date_format(LastUpdated,'%b %d, %Y %T') Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) Regards, -- Don Read [EMAIL PROTECTED] -- It's always darkest before the dawn. So if you are going to steal the neighbor's newspaper, that's the time to do it. - 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: Reformatting a DATESTAMP out of a table into a readable display date with SELECT
So sprach Scot Robnett am Sun, May 20, 2001 at 03:03:55PM -0500: Anybody out there that can tell me how this is done? Thanks! Yeah, the manual will tell you. In the section 'Date and Time functions', look for 'DATE_FORMAT'. Since you don't know where the manual is, it's online available at http://mysql.com/doc Alexander Skwar -- How to quote: http://learn.to/quote (german) http://quote.6x.to (english) Homepage: http://www.digitalprojects.com | http://www.iso-top.de iso-top.de - Die günstige Art an Linux Distributionen zu kommen Uptime: 6 days 10 hours 27 minutes - 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: time and date
So sprach chris am Tue, Apr 02, 2002 at 08:26:01PM -0500: Is there a way to store the time and date that a record was added within MySQL? I want to show the time and date on some of my records and can't seem to figure out an easy way to do it. Thanks! Either use a TIMESTAMP column, which will automatically update everytime you update/insert a row, or use a DATETIME column which you'll have to set to the date you want, eg. with 'INSERT INTO Tbl SET DatetimeColumn = NOW();' Alexander Skwar -- How to quote: http://learn.to/quote (german) http://quote.6x.to (english) Homepage: http://www.digitalprojects.com | http://www.iso-top.de iso-top.de - Die günstige Art an Linux Distributionen zu kommen Uptime: 6 days 10 hours 29 minutes - 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
necesito ayuda urgente
Hola. No pertenezco su lista de correo, pero me parece muy interesante su trabajo. Para efectos de un proyecto de grado requiero averiguar cuales son las ventajas y desventajas que ofrece Mysql con respecto de los demás manejadores de bases de datos como oracle, PosgreSQL, access, visual fox pro,sybase, etc. Si pudieran ayudarme les agradecería eternamente, creanme que necesito esta informacion super urgente. Gracias Esmeralda Cárdenas Estudiante Universidad del Magdalena - Colombia __ 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
UPDATE
Is this ok? UPDATE table1 SET table1.field1 = table2.field1 SELECT table1.field1, table1.field2, table2.field1, table2.field2, table2.field3 FROM table1, table2 WHERE table1.field2 BETWEEN table2.field2 AND table2.field3 HAVING table1.field1 IS NULL; I know there's a lot of rules about the update clause, but I find the documentation not satisfying. Can I use all these clasues in an update sql statement, assuming 3.22.32 on RH 6.2 Dave Carter Chief Web Architect Accelerated Business Technologies, Inc. http://www.abti.cc 717.464.2970 - 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: AIX segmentation fault with PHP, Apache and MySQL
Well we now have Apache 1.3.19 and PHP 4.0.5 but still the same problem... Am about to upgrade MySQL to 3.23.38 to see if this changes things, but feel this is clutching at straws... Thanks, Dave On Thursday, May 17, 2001, at 08:59 AM, Matthew P. Marino wrote: Apache is up to 1.3.17 at least. I would update apache and see what gives. PHP4 wasn't coded until Apache 1.3.15 was out. Dave Brooks, BCS Systems wrote: Hello, I am trying to port a PHP/MySQL application that happily runs under Linux across to an AIX box. We have MySQL is running under AIX - using mysql we can create tables, insert rows, etc and even access data via a C program. PHP is running as an Apache module - a simple phpinfo() works. If our PHP scripts are invoked when mysqld is not active we get a database error Can't connect to server, as to be expected. If however, mysqld is started and then we attempt our script, Apache reports a segmentation fault (as shown in its error logs) and the client browser gets an unexpected network error. Any ideas, debugging clues, etc would be much appreciated. AIX 4.3.3 Apache 1.3.12 (IBM HTTP Server) MySQL 3.23.32 PHP 4.0.4 pl 1 Many thanks, Dave Brooks - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail mysql-unsubscribe- [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail mysql-unsubscribe- [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
RE: UPDATE
On 20-May-01 Dave Carter wrote: Is this ok? UPDATE table1 SET table1.field1 = table2.field1 SELECT table1.field1, table1.field2, table2.field1, table2.field2, table2.field3 FROM table1, table2 WHERE table1.field2 BETWEEN table2.field2 AND table2.field3 HAVING table1.field1 IS NULL; No, UPDATE ... JOIN is not supported (not sure if standard SQL allows it). Use a temp table, or script the updates. check the comments : http://www.mysql.com/doc/U/P/UPDATE.html Regards, -- Don Read [EMAIL PROTECTED] -- It's always darkest before the dawn. So if you are going to steal the neighbor's newspaper, that's the time to do it. - 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: UPDATE
Using temp table... thanks I don't understand why this isn't legitimate SQL however. I would think that it should be supported Dave Carter Chief Web Architect Accelerated Business Technologies, Inc. http://www.abti.cc 717.464.2970 -Original Message- From: Don Read [mailto:[EMAIL PROTECTED]] Sent: Sunday, May 20, 2001 7:38 PM To: Dave Carter Cc: [EMAIL PROTECTED] Subject: RE: UPDATE On 20-May-01 Dave Carter wrote: Is this ok? UPDATE table1 SET table1.field1 = table2.field1 SELECT table1.field1, table1.field2, table2.field1, table2.field2, table2.field3 FROM table1, table2 WHERE table1.field2 BETWEEN table2.field2 AND table2.field3 HAVING table1.field1 IS NULL; No, UPDATE ... JOIN is not supported (not sure if standard SQL allows it). Use a temp table, or script the updates. check the comments : http://www.mysql.com/doc/U/P/UPDATE.html Regards, -- Don Read [EMAIL PROTECTED] -- It's always darkest before the dawn. So if you are going to steal the neighbor's newspaper, that's the time to do it. - 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
replication
My server application may end up being spread over 200 servers supporting up to 1 million persistent tcp connections. Each client will have many records in a database, performing updates and selects. How well does mysql replication work over 200 servers? Was replication meant for an application of this scale? If not, is there some sort of database partitioning scheme available? Steve - 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: necesito ayuda urgente
Que tal esmeralda. Primeramente, visual FoxPro y Access son manejadores de base de datos tipo DBMS y que opcionalmente pueden accesar a Servidores de Bases de Datos SQL. MySql, Oracle, Microsoft SQL, DB2 de IBM, Etc, pertenecen a la categoria de Servidores de Base de datos SQL Una de las principales diferencias entre estos dos tipos de aplicaciones, es que el primer grupo (Access y visual Foxpro) permiten desarrollar aplicaciones completas. Son compiladores con los cuales puedes desarrollar y distribuir tus aplicaciones. El segundo grupo (Servidores SQL: MySql, Oracle, etc) no son compiladores, sino servidores de bases de datos tipo SQL (sequential Query Lenguaje). La finalidad principal de los servidores SQL es que a traves de un lenguaje o protocolo estandard (ODBC es muy utilizado para esto) tu puedes accesar o consultar registros de una base de datos SQL desde diferentes lenguajes (Access, Visual FoxPRo, C/C++, Etc) y diferentes plataformas (Unix, Windows, Etc), esto hace a estos servidores SQL muy versatiles debido a que tu puedes desarrollar aplicaciones desde diferentes lenguajes de programacion e inclusive, diferentes sistemas operativos y sin que esto te limite para compartir y actualizar informacion en la misma base de datos SQL que otra aplicacion puede estar accesando a traves de un lenguaje diferente al tuyo, incluso bajo un sistema operativo diferente. Quizas puedas encontrar algunos articulos interesante en la misma pagina de www.mysql.com, busca en News... saludos desde mexico. jevr.- From: esmeralda cardenas [EMAIL PROTECTED] To: [EMAIL PROTECTED] Subject: necesito ayuda urgente Date: Sun, 20 May 2001 15:06:35 -0700 (PDT) Hola. No pertenezco su lista de correo, pero me parece muy interesante su trabajo. Para efectos de un proyecto de grado requiero averiguar cuales son las ventajas y desventajas que ofrece Mysql con respecto de los demás manejadores de bases de datos como oracle, PosgreSQL, access, visual fox pro,sybase, etc. Si pudieran ayudarme les agradecería eternamente, creanme que necesito esta informacion super urgente. Gracias Esmeralda Cárdenas Estudiante Universidad del Magdalena - Colombia __ 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 _ Get Your Private, Free E-mail from MSN Hotmail at 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
The Syntax to Get JDBC Connection
Dear All, I use mm.mysql.jdbc to access mysql in Java. To get the connection, the following sentence is writen in my program. But an error occurred. I guess that the syntax is wrong. Could you please give me the correct one. Connection conn = DriverManager.getConnection(jdbc:mysql://localhost/RegistrationDB?user=libing;password=123456); My requirements are as follows, I need to create a database, RegistrationDB, after getting connected with MySql. The username is libing and password iis 123456. Thanks! Li Bing - 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: The Syntax to Get JDBC Connection
If that's an exact quote then you left off the opening quote marks. Cal http://www.calevans.com -Original Message- From: Li Bing [mailto:[EMAIL PROTECTED]] Sent: Saturday, May 19, 2001 4:14 PM To: [EMAIL PROTECTED] Cc: [EMAIL PROTECTED] Subject: The Syntax to Get JDBC Connection Dear All, I use mm.mysql.jdbc to access mysql in Java. To get the connection, the following sentence is writen in my program. But an error occurred. I guess that the syntax is wrong. Could you please give me the correct one. Connection conn = DriverManager.getConnection(jdbc:mysql://localhost/RegistrationDB?user=libin g;password=123456); My requirements are as follows, I need to create a database, RegistrationDB, after getting connected with MySql. The username is libing and password iis 123456. Thanks! Li Bing - 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: AIX segmentation fault with PHP, Apache and MySQL
MySQL 3.23.38 made no difference Well we now have Apache 1.3.19 and PHP 4.0.5 but still the same problem... Am about to upgrade MySQL to 3.23.38 to see if this changes things, but feel this is clutching at straws... Thanks, Dave On Thursday, May 17, 2001, at 08:59 AM, Matthew P. Marino wrote: Apache is up to 1.3.17 at least. I would update apache and see what gives. PHP4 wasn't coded until Apache 1.3.15 was out. Dave Brooks, BCS Systems wrote: Hello, I am trying to port a PHP/MySQL application that happily runs under Linux across to an AIX box. We have MySQL is running under AIX - using mysql we can create tables, insert rows, etc and even access data via a C program. PHP is running as an Apache module - a simple phpinfo() works. If our PHP scripts are invoked when mysqld is not active we get a database error Can't connect to server, as to be expected. If however, mysqld is started and then we attempt our script, Apache reports a segmentation fault (as shown in its error logs) and the client browser gets an unexpected network error. Any ideas, debugging clues, etc would be much appreciated. AIX 4.3.3 Apache 1.3.12 (IBM HTTP Server) MySQL 3.23.32 PHP 4.0.4 pl 1 Many thanks, Dave Brooks - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail mysql-unsubscribe- [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail mysql-unsubscribe- [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: AIX segmentation fault with PHP, Apache and MySQL
Hmm. Can you be a bit more specific how you upgraded your Apache? Typically I've had good luck with building the new Apache first, then building PHP (using the new apxs that it installs). You are installing these modules as .so, correct? And building everything from source code? The only thing I can think of here is that your earlier Apache had a broken lib somewhere and the new installs are not replacing it.. Z On Sunday, May 20, 2001, at 10:15 PM, Dave Brooks, BCS Systems wrote: MySQL 3.23.38 made no difference Well we now have Apache 1.3.19 and PHP 4.0.5 but still the same problem... Am about to upgrade MySQL to 3.23.38 to see if this changes things, but feel this is clutching at straws... Thanks, Dave On Thursday, May 17, 2001, at 08:59 AM, Matthew P. Marino wrote: Apache is up to 1.3.17 at least. I would update apache and see what gives. PHP4 wasn't coded until Apache 1.3.15 was out. Dave Brooks, BCS Systems wrote: Hello, I am trying to port a PHP/MySQL application that happily runs under Linux across to an AIX box. We have MySQL is running under AIX - using mysql we can create tables, insert rows, etc and even access data via a C program. PHP is running as an Apache module - a simple phpinfo() works. If our PHP scripts are invoked when mysqld is not active we get a database error Can't connect to server, as to be expected. If however, mysqld is started and then we attempt our script, Apache reports a segmentation fault (as shown in its error logs) and the client browser gets an unexpected network error. Any ideas, debugging clues, etc would be much appreciated. AIX 4.3.3 Apache 1.3.12 (IBM HTTP Server) MySQL 3.23.32 PHP 4.0.4 pl 1 Many thanks, Dave Brooks - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail mysql-unsubscribe- [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail mysql-unsubscribe- [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail mysql-unsubscribe- [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail mysql-unsubscribe- [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
RE: Inserting images into BLOB Fields
Hi, How can I insert an image file into a blob field? I search the MySQL Documents but nothing came up specificaly on inserting images from files. INSERT INTO sig VALUES ( 1, 'Paul', 'Davolio', LOAD_FILE('d:/signatures/paul.txt') ); Rgds, Tfr --== [EMAIL PROTECTED] == MySQL development team == Tallinn / Estonia ==-- - 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: Fulltext and phrases
Hi, I have just done this: select * from indexed_table where match(indexed_col) against ('visual basic') This returns rows with either visual or basic. I read phrase searching was allowed in mySQL v4.0? Can someone please advise. you're right, phrase and AND searches will be in MySQL v4.0. but you'll have to wait a bit more for the 4.0 to come out. :-) Rgds, Tfr --== [EMAIL PROTECTED] == MySQL development team == Tallinn / Estonia ==-- - 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: Inserting images into BLOB Fields
Thank you!!! -Original Message- From: indrek siitan [mailto:[EMAIL PROTECTED]] Sent: Sunday, May 20, 2001 9:51 PM To: Mike; [EMAIL PROTECTED] Subject: RE: Inserting images into BLOB Fields Hi, How can I insert an image file into a blob field? I search the MySQL Documents but nothing came up specificaly on inserting images from files. INSERT INTO sig VALUES ( 1, 'Paul', 'Davolio', LOAD_FILE('d:/signatures/paul.txt') ); Rgds, Tfr --== [EMAIL PROTECTED] == MySQL development team == Tallinn / Estonia ==-- - 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
Error when connecting mysql or oracle
Hi All, I got a code from a PERL list that inserts a row into a mysql db table. I changed to my needs, tried, and it worked. Then I decided to install DBD-Oracle.ppd to see if it would work well with Oracle but it did not. After that my machine rebooted for no reason and now when I run the same script that worked once for mySQL I get the following message: [Fri Apr 06 23:44:31 2001] [error] [client 127.0.0.1] DBD::oracle initialisation failed: Can't locate object method driver via package DBD::oracle at D:/Perl/site/lib/DBI.pm line 511. [Fri Apr 06 23:44:31 2001] [error] [client 127.0.0.1] [Fri Apr 06 23:44:31 2001] [error] [client 127.0.0.1] Perhaps the capitalisation of DBD 'oracle' isn't right. at d:\PROGRA~1\APACHE~1\apache\cgi-bin\bugsora.cgi line 71 [Fri Apr 06 23:54:32 2001] [error] [client 127.0.0.1] DBD::Mysql initialisation failed: Can't locate object method driver via package DBD::Mysql at D:/Perl/site/lib/DBI.pm line 511. [Fri Apr 06 23:54:32 2001] [error] [client 127.0.0.1] [Fri Apr 06 23:54:32 2001] [error] [client 127.0.0.1] Perhaps the capitalisation of DBD 'Mysql' isn't right. at d:\PROGRA~1\APACHE~1\apache\cgi-bin\bugs.cgi line 71 [Fri Apr 06 23:57:52 2001] [error] [client 127.0.0.1] DBD::Mysql initialisation failed: Can't locate object method driver via package DBD::Mysql at D:/Perl/site/lib/DBI.pm line 511. [Fri Apr 06 23:57:52 2001] [error] [client 127.0.0.1] [Fri Apr 06 23:57:52 2001] [error] [client 127.0.0.1] Perhaps the capitalisation of DBD 'Mysql' isn't right. at d:\PROGRA~1\APACHE~1\apache\cgi-bin\bugs.cgi line 71 [Sat Apr 07 03:50:37 2001] [error] [client 127.0.0.1] DBD::Mysql initialisation failed: Can't locate object method driver via package DBD::Mysql at D:/Perl/site/lib/DBI.pm line 511. [Sat Apr 07 03:50:37 2001] [error] [client 127.0.0.1] [Sat Apr 07 03:50:37 2001] [error] [client 127.0.0.1] Perhaps the capitalisation of DBD 'Mysql' isn't right. at d:\PROGRA~1\APACHE~1\apache\cgi-bin\bugs.cgi line 71 Does anyone know how to fix it??? thanks sio _ Get Your Private, Free E-mail from MSN Hotmail at 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
I have a question
I installed recent version of mySQL,myODBC,PHP on my W2000 machine yesterday I can not access to an access file via ODBC It gives me Warning: SQL error: [Microsoft][ODBC Microsoft Access Driver] The Microsoft Jet database engine cannot open the file '(unknown)'. It is already opened exclusively by another user, or you need permission to view its data., SQL state S1000 in SQLConnect in c:\inetpub\wwwroot\php\ietest.php on line 7 Warning: Supplied argument is not a valid ODBC-Link resource in c:\inetpub\wwwroot\php\ietest.php on line 10 Warning: Supplied argument is not a valid ODBC-Link resource in c:\inetpub\wwwroot\php\ietest.php on line 10 Here is the code I tried htmlheadtitlePHP Test/title/head body ?php //connect to database $connectionstring = odbc_connect(VIDEO,kimh,1234); //disconnect from database odbc_close($connectionstring); ? /body/html VIDEO is an access file and it can be seen from system DSN on ODBC and I set username and password for it. I tried it without username and password and $connectionstring = odbc_connect(VIDEO,,); It does not work either And I delted the video file from system DSN and set it to User DSN and It gave me Warning: SQL error: [Microsoft][ODBC Driver Manager] Data source name not found and no default driver specified, SQL state IM002 in SQLConnect in c:\inetpub\wwwroot\php\ietest.php on line 7 Warning: Supplied argument is not a valid ODBC-Link resource in c:\inetpub\wwwroot\php\ietest.php on line 10 Warning: Supplied argument is not a valid ODBC-Link resource in c:\inetpub\wwwroot\php\ietest.php on line 10 What do I do? _ Get Your Private, Free E-mail from MSN Hotmail at 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: Error when connecting mysql or oracle
Well, this really isn't a mysql issue. This is an ActiveState perl issue, But it sounds like you've clobbered your DBD files some how and or you're just not initializing them correctly. Siomara Pantarotto wrote: Hi All, I got a code from a PERL list that inserts a row into a mysql db table. I changed to my needs, tried, and it worked. Then I decided to install DBD-Oracle.ppd to see if it would work well with Oracle but it did not. After that my machine rebooted for no reason and now when I run the same script that worked once for mySQL I get the following message: [Fri Apr 06 23:44:31 2001] [error] [client 127.0.0.1] DBD::oracle initialisation failed: Can't locate object method driver via package DBD::oracle at D:/Perl/site/lib/DBI.pm line 511. [Fri Apr 06 23:44:31 2001] [error] [client 127.0.0.1] [Fri Apr 06 23:44:31 2001] [error] [client 127.0.0.1] Perhaps the capitalisation of DBD 'oracle' isn't right. at d:\PROGRA~1\APACHE~1\apache\cgi-bin\bugsora.cgi line 71 [Fri Apr 06 23:54:32 2001] [error] [client 127.0.0.1] DBD::Mysql initialisation failed: Can't locate object method driver via package DBD::Mysql at D:/Perl/site/lib/DBI.pm line 511. [Fri Apr 06 23:54:32 2001] [error] [client 127.0.0.1] [Fri Apr 06 23:54:32 2001] [error] [client 127.0.0.1] Perhaps the capitalisation of DBD 'Mysql' isn't right. at d:\PROGRA~1\APACHE~1\apache\cgi-bin\bugs.cgi line 71 [Fri Apr 06 23:57:52 2001] [error] [client 127.0.0.1] DBD::Mysql initialisation failed: Can't locate object method driver via package DBD::Mysql at D:/Perl/site/lib/DBI.pm line 511. [Fri Apr 06 23:57:52 2001] [error] [client 127.0.0.1] [Fri Apr 06 23:57:52 2001] [error] [client 127.0.0.1] Perhaps the capitalisation of DBD 'Mysql' isn't right. at d:\PROGRA~1\APACHE~1\apache\cgi-bin\bugs.cgi line 71 [Sat Apr 07 03:50:37 2001] [error] [client 127.0.0.1] DBD::Mysql initialisation failed: Can't locate object method driver via package DBD::Mysql at D:/Perl/site/lib/DBI.pm line 511. [Sat Apr 07 03:50:37 2001] [error] [client 127.0.0.1] [Sat Apr 07 03:50:37 2001] [error] [client 127.0.0.1] Perhaps the capitalisation of DBD 'Mysql' isn't right. at d:\PROGRA~1\APACHE~1\apache\cgi-bin\bugs.cgi line 71 Does anyone know how to fix it??? thanks sio _ Get Your Private, Free E-mail from MSN Hotmail at 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 - 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
I have a question (2)
Hello I treid to access an access file using following code htmlheadtitlePHP Test/title/head body ?php //connect to database $connectionstring = odbc_connect(video,,); //disconnect from database odbc_close($connectionstring); ? /body/html I gives me Warning: SQL error: , SQL state 0 in SQLConnect in c:\inetpub\wwwroot\php\ietest.php on line 7 Warning: Supplied argument is not a valid ODBC-Link resource in c:\inetpub\wwwroot\php\ietest.php on line 10 Warning: Supplied argument is not a valid ODBC-Link resource in c:\inetpub\wwwroot\php\ietest.php on line 10 What do I missed? _ Get Your Private, Free E-mail from MSN Hotmail at 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: Error when connecting mysql or oracle
I reinstalled these two packages: D:\Perl\binppm install DBI.ppd Installing package 'DBI.ppd'... Writing D:\Perl\site\lib\auto\DBI\.packlist D:\Perl\binppm install DBD-Mysql.ppd Installing package 'DBD-Mysql.ppd'... Writing D:\Perl\site\lib\auto\DBD\Mysql\.packlist and now it works again: mysql select * from bug; +---+---+ | bugID | description | +---+---+ | 1 | The system reboots when you click button continue | | 2 | The main page crashes when more than 3 user connect to the system | | 3 | BLA BLA BLA | +---+---+ 3 rows in set (0.12 sec) the third line I insert via cgi script. My question now are: Do you think that when installing DBD-Oracle things got messed up??? Doe anyone know how to make it work with Orcale besides mysql?? Thanks siomara From: Colin Faber [EMAIL PROTECTED] Reply-To: [EMAIL PROTECTED] To: Siomara Pantarotto [EMAIL PROTECTED] CC: [EMAIL PROTECTED] Subject: Re: Error when connecting mysql or oracle Date: Sun, 20 May 2001 22:43:37 -0600 Well, this really isn't a mysql issue. This is an ActiveState perl issue, But it sounds like you've clobbered your DBD files some how and or you're just not initializing them correctly. Siomara Pantarotto wrote: Hi All, I got a code from a PERL list that inserts a row into a mysql db table. I changed to my needs, tried, and it worked. Then I decided to install DBD-Oracle.ppd to see if it would work well with Oracle but it did not. After that my machine rebooted for no reason and now when I run the same script that worked once for mySQL I get the following message: [Fri Apr 06 23:44:31 2001] [error] [client 127.0.0.1] DBD::oracle initialisation failed: Can't locate object method driver via package DBD::oracle at D:/Perl/site/lib/DBI.pm line 511. [Fri Apr 06 23:44:31 2001] [error] [client 127.0.0.1] [Fri Apr 06 23:44:31 2001] [error] [client 127.0.0.1] Perhaps the capitalisation of DBD 'oracle' isn't right. at d:\PROGRA~1\APACHE~1\apache\cgi-bin\bugsora.cgi line 71 [Fri Apr 06 23:54:32 2001] [error] [client 127.0.0.1] DBD::Mysql initialisation failed: Can't locate object method driver via package DBD::Mysql at D:/Perl/site/lib/DBI.pm line 511. [Fri Apr 06 23:54:32 2001] [error] [client 127.0.0.1] [Fri Apr 06 23:54:32 2001] [error] [client 127.0.0.1] Perhaps the capitalisation of DBD 'Mysql' isn't right. at d:\PROGRA~1\APACHE~1\apache\cgi-bin\bugs.cgi line 71 [Fri Apr 06 23:57:52 2001] [error] [client 127.0.0.1] DBD::Mysql initialisation failed: Can't locate object method driver via package DBD::Mysql at D:/Perl/site/lib/DBI.pm line 511. [Fri Apr 06 23:57:52 2001] [error] [client 127.0.0.1] [Fri Apr 06 23:57:52 2001] [error] [client 127.0.0.1] Perhaps the capitalisation of DBD 'Mysql' isn't right. at d:\PROGRA~1\APACHE~1\apache\cgi-bin\bugs.cgi line 71 [Sat Apr 07 03:50:37 2001] [error] [client 127.0.0.1] DBD::Mysql initialisation failed: Can't locate object method driver via package DBD::Mysql at D:/Perl/site/lib/DBI.pm line 511. [Sat Apr 07 03:50:37 2001] [error] [client 127.0.0.1] [Sat Apr 07 03:50:37 2001] [error] [client 127.0.0.1] Perhaps the capitalisation of DBD 'Mysql' isn't right. at d:\PROGRA~1\APACHE~1\apache\cgi-bin\bugs.cgi line 71 Does anyone know how to fix it??? thanks sio _ Get Your Private, Free E-mail from MSN Hotmail at 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 _ Get Your Private, Free E-mail from MSN Hotmail at 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: I have a question
Hi, I can not access to an access file via ODBC It gives me Warning: SQL error: [Microsoft][ODBC Microsoft Access Driver] The Microsoft Jet database engine cannot open the file '(unknown)'. It is already opened exclusively by another user, or you need permission to view its data., SQL state S1000 in SQLConnect in c:\inetpub\wwwroot\php\ietest.php on line 7 this is in no way associated to MySQL. as the error message says, you're trying to connect to a Microsoft Access data source, what is already exclusively opened by another user - your probably have the database open in MS Access - it opens it for exclusive use by default. Rgds, Tfr --== [EMAIL PROTECTED] == MySQL development team == Tallinn / Estonia ==-- - 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: Error when connecting mysql or oracle
well I've never really looked into how the PPM app that activestate works, I'd assume you'd probably just want to go grab the .zip file and unzip it into your library path your self, Then when you want to play with it make sure to use the Oracle driver in your DBI connect statement. Siomara Pantarotto wrote: I reinstalled these two packages: D:\Perl\binppm install DBI.ppd Installing package 'DBI.ppd'... Writing D:\Perl\site\lib\auto\DBI\.packlist D:\Perl\binppm install DBD-Mysql.ppd Installing package 'DBD-Mysql.ppd'... Writing D:\Perl\site\lib\auto\DBD\Mysql\.packlist and now it works again: mysql select * from bug; +---+---+ | bugID | description | +---+---+ | 1 | The system reboots when you click button continue | | 2 | The main page crashes when more than 3 user connect to the system | | 3 | BLA BLA BLA | +---+---+ 3 rows in set (0.12 sec) the third line I insert via cgi script. My question now are: Do you think that when installing DBD-Oracle things got messed up??? Doe anyone know how to make it work with Orcale besides mysql?? Thanks siomara From: Colin Faber [EMAIL PROTECTED] Reply-To: [EMAIL PROTECTED] To: Siomara Pantarotto [EMAIL PROTECTED] CC: [EMAIL PROTECTED] Subject: Re: Error when connecting mysql or oracle Date: Sun, 20 May 2001 22:43:37 -0600 Well, this really isn't a mysql issue. This is an ActiveState perl issue, But it sounds like you've clobbered your DBD files some how and or you're just not initializing them correctly. Siomara Pantarotto wrote: Hi All, I got a code from a PERL list that inserts a row into a mysql db table. I changed to my needs, tried, and it worked. Then I decided to install DBD-Oracle.ppd to see if it would work well with Oracle but it did not. After that my machine rebooted for no reason and now when I run the same script that worked once for mySQL I get the following message: [Fri Apr 06 23:44:31 2001] [error] [client 127.0.0.1] DBD::oracle initialisation failed: Can't locate object method driver via package DBD::oracle at D:/Perl/site/lib/DBI.pm line 511. [Fri Apr 06 23:44:31 2001] [error] [client 127.0.0.1] [Fri Apr 06 23:44:31 2001] [error] [client 127.0.0.1] Perhaps the capitalisation of DBD 'oracle' isn't right. at d:\PROGRA~1\APACHE~1\apache\cgi-bin\bugsora.cgi line 71 [Fri Apr 06 23:54:32 2001] [error] [client 127.0.0.1] DBD::Mysql initialisation failed: Can't locate object method driver via package DBD::Mysql at D:/Perl/site/lib/DBI.pm line 511. [Fri Apr 06 23:54:32 2001] [error] [client 127.0.0.1] [Fri Apr 06 23:54:32 2001] [error] [client 127.0.0.1] Perhaps the capitalisation of DBD 'Mysql' isn't right. at d:\PROGRA~1\APACHE~1\apache\cgi-bin\bugs.cgi line 71 [Fri Apr 06 23:57:52 2001] [error] [client 127.0.0.1] DBD::Mysql initialisation failed: Can't locate object method driver via package DBD::Mysql at D:/Perl/site/lib/DBI.pm line 511. [Fri Apr 06 23:57:52 2001] [error] [client 127.0.0.1] [Fri Apr 06 23:57:52 2001] [error] [client 127.0.0.1] Perhaps the capitalisation of DBD 'Mysql' isn't right. at d:\PROGRA~1\APACHE~1\apache\cgi-bin\bugs.cgi line 71 [Sat Apr 07 03:50:37 2001] [error] [client 127.0.0.1] DBD::Mysql initialisation failed: Can't locate object method driver via package DBD::Mysql at D:/Perl/site/lib/DBI.pm line 511. [Sat Apr 07 03:50:37 2001] [error] [client 127.0.0.1] [Sat Apr 07 03:50:37 2001] [error] [client 127.0.0.1] Perhaps the capitalisation of DBD 'Mysql' isn't right. at d:\PROGRA~1\APACHE~1\apache\cgi-bin\bugs.cgi line 71 Does anyone know how to fix it??? thanks sio _ Get Your Private, Free E-mail from MSN Hotmail at 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 _ Get Your Private, Free E-mail from MSN Hotmail at 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:
Re: how can I do this?
Hi, I have four table that have common fields like: date, destinazione and price. I what to create a temporary table with all four fields from four tables, what would be the correct sql syntax. TIA Adrian - 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
why does it not work
Hi, I have been trying this on my localhost and this works select special.contid, special.cityid, special.curr1, special.catalogo, special.hf, special.curr2, special.vitofferta, special.fh, special.club, special.stars, city.city from special,city where DATE_SUB(special.periodo, INTERVAL 3 DAY) '$tdate' and city.id=special.cityid order by RAND() limit 1 My version +--+ | version()| +--+ | 3.23.22-beta-log | +--+ but the same sql statement on my online server does not work. select special.contid, special.cityid, special.curr1, special.catalogo, - special.hf, special.curr2, special.vitofferta, special.fh, special.club, special.stars, city.city from special,city where DATE_SUB(special.periodo, INTERVAL 3 - DAY) '$tdate' and city.id=special.cityid order by RAND() limit 1; ERROR 1064: You have an error in your SQL syntax near 'RAND() limit 1' at line 3 select version(); +---+ | version() | +---+ | 3.22.32 | +---+ What could be the problem Adrian - 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