Compatability with Microsoft Access
Hello, My objective is to be able to access a "Microsoft Access" database, using ASP scripts on a Linux Apache server. Can I achieve database connectivity with an Access.mdb file localy on a Linux box using mySQL - i.e WITHOUT using some sort of ODBC bridging software. If there is a reliable conversion process to take an Access file and convert it into mySQL format - that would work for me as well! Thanks, Christopher. - 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
help! perl and MySQL Beginner Warning!
I have built a small guestbook using perl and MySQL when i try to run my perl script i get the following error. Software error: [Thu Feb 22 14:38:01 2001] DBI.pm: Can't locate DBI.pm in @INC (@INC contains: /usr/lib/perl5/5.00503/i386-linux /usr/lib/perl5/5.00503 /usr/lib/perl5/site_perl/5.005/i386-linux /usr/lib/perl5/site_perl/5.005) at /home/httpd/cgi-bin/guestbook.cgi line 8. BEGIN failed--compilation aborted at /home/httpd/cgi-bin/guestbook.cgi line 8. I have installed MySQL and the two perl plugins DBI and DBD using fooperl -MCPAN -e 'install DBI' fooperl -MCPAN -e'install DBD::mysql' Does anyone know where I should go from here? (Redhat 6.2, Apache) - 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
Copying a ddatabase from one server to another
Here's my situation I've been hosting my sites with one company for over a year and am now moving to a dedicated server operated by the same company. My existing database is large, containing around a dozen tables and over 5,000 entries. I want to copy the database structure and data to the new dedicated server. I've already created the new database, but not the tables. At first I tried copying the files from the database directory on my old server to the new database directory. I was able to read them but no combination of permissions or ownerships would allow me to insert/update the values (even when logged in as the super user). I found the mysqldump command in the MySQL docs. I created a dump file using the following command: [EMAIL PROTECTED] ysql.com mysqldump -uUSERNAME -pPASSWORD database dbBackup.sql and it created the dump file. I transferred it to the new server then tried to load it into my new database using the following command: mysqldump -uUSERNAME -pMILLER31 database dbBackup.sql (I also tried it with the -c option) I received the following output: # MySQL dump 8.12 # # Host: localhostDatabase: database # # Server version3.23.32 It did not insert any of the tables (and obviously not the data either). I tried another variation I found in the MySQL docs. I went to the original server and entered in the following command: mysqldump -uUSERNAME -pPASSWORD database | mysql --host=[IP Address of New Server] database -uUSERNAME -pPASSWORD and I received the following output: ERROR 1130: Host 'old.server.hostname.net' is not allowed to connect to this MySQL server Any tips??? Thanks, Jeff Gannaway ___ 2001 Wall Calendars * Art, Jazz, Blues, Women's, African-American. * Everyday Discounts. * Excellent paper and reproductions. And as always, a great selection of abstract, contemporary and African-American art prints. PopStreet.com is your avenue to art. http://www.popstreet.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: web based admin?
Do you have a remote server? Do you have a lot of data to enter into your database? Ask yourself: Would you rather preface each and every insert with "INSERT [data] INTO [table.column] ...", than enter data by filling in blanks in a webform. Do you want to correct typos or otherwise edit content in large text fields using a command line interface? Would you rather specify table and column every time you want to check your data structure, than see it all with the click of a mouse? I don't think so. I'll take the GUI, thank you. On 20 Feb 2001, at 4:08, [EMAIL PROTECTED] wrote: why do [would] you want to *admin* MySQL over the web (say, with phpMyAdmin)? (this will help me to learn :) tia - 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 John Jensen 520 Goshawk Court Bakersfield, CA 93309 661-833-2858 - 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: help! perl and MySQL Beginner Warning!
Hi Thomas well it may be that the install put it in another directory other than in the ones listed below I too am a bit of a beginner with perl and mysql but I found my DBI stuff in another dir so I used the following in my perl script use lib "dir/path/here/to/libs"; This tells perl to look in another dir(including the original path) for the modules... and it solved my problems, maybe not the best method but it did work, what I would like to know from ppl eventually tho is how to modify the @INC variable at a user level, IE when I log into my machine! but that I guess is for another mailing list... hope this helps you too -Original Message- From: Thomas O'Neill [mailto:[EMAIL PROTECTED]] Sent: 22 February 2001 12:17 To: [EMAIL PROTECTED] Subject: help! perl and MySQL Beginner Warning! I have built a small guestbook using perl and MySQL when i try to run my perl script i get the following error. Software error: [Thu Feb 22 14:38:01 2001] DBI.pm: Can't locate DBI.pm in @INC (@INC contains: /usr/lib/perl5/5.00503/i386-linux /usr/lib/perl5/5.00503 /usr/lib/perl5/site_perl/5.005/i386-linux /usr/lib/perl5/site_perl/5.005) at /home/httpd/cgi-bin/guestbook.cgi line 8. BEGIN failed--compilation aborted at /home/httpd/cgi-bin/guestbook.cgi line 8. I have installed MySQL and the two perl plugins DBI and DBD using fooperl -MCPAN -e 'install DBI' fooperl -MCPAN -e'install DBD::mysql' Does anyone know where I should go from here? (Redhat 6.2, Apache) - 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: + or - in place of = does what???
Hi. WHERE expects a boolean expression, but user_num+"AL011-33" is no boolean expression. MySQL therefore assumes that the result of the expression should be considered as boolean value. Analogous to C and similar languages, it assumes the expression to be 'false', if it is zero (numbers) or empty (strings). Else, it is considered 'true'. Therefore the above expression is equivalent to WHERE user_num+"AL011-33" != 0 as '+' is integer addition. It forces conversion of user_num and "AL011-33" to numbers. I guess atol() (or some equivalence) is used and therefore the string is converted, using all numbers from the left to right, until the first non-numerical characters is met and the conversion simply stops, returning the current value. E.g. 33-110AL - 33 - true 000110AL - 110 - true AL011-33 - 0 - false 000AL-33 - 0 - false Therefore "AL011-33" converts to 0 (it starts with a non-number) and doesn't add to the sum of '+'. So it boils down to the question whether user_num converts to a number differnt from 0. This is the case, if user_num starts with a number (and not a character), and the numbers are not only '0's. This results in the obversation, that only user_num which start with a number have been deleted. Bye, Benjamin. On Tue, Feb 20, 2001 at 12:14:02AM +0100, [EMAIL PROTECTED] wrote: i guess the calculation returns a result (ie: whether it's successfull or not), so '1-1' evaluates true; but 1-A evaluates false because A is not a number so you can't calculate on it. So in your case, this would be: where user_num+"AL011-33" if user_num='0': where '0'="%any%"; /// returns True; if user_num='Xxx': where NAN= any...; /// returns False makes some sense..if user_num is valid to calculate with %any% other value, comparison returns true, elsewise false. - Original Message - From: "Jordan" [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: 2001-02-19 11:29 PM Subject: + or - in place of = does what??? First time here, sorry if this is too much of a novice question to get answered... I just sent the command: DELETE FROM users WHERE user_num+"AL011-33"; by accident (I meant to use an "=" not the "+"). It killed 81 rows. I restored the data, but I couldn't find anything in the docs about what that command actually did. After restoring the data, I ran the command again (substituting SELECT for DELETE) and it looks like it gives me all the users that have user_num that start with a number rather than a letter. I got the same results regardless of whether I sent the command with a "-" or a "+". What gives? - 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: case sensitive selects
A comparison will be case sensitivie, if any sub-part of the expression is case sensitive. There are several ways to solve this: 1) CREATE or ALTER your tables so that the relevant CHAR and VARCHAR fields are of type BINARY; change TEXTs to BLOBs 2) Use a case-sensitive, but neutral function when SELECTing, to force MySQL to perform a case-sensitive comparison / Carsten -- Carsten H. Pedersen keeper and maintainer of the bitbybit.dk MySQL FAQ http://www.bitbybit.dk/mysqlfaq -Original Message- From: Ji Mikul [mailto:[EMAIL PROTECTED]] Sent: Wednesday, February 21, 2001 4:01 PM To: [EMAIL PROTECTED] Subject: case sensitive selects Hi all. I have problem with MySQL 3.23.32 on FreeBSD4.2 SELECTs are not case sensitive, any suggestion how to set it ? I'v looked into DOCs, but i'm not so clever from it :(( ... my config options was only ./configure --prefix=/usr/local/mysql Many thaks. Jiri Mikulas [EMAIL PROTECTED] http://www.anglictina.com ICQ: 108 36 60 66 Admin - anglictina.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
Re: MySQL and JDBC: Communication link failure
Try a) downgrading an _older_ mm.mysql driver, or, much better: b) upgrading to a newer (and non-alpha) mySQL database version. I've had exactly this problem every time I upgraded to a new mySQL version. Upgrading the driver, too, solved the problem in each case. For example, currently I'm using driver version 2.0.1 with database version 3.23.33, and they work fine together (driver 1.2b worked with DB 3.22.*, but not with 3.23.*). Hope this helps Gnther Pewny Cecilia Deng wrote: "Anybody know what's wrong? After 'java LoadDriver' I always get the message: Exception: Communication link failure:... ... DBMS: MySQL 3.23.11-alpha DB driver: mm.mysql-2.0.4-bin.jar" - 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 : Question???
Dear Sir/Madam, I'm a Visual FoxPro programmer. I want to use MySQL database for my programs. However, I cannot update MySQL database with my Visual FoxPro programs through ODBC (but I can view the record of table). My commands are as follow: CREATE CONNECTION conn1 DATASOURCE "MySQL" USERID "users" DATABASE "tempdata" STORE SQLSTRINGCONNECT('dsn=MySQL; uid=root; pwd=') TO xConnHandle //return of 'xConnHandle' is positive that means connection is successful// =SQLSETPROP(xConnHandle,'Transactions',2) //this return is negative that means there is an error on connection level// I don't know why I can view the table but I cannot update the table through ODBC. Would you help me to solve this problem? Thank you! Regards, Edith
RE: XML support under mySQL
*big snip* I agree with Cal, the XML module should really be sperated from the RDMB. XML is really great but, lets face it not everyone is going to use it so why force it down thier troat?. The really great thing about Open Source is that you do have a choice (unlike MS , Oracle). :) You have to choice to install external XML modules if you wish, if not why would you use it? I'm sure if you write the XML modules as an extension to MySQL in C or C++, it'll be just as fast as if it is built in. Not to maintion the fact that it'll be far easier of MySQL developer to put in other really "useful" RDMB related features like ForeinKeys etc etc. instead of "cool" but not critical features XML. And the code base for MySQL wouldn't be bloated either which means we as the users won't have to download 200MB RDMB servers :):) My $0.02 But you've yet to make a case for extending a database engine to do something it's not originally designed to do and something that I argue does not belong in a RDBMS engine. First, while I agree that XML is a great solution for 2 applications to exchange data, it is not a - 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: RE: XML support under mySQL
Mehalick, Richard RE SSI-GRAX ([EMAIL PROTECTED]) writes: Some relational databases return results in XML format. And operating systems have been written in Java and Perl. So? Just because you *can* doesn't mean you *should*. Suppose I want to translate the output to something else. Now I'm stuck - I have to strip off the XML. *MUCH* cleaner to have the database return just data - then you can use something else to wrap the data in anything you want - XML, HTML, PHP, whatever. We use this approach in Escapade - it outputs just data - you decide how you want it wrapped. The idea of decoupling data and metadata is a powerful one and has strong, compelling arguments in its favor - ane one usually taught in first-year computer science classes. -- Ed Carp, N7EKG [EMAIL PROTECTED] 940/367-2744 cell phone http://www.pobox.com/~erc [EMAIL PROTECTED] - text pager I sometimes wonder if the American people deserve to be free - they seem so unwilling to fight to preserve the few freedoms they have left. - 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: Youch!
Thank you. Re: On 21 Feb 2001, at 16:29, Atle Veka wrote: where's your mysqld located? /usr/local/mysql/bin just change your safe_mysql script to contain the correct location of your mysqld binary. I thought that was what I was doing with "bin/safe_mysqld " from /usr/local/mysql/ I worked fine before, but it was from a fresh boot (I'll try that). also, i *think* mysqladmin -uroot -p[pass] shutdown is the preferred shutdown mechanism, didn't even know you could do that with mysql (client). I'll make a note of it. are you sure it's actually stopped? do a 'ps | grep mysqld' to find out ;) Did that. All that turned up was the ps call. Atle On Wed, 21 Feb 2001, John Jensen wrote: I had shut down the mysql daemon using: bin/mysql -u root -p[password] shutdown Now when I attempt to restart it using: bin/safe_mysql it gives me the message: [1] 2564 The file /usr/local/mysql/libexec/mysqld doesn't exist or is not executable Please do a cd to the mysql installation directory and restart thisscript from there as follows: ./bin/safe_mysql but ./bin/safe_mysql just gave me the same message prefaced by: [2] 2570 I checked and found the directory 'libexec' does not exist. I can't recall it ever did. So now I am left wondering: "Why is it trying to look in a non-existent direcory?" and "What went wrong?" Any ideas? John Jensen 520 Goshawk Court Bakersfield, CA 93309 661-833-2858 - 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 John Jensen 520 Goshawk Court Bakersfield, CA 93309 661-833-2858 - 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
Problems on creating table
Dear Sir/ Madam, I'm using mySQL GUI Win32 to create a database. I managed to create a database but not a new table. What I did was that I created a database by using function Commands:Administration:Database:Create, and then I selected the database name from the database button(the one next to the connted button). Next, I tried to create a table by selecting Commands:Tables:Create Tables but nothing happened. Please help me by solving the said problem and also tell me if there is any tutorial for mySQL GUI on the web. Thanks a lot. Your GUI program is very user friendly and I don't give up the program because of this minor problem. Thanks for developing this nice software. 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
problems relating DATE and LOAD DATA INFILE
hello everybody, I am a newbie to database. I have two quetions, 1- I am using MySQL which I intalled with the Mandrake 7.2. I have lots of data in txt file format with a date field having a configuration like dd/mm/ and I have to use it in that format. but MySQL have a /mm/dd how can I change this setup in MySQL? 2- Data in the txt file have a configuration like data1|data2|dd/mm/|data4| and I want this txt file to be inserted in a table that I created. I am using LOAD DATA INFILE "/home/user/fee.txt" into table fee_policy fields terminated by '|' lines terminated by '/n'; but I can just insert the first row and not the rest, how can I upload all data in the table fee_policy? and due to the question 1, date field is inserted like 20dd/mm/yy and the last 2 digit of is omited. thanks in advance for all of your help. altay - 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
Access to Mysql ?
Hi, I would like to transform an Access database to a MySQL database .. I think there is no problem with doing an export of Access in CSV and an import in MySQL... The problem is .. in the Access db there some OLE Object which are images .. how to put them in the MySQL db ? Thanks. -- Christophe Suire [EMAIL PROTECTED] "Software is like sex, it's better when it's Free !" - 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: Copying a ddatabase from one server to another
Jeff Gannaway wrote: mysqldump -uUSERNAME -pPASSWORD database dbBackup.sql and it created the dump file. I transferred it to the new server then tried to load it into my new database using the following command: mysqldump -uUSERNAME -pMILLER31 database dbBackup.sql Don't take "mysqldump" for the import into the new database, try mysql -uUSERNAME -pMILLER31 database dbBackup.sql on the new mySQL server instead! Gnther Pewny - 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
synopsis of the problem (one line)
Description: How-To-Repeat: Fix: Submitter-Id: submitter ID Originator:root Organization: MySQL support: [none | licence | email support | extended email support ] Synopsis: Severity: Priority: Category: mysql Class: Release: mysql-3.23.33 (Official MySQL binary) Environment: System: Linux gemini.objectorb.com 2.2.16-22 #1 Tue Aug 22 16:49:06 EDT 2000 i686 unknown Architecture: i686 Some paths: /usr/bin/perl /usr/bin/make /usr/bin/gmake /usr/bin/gcc /usr/bin/cc GCC: Reading specs from /usr/lib/gcc-lib/i386-redhat-linux/2.96/specs gcc version 2.96 2731 (Red Hat Linux 7.0) Compilation info: CC='gcc' CFLAGS='-O6 -mpentium ' CXX='gcc' CXXFLAGS='-O6 -mpentium -felide-constructors' LDFLAGS='-static' LIBC: lrwxrwxrwx1 root root 14 Feb 16 23:41 /lib/libc.so.6 - libc-2.1.92.so -rwxr-xr-x1 root root 4776568 Aug 31 03:26 /lib/libc-2.1.92.so -rw-r--r--1 root root 22607104 Aug 31 02:45 /usr/lib/libc.a -rw-r--r--1 root root 178 Aug 31 02:45 /usr/lib/libc.so Configure command: ./configure --prefix=/usr/local/mysql '--with-comment=Official MySQL binary' --with-extra-charsets=complex --enable-assembler --with-mysqld-ldflags=-all-static --with-client-ldflags=-all-static --disable-shared - 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
Linuux with mysql and c++ API
Linux with mysql and c++API I'am trying to connect to an Mysql database trough c++ API (1.7.8) The program compiles just fine but when i try to run it I get the message Segmentation fault core dump When I try to run the program with the strace command I can see that the program connects to the database and retrives information from the selected table But just at it's about to complete it preformes the core dump. The follwing seems to be the problem: munmap(0xfec54533, 1096976036) = -1 EINVAL (Invalid argument) The arguments that I use seem to be correct code vise??? Can anyone give me a hint? Jarle
Mysql PID Problem?
Having problems starting mysql on my linux box. I think I've tried just about everything in the manual within reason. Please help out if anyone has an idea. The other day, mysql died on my system for no apparent reason. When I reboot the machine, based on the script in /etc/rc.d/init.d/mysql, mysql should start up and it does --somewhat. Here's the message I get: [root@myserver mysql]# /etc/rc.d/init.d/mysql start [root@myserver mysql]# Starting mysqld daemon with databases from /usr/var/mysql And it shows up in the process list below... root 5340 0.0 0.3 1668 828 pts/0S21:23 0:00 sh /usr/bin/safe_ mysql 5365 0.0 0.4 3308 1176 pts/0S21:23 0:00 /usr/sbin/mysqld mysql 5366 0.0 0.4 3308 1176 pts/0S21:23 0:00 /usr/sbin/mysqld mysql 5367 0.0 0.4 3308 1176 pts/0S21:23 0:00 /usr/sbin/mysqld And it logs it to my /usr/var/mysql/server.log as: /usr/sbin/mysqld, Version: 3.23.21-beta-log, started with: Tcp port: 3306 Unix socket: /var/lib/mysql/mysql.sock Time Id CommandArgument But any commands I send to mysql or mysqladmin hangup and nothing ever happens. I then have to kill -9 to force it to stop. So now I manually go in and start it, as root with safe_mysqld. Here's what I get: [root@myserver mysql]# safe_mysqld kill 4212: No such process Starting mysqld daemon with databases from /usr/var/mysql mysqld daemon ended It tries to kill a process, but there is no process in the list! This seems to start it, but then, any commands I send to it just hang the app. If I just try to run mysql from command line I get this: [root@myserver mysql]# mysql ERROR 2002: Can't connect to local MySQL server through socket '/var/lib/mysql/m ysql.sock' (111) One thing I have to consider is some recent DNS work I did. Is it possible DNS could cause these problems? I'm really at a loss here. Any help is greatly appreciated. Thanks, Jeff - 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: Future suggestion
Also, specifying fields won't break things when people add fields to a table. Yeah, but you already have the same problem with SELECT *. Let me give another example. You have a table with 15 rows. One of those rows is TEXT. You really do want everything except the text. Doesn't anyone else think it's a pain to type in all the fields rather than just doing "* EXCEPT textfield" in your query? Let me also point out that I see this being more useful as an interactive development aid than I do as a feature you'd use in deployment. Ok, I'll even settle for a query that does "* EXCEPT TEXT" which would eliminate datatypes rather than specific fields :-). - 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
Help me
Hello I'm working out a programm what generates page visiting statistics, to help me to go http://www.seitse.ee and click some links. With best regards Esko - 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
Transactions in 3.23.33 ?
Has transaction management present in the 3.23.33 binary distribution of MySQL? When creating BDB tables and trying to use them inside transactions I fail to get them to work. There's no error messages and the transactions seem to be ignored. I've tried this on Linux and NT. -- Bruce Percy Peopledoc 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
mySQL Lock Problem
hi, I like to write a multi-user program in internet by using mysql, do i need to use lock function to lock the table before i write or update anything to the table ? but some manual say we use it for maintenance purpose, is it right ? then how mysql handle the locking under multi-user environment ? please reply me asap from Darick. - 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
Youch!
I had shut down the mysql daemon using: bin/mysql -u root -p[password] shutdown Now when I attempt to restart it using: bin/safe_mysql it gives me the message: [1] 2564 The file /usr/local/mysql/libexec/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/safe_mysql but ./bin/safe_mysql just gave me the same message prefaced by: [2] 2570 I checked and found the directory 'libexec' does not exist. I can't recall it ever did. So now I am left wondering: "Why is it trying to look in a non-existent direcory?" and "What went wrong?" Any ideas? John Jensen 520 Goshawk Court Bakersfield, CA 93309 661-833-2858 - 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
maximum number of characters
Hi Can anybody tell me what the maximum number of characters I can have in one field. Thanks Matt. - 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
Problems with splitting data across different disks under Windows...
Hi, I'm working under Windows 98 with MySQL version 3.23.29. I tried to connect to a database that is on a different disk from the data directory (g:\mysql\data). So I created a file g:\mysql\data\pfi.sym containing the path e:\databases\pfi. I compiled with the USE_SYMDIR option and launched the server with -s option. When I execute the "SHOW DATABASES" command, I can see that "pfi" database exists. When I try to connect to "pfi" database, I get the message "unknown database". Did I do something wrong ? I had a look in the code and got the error in mysql_change_db function. I saw nothing in this function taking into account the symbolic links... Thanks Patrick __ Patrick Fiche - Prologue Software (France) Software Engineer Email: [EMAIL PROTECTED] Internet : http://www.prologue-software.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: maximum number of characters
Matt, Before posting to a mailing list, you should ensure you RTFM! Have a look at www.mysql.com and you'll find tha answers in the documentation. regards, P On Thu, 22 Feb 2001, Matt Davis wrote: Hi Can anybody tell me what the maximum number of characters I can have in one field. Thanks Matt. - 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: ranking album plays by city, help me beat Oracle
Hello. On Tue, Feb 20, 2001 at 03:27:08PM -0800, [EMAIL PROTECTED] wrote: Huh? You got it 7 times faster by only extracting that query from the for loop and changing it to a group by? Or did you do anything else? Sorry there were some other unnecessary queries that were mistakenly in the measurement.. Ah, okay. Never mind, but good to know. Here is the missing EXPLAIN. mysql EXPLAIN SELECT same_album_id, SUM(td_num) FROM album_by_metro - WHERE metro = 'Atlanta' AND rpt_dt = '2001-01-01' AND - rpt_dt = '2001-02-14' - GROUP BY same_album_id HAVING SUM(td_num) 500 - ; ++---++-+--- --+--+--+-+ | table | type | possible_keys | key | ke y_len | ref | rows | Extra | ++---++-+--- --+--+--+-+ | album_by_metro | range | rpt_dt,album_by_metro_idx2 | album_by_metro_idx2 | 103 | NULL | 8925 | where used; Using temporary | ++---++-+--- --+--+--+-+ 1 row in set (0.00 sec) "Using temporary" is not good (see also http://www.mysql.com/doc/E/X/EXPLAIN.html). Hm. I don't know, why a temporary table is used here. Two suggestions: Make a special key for that query (metro,rpt_dt,same_album_id,td_sum). And second, force in-memory tables with SELECT SQL_SMALL_RESULT same_album_id, ... Could you post the EXPLAIN and the speed measurement after each of the changes, please. Sorry I tried the below suggested query but it it is much slower at 1min 30 secs probably because it ranks all albums for all metros rather than just working on the rank of one album over the metros. Hm. Sorry, I don't understand your argument. By the for loop, your query does the same, doesn't it (selecting the rank of one album in each metro is the same as selecting for all metros the rank of one album)? But, of course, yes, the time is way off. mysql EXPLAIN SELECT metro, same_album_id, SUM(td_num) AS played - FROM album_by_metro - WHERE rpt_dt = '2001-01-01' AND rpt_dt = '2001-02-14' - GROUP BY metro, same_album_id - HAVING SUM(td_num) 1000 - ORDER BY metro, same_album_id, played DESC; ++---+---++-+--++--- ---+ | table | type | possible_keys | key| key_len | ref | rows | Ex tra| ++---+---++-+--++--- ---+ | album_by_metro | index | rpt_dt| rpt_dt | 161 | NULL | 716943 | wh ere used; Using index; Using temporary; Using filesort | ++---+---++-+--++--- --+ Hm. rpt_dt used as I guessed and the number of rows seems reasonable (about 100 times as much as with the query above). "using index" is fine (key_len indicates that not only rpt_dt is read from the key, but also all the other column values). But "using temporary" and "using filesort" is considered bad. We could use a better key, leaving out the column "region", e.g. (rpt_dt,metro,same_album_id,td_sum), but I guess, this will give only a small improvement (would you try it please?). The use of a temporary table is obligatory when GROUP BY and ORDER BY differ. One could change ORDER BY to "metro, same_album_id" and do the sorting on client side, but I doubt this would be a better solution. I guess the real problem is that the temporary table is created on disk, and this would be *slow*. One can force in-memory temporary tables by using SELECT SQL_SMALL_RESULT metro... (the temporary table should be no bigger than, hm, about 500*100*160 Bytes = 8MB... I hope that is acceptable with your hardware.) Would you please try it? We probably should bother about the filesort, because with the GROUP BY (and the suggested index above), we already have indirectly sorted on (metro,same_album_id) and only need to sort on the last column (played). I am really curious, whether my arguments hold, and therefore what your test results are. Thank you in advance. Can this faster approach below which in a loop queries the # of albums with sums be optimized to be a single query. ? I believe no, my query above was the best try I could give this. Thanks for all your help interest. Your are welcome. Bye, Benjamin. - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request
Re: Connecting via MyODBC always brings up the TDX mysql Driver Connect dialog
Make sure you also have at least a user (and password as appropriate) filled out in the MyODBC Control Panel. Pat... [EMAIL PROTECTED] - Original Message - From: "Jan R Andersson" [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: Wednesday, February 21, 2001 10:22 AM Subject: Connecting via MyODBC always brings up the "TDX mysql Driver Connect" dialog Hello, I've recently successfully downloaded and installed both MySQL and MyODBC on my Win2000 "box". Everything thing works great, except that for every connection via MyODBC I make, the ODBC-setup dialog "TDX mysql Driver Connect" pops up and I have to hit its OK button to close it. There is a checkbox named "Don't prompt on connect" which I thought was ment to have it stop poping up that dialog, but it has no effect. Any idea what to do? Thanks /Jan R Andersson /Kalix /Sweden WEB: www.jra.nu www.mobilesweden.org WAP: jra.nu/main.wml wap.mobilesweden.org - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Problem compiling...
Hi all, I've a little problem at the linking stage. I've always have the following error : g++ -g -o mainTest mainTest.o worldFactory.o -L/usr/local/OpenInventor26/lib -limage -lInventor -lInventorXt -L/usr/lib/mysql -lmysqlclient -lsqlplus -lpthread -L/usr/X11R6/lib -lX11 -lGL -lGLU -lGLw -lGLhack -lXext -lXm -lXt -lXi -lX11 -lXmu /usr/local/OpenInventor26/lib/libInventor.so: the use of `tempnam' is dangerous, better use `mkstemp' worldFactory.o: In function `_Bit_iterator::bump_down(void)': /usr/include/g++-3/stl_vector.h(.gnu.linkonce.t.__opf__Ct13mysql_ColData1Z12const_string+0x10): undefined reference to `float mysql_ColDataconst_string::convfloat(float) const' collect2: ld returned 1 exit status make: *** [mainTest] Erreur 1 I don't know what library I've missed here ... does any body know the answer ??? regards Cyril - 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
nesting tables
Sir, Is there this concept of nesting tables and varrays in mysql?. Iam creating a chemical compounds database. there are 20 field in this . Amongst them, I have a author field where there are multiple authors, amongst which one is common for all the records. suppose I query giving the common author for all the records, can I get the other associated author details who may be in more than one record. please help. Anticipating Reply. Revathi. V __ 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
Removing MySQL
Hi, How do you go about removing MySQL from a DEC Alpha box? Regards, Evan - 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: nesting tables
What do you mean by "nesting tables" and "varrays"? What you have described is known as relational databases and a good idea would be to buy a good book on Relational Database Management Systems. - Original Message - From: "revathi venkatraman" [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: Thursday, February 22, 2001 19:01 Subject: nesting tables Sir, Is there this concept of nesting tables and varrays in mysql?. Iam creating a chemical compounds database. there are 20 field in this . Amongst them, I have a author field where there are multiple authors, amongst which one is common for all the records. suppose I query giving the common author for all the records, can I get the other associated author details who may be in more than one record. please help. Anticipating Reply. Revathi. V __ 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 - 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: XML support under mySQL
XML will become a common and powerful way to express/exchange data on the web. I hope MySQL decides to go along for the ride. This is all fine and good, but why does MySQL itself have to do this? We don't want Microsoft and Oracle to take over the world, do we? :) Their popularity does not imply sound design. Just that they have superior marketing. My naive understanding is that it would be effortless to write a module in perl that translates the data returned by the DBI to XML. I'm not a perl expert so I cannot speak to that. However, I doubt that it's effortless or trivial. Why would it be easier to write said layer if it was inside the DBMS instead of outside? -- Michael Bacarella [EMAIL PROTECTED] Technical Staff / System Development, New York Connect.Net, 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
Re: Compatability with Microsoft Access
Check out www.devshed.com. Right now it has a very good article on what you want. - Original Message - From: [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: Thursday, February 22, 2001 16:15 Subject: Compatability with Microsoft Access Hello, My objective is to be able to access a "Microsoft Access" database, using ASP scripts on a Linux Apache server. Can I achieve database connectivity with an Access.mdb file localy on a Linux box using mySQL - i.e WITHOUT using some sort of ODBC bridging software. If there is a reliable conversion process to take an Access file and convert it into mySQL format - that would work for me as well! Thanks, Christopher. - 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
Exporting data from a MySQL database to an oracle database
Hi, I have a MySql database with customer information which is to be exported to an oracle database. I was wondering if someone could tell me the easiest way of doing this. Is there any such applications which look after the exporting of the data from the MySql database and importing to the new oracle database. Or even how to export the data from the MySql database to a flat file. Kind Regards Joe O'Toole - 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: So, what do you do with a tarball anyways.
"Matthew P. Marino" wrote: So, what do you do with a "tarball" anyways. Since compiling the source is hopless( "sql_yacc.cc"), I'm looking for a binary. then download the binary.. Or at least do a better job of describing your problem... - 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 writing a sql statement into a field.
Hi , notice your last field in the Values section. 'query += "\"" + this.customerId + "\",";' get rid of the comma at the end. end replace it with a close'n bracket. notice the last field, you have one extra field in the values bracket. 'xxx","c","-1","-1",")' at line 1 cheers Ken reply to : [EMAIL PROTECTED] www.mysqlwebring.com Statement: Syntax error or access violation: You have an error in your SQL syntax near 'xxx","c","-1","-1",")' at line 1 Was updating a log table in the database that has a message field. The message field was being updataed with: query = "INSERT INTO passtbl(user,pass,employeeId,customerId) VALUES"; query += "(\"" + this.getuserId() + "\","; query += "\"" + this.getpass() + "\","; query += "\"" + this.employeeId + "\","; query += "\"" + this.customerId + "\","; mysql explain applog - ; ++---+--+-+-++ | Field | Type | Null | Key | Default | Extra | ++---+--+-+-++ | applogid | int(10) | | PRI | NULL| auto_increment | | logMessage | varchar(255) | YES | | NULL|| | timedate | timestamp(14) | YES | | NULL|| ++---+--+-+-++ - 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
mysqldump output file not valid as input file for mysql client
Description: As of mysql 3.23.33, a dumpfile generated with mysqldump (using the flags: --opt --all-databases) creates a file which will not be uploaded correctly using the mysql client (as in: 'mysql -u root -pXX -q -s dumpfile.sql'). Specifically, the problem relates to mysqldump's outputting of table keys. See the actual dump of mysql.db below: DROP TABLE IF EXISTS db; CREATE TABLE db ( Host char(60) binary NOT NULL default '', Db char(64) binary NOT NULL default '', User char(16) binary NOT NULL default '', Select_priv enum('N','Y') NOT NULL default 'N', Insert_priv enum('N','Y') NOT NULL default 'N', Update_priv enum('N','Y') NOT NULL default 'N', Delete_priv enum('N','Y') NOT NULL default 'N', Create_priv enum('N','Y') NOT NULL default 'N', Drop_priv enum('N','Y') NOT NULL default 'N', Grant_priv enum('N','Y') NOT NULL default 'N', References_priv enum('N','Y') NOT NULL default 'N', Index_priv enum('N','Y') NOT NULL default 'N', Alter_priv enum('N','Y') NOT NULL default 'N', PRIMARY KEY (Host,Db,User), KEY User(User) pukes on this line ) TYPE=MyISAM COMMENT='Database privileges'; If a space is added (as in: "KEY User (User)"), the file will import correctly. I looked through the source file mysqldump.c and it appears that there always should be a space between the key name and the key columns, but my personal dumpfiles show that all non-primary keys have no space between the key name and the key column names. Go figure. :) Needless to say I don't get it. How-To-Repeat: See above description. Fix: See above description. Submitter-Id: submitter ID Originator:Matt Loschert Organization: Matt Loschert | email: [EMAIL PROTECTED]| Software Engineer | web: http://www.servint.net/ | ServInt Internet Services | phone: (703) 847-1381 | MySQL support: none Synopsis: mysqldump output file not valid as input file for mysql client Severity: non-critical Priority: medium Category: mysql Class: sw-bug Release: mysql-3.23.33 (Source distribution) Environment: System: FreeBSD delft.servint.com 4.2-STABLE FreeBSD 4.2-STABLE #0: Tue Feb 6 11:43:35 EST 2001 [EMAIL PROTECTED]:/disk2/cvsup/branches/releng_4/obj/disk2/cvsup/branches/releng_4/src/sys/QUICKIE 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 1169450 Feb 6 12:05 /usr/lib/libc.a lrwxr-xr-x 1 root wheel 9 Feb 6 12:05 /usr/lib/libc.so - libc.so.4 -r--r--r-- 1 root wheel 559516 Feb 6 12:05 /usr/lib/libc.so.4 Configure command: ./configure --prefix=/usr/local/mysql-23.33 --with-low-memory Perl: This is perl, version 5.005_03 built for i386-freebsd - 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: Transaction
- Original Message - From: "WANG_KING£¨Íõ¸Ö£©" [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: Thursday, February 22, 2001 13:51 Subject: Transaction Does the newest version of mysql support transaction ? Sure does. How does you solve your data integrity problem in your appliacation? Doesn't support foreign keys. Check out the manual and yes, there is a chinese manual as well. Yours, Sincerely King Wang Shanghai Huateng Software Systems Co, Ltd. 8/F, Wenxin United Press Tower, 755 Wei Hai Road, Shanghai 200041, P.R.C PH:32014500-5106 Email:[EMAIL PROTECTED] mailto:[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 - 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: BDB Problem with MAX() and multipart primary keys
Guenther Pewny writes: Hi folks, I have a problem with BDB tables. Please look at this short mysql session: mysql create table sample ( id1 int(8) not null, id2 int(8) not null, primary key (id1,id2)) type=BDB; Query OK, 0 rows affected (0.67 sec) mysql insert into sample values (1, 2); Query OK, 1 row affected (0.07 sec) mysql select id2 from sample where id1=1; +-+ | id2 | +-+ | 2 | +-+ 1 row in set (0.00 sec) mysql select min(id2) from sample where id1=1; +--+ | min(id2) | +--+ |2 | +--+ 1 row in set (0.00 sec) mysql select max(id2) from sample where id1=1; +--+ | max(id2) | +--+ | NULL | +--+ 1 row in set (0.00 sec) Is this a bug in mySQL? Why does MIN() return the correct result, while MAX() does not? Is it a severe bug which possibly can cause data inconsistency within the table data or does there exist a "good" workaround for this problem with only modifying the query? Thanks Gnther Pewny Hi! I have just tested this with 3.23.33 and it executed just fine !! 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: problem with blob
Hi again. Just thought that I'd repost my message cause I think nobody was checking their mail when I first posted it. Not rying to spam or anything I just really need to figure this out. Thanks, Jay (see post below) At 07:45 AM 2/21/2001 +00-03, Jay Brushett wrote: Hi, I'm new to MySQL so please forgive me if this post is very rudimentary. I've created a new database and added all my tables, etc... Everything seems to be fine except for a blob field in one of my tables. I'm using myODBC and ColdFusion 4.0 on Win2000. When I output the content the blob contains all that it displays are a series of letters and numbers, nothing remotely like the data I put in. But when I use the console and run the query it shows me the data that's in there. Thanks in advance, Jay Strategy ~ Creativity ~ Technology Jay Brushett [EMAIL PROTECTED] Developer ZeddComm Inc. 2nd Floor, The Tower | 100 Signal Hill Road St. John's, Newfoundland | Canada A1A 1B3 Main: 709.570.5669 | Fax: 709.739.9003 Web: www.zeddcomm.com St. John's ~ New York ~ Newport Beach ~ Ottawa Strategy ~ Creativity ~ Technology Jay Brushett [EMAIL PROTECTED] Developer ZeddComm Inc. 2nd Floor, The Tower | 100 Signal Hill Road St. John's, Newfoundland | Canada A1A 1B3 Main: 709.570.5669 | Fax: 709.739.9003 Web: www.zeddcomm.com St. John's ~ New York ~ Newport Beach ~ Ottawa
Re: Linuux with mysql and c++ API
Jarle Rudihagen writes: Linux with mysql and c++API I'am trying to connect to an Mysql database trough c++ API (1.7.8) The program compiles just fine but when i try to run it I get the message Segmentation fault core dump When I try to run the program with the strace command I can see that the program connects to the database and retrives information from the selected table But just at it's about to complete it preformes the core dump. The follwing seems to be the problem: munmap(0xfec54533, 1096976036) = -1 EINVAL (Invalid argument) The arguments that I use seem to be correct code vise??? Can anyone give me a hint? Jarle Hi! Please provide more info. What glibc do you have, which gcc compiler, how did you build mysql++ and finally what is your program like. SIGSEGV could be caused by a bug in connection.cc, so I am sending you a correct one. You will have to rebuild mysql++. 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: Auto-Inc question
[EMAIL PROTECTED] ([EMAIL PROTECTED]) writes: Hi, I have a table which contains a row called ListID which is set to auto increment, I added a load of test data into the table while I built my website so I could test various things out, anyway that is all finished now and I am ready to go live so I have dropped all the test data from the table. My question is how to I get the ListID to start back at 0 as at the moment even though all the fake content is gone it is still incrementing from the last record. Thats not to say I wasn`t expecting it, I`m just not sure how to reset the increment. 30 seconds work(less time than it took you to type your email) would've revealed the answer: 1. Click on "the manual" link at the bottom of this message. 2. See the search box? Type in "auto increment". 3. Click on the "myisamchk" link. 4. Read. Or, to make it even easier: http://www.mysql.com/doc/m/y/myisamchk_other_options.html Please, next time, bother to search the manual before wasting other's time answering questions to which 30 seconds research would reveal the answer. -- Ed Carp, N7EKG [EMAIL PROTECTED] 940/367-2744 cell phone http://www.pobox.com/~erc [EMAIL PROTECTED] - text pager I sometimes wonder if the American people deserve to be free - they seem so unwilling to fight to preserve the few freedoms they have left. - 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: nesting tables
revathi venkatraman ([EMAIL PROTECTED]) writes: Sir, Is there this concept of nesting tables and varrays in mysql?. Iam creating a chemical compounds database. there are 20 field in this . Amongst them, I have a author field where there are multiple authors, amongst which one is common for all the records. suppose I query giving the common author for all the records, can I get the other associated author details who may be in more than one record. please help. Before posting, please check: http://www.mysql.com/manual.php (the manual) Search for "join". Oh, and you might want to invest in a good book on databases - this is not a MySQL question, it is a generic database question, and doesn't really belong here. -- Ed Carp, N7EKG [EMAIL PROTECTED] 940/367-2744 cell phone http://www.pobox.com/~erc [EMAIL PROTECTED] - text pager I sometimes wonder if the American people deserve to be free - they seem so unwilling to fight to preserve the few freedoms they have left. - 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
Myisamchk unable to repair index problem
running myisamchk against basic table gives this error : stopword doesn't have a correct index definition. you need to recreate it before you can do a repair. table details: create table stopword(word char(32) DEFAULT '' NOT NULL, lang char(2) DEFAULT '' NOT NULL, PRIMARY KEY (word, lang)); This create command look good to me, so what could be the problem? I have already done a drop index, create index, flush tables but it still remains. FS - 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: Exporting data from a MySQL database to an oracle database
Joe.O'[EMAIL PROTECTED] (Joe.O'[EMAIL PROTECTED]) writes: I have a MySql database with customer information which is to be exported to an oracle database. I was wondering if someone could tell me the easiest way of doing this. Is there any such applications which look after the exporting of the data from the MySql database and importing to the new oracle database. Or even how to export the data from the MySql database to a flat file. Did you even bother to search the manual before you posted? Before posting, please check: http://www.mysql.com/manual.php (the manual) Search the manual for "mysqldump". -- Ed Carp, N7EKG [EMAIL PROTECTED] 940/367-2744 cell phone http://www.pobox.com/~erc [EMAIL PROTECTED] - text pager I sometimes wonder if the American people deserve to be free - they seem so unwilling to fight to preserve the few freedoms they have left. - 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
Oddity with date subtraction - bug?
Hi all, I recently did a query to subtract one DATETIME column from another, but I got odd results for one row and correct results for others. These queries expand upon what I was doing: mysql SELECT impression, click, click - impression AS diff, DATE_SUB(click, INTERVAL click - impression SECOND) AS calc FROM eventlog; +-+-+--+-+ | impression | click | diff | calc| +-+-+--+-+ | 2001-02-22 12:07:03 | 2001-02-22 12:09:04 | 201 | 2001-02-22 12:05:43 | | 2001-02-22 12:14:39 | 2001-02-22 12:14:44 |5 | 2001-02-22 12:14:39 | | 2001-02-22 12:16:13 | 2001-02-22 12:16:17 |4 | 2001-02-22 12:16:13 | +-+-+--+-+ 3 rows in set (0.00 sec) mysql SELECT TIME_TO_SEC('00:02:01'); +-+ | TIME_TO_SEC('00:02:01') | +-+ | 121 | +-+ 1 row in set (0.00 sec) mysql SELECT SEC_TO_TIME(201); +--+ | SEC_TO_TIME(201) | +--+ | 00:03:21 | +--+ 1 row in set (0.00 sec) As you can see, the difference between the two dates on the first record is clearly 2 minutes, 1 second - which works out as 121 seconds. However, MySQL thinks it's 201 seconds, which is actually 3 minutes 21 seconds - wrong! Do I have a bug here? Or is this not how I should be subtracting/adding dates? I'm using version 3.23.32-log, intstalled from official MySQL RPMs. Regards, Basil Hussain ([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: mysqldump output file not valid as input file for mysql client
[EMAIL PROTECTED] writes: Description: As of mysql 3.23.33, a dumpfile generated with mysqldump (using the flags: --opt --all-databases) creates a file which will not be uploaded correctly using the mysql client (as in: 'mysql -u root -pXX -q -s dumpfile.sql'). Specifically, the problem relates to mysqldump's outputting of table keys. See the actual dump of mysql.db below: DROP TABLE IF EXISTS db; CREATE TABLE db ( Host char(60) binary NOT NULL default '', Db char(64) binary NOT NULL default '', User char(16) binary NOT NULL default '', Select_priv enum('N','Y') NOT NULL default 'N', Insert_priv enum('N','Y') NOT NULL default 'N', Update_priv enum('N','Y') NOT NULL default 'N', Delete_priv enum('N','Y') NOT NULL default 'N', Create_priv enum('N','Y') NOT NULL default 'N', Drop_priv enum('N','Y') NOT NULL default 'N', Grant_priv enum('N','Y') NOT NULL default 'N', References_priv enum('N','Y') NOT NULL default 'N', Index_priv enum('N','Y') NOT NULL default 'N', Alter_priv enum('N','Y') NOT NULL default 'N', PRIMARY KEY (Host,Db,User), KEY User(User) pukes on this line ) TYPE=MyISAM COMMENT='Database privileges'; If a space is added (as in: "KEY User (User)"), the file will import correctly. I looked through the source file mysqldump.c and it appears that there always should be a space between the key name and the key columns, but my personal dumpfiles show that all non-primary keys have no space between the key name and the key column names. Go figure. :) Needless to say I don't get it. How-To-Repeat: See above description. Fix: See above description. Submitter-Id: submitter ID Originator: Matt Loschert Organization: Matt Loschert | email: [EMAIL PROTECTED]| Software Engineer | web: http://www.servint.net/ | ServInt Internet Services | phone: (703) 847-1381 | MySQL support: none Synopsis: mysqldump output file not valid as input file for mysql client Severity: non-critical Priority: medium Category: mysql Class: sw-bug Release:mysql-3.23.33 (Source distribution) Environment: System: FreeBSD delft.servint.com 4.2-STABLE FreeBSD 4.2-STABLE #0: Tue Feb 6 11:43:35 EST 2001 [EMAIL PROTECTED]:/disk2/cvsup/branches/releng_4/obj/disk2/cvsup/branches/releng_4/src/sys/QUICKIE 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 1169450 Feb 6 12:05 /usr/lib/libc.a lrwxr-xr-x 1 root wheel 9 Feb 6 12:05 /usr/lib/libc.so - libc.so.4 -r--r--r-- 1 root wheel 559516 Feb 6 12:05 /usr/lib/libc.so.4 Configure command: ./configure --prefix=/usr/local/mysql-23.33 --with-low-memory Perl: This is perl, version 5.005_03 built for i386-freebsd Hi! The above happens as USER is a keyword in MySQL. 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: Specification of the MySQL Server/Client protocol
Wittens writes: Hello, Perhaps you can call me stupid or just blind, but I can't find a specification of the MySQL Server/Client protocol anywhere... I need it to implement a simple, lightweight MySQL client for mIRC (so using MySQL++/libmysql is out of the question). Is there such a document lying around, if so where can I get it? Thanks in advance, Steven Wittens (I'm not sure how this list works, but I'm not subscribed, so if needed, please CC replies to me) Hi! How on Earth do you hope of skipping libmysql.c ?? 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: Compile Problem
Alec Solway writes: Hi, I am getting the following errore when trying to link the MySQL client library with a C++ program I have written. /usr/local/mysql/lib/libmysqlclient.a(my_open.o): In function `my_open': my_open.o(.text+0x14): undefined reference to `open64' /usr/local/mysql/lib/libmysqlclient.a(mf_format.o): In function `fn_format': mf_format.o(.text+0x201): undefined reference to `__lxstat64' /usr/local/mysql/lib/libmysqlclient.a(my_fopen.o): In function `my_fopen': my_fopen.o(.text+0x21): undefined reference to `fopen64' Which additional library must I include that has these functions? Regards. Alec Hi! You have to upgrade your system C library . Seems like it is Linux, so install glibc 2.2.1. 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: Mysql++ problems
sas writes: HI. When I was trying to include the "custon.hh" header file, I got some error messages like this. gcc -lsqlplus -I/usr/include -I/usr/include/mysql -L/usr/lib -o test3 test3.cc In file included from /usr/include/custom.hh:71, from test3.cc:5: /usr/include/custom-macros.hh:8299:16: warning: nothing can be pasted after this token /usr/include/custom-macros.hh:8354:5: warning: nothing can be pasted after this token /usr/include/custom-macros.hh:8371:5: warning: nothing can be pasted after this token /usr/include/custom-macros.hh:8389:5: warning: nothing can be pasted after this token /usr/include/custom-macros.hh:8427:50: warning: nothing can be pasted after this token ( . . . . . . and these messages repeated many many times) test3.cc:13:26: warning: pasting would not give a valid preprocessing token test3.cc:13:26: warning: pasting would not give a valid preprocessing token test3.cc:13:26: warning: pasting would not give a valid preprocessing token .(..well and these messages also repeated many times) /tmp/ccRsci15.o: In function `mysql_ColDataconst_string::operator int(void) const': /tmp/ccRsci15.o(.gnu.linkonce.t.__opi__Ct13mysql_ColData1Z12const_string+0x10): undefined reference to `int mysql_ColDataconst_string::convint(int) const' /tmp/ccRsci15.o: In function `mysql_ColDataconst_string::operator double(void) const':/tmp/ccRsci15.o(.gnu.linkonce.t.__opd__Ct13mysql_ColData1Z12const_string+0x12): undefined reference to `double mysql_ColDataconst_string::convdouble(double) const' collect2: ld returned 1 exit status make: *** [test3] Error 1 Should I always use gcc version 2.95.2? Does it work on gcc 2.96? I think I have linked the library's directory. Can you give me some hints? Thanks a lot :) Hi! Yes, please use gcc 2.95.2. 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: Problems on creating table
Pui Yin LEE [AP] writes: Dear Sir/ Madam, I'm using mySQL GUI Win32 to create a database. I managed to create a database but not a new table. What I did was that I created a database by using function Commands:Administration:Database:Create, and then I selected the database name from the database button(the one next to the connted button). Next, I tried to create a table by selecting Commands:Tables:Create Tables but nothing happened. Please help me by solving the said problem and also tell me if there is any tutorial for mySQL GUI on the web. Thanks a lot. Your GUI program is very user friendly and I don't give up the program because of this minor problem. Thanks for developing this nice software. Regards Hi! That functionality is on our TODO. You can however manually enter CREATE TABLE command ;o) 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: XML support under mySQL
Yes, Ed is correct. You store data, but it is the trasport of that data that makes XML look good. To me, using XML to transport the data is like using recordsets in Microsoft/ADO. - / Rick Mehalick Senior Consultant / Shell Services International SSI-GPAX / Phone: 281-544-5092(WCK) / Fax:281-544-2646(WCK) / email: [EMAIL PROTECTED] - -Original Message- From: Ed Carp [mailto:[EMAIL PROTECTED]] Sent: Thursday, February 22, 2001 6:18 AM To: [EMAIL PROTECTED]; [EMAIL PROTECTED] Subject: Re: XML support under mySQL Gorjan Todorovski ([EMAIL PROTECTED]) writes: Since XML is a way to exchange data...and it is protocol/platform indepdnent there is a very good reason to have XML docuemts going in and out the No, it's not. You store *data* in a database, *not* metadata. Do you understand the difference? -- Ed Carp, N7EKG [EMAIL PROTECTED] 940/367-2744 cell phone http://www.pobox.com/~erc [EMAIL PROTECTED] - text pager I sometimes wonder if the American people deserve to be free - they seem so unwilling to fight to preserve the few freedoms they have left. - 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: RE: XML support under mySQL
For some reason I don't think this was understood of what I said earlier. THE "DATABASE" ISN'T RESPONSIBLE FOR XML But, just because the database isn't responsible doesn't mean that the application is responsible for generating XML. Due to the fact I don't have my computer science degree like Ed Carp said we all should. I'm going to claim stupidity and yet still say my $0.02. We all know that the database is not responsible, nor should it be responsible for only making it's data accessible through XML. This is not at all what people need, nor are they asking for this. All people want is a way to put this wrapper on MySQL to be able to send queries to and have the output be in XML. There is no problem with this, nor should there be months of debate on whether or not this is a database function because it's obviously not. What people want is to have MySQL, an Open Source Database that is pretty damn good, take the initiative and make this wrapper to distribute with MySQL. Now if someone else wants to do this that's no big deal, let's just give MySQL a copy so that they distribute it with MySQL. You can't preach to me about how hard this is. If it wasn't for the fact I've been stuck working on Microsoft the past year I would do it in a couple days, I've already dome similar to create an XML feed manually for Microsoft SQL using ASP. Aaron Weiker -Original Message- From: Ed Carp [mailto:[EMAIL PROTECTED]] Sent: Wednesday, February 21, 2001 7:42 PM To: [EMAIL PROTECTED]; [EMAIL PROTECTED]; [EMAIL PROTECTED] Subject: Re: RE: XML support under mySQL Mehalick, Richard RE SSI-GRAX ([EMAIL PROTECTED]) writes: Some relational databases return results in XML format. And operating systems have been written in Java and Perl. So? Just because you *can* doesn't mean you *should*. Suppose I want to translate the output to something else. Now I'm stuck - I have to strip off the XML. *MUCH* cleaner to have the database return just data - then you can use something else to wrap the data in anything you want - XML, HTML, PHP, whatever. We use this approach in Escapade - it outputs just data - you decide how you want it wrapped. The idea of decoupling data and metadata is a powerful one and has strong, compelling arguments in its favor - ane one usually taught in first-year computer science classes. -- Ed Carp, N7EKG [EMAIL PROTECTED] 940/367-2744 cell phone http://www.pobox.com/~erc [EMAIL PROTECTED] - text pager I sometimes wonder if the American people deserve to be free - they seem so unwilling to fight to preserve the few freedoms they have left. - 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: HELP!!
elaine; Put the escape character in front of it (/') jack :-)= - Original Message - From: "Elaine Silva" [EMAIL PROTECTED] To: [EMAIL PROTECTED] Cc: [EMAIL PROTECTED] Sent: Wednesday, February 21, 2001 6:17 PM Subject: HELP!! Please, How can i insert the "'" character (like "sbie'2000") in a database using the INSERT command? tanks, Elaine. Don't E-Mail, ZipMail! http://www.zipmail.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
Re: Linuux with mysql and c++ API
Thank you for the quick answer, Sinisa Milivojevic. I had som trouble getting the mysql++ API working. I tried both binary and source distribution and finally today: It works I got another source distibution and after a clean compilation it worked. Thanks! Hilsen Jarle - Original Message - From: "Sinisa Milivojevic" [EMAIL PROTECTED] To: [EMAIL PROTECTED] Cc: Sent: Thursday, February 22, 2001 1:22 PM Subject: Re: Linuux with mysql and c++ API Jarle Rudihagen writes: Linux with mysql and c++API I'am trying to connect to an Mysql database trough c++ API (1.7.8) The program compiles just fine but when i try to run it I get the message Segmentation fault core dump When I try to run the program with the strace command I can see that the program connects to the database and retrives information from the selected table But just at it's about to complete it preformes the core dump. The follwing seems to be the problem: munmap(0xfec54533, 1096976036) = -1 EINVAL (Invalid argument) The arguments that I use seem to be correct code vise??? Can anyone give me a hint? Jarle Hi! Please provide more info. What glibc do you have, which gcc compiler, how did you build mysql++ and finally what is your program like. SIGSEGV could be caused by a bug in connection.cc, so I am sending you a correct one. You will have to rebuild mysql++. 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: mysqldump output file not valid as input file for mysql client
On Thu, 22 Feb 2001, Sinisa Milivojevic wrote: [EMAIL PROTECTED] writes: Description: As of mysql 3.23.33, a dumpfile generated with mysqldump (using the flags: --opt --all-databases) creates a file which will not be uploaded correctly using the mysql client (as in: 'mysql -u root -pXX -q -s dumpfile.sql'). Specifically, the problem relates to mysqldump's outputting of table keys. See the actual dump of mysql.db below: DROP TABLE IF EXISTS db; CREATE TABLE db ( Host char(60) binary NOT NULL default '', Db char(64) binary NOT NULL default '', User char(16) binary NOT NULL default '', Select_priv enum('N','Y') NOT NULL default 'N', Insert_priv enum('N','Y') NOT NULL default 'N', Update_priv enum('N','Y') NOT NULL default 'N', Delete_priv enum('N','Y') NOT NULL default 'N', Create_priv enum('N','Y') NOT NULL default 'N', Drop_priv enum('N','Y') NOT NULL default 'N', Grant_priv enum('N','Y') NOT NULL default 'N', References_priv enum('N','Y') NOT NULL default 'N', Index_priv enum('N','Y') NOT NULL default 'N', Alter_priv enum('N','Y') NOT NULL default 'N', PRIMARY KEY (Host,Db,User), KEY User(User) pukes on this line ) TYPE=MyISAM COMMENT='Database privileges'; If a space is added (as in: "KEY User (User)"), the file will import correctly. I looked through the source file mysqldump.c and it appears that there always should be a space between the key name and the key columns, but my personal dumpfiles show that all non-primary keys have no space between the key name and the key column names. Go figure. :) Needless to say I don't get it. How-To-Repeat: See above description. Fix: See above description. Submitter-Id: submitter ID Originator: Matt Loschert Organization: Matt Loschert| email: [EMAIL PROTECTED]| Software Engineer| web: http://www.servint.net/ | ServInt Internet Services| phone: (703) 847-1381 | MySQL support: none Synopsis: mysqldump output file not valid as input file for mysql client Severity: non-critical Priority: medium Category: mysql Class:sw-bug Release: mysql-3.23.33 (Source distribution) Environment: System: FreeBSD delft.servint.com 4.2-STABLE FreeBSD 4.2-STABLE #0: Tue Feb 6 11:43:35 EST 2001 [EMAIL PROTECTED]:/disk2/cvsup/branches/releng_4/obj/disk2/cvsup/branches/releng_4/src/sys/QUICKIE 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 1169450 Feb 6 12:05 /usr/lib/libc.a lrwxr-xr-x 1 root wheel 9 Feb 6 12:05 /usr/lib/libc.so - libc.so.4 -r--r--r-- 1 root wheel 559516 Feb 6 12:05 /usr/lib/libc.so.4 Configure command: ./configure --prefix=/usr/local/mysql-23.33 --with-low-memory Perl: This is perl, version 5.005_03 built for i386-freebsd Hi! The above happens as USER is a keyword in MySQL. Regards, Sinisa Sure, but this is a standard dump of the whole database, and the mysql client is having problems reloading the **mysql** database. The mysql.db table defines this key, not one of my tables. If you cannot use the --all-databases flag to mysqldump to make a valid backup file, what is the flag useful for? :) By the way, this used to work. I am not sure exactly what release it stopped working in. Thanks for the help. - Matt -- Matt Loschert | email: [EMAIL PROTECTED]| Software Engineer | web: http://www.servint.net/ | ServInt Internet Services | phone: (703) 847-1381 | - 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: RE: XML support under mySQL
Top of the morning to ya Aaron, 1: Ed did not suggest that everyone has to have a CS degree. Not defending Ed because based on his posts this morning, someone pissed in his Cheerios but he simply stated that people should be a little more educated about the subject before posting. 2: The discussion started with someone stating that MySQL should be extended to accept XML statements, not a wrapper. I think everyone against embedding XML in MySQL has advocated a wrapper. 3: Never claim stupidity, it gives flamers more ammo to work with. :) Cal http://www.calevans.com -Original Message- From: Aaron Weiker [mailto:[EMAIL PROTECTED]] Sent: Thursday, February 22, 2001 8:00 AM To: 'Ed Carp'; [EMAIL PROTECTED]; [EMAIL PROTECTED]; [EMAIL PROTECTED] Subject: RE: RE: XML support under mySQL For some reason I don't think this was understood of what I said earlier. THE "DATABASE" ISN'T RESPONSIBLE FOR XML But, just because the database isn't responsible doesn't mean that the application is responsible for generating XML. Due to the fact I don't have my computer science degree like Ed Carp said we all should. I'm going to claim stupidity and yet still say my $0.02. We all know that the database is not responsible, nor should it be responsible for only making it's data accessible through XML. This is not at all what people need, nor are they asking for this. All people want is a way to put this wrapper on MySQL to be able to send queries to and have the output be in XML. There is no problem with this, nor should there be months of debate on whether or not this is a database function because it's obviously not. What people want is to have MySQL, an Open Source Database that is pretty damn good, take the initiative and make this wrapper to distribute with MySQL. Now if someone else wants to do this that's no big deal, let's just give MySQL a copy so that they distribute it with MySQL. You can't preach to me about how hard this is. If it wasn't for the fact I've been stuck working on Microsoft the past year I would do it in a couple days, I've already dome similar to create an XML feed manually for Microsoft SQL using ASP. Aaron Weiker -Original Message- From: Ed Carp [mailto:[EMAIL PROTECTED]] Sent: Wednesday, February 21, 2001 7:42 PM To: [EMAIL PROTECTED]; [EMAIL PROTECTED]; [EMAIL PROTECTED] Subject: Re: RE: XML support under mySQL Mehalick, Richard RE SSI-GRAX ([EMAIL PROTECTED]) writes: Some relational databases return results in XML format. And operating systems have been written in Java and Perl. So? Just because you *can* doesn't mean you *should*. Suppose I want to translate the output to something else. Now I'm stuck - I have to strip off the XML. *MUCH* cleaner to have the database return just data - then you can use something else to wrap the data in anything you want - XML, HTML, PHP, whatever. We use this approach in Escapade - it outputs just data - you decide how you want it wrapped. The idea of decoupling data and metadata is a powerful one and has strong, compelling arguments in its favor - ane one usually taught in first-year computer science classes. -- Ed Carp, N7EKG [EMAIL PROTECTED] 940/367-2744 cell phone http://www.pobox.com/~erc [EMAIL PROTECTED] - text pager I sometimes wonder if the American people deserve to be free - they seem so unwilling to fight to preserve the few freedoms they have left. - 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: mysqldump output file not valid as input file for mysql client
Matt Loschert writes: On Thu, 22 Feb 2001, Sinisa Milivojevic wrote: [EMAIL PROTECTED] writes: Description: As of mysql 3.23.33, a dumpfile generated with mysqldump (using the flags: --opt --all-databases) creates a file which will not be uploaded correctly using the mysql client (as in: 'mysql -u root -pXX -q -s dumpfile.sql'). Specifically, the problem relates to mysqldump's outputting of table keys. See the actual dump of mysql.db below: DROP TABLE IF EXISTS db; CREATE TABLE db ( Host char(60) binary NOT NULL default '', Db char(64) binary NOT NULL default '', User char(16) binary NOT NULL default '', Select_priv enum('N','Y') NOT NULL default 'N', Insert_priv enum('N','Y') NOT NULL default 'N', Update_priv enum('N','Y') NOT NULL default 'N', Delete_priv enum('N','Y') NOT NULL default 'N', Create_priv enum('N','Y') NOT NULL default 'N', Drop_priv enum('N','Y') NOT NULL default 'N', Grant_priv enum('N','Y') NOT NULL default 'N', References_priv enum('N','Y') NOT NULL default 'N', Index_priv enum('N','Y') NOT NULL default 'N', Alter_priv enum('N','Y') NOT NULL default 'N', PRIMARY KEY (Host,Db,User), KEY User(User) pukes on this line ) TYPE=MyISAM COMMENT='Database privileges'; If a space is added (as in: "KEY User (User)"), the file will import correctly. I looked through the source file mysqldump.c and it appears that there always should be a space between the key name and the key columns, but my personal dumpfiles show that all non-primary keys have no space between the key name and the key column names. Go figure. :) Needless to say I don't get it. How-To-Repeat: See above description. Fix: See above description. Submitter-Id: submitter ID Originator:Matt Loschert Organization: Matt Loschert | email: [EMAIL PROTECTED]| Software Engineer | web: http://www.servint.net/ | ServInt Internet Services | phone: (703) 847-1381 | MySQL support: none Synopsis: mysqldump output file not valid as input file for mysql client Severity: non-critical Priority: medium Category: mysql Class: sw-bug Release: mysql-3.23.33 (Source distribution) Environment: System: FreeBSD delft.servint.com 4.2-STABLE FreeBSD 4.2-STABLE #0: Tue Feb 6 11:43:35 EST 2001 [EMAIL PROTECTED]:/disk2/cvsup/branches/releng_4/obj/disk2/cvsup/branches/releng_4/src/sys/QUICKIE 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 1169450 Feb 6 12:05 /usr/lib/libc.a lrwxr-xr-x 1 root wheel 9 Feb 6 12:05 /usr/lib/libc.so - libc.so.4 -r--r--r-- 1 root wheel 559516 Feb 6 12:05 /usr/lib/libc.so.4 Configure command: ./configure --prefix=/usr/local/mysql-23.33 --with-low-memory Perl: This is perl, version 5.005_03 built for i386-freebsd Hi! The above happens as USER is a keyword in MySQL. Regards, Sinisa Sure, but this is a standard dump of the whole database, and the mysql client is having problems reloading the **mysql** database. The mysql.db table defines this key, not one of my tables. If you cannot use the --all-databases flag to mysqldump to make a valid backup file, what is the flag useful for? :) By the way, this used to work. I am not sure exactly what release it stopped working in. Thanks for the help. - Matt -- Matt Loschert| email: [EMAIL PROTECTED]| Software Engineer | web: http://www.servint.net/ | ServInt Internet Services| phone: (703) 847-1381 | It is not client bug, but a server bug. We shall put on our TODO to fix that. 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)
Suport of cirilic-???
Dear support group of MySQL, I want thank you for this good (best) SQL server. But when I use MySQL for Windows with languages like Ukrainian, Rassian I can't use case insensitive select, or operator like Upper. Can you help me? Sincerely, Anatolii.
Re: mysqldump output file not valid as input file for mysql client
On Thu, 22 Feb 2001, Sinisa Milivojevic wrote: Matt Loschert writes: On Thu, 22 Feb 2001, Sinisa Milivojevic wrote: [EMAIL PROTECTED] writes: Description: As of mysql 3.23.33, a dumpfile generated with mysqldump (using the flags: --opt --all-databases) creates a file which will not be uploaded correctly using the mysql client (as in: 'mysql -u root -pXX -q -s dumpfile.sql'). Specifically, the problem relates to mysqldump's outputting of table keys. See the actual dump of mysql.db below: DROP TABLE IF EXISTS db; CREATE TABLE db ( Host char(60) binary NOT NULL default '', Db char(64) binary NOT NULL default '', User char(16) binary NOT NULL default '', Select_priv enum('N','Y') NOT NULL default 'N', Insert_priv enum('N','Y') NOT NULL default 'N', Update_priv enum('N','Y') NOT NULL default 'N', Delete_priv enum('N','Y') NOT NULL default 'N', Create_priv enum('N','Y') NOT NULL default 'N', Drop_priv enum('N','Y') NOT NULL default 'N', Grant_priv enum('N','Y') NOT NULL default 'N', References_priv enum('N','Y') NOT NULL default 'N', Index_priv enum('N','Y') NOT NULL default 'N', Alter_priv enum('N','Y') NOT NULL default 'N', PRIMARY KEY (Host,Db,User), KEY User(User) pukes on this line ) TYPE=MyISAM COMMENT='Database privileges'; If a space is added (as in: "KEY User (User)"), the file will import correctly. I looked through the source file mysqldump.c and it appears that there always should be a space between the key name and the key columns, but my personal dumpfiles show that all non-primary keys have no space between the key name and the key column names. Go figure. :) Needless to say I don't get it. How-To-Repeat: See above description. Fix: See above description. Submitter-Id:submitter ID Originator: Matt Loschert Organization: Matt Loschert | email: [EMAIL PROTECTED] | Software Engineer | web: http://www.servint.net/ | ServInt Internet Services | phone: (703) 847-1381 | MySQL support: none Synopsis:mysqldump output file not valid as input file for mysql client Severity:non-critical Priority:medium Category:mysql Class: sw-bug Release: mysql-3.23.33 (Source distribution) Environment: System: FreeBSD delft.servint.com 4.2-STABLE FreeBSD 4.2-STABLE #0: Tue Feb 6 11:43:35 EST 2001 [EMAIL PROTECTED]:/disk2/cvsup/branches/releng_4/obj/disk2/cvsup/branches/releng_4/src/sys/QUICKIE 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 1169450 Feb 6 12:05 /usr/lib/libc.a lrwxr-xr-x 1 root wheel 9 Feb 6 12:05 /usr/lib/libc.so - libc.so.4 -r--r--r-- 1 root wheel 559516 Feb 6 12:05 /usr/lib/libc.so.4 Configure command: ./configure --prefix=/usr/local/mysql-23.33 --with-low-memory Perl: This is perl, version 5.005_03 built for i386-freebsd Hi! The above happens as USER is a keyword in MySQL. Regards, Sinisa Sure, but this is a standard dump of the whole database, and the mysql client is having problems reloading the **mysql** database. The mysql.db table defines this key, not one of my tables. If you cannot use the --all-databases flag to mysqldump to make a valid backup file, what is the flag useful for? :) By the way, this used to work. I am not sure exactly what release it stopped working in. Thanks for the help. - Matt -- Matt Loschert | email: [EMAIL PROTECTED]| Software Engineer | web: http://www.servint.net/ | ServInt Internet Services | phone: (703) 847-1381 | It is not client bug, but a server bug. We shall put on our TODO to fix that. Regards, Sinisa Thanks, I appreciate the help. - Matt -- Matt Loschert | email: [EMAIL PROTECTED]| Software Engineer | web: http://www.servint.net/ | ServInt Internet Services | phone: (703) 847-1381 | - Before posting, please check: http://www.mysql.com/manual.php (the manual)
RE: Quoting numbers? (was Re:MySQL Tables)
It's all to do with data types, traditionally and across most languages quotes are used to delimit STRINGS and a string is NOT a number although may represent one when displayed. -Original Message- From: Pete Harlan [SMTP:[EMAIL PROTECTED]] Sent: 21 February 2001 20:51 To: [EMAIL PROTECTED] Subject: Quoting numbers? (was Re:MySQL Tables) I think you'll get better results if you don't quote your numbers. Quotes should be used for text and dates (depending) but not numbers. Out of curiosity, why? We use quotes for numbers all the time here, for consistency's sake; the programmer doesn't have to worry about the representation of, say, a salesman_id, but just reads/displays/stores it in the database. Aside from the fact that leaving them off is possible, is there a standards/compatibility/other reason to do so? (An example of a good reason not to use them would be if the db engine weren't smart enough to use an index when you say select * from table_name where numeric_key = '1234' but possibly (probably?) all dbms's are that smart.) --Pete - 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: Printed MySQL manual
The distributions come with a text version of the manual so you can download one and print it yourself but beware it is rather large. -Original Message- From: Thalis A. Kalfigopoulos [SMTP:[EMAIL PROTECTED]] Sent: 21 February 2001 21:05 To: [EMAIL PROTECTED] Subject: Re: Printed MySQL manual Denis: I'm not sure you really want a printed MySQL manual ... the software is dynamic, and is constantly being upgraded. The online manual is updated frequently, and is closer to the software you may be using. As an alternative, I would suggest one of the fine books on MySQL. Our developers each have a copy of the Paul DuBois book ("MySQL" / New Riders) as well as the O'Reilly book "MySQL mSQL". Both are excellent learning and reference resources, and are invaluable in understanding and applying SQL syntax. I assume both are pretty good (I can verify that the 2nd one is indeed), but still they are begining to show signs of their age. Mysql develops very fast and they are both '99 books (IIRC). Does anyone know of any plans for 2nd editions? cheers, thalis - 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: Cannot connect to local mySQL server through socket error (111)
Chuang Keng Chee wrote: Hi! Socket file specified is : /var/lib/mysql/mysql.sock which on my system has a filesize of zero. I'm running a Red Hat 7.0, Kernel 2.2.16-22smp which I installed with MySQL (ie, MySQL wasn't installed separately from source files.) I've got three copies of mysqld running when I do a ps (so, no problems with linuxthreads there.) In the /var/lib/mysql directory, there's an error file that said it could not create/write the mysql.pid file into /var/run. Since the /var/run directory is owned by root and mysql did not have write permissions, I gave write permissions to the others group. Still no luck. Is there some other configuration I need to do to get it to work ? Don't see why something installed out of the box should be having such problems. Thanks for any help. P.S. Searched through the lists archives, but only got back garbage from the mailing list on this problem. If you installed it out of the Red Hat box, then that is the problem. Go to redhat.com and get the fixxed rpm, or fix all your permissions manually. I'll bet this question has been covered 100 times. I'm sure it is in the archives. - 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
double InnerJoin -how?
I have three tables: one with contacts, one with members, and one that links the members to a group. How do I make a SQL-string, that gets the members from a specifik group, AND the contacts that belongs to this group as well? Won't I have to make a double InnerJoin? Kind regards, /Henrik Mohr - 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: Oddity with date subtraction - bug?
Basil Hussain wrote: Hi all, I recently did a query to subtract one DATETIME column from another, but I got odd results for one row and correct results for others. These queries expand upon what I was doing: mysql SELECT impression, click, click - impression AS diff, DATE_SUB(click, INTERVAL click - impression SECOND) AS calc FROM eventlog; +-+-+--+-+ | impression | click | diff | calc| +-+-+--+-+ | 2001-02-22 12:07:03 | 2001-02-22 12:09:04 | 201 | 2001-02-22 12:05:43 | | 2001-02-22 12:14:39 | 2001-02-22 12:14:44 |5 | 2001-02-22 12:14:39 | | 2001-02-22 12:16:13 | 2001-02-22 12:16:17 |4 | 2001-02-22 12:16:13 | +-+-+--+-+ 3 rows in set (0.00 sec) mysql SELECT TIME_TO_SEC('00:02:01'); +-+ | TIME_TO_SEC('00:02:01') | +-+ | 121 | +-+ 1 row in set (0.00 sec) mysql SELECT SEC_TO_TIME(201); +--+ | SEC_TO_TIME(201) | +--+ | 00:03:21 | +--+ 1 row in set (0.00 sec) As you can see, the difference between the two dates on the first record is clearly 2 minutes, 1 second - which works out as 121 seconds. However, MySQL thinks it's 201 seconds, which is actually 3 minutes 21 seconds - wrong! 2 min and 1 sec, like 0201 ? - 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
synopsis of the problem (one line)
Description: How-To-Repeat: Fix: Submitter-Id: submitter ID Originator:root Organization: MySQL support: [none | licence | email support | extended email support ] Synopsis: Severity: Priority: Category: mysql Class: Release: mysql-3.22.32 (Source distribution) Server: /usr/bin/mysqladmin Ver 8.0 Distrib 3.22.32, for suse-linux on i686 TCX Datakonsult AB, by Monty Server version 3.22.32 Protocol version10 Connection Localhost via UNIX socket UNIX socket /tmp/mysql.sock Uptime: 1 day 23 hours 48 min 9 sec Threads: 1 Questions: 728 Slow queries: 0 Opens: 12 Flush tables: 1 Open tables: 8 Environment: System: Linux dioweb02 2.2.16-SMP #1 SMP Wed Aug 2 20:01:21 GMT 2000 i686 unknown Architecture: i686 Some paths: /usr/bin/perl /usr/bin/make /usr/bin/gmake /usr/bin/gcc /usr/bin/cc GCC: Reading specs from /usr/lib/gcc-lib/i486-suse-linux/2.95.2/specs gcc version 2.95.2 19991024 (release) Compilation info: CC='gcc' CFLAGS='' CXX='c++' CXXFLAGS='' LDFLAGS='' Configure command: ./configure --enable-shared --enable-assembler --prefix=/usr --libdir=/usr/lib --libexecdir=/usr/sbin --sysconfdir=/etc --localstatedir=/var/mysql --infodir=/usr/share/info --mandir=/usr/share/man --without-debug --with-mysqld-user=mysql Perl: This is perl, version 5.005_03 built for i586-linux - 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
Sorry, delay in MySQL/Innobase distribution
Hi, readers of the mailing list! Sorry, we were not yet able to roll a distribution of MySQL-3.23.3x/Innobase yesterday. Monty is now traveling in South America for a week, and the distribution will take still some time. Currently, MySQL/Innobase runs on Win NT, Linux Intel, Linux Compaq Alpha 64-bit, and Solaris Sparc 32-bit. On FreeBSD there are still problems. I will tell more as there is progress. Regards, Heikki Tuuri Innobase Oy Helsinki, Finland - 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
ReisserFS
Hi Has anyone user MySql on a ReisserFS file system ? Where any problems encountered ? and do you have any pearls of wisdom that you are willing to share ? Thanks Simon -- Simon Windsor CricInfo http://www.cricinfo.com/ Tel: +44 (0) 1249 700720 Fax: +44 (0) 1249 700725 Email: mailto:[EMAIL PROTECTED] This email message is for the sole use of the intended recipient(s) and may contain confidential and privileged information. Any unauthorized review, use, disclosure or distribution is prohibited. If you are not the intended recipient, please contact the sender by reply email and destroy all copies of the original message. Thank you for your cooperation and assistance. - 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: Oddity with date subtraction - bug?
Hi, mysql SELECT impression, click, click - impression AS diff, DATE_SUB(click, INTERVAL click - impression SECOND) AS calc FROM eventlog; +-+-+--+-+ | impression | click | diff | calc| +-+-+--+-+ | 2001-02-22 12:07:03 | 2001-02-22 12:09:04 | 201 | 2001-02-22 12:05:43 | | 2001-02-22 12:14:39 | 2001-02-22 12:14:44 |5 | 2001-02-22 12:14:39 | | 2001-02-22 12:16:13 | 2001-02-22 12:16:17 |4 | 2001-02-22 12:16:13 | +-+-+--+-+ 3 rows in set (0.00 sec) As you can see, the difference between the two dates on the first record is clearly 2 minutes, 1 second - which works out as 121 seconds. However, MySQL thinks it's 201 seconds, which is actually 3 minutes 21 seconds - wrong! 2 min and 1 sec, like 0201 ? Ah, now I see why it's "201"! Just to check it's not a coincidence though, I got MySQL to calculate the difference between now and 60 seconds ago: mysql SELECT NOW() - DATE_SUB(NOW(), INTERVAL 60 SECOND) AS calc; +--+ | calc | +--+ | 100 | +--+ 1 row in set (0.00 sec) So, this makes sense, according to the above. But, the question remains - why the hell does MySQL return the result of the subtraction/addition in this format? It's completely un-intelligable. I probably would have guessed if it was "0201" or "000201", but it's just stupid how it does it. To prove this, I just did another test: mysql SELECT NOW() - DATE_SUB(NOW(), INTERVAL 7 MONTH) AS calc; ++ | calc | ++ | 95 | ++ 1 row in set (0.00 sec) What the hell is "95" supposed to represent? Can anyone explain the rational behind this? Anyway, this is clearly not gonna be suitable for subtracting/adding dates, so I suppose I'll have to resort to something ugly like converting each date to a timestamp before subtracting. Regards, Basil Hussain ([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
OLE DB Provider?
Hello everyone, I was wondering if the folks at MySQL were considering developing an OLE DB provider. I ask because, including myself, there seems to be quite a large number of developers who traditionally used MS DB products, moving over MySQL for many applications. Don't get me wrong, using ADO with the MyODBC provider works great. (A world better than Access DB's). I've seen a couple of more proprietary interfaces, but was hoping for something that would come from the MySQL team to ensure that it would be around for some time? Any Idea? Lee Jenkins - 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: BDB Problem with MAX() and multipart primary keys
It's a miracle. Which version of the BDB patch do you use? I'm using 3.2.9a. (Previously, there has been a version 3.2.3g...) Thanks... Gnther Pewny Sinisa Milivojevic wrote: Guenther Pewny writes: Hi folks, I have a problem with BDB tables. Please look at this short mysql session: mysql create table sample ( id1 int(8) not null, id2 int(8) not null, primary key (id1,id2)) type=BDB; Query OK, 0 rows affected (0.67 sec) mysql insert into sample values (1, 2); Query OK, 1 row affected (0.07 sec) mysql select id2 from sample where id1=1; +-+ | id2 | +-+ | 2 | +-+ 1 row in set (0.00 sec) mysql select min(id2) from sample where id1=1; +--+ | min(id2) | +--+ |2 | +--+ 1 row in set (0.00 sec) mysql select max(id2) from sample where id1=1; +--+ | max(id2) | +--+ | NULL | +--+ 1 row in set (0.00 sec) Is this a bug in mySQL? Why does MIN() return the correct result, while MAX() does not? Is it a severe bug which possibly can cause data inconsistency within the table data or does there exist a "good" workaround for this problem with only modifying the query? Thanks Gnther Pewny Hi! I have just tested this with 3.23.33 and it executed just fine !! 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
INSERT DELAYED crashes Mysql 3.23.33
Hi! I am trying to insert 1 000 000 records into a very simple table: create table test ( a1 tinyint unsigned not null, a2 tinyint unsigned not null, a3 tinyint unsigned not null, a4 tinyint unsigned not null, primary key (a1,a2,a3,a4) ); So, to make it faster i want to use INSERT DELAYED, however, when i do so, i get a message "Server has gone away" and the in the .err log i see mysqld got signal 11. I could not use INSERT DELAY in 3.23.30 and up. never tried it earlier. Now other problems detected whatsoever under any amount of load. Mysql is 3.23.33 compiled from the tar ball (NOT FROM PORTS) with the options recomended in the ports to stop it from crashing on heavy loads. OS: FreeBSD 4.2-STABLE Regards, Artem - 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: ReisserFS
On Thu, 22 Feb 2001, Simon Windsor wrote: Has anyone user MySql on a ReisserFS file system ? Where any problems encountered ? and do you have any pearls of wisdom that you are willing to share ? No problems at all. Even power outages and severe crashes did not touch the MySQL stuff on the ReiserFS file system, but that's probably all luck. :-) Regards, Jan - 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: Auto-Inc question
In a message dated 22/02/2001 12:22:26 GMT Standard Time, [EMAIL PROTECTED] writes: 30 seconds work(less time than it took you to type your email) would've revealed the answer: 1. Click on "the manual" link at the bottom of this message. 2. See the search box? Type in "auto increment". 3. Click on the "myisamchk" link. 4. Read. Or, to make it even easier: http://www.mysql.com/doc/m/y/myisamchk_other_options.html Please, next time, bother to search the manual before wasting other's time answering questions to which 30 seconds research would reveal the answer. -- Ed Carp, N7EKG [EMAIL PROTECTED] 940/367-2744 cell phone http://www.pobox.com/~erc [EMAIL PROTECTED] - text pager Ok well thats the the third reply I have just read of yours to peoples questions, I did research it but was trying to find a better method, I came up with the method of logging into mysql deleting the ID row recreating it and viola done. To me much faster than your method. Also seeing as this was the third post of yours which wasn`t very constructive to peoples questions might I suggest you don`t bother replying if we are wasting your time, the delete button is there for a reason and this mailing list is for asking questions. Ade - 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: Oddity with date subtraction - bug?
Basil Hussain wrote: Hi, mysql SELECT impression, click, click - impression AS diff, DATE_SUB(click, INTERVAL click - impression SECOND) AS calc FROM eventlog; +-+-+--+-+ | impression | click | diff | calc| +-+-+--+-+ | 2001-02-22 12:07:03 | 2001-02-22 12:09:04 | 201 | 2001-02-22 12:05:43 | | 2001-02-22 12:14:39 | 2001-02-22 12:14:44 |5 | 2001-02-22 12:14:39 | | 2001-02-22 12:16:13 | 2001-02-22 12:16:17 |4 | 2001-02-22 12:16:13 | +-+-+--+-+ 3 rows in set (0.00 sec) As you can see, the difference between the two dates on the first record is clearly 2 minutes, 1 second - which works out as 121 seconds. However, MySQL thinks it's 201 seconds, which is actually 3 minutes 21 seconds - wrong! 2 min and 1 sec, like 0201 ? Ah, now I see why it's "201"! Just to check it's not a coincidence though, I got MySQL to calculate the difference between now and 60 seconds ago: mysql SELECT NOW() - DATE_SUB(NOW(), INTERVAL 60 SECOND) AS calc; +--+ | calc | +--+ | 100 | +--+ 1 row in set (0.00 sec) So, this makes sense, according to the above. But, the question remains - why the hell does MySQL return the result of the subtraction/addition in this format? It's completely un-intelligable. I probably would have guessed if it was "0201" or "000201", but it's just stupid how it does it. To prove this, I just did another test: mysql SELECT NOW() - DATE_SUB(NOW(), INTERVAL 7 MONTH) AS calc; ++ | calc | ++ | 95 | ++ 1 row in set (0.00 sec) What the hell is "95" supposed to represent? Can anyone explain the rational behind this? Anyway, this is clearly not gonna be suitable for subtracting/adding dates, so I suppose I'll have to resort to something ugly like converting each date to a timestamp before subtracting. Regards, Basil Hussain ([EMAIL PROTECTED]) select now()-0, and you will see the answer is MMDDhhmmss. Now, represent 2 dates as strings of 14 numeric characters, and subtract them as numbers. Does it mean anything? Well, since the numbering system changes about 5 times as you move from left to right through the string, and the math is done base 10, I think it would be difficult to make much sense of the result. - 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
Suggestion For List Management
Here's an idea for the list memebers and list master Since a lot messages have undescriptive subjects ("Help", "Check This", "What's This?", etc...) I think it would be a good idea to set up the majordomo to add a tag to each subject line like the PHP list does. For instance Subj: Help become: Subj: [MYSQL] Help I've only been on the list for a day and a half. However I'm a memeber of 3 high-volume lists and I can tell that adopting this technique would make my life easier, and presumably other list memebers too. It definitely makes it easier to sort through your e-mails. Anyway, that's my 2 -Jeff Gannaway [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: ReisserFS
On Thu, Feb 22, 2001 at 03:22:13PM +, Simon Windsor wrote: Hi Has anyone user MySql on a ReisserFS file system ? Yes. Where any problems encountered ? and do you have any pearls of wisdom that you are willing to share ? It "just works". :-) -- Jeremy D. Zawodny, [EMAIL PROTECTED] Technical Yahoo - Yahoo Finance Desk: (408) 328-7878Fax: (408) 530-5454 Cell: (408) 439-9951 - 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: Transactions in 3.23.33 ?
AFAIK, the 3.23.33 binaries don't include the BDB table handler - you have to build mysql from source after unpacking the BDB module into your mysql source tree. On the other hand, I've read that the 3.23.34 version (it should be online these days) has BDB _and_ INNOBASE integrated. As posted some days ago, I've had problems with BDB queries concerning multipart primary keys / indexes. I am very hopeful (I found something similar in the 3.23.34 "done" list) that this bug is solved in the new version. So, I recommed to wait until 3.23.34 is available. Gnther Pewny Bruce Percy wrote: Has transaction management present in the 3.23.33 binary distribution of MySQL? When creating BDB tables and trying to use them inside transactions I fail to get them to work. There's no error messages and the transactions seem to be ignored. I've tried this on Linux and NT. -- Bruce Percy Peopledoc 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 - 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
Hi Is there any way when i just copy the service file and other related file to run mysql instead of installing fully on my system. Thanks sanjeev -Original Message- From: Simon Windsor [mailto:[EMAIL PROTECTED]] Sent: Thursday, February 22, 2001 10:22 AM To: [EMAIL PROTECTED] Subject: ReisserFS Hi Has anyone user MySql on a ReisserFS file system ? Where any problems encountered ? and do you have any pearls of wisdom that you are willing to share ? Thanks Simon -- Simon Windsor CricInfo http://www.cricinfo.com/ Tel: +44 (0) 1249 700720 Fax: +44 (0) 1249 700725 Email: mailto:[EMAIL PROTECTED] This email message is for the sole use of the intended recipient(s) and may contain confidential and privileged information. Any unauthorized review, use, disclosure or distribution is prohibited. If you are not the intended recipient, please contact the sender by reply email and destroy all copies of the original message. Thank you for your cooperation and assistance. - 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: BDB Problem with MAX() and multipart primary keys
Guenther Pewny writes: It's a miracle. Which version of the BDB patch do you use? I'm using 3.2.9a. (Previously, there has been a version 3.2.3g...) Thanks... Gnther Pewny Hi! I used latest source tarball from our 3.23 page. 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: ReisserFS
-Original Message- From: Simon Windsor [mailto:[EMAIL PROTECTED]] Sent: 22 February 2001 16:22 To: [EMAIL PROTECTED] Subject: ReisserFS Hi Has anyone user MySql on a ReisserFS file system ? Where any problems encountered ? and do you have any pearls of wisdom that you are willing to share ? Thanks Simon Why would there be conflics? Reiserfs and MySQL dont know anything about eachother, the first one is a filysystem, the second one a database that lives on top of it. But to answer your question - yes, I've been using mysql on reiserfs for a long time now, works perfect. MySQL wont become any faster or anything, but it works. (I installed reiserfs because I was tired of the long ext2 waiting times when deleting/checking a 30Gb partition.) -S - 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: ReisserFS
Hi, Is any body knows that is there nay way to use mySQL with out installing it fully. I mean to say just install service manager and other required drivers. Or can somebody let me know that what are the minium service require from mysql setup to run the mySQL server to win NT. Sanjeev -Original Message- From: Jan-Aage Bruvoll [mailto:[EMAIL PROTECTED]] Sent: Thursday, February 22, 2001 10:58 AM To: [EMAIL PROTECTED] Cc: [EMAIL PROTECTED] Subject: Re: ReisserFS On Thu, 22 Feb 2001, Simon Windsor wrote: Has anyone user MySql on a ReisserFS file system ? Where any problems encountered ? and do you have any pearls of wisdom that you are willing to share ? No problems at all. Even power outages and severe crashes did not touch the MySQL stuff on the ReiserFS file system, but that's probably all luck. :-) Regards, Jan - 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: ReisserFS
Jan-Aage Bruvoll writes: On Thu, 22 Feb 2001, Simon Windsor wrote: No problems at all. Even power outages and severe crashes did not touch the MySQL stuff on the ReiserFS file system, but that's probably all luck. :-) Regards, Jan No, that is not just luck. ReiserFS is a journalling file system. 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: ReisserFS
On Thu, 22 Feb 2001, Sinisa Milivojevic wrote: No, that is not just luck. ReiserFS is a journalling file system. Sure thing. The luck part was referring to the fact that even the consistency in the tables was ok, which is more on the luck side, since all buffers were flushed at the time of the crashes. Regards, Jan - 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: ReisserFS
Jan-Aage Bruvoll writes: On Thu, 22 Feb 2001, Sinisa Milivojevic wrote: No, that is not just luck. ReiserFS is a journalling file system. Sure thing. The luck part was referring to the fact that even the consistency in the tables was ok, which is more on the luck side, since all buffers were flushed at the time of the crashes. Regards, Jan That is true, unless you are using BDB. Then even flushing buffers should not matter. 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: Suggestion For List Management
¡Hola! [That's a recurrent theme in all mailing lists. Look in the archives the long answers] Yet again, no. Just learn to configure your MUA. HoraPe On Thu, Feb 22, 2001 at 11:08:06AM +, Jeff Gannaway wrote: Here's an idea for the list memebers and list master Since a lot messages have undescriptive subjects ("Help", "Check This", "What's This?", etc...) I think it would be a good idea to set up the majordomo to add a tag to each subject line like the PHP list does. For instance Subj: Help become: Subj: [MYSQL] Help I've only been on the list for a day and a half. However I'm a memeber of 3 high-volume lists and I can tell that adopting this technique would make my life easier, and presumably other list memebers too. It definitely makes it easier to sort through your e-mails. Anyway, that's my 2¢ -Jeff Gannaway [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 -- HoraPe --- Horacio J. Peña [EMAIL PROTECTED] [EMAIL PROTECTED] [EMAIL PROTECTED] [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: Suggestion For List Management
Well, you could filter anything sent or cc'ed to [EMAIL PROTECTED] into a separate folder -Original Message- From: Jeff Gannaway [mailto:[EMAIL PROTECTED]] Sent: 22 February 2001 11:08 To: [EMAIL PROTECTED] Subject: Suggestion For List Management Here's an idea for the list memebers and list master Since a lot messages have undescriptive subjects ("Help", "Check This", "What's This?", etc...) I think it would be a good idea to set up the majordomo to add a tag to each subject line like the PHP list does. For instance Subj: Help become: Subj: [MYSQL] Help I've only been on the list for a day and a half. However I'm a memeber of 3 high-volume lists and I can tell that adopting this technique would make my life easier, and presumably other list memebers too. It definitely makes it easier to sort through your e-mails. Anyway, that's my 2 -Jeff Gannaway [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 ** 'The information included in this Email is of a confidential nature and isi ntended only for the addressee. If you are not the intended addressee, any disclosure, copying or distribution by you is prohibited and may be unlawful. Disclosure to any party other than the addressee, whether inadvertent or otherwise is not intended to waive privilege or confidentiality' ** - 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: Suggestion For List Management
Jeff, This has been discussed before and I find it easier to just sort by the 'from' header in the message. Check the archives for more disscussion. Have a great day... John On Thursday 22 February 2001 06:08, Jeff Gannaway wrote: Here's an idea for the list memebers and list master Since a lot messages have undescriptive subjects ("Help", "Check This", "What's This?", etc...) I think it would be a good idea to set up the majordomo to add a tag to each subject line like the PHP list does. For instance Subj: Help become: Subj: [MYSQL] Help I've only been on the list for a day and a half. However I'm a memeber of 3 high-volume lists and I can tell that adopting this technique would make my life easier, and presumably other list memebers too. It definitely makes it easier to sort through your e-mails. Anyway, that's my 2 -Jeff Gannaway [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 - 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: Suggestion For List Management
Hey - Since a lot messages have undescriptive subjects ("Help", "Check This", "What's This?", etc...) I think it would be a good idea to set up the majordomo to add a tag to each subject line like the PHP list does. "[MYSQL] Help" is hardly more descriptive than "Help". My solution is to filter my messages into different mailboxes (i.e. 'MySQL') based on From or pretty much anything in the header with 'mysql'. The only reason one might want to append or prefix a static tag to every subject is if you don't have a mail program that can filter messages and you have to do an optical (eyeball) scan, y'know? I'd rather not have subject lines lengthened by the appendage of static text - get yerself a filter!!! Also, the MySQL list seems like an unusually talented bunch who rarely use generic subject lines - kudos! two more cents -- Jesse I've only been on the list for a day and a half. However I'm a memeber of 3 high-volume lists and I can tell that adopting this technique would make my life easier, and presumably other list memebers too. It definitely makes it easier to sort through your e-mails. Anyway, that's my 2 -Jeff Gannaway [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 - 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: ReisserFS
RE ReiserFS What is the hardware (32 bit or 64) and what is the maximum files size MySql will support on it? Thanks. Sincerely, William Mussatto, Senior Systems Engineer CyberStrategies, Inc ph. 909-920-9154 ext. 27 - 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
Fields
Hi, Are there certain chacters that a VARCHAR field can't store? If I xor encrypt a #, I get non-alphanumeric characters: Ex: 123456789123 may end up 1 YdR Is this a problem to store properly, should I use a different field type other than varchar? Thanks, Chris
Re: ReisserFS
On Thu, 22 Feb 2001, William R. Mussatto wrote: What is the hardware (32 bit or 64) and what is the maximum files size MySql will support on it? Thanks. I'm a mere end user when it comes to ReiserFS... I think you should be able to find all information you need on http://www.reiserfs.com/ As for MySQL, I guess the Fine Manual is the place to check, or even a search on http://www.google.com/ might do it. (The question has been asked before on the list, but I do not remember the correct answer.) Regards, Jan-Aage -- Mr. Jan-Aage Bruvoll Managing Director Bruvoll Brains in Bits, 7a Neal's Yard, London WC2H 9DP, UK Office/fax: +44 20 72408283 Mobile: +44 7740291600 - 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
abort in configure
Description: How-To-Repeat: Fix: Submitter-Id: submitter ID Originator:Pascal de Marichalar Organization: SIRIS MySQL support: none Synopsis: abort in "configure" Severity: critical Priority: high Category: mysql Class: support Release: mysql-3.23.33 (Source distribution) Environment: System: Linux linux.siris.fr 2.2.16-22 #1 Tue Aug 22 16:49:06 EDT 2000 i686 unknown Architecture: i686 Some paths: /usr/bin/perl /usr/bin/make /usr/bin/gmake /usr/bin/gcc /usr/bin/cc GCC: Reading specs from /usr/lib/gcc-lib/i386-redhat-linux/2.96/specs gcc version 2.96 2731 (Red Hat Linux 7.0) Compilation info: CC='gcc' CFLAGS='' CXX='gcc' CXXFLAGS='' LDFLAGS='' LIBC: lrwxrwxrwx1 root root 14 nov 23 18:05 /lib/libc.so.6 - libc-2.1.92.so -rwxr-xr-x1 root root 4776568 aoû 31 02:56 /lib/libc-2.1.92.so -rw-r--r--1 root root 22607104 aoû 31 02:15 /usr/lib/libc.a -rw-r--r--1 root root 178 aoû 31 02:15 /usr/lib/libc.so Configure command: ./configure --with-unix-socket-path=/var/tmp/mysql.sock --with-low-memory --with-mit-threads=yes --without-perl --enable-thread-safe-client --without-berkeley-db ---last output from configure--- -I/usr/local/BerkeleyDB.3.2/include -I./../include -I./../regex -I. -I../include -I.. -I. -O3 -DDBUG_OFF -fno-implicit-templates -c ha_berkeley.cc ha_berkeley.cc:105: type specifier omitted for parameter ha_berkeley.cc:105: parse error before `)' ha_berkeley.cc: In function `bool berkeley_init ()': ha_berkeley.cc:143: no matching function for call to `__db_env::set_noticecall (DB_ENV *, void () (...))' ha_berkeley.cc: At top level: ha_berkeley.cc:292: type specifier omitted for parameter ha_berkeley.cc:292: parse error before `)' ha_berkeley.cc: In function `void berkeley_noticecall (...)': ha_berkeley.cc:294: `notice' undeclared (first use this function) ha_berkeley.cc:294: (Each undeclared identifier is reported only once for each function it appears in.) ha_berkeley.cc:296: `DB_NOTICE_LOGFILE_CHANGED' undeclared (first use this function) ha_berkeley.cc:297: warning: unreachable code at beginning of switch statement make[3]: *** [ha_berkeley.o] Erreur 1 make[3]: Quitte le ripertoire `/home/tmn/WebDynamic/mysql-3.23.33/sql' make[2]: *** [all-recursive] Erreur 1 make[2]: Quitte le ripertoire `/home/tmn/WebDynamic/mysql-3.23.33/sql' make[1]: *** [all-recursive] Erreur 1 make[1]: Quitte le ripertoire `/home/tmn/WebDynamic/mysql-3.23.33' make: *** [all-recursive-am] Erreur 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
Re: Turn off MySql Warning Messages
At 11:28 AM 2/22/2001 -0600, samsom, debra wrote: I would Like to Turn Off the following MySQL Connect Warning message. Any Suggestions??? Warning: MySQL Connection Failed: Can't connect to MySQL server on 'localhost' (10061) in e:\program files\apache group\apache\htdocs\dwg\dwg.php on line 22 Server Currently Unavailable This is the code that is returning the above error message. mysql_connect("localhost","root","") or die ("Server Currently Unavailable"); @mysql_connect("localhost","root","") or die ("Server Currently Unavailable"); Put the @ in front to suppress error messages. - Scott Baker - Webster Internet - Network Technician 503.266.8253 - [EMAIL PROTECTED] "Children today are tyrants. They contradict their parents, gobble their food, and tyrannize their teachers." - Socrates - 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: double InnerJoin -how?
Hi. On Thu, Feb 22, 2001 at 03:50:22PM +0100, [EMAIL PROTECTED] wrote: I have three tables: one with contacts, one with members, and one that links the members to a group. How do I make a SQL-string, that gets the members from a specifik group, AND the contacts that belongs to this group as well? SELECT m.name, g.name, c.name FROM members m, contacts c, group_members g WHERE m.id = g.member_id AND g.id = 12345 AND g.contacts_id = c.id If this isn't like what you want, please post again and include the SELECTs you already have belonging to the seperate inner joins. Won't I have to make a double InnerJoin? Yes, but what is the problem with that? If you use the INNER JOIN ... ON syntax, you just have to move the WHERE clause parts around: SELECT m.name, g.name, c.name FROM members m INNER JOIN group_members g ON m.id = g.member_id INNER JOIN contacts c ON g.contacts_id = c.id WHEHRE g.id = 12345 Bye, Benjamin. - 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
indexing
When is there going to be the ability to index in descending order? Adam C Buggia DirectAthletics Inc. W: 978 927 7188 C: 781 608 5952 - 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: Suggestion For List Management
Actually, I have a message filter that looks for mysql.com in the "To or CC" portion of the header and moves any mail to my mySQL folder. Thus I can tell which messages are from mysql list members and which messages are from my supervisors. Still, it might be nice to add the [MYSQL] piece in the subject line. Ron Jeff Gannaway wrote: Here's an idea for the list memebers and list master Since a lot messages have undescriptive subjects ("Help", "Check This", "What's This?", etc...) I think it would be a good idea to set up the majordomo to add a tag to each subject line like the PHP list does. For instance Subj: Help become: Subj: [MYSQL] Help I've only been on the list for a day and a half. However I'm a memeber of 3 high-volume lists and I can tell that adopting this technique would make my life easier, and presumably other list memebers too. It definitely makes it easier to sort through your e-mails. Anyway, that's my 2 -Jeff Gannaway [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 - 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: ReisserFS
I'd heard that even in general use, some users had a noticeable increase in disk reads/writes under ReiserFS...it sounds like you haven't experienced this (?). I'm thinking about moving over to ReiserFS as well, shortly, and am looking for as much feedback from people using it as possible... regards, P Why would there be conflics? Reiserfs and MySQL dont know anything about eachother, the first one is a filysystem, the second one a database that lives on top of it. But to answer your question - yes, I've been using mysql on reiserfs for a long time now, works perfect. MySQL wont become any faster or anything, but it works. (I installed reiserfs because I was tired of the long ext2 waiting times when deleting/checking a 30Gb partition.) -S - 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