RE: [cobalt-users] mysql 4 package?

[Arthur Sherman <arturs@xxxxxxxxxxxxxxxx>]

Does it fit to raq4r?

Arthur Sherman
 

> -----Original Message-----
> From: cobalt-users-admin@xxxxxxxxxxxxxxx 
> [mailto:cobalt-users-admin@xxxxxxxxxxxxxxx] On Behalf Of 
> desa15@xxxxxxxx
> Sent: Tuesday, January 20, 2004 17:46
> To: cobalt-users@xxxxxxxxxxxxxxx
> Subject: RE: [cobalt-users] mysql 4 package?
> 
> In first place excuse my very bad English
> 
> 
> Migrate from MySQL 3.23.56-Max to 4.0.16 in a Cobalt Raq 550
> 
> 
> 
>   In first place is very necesary make a backup of the databases
> 
>   cp -r /var/lib/mysql /home/admin/backup_mysql
> 
>   MySQL4 use a diferent system to index the data, make a text 
> file with a
>   data and table structure
> 
>   mysqldump -uroot -ppassword --all databases >
>   /home/admin/backup_mysql/backup.sql
> 
> 
>   mysqladmin -uroot -ppassword shutdown (shutdown database engine)
> 
>   cd /usr/local/download
> 
> 
>   Download the precompiled version, is the best.
> 
>   wget www.mysql.com/Downloads/MySQL-4.0/mysql-4.0.16.tar.gz  
> (is a unreal
>   path)
> 
>   tar zxvf mysql-4.0.16.tar.gz  (decompress)
> 
>   mv mysql-4.0.16 mysql
> 
>   cd mysql
> 
>   #Only if you download the source code version
>   #Begin
> 
>   ./configure --prefix=/usr/local/mysql
>   --with-unix-socket-path=/var/lib/mysql/mysql.sock
>   --with-mysqld-user=mysql
>      make
>      make install
> 
>   #End
> 
>   chown mysql.mysql /usr/local/mysql
> 
>   scripts/mysql_install_db  (install default database)
> 
> 
> 
>   Rename the 3.23.56 binaries to _old
> 
>   for file in *; do mv /usr/local/mysql/bin/$file 
> /usr/bin/$file_old; done
> 
>   Make the links to the new binaries
> 
>   for file in *; do ln -s /usr/local/mysql/bin/$file 
> /usr/bin/$file; done
> 
>   chown -R mysql.mysql /var/lib/mysql
> 
>   chmod 755 /var/lib/mysql
> 
> 
>   Start the new engine
> 
>   /usr/local/mysql/bin/safe_mysqld &
> 
>   Press Ctrl + C
> 
>   Copy the new start script
> 
>   cp support-files/mysql.server /etc/rc.d/init.d/mysql
> 
> 
>   vi /etc/init.d/mysql
> 
>   #Paths to modify only for cobalt
> 
>   
> --------------------------------------------------------------
> ---------------
>   basedir=
> 
>   # The following variables are only set for letting mysql.server find
>   things.
> 
>   # Set some defaults
>   datadir=/var/lib/mysql
>   pid_file=
>   if test -z "$basedir"
>   then
>     basedir=/
>     bindir=/usr/bin
>   else
>     bindir="$basedir/bin"
>   fi
> 
>   PATH=/sbin:/usr/sbin:/bin:/usr/bin:$basedir/bin
>   export PATH
> 
>   
> --------------------------------------------------------------
> ---------------
> 
>   chkconfig --level 3 mysql on
> 
>   chkconfig --level 0 mysql off
> 
> 
>   My /etc/my.cnf (some keys has changed in the new version)
> 
> 
>   [client]
>   user=mysql
>   port            = 3306
>   socket          = /var/lib/mysql/mysql.sock
> 
>   [mysqld]
>   port            = 3306
>   socket          =/var/lib/mysql/mysql.sock
>   datadir         =/var/lib/mysql
>   skip-locking
> 
>   set-variable      = max_connections=250
>   set-variable      = key_buffer=64M
>   set-variable      = max_allowed_packet=1M
>   set-variable      = table_cache=256
> 
>   #BEGIN MySQL 4.01
>   set-variable      = sort_buffer_size=1M
>   set-variable      = read_buffer_size=1M
>   thread_cache = 8
>   query_cache_size= 16M
>   thread_concurrency = 8
>   #END Mysql 4.01
> 
>   set-variable      = net_buffer_length=8K
>   set-variable      = myisam_sort_buffer_size=32M
>   set-variable      = wait_timeout=14400
>   set-variable      = connect_timeout=10
>   set-variable      = max_connect_errors=10
> 
>   #Desactivamos los logs porque lo unico que hacen es ocupar
>   #log-bin
>   #log
>   server-id       = 1
>   skip-innodb
> 
> 
> 
>   Un saludo, Danny
> 
> 
> _____________________________________
> cobalt-users mailing list
> cobalt-users@xxxxxxxxxxxxxxx
> To subscribe/unsubscribe, or to SEARCH THE ARCHIVES, go to:
> http://list.cobalt.com/mailman/listinfo/cobalt-users
>