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 to proceed : > 1 - after install, move or copy (with -R option) your actual datadir > under /var/lib/mysql > (that is to say all the directories located under /var/lib/mysql/*) > to /var1/lib/mysql, > and then modify in your my.cnf the variable > to correspond with the new directory. > NOTE : stop the mysqld daemon before copying or moving directories. > > 2 - before install, configure in your my.cnf the futur directory to use > with the variable ; > then place it under /etc/ - this cause the script > to find in /etc/my.cnf the datadir to use. > After install, you'll see that the directories mysql and test are > placed under > > Hope this help > Thierno6C > > -Original Message- > From: sanjay gupta [mailto:[EMAIL PROTECTED] > Sent: jeudi 4 septembre 2003 09:35 > To: [EMAIL PROTECTED] > Subject: 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 is mounted to my raid device /dev/md0 and i want mysql > data directory should be /var1 > > any suggestions > > sanjay > > > > -- > MySQL General Mailing List > For list archives: http://lists.mysql.com/mysql > To unsubscribe: > http://lists.mysql.com/[EMAIL PROTECTED] > > -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: 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 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 is > > mounted to my raid device /dev/md0 and i want mysql data directory should > > be /var1 > > > > Move databases to the new MySQL data dir. Run mysqld with --datadir=/var1/lib/mysql option or put to the my.cnf > > [mysqld] > datadir=/var1/lib/mysql > > > > -- > For technical support contracts, goto https://order.mysql.com/?ref=ensita > This email is sponsored by Ensita.net http://www.ensita.net/ >__ ___ ___ __ > / |/ /_ __/ __/ __ \/ /Egor Egorov > / /|_/ / // /\ \/ /_/ / /__ [EMAIL PROTECTED] > /_/ /_/\_, /___/\___\_\___/ MySQL AB / Ensita.net ><___/ www.mysql.com > > > > > -- > MySQL General Mailing List > For list archives: http://lists.mysql.com/mysql > To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED] > > -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
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 is mounted to my raid device /dev/md0 and i want mysql data directory should be /var1 any suggestions sanjay -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
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 number of mysql processes are running becasue it should show only single mysqld process. any idea sanjay -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
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 InnoDB and MyISAM tables ? > Hi Sanjay, > > I made a chart which shows the tables and their supported functions. > > Please have a look here: > > http://www.knowd.co.jp/staff/nils/ > > I hope this helps. > > Best regards > > Nils Valentin > Tokyo/Japan > > > 2003年 8月 22日 金曜日 18:45、sanjay gupta さんは書きました: > > Hi all , > > > > can anybody tell me the differance between the innidb and myisam tables > > types . > > > > sanjay > > -- > --- > Valentin Nils > Internet Technology > > E-Mail: [EMAIL PROTECTED] > URL: http://www.knowd.co.jp > Personal URL: http://www.knowd.co.jp/staff/nils > > -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
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 the mysql command-line client and type the > following: > > \P more > > Then hit enter. That forces the client to pass all of its output through > the more command and will thus return a screen's worth of records at a time. > \P will pipe the client's output through whatever you wish. If you want to > turn this feature off, just type \n on a new line all by itself. (Note that > this must be typed each time you start up the client app...) > > -Rob > > -Original Message- > From: Roger Baklund [mailto:[EMAIL PROTECTED] > Sent: Tuesday, August 19, 2003 8:42 AM > To: [EMAIL PROTECTED] > Cc: sanjay gupta > Subject: Re: scroll problem > > > * sanjay gupta > > i have tried limit , but i want 10 records at a time and when i > > hit "return key" i will show next 10 records, and so on. how i > > can achieve this . > > Depending on your OS, you could try something like this: > > $> mysql -e "SELECT * FROM tablename" database | more > > It won't give you 10 rows, but the number of rows that fits your screen. > > Note that 'more' is a OS utility, not a part of mysql. > > This should work on win, linux & unix. > > If you run unix/linux, try 'less' instead of 'more'... should give you also > page-up/page-down... ;) > > -- > Roger > > > > -- > MySQL General Mailing List > For list archives: http://lists.mysql.com/mysql > To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED] > > -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: scroll problem
thanks for the reply, i have tried limit , but i want 10 records at a time and when i hit "return key" i will show next 10 records, and so on. how i can achieve this . sanjay - Original Message - From: "Victoria Reznichenko" <[EMAIL PROTECTED]> To: <[EMAIL PROTECTED]> Sent: Tuesday, August 19, 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 records are > > visible.Is there any command suffix to SQL commands so that i may able to > > see all the records, > > Use LIMIT clause to retrieve only certain number of records. You can also use SELECT .. INTO OUTFILE command: > http://www.mysql.com/doc/en/SELECT.html > > > -- > For technical support contracts, goto https://order.mysql.com/?ref=ensita > This email is sponsored by Ensita.net http://www.ensita.net/ >__ ___ ___ __ > / |/ /_ __/ __/ __ \/ /Victoria Reznichenko > / /|_/ / // /\ \/ /_/ / /__ [EMAIL PROTECTED] > /_/ /_/\_, /___/\___\_\___/ MySQL AB / Ensita.net ><___/ www.mysql.com > > > > > > -- > MySQL General Mailing List > For list archives: http://lists.mysql.com/mysql > To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED] > > -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
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 able to see all the records, thanks in advance, sanjay -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
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 localhost -p #mysql -u root -h localhost -p mysql #mysql -u root -h localhost test -p #mysql -u root -h localhost test #mysql -u root #mysql -u root mysql but none of the option is working at all. Please any idea how i can change the root password or enter the mysql after fresh installation sanjay -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: Accessing Mysql after fresh installation
When i type the command # mysqladmin -p password '' > Enter password: > # it asks for password. I don't remember the password any more . So it gives the same message "Access denied for user [EMAIL PROTECTED] using password np" what to do - Original Message - From: "mathan" <[EMAIL PROTECTED]> 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 for > > user [EMAIL PROTECTED] host ...using password yes" > > > > i have tried all the options like > > > > #mysql -u root -h localhost > > #mysql -u root -h localhost -p > > #mysql -u root -h localhost -p mysql > > #mysql -u root -h localhost test -p > > #mysql -u root -h localhost test > > #mysql -u root > > #mysql -u root mysql > > > > but none of the option is working at all. > > > > Please any idea how i can change the root password or enter the mysql > after > > fresh installation > > > First disalbe the root passwd: > > To remove password simply type: > # mysqladmin -p password '' > Enter password: > # > > It will ask the passwd, enter the password you set previously, > > After that you can run mysql binary. I will not show any error messages and > you can play with mysql. > > # mysql > Welcome to the MySQL monitor. Commands end with ; or \g. > Your MySQL connection id is 22 to server version: 3.23.54-log > > Type 'help;' or '\h' for help. Type '\c' to clear the buffer. > > mysql> > > thanks > --mathan > > > > -- > MySQL General Mailing List > For list archives: http://lists.mysql.com/mysql > To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED] > > -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: Accessing Mysql after fresh installation
Hi Mathan. i am totally confused . Actually same problem occurred when install the mysql 2-3 months back. but then i solved the problem , how , i didnt know . but this time when i again start the mysql and did the installation the same problem is unable to resolve after all tries. i would like to mention to "Mr. Mathan " that i have not set any password after installation. the message appered after installation that you must set the password using "/usr/bin/mysqladmin -u root -p password 'new password' "/usr/bin/mysqladmin -u root -h localhost.localdomain -p password 'new password' but i 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 PROTECTED]> Sent: Wednesday, August 13, 2003 5:20 PM Subject: Re: Accessing Mysql after fresh installation > > When i type the command > > # mysqladmin -p password '' > > > Enter password: > > > # > > it asks for password. I don't remember the password any more . So it gives > > the same message > > "Access denied for user [EMAIL PROTECTED] using password np" > > > > what to do > > Ok, If you dont have any important data, then remove your data directory, > and do the following steps: > > To find the data directory run the command, the "ldata" will contains the > data directory. > # cat mysql_install_db | grep "ldata=" > > test -z "$ldata" && ldata= > > for eg assume data dir is /var/opt/mysql, then run the following commands > > # rm -rf /var/opt/mysql > # groupadd mysql > # mysql_install_db > # chown -R mysql /var/opt/mysql > # chmod 700 /var/opt/mysql > # safe_mysqld & > [1] 29828 > Starting mysqld daemon with databases from /var/opt/mysql > # mysqladmin create testdb > # mysql > Welcome to the MySQL monitor. Commands end with ; or \g. > Your MySQL connection id is 3 to server version: 3.23.54-log > > Type 'help;' or '\h' for help. Type '\c' to clear the buffer. > > mysql> connect testdb; > > then play with mysql. > > Let me know if you need any clarifications. > > thanks > --mathan > > > -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
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 archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
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: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: installation problem Mysql on Red Hat linux 6.2
Hi, i have download all the versions of mysql from 3 to 4 in rpm format . but could not install any of them on my red hat 6.2 machine When i installing using rpm -i it gives me the message "error MySQL-server-version number .rpm cannot be installed " do anybody have installed the mysql 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 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]> > Sent: Tuesday, July 29, 2003 4:51 PM > Subject: Re: installation problem Mysql 4.0.13 on Red Hat linux 6.2 > > > > > > > rpm -ivt MySQL-server-4.0.13-0.i386.rpm > > > returns " Only one major mode may be specified " > > > > this message is from the rpm utility and means that is it not being used > > correctly, there is no problem with mysql. > > > > maybe just try "rpm -i MySQL-server-4.0.13-0.i386.rpm" > > > > > > > > > > > > > > > > - Original Message - > > From: "sanjay gupta" <[EMAIL PROTECTED]> > > To: <[EMAIL PROTECTED]> > > Cc: <[EMAIL PROTECTED]> > > Sent: Tuesday, July 29, 2003 6:52 AM > > Subject: 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 my machine but could not > succeed > > . > > > please help > > > > > > Thanks in advance. > > > > > > sanjay > > > > > > > > > -- > > > MySQL General Mailing List > > > For list archives: http://lists.mysql.com/mysql > > > To unsubscribe: > > http://lists.mysql.com/[EMAIL PROTECTED] > > > > > > > > > > > > -- > > MySQL General Mailing List > > For list archives: http://lists.mysql.com/mysql > > To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED] > > > > > > > -- > MySQL General Mailing List > For list archives: http://lists.mysql.com/mysql > To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED] > > -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: 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]> Sent: Tuesday, July 29, 2003 4:51 PM Subject: Re: installation problem Mysql 4.0.13 on Red Hat linux 6.2 > > > rpm -ivt MySQL-server-4.0.13-0.i386.rpm > > returns " Only one major mode may be specified " > > this message is from the rpm utility and means that is it not being used > correctly, there is no problem with mysql. > > maybe just try "rpm -i MySQL-server-4.0.13-0.i386.rpm" > > > > > > > > - Original Message - > From: "sanjay gupta" <[EMAIL PROTECTED]> > To: <[EMAIL PROTECTED]> > Cc: <[EMAIL PROTECTED]> > Sent: Tuesday, July 29, 2003 6:52 AM > Subject: 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 my machine but could not succeed > . > > please help > > > > Thanks in advance. > > > > sanjay > > > > > > -- > > MySQL General Mailing List > > For list archives: http://lists.mysql.com/mysql > > To unsubscribe: > http://lists.mysql.com/[EMAIL PROTECTED] > > > > > > > -- > MySQL General Mailing List > For list archives: http://lists.mysql.com/mysql > To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED] > > -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: installation problem Mysql 4.0.13 on Red Hat linux 6.2
i am unable to install mysql 4.0 on my Rh. 6.2 box. >i have glib 1.2.6. When try to install the mysql it >gives the message "Mysql-server-version no.cannot be >installed" > >May i know what are the minimum requirment for >installtion of mysql 4.0 on 6.2. > >Is it possible to install the mysql 4.0 on 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 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 my machine but could not succeed . > please help > > Thanks in advance. > > sanjay > > > -- > MySQL General Mailing List > For list archives: http://lists.mysql.com/mysql > To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED] > > -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
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 my machine but could not succeed . please help Thanks in advance. sanjay -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
MySQL 4.0 on Red Hat Linux 6.2 installation problem
Hi all, i am unable to install mysql 4.0 on my Rh. 6.2 box. i have glib 1.2.6. When try to install the mysql it gives the message "Mysql-server-version no.cannot be installed" May i know what are the minimum requirment for installtion of mysql 4.0 on 6.2. Is it possible to install the mysql 4.0 on 6.2 thanks in advance sankalap