Undefined variable error with mysql-3.23.24-beta-win[1] and php-4.0.4pl1-Win32.zip on W2K with IIS 5.0
I am running a web site which runs perfectly on my Unix web hosted site. I have just moved it over to W2K and have undefined variable errors ... my thought is that mysql 3.23.24 for Windows may not support undefined variables and on unix they are supported. Any thoughts on how to get this fixed? Thanks in advance, Mark Bruk [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
mysql with php4
Hello mysql, I've installed the MySQL from RPM version 3.23.32. Then, I install also php4.04 from source with option --with-mysql without giving the path-to-mysql information. It works so far but I get the following information when using the phpinfo() : mysql MySQL Support enabled Active Persistent Links 0 Active Links 0 Client API version 3.23.22-beta MYSQL_INCLUDE MYSQL_LFLAGS MYSQL_LIBS Why does it give the old version number ? Have I done something wrong ? Should I put --with-mysql=/path/to/mysql ? Thanks in advance! -- Best regards, Kenneth mailto:[EMAIL PROTECTED] - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
AW: mysql with php4
Why does it give the old version number ? Have I done something wrong ? Should I put --with-mysql=/path/to/mysql ? Yes, you should. If you leave out the path, PHP uses a MySQL library shipped with the PHP source code. You should have gotten a warning after the ./configure for PHP, explaining the drawbacks of this. - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
I have problem With mysqlGUI
Hi! i use mysql for windown version and i have this problem, as i know the mysqlGUI is a graphical tool to help you to make tables fields and other thinks for your database. I can change the password ,give sql commands but from the menu commands-tables it doesn't work create table, edit table , and drop table. i have one more problem i can't find the file mysqlgui.help in www.mysql.com site.If you can send me the url. Thanks you very much Nikos Tzelvenzis.
About Borland
Hi, Im not sure but: Is it safe to assume that row[0] and row[1] are valid (ie not NULL and not garbage)!(?) ... row = mysql_fetch_row(res); printf("[%s:%s]\n", row[0], row[1]); ... mysql_data_seek(res, 0); ... row = mysql_fetch_row(res); printf("[%s:%s]\n", row[0], row[1]); ... However, it does not crash in VC6.0. Does it do the expected (ie two similar rows)? It might be that VC6 does a correct jobb with garbage pointers (NULL pointers) while Borland has a hard time with them inside printf(...). // Jarmo - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: I have problem With mysqlGUI
Hi!=20 i use mysql for windown version and i have this problem, as i know the mysqlGUI is a graphical tool to help you to make tables = fields and other thinks for your database. I can change the password ,give sql commands but from the menu = commands-tables it doesn't work create table, edit table , and drop = table. i have one more problem i can't find the file mysqlgui.help in = www.mysql.com site.If you can send me the url. Thanks you very much Nikos Tzelvenzis. Hi! Create and alter table are on TODO, while edit is in the works (although I can not find time for it). DROP table is something I could add very fast. Thanks for the idea ! Regards, Sinisa __ _ _ ___ == MySQL AB /*/\*\/\*\ /*/ \*\ /*/ \*\ |*| Sinisa Milivojevic /*/ /*/ /*/ \*\_ |*| |*||*| mailto:[EMAIL PROTECTED] /*/ /*/ /*/\*\/*/ \*\|*| |*||*| Larnaca, Cyprus /*/ /*/ /*/\*\_/*/ \*\_/*/ |*| /*/^^^\*\^^^ /*/ \*\Developers Team - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
replace only certain words in a text column
i want to replace all occurences of www to http://www in all columns of a table. the column contains blocks of text. is there any way to do this directly in mySQL? thankx. =) --- Stephen U. Lee [EMAIL PROTECTED] (632) 714-9924 (0917)9068115 === f o r t h m e d i a http://www.forthmedia.net [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
Setting up MySQL on Windows 2000
Folks, I am totally new to databases, haven't got the foggiest of what's going on here. I have downloaded and installed MySQL 3.23.29 a while back, but I still don't know how to even configure it, even though I have read several articles about using it, and consulted our webmaster, but he's got no time for a wanna-be like me... *grin*... , as well as mailing some friends about it, without success. here's my problem: In my c:\program files\mysql\data directory, there is NOTHING. There's supposed to be a folder mysql. I saw that folder there earlier. I wonder if I haven't by accident deleted it sometime. Anyways, how do I get that contents back? I used the admin tool to create the new database, called mysql, but it's empty. No tables are defined for it. How do I do that? Everyone that I asked have been doing this from Linux, and I am simply unable to follow their instructions... Once I get this fixed, I need to create a new datase, called drupal, which requires login, I need to specify host/password and other info for it. That is unfortunately the only information I've got for this problem. I hope someone makes out what my problem is! Any help would be appreciated. -- Kobus - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Primary key ID gets messed up after deleting/adding
I have a primary key listed as ID When I first added about 10 records and then deleted a few records and then added more records it didn't replace the missing records. When I select all records to view I now get: 1 2 why didn't it go to 3, 4 and 5 after 2? 6 7 8 When I add a record it becomes record 11. Am I doing something wrong when I delete a record? I thought it would move the other records down 6 and 7 would be 3 and 4 etc... Using RedHat Linux with latest MySQL rpms: mysql-server-3.23.32-1.7 php-mysql-4.0.4pl1-3 mysql-devel-3.23.32-1.7 mysqlclient9-3.23.22-3 mysql-3.23.32-1.7 - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Need Help with RH 7.0 RPM install
I have not been able to figure this out, yet. I found the file /usr/share/mysql/make_binary_distribution and tried a make on it; no luck. I scoured the documentation on the web and in my own distribution and have not been able to find out what to do next. See Below. I would appreciate getting some advise as to where to turn next. thanks, HARry I'm trying to set up a database system for the first time. I installed mysql-3.23.32-1.7.i386.rpm on my RedHat Linux version 7.0, but it doesn't seem to have set up correctly. Is anyone familiar with how to proceed from the point of installing this RPM to getting the server configured and the daemon started, so as to be able to start the tutorial on the test DB? In the documentation located here: http://www.mysql.com/doc/P/o/Post-installation.html, the post install instructions don't seem to work. /usr/bin/mysql_install_db gives the following message: "Didn't find /usr/libexec/mysqld You should do a 'make install' before executing this script." Also, I believe I need to be executing the ./mysql_config with some set of arguments according to this section of the documentation: http://www.mysql.com/doc/c/o/configure_options.html "If you want to compile statically linked programs (for example, to make a binary distribution, to get more speed, or to work around problems with some RedHat Linux distributions), run configure like this: shell ./configure --with-client-ldflags=-all-static \ --with-mysqld-ldflags=-all-static " This document is far too generalized for me to know exactly what to do. I've tried bouncing a few things around, but have not been able to move forward. Fortunately, I haven't messed up my system, yet! Lost in the Ozone, HARry - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
bug report - docs
SEND-PR: -*- send-pr -*- SEND-PR: Lines starting with `SEND-PR' will be removed automatically, as SEND-PR: will all comments (text enclosed in `' and `'). SEND-PR: From: root To: [EMAIL PROTECTED] Subject: [50 character or so descriptive subject here (for reference)] Description: INSTALL-BIN file has errors: on the direction shell groupadd mysql shell useradd -g mysql mysql shell cd /usr/local shell gunzip /path/to/mysql-VERSION-OS.tar.gz | tar xvf - shell ln -s mysql-VERSION-OS mysql shell cd mysql shell scripts/mysql_install_db shell chown -R root /usr/local/mysql shell chown -R mysql /usr/local/mysql/var shell chgrp -R mysql /usr/local/mysql shell chown -R root /usr/local/mysql/bin/ shell bin/safe_mysqld --user=mysql : it should be chown -R mysql /usr/local/mysql/data instead "var" How-To-Repeat: see docs Fix: Submitter-Id: submitter ID Originator:root Organization: organization of PR author (multiple lines) MySQL support: [none Synopsis: docs wrong Severity: serious Priority: low Category: mysql Class: doc-bug Release: mysql-3.23.36 (Official MySQL binary) - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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: Need Help with RH 7.0 RPM install
I have not been able to figure this out, yet. I found the file /usr/share/mysql/make_binary_distribution and tried a make on it; no luck. I scoured the documentation on the web and in my own distribution and have not been able to find out what to do next. See Below. I would appreciate getting some advise as to where to turn next. On Redhat, you're usually best of when you use the RPM file from the MySQL site. You can install it just like all other RPMs with rpm -ivh rpm file name The only thing left to do after installation is setting a password for the "root" user. You will get a message after the installation has finished which tells you how to do that. Jens - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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: Primary key ID gets messed up after deleting/adding
When I first added about 10 records and then deleted a few records and then added more records it didn't replace the missing records. That's MySQL's usual behaviour. auto_increment only garantees to create unique keys. "Holes" left by deleting data are not filled. Jens - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Startup Params for MySQL on small Network?
Hello, We're using MySQL on a small local area network with an average of 4 clients hitting the database with SELECTS, INSERTS and UPDATES. We're using a Win2K file server with UDMA/100/7200 HD's and 256 MB Ram. Each client is accessing the DB through MyODBC. Actually it's a VB6 App using the OLE DB Provider for ODBC as well, so the fact that we're getting the speed we're getting says a lot about MySQL. Anyway, I've asked this question before a couple of times, but have received to replies and figure that I should just keep trying (I've looked in the manual, but have not found specifics that I need). I would like to know what would be a good basic setup for variables on the server and what I should set them to given the application of MySQL that we are using it in. Number of MaxConnections, memory allocated for indexing, etc. suggestions would be greatly appreciated so that I can have a good starting point to experiment with. ADV(Thanks)ANCE, Lee Jenkins
Re: Primary key ID gets messed up after deleting/adding
I can understand not wanting to have holes, but.. If it is a primary key, how are you going to handle updating tables that rely on that key id? If your id numbers were to shift, like you want, and you had a related sub table (one to many) and this was say, an shopping cart, then all of a sudden customer A's line items are showing up in Customer B's and not customer A's It is more common to to have reliable unique no shifting keys. You can program in some logic that deletes all related records in related tables, and then re-uses numbers if you want to 'fill' the holes, butis it really worth it? Holes are merely an aesthetic item in the vast majority of cases. Auto_increment behavior is clearly documented in the manual. On 4/8/01 9:35 AM, "David" [EMAIL PROTECTED] wrote: I have a primary key listed as ID When I first added about 10 records and then deleted a few records and then added more records it didn't replace the missing records. When I select all records to view I now get: 1 2 why didn't it go to 3, 4 and 5 after 2? 6 7 8 When I add a record it becomes record 11. Am I doing something wrong when I delete a record? I thought it would move the other records down 6 and 7 would be 3 and 4 etc... Using RedHat Linux with latest MySQL rpms: mysql-server-3.23.32-1.7 php-mysql-4.0.4pl1-3 mysql-devel-3.23.32-1.7 mysqlclient9-3.23.22-3 mysql-3.23.32-1.7 - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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: Primary key ID gets messed up after deleting/adding
How would you actually overcome that? Wouldn't it be good if MySQL would be adapted to actually do this for you? -- Kobus "Jens Vonderheide" [EMAIL PROTECTED] 2001-04-08 19:25:48 When I first added about 10 records and then deleted a few records and then added more records it didn't replace the missing records. That's MySQL's usual behaviour. auto_increment only garantees to create unique keys. "Holes" left by deleting data are not filled. Jens - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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: Primary key ID gets messed up after deleting/adding
No, what is meant here is that: He has record 1 2 3 and 4. Now deletes 2 and 3. Now create 2 new records. MySQL creates them as 5 and 6, instead of 2 and 3 again... --Kobus Lindsay Adams [EMAIL PROTECTED] 2001-04-08 19:42:12 I can understand not wanting to have holes, but.. If it is a primary key, how are you going to handle updating tables that rely on that key id? If your id numbers were to shift, like you want, and you had a related sub table (one to many) and this was say, an shopping cart, then all of a sudden customer A's line items are showing up in Customer B's and not customer A's It is more common to to have reliable unique no shifting keys. You can program in some logic that deletes all related records in related tables, and then re-uses numbers if you want to 'fill' the holes, butis it really worth it? Holes are merely an aesthetic item in the vast majority of cases. Auto_increment behavior is clearly documented in the manual. On 4/8/01 9:35 AM, "David" [EMAIL PROTECTED] wrote: I have a primary key listed as ID When I first added about 10 records and then deleted a few records and then added more records it didn't replace the missing records. When I select all records to view I now get: 1 2 why didn't it go to 3, 4 and 5 after 2? 6 7 8 When I add a record it becomes record 11. Am I doing something wrong when I delete a record? I thought it would move the other records down 6 and 7 would be 3 and 4 etc... Using RedHat Linux with latest MySQL rpms: mysql-server-3.23.32-1.7 php-mysql-4.0.4pl1-3 mysql-devel-3.23.32-1.7 mysqlclient9-3.23.22-3 mysql-3.23.32-1.7 - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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 - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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: uninstalling MySQL
rpm -qa | grep mysql if nothing found, rm -rf /usr/local/var rm -rf `find /usr/local/bin/ | grep mysql` rm -rf /etc/my.cnf This should catch about everything. cheers, roel On Sun, Apr 08, 2001 at 12:24:08AM -0400, David Loszewski wrote: how do I uninstall MySQL 3.22 after installing it? worst part is that I installed it so long ago that I can't remember if I did it by .rpm or .tar help please, Dave - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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: uninstalling MySQL
Probably should change that first line to rpm -qa | grep -i mysql Roel Vanhout wrote: rpm -qa | grep mysql if nothing found, rm -rf /usr/local/var rm -rf `find /usr/local/bin/ | grep mysql` rm -rf /etc/my.cnf This should catch about everything. cheers, roel On Sun, Apr 08, 2001 at 12:24:08AM -0400, David Loszewski wrote: how do I uninstall MySQL 3.22 after installing it? worst part is that I installed it so long ago that I can't remember if I did it by .rpm or .tar help please, Dave - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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 - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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: create table foo select * from bar does not copy keys??
I don't know if the manual says anything about this but if you check Paul's book page 150 (paul now we are referencing your book down to page level) it says: "creating a table by selecting data into it does not automatically copy any indexes from the original table" regards, thalis On Sun, 8 Apr 2001, Marc Swanson wrote: I'm not sure if this is a bug or not, but I just realized today that some of my create table queries (on mysql 3.23.32 ) were not behaving as I would expect.. Example: ** mysql create table foo (id int not null primary key, field1 varchar(55), unique data_index (id,field1)); Query OK, 0 rows affected (0.04 sec) mysql show columns from foo; ++-+--+-+-+---+ | Field | Type| Null | Key | Default | Extra | ++-+--+-+-+---+ | id | int(11) | | PRI | 0 | | | field1 | varchar(55) | YES | | NULL| | ++-+--+-+-+---+ 2 rows in set (0.02 sec) mysql create table bar select * from foo; Query OK, 0 rows affected (0.07 sec) Records: 0 Duplicates: 0 Warnings: 0 mysql show columns from bar; ++--+--+-+-+---+ | Field | Type | Null | Key | Default | Extra | ++--+--+-+-+---+ | id | int(11) | | | 0 | | | field1 | char(55) | YES | | NULL| | ++--+--+-+-+---+ 2 rows in set (0.00 sec) *** As you can see the primary key is not a part of table bar. Nor is the unique index as shown with mysqldump *** root@raid:/home/mswanson mysqldump -d test bar # MySQL dump 8.12 # # Host: localhostDatabase: test # # Server version3.23.32-log # # Table structure for table 'bar' # CREATE TABLE bar ( id int(11) NOT NULL default '0', field1 char(55) default NULL ) TYPE=MyISAM; ** The manual doesn't say anything about this. Is this a bug or just something I missed in the manual? Thanks -Marc- #/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/# #Marc Swanson | # #MSwanson Consulting | \|||/ # # | /o o\ # #Phone: (603)868-1721|-oooOooo-# #Fax:(603)868-1730| Solutions in: # #Mobile: (603)512-1267| 'PHP'Perl # #[EMAIL PROTECTED] | 'SQL'C++ # # | 'HTML 'Sh/Csh# #http://www.mswanson.com | 'Javascript# #/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/# - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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: Working with FIND_IN_SET
On Sun, 8 Apr 2001, John Hart wrote: I am working on a rather large database project, in which I am making a text column that contains different data, seperated by commas. What I need to do is run a query where I will return only the datasets that contain any of sets that partially, or fully match any data in the set... For example, if the dataset contains: dark, black, small I want to be able to return this data if the query contains ran contains any of the following matches: dark black small sma bla ...etc... I do not, however, want a full LIKE search with wildcards, because I do not want to return the set if they were to search on 'all' (which would match smALL). Is there an easy way to do this, or am I forced into matching entire words in a set? I appreciate any help anyone could offer me... Thank you... John If I got you correctly, you might consider RLIKE where you define the mathing string as a regular expressions. So in you case the regexp would be something like: RLIKE ".*, YOUR_QUERY_STRING_HERE.*, .*" regards, thalis - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: Primary key ID gets messed up after deleting/adding
How would you actually overcome that? Wouldn't it be good if MySQL would be adapted to actually do this for you? I think that not reusing deleted numbers is easier (i.e. more efficient). IIRC, earlier versions of MySQL in fact reused the numbers. There are 2 ways to overcome this: 1) Check if you really need to rely on numbers without any gaps. If you tell us what you want to do, someone on the list may come up with a different approach. 2) If you really need that behaviour, you shouldn't use auto_increment, but write your own functions to get a unique key. I did this once (because I needed to support some RDBMSs without auto_increment). It's not that difficult. Jens - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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: Setting up MySQL on Windows 2000
Hi At 18:13 08/04/2001 +0200, Kobus Myburgh wrote: Folks, I am totally new to databases, haven't got the foggiest of what's going on here. I have downloaded and installed MySQL 3.23.29 a while back, but I still don't know how to even configure it, even though I have read several articles about using it, and consulted our webmaster, but he's got no time for a wanna-be like me... *grin*... , as well as mailing some friends about it, without success. here's my problem: In my c:\program files\mysql\data directory, there is NOTHING. There's supposed to be a folder mysql. I saw that folder there earlier. I wonder if I haven't by accident deleted it sometime. Anyways, how do I get that contents back? I used the admin tool to create the new database, called mysql, but it's empty. No tables are defined for it. How do I do that? Everyone that I asked have been doing this from Linux, and I am simply unable to follow their instructions... c:\program files\mysql\data contain sub-folder which turn contain your databases as well as your grant tables. Had you been using a later with replication enabled you could have recovered your databases from the recovery logs. But since it appears that this is not the case you have no alternative but to re-install MySQL and start over again. It might be worth trying something like Norton Undelete Once I get this fixed, I need to create a new datase, called drupal, which requires login, I need to specify host/password and other info for it. That is unfortunately the only information I've got for this problem. I hope someone makes out what my problem is! Any help would be appreciated. -- Kobus - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php Regards John -- MySQL Development Team __ ___ __ __ / |/ /_ __/ __/ __ \/ / John Dean [EMAIL PROTECTED] / /|_/ / // /\ \/ /_/ / /__ MySQL AB, http://www.mysql.com/ /_/ /_/\_, /___/\___\_\/ Mansfield, England, UK ___/ - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
looking for post install tip for mac OS X
anyone know where (or even just how-to) find info on getting mysql to start with system boot? thank you in advance. - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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: replace only certain words in a text column
On Sun, 8 Apr 2001, Stephen U. Lee wrote: i want to replace all occurences of www to http://www in all columns of a table. the column contains blocks of text. is there any way to do this directly in mySQL? Check the manual for the infinite String manipulation functions. If all your records start with a 'www' then the easy way out is: UPDATE table SET column_name=CONCAT("http://",column_name); If not then, again the easy way out is: UPDATE table SET column_name=CONCAT("http://",column_name) WHERE column_name LIKE 'www%'; regards, thalis thankx. =) --- Stephen U. Lee [EMAIL PROTECTED] (632) 714-9924 (0917)9068115 === f o r t h m e d i a http://www.forthmedia.net [EMAIL PROTECTED] --- - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
RE: Working with FIND_IN_SET
You can do the same thing with like: where concat(",",myField,",") like "%,$searchString,%" this will of cause be somewhat slow, how about normalizing your database: header(id,fields) type(id,dataset) header(1,) type(1,black) type(1,dark) ... now you can select * from header,type where (id=id) and dataset in("...","...") group by id So long Martin -Original Message- From: Thalis A. Kalfigopoulos [mailto:[EMAIL PROTECTED]] Sent: Sunday, April 08, 2001 11:42 AM To: John Hart Cc: [EMAIL PROTECTED] Subject: Re: Working with FIND_IN_SET On Sun, 8 Apr 2001, John Hart wrote: I am working on a rather large database project, in which I am making a text column that contains different data, seperated by commas. What I need to do is run a query where I will return only the datasets that contain any of sets that partially, or fully match any data in the set... For example, if the dataset contains: dark, black, small I want to be able to return this data if the query contains ran contains any of the following matches: dark black small sma bla ...etc... I do not, however, want a full LIKE search with wildcards, because I do not want to return the set if they were to search on 'all' (which would match smALL). Is there an easy way to do this, or am I forced into matching entire words in a set? I appreciate any help anyone could offer me... Thank you... John If I got you correctly, you might consider RLIKE where you define the mathing string as a regular expressions. So in you case the regexp would be something like: RLIKE ".*, YOUR_QUERY_STRING_HERE.*, .*" regards, thalis - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
select replace not working with fields on OS X Server
Description: when doing a select replace(fieldname, 'lookforstring', 'replacestring'), the replace never occurs. It works fine if searching on a static string. The behaviour is correct on my Red Hat machine. How-To-Repeat: - easy to repeat (bug was in 3.22.23 as well) - just try a replace in any table (myisam or just isam) - seems to be os-specific Fix: Submitter-Id: submitter ID Originator:Julian Wood "[EMAIL PROTECTED]" Organization: University of Calgary MySQL support: none Synopsis: select replace not working with fields on OS X Server Severity: non-critical Priority: medium Category: mysql Class: sw-bug Release: mysql-3.23.36 (Official MySQL binary) Environment: System: Rhapsody movies 5.5 Kernel Release 5.5: Fri Jul 2 13:10:26 PDT 1999; root(rcbuilder):Objects/kernel-154.14.obj~10/RELEASE_PPC Copyright (c) 1988-1995,1997-1999 Apple Computer, Inc. All Rights Reserved. Power Macintosh Some paths: /usr/bin/perl /bin/make /usr/bin/cc Compilation info: CC='gcc' CFLAGS='-O2 -fno-omit-frame-pointer' CXX='gcc' CXXFLAGS='-O2 -fno-omit-frame-pointer' LDFLAGS='' LIBC: Configure command: ./configure --prefix=/usr/local/mysql '--with-comment=Official MySQL binary' --with-extra-charsets=complex --disable-shared Perl: This is perl, version 5.005_02 built for rhapsody - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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 3.23.36 + myisam + mysqldump
Hi, I have compiled mysql 3.23.36 from tarball source under debian. So I try to modify some defaults to fit to the filesystem layout, used under debian (2.2r2, potato, Kernel 2.4.1). All seemed to work fine. So I make a dump from our database and insert the dump into the new system. After this I can use the mysql-client and can make selects but I'm not be able to use mysqlshow (no database listet) neither mysqldump (I only get the server-version listed). I'm walking through faq and manuals, but there were no hints to clearify my problem. mny tks for any hints to fix Martin Bringe - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
dual processors
Will mysql operate on a dual processor system under linux? Any appreciable performance advantages? - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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: Primary key ID gets messed up after deleting/adding
How I learned to love number gaps: I have a database of colleges and universities. Every degree listing as a numbered id. This used to be auto-incremented. After several deletes and additions, I found it advantageous to have gaps between schools to add new degree listings, so that I didn't get a numbering scenario like School A has degree #s 4, 5, 89, 326 and School B has #s 6, 7 8, 88, 91, 214, etc. If I have gaps, I have room to keep a school's degrees together in a sequence. It makes it so much easier to keep track. Gaps are only a subjective problem. Objectively, they make no difference to the database operation, and administratively, they can be quite useful. When we look past our expectations, we often find new posibilities. On 8 Apr 2001, at 20:37, Jens Vonderheide wrote: How would you actually overcome that? Wouldn't it be good if MySQL would be adapted to actually do this for you? I think that not reusing deleted numbers is easier (i.e. more efficient). IIRC, earlier versions of MySQL in fact reused the numbers. There are 2 ways to overcome this: 1) Check if you really need to rely on numbers without any gaps. If you tell us what you want to do, someone on the list may come up with a different approach. 2) If you really need that behaviour, you shouldn't use auto_increment, but write your own functions to get a unique key. I did this once (because I needed to support some RDBMSs without auto_increment). It's not that difficult. Jens - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php John Jensen 520 Goshawk Court Bakersfield, CA 93309 661-833-2858 - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
table locking
Is there an explanation somewhere about the rules mysql uses when lock tables? - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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 details on warnings
Suppose I have this: --- mysql UPDATE blah blah... Query OK, 1 row affected (0.00 sec) Rows matched: 1 Changed: 1 Warnings: 1 --- How can I see the warning information, such as a detailed message? (BTW I *did* check some docs: - I can't find the word 'warning' in the table of contents of the "HTML, one page per chapter" - I can't find the word 'warning' in the index of New Riders' MySQL book.) -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
character set works via web but not at command line?
Hi (if needed you can find my environment setup below) I wish to load some data files at the mysql command prompt but seem to be failing due to Swedish characters being incorporated. Here is the error: ERROR 1064: You have an error in your SQL syntax near 'insert into category (categoryid,description,xsectionid) values ( "HÓstar sÓljes"' at line 3 I was suprised as my web interface manages to place and retrieve Swedish characters with no problems. Yet when I review table information at the command prompt the Swedish characters are not visable. Having read many messages and the "Languge" page in the document I still have no answer as to why I can via the web, and why I cant via the data load files? I read a message dated early 2000 that compiling character sets was not going to be need shortly as support for character sets was being developed. Have I missed something? I tried the "default-character-set" tag and I got an error that #10 was not a compiled language? #10 being swe7 in the index file... and I figure meaning Swedish. Whats happening and how do I resolve this. In summary, I need to data load Swedish character files at the command line. Thanks for any help. Regards, Ian mySQL/Java environment - os: w2000 mySQL server: v3.23.36 mySQL client: v3.23.33 IBM JVM 1.3 Web solution: JSP/Beans Web server: Jakarta Tomcat (from Apache project) Web JDBC: mm.mysql-2.0.4 and Poolman _ Get Your Private, Free E-mail from MSN Hotmail at http://www.hotmail.com. - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
GRANT permissions
I'm confused, and wondering if anyone can help me. I'm running 2 virtual servers, let's say server1.domain.com and server2.domain.com. These virtual servers sit on servers named host1.isp.com and host2.isp.com respectively (I hope I haven't lost anyone yet). I have a perl script, that lists the contents of a table in a database stored on [EMAIL PROTECTED], and when I point the DSN to host=localhost, all works fine. Now I want the app to run on both virtual servers, so I modify the script on server2.domain.com to have DSN=server1.domain.com. I have granted all permissions required to: [EMAIL PROTECTED] [EMAIL PROTECTED] user@"%.domain.com" /and/ user@"%.isp.com" Yet the script doesn't run. It doesn't say cannot connect (I do get that error if I revoke all privs), but I get: DBI-connect(database=DBNAME;host=HOSTNAME;port=143) failed: Lost connection to MySQL server during query at /script/name line 26 Can't call method "prepare" on an undefined value at /script/name line 29. I can connect to the database from server2 using: mysql DBNAME -u USERNAME -h HOSTNAME -p without problems. I guess what I'm asking, to cut a long question short, is if anyone has any idea what this error message means. Lost connection make me think it authenticates, but then disconnects, however if I connect to localhost from server1, it works fine. One last thing, even if I "grant all to user@%" it won't run properly. Hoping someone can help, and thanks in advance... Ben - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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: character set works via web but not at command line?
Ian, I may be way off the mark here, but I've found MySQL usually starts quoting the line from the place at which the error occurred, thus indicating it didn't like the "insert" part. Not being able to see the preceding lines I can only suggest it may not have an active database to write to. When importing a mysqldump, make sure you specify the db name (I'm sorry if this is too simplistic and obvious to you :-) $ mysql dbname -u username -p mysqldump.file provide password If this is not the case, and the contents of your database are not sensitive, I'm willing to take a look and try it on my machine. Hope this helps, Ben -Original Message- From: Ian Corner [mailto:[EMAIL PROTECTED]] Sent: 08 April 2001 22:32 To: [EMAIL PROTECTED] Subject: character set works via web but not at command line? Hi (if needed you can find my environment setup below) I wish to load some data files at the mysql command prompt but seem to be failing due to Swedish characters being incorporated. Here is the error: ERROR 1064: You have an error in your SQL syntax near 'insert into category (categoryid,description,xsectionid) values ( "Hstar sljes"' at line 3 I was suprised as my web interface manages to place and retrieve Swedish characters with no problems. Yet when I review table information at the command prompt the Swedish characters are not visable. Having read many messages and the "Languge" page in the document I still have no answer as to why I can via the web, and why I cant via the data load files? I read a message dated early 2000 that compiling character sets was not going to be need shortly as support for character sets was being developed. Have I missed something? I tried the "default-character-set" tag and I got an error that #10 was not a compiled language? #10 being swe7 in the index file... and I figure meaning Swedish. Whats happening and how do I resolve this. In summary, I need to data load Swedish character files at the command line. Thanks for any help. Regards, Ian mySQL/Java environment - os: w2000 mySQL server: v3.23.36 mySQL client: v3.23.33 IBM JVM 1.3 Web solution: JSP/Beans Web server: Jakarta Tomcat (from Apache project) Web JDBC: mm.mysql-2.0.4 and Poolman _ Get Your Private, Free E-mail from MSN Hotmail at http://www.hotmail.com. - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: Provider claims 'it's normal that mysql crashes', is that true?
On Wed, Apr 04, 2001 at 05:26:39PM +0200, Gunnar von Boehn wrote: As I asked them why their mysql-server die so often, I got their standard problem email-answer that claims "mysql is scaling rather badly". The truth is probably closer to "we are scaling mysql badly". A well run MySQL server doesn't crash. There's no good reason you can't have hundreds of days of uptime. Jeremy -- Jeremy D. Zawodny, [EMAIL PROTECTED] Technical Yahoo - Yahoo Finance Desk: (408) 328-7878Fax: (408) 530-5454 Cell: (408) 439-9951 - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: Multi-level JOIN query
Your absolutely right, my question was not clearly specified. So here's a concrete problem: Let's say table A has 2 fields: PRODUCT_ID (unique) and PRODUCT_NAME, table B has 3 fields: PRODUCT_ID,COMPANY_ID and LAST_PRODUCTION_DATE, and finally table C : COMPANY_ID and CONTACT_INFO Table A is the main table of the query. It contains product names with unique product ids. Table B has at most 1 entry for each product id. (There may be products which have no entries in table B). Table C contains the company's contact info if available(!). I want to show the following informations in each row: product name, last production date (if available) and producer's contact info (if available). So, as I see the query should look like this: SELECT a.PRODUCT_NAME,b.LAST_PRODUCTION_DATE,c.CONTACT_INFO FROM A AS a LEFT JOIN B AS b ON a.PRODUCT_ID=b.PRODUCT_ID LEFT JOIN C as c ON b.COMPANY_ID=c.COMPANY_ID ..but this is wrong. Thanks for any suggestions.. Christian Fischer I need some suggestions about a special query. The situation is: There are (for simplicity) 4 tables: A,B,C and D which must be joined like this: Between A and B must be an outer-join association and C and D must be connected to B also with outer-join. But this causes a 'Cross dependency found in OUTER JOIN' error. I could connect A and B with INNER JOIN but it's useless from my point of view. I think the problem could be solved with redesigning the database structure, but it's currently not possible. You need to specify the outer join. A LEFT OUTER JOIN B is not the same as A RIGHT OUTER JOIN B or B LEFT OUTER JOIN A. When you have nested outer joins, only one of the tables can be preserved. You need to specify which table is being preserved (all rows are returned). I recommend posting the table definitions and stating which columns are used in the joins. Does somebody know a good (general) solution for this? Temporary tables could help, but i deal with lot's of data and I'm afraid it would be very slow. Outer joins + lot's of data = slow queries, even without temp tables. Bob Hall - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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: Hierarchical lists
--- [EMAIL PROTECTED] wrote: Hello, I'm new to MySQL and have ran into a problem in designing my database. I have a table of items, A, and each item should have any number of other records from another table, B, associated with it. I also need to have any number of records from table C associated with table B. They need to be associated in such a way that I can quickly find out what is associated with a record in table A, as well as what is associated with a record in table B. In other words, how do I store an array of pointers? What's the best way to do this? I couldn't find anything relevant in the docs. I'm not sure that I've understood correctly, but perhaps : create table A ( aid int unsigned not null auto_increment, value char(1000), key idxaid (aid) ); create table B ( bid int unsigned not null auto_increment, aid int unsigned not null default -1, value char(1000), key idxbid (bid), key idxaid (aid) ); create table C ( cid int unsigned not null auto_increment, bid int unsigned not null default -1, value char(1000), key idxcid (cid), key idxbid (bid) ); That way, reading data from Table B tells you about the parent, likewise for C. Thanks for you reply..but I want to be able to find the list of the children, not parents. For example: In table A: foo quux (separate from B's quux) / \ / In table B: baz quux bar /|\ \ In table C: w x y z Each table's rows (except for table C) should be allowed to have any number of children, and I should be able to get a list of all the children of a parent. In C, I would do it like this: typedef struct _A { int value; B* children[100]; } A; typedef struct _B { int value; C* children[100]; } typedef struct _C { int value; } How would I do this in MySQL? __ Do You Yahoo!? Get email at your own domain with Yahoo! Mail. http://personal.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
mysql/mysql++ fail on sun-solaris-sparc with segfault
Description: Programs, compiled with mysql++ on that machine, abort with a segfault at an attempt to connect to the mysql server, while programs using Mysql C API (for instance, mysql's own benchmark suite) and the same programs executed on a local Linux machine run OK. I used mysql++-1.7.8 and recent stable 3.26.36 mysql (source). According to debugger's backtrace, it stops with signal 11 (and message: 'Segmentation fault (core dumped)') in mysql connection / memory allocation code: (gdb) bt #0 0xef545c18 in _malloc_unlocked () #1 0xef545b38 in malloc () #2 0xef78acec in my_malloc () #3 0xef7899c0 in vio_new () #4 0xef786a28 in mysql_real_connect () #5 0xef5c6568 in MysqlConnection::real_connect () #6 0xef5c5e74 in MysqlConnection::MysqlConnection () #7 0x2e398 in main () at test1.cc:9 It is not only my programs that fail like that, all the mysql++ examples abort exactly this way. Interestingly enough, one of the programs I use behave a bit differently. It starts with "Bad free() ignored" message and stops with 'Abort (core dumped)' message. Debugger produces the following backtrace (formatted manually for readability): (gdb) bt #0 0xef50828c in _libc_kill () #1 0xef4ba608 in abort () #2 0xef578bd0 in Letext () #3 0xef578c00 in __terminate () #4 0xef579708 in throw_helper (eh=0xef59be4c, pc=0xef5c7bff, my_udata=0xefffec70, offset_p=0xefffec6c) #5 0xef579910 in __throw () #6 0xef5c7c00 in MysqlConnection::execute () #7 0x111e38 in basic_stringchar, string_char_traitschar, __default_alloc_templatefalse, 0 ::unique () #8 0x10f51c in basic_stringchar, string_char_traitschar, __default_alloc_templatefalse, 0 ::append () #9 0x10af58 in MysqlQuery::~MysqlQuery () #10 0x4193c in _init () #11 0x3b6b4 in _init () #12 0x3cb04 in _init () #13 0x3dfb8 in _init () The more detailed report and listing of debugger outputs and some code is available online for your reference at: http://netec.mcc.ac.uk/HoPEc/g4/mysql-problem-details.txt I've tried several versions of mysql deamon (mentioned in the details doc), and to recompile mysql and mysql++ several times with two versions of gcc (2.95.1 and 2.95.2) and with different options (according to Mysql Documentation/installation/system specific/Solaris recommendations), with little success and minimal changes of soft behaviour. I've also tried --safe-mode and --loging but that didn't make situation clear, but please look into the details file mentioned above: may be for you it will make something clear. How-To-Repeat: should be obvious from the above description Fix: no idea, sorry Submitter-Id: submitter ID Originator:ivan kurmanov, [EMAIL PROTECTED] Organization: RePEc, http://repec.org MySQL support: none Synopsis: synopsis of the problem (one line) Severity: critical Priority: high Category: mysql mysql++ Class: sw-bug Release: mysql-3.23.36 (Source distribution) Environment: Library used: Mysql++ 1.7.8 System: SunOS irwell 5.6 Generic_105181-20 sun4u sparc SUNW,Ultra-Enterprise Architecture: sun4 Some paths: /home/adnetec/usr/local/bin/perl /home/adnetec/bin/make /usr/local/bin/gmake /home/adnetec/usr/local/bin/gcc /opt/SUNWspro/bin/cc GCC: Reading specs from /home/adnetec/usr/local/lib/gcc-lib/sparc-sun-solaris2.6/2.95.2/specs gcc version 2.95.2 19991024 (release) Compilation info: CC='gcc' CFLAGS='-O6 ' CXX='c++' CXXFLAGS='-O6 -fomit-frame-pointer -felide-constructors -fno-exceptions -fno-rtti ' LDFLAGS='' LIBC: -rw-r--r-- 1 bin bin 1608144 Feb 7 2000 /lib/libc.a lrwxrwxrwx 1 root root 11 Jun 21 1999 /lib/libc.so - ./libc.so.1 -rwxr-xr-x 1 bin bin 1014272 Feb 7 2000 /lib/libc.so.1 -rw-r--r-- 1 bin bin 1608144 Feb 7 2000 /usr/lib/libc.a lrwxrwxrwx 1 root root 11 Jun 21 1999 /usr/lib/libc.so - ./libc.so.1 -rwxr-xr-x 1 bin bin 1014272 Feb 7 2000 /usr/lib/libc.so.1 Configure command: ./configure --prefix=/home/adnetec/Ivan --with-unix-socket-path=/home/adnetec/Ivan/tmp/mysql.socket --with-low-memory --enable-assembler Perl: This is perl, version 5.005_02 built for sun4-solaris NB: I didn't send this report with mysql-bug script, I just used its output for this message as draft, because I couldn't send mail from that machine, it is remote for me. Sorry, if that sets any limits to usefulnes of this report. - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble
RE: uninstalling MySQL
that worked, thx I also installed PHP4, should I uninstall that? I installed it as a tar. and if so how do I do it? Dave -Original Message- From: Steve Ruby [mailto:[EMAIL PROTECTED]] Sent: Sunday, April 08, 2001 7:46 PM To: David Loszewski Subject: Re: uninstalling MySQL If rpm -qa shows MySQL rpms then you use rpm -e package name then you remove the installed directories, I wouldn't do an rm -fr /usr/local/var like the person before said, he probably mean rm -fr /usr/local/var/mysql which would be safe David Loszewski wrote: so what do I do after that? Dave -Original Message- From: Steve Ruby [mailto:[EMAIL PROTECTED]] Sent: Sunday, April 08, 2001 2:32 PM To: Roel Vanhout Cc: David Loszewski; [EMAIL PROTECTED] Subject: Re: uninstalling MySQL Probably should change that first line to rpm -qa | grep -i mysql Roel Vanhout wrote: rpm -qa | grep mysql if nothing found, rm -rf /usr/local/var rm -rf `find /usr/local/bin/ | grep mysql` rm -rf /etc/my.cnf This should catch about everything. cheers, roel On Sun, Apr 08, 2001 at 12:24:08AM -0400, David Loszewski wrote: how do I uninstall MySQL 3.22 after installing it? worst part is that I installed it so long ago that I can't remember if I did it by .rpm or .tar help please, Dave - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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 - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
wildcard character in sql grant statement
Hello, Is there a new wildcard character in 3.23? I am trying to use the grant statement GRANT ALL ON DATA.* TO user1@% IDENTIFIED BY "password" It doesnt seem to like the % as it returns an sql error Thanks for your time, Scott - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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: Hierarchical lists
On Sun, 8 Apr 2001, Realbad Atgames wrote: --- [EMAIL PROTECTED] wrote: Hello, I'm new to MySQL and have ran into a problem in designing my database. I have a table of items, A, and each item should have any number of other records from another table, B, associated with it. I also need to have any number of records from table C associated with table B. They need to be associated in such a way that I can quickly find out what is associated with a record in table A, as well as what is associated with a record in table B. In other words, how do I store an array of pointers? What's the best way to do this? I couldn't find anything relevant in the docs. I'm not sure that I've understood correctly, but perhaps : create table A ( aid int unsigned not null auto_increment, value char(1000), key idxaid (aid) ); create table B ( bid int unsigned not null auto_increment, aid int unsigned not null default -1, value char(1000), key idxbid (bid), key idxaid (aid) ); create table C ( cid int unsigned not null auto_increment, bid int unsigned not null default -1, value char(1000), key idxcid (cid), key idxbid (bid) ); That way, reading data from Table B tells you about the parent, likewise for C. Thanks for you reply..but I want to be able to find the list of the children, not parents. For example: In table A: foo quux (separate from B's quux) / \ / In table B: baz quux bar /|\ \ In table C: w x y z Each table's rows (except for table C) should be allowed to have any number of children, and I should be able to get a list of all the children of a parent. In C, I would do it like this: typedef struct _A { int value; B* children[100]; } A; typedef struct _B { int value; C* children[100]; } typedef struct _C { int value; } How would I do this in MySQL? The question is not a Mysql issue but rather simple sense and logic. Make your tables as: A: aname char() aid int auto_increment B: bname char() bid int auto_increment aid int which you'll set depending on which record of A this specific record of B is a child of C: cname char() bid int which you'll set depending on which record of B this specific record of C is a child of To find out all the B_children of record 'A123' from table A you'd do: select bname from A,B where A.aid=B.aid AND A.aname="A123"; Same for finding the C_children of a record from table B. Hell! you can even get the grandchildren in table C that belong to a record 'A123' from table A: select cname from A,B,C where A.aid=B.aid AND B.bid=C.bid AND A.aname="A123"; regards, thalis - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Bad Select Syntax workaround?
I have a (dumb!) program that performs SELECT statements with a quote around the table and the fieldname; see the portion from the trace log below: Cardfivefffe35e1:fffed875 EXIT SQLExecDirect with return code -1 (SQL_ERROR) HSTMT 0x00cf17ac UCHAR * 0x00ae62ac [ 363] "SELECT `telstrasaturn`.`AutonumberedKey`,`telstrasaturn`.`ID`,`telstrasaturn`.`Stat us`,`telstrasaturn`.`ExtendedStatus`,`telstrasaturn`.`FIRSTNAME`,`telstrasat urn`.`SURNAME`,`telstrasaturn`.`DIVISION`,`telstrasaturn`.`LOCATION`,`telstr asaturn`.`LOC_NO`,`telstrasaturn`.`PICTURE`,`telstrasaturn`.`EXPDATE`,`telst rasaturn`.`PRNREC` FROM "telstrasaturn" FOR UPDATE " SDWORD 363 DIAG [42000] [TCX][MyODBC]You have an error in your SQL syntax near '"telstrasaturn" ' at line 1 (1064) -- What workaround do I have for this? The 'FOR UPDATE' clause also seems to be at fault; if I query a MySQL table "SELECT * FROM TABLE FOR UPDATE' i get an sql syntax error "near FOR UPDATE" -- does this imply MySQL does not yet have support for this? Is there anyway for MyODBC, or MySQL server to rid SELECT statements it parses of 1) the uncessary quotes (basically replace '.' to . ) 2) the FOR UPDATE clause The UPDATE locking is not a necessity in the application; Win9x Card printing software which uses ONLY odbc as a connection method. Thanks, Siggy
RE: REXEXP in select only works with short expressions on Alpha
Hi, Just a guess, but I expect that the first response will be to use gcc 2.95.2 or later Quentin -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]] Sent: Monday, 9 April 2001 1:30 p.m. To: [EMAIL PROTECTED] Subject: REXEXP in select only works with short expressions on Alpha Description: When transfering a database application to use an Alpha Linux server rather than intel Linux previously working regular expressions fail to work. It appears to be due to a length limit. This effects both binary downloads and home compiled distributions. How-To-Repeat: Simple test case (with results) mysql create table test (xxx char(128)); Query OK, 0 rows affected (0.00 sec) mysql insert into test (xxx) values('this is a test of some long text to see what happens'); Query OK, 1 row affected (0.00 sec) mysql select * from test where xxx regexp('is a test of some long text to'); +--+ | xxx | +--+ | this is a test of some long text to see what happens | +--+ 1 row in set (0.00 sec) mysql select * from test where xxx regexp('is a test of some long text to '); Empty set (0.00 sec) mysql select * from test where xxx regexp('is a test of some long text to s'); Empty set (0.00 sec) mysql select * from test where xxx regexp('is a test of some long text to se'); Empty set (0.00 sec) mysql select * from test where xxx regexp('test of some long text to se'); +--+ | xxx | +--+ | this is a test of some long text to see what happens | +--+ 1 row in set (0.00 sec) Fix: Unknown - I have revererted to the working Intel system - hopefully this a fix will be found soon since the original move was due to capacity problems on the intel hardware ! Submitter-Id: submitter ID Originator:[EMAIL PROTECTED] Organization: MySQL support: [none] Synopsis: on linux Alpha regexp does not work with long expressions Severity: critical Priority: high Category: mysql Class: sw-bug Release: mysql-3.23.36 (Source distribution) Environment: System: Linux rossem.octopus-technologies.co.uk 2.2.14-6.0 #1 Tue Mar 28 16:56:56 EST 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/egcs-2.91.66/specs gcc version egcs-2.91.66 19990314/Linux (egcs-1.1.2 release) Compilation info: CC='gcc' CFLAGS='' CXX='c++' CXXFLAGS='' LDFLAGS='' LIBC: lrwxrwxrwx1 root root 13 Apr 7 17:16 /lib/libc.so.6.1 - libc-2.1.3.so -rwxr-xr-x1 root root 8070122 Mar 27 2000 /lib/libc-2.1.3.so -rw-r--r--1 root root 18837112 Mar 27 2000 /usr/lib/libc.a -rw-r--r--1 root root 180 Mar 27 2000 /usr/lib/libc.so Configure command: ./configure Perl: This is perl, version 5.005_03 built for alpha-linux - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php The information contained in this email is privileged and confidential and intended for the addressee only. If you are not the intended recipient, you are asked to respect that confidentiality and not disclose, copy or make use of its contents. If received in error you are asked to destroy this email and contact the sender immediately. Your assistance is appreciated. - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
alter table tbl_name rename [to] new_tbl_name - including to doesn't work.
Description: When one uses the "alter table tbl_name rename [to] new_tbl_name" command, it works when "to" is not included in the command, but says there is an error in the SQL syntax when "to" is included. My understanding is that "to" is optional and it should work both ways. How-To-Repeat: mysql create table foo (id int); Query OK, 0 rows affected (0.02 sec) mysql alter table foo rename to bar; ERROR 1064: You have an error in your SQL syntax near 'to bar' at line 1 mysql alter table foo rename bar; Query OK, 0 rows affected (0.01 sec) Fix: Don't use "to." Submitter-Id: submitter ID Originator:Geordy Kitchen Organization: MySQL support: [none | licence | email support | extended email support ] Synopsis: Severity: Priority: Category: mysql Class: Release: mysql-3.22.32 (Source distribution) Environment: System: Linux okcomputer 2.2.17 #1 Sun Jun 25 09:24:41 EST 2000 i686 unknown Architecture: i686 Some paths: /usr/bin/perl /usr/bin/make /usr/bin/gcc /usr/bin/cc GCC: Reading specs from /usr/lib/gcc-lib/i386-linux/2.95.2/specs gcc version 2.95.2 2220 (Debian GNU/Linux) Compilation info: CC='gcc' CFLAGS='-O2 -fomit-frame-pointer' CXX='g++' CXXFLAGS='-O2 -fomit-frame-pointer -felide-constructors -fno-exceptions -fno-rtti' LDFLAGS='' Configure command: ./configure --enable-shared --without-readline --enable-assembler --with-mysqld-user=mysql --with-unix-socket-path=/var/run/mysqld/mysqld.sock --prefix=/usr --exec-prefix=/usr --libexecdir=/usr/sbin --sysconfdir=/etc/mysql --datadir=/usr/share --localstatedir=/var/lib/mysql --infodir=/usr/share/info --includedir=/usr/include --mandir=/usr/share/man Perl: This is perl, version 5.005_03 built for i386-linux - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
connecting to a remote machine
Hello, Does anyone know off hand what the command is (in mySQL interactive mode ) to connect to a remote mySQL server? Thanks for your time, Scott - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Converting FileMaker 5 files to mySQL
I was wondering if there is a tool or special way to merge all of the contents of Filemaker Pro 5 files so they can be used in mySQL. Here is my scenario: Currently I have a fileserver for my website that uses FileMaker 5 and I am looking to merge those attributes and settings so they can be used in mySQL instead of FileMaker. Do I have to export my FileMaker 5 file as a .cvs or .txt file? Do I have to do it another way? If anybody has any advive, it would help me greatly. Thanks! :) __ FREE Personalized Email at Mail.com Sign up at http://www.mail.com/?sr=signup - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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: connecting to a remote machine
Mysql has many command line options. Try mysql --help for a list, and you will see that the -h option is used to specify the host. Regards, Gary "SuperID" Huntress === FreeSQL.org offering free database hosting to developers Visit http://www.freesql.org - Original Message - From: "Scott Meesseman" [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: Sunday, April 08, 2001 10:32 PM Subject: connecting to a remote machine Hello, Does anyone know off hand what the command is (in mySQL interactive mode ) to connect to a remote mySQL server? Thanks for your time, Scott - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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
Disappearing \
First, things, first - I am a newbie to MySQL but I have it up and running quite well. The only thing I haven't been able to figure out is why I'm losing "\" (back slashes) in my stored data. I have a application I'm considering MySQL for and one table must have a column containing a UNC path. When I insert the value of "\\server\folder", MySQL turns it into "\serverfolder" - very strange. I've set this column up as a varchar. - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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: Disappearing \
On Sun, Apr 08, 2001 at 10:34:17PM -0600, Jack A. Tinsley Jr. wrote: First, things, first - I am a newbie to MySQL but I have it up and running quite well. The only thing I haven't been able to figure out is why I'm losing "\" (back slashes) in my stored data. I have a application I'm considering MySQL for and one table must have a column containing a UNC path. When I insert the value of "\\server\folder", MySQL turns it into "\serverfolder" - very strange. I've set this column up as a varchar. The "\" character is an escape character, often used to include otherwise "special" characters in your data. To include a literal "\" in your data, you need to actually double it up "\\". Jeremy -- Jeremy D. Zawodny, [EMAIL PROTECTED] Technical Yahoo - Yahoo Finance Desk: (408) 328-7878Fax: (408) 530-5454 Cell: (408) 439-9951 - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: Disappearing \
You need to escape it with another "\". Look up the manual about escaping special chars. - Original Message - From: "Jack A. Tinsley Jr." [EMAIL PROTECTED] To: "[EMAIL PROTECTED]" [EMAIL PROTECTED] Sent: Monday, April 09, 2001 12:34 Subject: Disappearing "\" First, things, first - I am a newbie to MySQL but I have it up and running quite well. The only thing I haven't been able to figure out is why I'm losing "\" (back slashes) in my stored data. I have a application I'm considering MySQL for and one table must have a column containing a UNC path. When I insert the value of "\\server\folder", MySQL turns it into "\serverfolder" - very strange. I've set this column up as a varchar. - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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
Cannot Connect to remote host for replication
hi there, i have been trying to implement replication, however the error that i get is ERROR 2003: Can't connect to MySQL server on '192.168.1.2' (111) i try to do this at the linux prompt at the slave with mysql-h hostname and the same error is displayed. what could be wrong ?? thanks in advance bye Mathew - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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: Poddible SHOW DATABASE || TABLE bug in 3.23.33
Yeah, yeah alright then... database,sql,query Happy? Now for my message... I downgraded to 3.22.xx and the same thing happened. It seems like it's something else. Slackware Current. Some paths: /usr/bin/perl /usr/bin/make /usr/bin/gmake /usr/bin/gcc /usr/bin/cc GCC: Reading specs from /usr/lib/gcc-lib/i386-slackware-linux/egcs-2.91.66/specs gcc version egcs-2.91.66 19990314/Linux (egcs-1.1.2 release) Compilation info: CC='gcc' CFLAGS='' CXX='c++' CXXFLAGS='' LDFLAGS='' LIBC: lrwxrwxrwx 1 root root 13 Jan 21 16:02 /lib/libc.so.6 - libc-2.2.1.so -rwxr-xr-x 1 root root 1008844 Sep 10 1999 /lib/libc-2.1.2.so -rwxr-xr-x 1 root root 4170792 Mar 20 2000 /lib/libc-2.1.3.so -rwxr-xr-x 1 root root 1128904 Jan 15 04:29 /lib/libc-2.2.1.so -rw-r--r-- 1 root root 20266642 Mar 20 2000 /usr/lib/libc.a -rw-r--r-- 1 root root 178 Mar 20 2000 /usr/lib/libc.so Fran :):):) - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Slave to Master Connection
Hi there, the error that i specifically get when the slave tries to connect to the master is 010409 10:44:58 Slave thread: error connecting to master:Can't connect to MySQL server on '192.168.1.2' (111)(107), retry in 60 sec even if i try to run mysql -h master the same error happens. what could be wrong ?? thanks bye Mathew - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: Cannot Connect to remote host for replication
Where is your server located? On the same LAN? You sure the mysql server is running? - Original Message - From: "MCA Department PESIT" [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: Monday, April 09, 2001 12:48 Subject: Cannot Connect to remote host for replication hi there, i have been trying to implement replication, however the error that i get is ERROR 2003: Can't connect to MySQL server on '192.168.1.2' (111) i try to do this at the linux prompt at the slave with mysql-h hostname and the same error is displayed. what could be wrong ?? thanks in advance bye Mathew - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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: Slave to Master Connection
On Mon, Apr 09, 2001 at 10:37:36AM +0530, MCA Department PESIT wrote: the error that i specifically get when the slave tries to connect to the master is 010409 10:44:58 Slave thread: error connecting to master:Can't connect to MySQL server on '192.168.1.2' (111)(107), retry in 60 sec even if i try to run mysql -h master the same error happens. what could be wrong ?? Are the username/password correct? Is there anything in the error log on the master? Jeremy -- Jeremy D. Zawodny, [EMAIL PROTECTED] Technical Yahoo - Yahoo Finance Desk: (408) 328-7878Fax: (408) 530-5454 Cell: (408) 439-9951 - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Slave to host connection
Hi there, the master is running on 192.168.1.2 and the slave on 192.168.1.5 , yes, the master is running. the user name and password are correct. actually i dont think it gets to the state of actually verifying the user name and password. even if i do just a mysql -h 192.168.1.2 it gives me an immediate error at 192.168.1.5 [root@linux] /var/lib/mysql# mysql -h 192.168.1.2 -P 3306 -u slave -p Enter password: ERROR 2003: Can't connect to MySQL server on '192.168.1.2' (111) there are no errors at the server side and the error log is clean Mathew - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php