Re: How do I uninstall mySQL?
how did you install them? rpm pkgs, source? Scott Dix wrote: mySQL, How do I uninstall mySQL? 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
Re: Speed problems.. Still
what version of mysql are you running? I was having similar problem then I upgraded my mysql to 3.23.51 and the problem was solved. Richard Baskett wrote: Ok Im still having some serious speed problems and obviously since more records are being added every day the problem is getting worse. Here is the query: SELECT DISTINCT Location.SortID AS Loc, LocName, JobTitle AS Job, Company AS Comp, Jobs.JobID, Employers.EmpID FROM Employers INNER JOIN Jobs ON Employers.EmpID = Jobs.EmpID INNER JOIN JobsLocation ON Jobs.JobID = JobsLocation.JobID INNER JOIN Location ON JobsLocation.LocID = Location.LocID WHERE Valid = 1 AND JobTitle IS NOT NULL AND ( LocName LIKE 'US-Alabama%' ) ORDER BY Loc ASC EXPLAIN table type possible_keys key key_len ref rowsExtra Employers ALLPRIMARY NULL NULL NULL 56467 where used; Using temporary; Using filesort Jobsref PRIMARY,EmpID EmpID 4 Employers.EmpID 1 where used JobsLocation ref PRIMARY PRIMARY 4 Jobs.JobID 1 Using index Locationeq_ref LocID,LocName LocID2 JobsLocation.LocID 1 where used And yes I need all of those tables.. I took people's advice and used inner join instead of left join. It takes 52 seconds now... still not even close to satisfactory. Once I speed it up enough I am going to save the results to a table with a timestamp and periodically update those results and call those results if the particular query is being called again within the time limit. Any help would be appreciated. Plus I was told in the last thread that PRIMARY key is not an Index.. Is this true? Thanks! Rick Science without religion is lame, religion without science is blind. - Albert Einstein - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
mysql3.23.51 in RaQ2
Subject: Re: [cobalt-users] glibc download Date: Tue, 13 Aug 2002 11:26:57 -0700 From: Brian Quinn [EMAIL PROTECTED] To: Rahadul Kabir [EMAIL PROTECTED] Yeah i installed the new glib and still can't get it to work. I got PHP4 to work fine after upgrading, but not mySQL I always see people with RAQ2's say they have mySQL 3.23.x installed, but either they don't know how they did it, or don't write me back. I'll let you know if i get something to work, if you don't mind doing the same. Thanks Brian Has anyone installed mysql 3.23.51 successfully on RaQ2??? - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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 UPGRADE ERROR
hi all, I was trying to upgrade mysql from 3.22.21 to 3.23.51 on my RaQ2 system. after removing the older version when I trid to install this new version (rpm pkgs) I got the follwoing error. anyone has any idea or can pelase tell me what should I do at this point. thanks in advance. rahad [root tomcat]# rpm -Uvh MySQL-* package MySQL-3.23.51-1 is for a different architecture error: MySQL-3.23.51-1.i386.rpm cannot be installed package MySQL-client-3.23.51-1 is for a different architecture error: MySQL-client-3.23.51-1.i386.rpm cannot be installed package MySQL-devel-3.23.51-1 is for a different architecture error: MySQL-devel-3.23.51-1.i386.rpm cannot be installed - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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 and MIPS
where can I find a mysql 3.23.51 to download for MIPS architecture??? 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
upgrade error
hi all, I was trying to upgrade mysql from 3.22.21 to 3.23.51 on my RaQ2 system. after removing the older version when I trid to install this new version (rpm pkgs) I got the follwoing error. anyone has any idea or can pelase tell me what should I do at this point. thanks in advance. rahad [root tomcat]# rpm -Uvh MySQL-* package MySQL-3.23.51-1 is for a different architecture error: MySQL-3.23.51-1.i386.rpm cannot be installed package MySQL-client-3.23.51-1 is for a different architecture error: MySQL-client-3.23.51-1.i386.rpm cannot be installed package MySQL-devel-3.23.51-1 is for a different architecture error: MySQL-devel-3.23.51-1.i386.rpm cannot be installed - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
change mysql dir
hi all, I'm running mysql 3.22 on my RaQ2 system. mysql was installed and configured on /var dir. but now that the databases are growing system is running out of disk space. So I decided to change the datadir=/home/mysql then I tried to move the mysql databases using following command being a root mv /var/lib/mysql/* /home/mysql/ -R but I get the following messages [root admin]# mv /var/lib/mysql/* /home/mysql/ -R mv: invalid option -- R Try `mv --help' for more information. can someone please tell me what i'm doing wrong or provide me with a solution to this problem. oh and if I don't use the -R option then I get error as the files under /var/lib/mysql/ are not regular files. please help. thanks so much. sorry about my bad English. rahad - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
change MySQL dir
hi all, I'm running mysql 3.22 on my RaQ2 system. mysql was installed and configured on /var dir. but now that the databases are growing system is running out of disk space. So I decided to change the datadir=/home/mysql then I tried to move the mysql databases using following command being a root mv /var/lib/mysql/* /home/mysql/ -R but I get the following messages [root admin]# mv /var/lib/mysql/* /home/mysql/ -R mv: invalid option -- R Try `mv --help' for more information. can someone please tell me what i'm doing wrong or provide me with a solution to this problem. oh and if I don't use the -R option then I get error as the files under /var/lib/mysql/ are not regular files. please help. thanks so much. sorry about my bad English. rahad - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
change mysql dir
hi all, I'm running mysql 3.22 on my RaQ2 system. mysql was installed and configured on /var dir. but now that the databases are growing system is running out of disk space. So I decided to change the datadir=/home/mysql then I tried to move the mysql databases using following command being a root mv /var/lib/mysql/* /home/mysql/ -R but I get the following messages [root admin]# mv /var/lib/mysql/* /home/mysql/ -R mv: invalid option -- R Try `mv --help' for more information. can someone please tell me what i'm doing wrong or provide me with a solution to this problem. oh and if I don't use the -R option then I get error as the files under /var/lib/mysql/ are not regular files. please help. thanks so much. sorry about my bad English. rahad - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
changing mysql dir
hi all, I'm running mysql 3.22 on my RaQ2 system. mysql was installed and configured on /var dir. but now that the databases are growing system is running out of disk space. So I decided to change the datadir=/home/mysql then I tried to move the mysql databases using following command being a root mv /var/lib/mysql/* /home/mysql/ -R but I get the following messages [root admin]# mv /var/lib/mysql/* /home/mysql/ -R mv: invalid option -- R Try `mv --help' for more information. can someone please tell me what i'm doing wrong or provide me with a solution to this problem. oh and if I don't use the -R option then I get error as the files under /var/lib/mysql/ are not regular files. please help. thanks so much. sorry about my bad English. rahad - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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 Startup Help!
hi im getting the message : Can't connect to local MySQL server through socket '/var/lib/mysql/mysql.sock' (111) when i try to connect to mysql Then I tried to run daemon [root /root]# /usr/sbin/mysqld Fatal error: Please read Security section of the manual to find out how to run mysqld as root! 020702 13:25:41 Aborting 020702 13:25:41 /usr/sbin/mysqld: Shutdown Complete [root /root]# /usr/sbin/mysqld start /usr/sbin/mysqld: Too many parameters /usr/sbin/mysqld Ver 3.23.51 for pc-linux-gnu on i686 Use '--help' or '--no-defaults --help' for a list of available options can someone please help me out. I have just installed mysql 3.23.51 on my RaQ System. Thanks rahad - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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 startup help!
hi im getting the message : Can't connect to local MySQL server through socket '/var/lib/mysql/mysql.sock' (111) when i try to connect to mysql Then I tried to run daemon [root /root]# /usr/sbin/mysqld Fatal error: Please read Security section of the manual to find out how to run mysqld as root! 020702 13:25:41 Aborting 020702 13:25:41 /usr/sbin/mysqld: Shutdown Complete [root /root]# /usr/sbin/mysqld start /usr/sbin/mysqld: Too many parameters /usr/sbin/mysqld Ver 3.23.51 for pc-linux-gnu on i686 Use '--help' or '--no-defaults --help' for a list of available options can someone please help me out. I have just installed mysql 3.23.51 on my RaQ System. Thanks rahad - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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 error!!!
[root /root]# mysqladmin -u root password '30waverly' 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' ex ists! [root /root]# I can't connect to mysql. does anyone know whats te problem. 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
MYSQ current value!!!
This are the few variables for mysql. Does anyone know how can I set the current value to some other value. because whats happing now is when I try to startup mysql, it starts and right after a second it ends. and I think Its because of this current value: 0. can someone please tel me in which file should I look into to chnage this value or any other solutions . thanks so much Possible variables for option --set-variable ( connect_timeout current value: 0 shutdown_timeout current value: 3600 - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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 /var dir
Hi, I have MySQL3.23.47 running on a Cobalt RaQ4 System. The mysql installed datadir turned out to be /var/lib/mysql. /var directory has its own partition (/dev/hda3) and total space available is 194MB. As My databases are growing and Im out of space now on the /var directory. I am thinking I need to change the datadir variable to somewhere on the /home directory, where I have 25GB free. How can I achieve this? Or is this the right approach? Please provide some solution as details as possible, as Im new into this stuff. Thanks so much. Rahad - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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 3.23.47 table
[EMAIL PROTECTED] wrote: Your message cannot be posted because it appears to be either spam or simply off topic to our filter. To bypass the filter you must include one of the following words in your message: sql,query If you just reply to this message, and include the entire text of it in the reply, your reply will go through. However, you should first review the text of the message to make sure it has something to do with MySQL. Just typing the word MySQL once will be sufficient, for example. You have written the following: Several of our users have reported random table corruption with Linux kernel 2.2.14 under heavy load. The table corruptions went away after an upgrade to a newer kernel. It appears that version 2.2.14 of the Linux kernel has a bug in the I/O implementation. Under some rather rare circumstances, the kernel will write incorrect data to the disk. I'm currently running Linux kernel version 2.2.14 , but i want to update with version 2.2.19. Have any one done that before? or does anyone has any idea how to do it or where can I find some helpful materials to resolve this problem. Thanks so much. --rahad - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
how to test JDBC driver!
I have installed and configured JDBC driver to work with MySql 3.23.47. Does anyone know how to test to see that JDBC driver is working properly? Is there a test file? thanks --rahad - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
How to install JDBC driver!
mm.mysql-2.0.10-you-must-unjar-me.jar this is the JDBC driver for Mysql3.23.47. Can someone tell me what is the command to unjar this file as well as how to install this on linux. mysql is on /var/lib/mysql (by default) and JDK on /home/tomcat. thanks so much --rahad - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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 to install JDBC driver!
Rahadul Kabir wrote: mm.mysql-2.0.10-you-must-unjar-me.jar this is the JDBC driver for Mysql3.23.47. Can someone tell me what is the command to unjar this file as well as how to install this on linux. mysql is on /var/lib/mysql (by default) and JDK on /home/tomcat. thanks so much --rahad - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
How to unjar a package!
can some one please tell me how to unjar a package, like a package which comes with .jar extension (executable file). 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
Confused About JDBC Driver
I'm a bit confused here. can some please tell me what is the difference between this two files -- mm.mysql.jdbc-1.2c.tar.gz ( Includes mysql_comp.jar and mysql_uncomp.jar) -- mm.mysql-2.0.10-you-must-unjar-me.jar For JDBC driver to run with mysql which one do I need? I thought you only need .jar file. then whats the mm.mysql.jdbc-1.2c.tar.gz file for. Are they the same files??? thanks so much. --rahad - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
JDBC Driver for MySQL3.23.47-1
hi, I recently installed MySQL3.23.47 and now I need the JDBC drivers for it. Does anyone know where can I find a Free JDBC driver that would work with MySQL 3.23.47-1? thanks so much --rahad - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
mysqld startup help!!
Hi, I installed MySQL version 3.23.47. It starts up and stop when i use the following command /etc/rc.d/init.d/mysql start /etc/rc.d/init.d/mysql stop Bu I attem to start /usr/sbin/mysqld server and edit the user table and update the password and user, it gives me following Fatal error [root /root]# /usr/sbin/mysqld Fatal error: Please read Security section of the manual to find out how to run mysqld as root! 020123 5:06:36 Aborting 020123 5:06:36 /usr/sbin/mysqld: Shutdown Complete Does anyone have any idea. please let me what should I do at this point. thanks --rahad - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Uninstall MySQL!!!
hi, can some one tell me how to Uninstall MySQL3.23.47-1from linux machine. I installed it and it went all wrong, so i want to start over. 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: Uninstall MySQL!!!
hi Jason, Thanks so much for your help. but it only worked for client and devel package. When I tried to uninstall the MySql Server package i get an error message as [root java]# rpm -qa | grep -i mysql MySQL-3.23.47-1 [root java]# rpm -e MySQL-3.23.47-1 error reading information on service mysql: No such file or directory execution of script failed [root java]# do you have any idea about this. Is there any other flag or command that can be used to uninstall this. thanks again. Jason Yates wrote: On Monday 21 January 2002 04:09 pm, you wrote: hi, can some one tell me how to Uninstall MySQL3.23.47-1from linux machine. I installed it and it went all wrong, so i want to start over. thanks. If you installed it using the binaries it's as simple as, rpm -e package-name Do an 'rpm -qa | grep -i mysql' that will list any mysql packages and put the package name in the rpm -e command. -Jason Yates - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
MySQL 3.23.47 or 4.0.1???
Hi, Do anyone know whether 4.0.1 is better than the 3.23.47, eventhough 4.0.1 is not a stable version. Is 4.0.1 would do the same thing as the 3.23.47? thanks --rahad - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php