Problem with mysql
Hello, I have installed the mysql-max version 3.23.38 and I now have a problem with mysql. Whenever I try to access mysql I get an error when loading mysql.so that mysql_init is an undefined symbol. Where could the problem be? Andrew Do You Yahoo!? Get your free @yahoo.co.uk address at http://mail.yahoo.co.uk or your free @yahoo.ie address at http://mail.yahoo.ie - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
transaction
Does MySQL for Windows support transaction ? If YES, all version ? Thanks a lot. -- K Free E-mail http://www.k.ro/ by KappaNet http://www.kappa.ro/ - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
RE: transaction
Hi No not all versions. You have to have either BDB, InnDB or GEMINI to use transactions. The new mysqld-max has either BDB or InnoDB and some have Both. Regards ~ Warren van der Merwe Software Director PRT Trading (Pty) Ltd t/a RedTie Durban, South Africa Cell (+27-83) 262-9163 Office (+27-31) 767-0249 -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] ]On Behalf Of Grigore M Gabriel Sent: 18 May 2001 10:19 To: [EMAIL PROTECTED] Subject: transaction Does MySQL for Windows support transaction ? If YES, all version ? Thanks a lot. -- K Free E-mail http://www.k.ro/ by KappaNet http://www.kappa.ro/ - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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: Problem with mysql
Andrew Wafula wrote: Hello, I have installed the mysql-max version 3.23.38 and I now have a problem with mysql. Whenever I try to access mysql I get an error when loading mysql.so that mysql_init is an undefined symbol. Where could the problem be? Andrew Andrew: Probably you have incompatible libraries. You probably downloaded the rpm and your system is out of date. You may need to compile from source, but without doing the following: /usr/local/bin/mysqlbug And, following the prompts, we couldn't possibly know where the problem could be. Give it a shot. You might be surprized that you'll receive some useful info to help you fix the problem. Best Regards, Van -- = Linux rocks!!! http://www.dedserius.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
Master election feature thing in Mysql 4.0 ?
Hi, I heard something about a master election feature or something that will decide if a server would act as master or slave in a mysql replication cluster.. But that was for version 4.0 ? I'm currently trying to set up a solution where all mysql machines starts up with no slave or master running and then a monitoring script is choosing the server that should be master.. and starts the slave on the other ones. And to let the clients always connect to the current master I've like a masterdb hostname in a internal dns zone which always points to the correct master.. And when a master goes offline, the next slave in the list (which is up-to-date with the binlog from the master that was stopped) will be chosen as master.. I want to hear from you that have solutions like the one above running.. and tips and if there is some things that may not work etc.. Regards, Johan Andersson Consultant - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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: how do i start mysql gui interface in sun solaris 2.7 sparc ?
Fengxian Guo writes: how do i start mysql gui interface in sun solaris 2.7 sparc ? thanks very much Hi! There is a README that comes with a source and binary distros. If you do not have one, please let me know. If you find problems, then again let me know. 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
Advice about 'many aborted clients'
Hello, we're using mysql 3.23.33 on a separate Linux server, but about 50% of all connections go wrong and get an error like this: Aborted connection 84620 to db: 'xxx' user: 'yyy' host: `aaa.bbb.cc.ddd.' (Got timeout reading communication packets). There are 3 frontends (Sun) webservers. We're making about 15 connections per second. Has anybody any tips about the configuration and give advice about how to prevent those errors. Sander. my.cnf parameters: [client] port= 3306 socket = /tmp/mysql.sock # The MySQL server [mysqld] port= 3306 socket = /tmp/mysql.sock skip-locking set-variable= key_buffer=256M set-variable= max_connections=255 set-variable= max_allowed_packet=1M set-variable= table_cache=256 set-variable= sort_buffer=1M set-variable= record_buffer=1M set-variable= myisam_sort_buffer_size=64M set-variable= thread_cache=16 set-variable= thread_concurrency=8 log-bin server-id = 1 set-variable= interactive_timeout=60 set-variable= wait_timeout=60 set-variable= connect_timeout=10 [mysqldump] quick set-variable= max_allowed_packet=16M [mysql] no-auto-rehash [isamchk] set-variable= key_buffer=128M set-variable= sort_buffer=128M set-variable= read_buffer=2M set-variable= write_buffer=2M [myisamchk] set-variable= key_buffer=128M set-variable= sort_buffer=128M set-variable= read_buffer=2M set-variable= write_buffer=2M [mysqlhotcopy] interactive-timeout
Re: Problems again ...
-p is for when you have a password set, but you don't have one set yet. password is used to set or change the password but it needs a parameter following it, the new password. You did install mysql from the mysql web site, not RH's mysql, didn't you? - Original Message - From: Radu Adam [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: Friday, May 18, 2001 19:09 Subject: Problems again ... I posted a question yesterday ... I installed RedHat Linux 7.1 with MySQL on it but it doesn't let me do anything. This is what happens: [root@lambda /root]# mysqladmin -u root password mysqladmin: connect to server at 'localhost' failed error: 'Access denied for user: 'root@localhost' (Using password: NO)' and if I try with a password (i don't know what password !!!) it does this: [root@lambda /root]# mysqladmin -u root -p password 'somepass' Enter password: mysqladmin: connect to server at 'localhost' failed error: 'Access denied for user: 'root@localhost' (Using password: YES)' So ... how can I reset the root password? --- Mailuri? Gramada! La www.emoka.ro iti faci moka un cont de mail fara limita de trafic! - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: mysql start failed.
has it already started? ps -ef | grep mysql - Original Message - From: DEVOS BASTIEN [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: Friday, May 18, 2001 19:11 Subject: mysql start failed. Here's a problem I have when trying starting mysql. Config : RH7.0, MySQL 3.23.32, kernel2.4.3. I read that there's a problem with RH7.0 and that a ´chown -R mysql /var/lib/mysql´ should resolve that, but it doesn't change anything. always this message : snip 010518 13:00:22 mysqld started 010518 13:00:22 /usr/libexec/mysqld: Can't find file: './mysql/host.frm' (errno: 13) 010518 13:00:22 mysqld ended /snip even when I boot, it says : blahblah [OK] blahblah [OK] Starting MySQL [OK] mysqld ended blahblah [OK] blahblah [OK] blahblah [OK] Any idea ? - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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: phpmyadmin + mysql +Unknown database 'test'
Hi, Well, I also had the same problem and finally traced the bug down to a file called db_readdump.php3 in phpmyadmin directory. If you'r still having the problem, may be this is helpful to you too. edit db_readdump.php3 and add in the beginning of the file $db = trim($db); Then at the bottom of the code (somewhere around line no.45) you will find.. if(!empty($sql_file) $sql_file != none ereg(^php[0-9A-Za-z_.-]+$, basename($sql_file))) { $sql_query = addslashes(fread(fopen($sql_file, r), filesize($sql_file))); } Cut this part of code and paste it just below, the following code... $pieces = split_sql($sql_query); if (count($pieces) == 1 !empty($pieces[0])) { $sql_query = trim($pieces[0]); include (sql.php); exit; } thats it, Hope this helps, Regards, Sivaprasad. R.L http://netlogger.net __ Do You Yahoo!? Yahoo! Auctions - buy the things you want at great prices http://auctions.yahoo.com/ - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
I am newbie and I can't resist anymore !!!!
so ... this is another story: mysqladmin: connect to server at 'localhost' failed error: 'Can't connect to local MySQL server through socket '/var/lib/mysql/mysql.sock' (111)' Check that mysqld is running and that the socket: '/var/lib/mysql/mysql.sock' exists! Indeed there is no mysql.sock at that location .. but why? --- Mailuri? Gramada! La www.emoka.ro iti faci moka un cont de mail fara limita de trafic! - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Transactions
How can I use transactions in mySQL ver. 3.23.38-nt? Tel.: 0422-678874 mailto:[EMAIL PROTECTED] Carlo Scalet - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
problem regarding ASP+MySQL in NT with IIS (web server)
respected sir, i have a problem regarding connectivity between ASP and mysql. will it possible to connect asp with mysql if yes then how we can do it will it need any driver if yes then from where we get that driver .. will i get some tutoril in this matter... thanking you ashutosh - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
RE: mysql start failed.
Nothing is running. I tried removing the socket mysql.sock and trying reconnect, but it creates a new socket mysql.sock and mysql is not running. I know this kind of problem is known, but I never found a solution. -Original Message- From: Rolf Hopkins [SMTP:[EMAIL PROTECTED]] Sent: Friday, May 18, 2001 1:29 PM To: DEVOS BASTIEN; [EMAIL PROTECTED] Subject: Re: mysql start failed. has it already started? ps -ef | grep mysql - Original Message - From: DEVOS BASTIEN [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: Friday, May 18, 2001 19:11 Subject: mysql start failed. Here's a problem I have when trying starting mysql. Config : RH7.0, MySQL 3.23.32, kernel2.4.3. I read that there's a problem with RH7.0 and that a ´chown -R mysql /var/lib/mysql´ should resolve that, but it doesn't change anything. always this message : snip 010518 13:00:22 mysqld started 010518 13:00:22 /usr/libexec/mysqld: Can't find file: './mysql/host.frm' (errno: 13) 010518 13:00:22 mysqld ended /snip even when I boot, it says : blahblah [OK] blahblah [OK] Starting MySQL [OK] mysqld ended blahblah [OK] blahblah [OK] blahblah [OK] Any idea ? - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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
Instalation problems!!!!
Hi, I want to install mysql for unix machine (digital/compaq) alphav56-dec-osf4.0d. Is there any version of mySQL for this version of digital unix?!!! I tried to ftp a version called mysql-3-23-25-beta-dec-os4_0f-alphaev6_tar and I have a problem with instalation manual: I can't find the Makefile with gunzip the mysql-3-23-25-beta-dec-os4_0f-alphaev6_tar? Please let me know if you have any questions, comments,... Thanks in Advance, Fariba - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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: Instalation problems!!!!
Fariba Noorbakhsh writes: Hi, I want to install mysql for unix machine (digital/compaq) alphav56-dec-osf4.0d. Is there any version of mySQL for this version of digital unix?!!! I tried to ftp a version called mysql-3-23-25-beta-dec-os4_0f-alphaev6_tar and I have a problem with instalation manual: I can't find the Makefile with gunzip the mysql-3-23-25-beta-dec-os4_0f-alphaev6_tar? Please let me know if you have any questions, comments,... Thanks in Advance, Fariba Hi! Check out with file program, may be tarball is not gzipped. 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
CPU usage running mysql
Hi, We run mysql V3.22.32 (solaris 2.5.1 version ) on a Solaris 2.6 box. The top command shows the mysqld running at 98.3% of cpu time when the system is idling. On a Solaris 7 box runnning Solaris 7 running mysql-3.22.32 (solaris 7 version) but also idle, the top command shows 0.5% for the mysqld. Any ideas which is correct, how I can rectify the situation and could this explain why the 2.6 box has started to run slow? Stopping and restarting the mysqld has no effect on the cpu time used Thanks, David - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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: FW: ERROR 1136: Column count doesn't match value count at row 1
Amy Wan wrote: Hi all, I have a regular table like this CREATE TABLE MediaChannel ( MediaChannelID INT NOT NULL, Medium VARCHAR(5) NOT NULL, CallLettersVARCHAR(12) NOT NULL, StationNickNameVARCHAR(40), Slogan VARCHAR(40), ButtonName VARCHAR(10), Format VARCHAR(10), CityID INT NOT NULL, ChannelVARCHAR(15), URLVARCHAR(100), StreamingURL VARCHAR(100), WebLogoVARCHAR(60), WapLogoVARCHAR(60), SpecialPromotion VARCHAR(110), SpecialPromotionURLVARCHAR(150), Audience INT, OwnerCompanyID INT, Status CHAR(1) NOT NULL, PRIMARY KEY (MediaChannelID) ) TYPE = InnoDB ; Then I tried to insert the following sql query into the above table using mysql INSERT INTO MediaChannel VALUES (1, 'RADIO','WAPE','WAPE FM','CHR',14,'95.1 FM','http://www.wape951.com','http://www.wape951.com','fl_jacksonville _wape.jpg','','','',2,1,'A'); I got the follow error ERROR 1136: Column count doesn't match value count at row 1 WHY IS THAT? Amy Because your column count doesn't match value count. You have 18 columns, and 16 values. -- Gerald L. Clark [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: Is it possible? ODBC doubt.
In message 001301c0ddf3$49e1cc60$12ffa8c0@notodo, Martin Cabrera Diaubalick [EMAIL PROTECTED] writes Hi there! I installed MyODBC and tried to import a Database from my Web Hosting account but didn't let me. Was it me that didn't know how to do it or is it possible that access is only allowed through local connection? TIA Regards I too would be interested in this having tried and failed. CHRIS -- Chris Wilkinson - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
my sql admin site
Can some one let me know about the URL to go through the mysql Admin issues. Regards, Ravi Do You Yahoo!? Get your free @yahoo.co.uk address at http://mail.yahoo.co.uk or your free @yahoo.ie address at http://mail.yahoo.ie - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
DBI problem
Hi, I tried to connect to the database, when I compiled it, it replied with (offline mode: enter name=value pairs on standard input) - What is this meant? Below is my code: #!/usr/bin/perl -w use strict; use CGI; use DBI; my $dbh; my $sth; my @row; my $form = new CGI; print $form-header; print htmlbody; print ready to connectp; my $database = loc_data; my $username = mysql; my $password = mysql; #open connection to Access database $dbh = DBI-connect(DBI:mysql:$database, $username, $password) or die Couldn't connect to database: . $dbh-errstr; # print connectedp; #construct SQL statement ##$sqlstatement = SELECT * from tld_data; # print selectedp; #prepare and execute SQL statement $sth = $dbh-prepare(SELECT * from tld_data) or die Can't prepare SQL statement: ; # print preparedp; $sth-execute || print Could not execute SQL statement, maybe invalid?; #print pready to output; #output database results while (@row=$sth-fetchrow_array) { print @row\nbr } #vprint hello; #close datbase $dbh-disconnect(); $sth - finish; print $form-end_html; Thanks in advance, Connie _ Get your FREE download of MSN Explorer at http://explorer.msn.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 mysql-unsubscribe-##L=##[EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
RE: DBI problem
try connect with a minimal script, like this (I didn't try it) : snip #!/usr/bin/perl -w use strict; use CGI; use DBI; my $dbh; print something before connect; $dbh = DBI-connect(DBI:mysql:$database, $username, $password) or die Couldn't connect to database: . $dbh-errstr; print something after; $dbh-disconnect(); /snip If it gives you back the prompt, connection should work, or if not, it should (I hope) give you an error, and with some chance, you should something significant in this error ! ;-) -Original Message- From: c cw_1 [SMTP:[EMAIL PROTECTED]] Sent: Friday, May 18, 2001 3:28 PM To: [EMAIL PROTECTED] Subject: DBI problem Hi, I tried to connect to the database, when I compiled it, it replied with (offline mode: enter name=value pairs on standard input) - What is this meant? Below is my code: #!/usr/bin/perl -w use strict; use CGI; use DBI; my $dbh; my $sth; my @row; my $form = new CGI; print $form-header; print htmlbody; print ready to connectp; my $database = loc_data; my $username = mysql; my $password = mysql; #open connection to Access database $dbh = DBI-connect(DBI:mysql:$database, $username, $password) or die Couldn't connect to database: . $dbh-errstr; # print connectedp; #construct SQL statement ##$sqlstatement = SELECT * from tld_data; # print selectedp; #prepare and execute SQL statement $sth = $dbh-prepare(SELECT * from tld_data) or die Can't prepare SQL statement: ; # print preparedp; $sth-execute || print Could not execute SQL statement, maybe invalid?; #print pready to output; #output database results while (@row=$sth-fetchrow_array) { print @row\nbr } #vprint hello; #close datbase $dbh-disconnect(); $sth - finish; print $form-end_html; Thanks in advance, Connie _ Get your FREE download of MSN Explorer at http://explorer.msn.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 mysql-unsubscribe-##L=##[EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail mysql-unsubscribe-##L=##[EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
OT: Anyone know of a good Real Audio/Video host in East Coast
I am moving all my web-hosting stuff for my company in-house (finally)! Thanks to Dell's price cuts and Mpower DSL connection (at an unbeatable price) I am able to bring in-house most of the stuff (including fabulous MySQL database) BUT the Real Audio/Video server. I need a plan that gives me Real Server G2 (no http streaming bulls**t) with 100-150 megs of space with 5 Gig traffic for under $40 a month located in Midwest (Chicago would be best) or East coast. I would appreciate your help! Apollo P.S. I am not interested in small hosts. I need to be on a major host. Apolinaras Apollo Sinkevicius Carmel Music Entertainment, LLC 701 Main Street, 2nd Floor Evanston, IL 60202 Toll-free: 800-276-5969 Phone: 847-864-5969 Fax: 847-864-6149 E-mail: [EMAIL PROTECTED] web-site: http://carmelentertainment.com Chicago's largest resource for absolutely the best musical and variety talent available.
RE: problem regarding ASP+MySQL in NT with IIS (web server)
Hi Ashutosh, You can try a tool like MySQLX which was specifically developed for MySQL and ASP, see: http://www.scibit.com/MySQLX or any of the other ASP API interfaces in the mysql Contrib section. Regards Jacques http://www.scibit.com/mysql -Original Message- From: ASHUTOSH SHARMA [mailto:[EMAIL PROTECTED]] Sent: 18 May 2001 13:51 To: [EMAIL PROTECTED] Subject: problem regarding ASP+MySQL in NT with IIS (web server) respected sir, i have a problem regarding connectivity between ASP and mysql. will it possible to connect asp with mysql if yes then how we can do it will it need any driver if yes then from where we get that driver .. will i get some tutoril in this matter... thanking you ashutosh - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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: Telnet and ftp problem
You don't use telnet or ftp to connect to the MySQL server. You use the client mysql. Rodolfo Baselli wrote: Hi I've got a MySQL box running on a PIII/700 with SuSE Linux 6.4 and cannot connect to it via telnet and ftp. I have my telnet prompt back as I stop the MySQL server daemon (from the console ;-)). The MySQL client login is always straight, it never fails and I get the mysql prompt immeditely. Has someone ever had this problem before? Server version is 3.22.32 Rodolfo Baselli (Italy) - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php -- Gerald L. Clark [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
if or statement possible?
Is it possible to make this type of logical command in MySQL? if ((x == y) or (x == z)) { response1 } else{ response2 } From what I can see the sql if statement will only handle one argument on the LHS. Can this be done, or do I need to look at multiple queries and then combine the results externally? -- === Kip Turkphone: 915.234.5678 Systems Administrator or 800.695.9016 Killer of Spam/Writer of Code/Penguin Proponent West Central Net fax: 915.656.0071 === - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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: DBI problem
that is because you are calling a script using cgi from the command prompt. that's really a question for a perl/cgi group. cgi's are intended to be run from the web. i think you can just press Ctrl+D (or Ctrl+Z - can't remember which) when you get that prompt to continue. - Original Message - From: c cw_1 [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: Friday, May 18, 2001 2:28 PM Subject: DBI problem Hi, I tried to connect to the database, when I compiled it, it replied with (offline mode: enter name=value pairs on standard input) - What is this meant? Below is my code: #!/usr/bin/perl -w use strict; use CGI; use DBI; my $dbh; my $sth; my @row; my $form = new CGI; print $form-header; print htmlbody; print ready to connectp; my $database = loc_data; my $username = mysql; my $password = mysql; #open connection to Access database $dbh = DBI-connect(DBI:mysql:$database, $username, $password) or die Couldn't connect to database: . $dbh-errstr; # print connectedp; #construct SQL statement ##$sqlstatement = SELECT * from tld_data; # print selectedp; #prepare and execute SQL statement $sth = $dbh-prepare(SELECT * from tld_data) or die Can't prepare SQL statement: ; # print preparedp; $sth-execute || print Could not execute SQL statement, maybe invalid?; #print pready to output; #output database results while (@row=$sth-fetchrow_array) { print @row\nbr } #vprint hello; #close datbase $dbh-disconnect(); $sth - finish; print $form-end_html; Thanks in advance, Connie _ Get your FREE download of MSN Explorer at http://explorer.msn.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 mysql-unsubscribe-##L=##[EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail mysql-unsubscribe-##L=##[EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
mySQL 3.22.32-1
Hi, Does mySQL 3.22.32-1 work on Windows 98? My ISP is using Chili!Soft ASP which only talks to mySQL 3.22.32-1, therefor mySQL 3.23 is out of the question. Any reply is greatly appreciated. Putri Alam US-ASEAN Business Council Washington, DC - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
RE: problem regarding ASP+MySQL in NT with IIS (web server)
Our solution to this was installing myODBC on the NT Server and connecting in this fashion: Dim Conn_STRING Conn_STRING = driver={mysql};database=dbname;uid=uname;pwd=password;option=16386; set rsRecordSet = Server.CreateObject(ADODB.Recordset) rsRecordSet.ActiveConnection = Conn_STRING This assumes VBScript On an off note, I suggest you make the connection string an include file, so that if the name changes or the pw changes or whatever, you will not have to change every page in your site. Hope this helps you, Dave Carter Chief Web Architect Accelerated Business Technologies, Inc. http://www.abti.cc 717.464.2970 -Original Message- From: ASHUTOSH SHARMA [mailto:[EMAIL PROTECTED]] Sent: Friday, May 18, 2001 7:51 AM To: [EMAIL PROTECTED] Subject: problem regarding ASP+MySQL in NT with IIS (web server) respected sir, i have a problem regarding connectivity between ASP and mysql. will it possible to connect asp with mysql if yes then how we can do it will it need any driver if yes then from where we get that driver .. will i get some tutoril in this matter... thanking you ashutosh - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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: if or statement possible?
On Fri, 18 May 2001, Kip Turk wrote: Is it possible to make this type of logical command in MySQL? if ((x == y) or (x == z)) { response1 } else { response2 } I'll go ahead and follow up my own post, as I found a solution, using regexp. Here's a test case I ran if anyone else is interested: select distinct(if(substring(username,1,8) regexp 'ange(wcc|pin)-', lcase(trim(leading concat(substring_index(username,'-',1), '-') from username)), lcase(username))) as username from radacct where acctstarttime between '2001-05-17' and '2001-05-18' order by username; Basically, I wanted to see if the username started with angewcc- or angepin- and if so, remove that portion of the string. It worked quite well, returning 3000 rows in less than a second. cheers, -- === Kip Turkphone: 915.234.5678 Systems Administrator or 800.695.9016 Killer of Spam/Writer of Code/Penguin Proponent West Central Net fax: 915.656.0071 === - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: MySQL-Based System Monitoring Tool
Hi Van, I use a program called netsaint. (netsaint.sourceforge.net) It uses mysql or postgresql for almost everything. The history file is still flat ASCII, but its on the todo list to move it to the mysql database. (it's the only file that has NOT been put into a database!). The mysql plugin is in the contrib section of the plugin modules. I run NRPE for getting stats from remote machines. E-mail me privately and I'll give you the address and login for my netsaint page if you are interested. I hope this helps. Ken - Ken Menzel ICQ# 9325188 www.icarz.com [EMAIL PROTECTED] - Original Message - From: Van [EMAIL PROTECTED] To: MySQL [EMAIL PROTECTED] Sent: Friday, May 18, 2001 1:19 AM Subject: MySQL-Based System Monitoring Tool Greetings All: I'll keep this brief. Subject says it all. There's MRTG, which appears to have branched to RRD, and Spong, and Big Brother (which used to be good), and Big Sister, and MRTG-PME, inept, etc. ad nauseam. Problem with most of the better developed ones is a perl basis and usage of flat-files for history, etc. SNMP opens up security problems and you can't get MIB's for every device. All I'm looking for is uptime, traffic, cpu, disk, and key services monitoring. Flat-files, just doesn't make sense. MySQL as the data repository seems to make much more sense. Before I go inventing the wheel and starting a new C/C++ project, does anyone know of something out there that does these basic things? I'm not too concerned with the graphing; I'll throw together my own php or c-based gd images with the data. Thanks, if anyone can help prevent YAMT (monitoring tool). Best Regards, Van -- == === Linux rocks!!! http://www.dedserius.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
SELECT DISTINCT on two columns
I have two columns in a table I need to get distinct values out of. I know I can get distinct combinations of the values of the two columns with SELECT DISTINCT fruits1, fruits2 but what I need is unique values among the two. So that if in fruits1 I have values apples and oranges, and in fruits2 I have values bananas and oranges, my query will return values apples, oranges, bananas. Any ideas how this can be done? - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
MysqlGUI interace
I am intersted in your MySQL GUI. Any specs available ? Will the software be at a cost ? Are you looking for distributors ? I am an independant consultant in France and enthused by free software field. Yours truly, Michel Demonfaucon Ahimsa - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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: Weird problem. 3.23.37, RH 6.0
try SELECT * WHERE x like '3411'. Steve Sobol wrote: I have a varchar field that contains the street number (part of a mailing address). It's a varchar because the field may occasionally contain non-numeric characters, but normally it doesn't. Let's call the field x. I have a record where x='3411'. In spite of the fact that x is a varchar, the query SELECT * WHERE x='3411' returns no rows, while SELECT * WHERE x=3411 returns the row containing x=3411. Why doesn't the string comparison work on the varchar field? I can't guarantee that there won't ever be non-numeric characters in that field, or I would have made it an int instead. Help! Thanks. -- Tired of Earthlink? Get JustTheNet! Nationwide Dialup, ISDN, DSL, ATM, Frame Relay, T-1, T-3, and more. EARTHLINK AMNESTY PROGRAM: Buy a year, get two months free More info coming soon to http://JustThe.net, or e-mail me! B!ff: K3wl, w3'v3 r00t3D da [EMAIL PROTECTED] 0h CrAp, INC0M!Ng $%^NO CARRIER - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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: NT installation / port issues
At 11:36 18/05/2001 -0400, Michael Britton wrote: Hi, That error message should means: the server wasn't started or the client wasn't able to connect for privileges issues. The server you should use is: mysqld-nt.exe The recommended way on NT is as service so install it by: \mysql\bin\mysqld-nt --install to start the server at first time, type: net start mysql to stop the server: net stop mysql When you install the service, thereafter at every boot the server is started. To be sure it isn't exist other process, using the port 3306, you can list all the ports with (before start the MySQL server): netstat -a In the remote case that port is used by other process than MySQL server, you can specify other port like 3307..3309, using the my.cnf/my.ini file with the variable port=3308. Take a look in the Manual about the use of the configuration file. Also read about the GRANT/REVOKE commands. Regards, Miguel System: NT 4.0 mysql Ver. 8.2 Distrib 3.22.34, for Win95/Win98 on i586 I'm unable to access mysql server on port 3306. Error reads: Can't connect to MySQL server on 'localhost' (10061). Does this mean it's not on 3306? How do I get it there? Do I have the wrong version and do I need to download an NT version? Thanks, Michael Britton Mike Britton Web Developer LIPSinc http://www.lipsinc.com http://www.lipsinc.com/ We Have Ways of Making You Talk. __ ___ __ / |/ /_ __/ __/ __ \/ / http://www.mysql.com/ / /|_/ / // /\ \/ /_/ / /__ Miguel Solórzano [EMAIL PROTECTED] /_/ /_/\_, /___/\___\_\___/ São Paulo, Brazil ___/ Development Team - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: Weird problem. 3.23.37, RH 6.0
Dibo Chen wrote: try SELECT * WHERE x like '3411'. Like doesn't work either. I tried it. mysql select ppn from main where streetnum=3411; +---+ | ppn | +---+ | 01A003290 | | 01A016440 | +---+ 2 rows in set (3.04 sec) mysql select ppn from main where streetnum='3411'; Empty set (2.85 sec) mysql select ppn from main where streetnum like '3411'; Empty set (2.88 sec) Field TypeNullKey Default Extra id bigint(4) PRI 0 ppn varchar(40) streetnum varchar(80) streetdir varchar(80) streetname varchar(80) streetsuffixvarchar(80) streetnum2 varchar(80) taxdist varchar(5) owner1 varchar(40) -- Tired of Earthlink? Get JustTheNet! Nationwide Dialup, ISDN, DSL, ATM, Frame Relay, T-1, T-3, and more. EARTHLINK AMNESTY PROGRAM: Buy a year, get two months free More info coming soon to http://JustThe.net, or e-mail me! B!ff: K3wl, w3'v3 r00t3D da [EMAIL PROTECTED] 0h CrAp, INC0M!Ng $%^NO CARRIER - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Matching errors.
Description: Using MATCH in select-clauses returns: ERROR 1030: Got error -1 from table handler How-To-Repeat: Table: CREATE TABLE files (id INT(10) NOT NULL AUTO_INCREMENT PRIMARY KEY, filename BLOB, comment BLOB, size INT(10), cd INT(10), date_entered TIMESTAMP); create fulltext index sepeindex on files (filename,comment); And then a: SELECT * from files where MATCH filename AGAINST ('david gray'); Fix: Not known. Submitter-Id: submitter ID Originator:hjalmar wåhlander Organization: Private MySQL support: none Synopsis: Matching errors. Severity: serious Priority: medium Category: mysql Class: sw-bug Release: mysql-3.23.37 (Source distribution) Environment: System: Linux r2d2.myspys 2.2.14-5.0 #1 Tue Mar 7 20:53:41 EST 2000 i586 unknown Architecture: i586 Some paths: /usr/local/bin/perl /usr/bin/make /usr/bin/gmake /usr/bin/gcc /usr/bin/cc GCC: Reading specs from /usr/lib/gcc-lib/i386-redhat-linux/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 Jul 31 2000 /lib/libc.so.6 - libc-2.1.3.so -rwxr-xr-x1 root root 4101324 Feb 29 2000 /lib/libc-2.1.3.so -rw-r--r--1 root root 20272704 Feb 29 2000 /usr/lib/libc.a -rw-r--r--1 root root 178 Feb 29 2000 /usr/lib/libc.so Configure command: ./configure - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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 problems
I have successfully installed MySQL 3.23.38. I can start the server and log in as root. When I try to grant new users using: grant insert to test.* for testuser identified by 'testpassword'; It comes back saying 0 rows affected. I can go the the MySQL db and look at the grant table and it will show testuser with proper privlidges but a very scrambled looking password (not sure if that is on purpose for security). But when I try to log that user in using: mysql -u testuser -p and then enter the password: testpassword The login fails everytime. Any help would be appreciated. Thanks!!! Justin Pease - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
PATCH: InnoDB assertion failure in ibuf0ibuf.c in large table import
Hi! A bug fix patch: If you do a lot of inserts into a table and a column in a secondary index contains NULL values, then the insert buffer may overflow, causing an assertion failure in ibuf0ibuf.c, line 2264. A fixed mysql/innobase/ibuf/ibuf0ibuf.c can be downloaded from http://www.innobase.fi/bugfixes.html Regards, Heikki - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Error installing DBI mySQL Driver
Hello I am trying to install DBD-mysql, i have installed all the requisites that its needs : 1. Perl == ActivePerl-5.6.1.626 2. MySQL == Ver 9.38 Distrib 3.22.32 3. DBI == DBI-1.15 4. C compiler and Gzip libraries are included in the installation of Linux , but when i run the make told me and error. The process of make with the error is: mkdir blib mkdir blib/lib mkdir blib/lib/DBD mkdir blib/arch mkdir blib/arch/auto mkdir blib/arch/auto/DBD mkdir blib/arch/auto/DBD/mysql mkdir blib/lib/auto mkdir blib/lib/auto/DBD mkdir blib/lib/auto/DBD/mysql mkdir blib/man3 cp lib/DBD/mysql.pm blib/lib/DBD/mysql.pm cp lib/Bundle/DBD/mysql.pm blib/lib/Bundle/DBD/mysql.pm cp lib/Mysql/Statement.pm blib/lib/Mysql/Statement.pm cp lib/DBD/mysql/INSTALL.pod blib/lib/DBD/mysql/INSTALL.pod cp lib/DBD/mysql.pod blib/lib/DBD/mysql.pod cp lib/Mysql.pm blib/lib/Mysql.pm cc -c -I/usr/lib/perl5/site_perl/5.005/i686-linux/auto/DBI -Dbool=char - DHAS_BOOL -I/usr/local/include -O2-DVERSION=\2.0900\ - DXS_VERSION=\2.0900\ -fpic -I/usr/lib/perl5/5.00503/i686-linux/CORE dbdimp.c In file included from dbdimp.c:29: dbdimp.h:31:49: mysql.h: No such file or directory dbdimp.h:32:49: errmsg.h: No such file or directory make: *** [dbdimp.o] Error 1 Why this error ??, please help me with this, I REALLY need an answer. Thanks Ana Elisa Martinez - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Restoring data to a database
Hi, I back up my entire database with the following command: mysqldump --opt -ppassword mydbf_db /mydir/mydbf.backup Does anyone know the counterpart command to restore from the backup file? Thanks, Don - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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: Hierarchy Queries - Multiple LEFT JOINs of the same table?
cool, thanks! I don't know why I was using LEFT JOINS :) What would I do if I wanted to go the other way... ie see everyone who reports to Bob? Also, won't this query return blank if you can't go up 2 levels to S3? Thanks! Graeme - Original Message - From: Dibo Chen [EMAIL PROTECTED] To: Graeme B. Davis [EMAIL PROTECTED] Cc: [EMAIL PROTECTED] Sent: Friday, May 18, 2001 2:53 PM Subject: Re: Hierarchy Queries - Multiple LEFT JOINs of the same table? try: select s3.name from staff s1, staff s2, staff s3 where s1.id = 1 and s1.reportsto = s2.id and s2.reportsto = s3.id Graeme B. Davis wrote: I have a staff database which contains a column that has a reports to field. If I have a table like this: IDNameReports To 1 Graeme 5 3 Bob 6 5 Sue 3 How can I (in one query) find the next 2 levels of people that Graeme reports to? Ie, I want to get the following from the query when I search for Graeme: Graeme, Sue, Bob Is this possible? I presume it would be with a LEFT JOIN, but I can't figure out how to change the name of the table for the second JOIN. Here is my current query: SELECT S.first, S.last, S.reportsto, staff.first, staff.last, staff.reportsto, S2.first, S2.last, S2.reportsto FROM staff AS S, staff AS S2 LEFT JOIN staff ON S.reportsto=staff.id WHERE S.first='Graeme' AND staff.id=S2.id Any ideas? Thanks! - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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: Restoring data to a database
Don Pro writes: Hi, I back up my entire database with the following command: mysqldump --opt -ppassword mydbf_db /mydir/mydbf.backup I've got: mysqldump -h mysql.io.com -u user -p --opt database ! backup-file.sql mysql -h mysql.io.com -u user -p database backup-file.sql In your case the -u is probably optional. My version prompts for the password. --Cindy - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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: Restoring data to a database
If you look at the 'text' file you created with the 'dump', you'll see that it contains all of the 'SQL commands' to recreate the tables and 'insert' the data you've extracted. So you simply type: mysql mydbf_db /mydir/mydbf.backup (you might have to insert/add the -u and a username and -p to the command...) Don Pro wrote: Hi, I back up my entire database with the following command: mysqldump --opt -ppassword mydbf_db /mydir/mydbf.backup Does anyone know the counterpart command to restore from the backup file? Thanks, Don
ENUM and large strings
Hi! In order to save space in our database, we designed our tables to use enumerated datatypes. For one column, we have about 2,800 different values, each of which is about 30-40 text characters long. Now, all the MySQL documentation I have read states that the limit for the number of ENUM keys is 65535 (2 byte representation), and nowhere does it mention a maximum size for the key values. Is this a bug? We are using the version distributed with Red Hat 7.0 (3.23.32). Any advice is appreciated. Thanks! -- 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
Re: date_format sets time to 12:00:00
Sinisa Milivojevic wrote: [EMAIL PROTECTED] writes: Description: date_format is setting times to 12:00 AM; time_format works fine How-To-Repeat: mysql select start,TIME_FORMAT(start, '%l:%i %p') AS start2 FROM time; +--+--+ | start| start2 | +--+--+ | 12:00:00 | 12:00 PM | | 14:00:00 | 2:00 PM | +--+--+ 2 rows in set (0.01 sec) mysql select start,DATE_FORMAT(start, '%l:%i %p') AS start2 FROM time; +--+--+ | start| start2 | +--+--+ | 12:00:00 | 12:00 AM | | 14:00:00 | 12:00 AM | +--+--+ 2 rows in set (0.06 sec) cut Hi! And column start is of what type and what are it's actual values. Column start is of type TIME. The actual values are illustrated above in the example. Paul shad 96c / 4B CS / mac activist / eda / fumbler fan of / jewel / sophie b. / sarah slean / steve poltz / emm gryner / / x-files / buffy / dawson's creek / habs / bills / 49ers / t h i n k d i f f e r e n t. Mulder, not everything is a labyrinth of dark conspiracy, and not everybody is plotting to deceive, inveigle, and obfuscate. ... Where are you going? -- Dana Scully, The X-Files To find someone who I know plotted to deceive, inveigle, and obfuscate. -- Fox Mulder, The X-Files - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
question about a select application (sql, database)
Hi, everyone, I wrote a program to keep inserting rows to the databases. But I want to check the LAST row I inserted. Is there any good way to do it?? thanks, Joe
RE: question about a select application (sql, database)
Does the table have an auto_increment column? If so: select * from table where autoinccolumn = LAST_INSERT_ID(); I wrote a program to keep inserting rows to the databases. But I want to check the LAST row I inserted. Is there any good way to do it?? - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
RE: ENUM and large strings
Perhaps in your case it would be better to use another table and do a join? Hi! In order to save space in our database, we designed our tables to use enumerated datatypes. For one column, we have about 2,800 different values, each of which is about 30-40 text characters long. Now, all the MySQL documentation I have read states that the limit for the number of ENUM keys is 65535 (2 byte representation), and nowhere does it mention a maximum size for the key values. Is this a bug? We are using the version distributed with Red Hat 7.0 (3.23.32). Any advice is appreciated. Thanks! - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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: Grant problems
I think you're using it incorrectly. It should be: grant insert on test.* to testuser@localhost identified by 'testpassword'; I have successfully installed MySQL 3.23.38. I can start the server and log in as root. When I try to grant new users using: grant insert to test.* for testuser identified by 'testpassword'; It comes back saying 0 rows affected. I can go the the MySQL db and look at the grant table and it will show testuser with proper privlidges but a very scrambled looking password (not sure if that is on purpose for security). But when I try to log that user in using: mysql -u testuser -p and then enter the password: testpassword The login fails everytime. Any help would be appreciated. Thanks!!! - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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 instalation problem
Recently, I've been trying to install MySQL on a redhat 7.2 system. I am trying to do so from source. Everything seems to go well untill I have to change the root password. Basicly the following happens: Installing all prepared tables 010518 10:22:02 /usr/local/mysql/libexec/mysqld: Shutdown Complete To start mysqld at boot time you have to copy support-files/mysql.server to the right place for your system PLEASE REMEMBER TO SET A PASSWORD FOR THE MySQL root USER ! This is done with: /usr/local/mysql/bin/mysqladmin -u root -p password 'new-password' /usr/local/mysql/bin/mysqladmin -u root -h stupidsiteforjerks.com -p password 'new-password' See the manual for more instructions. NOTE: If you are upgrading from a MySQL = 3.22.10 you should run the /usr/local/mysql/bin/mysql_fix_privilege_tables. Otherwise you will not be able to use the new GRANT command! You can start the MySQL daemon with: cd /usr/local/mysql ; /usr/local/mysql/bin/safe_mysqld You can test the MySQL daemon with the benchmarks in the 'sql-bench' directory: cd sql-bench ; run-all-tests Please report any problems with the /usr/local/mysql/bin/mysqlbug script! The latest information about MySQL is available on the web at http://www.mysql.com Support MySQL by buying support/licenses at https://order.mysql.com [root@stupidsiteforjerks mysql-3.23.38]# /usr/local/mysql/bin/mysqladmin -u root -p password 'new-password' Enter password: /usr/local/mysql/bin/mysqladmin: connect to server at 'localhost' failed error: 'Can't connect to local MySQL server through socket '/tmp/mysql.sock' (2)' Check that mysqld is running and that the socket: '/tmp/mysql.sock' exists! Anybody have any ideas? -- ++ |Mark Campbell | |[EMAIL PROTECTED] | |ICQ:1615| ++ Ach! Das facken phone ist ein...nuisance phone! - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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 outer join...
Hello, all. Having a small problem with MySQL and need some expert help. Trying to do a left outer join on one table out of seven. As shown below the only table which may have no row would be the pnotes table. Also shown below is the results I am getting (*use a fixed font for proper viewing*). There should be two rows returned, the complete one as shown below and one with partial data, i.e., missing the data stored in column pnotes_A which contains several fields separated by colons (columns Alice, Disk#, RTech, STech, Scored, Faxed in the report sample below). Any help would be greatly appreciated. select concat( caldateof, ',',ptlname, ',',ptfname, ',',roomname, ',',cptcode, ',',ptrefdoc, ',',ptphy1, ',',pnotes_A ) from scheduler sch, patient pat, procrec, cpt, physician phy, room left outer join pnoteson pat.id = pnotes.pnotespat and pnotes.pnotesdescrip = 'Tech' where MONTH(sch.CALDATEOF) = $xmonth and pat.ptrefdoc = phy.id and pat.id = procrec.procpatient and procrec.proccpt = cpt.id and sch.calpatient = pat.id and sch.calroom = room.id order by caldateof, roomdescrip bash script parses output of above script to produce below report: Tech Score Recap - May Fri May 18 20:04:38 EDT 2001 Test Date Patient Name Alice Dsk Lab Type Ref PhyInt PhyRTech STech Scored Faxed NULL NULL, NULL NULL NULL NULL NONE NULL NULL NULL NULL NULL NULL, NULL NULL NULL NULL NONE NULL NULL NULL NULL 2001-05-14 Doe, John311 P52 MCP1 PSG Arthur Jordan KS NULL NULL, NULL NULL NULL NULL NONE NULL NULL NULL NULL Total Patients:4
RE: MySQL instalation problem
You can start the MySQL daemon with: cd /usr/local/mysql ; /usr/local/mysql/bin/safe_mysqld ... [root@stupidsiteforjerks mysql-3.23.38]# /usr/local/mysql/bin/mysqladmin -u root -p password 'new-password' Enter password: /usr/local/mysql/bin/mysqladmin: connect to server at 'localhost' failed error: 'Can't connect to local MySQL server through socket '/tmp/mysql.sock' (2)' Check that mysqld is running and that the socket: '/tmp/mysql.sock' exists! Did you start the MySQL daemon before trying to change your password, as it says above? What does ps auxw | grep mysql say? - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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: ENUM and large strings
In order to save space in our database, we designed our tables to use enumerated datatypes. For one column, we have about 2,800 different values, each of which is about 30-40 text characters long. Now, all the MySQL documentation I have read states that the limit for the number of ENUM keys is 65535 (2 byte representation), and nowhere does it mention a maximum size for the key values. Is this a bug? We are using the version distributed with Red Hat 7.0 (3.23.32). Any advice is appreciated. Thanks! Good God man Is this some kind of masochistic or sick joke? use another table! CREATE TABLE Enum_Table ( enum_id SMALLINT UNSIGNED NOT NULL UNIQUE auto_increment, enum_name VARCHAR(40) NOT NULL ); there, now you can have 65535 enums... daevid.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
[isp-linux] Apache make fails (apache, ssl, php, mysql)
I'm trying to add php support into apache and the 'make' command fails. mysql-3.23.38 installed fine and I ran some tests and everything is working. php-4.0.5 also installed fine (but don't know how to test it from the command line). The apache configure also went fine: [root@dns2 apache_1.3.14]# ./configure \ --prefix=/usr/local/apache \ --activate-module=src/modules/standard/mod_rewrite.c \ --enable-module=rewrite \ --enable-module=ssl \ --activate-module=src/modules/php4/libphp4.a \ --enable-module=php4 But when I try to do 'make' for apache, I run into these problems: (there is lots of messages about 'undefined reference...' for mysql) modules/php4/libphp4.a(php_mysql.o): In function `_free_mysql_result': /home/ae/software/php-4.0.5/ext/mysql/php_mysql.c:191: undefined reference to `m ysql_free_result' collect2: ld returned 1 exit status make[2]: *** [target_static] Error 1 make[2]: Leaving directory `/home/ae/software/apache_1.3.14/src' make[1]: *** [build-std] Error 2 make[1]: Leaving directory `/home/ae/software/apache_1.3.14' make: *** [build] Error 2 Does anyone know how I can correct this problem? P.S. I'm trying to do this on a RedHat 7.0 box with a working version of apache 1.3.14 already installed. Thanks! SW Penguinistas! Find out the latest news, tips and opinions making its way through the Linux industry. http://www.linuxplanet.com/linuxplanet/ _ The ISP-LINUX Discussion List _ To Join: mailto:[EMAIL PROTECTED] To Remove: mailto:[EMAIL PROTECTED] Archives: http://isp-lists.isp-planet.com/isp-linux/archives/