%define mysql_version 3.23.42 %define shared_lib_version 10:0:0 %define release 1 %define mysqld_user mysql %define see_base For a description of MySQL see the base MySQL RPM or http://www.mysql.com Name: MySQL Summary: A very fast and reliable SQL database engine Group: Applications/Databases Summary(pt_BR): Um servidor SQL rápido e confiável. Group(pt_BR): Aplicações/Banco_de_Dados Version: %{mysql_version} Release: %{release} Copyright: GPL / LGPL Source: http://www.mysql.com/Downloads/MySQL-3.23/mysql-%{mysql_version}.tar.gz Icon: mysql.gif URL: http://www.mysql.com/ Provides: msqlormysql MySQL-server Obsoletes: mysql Prefix: %{_prefix} # Think about what you use here since the first step is to # run a rm -rf BuildRoot: /var/tmp/mysql-root %ifarch ia64 %define stdlib lib/ia64l32 %define stdlib64 lib/ia64l64 %define liblink ../../.. %else %define stdlib lib %define liblink ../.. %endif # From the manual %description MySQL is a true multi-user, multi-threaded SQL (Structured Query Language) database server. MySQL is a client/server implementation that consists of a server daemon (mysqld) and many different client programs/libraries. The main goals of MySQL are speed, robustness and ease of use. MySQL was originally developed because we needed a SQL server that could handle very big databases with magnitude higher speed than what any database vendor could offer to us. And since we did not need all the features that made their server slow we made our own. We have now been using MySQL since 1996 in a environment with more than 40 databases, 10,000 tables, of which more than 500 have more than 7 million rows. This is about 200G of data. The base upon which MySQL is built is a set of routines that have been used in a highly demanding production environment for many years. While MySQL is still in development, it already offers a rich and highly useful function set. See the documentation for more information %description -l pt_BR O MySQL é um servidor de banco de dados SQL realmente multiusuário e\ multi-tarefa. A linguagem SQL é a mais popular linguagem para banco de\ dados no mundo. O MySQL é uma implementação cliente/servidor que\ consiste de um servidor chamado mysqld e diversos\ programas/bibliotecas clientes. Os principais objetivos do MySQL são:\ velocidade, robustez e facilidade de uso. O MySQL foi originalmente\ desenvolvido porque nós na Tcx precisávamos de um servidor SQL que\ pudesse lidar com grandes bases de dados e com uma velocidade muito\ maior do que a que qualquer vendedor podia nos oferecer. Estamos\ usando\ o MySQL desde 1996 em um ambiente com mais de 40 bases de dados com 10.000\ tabelas, das quais mais de 500 têm mais de 7 milhões de linhas. Isto é o\ equivalente a aproximadamente 50G de dados críticos. A base da construção do\ MySQL é uma série de rotinas que foram usadas em um ambiente de produção com\ alta demanda por muitos anos. Mesmo o MySQL estando ainda em desenvolvimento,\ ele já oferece um conjunto de funções muito ricas e úteis. Veja a documentação\ para maiores informações. %package client Release: %{release} Summary: MySQL - Client Group: Applications/Databases Summary(pt_BR): MySQL - Cliente Group(pt_BR): Aplicações/Banco_de_Dados Obsoletes: mysql-client %description client This package contains the standard MySQL clients. %{see_base} %description client -l pt_BR Este pacote contém os clientes padrão para o MySQL. %package bench Release: %{release} Requires: MySQL-client perl Summary: MySQL - Benchmarks and test system Group: Applications/Databases Summary(pt_BR): MySQL - Medições de desempenho Group(pt_BR): Aplicações/Banco_de_Dados Obsoletes: mysql-bench %description bench This package contains MySQL benchmark scripts and data. %{see_base} %description bench -l pt_BR Este pacote contém medições de desempenho de scripts e dados do MySQL. %package devel Release: %{release} Requires: MySQL-client Summary: MySQL - Development header files and libraries Group: Applications/Databases Summary(pt_BR): MySQL - Medições de desempenho Group(pt_BR): Aplicações/Banco_de_Dados Obsoletes: mysql-devel %description devel This package contains the development header files and libraries necessary to develop MySQL client applications. %{see_base} %description devel -l pt_BR Este pacote contém os arquivos de cabeçalho (header files) e bibliotecas necessárias para desenvolver aplicações clientes do MySQL. %prep %setup -q -n mysql-%{mysql_version} %build RBR=$RPM_BUILD_ROOT MBD=$RPM_BUILD_DIR/mysql-%{mysql_version} rm -rf $RBR mkdir -p $RBR libtoolize --force export CC="gcc -pipe -Wa,-many" export CXX="gcc -pipe -Wa,-many" export CXXFLAGS="-felide-constructors -fno-exceptions -fno-rtti" ./configure --prefix=%{prefix} --enable-shared --enable-thread-safe-client \ --enable-large-files --with-low-memory --datadir=%{prefix}/share \ --localstatedir=/var/lib/mysql --infodir=%{prefix}/info \ --mandir=%{prefix}/man --libexecdir=%{prefix}/libexec # And now we build it all make # Save manual to avoid rebuilding %ifos skip_this mv Docs/manual.ps Docs/manual.ps.save make distclean mv Docs/manual.ps.save Docs/manual.ps %endif %install -n mysql-%{mysql_version} RBR=$RPM_BUILD_ROOT MBD=$RPM_BUILD_DIR/mysql-%{mysql_version} # Ensure that needed directories exists install -d $RBR/etc/logrotate.d install -d $RBR/etc/rc.d/init.d install -d $RBR/var/lib/mysql/mysql install -d $RBR%{prefix}/share/sql-bench install -d $RBR%{prefix}/share/mysql-test install -d $RBR%{prefix}/libexec install -d $RBR%{prefix}/share install -d $RBR%{prefix}/man install -d $RBR%{prefix}/include install -d $RBR%{prefix}/doc/MySQL-%{mysql_version} install -d $RBR%{prefix}/lib install -d $RBR%{prefix}/info # Make install make install DESTDIR=$RBR benchdir_root=%{prefix}/share/ # Install logrotate and autostart install -m644 $MBD/support-files/mysql-log-rotate $RBR/etc/logrotate.d/mysql install -m755 $MBD/support-files/mysql.server $RBR/etc/rc.d/init.d/mysql # Install docs install -m644 $RPM_BUILD_DIR/mysql-%{mysql_version}/Docs/mysql.info \ $RBR/%{prefix}/info/mysql.info for file in README COPYING COPYING.LIB Docs/manual_toc.html Docs/manual.html \ Docs/manual.txt Docs/manual.texi Docs/manual.ps \ support-files/my-huge.cnf support-files/my-large.cnf \ support-files/my-medium.cnf support-files/my-small.cnf do b=`basename $file` install -m644 $MBD/$file $RBR/%{prefix}/doc/MySQL-%{mysql_version}/$b done # Save some space... strip $RPM_BUILD_ROOT%{prefix}/bin/* || : ( cd $RPM_BUILD_ROOT mkdir -p usr/bin cd usr/bin ln -sf ../..%{prefix}/bin/* . cd - mkdir -p usr/include/mysql cd usr/include/mysql ln -sf ../../..%{prefix}/include/mysql/* . cd - mkdir -p usr/%{stdlib}/mysql cd usr/%{stdlib}/mysql ln -sf ../%{liblink}%{prefix}/lib/mysql/* . cd - ) %pre if test -x /etc/rc.d/init.d/mysql then /etc/rc.d/init.d/mysql stop > /dev/null 2>&1 echo "Giving mysqld a couple of seconds to exit nicely" sleep 5 fi %post mysql_datadir=/var/lib/mysql # Create data directory if needed if test ! -d $mysql_datadir; then mkdir $mysql_datadir; fi if test ! -d $mysql_datadir/mysql; then mkdir $mysql_datadir/mysql; fi if test ! -d $mysql_datadir/test; then mkdir $mysql_datadir/test; fi %ifos linux # Make MySQL start/shutdown automatically when the machine does it. /sbin/chkconfig --add mysql # Create a MySQL user. Do not report any problems if it already # exists. This is redhat specific and should be handled more portable useradd -M -r -d $mysql_datadir -s /bin/bash -c "MySQL server" mysql 2> /dev/null || true %else mkuser -a home=$mysql_datadir gecos="MySQL server" mysql 2>/dev/null || true %endif # Change permissions so that the user that will run the MySQL daemon # owns all database files. chown -R mysql $mysql_datadir # Initiate databases mysql_install_db -IN-RPM --ldata=$mysql_datadir # Change permissions again to fix any new files. chown -R mysql $mysql_datadir # Fix permissions for the permission database so that only the user # can read them. chmod -R og-rw $mysql_datadir/mysql # Restart in the same way that mysqld will be started normally. /etc/rc.d/init.d/mysql start # Allow safe_mysqld to start mysqld and print a message before we exit sleep 2 %preun if test -x /etc/rc.d/init.d/mysql then /etc/rc.d/init.d/mysql stop > /dev/null fi %ifos linux # Remove autostart of mysql if test $1 = 0 then /sbin/chkconfig --del mysql fi # We do not remove the mysql user since it may still own a lot of # database files. %endif %files %attr(-, root, system) %doc %{prefix}/doc/MySQL-%{mysql_version}/ %attr(755, root, system) %{prefix}/bin/isamchk %attr(755, root, system) %{prefix}/bin/isamlog %attr(755, root, system) %{prefix}/bin/pack_isam %attr(755, root, system) %{prefix}/bin/myisamchk %attr(755, root, system) %{prefix}/bin/myisamlog %attr(755, root, system) %{prefix}/bin/myisampack %attr(755, root, system) %{prefix}/bin/mysql_fix_privilege_tables %attr(755, root, system) %{prefix}/bin/mysql_convert_table_format %attr(755, root, system) %{prefix}/bin/mysql_install_db %attr(755, root, system) %{prefix}/bin/mysql_setpermission %attr(755, root, system) %{prefix}/bin/mysql_zap %attr(755, root, system) %{prefix}/bin/mysqlbug %attr(755, root, system) %{prefix}/bin/mysqltest %attr(755, root, system) %{prefix}/bin/mysqlhotcopy %attr(755, root, system) %{prefix}/bin/perror %attr(755, root, system) %{prefix}/bin/replace %attr(755, root, system) %{prefix}/bin/resolveip %attr(755, root, system) %{prefix}/bin/safe_mysqld %attr(755, root, system) %{prefix}/bin/mysqld_multi %attr(755, root, system) %{prefix}/bin/my_print_defaults %attr(755, root, system) /usr/bin/isamchk %attr(755, root, system) /usr/bin/isamlog %attr(755, root, system) /usr/bin/pack_isam %attr(755, root, system) /usr/bin/myisamchk %attr(755, root, system) /usr/bin/myisamlog %attr(755, root, system) /usr/bin/myisampack %attr(755, root, system) /usr/bin/mysql_fix_privilege_tables %attr(755, root, system) /usr/bin/mysql_convert_table_format %attr(755, root, system) /usr/bin/mysql_install_db %attr(755, root, system) /usr/bin/mysql_setpermission %attr(755, root, system) /usr/bin/mysql_zap %attr(755, root, system) /usr/bin/mysqlbug %attr(755, root, system) /usr/bin/mysqltest %attr(755, root, system) /usr/bin/mysqlhotcopy %attr(755, root, system) /usr/bin/perror %attr(755, root, system) /usr/bin/replace %attr(755, root, system) /usr/bin/resolveip %attr(755, root, system) /usr/bin/safe_mysqld %attr(755, root, system) /usr/bin/mysqld_multi %attr(755, root, system) /usr/bin/my_print_defaults %attr(644, root, system) %{prefix}/info/mysql.info* %attr(755, root, system) %{prefix}/libexec/mysqld %attr(644, root, system) /etc/logrotate.d/mysql %attr(755, root, system) /etc/rc.d/init.d/mysql %attr(755, root, system) %{prefix}/share/mysql/ %files client %attr(755, root, system) %{prefix}/bin/msql2mysql %attr(755, root, system) %{prefix}/bin/mysql %attr(755, root, system) %{prefix}/bin/mysqlaccess %attr(755, root, system) %{prefix}/bin/mysqladmin %attr(755, root, system) %{prefix}/bin/mysql_find_rows %attr(755, root, system) %{prefix}/bin/mysqldump %attr(755, root, system) %{prefix}/bin/mysqlimport %attr(755, root, system) %{prefix}/bin/mysqlshow %attr(755, root, system) %{prefix}/bin/mysqlbinlog %attr(755, root, system) %{prefix}/lib/mysql/libmysqlclient.a %attr(755, root, system) %{prefix}/lib/mysql/libmysqlclient_r.a %attr(755, root, system) /usr/bin/msql2mysql %attr(755, root, system) /usr/bin/mysql %attr(755, root, system) /usr/bin/mysqlaccess %attr(755, root, system) /usr/bin/mysqladmin %attr(755, root, system) /usr/bin/mysql_find_rows %attr(755, root, system) /usr/bin/mysqldump %attr(755, root, system) /usr/bin/mysqlimport %attr(755, root, system) /usr/bin/mysqlshow %attr(755, root, system) /usr/bin/mysqlbinlog %attr(755, root, system) /usr/lib/mysql/libmysqlclient.a %attr(755, root, system) /usr/lib/mysql/libmysqlclient_r.a %attr(644, root, system) %doc %{prefix}/man/man1/mysql.1* %attr(644, root, system) %doc %{prefix}/man/man1/isamchk.1* %attr(644, root, system) %doc %{prefix}/man/man1/isamlog.1* %attr(644, root, system) %doc %{prefix}/man/man1/mysql_zap.1* %attr(644, root, system) %doc %{prefix}/man/man1/mysqlaccess.1* %attr(644, root, system) %doc %{prefix}/man/man1/mysqladmin.1* %attr(644, root, system) %doc %{prefix}/man/man1/mysqld.1* %attr(644, root, system) %doc %{prefix}/man/man1/mysqld_multi.1* %attr(644, root, system) %doc %{prefix}/man/man1/mysqldump.1* %attr(644, root, system) %doc %{prefix}/man/man1/mysqlshow.1* %attr(644, root, system) %doc %{prefix}/man/man1/perror.1* %attr(644, root, system) %doc %{prefix}/man/man1/replace.1* %attr(644, root, system) %doc %{prefix}/man/man1/safe_mysqld.1* %files devel %attr(755, root, system) %{prefix}/bin/comp_err %attr(755, root, system) %{prefix}/bin/mysql_config %attr(755, root, system) %{prefix}/include/mysql/ %attr(755, root, system) %{prefix}/lib/mysql/libdbug.a %attr(755, root, system) %{prefix}/lib/mysql/libheap.a %attr(755, root, system) %{prefix}/lib/mysql/libmerge.a %attr(755, root, system) %{prefix}/lib/mysql/libmyisam.a %attr(755, root, system) %{prefix}/lib/mysql/libmyisammrg.a %attr(755, root, system) %{prefix}/lib/mysql/libmystrings.a %attr(755, root, system) %{prefix}/lib/mysql/libmysys.a %attr(755, root, system) %{prefix}/lib/mysql/libnisam.a %attr(755, root, system) /usr/bin/comp_err %attr(755, root, system) /usr/bin/mysql_config %attr(755, root, system) /usr/include/mysql/ %attr(755, root, system) /usr/lib/mysql/libdbug.a %attr(755, root, system) /usr/lib/mysql/libheap.a %attr(755, root, system) /usr/lib/mysql/libmerge.a %attr(755, root, system) /usr/lib/mysql/libmyisam.a %attr(755, root, system) /usr/lib/mysql/libmyisammrg.a %attr(755, root, system) /usr/lib/mysql/libmystrings.a %attr(755, root, system) /usr/lib/mysql/libmysys.a %attr(755, root, system) /usr/lib/mysql/libnisam.a %attr(755, root, system) %{prefix}/lib/mysql/*.la %attr(755, root, system) /usr/lib/mysql/*.la %files bench %attr(-, root, system) %{prefix}/share/sql-bench %attr(-, root, system) %{prefix}/share/mysql-test %changelog * Wed Sep 12 2001 David Clissold - Update to level 3.23.42 * Wed Jul 11 2001 David Clissold - Initial build for AIX Toolbox * Tue Jan 2 2001 Monty - Added mysql-test to the bench package * Fri Aug 18 2000 Tim Smith - Added separate libmysql_r directory; now both a threaded and non-threaded library is shipped. * Wed Sep 28 1999 David Axmark - Added the support-files/my-example.cnf to the docs directory. - Removed devel dependency on base since it is about client development. * Wed Sep 8 1999 David Axmark - Cleaned up some for 3.23. * Thu Jul 1 1999 David Axmark - Added support for shared libraries in a separate sub package. Original fix by David Fox (dsfox@cogsci.ucsd.edu) - The --enable-assembler switch is now automatically disables on platforms there assembler code is unavailable. This should allow building this RPM on non i386 systems. * Mon Feb 22 1999 David Axmark - Removed unportable cc switches from the spec file. The defaults can now be overridden with environment variables. This feature is used to compile the official RPM with optimal (but compiler version specific) switches. - Removed the repetitive description parts for the sub rpms. Maybe add again if RPM gets a multiline macro capability. - Added support for a pt_BR translation. Translation contributed by Jorge Godoy . * Wed Nov 4 1998 David Axmark - A lot of changes in all the rpm and install scripts. This may even be a working RPM :-) * Sun Aug 16 1998 David Axmark - A developers changelog for MySQL is available in the source RPM. And there is a history of major user visible changed in the Reference Manual. Only RPM specific changes will be documented here.