urgent help needed on replication on windows 2000
Hi, I am working on mysql repliction on windows 2000. I am trying to make the slave as master when the master goes down. When I execute the io thread shutdown on slave after master goes down, it hangs. Even the slave server does not stop on executing the shutdown command using mysqladmin and root user. Regards, Anup Mahansaria -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
RE: urgent help needed on replication on windows 2000
What version of mySQL are you using, 4.0.19 (not yet released) fixes something similar to what you have described. -- DVP -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] Sent: Wednesday, March 31, 2004 7:49 PM To: [EMAIL PROTECTED] Subject: urgent help needed on replication on windows 2000 Hi, I am working on mysql repliction on windows 2000. I am trying to make the slave as master when the master goes down. When I execute the io thread shutdown on slave after master goes down, it hangs. Even the slave server does not stop on executing the shutdown command using mysqladmin and root user. Regards, Anup Mahansaria -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED] -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
RE: urgent help needed on replication on windows 2000
Hi, I am using release 5. What is the release you recommend for such a scenario. Regards, Anup Mahansaria Dathan Vance Pattishall [EMAIL PROTECTED] To r.com[EMAIL PROTECTED], [EMAIL PROTECTED] 04/01/04 11:40 AM cc Subject RE: urgent help needed on replication on windows 2000 What version of mySQL are you using, 4.0.19 (not yet released) fixes something similar to what you have described. -- DVP -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] Sent: Wednesday, March 31, 2004 7:49 PM To: [EMAIL PROTECTED] Subject: urgent help needed on replication on windows 2000 Hi, I am working on mysql repliction on windows 2000. I am trying to make the slave as master when the master goes down. When I execute the io thread shutdown on slave after master goes down, it hangs. Even the slave server does not stop on executing the shutdown command using mysqladmin and root user. Regards, Anup Mahansaria -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED] -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: Urgent help needed - SCO Unix binary
On Tue, 10 Feb 2004 [EMAIL PROTECTED] wrote: Hi, I could not find the binary for SCO Unixware (Intel based) in download section. I suppose mysql supports this environment too. May I know as to where can I find this binary. Do I need to build this myself? There are some version on ftp.zenez.com in the pub/zenez/prgms directory. You may want to try one of them. -- Boyd Gerber [EMAIL PROTECTED] ZENEZ 1042 East Fort Union #135, Midvale Utah 84047 -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Urgent help needed - SCO Unix binary
Hi, I could not find the binary for SCO Unixware (Intel based) in download section. I suppose mysql supports this environment too. May I know as to where can I find this binary. Do I need to build this myself? TIA Regards, Anup Mahansaria -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: Urgent help needed - SCO Unix binary
Hi! If memory serves me correctly, MySQL AB have stopped issuing SCO OpenServer and SCO UnixWare binaries publicly and will only be providing them to customers who take out commercial licences. This is probably due to the fact that OpenServer and UnixWare cost a lot compared ot other OSes, don't represent a huge percentage of the MySQL userbase and that the UDK for each is some disgusting amount to purchase. Which version of UnixWare is it? A workaround might be available in the form of the Linux Kernel Personality. Additionally, the Skunkware repository might be able to help you out if SCO's servers are currently accessible in this virus-infested internet we all wade in. I recently migrated a customer from UnixWare 7.1.1 to Redhat AS 2.1 (they had a copy that a mate sold them cheap) for this and a few other reasons (including Wow! The Redhat desktop looks pretty!). Regards, Chris [EMAIL PROTECTED] wrote: Hi, I could not find the binary for SCO Unixware (Intel based) in download section. I suppose mysql supports this environment too. May I know as to where can I find this binary. Do I need to build this myself? TIA Regards, Anup Mahansaria -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: Urgent help needed - SCO Unix binary
Basically, the stability of the build is dependant on the following factors: * Suitable functions in your C library for threaded applications. UnixWare is apparently fine in this category and doesn't require any workarounds. Installing the latest patches and things would be in your best interest though. * The compiler you use. I'm pretty sure that Skunkware includes GCC 2.95.x . This is one of the recommended compilers for building MySQL binaries. If you install this and can get a clean compile, you'll probably be fine. Regards, Chris [EMAIL PROTECTED] wrote: Hi Chris, I want it on SCO Unixware 7.1.1 (intel based) I did see it in the installation manual of MySQL where they give some instructions for building the binaries for SCO Unixware. Can I go ahead and build it. How do you see the stability factor of such builds. Regards, Anup Mahansaria Chris Nolan [EMAIL PROTECTED] To [EMAIL PROTECTED] 02/10/04 07:47 PM cc [EMAIL PROTECTED] Subject Re: Urgent help needed - SCO Unix binary Hi! If memory serves me correctly, MySQL AB have stopped issuing SCO OpenServer and SCO UnixWare binaries publicly and will only be providing them to customers who take out commercial licences. This is probably due to the fact that OpenServer and UnixWare cost a lot compared ot other OSes, don't represent a huge percentage of the MySQL userbase and that the UDK for each is some disgusting amount to purchase. Which version of UnixWare is it? A workaround might be available in the form of the Linux Kernel Personality. Additionally, the Skunkware repository might be able to help you out if SCO's servers are currently accessible in this virus-infested internet we all wade in. I recently migrated a customer from UnixWare 7.1.1 to Redhat AS 2.1 (they had a copy that a mate sold them cheap) for this and a few other reasons (including Wow! The Redhat desktop looks pretty!). Regards, Chris [EMAIL PROTECTED] wrote: Hi, I could not find the binary for SCO Unixware (Intel based) in download section. I suppose mysql supports this environment too. May I know as to where can I find this binary. Do I need to build this myself? TIA Regards, Anup Mahansaria -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: Urgent help needed - SCO Unix binary
Thanks Chris. Will get back to you if I get some problem. Regards, Anup Mahansaria Chris Nolan [EMAIL PROTECTED] To [EMAIL PROTECTED] 02/11/04 09:32 AM cc [EMAIL PROTECTED] Subject Re: Urgent help needed - SCO Unix binary Basically, the stability of the build is dependant on the following factors: * Suitable functions in your C library for threaded applications. UnixWare is apparently fine in this category and doesn't require any workarounds. Installing the latest patches and things would be in your best interest though. * The compiler you use. I'm pretty sure that Skunkware includes GCC 2.95.x . This is one of the recommended compilers for building MySQL binaries. If you install this and can get a clean compile, you'll probably be fine. Regards, Chris [EMAIL PROTECTED] wrote: Hi Chris, I want it on SCO Unixware 7.1.1 (intel based) I did see it in the installation manual of MySQL where they give some instructions for building the binaries for SCO Unixware. Can I go ahead and build it. How do you see the stability factor of such builds. Regards, Anup Mahansaria Chris Nolan [EMAIL PROTECTED] To [EMAIL PROTECTED] 02/10/04 07:47 PM cc [EMAIL PROTECTED] Subject Re: Urgent help needed - SCO Unix binary Hi! If memory serves me correctly, MySQL AB have stopped issuing SCO OpenServer and SCO UnixWare binaries publicly and will only be providing them to customers who take out commercial licences. This is probably due to the fact that OpenServer and UnixWare cost a lot compared ot other OSes, don't represent a huge percentage of the MySQL userbase and that the UDK for each is some disgusting amount to purchase. Which version of UnixWare is it? A workaround might be available in the form of the Linux Kernel Personality. Additionally, the Skunkware repository might be able to help you out if SCO's servers are currently accessible in this virus-infested internet we all wade in. I recently migrated a customer from UnixWare 7.1.1 to Redhat AS 2.1 (they had a copy that a mate sold them cheap) for this and a few other reasons (including Wow! The Redhat desktop looks pretty!). Regards, Chris [EMAIL PROTECTED] wrote: Hi, I could not find the binary for SCO Unixware (Intel based) in download section. I suppose mysql supports this environment too. May I know as to where can I find this binary. Do I need to build this myself? TIA Regards, Anup Mahansaria -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Urgent help needed ! --- mySQL on Mac OS X
greetings nug we ar estuck in a project to connect to mySQL running on Mac OS X, through TCP/IP, please suggest regards, ram -- +--+ Mac Solutions http://www.macsolutionsindia.com +91 98102 70848 ram @ macsolutionsindia.com MSN: [EMAIL PROTECTED] support @ macsolutionsindia.com +--+ Simplifying solutions for you... Macintosh, Windows, Client/Server, Web - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Urgent Help needed
Hi all, I have used the following script to connect our remote database from my local machine. The PHP script is at my local machine. When I tried to connect the database, instead of connecting to the IP provided in the script, it is searching the Dynamic IP of my Internet Service Provider. and getting the following error. Script in my local machine is : ?php mysql_connect(216.180.237.200,let_rot,vindb) or die (cannot connect to mysqld); mysql_select_db(lnet_bbay) or die(cannot select database); ? The IP 216.180.237.200 is the IP provided by my Web space provider. The error message is, Warning: Access denied for user: '[EMAIL PROTECTED]' (Using password: YES) in c:\apache\htdocs\depots\temp\bomy\connect.php on line 2 Warning: MySQL Connection Failed: Access denied for user:'[EMAIL PROTECTED]' (Using password: YES) inc:\apache\htdocs\depots\temp\bombay\connect.php on line 2 cannot connect to mysqld The IP 203.100.234.139 is the Dynamic IP of my Internet Service Provider. Please help me to sort out the problem. Regards, Vinod. - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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: Urgent Help needed
It looks like you have a dynamic IP your end and the mysql server is looking for a fixed IP. Try name based DNS form your PC. Simon -Original Message- From: [EMAIL PROTECTED] [mailto:manuvi;eth.net] Sent: 18 October 2002 09:38 To: [EMAIL PROTECTED] Cc: [EMAIL PROTECTED] Subject: Urgent Help needed Hi all, I have used the following script to connect our remote database from my local machine. The PHP script is at my local machine. When I tried to connect the database, instead of connecting to the IP provided in the script, it is searching the Dynamic IP of my Internet Service Provider. and getting the following error. Script in my local machine is : ?php mysql_connect(216.180.237.200,let_rot,vindb) or die (cannot connect to mysqld); mysql_select_db(lnet_bbay) or die(cannot select database); ? The IP 216.180.237.200 is the IP provided by my Web space provider. The error message is, Warning: Access denied for user: '[EMAIL PROTECTED]' (Using password: YES) in c:\apache\htdocs\depots\temp\bomy\connect.php on line 2 Warning: MySQL Connection Failed: Access denied for user:'[EMAIL PROTECTED]' (Using password: YES) inc:\apache\htdocs\depots\temp\bombay\connect.php on line 2 cannot connect to mysqld The IP 203.100.234.139 is the Dynamic IP of my Internet Service Provider. Please help me to sort out the problem. Regards, Vinod. - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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: Urgent Help needed
It looks like you have a dynamic IP your end and the mysql server is looking for a fixed IP. Nope, you read it wrong, both of you. MySQL is printing out YOUR IP address, not the address of the server. It's complaining that you don't have permission to access the data you want. sql, 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
Mysql Question - urgent help needed pls
Hi, Could any of you help me in getting a Performance Comparison document for MySQL on different architectures (Intel linux or S390 linux). Regards, prabha - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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: Urgent Help needed
was specified explicitly.) With the C API function mysql_info(), you can find out how many records were copied, and (when IGNORE is used) how many records were deleted due to duplication of unique key values. The FOREIGN KEY, CHECK and REFERENCES clauses don't actually do anything. The syntax for them is provided only for compatibility, to make it easier to port code from other SQL servers and to run applications that create tables with references. See section 5.3 Functionality missing from MySQL. Here is an example that shows some of the uses of ALTER TABLE. We begin with a table t1 that is created as shown below: mysql CREATE TABLE t1 (a INTEGER,b CHAR(10)); To rename the table from t1 to t2: mysql ALTER TABLE t1 RENAME t2; To change column a from INTEGER to TINYINT NOT NULL (leaving the name the same), and to change column b from CHAR(10) to CHAR(20) as well as renaming it from b to c: mysql ALTER TABLE t2 MODIFY a TINYINT NOT NULL, CHANGE b c CHAR(20); To add a new TIMESTAMP column named d: mysql ALTER TABLE t2 ADD d TIMESTAMP; To add an index on column d, and make column a the primary key: mysql ALTER TABLE t2 ADD INDEX (d), ADD PRIMARY KEY (a); To remove column c: mysql ALTER TABLE t2 DROP COLUMN c; To add a new AUTO_INCREMENT integer column named c: mysql ALTER TABLE t2 ADD c INT UNSIGNED NOT NULL AUTO_INCREMENT, ADD INDEX (c); Note that we indexed c, because AUTO_INCREMENT columns must be indexed, and also that we declare c as NOT NULL, because indexed columns cannot be NULL. When you add an AUTO_INCREMENT column, column values are filled in with sequence numbers for you automatically. Best of luck. ~ SubbaReddy .M Sr. Programmer, Frontlinesoft, Hyderabad ( http://www.frontlinesoft.com ) Ph: 91-40-3392147, 3391683 w3doc: http://www.geocities.com/msubbareddy/ ICQ: 56093095 - Original Message - From: Karuku Srinivas [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: Wednesday, January 30, 2002 1:12 PM Subject: Urgent Help needed Hi All, Can anyone please tell me how to alter a table wherin modify a column (which is Unique) to a non unique column. Any help on this would be great . Thanks Regards, K Srinivas res Ph:6631851 ATS TransLogic Systems 5th Floor Amogh Plaza, Greenlands, Hyderabad, AP 500 016, India Tel: +91-40-3401795 x30 Fax: +91-40-3407943 http://www.translogicsys.com Logic that Works. - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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
Urgent Help needed
Hi All, Can anyone please tell me how to alter a table wherin modify a column (which is Unique) to a non unique column. Any help on this would be great . Thanks Regards, K Srinivas res Ph:6631851 ATS TransLogic Systems 5th Floor Amogh Plaza, Greenlands, Hyderabad, AP 500 016, India Tel: +91-40-3401795 x30 Fax: +91-40-3407943 http://www.translogicsys.com Logic that Works. - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Urgent help needed, is this a version bug?
Hello John, are you sure, that the user test with password test1 exist in your Grant-Tables and has rights to INSERT ??? [;-)] Gruß Christian john zie wrote: Mysql: We have installed mysql 3.23.26 beta version to a BSD 4.2 server. It works fine, however when we test a php file which just function to insert some data to a table in database, and display all data on the web page. After run this, the data have been inserted and displayed; however, it give us a warning message Warning: MySQL: Unable to save result set in . . I test the same scripts in many other servers with MySQl 3.22.23,(BSD) , MYSQL 2.23.36(Linux), there are no errors or any warning messges at all. Is there a way to reconfigration MYSQL, or PHP to eliminate this problem. The following is a typical test .php: to run this sript, you just create a table call user on your test database. SQL Scripts to create the table create table user (Uname varchar(20) passvarchar(8)); HTML BODD TITLE New Document /TITLE /HEAD BODY ?php $db = mysql_connect(localhost, test, test1) ; mysql_select_db(testdata); if($submit) { $query = INSERT INTO user (user, pass) values ('$user', '$pass') ; $result = mysql_query($query, $db); echo Your values have been inserted in databaseBR; } $select = SELECT * FROM user; $result1 = mysql_query($select, $db); while($r = mysql_fetch_array($result1)) { $user = $r[user]; $pass = $r[pass]; echo This is user: $userBR; echo This is pass: $passBR; } ? form name = frm method = get Username:input type = text name = userbr Password:input type = password name = pass input type = submit name = submit /form /BODY /HTML Thanks, John _ 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] mailto:[EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] mailto:[EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Urgent Help needed for installing
Hello All, I've been trying upgrade our current MySQL 3.23.39 to the 3.23.40 I have tired with both the binary distro and source distro with no luck. The install seems to go OK, but I can't start the mysql server. This is on a RH/Linux 6.2 Kernel 2.4.6 i686 system. The main problem seems to be, that our dedicated server comes with a WebHosting Mgr browser interface and Cpanel for customers to use and the MySQL installation is all tied into this. So it must be, for what I have been told, that we must use the current settings to upgrade, which I did. Datadir /var/lib/mysql I tried with Mysql-Max binary install, but couldn't get the symbolic link to work properly. I unpacked the tar in the /var/lib folder, then created the symbolic link as it specifies to the mysql folder, still no luck. I tried installing the source distro, with the ./configure --prefix=/var/lib/mysql Everything seem to install OK, but when attempting to start the mysql server, sometimes it looks for the mysql.sock in the /var/lib/mysql folder, and sometimes it looks for it in the /tmp folder. I copied the mysql.server to the /etc/rc.d/init.d folder chmoded it 500, create the various symbolic links to the /etc/rc2.d and rc3.d, rc4.d as outlined. Then if I do: /etc/rc.d/init.d/mysql stop or start it complains it can create or find the .pid file which is suppose to be in the /var/lib/mysql folder. all the chown settings are correct: chown mysql.root for the /var/lib/mysql folder I have a feeling something from the current version is causing some problems and screwing with the upgrade. If any one maybe able to shed some lite to what I maybe doing work, it would be much appreciated. Our support/tech people are very slow to responded to help and we need to have this installed in the next day and require the transaction support with BDB tables. THX's, Mike(mickalo)Blezien =-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-= Thunder Rain Internet Publishing Providing Internet Solutions that work! http://www.thunder-rain.com Tel: 1(225)686-2002 =-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-= - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Urgent Help needed for installing
Hello All, I've been trying upgrade our current MySQL 3.23.39 to the 3.23.40 I have tired with both the binary distro and source distro with no luck. The install seems to go OK, but I can't start the mysql server. This is on a RH/Linux 6.2 Kernel 2.4.6 i686 system. Please disregard this posting, after blowing everything out and starting from scratch I was finally able to get the source distro successfully installed now! :) Just one other question, I thought that the source distro 3.23.40 came with BDB table handlers enabled by default?? Come find out it doesn't!! Is there something else that needs to be done during the install to enable BDB table handlers?? THX's Mike(mickalo)Blezien =-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-= Thunder Rain Internet Publishing Providing Internet Solutions that work! http://www.thunder-rain.com Tel: 1(225)686-2002 =-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-= - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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: Urgent Help needed for installing
At 2:55 PM -0500 7/25/01, MikemickaloBlezien wrote: Hello All, I've been trying upgrade our current MySQL 3.23.39 to the 3.23.40 I have tired with both the binary distro and source distro with no luck. The install seems to go OK, but I can't start the mysql server. This is on a RH/Linux 6.2 Kernel 2.4.6 i686 system. Please disregard this posting, after blowing everything out and starting from scratch I was finally able to get the source distro successfully installed now! :) Just one other question, I thought that the source distro 3.23.40 came with BDB table handlers enabled by default?? Come find out it doesn't!! Is there something else that needs to be done during the install to enable BDB table handlers?? Source distributions don't really come with any table handler enabled by default, because there are no binaries included in the distribution. To see what options control the table handlers, run this command: ./configure --help | more THX's Mike(mickalo)Blezien =-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-= Thunder Rain Internet Publishing Providing Internet Solutions that work! http://www.thunder-rain.com Tel: 1(225)686-2002 =-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-= -- 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: Urgent Help needed for installing
MikemickaloBlezien [EMAIL PROTECTED] writes: Hello All, I've been trying upgrade our current MySQL 3.23.39 to the 3.23.40 I have tired with both the binary distro and source distro with no luck. The install seems to go OK, but I can't start the mysql server. This is on a RH/Linux 6.2 Kernel 2.4.6 i686 system. Please disregard this posting, after blowing everything out and starting from scratch I was finally able to get the source distro successfully installed now! :) Just one other question, I thought that the source distro 3.23.40 came with BDB table handlers enabled by default?? Come find out it doesn't!! Is there something else that needs to be done during the install to enable BDB table handlers?? Hi, Please read: http://www.mysql.com/doc/B/D/BDB_install.html Regards, Matt -- For technical support contracts, visit https://order.mysql.com/ __ ___ ___ __ / |/ /_ __/ __/ __ \/ /Mr. Matt Wagner [EMAIL PROTECTED] / /|_/ / // /\ \/ /_/ / /__ MySQL AB, Herr Direktor /_/ /_/\_, /___/\___\_\___/ Hopkins, Minnesota 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: Urgent Help needed for installing
At 4:08 PM -0500 7/25/01, MikemickaloBlezien wrote: On Wed, 25 Jul 2001 16:04:17 -0500, Paul DuBois [EMAIL PROTECTED] wrote: Source distributions don't really come with any table handler enabled by default, because there are no binaries included in the distribution. To see what options control the table handlers, run this command: ./configure --help | more Paul, So this would have to be done thur the install of the source distro?? Yes. That's what you were asking about, weren't you? Binary distributions don't include a configure script. Do I need to re-install the source again to use BDB tables?? You need to recompile, then reinstall the binaries that the recompilation builds, yes. Mike(mickalo)Blezien =-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-= Thunder Rain Internet Publishing Providing Internet Solutions that work! http://www.thunder-rain.com Tel: 1(225)686-2002 =-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-= -- 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
Urgent help needed, is this a version bug?
Mysql: We have installed mysql 3.23.26 beta version to a BSD 4.2 server. It works fine, however when we test a php file which just function to insert some data to a table in database, and display all data on the web page. After run this, the data have been inserted and displayed; however, it give us a warning message Warning: MySQL: Unable to save result set in . . I test the same scripts in many other servers with MySQl 3.22.23,(BSD) , MYSQL 2.23.36(Linux), there are no errors or any warning messges at all. Is there a way to reconfigration MYSQL, or PHP to eliminate this problem. The following is a typical test .php: to run this sript, you just create a table call user on your test database. SQL Scripts to create the table create table user (Uname varchar(20) passvarchar(8)); HTML BODD TITLE New Document /TITLE /HEAD BODY ?php $db = mysql_connect(localhost, test, test1) ; mysql_select_db(testdata); if($submit) { $query = INSERT INTO user (user, pass) values ('$user', '$pass') ; $result = mysql_query($query, $db); echo Your values have been inserted in databaseBR; } $select = SELECT * FROM user; $result1 = mysql_query($select, $db); while($r = mysql_fetch_array($result1)) { $user = $r[user]; $pass = $r[pass]; echo This is user: $userBR; echo This is pass: $passBR; } ? form name = frm method = get Username:input type = text name = userbr Password:input type = password name = pass input type = submit name = submit /form /BODY /HTML Thanks, John _ 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
Re: Urgent Help needed for installing
I've been trying upgrade our current MySQL 3.23.39 to the 3.23.40 I have tired with both the binary distro and source distro with no luck. The install seems to go OK, but I can't start the mysql server. This is on a RH/Linux 6.2 Kernel 2.4.6 i686 system. Please disregard this posting, after blowing everything out and starting from scratch I was finally able to get the source distro successfully installed now! :) Just one other question, I thought that the source distro 3.23.40 came with BDB table handlers enabled by default?? Come find out it doesn't!! Is there something else that needs to be done during the install to enable BDB table handlers?? Thanks Matt! I looked all over the manual, and I'll be damn if I could find that! Oh well :) Thx's On Wed, 25 Jul 2001 16:08:52 -0500, Matt Wagner [EMAIL PROTECTED] wrote: Hi, Please read: http://www.mysql.com/doc/B/D/BDB_install.html Regards, Mike(mickalo)Blezien =-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-= Thunder Rain Internet Publishing Providing Internet Solutions that work! http://www.thunder-rain.com Tel: 1(225)686-2002 =-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-= - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Urgent Help Needed
Hi Group, I posted this question before, and need help urgently. The problem is using a specific search! What we are trying to do is intially search 3 fields and then once the results are found it needs to be able to narrow down the results by searching the intial 3 criteria and also a keywords search on a full text index. I have tried but got no success as I keep getting SYNTAX error. Can anyone please help, this is most urgent. The one we tried was: $SQL = SELECT * FROM cvtemplate WHERE employment_type = '$employment_type' AND location = '$location' AND related_discipline = '$related_discipline', MATCH specific_work_profile, wxcdone, wxcdtwo, wxcdthree, wxcdfour AGAINST ('$keywords') AS score FROM cvtemplate HAVING score!=0 ORDER BY score DESC; From this we get the following error: You have an error in your SQL syntax near ' MATCH specific_work_profile, wxcdone, wxcdtwo, wxcdthree, wxcdfour AGAINST ('CE' at line 1 Is there a specific way we need to do this query! Basically we are trying to do a MATCH and additional query on the same. Your help is truly appreciated. Thanks Barry Zimmerman - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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: Urgent Help Needed
The one we tried was: $SQL = SELECT * FROM cvtemplate WHERE employment_type = '$employment_type' AND location = '$location' AND related_discipline = '$related_discipline', MATCH specific_work_profile, wxcdone, wxcdtwo, wxcdthree, wxcdfour AGAINST ('$keywords') AS score FROM cvtemplate HAVING score!=0 ORDER BY score DESC; From this we get the following error: You have an error in your SQL syntax near ' MATCH specific_work_profile, wxcdone, wxcdtwo, wxcdthree, wxcdfour AGAINST ('CE' at line 1 Have you tried: SELECT * FROM cvtemplate, MATCH (specific_work_profile, wxcdone, wxcdtwo, wxcdthree, wxcdfour) AGAINST ('$keywords') AS score FROM cvtemplate WHERE employment_type = '$employment_type' AND location = '$location' AND related_discipline = '$related_discipline' HAVING score != 0 ORDER BY score DESC - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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: Urgent Help Needed
Hi, Does $keywords contain a quote ? You must escape special characters in strings before using them in SQL statements. If you are using Perl DBI look use 'quote' function otherwise, check MySQL API for your programming language. Hope this helps -- Joseph Bueno NetClub/Trader.com [EMAIL PROTECTED] wrote: Hi Group, I posted this question before, and need help urgently. The problem is using a specific search! What we are trying to do is intially search 3 fields and then once the results are found it needs to be able to narrow down the results by searching the intial 3 criteria and also a keywords search on a full text index. I have tried but got no success as I keep getting SYNTAX error. Can anyone please help, this is most urgent. The one we tried was: $SQL = SELECT * FROM cvtemplate WHERE employment_type = '$employment_type' AND location = '$location' AND related_discipline = '$related_discipline', MATCH specific_work_profile, wxcdone, wxcdtwo, wxcdthree, wxcdfour AGAINST ('$keywords') AS score FROM cvtemplate HAVING score!=0 ORDER BY score DESC; From this we get the following error: You have an error in your SQL syntax near ' MATCH specific_work_profile, wxcdone, wxcdtwo, wxcdthree, wxcdfour AGAINST ('CE' at line 1 Is there a specific way we need to do this query! Basically we are trying to do a MATCH and additional query on the same. Your help is truly appreciated. Thanks Barry Zimmerman - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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: Urgent Help Needed
Hi I escape all the characters as the values are passed to the page. It is driving me mad, just to get this to work! Not many people I know have the solution. I would have thought searching FULLTEXT and other fields at the same time would be easy. Any help again appreciated. Barry In a message dated 14/5/01 11:02:42 am, [EMAIL PROTECTED] writes: Hi, Does $keywords contain a quote ? You must escape special characters in strings before using them in SQL statements. If you are using Perl DBI look use 'quote' function otherwise, check MySQL API for your programming language. Hope this helps -- Joseph Bueno NetClub/Trader.com [EMAIL PROTECTED] wrote: Hi Group, I posted this question before, and need help urgently. The problem is using a specific search! What we are trying to do is intially search 3 fields and then once the results are found it needs to be able to narrow down the results by searching the intial 3 criteria and also a keywords search on a full text index. I have tried but got no success as I keep getting SYNTAX error. Can anyone please help, this is most urgent. The one we tried was: $SQL = SELECT * FROM cvtemplate WHERE employment_type = '$employment_type' AND location = '$location' AND related_discipline = '$related_discipline', MATCH specific_work_profile, wxcdone, wxcdtwo, wxcdthree, wxcdfour AGAINST ('$keywords') AS score FROM cvtemplate HAVING score!=0 ORDER BY score DESC; From this we get the following error: You have an error in your SQL syntax near ' MATCH specific_work_profile, wxcdone, wxcdtwo, wxcdthree, wxcdfour AGAINST ('CE' at line 1 Is there a specific way we need to do this query! Basically we are trying to do a MATCH and additional query on the same. Your help is truly appreciated. Thanks Barry Zimmerman - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php --- Headers Return-Path: [EMAIL PROTECTED] Received: from rly-zd02.mx.aol.com (rly-zd02.mail.aol.com [172.31.33.226]) by air-zd01.mail.aol.com (v77_r1.36) with ESMTP; Mon, 14 May 2001 06:02:42 2000 Received: from smtp-gw.netclub.com (home.paris.trader.com [195.68.19.162]) by rly-zd02.mx.aol.com (v78.43) with ESMTP; Mon, 14 May 2001 06:02:30 -0400 Received: from [127.0.0.1] (helo=trader.com) by smtp-gw.netclub.com with esmtp (Exim 3.13 #1) id 14zFBm-Mi-00; Mon, 14 May 2001 12:02:54 +0200 Sender: jbueno Message-ID: [EMAIL PROTECTED] Date: Mon, 14 May 2001 12:02:54 +0200 From: Joseph Bueno [EMAIL PROTECTED] X-Mailer: Mozilla 4.73 [en] (X11; I; Linux 2.2.15-4mdkfb i686) X-Accept-Language: en MIME-Version: 1.0 To: [EMAIL PROTECTED] CC: [EMAIL PROTECTED] Subject: Re: Urgent Help Needed References: [EMAIL PROTECTED] Content-Type: text/plain; charset=us-ascii Content-Transfer-Encoding: 7bit - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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: Urgent Help Needed
Hi, Tried that and also got an error, I just hope someone has had to do this type of search!! Would have thought so! Just need to search a MATCH and others at the same time. Thanks all. Barry In a message dated 14/5/01 10:54:16 am, [EMAIL PROTECTED] writes: The one we tried was: $SQL = SELECT * FROM cvtemplate WHERE employment_type = '$employment_type' AND location = '$location' AND related_discipline = '$related_discipline', MATCH specific_work_profile, wxcdone, wxcdtwo, wxcdthree, wxcdfour AGAINST ('$keywords') AS score FROM cvtemplate HAVING score!=0 ORDER BY score DESC; From this we get the following error: You have an error in your SQL syntax near ' MATCH specific_work_profile, wxcdone, wxcdtwo, wxcdthree, wxcdfour AGAINST ('CE' at line 1 Have you tried: SELECT * FROM cvtemplate, MATCH (specific_work_profile, wxcdone, wxcdtwo, wxcdthree, wxcdfour) AGAINST ('$keywords') AS score FROM cvtemplate WHERE employment_type = '$employment_type' AND location = '$location' AND related_discipline = '$related_discipline' HAVING score != 0 ORDER BY score DESC - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php --- Headers Return-Path: [EMAIL PROTECTED] Received: from rly-yc04.mx.aol.com (rly-yc04.mail.aol.com [172.18.149.36]) by air-yc05.mail.aol.com (v77_r1.36) with ESMTP; Mon, 14 May 2001 05:54:16 2000 Received: from web.mysql.com (web.mysql.com [192.58.197.162]) by rly-yc04.mx.aol.com (v77_r1.36) with ESMTP; Mon, 14 May 2001 05:54:11 -0400 Received: (qmail 8607 invoked by uid 7797); 14 May 2001 09:49:46 - Mailing-List: contact [EMAIL PROTECTED]; run by ezmlm (http://www.ezmlm.org) List-ID: mysql.mysql.com Precedence: bulk List-Help: mailto:[EMAIL PROTECTED] List-Unsubscribe: mailto:[EMAIL PROTECTED] List-Post: mailto:[EMAIL PROTECTED] List-Subscribe: mailto:[EMAIL PROTECTED] Delivered-To: mailing list [EMAIL PROTECTED] Received: (qmail 8567 invoked from network); 14 May 2001 09:49:45 - From: Chris Bolt [EMAIL PROTECTED] To: [EMAIL PROTECTED] Subject: RE: Urgent Help Needed Date: Mon, 14 May 2001 03:52:32 -0600 Message-ID: [EMAIL PROTECTED] MIME-Version: 1.0 Content-Type: text/plain; charset=us-ascii Content-Transfer-Encoding: 7bit X-Priority: 3 (Normal) X-MSMail-Priority: Normal X-Mailer: Microsoft Outlook IMO, Build 9.0.2416 (9.0.2910.0) X-MimeOLE: Produced By Microsoft MimeOLE V5.50.4522.1200 In-Reply-To: [EMAIL PROTECTED] Importance: Normal - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php