how to change default data directory

Hi All , I am using RH7.1 box . I am preparing to install mysql 4.0.13. Previously when i installed the mysql the mysql data directory was /var/lib/mysql . I uninstall the mysql . Now i want my data directory to be /var1/lib/mysql instead of /var/lib/mysql . I want this because var1

Re: how to change default data directory

thanks for valuable tips - Original Message - From: Egor Egorov [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: Thursday, September 04, 2003 3:30 PM Subject: Re: how to change default data directory sanjay gupta [EMAIL PROTECTED] wrote: I am using RH7.1 box . I am preparing

Re: how to change default data directory

thanks for the valuable tips sanjay gupta - Original Message - From: Thierno Cissé [EMAIL PROTECTED] To: 'sanjay gupta' [EMAIL PROTECTED]; [EMAIL PROTECTED] Sent: Thursday, September 04, 2003 3:50 PM Subject: RE: how to change default data directory Hi Sanjay, I see two ways

large mysql processes

Hi all, I am using Mysql-4.0.12 on my 7.1 redhat. every thing is working fine but when i give command #ps -ae it shows various process including mysqld_safe and mysql . the mysqld process are eleven in number with respective pids on my machine . I want to know why there are large

Re: differance between InnoDB and MyISAM tables ?

Hi Nils Valentin, Thanks for the sincere efforts and valuable tips sanjay gupta - Original Message - From: Nils Valentin [EMAIL PROTECTED] To: sanjay gupta [EMAIL PROTECTED]; [EMAIL PROTECTED] Cc: [EMAIL PROTECTED] Sent: Sunday, August 24, 2003 6:31 PM Subject: Re: differance between

differance between InnoDB and MyISAM tables ?

Hi all , can anybody tell me the differance between the innidb and myisam tables types . sanjay -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

Re: scroll problem

Thanks for the valuable tips sanjay - Original Message - From: Rob A. Brahier [EMAIL PROTECTED] To: Roger Baklund [EMAIL PROTECTED]; [EMAIL PROTECTED] Cc: sanjay gupta [EMAIL PROTECTED] Sent: Tuesday, August 19, 2003 11:15 PM Subject: RE: scroll problem If you are using *nix, fire up

scroll problem

Dear all, I have lot of problem due to scrolling .e.g. When i give command select * from table-name .if the records are more than the srceen width then i am unable to see all the records ,only last records are visible.Is there any command suffix to SQL commands so that i may

Re: scroll problem

, 2003 2:32 PM Subject: Re: scroll problem sanjay gupta [EMAIL PROTECTED] wrote: I have lot of problem due to scrolling .e.g. When i give command select * from table-name .if the records are more than the srceen width then i am unable to see all the records ,only last

Re: Accessing Mysql after fresh installation

have not set the password. there should be default password so that i may be adble to login to mysql . i have followed the the procedure that you have given below , still the same problem occures still hanging sanjay - Original Message - From: mathan [EMAIL PROTECTED] To: sanjay gupta [EMAIL

Re: Accessing Mysql after fresh installation

] To: sanjay gupta [EMAIL PROTECTED]; [EMAIL PROTECTED] Sent: Wednesday, August 13, 2003 4:04 PM Subject: Re: Accessing Mysql after fresh installation I have recently installes mysql -4.0.0.1 on my redhat 7.1 machine . After installing when enter into mysql it gives me message Access denied

Accessing Mysql after fresh installation

Hi All, I have recently installes mysql -4.0.0.1 on my redhat 7.1 machine . After installing when enter into mysql it gives me message Access denied for user [EMAIL PROTECTED] host ...using password yes i have tried all the options like #mysql -u root -h localhost #mysql -u root -h

how to upgrade mysql from 3.20 to 3.23

Dear All, I want to upgrade my mysql ver 3.20.32a-3 on my Red Hat linux 6.2 machine to mysql 3.23 version. Presently i have glib-1.2.6-3 and libc-5.3.12-3.1. How can i upgrade to version 3.23. thanks in advance sankalap -- MySQL General Mailing List For list archives:

Re: how to upgrade mysql from 3.20 to 3.23

Dear All, I want to upgrade my mysql ver 3.20.32a-3 on my Red Hat linux 6.2 machine to mysql 3.23 version. Presently i have glib-1.2.6-3 and libc-5.3.12-3.1. How can i upgrade to version 3.23. thanks in advance sankalap -- MySQL General Mailing List For list

Re: installation problem Mysql 4.0.13 on Red Hat linux 6.2

I used the coammand rpm -i also.Like that rpm -i MySQL-server-4.0.13-0.i386.rpm but it gives the mesaage error : MySQL-server-4.0.13-0.i386.rpm cannot be installed please help - Original Message - From: Matthew [EMAIL PROTECTED] To: sanjay gupta [EMAIL PROTECTED]; [EMAIL PROTECTED

Re: installation problem Mysql on Red Hat linux 6.2

on Red Hat 6.2 machine please help thanks in advance - Original Message - From: sanjay gupta [EMAIL PROTECTED] To: Matthew [EMAIL PROTECTED]; [EMAIL PROTECTED] Sent: Wednesday, July 30, 2003 1:10 PM Subject: Re: installation problem Mysql 4.0.13 on Red Hat linux 6.2 I used

installation problem Mysql 4.0.13 on Red Hat linux 6.2

Dear All , I am facing problem in installing the mysql 4.0.13 on my linux 6.2 machine . I have pentium III server. When i give the command rpm -ivt MySQL-server-4.0.13-0.i386.rpm it give the message Only one major mode may be specified I tried lot to install the mysql ver 4 on

Re: installation problem Mysql 4.0.13 on Red Hat linux 6.2

thanks in advance sankalap - Original Message - From: sanjay gupta [EMAIL PROTECTED] To: [EMAIL PROTECTED] Cc: [EMAIL PROTECTED] Sent: Tuesday, July 29, 2003 11:22 AM Subject: installation problem Mysql 4.0.13 on Red Hat linux 6.2 Dear All , I am facing problem