MySQL Backup and recovery

Prelude:

It is recommended that you use the RPM package in Linux to install MySQL. MySQL rpm is now embedded in the SUSE Linux 7.3 system, but should be able to work in most versions of Linux that support RPM and use glibc.

MySQL AB does not provide a specific platform-related RPM; the difference between the specific platform-related rpm and the common RPM is the specific platform-related RPM built for the target platform, for dynamic connectivity. Universal RPM is a static connection with Linux threads.

Note: MySQL's RPM distribution is typically provided by other vendors. Unlike MySQL AB, the instructions in this manual are not necessarily suitable for installing MySQL's RPM distributions provided by other vendors. The vendor's instructions should be consulted at this time.

If there is a problem with the RPM file (for example, if you receive the error "Sorry", the host ' xxxx ' could ' is looked up ").

In most cases, you only need to install Mysql-server and mysql-client packages to install MySQL. No other packages are required in a standard installation. If you want to run a more versatile Mysql-max server, you should also install Mysql-max RPM. You must install the M mysql-server rpm before installing the module.

If a subordinate error occurs when installing the MySQL package (for example, "error:removing these packages would break dependencies:libmysqlclient.so.10 are needed by ..."), you You should also install package Mysql-shared-compat, which includes two backward-compatible shared libraries (MySQL 4.0 is Libmysqlclient.so.12,mysql 3.23 is libmysqlclient.so.10).

Many Linux distributions include MySQL 3.23, which typically dynamically connects applications to save hard disk space. If these shared libraries are in a separate package (for example, mysql-shared), simply install the packages and upgrade the MySQL server and client packages (for static connections and not for shared libraries). For distributions that contain shared libraries in the same package as the MySQL server (for example, Red Hat Linux), you can install 3.23 mysql-shared RPM, or use the Mysql-shared-compat package.

The following RPM packages are available:

mysql-server-version.i386.rpm

MySQL server. You need this option unless you only want to connect to a MySQL server running on another machine. Note: Before MySQL 4.0.10, the server rpm file is called mysql-version.i386.rpm. In other words, the name does not contain-server.

mysql-max-version.i386.rpm

Mysql-max server. The server has other features that mysql-server RPM does not have. You must first install mysql-server rpm, because Mysql-max rpm depends on it.

mysql-client-version.i386.rpm

Standard MySQL client program. You may always want to install the package.

mysql-bench-version.i386.rpm

Tests and benchmarks. Perl and Dbd::mysql modules are required.

mysql-devel-version.i386.rpm

Libraries and include files, if you want to compile other MySQL clients, such as Perl modules, you need.

mysql-shared-version.i386.rpm

This package contains the shared libraries (libmysqlclient.so*) that some languages and applications need to dynamically load, using MySQL.

mysql-shared-compat-version.i386.rpm

The package includes a shared library of MySQL 3.23 and MySQL 4.0. If you install the application dynamically connected to MySQL 3.23, but you want to upgrade to MySQL 4.0 instead of breaking the library dependencies, install the package instead of installing mysql-shared. Include the installation package from MySQL 4.0.13.

mysql-embedded-version.i386.rpm

Embedded MySQL server library (from MySQL 4.0).

mysql-version.src.rpm

Contains the source code of all previous packages. Can be used to reconstruct rpm (for example, Alpha or SPARC) on other architectures.

To see all the files within the RPM package (for example, Mysql-server rpm), run:

Shell> RPM-QPL mysql-server-version.i386.rpm

To perform a standard minimum installation, run:

Shell> rpm-i mysql-server-version.i386.rpm

Shell> rpm-i mysql-client-version.i386.rpm

To install only the client package, run:

Shell> rpm-i mysql-client-version.i386.rpm