Re: Need to cleanly uninstall
Looks like there is a problem with 4.0.3 or I am doing something wrong: First I tried to upgrade from rpm, linux:/home/me/TMPOUT # rpm -e MySQL-4.0.3-0.i386.rpm error: package MySQL-4.0.3-0.i386.rpm is not installed linux:/home/me/TMPOUT # rpm -i MySQL-4.0.3-0.i386.rpm package MySQL-4.0.3-0 is already installed linux:/home/me/TMPOUT # rpm -e MySQL-4.0.3-0.i386.rpm error: package MySQL-4.0.3-0.i386.rpm is not installed linux:/home/db/TMPOUT # rpm -q mysql package mysql is not installed >linux:/home/db/TMPOUT # rpm -qa | grep MySQL >MySQL-shared-4.0.3-0 >MySQL-client-4.0.3-0 >MySQL-devel-4.0.3-0 >MySQL-4.0.3-0 >linux:/home/db/TMPOUT # /usr/bin/mysql >ERROR 2002: Can't connect to local MySQL server >through socket '/var/lib/mysql/mysql.sock' (2) FIrst, it Looks like rpm for 4.0.3 does not work. ANyone installed from rpm? Second, I went to the tarball: linux:/usr/local # groupadd mysql groupadd: group mysql exists linux:/usr/local # useradd -g mysql mysql useradd: user mysql exists linux:/usr/local # ln -s /usr/local/mysql-4.0.3-beta-pc- linux-gnu-i686 mysql linux:/usr/local # cd mysql linux:/usr/local/mysql # scripts/mysql_install_db Installing all prepared tables Unknown suffix ' ' used for variable 'thread_concurrency' (value '4 # Try number of CPU's*2') ./bin/mysqld: Error while setting value '4 # Try number of CPU's*2' to 'thread_concurrency' Installation of grant tables failed! Examine the logs in ./data for more information. You can also try to start the mysqld daemon with: ./bin/mysqld --skip-grant & You can use the command line tool ./bin/mysql to connect to the mysql database and look at the grant tables: shell> ./bin/mysql -u root mysql mysql> show tables Try 'mysqld --help' if you have problems with paths. Using --log gives you a log in ./data that may be helpful. The latest information about MySQL is available on the web at http://www.mysql.com Please consult the MySQL manual section: 'Problems running mysql_install_db', and the manual section that describes problems on your OS. Another information source is the MySQL email archive. Please check all of the above before mailing us! And if you do mail us, you MUST use the ./bin/mysqlbug script! linux:/usr/local/mysql # I don't get it, since here is /etc/my.cnf Any ideas what I should check?? Thanks, S.Alexiou # Example mysql config file for very large systems. # # This is for large system with memory of 1G-2G where # the system runs mainly # MySQL. # # You can copy this file to # /etc/mf.cnf to set global options, # mysql-data-dir/my.cnf to set server-specific options (in this # installation this directory is /var/lib/mysql) or # ~/.my.cnf to set user-specific options. # # One can in this file use all long options that the program supports. # If you want to know which options a program support, run the program # with --help option. # The following options will be passed to all MySQL clients [client] #password = your_password port = 3306 socket = /var/lib/mysql/mysql.sock # Here follows entries for some specific programs # The MySQL server [mysqld] port = 3306 socket = /var/lib/mysql/mysql.sock skip-locking set-variable = key_buffer_size=500M set-variable = key_buffer=100M set-variable = max_allowed_packet=1M set-variable = table_cache=512 set-variable= max_connections=10 set-variable= tmp_table_size=400M set-variable = sort_buffer=2M set-variable = record_buffer=2M set-variable = thread_cache=8 set-variable = thread_concurrency=4 # Try number of CPU's*2 #set-variable = myisam_sort_buffer_size=64M set-variable = myisam_sort_buffer_size=4M # Heiki says add: innodb_data_home_dir= #and then use absolute file paths #innodb_data_file_path=ibdata1:2000M;ibdata2:2000M;ibdat a3:2000M;ibdata4:2000M;ibdata5:2000M;ibdata6:2000M;ibdat a7:2000M;ibdata8:2000M innodb_data_file_path=/var/lib/mysql/ibdata1:2000M;/var/ lib/mysql/ibdata2:2000M;/var/lib/mysql/ibdata3:2000M;/va r/lib/mysql/ibdata4:2000M;/var/lib/mysql/ibdata5:2000M;/ var/lib/mysql/ibdata6:2000M;/var/lib/mysql/ibdata7:2000M ;/var/lib/mysql/ibdata8:2000M;/usr/ibdata/ibdata9:2000M; /usr/ibdata/ibdata10:2000M;/usr/ibdata/ibdata11:2000M;/u sr/ibdata/ibdata12:2000M;/ibdata/ibdata13:2000M;/ibdata/ ibdata14:2000M;/ibdata/ibdata15:2000M;/var/lib/mysql/ibd ata16:2000M;/var/lib/mysql/ibdata17:2000M;/var/lib/mysql /ibdata18:2000M;/var/lib/mysql/ibdata19:2000M;/var/lib/m ysql/ibdata20:2000M;/var/lib/mysql/ibdata21:2000M #;/usr/ibdata/ibdata9:2000M;/usr/ibdata/ibdata10:2000M ## Comment next line if you do not need recovery(the hostname-bin.xxx files) #log-bin ## server-id = 1 #set-variable= open-files-limit=8192 #ulimit is 1024,hard 8192 set-variable = innodb_buffer_pool_size=1100M # so that innodb_buffer_pool size+key_buffer+max_connections* (sort_buffer+record_buffer+2M)=1100+100+10*(2+2+2) =1260<2000M=RAM set-variable = innodb_additional_mem_pool_size=700M set-variable = innodb_log_file_size=1000M set-v
Re: Need to cleanly uninstall
Hmmm, (mysql, query) > Thanks That's OK. > It's 2.4.18 Sorry, I meant distribution...eg is it RedHat, Slackware ;-? > So, I will try to unistall and install from the > tarball, yes? It wouldn't hurt. How did you install it in the first place? DSL -- Con te partiro, su navi per mari Che io lo so, no, no non esistono piu Con te io li vivro. (Sartori F, Quarantotto E) - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: Need to cleanly uninstall
Thanks It's 2.4.18 So, I will try to unistall and install from the tarball, yes? > > > Spiros, > > > linux:/home/db/TMPOUT # rpm -q mysql > > package mysql is not installed > > > > linux:/home/db/TMPOUT # rpm -qa | grep MySQL > > MySQL-shared-4.0.3-0 > > MySQL-client-4.0.3-0 > > MySQL-devel-4.0.3-0 > > MySQL-4.0.3-0 > > linux:/home/spiros/TMPOUT # > > Ok. > > > mypc@linux:~> /usr/bin/mysql > > ERROR 2002: Can't connect to local MySQL server through socket > > '/var/lib/mysql/mysql.sock' (2) > > mypc@linux:~> /usr/bin/mysqld_safe > > /usr/bin/mysqld_safe: my_print_defaults: command not found > > The file /usr/sbin/mysqld doesn't exist or is not executable > > Please do a cd to the mysql installation directory and restart > > this script from there as follows: > > ./bin/mysqld_safe. > > @linux:~> > > > > Does this mean the rpm is no good? What next > > Possibly. What version of Linux are you using? > DSL > -- > Con te partiro, su navi per mari > Che io lo so, no, no non esistono piu > Con te io li vivro. > (Sartori F, Quarantotto E) > - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: Need to cleanly uninstall
Spiros, > linux:/home/db/TMPOUT # rpm -q mysql > package mysql is not installed > > linux:/home/db/TMPOUT # rpm -qa | grep MySQL > MySQL-shared-4.0.3-0 > MySQL-client-4.0.3-0 > MySQL-devel-4.0.3-0 > MySQL-4.0.3-0 > linux:/home/spiros/TMPOUT # Ok. > mypc@linux:~> /usr/bin/mysql > ERROR 2002: Can't connect to local MySQL server through socket > '/var/lib/mysql/mysql.sock' (2) > mypc@linux:~> /usr/bin/mysqld_safe > /usr/bin/mysqld_safe: my_print_defaults: command not found > The file /usr/sbin/mysqld doesn't exist or is not executable > Please do a cd to the mysql installation directory and restart > this script from there as follows: > ./bin/mysqld_safe. > @linux:~> > > Does this mean the rpm is no good? What next Possibly. What version of Linux are you using? DSL -- Con te partiro, su navi per mari Che io lo so, no, no non esistono piu Con te io li vivro. (Sartori F, Quarantotto E) - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: Need to cleanly uninstall
On Saturday 07 September 2002 10:48, you wrote: > You could do something like: > > linux:/home/db/TMPOUT # rpm -e MySQL-4.0.3-0.i386.rpm > > error: package MySQL-4.0.3-0.i386.rpm is not installed > > Don't add the RPM on the end. > > Also, what does: > > * rpm -qa | grep MySQL > > ...show. It will be in there. Use that name. > > mysql,query > > DSL linux:/home/db/TMPOUT # rpm -q mysql package mysql is not installed linux:/home/db/TMPOUT # rpm -qa | grep MySQL MySQL-shared-4.0.3-0 MySQL-client-4.0.3-0 MySQL-devel-4.0.3-0 MySQL-4.0.3-0 linux:/home/spiros/TMPOUT # mypc@linux:~> /usr/bin/mysql ERROR 2002: Can't connect to local MySQL server through socket '/var/lib/mysql/mysql.sock' (2) mypc@linux:~> /usr/bin/mysqld_safe /usr/bin/mysqld_safe: my_print_defaults: command not found The file /usr/sbin/mysqld doesn't exist or is not executable Please do a cd to the mysql installation directory and restart this script from there as follows: ./bin/mysqld_safe. @linux:~> Does this mean the rpm is no good? What next - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: Need to cleanly uninstall
You could do something like: > linux:/home/db/TMPOUT # rpm -e MySQL-4.0.3-0.i386.rpm > error: package MySQL-4.0.3-0.i386.rpm is not installed Don't add the RPM on the end. Also, what does: * rpm -qa | grep MySQL ...show. It will be in there. Use that name. mysql,query DSL -- Con te partiro, su navi per mari Che io lo so, no, no non esistono piu Con te io li vivro. (Sartori F, Quarantotto E) - 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 to cleanly uninstall
I tried to upgrade from 4.01 to 4.03 -apparently I did something wrong and now got a bad server. Anyone can givew advice on how to cleanly unistall now(e.g. rm /usr/bin/mysql*)? linux:/home/db/TMPOUT # rpm -e MySQL-4.0.3-0.i386.rpm error: package MySQL-4.0.3-0.i386.rpm is not installed linux:/home/db/TMPOUT # rpm -i MySQL-4.0.3-0.i386.rpm package MySQL-4.0.3-0 is already installed linux:/home/db/TMPOUT # rpm -e MySQL-4.0.3-0.i386.rpm error: package MySQL-4.0.3-0.i386.rpm is not installed linux:/home/db/TMPOUT # Thanks, S.Alexiou - 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