# Copyright (C) 2002 Stephane SCHILDKNECHT <dbadialog@free.fr>
#
# This file is part of dba-dialog.
#
# dba-dialog is free software; you can redistribute it and/or modify
# it under the terms of the GNU General Public License as published by
# the Free Software Foundation; either version 2 of the License, or
# (at your option) any later version.
#
# dba-dialog is distributed in the hope that it will be useful,
# but WITHOUT ANY WARRANTY; without even the implied warranty of
# MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE. See the
# GNU General Public License for more details.
#
# You should have received a copy of the GNU General Public License
# along with dba-dialog; if not, write to the Free Software
Foundation, Inc., 59 Temple Place, Suite 330, Boston, MA 02111-1307 USA
SAS 28.05.2002
####################################################### # Pour une version française du README, voir plus bas # #######################################################
DBA-DIALOG is a 'dialog' interface intended to facilitate installation and administration of databases. It should allow one to create a database, the tables and to populate them. Of course, it is also easy to drop everything.
To use DBA-DIALOG, just untar the package and launch it by typing : ./dba-dialog [-x for X mode]
You may also launch it precising the database, the user, host and port like that : ./dba-dialog [-x for X Mode] -u <username> -h <hostname> -p <port> -d <database_name>
You may also choose the server by adding -P|--postgresql, -O|--oracle -M|--mysql, -D|--db2. But, today, only a part of mysql and a bigger part of postgresql are developped.
The menus are self-explanotory (in french it is)...
################
# Console mode #
################
The scripts must be read in the following order:
To create and populate the database:
A script must exist in that directory named <database_name>.sql which contains the tables definitions.
1. ./creation_base.sh <database_name> [-h <host> -p <port>] [-d 'My pretty database description' (postgresql specific part)]
To populate the tables:
The scripts in the specific database directory must be precised at bottom of the script pop_stat.sh.
I should change that script so that the user may precise in the dba-dialog the script he wants to
be read.
2. ./pop_stat.sh <batabase_name> [-h <host> -p <port>]
To drop a database:
./suppression_base.sh <database_name> [-h <host> -p <port>]
############################################################################# # Installation complete et graphique # # Pour installer la base en mode shell, suivre la deuxième partie du README # #############################################################################
Une interface 'dialog' a été conçue pour faciliter l'installation des
bases.
Elle permet de piloter la création de base, des tables associees et de les peupler.
Pour cela, rien de plus simple, lancer
./dba-dialog [-x pour le mode X]
Les menus sont suffisamment explicites, je pense.
################
# Mode console #
################
Pour créer la base et la peupler
Lancer les scripts dans l'ordre suivant :
- ./creation_base.sh <nom_base> Il est possible de passer en argument le serveur ou la base doit etre installee et le port, ainsi qu'un commentaire decrivant la base ce qui donne par exemple
./creation_base.sh <DB_name> -h pipo -p 1234 -d 'Mon commentaire à moi'
2. ./pop_stat.sh <DB_name>
Les arguments sont les memes au commentaire pres
soit par exemple :
./pop_stat.sh <DB_name> -h pipo -p 1234
3. ./pop_test.sh <DB_name>
Les arguments sont les memes au commentaire pres
soit par exemple :
./pop_test.sh <DB_name> -h pipo -p 1234
############################################################# Pour supprimer totalement une base, utiliser le script ./suppression_base.sh <DB_name>
avec les arguments -h pour le host, -p pour le port