MySQL client for AS/400
Has anyone ported a MySQL client to IBM AS/400? I have a customer (on AS/400) that would like to mirror some data to a MySQL server. Thank you for any help you can offer. Regards, Rich - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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: GLIBC 2.2.4
On Fri, 24 Aug 2001, Sinisa Milivojevic wrote: Trond Eivind Glomsrød writes: Peter Zaitsev [EMAIL PROTECTED] writes: I'm trying to compile mysql 3.23.41 with recent glibc 2.2.4 but this somehow does not work with the following diagnose: It builds just fine with glibc 2.2.4 on a current development version of Red Hat Linux (Roswell + a few minor updates). Did you compile glibc yourself or have you used gcc 3? You know better then me that 2.2.4 should NOT be built with gcc 3 ! Which was why I asked :) - 2.2.4 wants 2.96RH or 2.95.3 (2.95.2 should work on IA32, though) -- Trond Eivind Glomsrød Red Hat, Inc. - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
large table with text field -- performance?
I have a large (40 million rows) table that currently consists of a few integers and a varchar. I need to add a memo (text 255 chars) field to about 2% of the rows. Originally I was going to create another table with a key and the memo field, but this method is complicating the programming logic. The easiest solution would be to add the memo field right to this table, and use it only when needed. Does the presence of a memo fields affect the performance a lot? Are memos stored with the records themselves, or in a separate part of the table data (I believe Access and SQL-Server stores the memos separately, which can kill performance). Finally, in this case should I allow Null's and use them for the 98% empty fields? Thx, Tac - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Part-2 of not regexp
I hate when my dumbness shows on world-wide tv Please nullify my last query= Subject: not regexp - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Thougths on getting MySQL into the enterprise vs MSSQL Oracle
This is kind of an open letter and request for help. Also would apply to our pgSQL friends as well. What would be a major benefit is Guides/FAQs etc on converting from Oracle or MSSQL to MySQL and pgSQL Easy data conversion and export from Oracle MSSQL to MySQL and pgSQL And so on .. Today I can't convert anyone on using an open source DB but taking one step at a time, doing demonstration projects, etc. I can happen. Any thoughts, ideas, etc ? -pete Pete Lancashire Unix Systems Administration Columbia Sportswear Co. Inc. [EMAIL PROTECTED] (503) 978-4173 - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
religous studies intro
** Virus Warning Message (on steiner.cc.vt.edu) Found virus TROJ_SIRCAM.A in file religous studies intro.doc.com The uncleanable file was deleted. * Hi! How are you? I send you this file in order to have your advice See you later. Thanks ** Virus Warning Message (on steiner.cc.vt.edu) religous studies intro.doc.com was removed from here because it contained a virus. * - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
unique()
Hi I have a table with a filed that is unique (used unique() in the creation). how do I undo this unique()? thanks berber - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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 over Sun Cluster (Veritas)
Hi I'm wondering is MySQL is Cluster aware? Can it work in an Active/Passive or Active/Active Configuration of a cluster? thanks berber - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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: myODBC?
Hi, maybe I didn't phrase my question correctly. I'm using a SGI machine running Irix and going to be using a mySQL db on a Linux box behind a firewall. Since I will set up a tunnel with ssh2 to forward port 3306, it will appear to the Irix system that the db exists locally. Now here is what I'm confused about: Do I 1) install both iODBC and myODBC on the Irix system? or 2) install iODBC on the Irix one and myODBC on that Linux machine where the mySQL db physically located? Thanks! Wen -Original Message- From: Venu [mailto:[EMAIL PROTECTED]] Sent: Friday, August 24, 2001 9:33 AM To: Werner Stürenburg; Wen Tien Cc: [EMAIL PROTECTED] Subject: RE: myODBC? Hi !!! )-Original Message- )From: Werner Stürenburg [mailto:[EMAIL PROTECTED]] )Sent: Friday, August 24, 2001 5:59 AM )To: Wen Tien )Cc: [EMAIL PROTECTED] )Subject: Re: myODBC? ) ) )In my understanding, myODBC is a middleware for programs which )don't know how to deal directly with mySQL. So if you use perl or )php, you won't ever use ODBC, as this only slows things down, )obviously. ODBC is kind of a workaround in my understanding. ) )Please correct me, if I'm wrong. ) )Wen Tien schrieb am Freitag, 24. August 2001, 14:39:55: ) ) Hi, ) I am a newbie that has a question about what exactly is )myODBC (for Unix) ) doing. Is myODBC, 1) a wrapper over the mySQL database to )make it conform ) to the ODBC interface or 2) a plug-in driver that goes with a manager ) program to allow the access of mySQL db? I am using an Irix machine that ) tries to use a mySQL db on a Linux box (natively via port )forwarding) so I'm ) trying to decide where to install what... thanks. ) MyODBC is a ODBC Driver for MySQL. The current version is fully conformed to MS ODBC 2.x Specifications. So you can use the driver to access MySQL as per this specifications. Coming to the second one, yes, MyODBC works fine with all major driver managers such as MS ODBC DM, iODBC, unixODBC and Merant ODBC DM. Also it works in a stand alone mode too when you link the static library of the driver to your application. In this case no DSN issue will be coming. You can use DSN less connection, by specifying proper connection fields. The only drawback in this case (for any odbc driver ) is it can only talk to MySQL server, and it can't talk to any other, but its not the case when going through the manager. Regards Venu -- For technical support contracts, go to https://order.mysql.com/ __ ___ ___ __ / |/ /_ __/ __/ __ \/ /Mr. Venu [EMAIL PROTECTED] / /|_/ / // /\ \/ /_/ / /__ MySQL AB, Developer /_/ /_/\_, /___/\___\_\___/ Woodside, California USA ___/ www.mysql.com - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: MySQL client on AS/400?
Rich Duzenbury writes: I have need to replicate some data from an AS/400 to a MySQL server. Has anyone ported a client? Regards, Rich You can make a client on AIX, but OS/400 ... sorry no. Best way to accomplish what you need is to save table create scripts and to use SELECT ...INTO ... to copy data. -- Regards, __ ___ ___ __ / |/ /_ __/ __/ __ \/ /Mr. Sinisa Milivojevic [EMAIL PROTECTED] / /|_/ / // /\ \/ /_/ / /__ MySQL AB, FullTime Developer /_/ /_/\_, /___/\___\_\___/ Larnaca, Cyprus ___/ www.mysql.com - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: Moving database from NT Linux
To be honest, I'm not sure if you can just transport the db files. I'm sure it won't work it you're using different versions of MySQL on the machines. What I do when going from Win2K to FreeBSD is a mysqldump to extract the SQL statements to recreate the table. I'll use SELECT ... INTO OUTFILE to export a CSV for each table. On the Unix box I'll use the SQL statements from the mysqldump to recreate the tables and the CSV file to import the data (using LOAD DATA INFILE). Oh, to make the move even smoother... If you have gzip running on Win2K, then gzip the CSV file and then bring it over to the Linux box. When you unzip the file don't forget the -a switch. gzip will automatically convert all the \r\n to \n, which is how Unix/Linux like things. Just remember you need file permissions in MySQL to perform the INFILE and OUTFILE operations. Jeremy - Original Message - From: George Pitcher [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: Friday, August 24, 2001 8:42 AM Subject: Moving database from NT Linux Hi all, I'm getting closer and closer to having MySQL/PHP/Apache set up on my LinuxPPC box. Now, I haven't been sitting twiddling my thumbs while I was waiting. Instead I was building a database on MySQL on NT. I would like to move this to Linux asap. There are 6 tables with between 8 and 40 fields in them. The largest DB has 350,000 records and the overs a bit less (but still a lot). My question, really, is: Will I have to go through the create database process all over again or can I move this DB over from one platform to another? MTIA George P in Edinburgh _ Do You Yahoo!? Get your free @yahoo.com address at http://mail.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
MySQL, WebObjects 5: jdbc connection problems
Config: * Mac: Mac OS X 10.0.4; java 1.3.1; mysql 3.23.32 * Linux: Linux 2.2.19/debian testing; java 1.3.1; mysql 3.23.36 I *really* could use some help here. I need to get MySQL up and running; I've been at it for 2 days and can't get my WO app to see it, whether I try on Linux or OS X. Here's the scoop ... let's try OS X first: * .jar files belong in /Library/Java/Home/lib/ext/ * In EOModeler: URL: jdbc:mysql://localhost/newsie Driver: org.gjt.mm.mysql.Driver * MySQL is up and running, and I created a database newsie * EOModeler gives this error JDBC connection failed for driver :'org.gjt.mm.mysql.Driver'. Driver not found in Java Runtime! Please verify your C35LASSPATH environment variable. The current CLASSPATH for your application is : /Developer/Applications/EOModeler.app/Contents/Resources/Java/eomodeler.zi p:/Users/paul/Library/Java:/Library/Java:/System/Library/Java:/Network/Lib rary/Java:/System/Library/Frameworks/JavaVM.framework/Classes/classes.jar: /System/Library/Frameworks/JavaVM.framework/Classes/ui.jar:/Library/Java/H ome/lib/ext/mm.mysql-2.0.6.1.jar:/Developer/Applications/EOModeler.app/Con tents/Resources/Java/eomodeler.zip On Linux: * .jar files belong in /usr/local/jdk1.3.1/jre/lib/ext/ My questions 1. What file(s) do I download from http://mmmysql.sourceforge.net/? mm.mysql-2.0.4-bin.jar? mm.mysql-2.0.4-src.jar? mm.mysql-2.0.6.1.jar? something else? 2. What do I rename them to? 3. Where do I place them in the filesystem? 4. The docs talk about unpacking: http://mmmysql.sourceforge.net/doc/mm.doc/x68.htm What iss there to unpack? please help. step-by-step instructions would be much appreciated. Paul - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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: Moving database from NT Linux
George:
Suggest you use mysqldump, including the option to automagically create the
database and table schema.
On the WinNT machine:
mysqldump -u{username} -p -c --databases {databasename}{databasename}.sql
Copy the file(s) across the network to the LinuxPPC box
On the LinuxPPC box:
mysql -u{username} -p{databasename}.sql
Gerald Jensen
- Original Message -
From: George Pitcher [EMAIL PROTECTED]
To: [EMAIL PROTECTED]
Sent: Friday, August 24, 2001 8:42 AM
Subject: Moving database from NT Linux
Hi all,
I'm getting closer and closer to having MySQL/PHP/Apache set up on my
LinuxPPC box.
Now, I haven't been sitting twiddling my thumbs while I was waiting. Instead
I was building a database on MySQL on NT.
I would like to move this to Linux asap. There are 6 tables with between 8
and 40 fields in them. The largest DB has 350,000 records and the overs a
bit less (but still a lot).
My question, really, is: Will I have to go through the create database
process all over again or can I move this DB over from one platform to
another?
MTIA
George P in Edinburgh
_
Do You Yahoo!?
Get your free @yahoo.com address at http://mail.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
selection from multiple tables;
for a particular query i have to select data from five tables. can any one suggest me a best way to do that in terms of performace.. thanks in advance muruganandam - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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: Moving database from NT Linux
Do a SQLDUMP using a program like MySQLFront in NT then connect to the Linux MySQL using the same from NT. Run the SQL script you made and your off to the races. Just did this for my move from NT to Linux. There might be even a better way to do this but that's how I did mine and it worked. Cheers M;) -Original Message- FROM: George Pitcher TO: [EMAIL PROTECTED] DATE: Fri 8/24/01 7:56 SUBJECT: Moving database from NT Linux Hi all, I'm getting closer and closer to having MySQL/PHP/Apache set up on my LinuxPPC box. Now, I haven't been sitting twiddling my thumbs while I was waiting. Instead I was building a database on MySQL on NT. I would like to move this to Linux asap. There are 6 tables with between 8 and 40 fields in them. The largest DB has 350,000 records and the overs a bit less (but still a lot). My question, really, is: Will I have to go through the create database process all over again or can I move this DB over from one platform to another? MTIA George P in Edinburgh _ Do You Yahoo!? Get your free @yahoo.com address at http://mail.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: Re: mySQL Interface Programs
Hello, I have tried MySQL Front and it works very nicely I've used it for importing data and data modification. I just have a few questions I hope you can answer... Firstly I imported some MS Access 2000 tables. The import see to go fine, but when I went back to check some of the data that was imported I noticed in some fields that some data was missing. I then found that the field sizes were not the same as the MS Access fields size. I tried to re-import again and modified the field size to suit and it now seems to of imported OK without any missing data. Is this the correct way of should of imported the data ? Regarding MySQL Front, is there anything I should watch for, like the importing problem I experienced ? The data types I've used are int(250) unsigned - What is the biggest value I can have for this ? text - Should I use this for memo type fields ? varchar - Should I use this for text fields ? Thanks for your help and comments... Neil - Original Message - From: Neil Tompkins [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: Thursday, August 23, 2001 1:23 PM Subject: Fwd: Re: mySQL Interface Programs From: Jason Brunk [EMAIL PROTECTED] To: Neil Tompkins [EMAIL PROTECTED], [EMAIL PROTECTED] Subject: Re: mySQL Interface Programs Date: Thu, 23 Aug 2001 08:19:10 -0700 if you have ever used mssql server, then this will look similar. this is what i currently use, pretty easy to use. has some nice functions as well. - Original Message - From: Neil Tompkins [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: Thursday, August 23, 2001 1:10 AM Subject: mySQL Interface Programs Hello, Currently to connect to mySQL server I use MS Access and ODBC. I have noticed that the update when scrolling through records is not very good. Can anyone recommend and suggestion so FREE programs to view and edit data. Thanks Neil _ Get your FREE download of MSN Explorer at http://explorer.msn.com/intl.asp - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php _ Get your FREE download of MSN Explorer at http://explorer.msn.com/intl.asp - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
ERROR: Lost connection to MySQL server during query
Hi group, Im using the latest mySQL 3.23.41, ever since I installed the new version I've been getting Lost connection to MySQL server during query 50% of the time on my mySQL server. I have a load average of 247 queries per second accordig to mysqladmin status. Anyone experienced the same problem with mySQL? Regards, Boulat - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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: Moving database from NT Linux
Jeremy Falcon writes: To be honest, I'm not sure if you can just transport the db files. I'm sure it won't work it you're using different versions of MySQL on the machines. What I do when going from Win2K to FreeBSD is a mysqldump to extract the SQL statements to recreate the table. I'll use SELECT ... INTO OUTFILE to export a CSV for each table. On the Unix box I'll use the SQL statements from the mysqldump to recreate the tables and the CSV file to import the data (using LOAD DATA INFILE). Oh, to make the move even smoother... If you have gzip running on Win2K, then gzip the CSV file and then bring it over to the Linux box. When you unzip the file don't forget the -a switch. gzip will automatically convert all the \r\n to \n, which is how Unix/Linux like things. Just remember you need file permissions in MySQL to perform the INFILE and OUTFILE operations. Jeremy To clear out any confusion, since 3.23.0, MyISAM files can be safely copied from one OS/CPU combo to other as they have their own OS/CPU independent format. Just make sure they are not corrupted. -- Regards, __ ___ ___ __ / |/ /_ __/ __/ __ \/ /Mr. Sinisa Milivojevic [EMAIL PROTECTED] / /|_/ / // /\ \/ /_/ / /__ MySQL AB, FullTime Developer /_/ /_/\_, /___/\___\_\___/ Larnaca, Cyprus ___/ www.mysql.com - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
where option in mysqldump
Can anyone give an example of how to use the where option in mysqldump to get a dump of only those records whose values of field fieldx are larger than something? For example for all database tables of db mydatabase which possess a field named fieldx store in the dump only those records whose value of fieldx is larger than '123_xyx_' ? I tried --where= fieldx '123_xyx_ and got no complaints, but it returned all records. Thanks, S.Alexiou - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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: joins with concatenated keys
table a has ak1 and ak2 as primary key table b has bk1 and bk2 as primary key how do I join these tables? if i write where a.ak1 = b.bk1 and a.ak2 = b.bk2 data are returned multiple times. AnneMarie, When you say data are returned multiple times please clarify what you mean: a) Does the join return two identical rows/records? presumably the first time because ak1=bk1 and the second because ak2=bk2 also. or b) Do you mean that the join/result features single rows but with multiple columns? ie ak1, ak2, bk1, bk2 - where one pair of columns is (by definition) redundant. I can generate the second, but not the first. Please advise, =dn - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Error: 6 (Errcode: 13)
DROP TABLE Track Error: 6 - Error on delete of '.\sports\track.ISD' (Errcode: 13) Anyone know what that means? As you can see, it came from tryign to do a DROP on a table. Thanks, Tyler Longren - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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: selection from multiple tables;
- Original Message - From: muruganandam [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: Wednesday, September 05, 2001 4:04 PM Subject: selection from multiple tables; for a particular query i have to select data from five tables. can any one suggest me a best way to do that in terms of performace.. thanks in advance muruganandam Make sure that all the tables have an index and do the selection using the indexes. chuck - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Error
I still get this error. Can someone help me to solve this?
MySQL Query Failed. Error 1030: Got error -1 from table handler
$query = SELECT * FROM question WHERE answer'1' AND id250 ORDER BY id;
$result = mysql_query($query) or die('MySQL Query Failed. Error
'.mysql_errno().':
'.mysql_error());
$number = mysql_num_rows($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
advise about add [MySQl-MailList] label to all mail subject from this list
hi, I think this mail list is very helpful to me. But several hundred letters one day may bomb my mailbox up, and it is a great problem to manage all the letter. I have an advice to the friends who manage this list. Please add a label to every letter from this mail list in order for all of us to use mail filter fluently. example: from: [EMAIL PROTECTED] to :[EMAIL PROTECTED] Subject: [MySQl-MailList] problem about * ** Your sincerely aDragon [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: mysql-server.sh gone in freebsd
Hi Armando, I think you probably need to notify the mainter of the port for freebsd (from ports) Port: mysql-server-3.23.40 Path: /usr/ports/databases/mysql323-server Info: Multithreaded SQL database (server) Maint: [EMAIL PROTECTED] It's probably something in the port install script. Ken - Original Message - From: Armando Cerna [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: Thursday, August 23, 2001 9:30 PM Subject: mysql-server.sh gone in freebsd HI installed the mysql-server port in freebsd and the /usr/local/etc/rc.d/mysql-server.sh file just disapeared its done this before and I fixed it by reinstalling I think but I would like to avoid this. Does anyone know anything about this? Armando - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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: joins with concatenated keys
table a has ak1 and ak2 as primary key table b has bk1 and bk2 as primary key how do I join these tables? if i write where a.ak1 = b.bk1 and a.ak2 = b.bk2 data are returned multiple times. AnneMarie, When you say data are returned multiple times please clarify what you mean: a) Does the join return two identical rows/records? presumably the first time because ak1=bk1 and the second because ak2=bk2 also. or b) Do you mean that the join/result features single rows but with multiple columns? ie ak1, ak2, bk1, bk2 - where one pair of columns is (by definition) redundant. I can generate the second, but not the first. Please advise, =dn - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: Replication Config Bug (Re: master.info and my.cnf updates)
On Friday 24 August 2001 00:09, Jeremy Zawodny wrote: On Thu, Aug 23, 2001 at 01:15:25PM -0400, Robinson, Mike wrote: I just set up a master/slave replication scheme and all is well, but through the procedure did get bit on the tail. After the setup, and after the master and slave mysql servers had been started, I got some error messages that pointed to a type in the slave's my.cnf file. I shut the slave down, fixed the typo, and restarted. Got the same error. I had a look at the master.info, and noticed it contained old information from the previous my.cnf. There were no binary log entries in it, so I shut the slave down, deleted the master.info, and restarted the slave. This fixed the problem and they're replicating fine. (A terrific feature, my thanks to the mysql team for that one.) Question is, is this behaviour by design? Seems to me if you edit my.cnf and restart the mysql slave the master.info entries corresponding to the my.cnf file should be updated. Thanks for any insight. That's a common problem. Very common. You have to remove the master.info file, or edit it by hand. :-( I've called it a bug several times in the past, but it occurs to me that I may have never told the person who wrote the replication code. So... Sasha: Can this be fixed? In my mind it's a bug. One that has bitten too many people already. If not, we at least to get it documented here: http://www.mysql.com/doc/R/e/Replication_Features.html Thoughts? It is a feature that needs to be better documented. The main reason master.info is more authoritative that my.cnf is to support dynamic master changes. That is if you did CHANGE MASTER TO a different host, you want to continue replicating from that new master if you restart the slave in the middle. The options in my.cnf should really be called default-master-host, default-master-port, etc, but it is too late to change now - it would cause more problems that it would solve. In fact, we should probably change the replication HOWTO to suggest CHANGE MASTER TO command for replication setup instead of using my.cnf options. The recommended procedure to change masters is also to use CHANGE MASTER TO command. Thanks, Jeremy -- Jeremy D. Zawodny, [EMAIL PROTECTED] Technical Yahoo - Yahoo Finance Desk: (408) 349-7878 Fax: (408) 349-5454 Cell: (408) 685-5936 MySQL 3.23.41-max: up 6 days, processed 88,944,778 queries (148/sec. avg) Jeremy, your server has been slowing down - it started out at 154 queries per second, and now is down to 148 :-) -- MySQL Development Team For technical support contracts, visit https://order.mysql.com/ __ ___ ___ __ / |/ /_ __/ __/ __ \/ / Sasha Pachev [EMAIL PROTECTED] / /|_/ / // /\ \/ /_/ / /__ MySQL AB, http://www.mysql.com/ /_/ /_/\_, /___/\___\_\___/ Provo, Utah, USA ___/ - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
WebStream Internet Solutions Signs Contract With Broward Alliance
This is an Official WebStream Press Release Release date: August 23, 2001 For more information contact: Gary Lee at 888-932-2333 WebStream Internet Solutions Signs Contract With Broward Alliance FOR IMMEDIATE RELEASE Fort Lauderdale, FL - August 23, 2001 - WebStream Internet Solutions has signed a three-year contract with The Broward Alliance, one of the nation's premier economic development organizations, to expand and host their web site. The new web site will serve as a source for information on business expansion and relocation, film/TV production, workforce education, minority business development, and site location assistance in Broward County, Florida. WebStream is under contract to develop the new Broward Alliance web site and will now continue to also host the site, which is popular with companies seeking to expand into the Greater Fort Lauderdale, Florida area. For more information on The Broward Alliance, point your browser to web site address http://www.browardalliance.org/. We look forward to working with WebStream on the Alliance's new site, said Yvonne Lopez, Broward Alliance Vice President of Communications. Their quality of work and creative talents will be showcased around the world as we brand Broward County as an international business center. Since 1997, WebStream Internet Solutions has developed and hosted web sites in over 110 countries. Among the successful Internet sites WebStream has launched and is hosting are CBS Records, Don King Productions, SurplusBid and Evander Holyfield. For a more in-depth look at WebStream clients, visit the web address http://www.webstream.net/. WebStream has become a leader in the Internet industry due to its commitment to customer support and dedication to developing quality web sites. With a unique seasoned combination of designers and programmers, WebStream creates web sites that fit the needs of both large companies and small organizations. With an enthusiastic attitude about transforming the way e-business gets done, we strive to improve the online presence of each of our clients, said WebStream CEO Kerry Brewer. We use our years of experience, creativity and technological expertise to design and build powerful web sites. WebStream has developed an outstanding reputation for providing solutions for interactive learning, online brand building, business design, revenue management, online payment processing and customer relationship management. WebStream has become one of the nation's leading providers of comprehensive business Internet services due to its loyal client roster. P.S. Have you tried our SiteBuilder yet? If not, then go to http://sitebuilder.webstream.net/ to find out how easy it is to build your own web site in minutes with fun and ease! ==30== Would you like to un-subscribe from this mailing list? If so, please click here: http://demo.webstream.net/optout/optout.cfm?email=mysql%40lists%2Emysql%2Ecommailgroup=GlobalBusiness If the above link is not available, cut and paste this into your browser window. - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: load data infile....
Rudy, there is an explanation to this behaviour: on escaped data you could un-escape almost everything, one can escape almost any character if wanted.. .. so \\ gets \ and \* gets *, \% gets % and \N gets... N. mysql select \A\B\C\J\N; +-+ |ABCJN| +-+ |ABCJN| +-+ 1 row in set (0.03 sec) In your situation the field type is char(1), and this 'bug' typically affects this field. why ? you'll have to ask one of the developers. Fix: Guess the fix would be to remove the word 'optionally' from 'optionally enclosed by '' '. regards, rene On Fri, 24 Aug 2001 15:36:41 +0200 Rudy Metzger [EMAIL PROTECTED] wrote: Dear all, I have the following problem with load data... Please excuse layout, but the linewidth is just too short // --- // Here is my table definition // --- mysql desc customer; +---+--+--+-+-+---+- + | Field | Type | Null | Key | Default | Extra | Privileges | +---+--+--+-+-+---+- + | SK| int(10) unsigned | | PRI | 0 | | select,insert,update,references | | ShopCode | char(3) | | | | | select,insert,update,references | | PasNr | smallint(5) unsigned | | | 0 | | select,insert,update,references | | OriginalShopCode | char(3) | YES | | NULL| | select,insert,update,references | | OriginalPasNr | smallint(6) | YES | | NULL| | select,insert,update,references | | Titel | varchar(15) | YES | | NULL| | select,insert,update,references | | FirstName | varchar(10) | YES | | NULL| | select,insert,update,references | | Voorvoegsel | varchar(10) | YES | | NULL| | select,insert,update,references | | SurName | varchar(20) | YES | | NULL| | select,insert,update,references | | Street| varchar(25) | YES | | NULL| | select,insert,update,references | | StreetNumber | varchar(8) | YES | | NULL| | select,insert,update,references | | ZIP | varchar(10) | YES | | NULL| | select,insert,update,references | | City | varchar(35) | YES | | NULL| | select,insert,update,references | | Telephone | varchar(15) | YES | | NULL| | select,insert,update,references | | Gender| char(1) | YES | | NULL| | select,insert,update,references | | BirthDate | date | YES | | NULL| | select,insert,update,references | | AirMiles | char(1) | YES | | NULL| | select,insert,update,references | | AirMilesTeller| smallint(6) | YES | | NULL| | select,insert,update,references | | Lid | char(1) | YES | | NULL| | select,insert,update,references | | JaarWeekNrMutatie | smallint(6) | YES | | NULL| | select,insert,update,references | | WeekNrMutatie | tinyint(4) | YES | | NULL| | select,insert,update,references | | DatumMutatie | datetime | YES | | NULL| | select,insert,update,references | | EmailAddress | varchar(40) | YES | | NULL| | select,insert,update,references | | Mailing | char(1) | YES | | NULL| | select,insert,update,references | | PostCodeCheck | char(1) | YES | | NULL| | select,insert,update,references | +---+--+--+-+-+---+- + 25 rows in set (0.01 sec) // - // this is the file i am trying to load (all one line in reality...) // - 1 01100 \N \N MEVR. B.G. \NVEEN V.D. ** * 10 ** **023-5440320 V 1956-08-30 00:00:00 J 46 A 200031 2000-08-05 00:00:00 \N J \N // // the syntax for the load data. // load data infile '/home/rmetzger/mysql/import/klant.txt' into
'mysqldump --allow-keywords' produces non-keyword friendly scripts.
Description: 'mysqldump --allow-keywords' seems not to work using mysql-3.23.38-1.alpha.rpm or mysql-3.23.41-1.alpha.rpm, i.e. keyword-permissive column names are not produced. The same command works properly on MySQL 3.23.22 on Linux on Intel hardware. How-To-Repeat: The table can be created using: CREATE TABLE `GeneAnnotation` ( `AnnotationID` int(11) unsigned NOT NULL default '0', `GeneID` varchar(255) default NULL, `Key` varchar(255) default NULL, `Value` varchar(255) default NULL, PRIMARY KEY (`AnnotationID`) ) TYPE=MyISAM ; The following command: mysqldump --allow-keywords -p -u root -d minimal_pa14 GeneAnnotation Produces the problematic output: # MySQL dump 8.14 # # Host: localhostDatabase: minimal_pa14 # # Server version3.23.41 # # Table structure for table 'GeneAnnotation' # CREATE TABLE GeneAnnotation ( AnnotationID int(11) unsigned NOT NULL default '0', GeneID varchar(255) default NULL, Key varchar(255) default NULL, Value varchar(255) default NULL, PRIMARY KEY (AnnotationID) ) TYPE=MyISAM; The line beginning with 'Key' causes problems. A short shell script to reproduce the problem...## #!/bin/sh # Creating the problematic db table with a column named 'Key' echo ' CREATE TABLE `GeneAnnotation` ( `AnnotationID` int(11) unsigned NOT NULL default '0', `GeneID` varchar(255) default NULL, `Key` varchar(255) default NULL, `Value` varchar(255) default NULL, PRIMARY KEY (`AnnotationID`) ) TYPE=MyISAM ;' | mysql test mysqldump --allow-keywords -d test GeneAnnotation # Cleaning up... echo ' drop table test.GeneAnnotation;' | mysql test #End Shell Script Fix: Workarounds: Add backquotes (`) manually to the mysqldump output where the column name is key. Alternatively, the programmer could avoid using keywords in the first place! Submitter-Id: submitter ID Originator:Jonathan M. Urbach Organization: Massachusetts General Hospital dept of Molecular Biology MySQL support: none Synopsis:'mysqldump --allow-keywords' produces non-keyword friendly scripts. Severity: non-critical Priority: low Category: mysql Class: sw-bug Release: mysql-3.23.41 (Source distribution) Environment: Alpha, Linux RedHat 7.0 System: Linux lassie.mgh.harvard.edu 2.2.17-4 #1 Mon Oct 23 15:19:13 EDT 2000 alpha unknown Architecture: alpha 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/alpha-redhat-linux/2.96/specs gcc version 2.96 2731 (Red Hat Linux 7.0) Compilation info: CC='gcc' CFLAGS='-O2 -mieee -D_GNU_SOURCE -D_FILE_OFFSET_BITS=64 -D_LARGEFILE_SOURCE' CXX='c++' CXXFLAGS='-O2 -mieee -D_GNU_SOURCE -D_FILE_OFFSET_BITS=64 -D_LARGEFILE_SOURCE' LDFLAGS='' LIBC: lrwxrwxrwx1 root root 13 Jun 14 15:14 /lib/libc.so.6.1 - libc-2.2.3.so -rwxr-xr-x1 root root 9927184 May 27 15:02 /lib/libc-2.2.3.so -rw-r--r--1 root root 23047758 May 27 15:01 /usr/lib/libc.a -rw-r--r--1 root root 180 May 27 15:01 /usr/lib/libc.so Configure command: ./configure alpha-redhat-linux --prefix=/usr --exec-prefix=/usr --bindir=/usr/bin --sbindir=/usr/sbin --sysconfdir=/etc --datadir=/usr/share --includedir=/usr/include --libdir=/usr/lib --libexecdir=/usr/libexec --localstatedir=/var --sharedstatedir=/usr/com --mandir=/usr/share/man --infodir=/usr/share/info --without-debug --without-readline --enable-shared --with-extra-charsets=complex --with-bench --localstatedir=/var/lib/mysql --with-unix-socket-path=/var/lib/mysql/mysql.sock --with-mysqld-user=mysql --with-extra-charsets=all --disable-assember --with-thread-safe-client --enable-assembler - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail mysql-unsubscribe-##L=##[EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: GLIBC 2.2.4
Trond Eivind Glomsrød writes: On Fri, 24 Aug 2001, Sinisa Milivojevic wrote: You know better then me that 2.2.4 should NOT be built with gcc 3 ! Which was why I asked :) - 2.2.4 wants 2.96RH or 2.95.3 (2.95.2 should work on IA32, though) -- Trond Eivind Glomsrød Red Hat, Inc. And I guessed so. I just wanted to hear it from you ;o) -- Regards, __ ___ ___ __ / |/ /_ __/ __/ __ \/ /Mr. Sinisa Milivojevic [EMAIL PROTECTED] / /|_/ / // /\ \/ /_/ / /__ MySQL AB, FullTime Developer /_/ /_/\_, /___/\___\_\___/ Larnaca, Cyprus ___/ www.mysql.com - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Version 4.0
Hello- I poked around on the site but didn't find any definite answer. Roughly when is version 4.0 of MySQL expected out? I saw the information on the todo in regards to version 4.0 and the subsequent 4.1 but didn't see any dates. Thanks for any help. Steve - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
RE: MySQL client for AS/400
Hi Rich, i haven't heard about an AS/400-Client so far. As long you might don't want to start writing an asynchronus dataque server on the AS/400 and a client on the mySQL-Server to handle the data mirroring, i would suggest to try IBM's JDBC-API. Together with Sun's JDBC 2.0 Optional Package API (available as a download from Sun) you can access DB2/400 and mySQL from both platforms. I hope this info will bring you a step ahead. Regards, Bernhard -Original Message- From: Rich Duzenbury [mailto:[EMAIL PROTECTED]] Sent: Thursday, August 23, 2001 6:16 PM To: [EMAIL PROTECTED] Subject: MySQL client for AS/400 Has anyone ported a MySQL client to IBM AS/400? I have a customer (on AS/400) that would like to mirror some data to a MySQL server. Thank you for any help you can offer. Regards, Rich - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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 client for AS/400
Hi Rich, i haven't heard about an AS/400-Client so far. As long you might don't want to start writing an asynchronus dataque server on the AS/400 and a client on the mySQL-Server to handle the data mirroring, i would suggest to try IBM's JDBC-API. Together with Sun's JDBC 2.0 Optional Package API (available as a download from Sun) you can access DB2/400 and mySQL from both platforms. I hope this info will bring you a step ahead. Regards, Bernhard -Original Message- From: Rich Duzenbury [mailto:[EMAIL PROTECTED]] Sent: Thursday, August 23, 2001 6:16 PM To: [EMAIL PROTECTED] Subject: MySQL client for AS/400 Has anyone ported a MySQL client to IBM AS/400? I have a customer (on AS/400) that would like to mirror some data to a MySQL server. Thank you for any help you can offer. Regards, Rich - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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
Max table size in MySQL on Redhat 7.0 be default
What is the maximum table size allowed by MySQL and Redhat 7.0 be default? Benjamin Arai - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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.server is not found
Hi, I was trying to install mysql on Linux Redhat 7.1, after following all the steps on the website, I tried to start mysql server using the mysql.server start command, and I got this error message saying that mysql.server is not found evern though it's under support-files folder and I cd-ed into the folder and tried to start it from there. I even tried to change the permission of the file but no help... Please let me know if this is a common error and how to fix it. Thanks, A.T. - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: Replication advice needed...
The other solution is rsync. I dont know much about this guy yet, but I have some concerns with using it to copy over large remote files. For example, if I have a 1.2 gig table that has been heavily modified over a weeks work, how reliable is the remote file after rsync? I guess Im just concerned about data integrity. on the rsync list is just a discussion, see subject Re: 2G Maximum file size? Source and destination systems are running Solaris 2.6 you can setup a cron job for rsync to transfer changes every hour; rsync has very effective mechanisms and algorithms to transport only the binary pieces of data what was changed - means you may have very little traffic compared with other methods it's really worthy a deeper look... i.t - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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: myODBC?
Hi !! )-Original Message- )From: Wen Tien [mailto:[EMAIL PROTECTED]] )Sent: Friday, August 24, 2001 1:58 PM )To: [EMAIL PROTECTED]; Werner Stürenburg )Cc: [EMAIL PROTECTED] )Subject: RE: myODBC? ) ) )Hi, maybe I didn't phrase my question correctly. I'm using a SGI machine )running Irix and going to be using a mySQL db on a Linux box behind a )firewall. Since I will set up a tunnel with ssh2 to forward port 3306, it )will appear to the Irix system that the db exists locally. Now )here is what )I'm confused about: Do I 1) install both iODBC and myODBC on the Irix )system? or 2) install iODBC on the Irix one and myODBC on that )Linux machine )where the mySQL db physically located? Thanks! ) You need to install both iODBC or unixODBC and MyODBC in the client side from which your ODBC application tries to access (Irix) the db from Linux m/c. Regards Venu -- For technical support contracts, go to https://order.mysql.com/ __ ___ ___ __ / |/ /_ __/ __/ __ \/ /Mr. Venu [EMAIL PROTECTED] / /|_/ / // /\ \/ /_/ / /__ MySQL AB, Developer /_/ /_/\_, /___/\___\_\___/ Woodside, California USA ___/ www.mysql.com - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
RE: MySQL + ODBC + palm + security?
Hi !!! Can anyone has the answer for him ? How we can have a secure data transfer over the web using MySQL and its APIs ? He is desperately needed some idea in order to take further steps with MySQL ? Regards Venu )-Original Message- )From: A. Chris Nichols [mailto:[EMAIL PROTECTED]] )Sent: Friday, August 24, 2001 7:08 AM )To: [EMAIL PROTECTED] )Subject: RE: MySQL + ODBC + palm + security? ) ) )Venu, ) )I was wondering if you had had any luck finding anything out about )this. I've got to try to find a way to synch some clients that are out on )the net with out MySQL database that is available on the web. If they )can't do it securely though it doesn't make sense since the data is )sensitive. Do you know of any other possibilities other than ODBC for )something like this? ) )-Chris ) )At 01:13 PM 8/14/2001, you wrote: )Hi ! ) ))-Original Message- ))From: A. Chris Nichols [mailto:[EMAIL PROTECTED]] ))Sent: Tuesday, August 14, 2001 7:45 AM ))To: [EMAIL PROTECTED] ))Subject: RE: MySQL + ODBC + palm + security? )) )) ))Any more thoughts on this? Are there any secure methods out there for ))synching over the internet? )) ))-Chris )) ))At 03:56 PM 8/13/2001, you wrote: ))Hi ! )) )))-Original Message- )))From: A. Chris Nichols [mailto:[EMAIL PROTECTED]] )))Sent: Monday, August 13, 2001 11:53 AM )))To: [EMAIL PROTECTED] )))Subject: MySQL + ODBC + palm + security? ))) ))) )))Hey everyone, ))) )))Has anyone had any experience establishing a secure connection )between a )))palm device and MySQL database that's on the net? I've setup )secure web )))pages on our webserver that are visible on the web and viewable by )))wireless )))palms (securely). Scripts on that interface provide a way to get )))data into )))the DB securely. ))) )))What I'm hoping to find is an alternative for when wireless )access is not )))available. I've got a working form on Pendragon forms that can ))synch with )))the MySQL database using the MyODBC driver and a local DSN for )the MySQL )))database. As I understand ODBC has no inherent security but there are )))secure drivers that talk with some RDBMSs. Is anyone aware of a secure )))version ODBC driver for MySQL? Or is there any other way that )people are )))aware of to accomplish this weird goal? ))) )) ) Regards Venu -- For technical support contracts, go to https://order.mysql.com/ __ ___ ___ __ / |/ /_ __/ __/ __ \/ /Mr. Venu [EMAIL PROTECTED] / /|_/ / // /\ \/ /_/ / /__ MySQL AB, Developer /_/ /_/\_, /___/\___\_\___/ Woodside, California USA ___/ www.mysql.com ) - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
RE: myODBC?
Hi !!! )-Original Message- )From: Werner Stürenburg [mailto:[EMAIL PROTECTED]] )Sent: Friday, August 24, 2001 5:59 AM )To: Wen Tien )Cc: [EMAIL PROTECTED] )Subject: Re: myODBC? ) ) )In my understanding, myODBC is a middleware for programs which )don't know how to deal directly with mySQL. So if you use perl or )php, you won't ever use ODBC, as this only slows things down, )obviously. ODBC is kind of a workaround in my understanding. ) )Please correct me, if I'm wrong. ) )Wen Tien schrieb am Freitag, 24. August 2001, 14:39:55: ) ) Hi, ) I am a newbie that has a question about what exactly is )myODBC (for Unix) ) doing. Is myODBC, 1) a wrapper over the mySQL database to )make it conform ) to the ODBC interface or 2) a plug-in driver that goes with a manager ) program to allow the access of mySQL db? I am using an Irix machine that ) tries to use a mySQL db on a Linux box (natively via port )forwarding) so I'm ) trying to decide where to install what... thanks. ) MyODBC is a ODBC Driver for MySQL. The current version is fully conformed to MS ODBC 2.x Specifications. So you can use the driver to access MySQL as per this specifications. Coming to the second one, yes, MyODBC works fine with all major driver managers such as MS ODBC DM, iODBC, unixODBC and Merant ODBC DM. Also it works in a stand alone mode too when you link the static library of the driver to your application. In this case no DSN issue will be coming. You can use DSN less connection, by specifying proper connection fields. The only drawback in this case (for any odbc driver ) is it can only talk to MySQL server, and it can't talk to any other, but its not the case when going through the manager. Regards Venu -- For technical support contracts, go to https://order.mysql.com/ __ ___ ___ __ / |/ /_ __/ __/ __ \/ /Mr. Venu [EMAIL PROTECTED] / /|_/ / // /\ \/ /_/ / /__ MySQL AB, Developer /_/ /_/\_, /___/\___\_\___/ Woodside, California USA ___/ www.mysql.com - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
RE: MySQL + ODBC + palm + security?
Hi I'd also like to know the answer to this. I also had a thought that it might be nice to have a site to post answers that come through this email list. I know there are archives but they can be difficult to use to find the answer to peoples questions. What does everyone think about having a site QA for posting? If it popular, I'd be happy to set something up. Peter At 09:10 AM 8/24/2001 -0700, Venu wrote: Hi !!! Can anyone has the answer for him ? How we can have a secure data transfer over the web using MySQL and its APIs ? He is desperately needed some idea in order to take further steps with MySQL ? Regards Venu )-Original Message- )From: A. Chris Nichols [mailto:[EMAIL PROTECTED]] )Sent: Friday, August 24, 2001 7:08 AM )To: [EMAIL PROTECTED] )Subject: RE: MySQL + ODBC + palm + security? ) ) )Venu, ) )I was wondering if you had had any luck finding anything out about )this. I've got to try to find a way to synch some clients that are out on )the net with out MySQL database that is available on the web. If they )can't do it securely though it doesn't make sense since the data is )sensitive. Do you know of any other possibilities other than ODBC for )something like this? ) )-Chris ) )At 01:13 PM 8/14/2001, you wrote: )Hi ! ) ))-Original Message- ))From: A. Chris Nichols [mailto:[EMAIL PROTECTED]] ))Sent: Tuesday, August 14, 2001 7:45 AM ))To: [EMAIL PROTECTED] ))Subject: RE: MySQL + ODBC + palm + security? )) )) ))Any more thoughts on this? Are there any secure methods out there for ))synching over the internet? )) ))-Chris )) ))At 03:56 PM 8/13/2001, you wrote: ))Hi ! )) )))-Original Message- )))From: A. Chris Nichols [mailto:[EMAIL PROTECTED]] )))Sent: Monday, August 13, 2001 11:53 AM )))To: [EMAIL PROTECTED] )))Subject: MySQL + ODBC + palm + security? ))) ))) )))Hey everyone, ))) )))Has anyone had any experience establishing a secure connection )between a )))palm device and MySQL database that's on the net? I've setup )secure web )))pages on our webserver that are visible on the web and viewable by )))wireless )))palms (securely). Scripts on that interface provide a way to get )))data into )))the DB securely. ))) )))What I'm hoping to find is an alternative for when wireless )access is not )))available. I've got a working form on Pendragon forms that can ))synch with )))the MySQL database using the MyODBC driver and a local DSN for )the MySQL )))database. As I understand ODBC has no inherent security but there are )))secure drivers that talk with some RDBMSs. Is anyone aware of a secure )))version ODBC driver for MySQL? Or is there any other way that )people are )))aware of to accomplish this weird goal? ))) )) ) Regards Venu -- For technical support contracts, go to https://order.mysql.com/ __ ___ ___ __ / |/ /_ __/ __/ __ \/ /Mr. Venu [EMAIL PROTECTED] / /|_/ / // /\ \/ /_/ / /__ MySQL AB, Developer /_/ /_/\_, /___/\___\_\___/ Woodside, California USA ___/ www.mysql.com ) - Please check http://www.mysql.com/Manual_chapter/manual_toc.html; before posting. To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, send a message to the address shown in the List-Unsubscribe header of this message. If you cannot see it, e-mail [EMAIL PROTECTED] instead. - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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 Still a wise choice for developers?
Dear Everyone, I have been looking at this mysql.com/org dispute for a while now, and i must say i am getting more and more wurried. I have been a faithfull user of MySql for some years now. Not because it is the 'best full features database out there', but because it serves my specific needs perfectly (easy intergration with PHP and support for tons of images stored in a database). First MySql was a commercial product, freely available for most situations, and all was well with me. Though i strongly prefer GPL, it was still a source tar.gz, and i can imagine a company needs to try to make money any way they can.. Later MySql was GPL'd and i rejoiced.. No more wurries about finding out about licencing issues, and hoping for good 3rd party contributions to MySql.. All was well and my choice for MySql was only re-affirmed. Now, a few years after first using MySql, a major dispute seems to plague the 'image' of MySql, and posibly also the future of the product. Big disputes like this won't make any customer of mine choose my MySql-based product any faster, quite the oposite, and i have already recieved numorous questions from my clients about my MySql choice.. I am not siding with any party, nor giving (or want to have) any opinion on this dispute, however it is hurting my buisness, and my faith in continued fast development in MySql. MySql is not 'there' yet, it has a while to go before it is 'there' (thats why external parties sponsoring or helping with mysql 4 sounded great). And any obstacles like this will make people doubt if it will 'get there'. For my clients, and my self, only the bottom line matters... will this still be a product of choice in a few years, and is it worth the investment of resources to use it. The last thing that wurries me is the lack of updates on the issue, when i, as a wurried client customer go to the mysql.com website, the only thing i find is a 'open inventation for 2001/07/18'. Being deep-august i presume that has come and gone, and no results or communications can be found.. (and the changelog mentioning: All reference to Gemini DB removed). MySql.org offers even less information. So, my real question, is MySql still the top choice for developers? Can you affirm that my choice for MySql is the right one? -- Chris Chabot - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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 Migration
We have about 300,000 records currently in a MySQL database. A new system has been built on Oracle, and now we must migrate the data from MySQL to Oracle (I know, it's not something I wanted to do.) What is the best way to do this? Import into another database (something like Access) then export to Oracle? Scripting on the Oracle side that would do this? Mind you there is about 300,000 records, so this isn't a menial task, neseccarily. Also, although the two databases are of similar structure, they aren't identical, so some translation would be needed. Thank you, Hans [EMAIL PROTECTED] __ Do You Yahoo!? Make international calls for as low as $.04/minute with Yahoo! Messenger http://phonecard.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
Re: MySQL Still a wise choice for developers?
Well, I've been a die-hard mysql fan for two years now and have been using it with php for a web-based app. It has never crashed on me and has performed perfectly. As our app has grown, we have found a need for subselects and complex queries and the work-arounds were ok until our databases started getting more data in them. Then the work-arounds SLOWED down real bad and looping out of the code was no longer an option. Yesterday I crossed over to Postgres. It broke my heart to do it, but I have to say that it outperforms mysql hands-down on complex queries and the subselects open new doors for us that we need to stay competitive. Porting the app over to it is tedious but not difficult. I'm going to miss the simplicity and ease of MySQL, but if you're doing an app that's going to grow and need sophisticated stuff, you're going to need Postgres. I would also strongly suggest not storing your images in the database but rather a link to the image. I really didn't understand everything Postgres was capable of until I started messing with it yesterday. Try it out... Robert Dayton Unconventional Solutions, Inc. Creators of DForce Internet Process Serving Software 88-30 Sutphin blvd Jamaica, NY 11435 (718) 558-6081 (352) 343-0462 - Original Message - From: Chris Chabot [EMAIL PROTECTED] To: [EMAIL PROTECTED]; [EMAIL PROTECTED]; [EMAIL PROTECTED] Sent: Saturday, August 25, 2001 12:37 PM Subject: MySQL Still a wise choice for developers? Dear Everyone, I have been looking at this mysql.com/org dispute for a while now, and i must say i am getting more and more wurried. I have been a faithfull user of MySql for some years now. Not because it is the 'best full features database out there', but because it serves my specific needs perfectly (easy intergration with PHP and support for tons of images stored in a database). First MySql was a commercial product, freely available for most situations, and all was well with me. Though i strongly prefer GPL, it was still a source tar.gz, and i can imagine a company needs to try to make money any way they can.. Later MySql was GPL'd and i rejoiced.. No more wurries about finding out about licencing issues, and hoping for good 3rd party contributions to MySql.. All was well and my choice for MySql was only re-affirmed. Now, a few years after first using MySql, a major dispute seems to plague the 'image' of MySql, and posibly also the future of the product. Big disputes like this won't make any customer of mine choose my MySql-based product any faster, quite the oposite, and i have already recieved numorous questions from my clients about my MySql choice.. I am not siding with any party, nor giving (or want to have) any opinion on this dispute, however it is hurting my buisness, and my faith in continued fast development in MySql. MySql is not 'there' yet, it has a while to go before it is 'there' (thats why external parties sponsoring or helping with mysql 4 sounded great). And any obstacles like this will make people doubt if it will 'get there'. For my clients, and my self, only the bottom line matters... will this still be a product of choice in a few years, and is it worth the investment of resources to use it. The last thing that wurries me is the lack of updates on the issue, when i, as a wurried client customer go to the mysql.com website, the only thing i find is a 'open inventation for 2001/07/18'. Being deep-august i presume that has come and gone, and no results or communications can be found.. (and the changelog mentioning: All reference to Gemini DB removed). MySql.org offers even less information. So, my real question, is MySql still the top choice for developers? Can you affirm that my choice for MySql is the right one? -- Chris Chabot - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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: Error: 6 (Errcode: 13)
DROP TABLE Track Error: 6 - Error on delete of '.\sports\track.ISD' (Errcode: 13) Anyone know what that means? As you can see, it came from tryign to do a DROP on a table. Permission denied. Maybe the dir permissions aren't correctly set up? / Carsten -- Carsten H. Pedersen keeper and maintainer of the bitbybit.dk MySQL FAQ http://www.bitbybit.dk/mysqlfaq - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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 Still a wise choice for developers?
The last thing that wurries me is the lack of updates on the issue, when i, as a wurried client customer go to the mysql.com website, the only thing i find is a 'open inventation for 2001/07/18'. Being deep-august i presume that has come and gone, and no results or communications can be found.. (and the changelog mentioning: All reference to Gemini DB removed). MySql.org offers even less information. The dispute between MySQL AB and NuSphere doesn't concern me as it does you. MySQL's only loss was that at one time it supported Gemini tables, and now it does not. Apparently, this couldn't mean TOO much to you in that I'm guessing you don't rely on transactions. And even if you did, there are Berkley DB and InnoDB table support for transactions. As far as I've read, NuSphere is in violation of the GPL, but I genuinely believe that things can be worked out -- you just have to pay the piper. This whole Internet free mentality has now spread from users to companies. I think it's time that users and companies start realizing that nothing is entirely free. So, my real question, is MySql still the top choice for developers? Can you affirm that my choice for MySql is the right one? MySQL is my top choice. Heheh.. affirm? Nope. I can suggest that you try the other database backends out there, open-source and non-open-source. We have and MySQL is still our choice for many reasons. It's fast, very active community (1,000+ messages on this mailing list alone in just a few weeks), very fast and fantastic support (my company has an e-mail support contract with MySQL AB), and the pricing can't be beat (free for most of you, but if you bundle the software, there's plenty of room for margin). [.kate] ___ Visit http://www.visto.com. Find out how companies are linking mobile users to the enterprise with Visto. - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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 Migration
Hello Hans, a few weeks ago i had a similar task to accomplish, porting a mySQL DB over to IBM's DB2 for S/390, so i can relate to this kind of *most exciting* job. Anyway, from my experience I wouldn't recommend anything like a bulk copy or mass import/export. Because when you are switching to a different DB vendor you will always have difference in field length, types etc. So the best would be to pick some records from the mySQL database that contains all information you will have to bring into the oracle system. An oracle script should do the data validation, mapping to the new fields and inserting into the new db. After all the new rows will be transferred you can walk through those records and check if all trans- actions went well. If all information arrived in the right format and length than you can import the bulk. Regards, Bernhard -Original Message- From: Hans Zaunere [mailto:[EMAIL PROTECTED]] Sent: Saturday, August 25, 2001 7:40 PM To: [EMAIL PROTECTED] Subject: MySQL Migration We have about 300,000 records currently in a MySQL database. A new system has been built on Oracle, and now we must migrate the data from MySQL to Oracle (I know, it's not something I wanted to do.) What is the best way to do this? Import into another database (something like Access) then export to Oracle? Scripting on the Oracle side that would do this? Mind you there is about 300,000 records, so this isn't a menial task, neseccarily. Also, although the two databases are of similar structure, they aren't identical, so some translation would be needed. Thank you, Hans [EMAIL PROTECTED] __ Do You Yahoo!? Make international calls for as low as $.04/minute with Yahoo! Messenger http://phonecard.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: advise about add [MySQl-MailList] label to all mail subject from this list
On Sat, Aug 25, 2001 at 09:42:33AM +0800, aDragon wrote: hi, I think this mail list is very helpful to me. But several hundred letters one day may bomb my mailbox up, and it is a great problem to manage all the letter. I have an advice to the friends who manage this list. Please add a label to every letter from this mail list in order for all of us to use mail filter fluently. example: from: [EMAIL PROTECTED] to :[EMAIL PROTECTED] Subject: [MySQl-MailList] problem about * What's wrong with [EMAIL PROTECTED]? I use the following in my .procmailrc: :0: * ^[EMAIL PROTECTED] IN.mysql Everything from the list ends up in the folder IN.mysql. In the past I've had no trouble managing other lists like this, even when I didn't have access to procmail. Even Outlook can do this. database, ... -- Any technology distinguishable from magic is insufficiently advanced. TopQuark Software Serv. Contract programmer, server bum. [EMAIL PROTECTED]Give up Spammers; I use procmail. - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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: JDBC Primary key error
Also, I'm seeing this in the logfile: java.lang.NullPointerException WOApplication 'Newsie': Exception occurred while handling request: com.webobjects.foundation.NSForwardException [com.webobjects.jdbcadaptor.JDBCAdaptorException] null Paul (in case you're wondering, yes, i did get mysql working argh.) info: WO5, Mac OS X 10.0.4, MySQL 3.23.32, mm.mysql JDBC adaptor 2.0.6.1 I get this error: java.lang.IllegalStateException: Adaptor com.webobjects.jdbcadaptor.JDBCAdaptor@b7ad3 failed to provide new primary keys for entity 'Style' here's the code excerpt: editingContext.insertObject(styleItem); editingContext.insertObject(colourItem); editingContext.saveChanges(); --- dies here What's interesting is that EOModeler creates the table like this: ++-+--+-+-+---+ | Field | Type| Null | Key | Default | Extra | ++-+--+-+-+---+ | id | int(11) | | PRI | 0 | | | style_name | varchar(10) | YES | | NULL| | ++-+--+-+-+---+ there's no auto_increment for the id. - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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 Migration
MySQL does have a program mysqlimport. I, myself, being a scripting gal would most probably dump my Oracle DB into a comma delimited file or straight out raw SQL and make the text substitions to match the INSERT and CREATE TABLE syntax. Post a sample of your dump file and I can help you forge an import script. [.kate] -Original Message- From:Hans Zaunere [EMAIL PROTECTED] Sent:Sat, 25 Aug 2001 10:39:52 -0700 (PDT) To: [EMAIL PROTECTED] Subject: MySQL Migration We have about 300,000 records currently in a MySQL database. A new system has been built on Oracle, and now we must migrate the data from MySQL to Oracle (I know, it's not something I wanted to do.) What is the best way to do this? Import into another database (something like Access) then export to Oracle? Scripting on the Oracle side that would do this? Mind you there is about 300,000 records, so this isn't a menial task, neseccarily. Also, although the two databases are of similar structure, they aren't identical, so some translation would be needed. Thank you, Hans [EMAIL PROTECTED] __ Do You Yahoo!? Make international calls for as low as $.04/minute with Yahoo! Messenger http://phonecard.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 ___ Visit http://www.visto.com. Find out how companies are linking mobile users to the enterprise with Visto. - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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 Still a wise choice for developers?
On Sat, Aug 25, 2001 at 06:37:26PM +0200, Chris Chabot wrote: I have been looking at this mysql.com/org dispute for a while now, and i must say i am getting more and more wurried. Many of us have. I have been a faithfull user of MySql for some years now. Not because it is the 'best full features database out there', but because it serves my specific needs perfectly (easy intergration with PHP and support for tons of images stored in a database). Great. Now, a few years after first using MySql, a major dispute seems to plague the 'image' of MySql, and posibly also the future of the product. The image of MySQL or NuSphere? Big disputes like this won't make any customer of mine choose my MySql-based product any faster, quite the oposite, and i have already recieved numorous questions from my clients about my MySql choice.. What are they asking, specifically? I am not siding with any party, nor giving (or want to have) any opinion on this dispute, however it is hurting my buisness, and my faith in continued fast development in MySql. Will it help when you see MySQL 4.0 come out? MySql is not 'there' yet, it has a while to go before it is 'there' (thats why external parties sponsoring or helping with mysql 4 sounded great). Where is 'there' for you? For my clients, and my self, only the bottom line matters... will this still be a product of choice in a few years, and is it worth the investment of resources to use it. The last thing that wurries me is the lack of updates on the issue, when i, as a wurried client customer go to the mysql.com website, the only thing i find is a 'open inventation for 2001/07/18'. Being deep-august i presume that has come and gone, and no results or communications can be found.. (and the changelog mentioning: All reference to Gemini DB removed). MySql.org offers even less information. You can assume that *something* is going on--maybe it's just lawyers talking at each other. NuSphere did just send some patches into the MySQL developers (earlier this week). I know that the folks at MySQL have been trying to get the dispute resolved. So, my real question, is MySql still the top choice for developers? It is for some. Others like PostreSQL, Oracle, DB2, etc. Can you affirm that my choice for MySql is the right one? Only you can do that. Jeremy -- Jeremy D. Zawodny, [EMAIL PROTECTED] Technical Yahoo - Yahoo Finance Desk: (408) 349-7878 Fax: (408) 349-5454 Cell: (408) 685-5936 MySQL 3.23.41-max: up 8 days, processed 106,624,559 queries (140/sec. avg) - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: Replication advice needed...
On Fri, Aug 24, 2001 at 09:37:43AM -0700, Bryan Coon wrote: The other solution is rsync. I dont know much about this guy yet, but I have some concerns with using it to copy over large remote files. For example, if I have a 1.2 gig table that has been heavily modified over a weeks work, how reliable is the remote file after rsync? I guess Im just concerned about data integrity. I've never had rsync corrupt data, and we routinely push around gigabytes per day (as a company) using rsync. Jeremy -- Jeremy D. Zawodny, [EMAIL PROTECTED] Technical Yahoo - Yahoo Finance Desk: (408) 349-7878 Fax: (408) 349-5454 Cell: (408) 685-5936 MySQL 3.23.41-max: up 8 days, processed 106,728,794 queries (140/sec. avg) - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: MySQL Migration
At 10:39 AM -0700 8/25/01, Hans Zaunere wrote: We have about 300,000 records currently in a MySQL database. A new system has been built on Oracle, and now we must migrate the data from MySQL to Oracle (I know, it's not something I wanted to do.) What is the best way to do this? Import into another database (something like Access) then export to Oracle? Scripting on the Oracle side that would do this? Mind you there is about 300,000 records, so this isn't a menial task, neseccarily. Also, although the two databases are of similar structure, they aren't identical, so some translation would be needed. Oracle has some kind of MySQL-to-Oracle tool. Check their Web site. I've never used it, so I can't comment on how well it works. Thank you, Hans [EMAIL PROTECTED] -- Paul DuBois, [EMAIL PROTECTED] - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
innobase problem
As stated on the bugs and fixes page on http://www.innodb.com/bugfixes.html there is a problem with the latest innodb code that causes corruption when doing updates... I believe I have run into that problem... First mysql would hang.. and do nothing. After killing it and restarting it the error log reads: InnoDB: Doing recovery: scanned up to log sequence number 10 2051892005 InnoDB: Starting an apply batch of log records to the database... InnoDB: Apply batch completed But hangs there again and mysql doesnt seem to come back up. I dont care about the data being rolled back I just want to get the database back up and running. Is there a way I can delete the rollback logs safely? Anyone know how I can get the database back up quickly? Thanks, ryan - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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: where option in mysqldump
On 24-Aug-2001 [EMAIL PROTECTED] wrote: Can anyone give an example of how to use the where option in mysqldump to get a dump of only those records whose values of field fieldx are larger than something? For example for all database tables of db mydatabase which possess a field named fieldx store in the dump only those records whose value of fieldx is larger than '123_xyx_' ? I tried --where= fieldx '123_xyx_ and got no complaints, but it returned all records. Try closing your quotes --where= fieldx '123_xyx_' Regards, -- Don Read [EMAIL PROTECTED] -- It's always darkest before the dawn. So if you are going to steal the neighbor's newspaper, that's the time to do it. (53kr33t w0rdz: sql table query) - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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: Version 4.0
On Sat, Aug 25, 2001 at 08:32:00AM -0500, Steve Suehring wrote: Hello- I poked around on the site but didn't find any definite answer. Roughly when is version 4.0 of MySQL expected out? I saw the information on the todo in regards to version 4.0 and the subsequent 4.1 but didn't see any dates. There's been talk of an initial (beta?) release in about a month. Jeremy -- Jeremy D. Zawodny, [EMAIL PROTECTED] Technical Yahoo - Yahoo Finance Desk: (408) 349-7878 Fax: (408) 349-5454 Cell: (408) 685-5936 MySQL 3.23.41-max: up 8 days, processed 106,831,272 queries (140/sec. avg) - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
RE: MySQL Migration
Hello Hans, a few weeks ago i had a similar task to accomplish, porting a mySQL DB over to IBM's DB2 for S/390, so i can relate to this kind of *most exciting* job. Anyway, from my experience I wouldn't recommend anything like a bulk copy or mass import/export. Because when you are switching to a different DB vendor you will always have difference in field length, types etc. So the best would be to pick some records from the mySQL database that contains all information you will have to bring into the oracle system. An oracle script should do the data validation, mapping to the new fields and inserting into the new db. After all the new rows will be transferred you can walk through those records and check if all trans- actions went well. If all information arrived in the right format and length than you can import the bulk. Regards, Bernhard -Original Message- From: Hans Zaunere [mailto:[EMAIL PROTECTED]] Sent: Saturday, August 25, 2001 7:40 PM To: [EMAIL PROTECTED] Subject: MySQL Migration We have about 300,000 records currently in a MySQL database. A new system has been built on Oracle, and now we must migrate the data from MySQL to Oracle (I know, it's not something I wanted to do.) What is the best way to do this? Import into another database (something like Access) then export to Oracle? Scripting on the Oracle side that would do this? Mind you there is about 300,000 records, so this isn't a menial task, neseccarily. Also, although the two databases are of similar structure, they aren't identical, so some translation would be needed. Thank you, Hans [EMAIL PROTECTED] __ Do You Yahoo!? Make international calls for as low as $.04/minute with Yahoo! Messenger http://phonecard.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: Perl DBI -- How to select all returned values into an array
At 10:07 AM -0700 8/24/01, Katherine Porter wrote:
For single values I usually use this DBI function and query:
my $val =3D $dbh-selectrow_array(SELECT value FROM tab1 WHERE test=3D=
2);
However, what if I want to store a bunch of values into an array?
my @vals =3D $dbh-?(SELECT value FROM tab1 WHERE test 10);
What's the syntax I'm missing above? Any help appreciated!
[.kate]
my $ref = $dbh-selectcol_arrayref (single-column query);
my @val = (defined ($ref) ? @{$ref} : () );
--
Paul DuBois, [EMAIL PROTECTED]
-
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/ (the list archive)
To request this thread, e-mail [EMAIL PROTECTED]
To unsubscribe, e-mail [EMAIL PROTECTED]
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: advise about add [MySQl-MailList] label to all mail subject from this list
On Sat, Aug 25, 2001 at 09:42:33AM +0800, aDragon wrote: I think this mail list is very helpful to me. But several hundred letters one day may bomb my mailbox up, and it is a great problem to manage all the letter. I have an advice to the friends who manage this list. Please add a label to every letter from this mail list in order for all of us to use mail filter fluently. example: I doubt it'll happen. This topic comes up every couple months (check the archives), and the conclusion is always the same: There are already more than enough ways to identify and filter traffic form this list. Munging the subject line would only serve to annoy people and waste valuable space in the Subject line. Jeremy -- Jeremy D. Zawodny, [EMAIL PROTECTED] Technical Yahoo - Yahoo Finance Desk: (408) 349-7878 Fax: (408) 349-5454 Cell: (408) 685-5936 MySQL 3.23.41-max: up 8 days, processed 106,839,518 queries (140/sec. avg) - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: Error
Hi,
You are missing the ; at the end of the SQL statement
try $query = SELECT * FROM question WHERE answer'1' AND id250 ORDER BY
id;;
instead of $query = SELECT * FROM question WHERE answer'1' AND id250
ORDER BY id;
CPereira
- Original Message -
From: Martin Kampherbeek [EMAIL PROTECTED]
To: [EMAIL PROTECTED]
Sent: Saturday, August 25, 2001 8:17 AM
Subject: Error
I still get this error. Can someone help me to solve this?
MySQL Query Failed. Error 1030: Got error -1 from table handler
$query = SELECT * FROM question WHERE answer'1' AND id250 ORDER BY
id;
$result = mysql_query($query) or die('MySQL Query Failed. Error
'.mysql_errno().':
'.mysql_error());
$number = mysql_num_rows($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
-
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/ (the list archive)
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 Still a wise choice for developers?
I would also strongly suggest not storing your images in the database but rather a link to the image. even that - why? if you're using an ultrafast webserver like Tux in combination with Apache/php-perl the Tux webserver serves the images incredibly fast (see specweb tests) what advantage is the storing of a link to images in a SQL database? i.t - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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: Data Encryption
I don't know if this just a shoot in the wind but heres my configuration. Everyting to be posted to and from the db is done first threw https: then I have a VPN set from the actual db to http. From inside the VPN I have it setup for IPsec. This is about as secure as I possibly know from my history thus far. -- Arnix Security, Inc. Michael Olden http://www.arnix.net/ Charles Williams wrote: correct. however, as I stated you would need the key to decrypt it in the end to be able to use the data. With a slight modification to an md5 or sha-1 javascript it could be done. However, if the key is ever comprimised you are in trouble. chuck - Original Message - From: Elizabeth Alderton [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: Thursday, August 23, 2001 9:26 AM Subject: Re: Data Encryption Dear Chuck Your idea has given me an idea. How about: When we actually collect the data, we encrypt it so that it is actually held in mysql in an encrypted form? Then it can speed up and down the phone lines in the 'raw' so to speak, but it's still in code so no one can get it anyway? We wouldn't need SSH or SSL then would we? Or is that too simplistic? Regards Elizabeth -Original Message- From: Charles Williams [EMAIL PROTECTED] To: Elizabeth Alderton [EMAIL PROTECTED]; [EMAIL PROTECTED] [EMAIL PROTECTED] Date: 22 August 2001 21:30 Subject: Re: Data Encryption I use a random key generating SHA-1 js module for all my encryption for passwords. You could do something the same using a fixed key system so that once it's on the server you can decrypt it. However, I haven't tried it yet with SHA-1 so don't know how difficult or sane it would be to try. chuck - Original Message - From: Elizabeth Alderton [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: Wednesday, August 22, 2001 6:11 PM Subject: Data Encryption If I do a SELECT query to bring data down to a PC (this is being done through Delphi) how can I encrypt the data so that it comes safely? Equally when doing UPDATE and INSERT in the other direction I would want to encrypt the data. Can anyone help please? Regards Elizabeth - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] com Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
JDBC Primary key error
(in case you're wondering, yes, i did get mysql working argh.) info: WO5, Mac OS X 10.0.4, MySQL 3.23.32, mm.mysql JDBC adaptor 2.0.6.1 I get this error: java.lang.IllegalStateException: Adaptor com.webobjects.jdbcadaptor.JDBCAdaptor@b7ad3 failed to provide new primary keys for entity 'Style' here's the code excerpt: editingContext.insertObject(styleItem); editingContext.insertObject(colourItem); editingContext.saveChanges(); --- dies here What's interesting is that EOModeler creates the table like this: ++-+--+-+-+---+ | Field | Type| Null | Key | Default | Extra | ++-+--+-+-+---+ | id | int(11) | | PRI | 0 | | | style_name | varchar(10) | YES | | NULL| | ++-+--+-+-+---+ there's no auto_increment for the id. Paul - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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: Perl DBI -- How to select all returned values into an array
On Fri, Aug 24, 2001 at 10:07:59AM -0700, Katherine Porter wrote:
For single values I usually use this DBI function and query:
my $val =3D $dbh-selectrow_array(SELECT value FROM tab1 WHERE test=3D=
2);
However, what if I want to store a bunch of values into an array?
my @vals =3D $dbh-?(SELECT value FROM tab1 WHERE test 10);
What's the syntax I'm missing above? Any help appreciated!
Glance over this for a minute (stolen from an example in perl cookbook):
my $sth = $dbh-prepare( qq{select * from invoice} );
$sth- execute;
while( (my @row) = $sth-fetchrow_array ) {
print join(qq{, }, map {defined $_ ? $_ : qq{(null)} } @row, qq{\n};
}
--
Any technology distinguishable from magic is insufficiently advanced.
TopQuark Software Serv. Contract programmer, server bum.
[EMAIL PROTECTED]Give up Spammers; I use procmail.
-
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/ (the list archive)
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, Web Objects 5: job connection problems
Hi !! )-Original Message- )From: Paul Schreiber [mailto:[EMAIL PROTECTED]] )Sent: Friday, August 24, 2001 1:21 PM )To: Web Objects admin; Web Objects newsiest; Web Objects dev; MySQL List )Subject: MySQL, Web Objects 5: job connection problems ) ) )Comfit: )* Mac: Mac OS X 10.0.4; java 1.3.1; MySQL 3.23.32 )* Linux: Linux 2.2.19/defiant testing; java 1.3.1; MySQL 3.23.36 ) )I *really* could use some help here. I need to get MySQL up and running; )I've been at it for 2 days and can't get my WO app to see it, whether I )try on Linux or OS X. ) )Here's the scoop ... let's try OS X first: )* .jar files belong in /Library/Java/Home/lib/ext/ )* In Remodeled: ) URL: jdbc:mysql://localhost/newsie ) Driver: org.gjt.mm.mysql.Driver )* MySQL is up and running, and I created a database newsie ) )* EOModeler gives this error )JDBC connection failed for driver :'org.gjt.mm.mysql.Driver'. Driver not )found in Java Runtime! Please verify your C35LASSPATH environment )variable. )The current CLASSPATH for your application is : )/Developer/Applications/EOModeler.app/Contents/Resources/Java/eomodeler.zi )p:/Users/paul/Library/Java:/Library/Java:/System/Library/Java:/Network/Lib )rary/Java:/System/Library/Frameworks/JavaVM.framework/Classes/classes.jar: )/System/Library/Frameworks/JavaVM.framework/Classes/ui.jar:/Library/Java/H )ome/lib/ext/mm.mysql-2.0.6.1.jar:/Developer/Applications/EOModeler.app/Con )tents/Resources/Java/eomodeler.zip ) ) )On Linux: )* .jar files belong in /usr/local/jdk1.3.1/jre/lib/ext/ ) I had the same problem couple of days back when I downloaded 2.0.6.1.jar file from the same web site. But surprisingly, this is not a jar file, it is a source zip/tar file. you can see the file size as 382 KB. When I set my CLASSPATH to this jar file(2.0.6.1.jar) I get the same error saying driver can't be loaded, because this is not a jar executable. Using winzip/tar when I extracted the files from this jar file, then you get the real sources and the real jar file with the name (mm.mysql-2.0.6.jar with size 102 KB). Later I pointed my CLASSPATH to the extracted jar file and worked out well. But I did all these on Windows 200. The problem is in the web, the file name looks like this: mm.mysql-2.0.6.1.jar, but it should be mm.mysql-2.0.6.1.src.tar. Hope this should fix your problem. Let me know the outcome of it. Regards Venu -- For technical support contracts, go to https://order.mysql.com/ __ ___ ___ __ / |/ /_ __/ __/ __ \/ /Mr. Venu [EMAIL PROTECTED] / /|_/ / // /\ \/ /_/ / /__ MySQL AB, Developer /_/ /_/\_, /___/\___\_\___/ Woodside, California USA ___/ www.mysql.com - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: Query optimization issue.
On Thu, Aug 23, 2001 at 11:11:38AM -0700, Steven Roussey wrote: mysql explain select * from dominf.domip order by ip desc; 'ORDER BY something DESC' does not use an index. It must be ascending. See the manual. Also, I forgot, if you do this often and it needs to be in DESC order, you can always alter the app to create and use an extra column 'ip_desc unsigned int not null' and set it in an insert to (0x - ip) and have an index on ip_desc. (If the column was signed you would use 0x7FF - thevariable, but ip numbers need to be stored as unsigned). And it's also worth knowing that this is fixed in 4.0. Jeremy -- Jeremy D. Zawodny, [EMAIL PROTECTED] Technical Yahoo - Yahoo Finance Desk: (408) 349-7878 Fax: (408) 349-5454 Cell: (408) 685-5936 MySQL 3.23.41-max: up 8 days, processed 107,141,973 queries (140/sec. avg) - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: Error
At 11:24 PM +0100 8/25/01, Carlos Pereira wrote:
Hi,
You are missing the ; at the end of the SQL statement
try $query = SELECT * FROM question WHERE answer'1' AND id250 ORDER BY
id;;
instead of $query = SELECT * FROM question WHERE answer'1' AND id250
ORDER BY id;
No. A semicolon statement terminator is a mysql convention, and is
not needed when issuing queries from within an API. For some APIs,
it will even cause queries to fail.
An error from the table handler may indicate a more serious problem,
perhaps requiring a table repair.
CPereira
- Original Message -
From: Martin Kampherbeek [EMAIL PROTECTED]
To: [EMAIL PROTECTED]
Sent: Saturday, August 25, 2001 8:17 AM
Subject: Error
I still get this error. Can someone help me to solve this?
MySQL Query Failed. Error 1030: Got error -1 from table handler
$query = SELECT * FROM question WHERE answer'1' AND id250 ORDER BY
id;
$result = mysql_query($query) or die('MySQL Query Failed. Error
'.mysql_errno().':
'.mysql_error());
$number = mysql_num_rows($result);
--
Paul DuBois, [EMAIL PROTECTED]
-
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/ (the list archive)
To request this thread, e-mail [EMAIL PROTECTED]
To unsubscribe, e-mail [EMAIL PROTECTED]
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
