Installer une base de données SQL (MySQL)



Logiciels

MySQL

MySQL
www.mysql.com

MySQL 3.22.27 -- 07 octobre 1999, 3910ko (.tar.gz)

"MySQL is a true multi-user, multi-threaded SQL database server. SQL is the most popular database language in the world. MySQL is a client/server implementation that consists of a server daemon mysqld and many different client programs and libraries.
SQL is a standardized language that makes it easy to store, update and access information. For example, you can use SQL to retrieve product information and store customer information for a web site. MySQL is also fast and flexible enough to allow you to store logs and pictures in it.
The main goals of MySQL are speed, robustness and ease of use. MySQL was originally developed because we at TcX needed a SQL server that could handle very large databases an order of magnitude faster than what any database vendor could offer to us. We have now been using MySQL since 1996 in an environment with more than 40 databases containing 10,000 tables, of which more than 500 have more than 7 million rows. This is about 100 gigabytes of mission-critical 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. Although MySQL is still under development, it already offers a rich and highly useful function set.
The official way to pronounce MySQL is ``My Ess Que Ell'' (Not MY-SEQUEL)."

MySQL est un serveur de base de données SQL (Structured Query Language). SQL est le langage d'accès au base de données le plus populaire dans le monde. MySQL est une implémentation client/serveur qui consiste en un serveur démon mysqld et plusieurs programmes ou bibliothèes clients différents.

Installation

$ cd /opt
$ lynx ftp://ftp.mysql.com/.../mysql-3.22.26a-pc-linux-gnu-i686.tar.gz
$ tar xvzf mysql-3.22.26a-pc-linux-gnu-i686.tar.gz
$ ln -sf mysql-3.22.26a-pc-linux-gnu-i686 mysql
$ ln -sf /opt/mysql/lib /usr/local/lib/mysql
$ ln -sf /opt/mysql/include /usl/local/include/mysql
$ cd mysql
Éditez bin/mysqlaccess pour modifiez les chemin d'acces (lignes 18, 34 et 35).
$ scripts/mysql_install_db
$ bin/safe_mysqld &
Mettez un mot de passe à l'utilisateur root de mysql :
$ bin/mysqladmin -u root password 'new-password'
Copiez support-files/mysql.server, aprés avoir modifier la ligne 16 et 18 pour refléter le chemin d'installation de mysql, à la bonne place pour lancer mysql au démarrage du système.
Installer Perl
$ lynx Data-Dumper-2.09.tar.gz
$ tar xvzf Data-Dumper-2.09.tar.gz
$ cd Data-Dumper-2.09
$ perl Makefile.PL
$ make
$ make test
$ make install
$ cd ..
$ rm -rf Data-Dumper-2.09
$ lynx DBI-1.06.tar.gz
$ tar xvzf DBI-1.06.tar.gz
$ cd DBI-1.06
$ perl Makefile.PL
$ make
$ make test
$ make install
$ cd ..
$ rm -rf DBI-1.06
$ lynx Msql-Mysql-modules-1.2017.tar.gz
$ tar xvzf Msql-Mysql-modules-1.2017.tar.gz
$ cd Msql-Mysql-modules-1.2017
$ perl Makefile.PL
$ make
$ make test
$ make install
$ cd ..
$ rm -rf Msql-Mysql-modules-1.2017

Administration

phpMyAdmin
phpMyadmin 2.0.4 -- 10 octobre 1999, 56ko (.tar.gz), 75ko (.zip)
phpMyAdmin is a tool written in PHP3 intended to handle the adminstration of MySQL over the WWW. Currently it can create and drop databases, create/drop/alter tables, delete/edit/add fields, execute any SQL-statement, manage keys on fields, create dumps of tables and databases, export/import CSV data and adminstrate one single database and multiple MySQL servers.

MyAdmin 0.2 13 janvier 1999
MyAdmin is a web cgi written in perl to fully administer the MySQL database. This script will support SQL interface, imports and export via the web interface and eventually the mysql privilage system. The current release is intended for testers but has proven to be quite stable. It can administrate any database on any server that the cgi host has permissions to connect.

Interface avec le serveur Web (PHP)

PHPPHP: Hypertext Preprocessor
php 3.0.12 -- , 05 août 1999 1813ko (.tar.gz)
php 4.0b2 -- , 1344ko (.tar.gz)
PHP 3.0 is an HTML-embedded scripting language. Much of its syntax is borrowed from C, Java and Perl with a couple of unique PHP-specific features thrown in. The goal of the language is to allow web developers to write dynamically generated pages quickly.

ZendZend Engine announced - January 04th 1999
Two members of the core PHP development team have announced Zend, a new engine for the popular PHP server-side scripting language for Internet applications. Advantages to Web developers include an up to one hundred-fold increase in speed and the ability to distribute scripts without revealing source code. The press release is available here.

www-sql 0.5.7 -- 21 janvier 1999
www-sql is able to display information from MySQL or PostgreSQL databases in web pages. It does this with a simple embedded scripting language. The commands are embedded in special HTML tags, so it should be possible to edit the document with an HTML editor. The tags are evaluated when the page is loaded, so the resultant page will be HTML compliant.

asp2php 0.67 -- 6 avril 1999
asp2php converts WWW Active Server Pages (ASP) files that run on the Microsoft IIS Web Server into PHP3 pages to run on Apache.
Changes:Fixed a bug in the parser/scanner for quoted strings.

class.Validator.php3 1.0 -- 6 février 1999
Validator is a class containing common data validation and string and array manipulation functions. Validation routines include is_email(), is_zip(), is_phone(), etc.
Changes: Initial Public Release

Compilez et Installez PHP

$ lynx ftp://ftp.php.net/.../php-3.0.7.tar.gz
$ tar xvzf php-3.0.7.tar.gz
$ cd php-3.0.7
$ CFLAGS='-O2 -s -march=pentiumpro' ./configure \
	--with-apxs=/usr/local/apache/bin/apxs \
	--with-config-file-path=/usr/local/apache/conf \
	--with-mod-dav=/usr/local/apache/libexec --with-xml --with-mysql \
	--with-imap --with-ldap --with-zlib
$ make
$ make install
$ cd ..
$ rm -rf php-3.0.7

Interface avec les autres bases de données (JDBC et ODBC)

MM.MySQL 1.1i -- 1 avril 1999
MM.MYSQL is a JDBC driver for the MySQL database. It implements all of the JDBC spec that can be implemented for MySQL, and offers high performance and stability. More information is available at the homepage.

twz1jdbcForMysql 1.0.4-GA -- 1 avril 1999
twz1jdbcForMysql (aka tjFM) is a type 4 JDBC driver for TcX's MySQL database. It has numerous initialization options settable by URL parameter, passed Properties or a properties file (for applications). It can cache query results to memory (default), disk (applications only) or not cache at all at the user's option. It handles insertion (through PreparedStatement) and retrieval of binary objects (blobs) and is delivered with source.
Changes: Several small fixes.


Christophe Merlet
redfox@redfoxcenter.org
©Tous droits réservés
11 octobre 1999