#
# ***************************************************************************************************
#
# File name: parameters.txt
#
# Copyright © 2017 Alessandro Quintiliani
#
# This file is part of MultiDump package.
#
# MultiDump 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 3 of the License, or
# (at your option) any later version.
#
# MultiDump 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 MultiDump package. If not, see <http://www.gnu.org/licenses/>.
#
# ***************************************************************************************************
# NOTE ABOUT THIS FILE
# this file contains parameters used by the class MultiDump. Read carefully the following rules to configure this file properly
#
# - each line must contain a row written in the format <parameter name>=<value>
# (the blanks near the '=' or at the beginning or end of the row do not affect the procedure at all)
# other formats will be ignored by the procedure
#
# - prepend hash (#) at any row you want to comment ('#' must be the first character of the row you choose to comment); you can comment only the rows
# containing the word FACULTATIVE in the heading comment
#
# - you can leave empty rows between the rows
#
# - wherever a group of parameters has an heading comment containing DO NOT EDIT THE VALUE(S) it means that you cannot modify their values
#
# - some of the parameters included in this file are referred to mysql database. If you also want to dump other database type
# (oracle, postGreSql, etc..) follow the rules written in the section ### GROUP OF DUMP OPTIONS AND QUERIES ###
### GROUP OF FOLDERS ###
# folder_dump_files: name of the folder containing the files each with a dumped table. You can also define an absolute or relative path with
# both slashes or backslashes as a directory separator. Set the writing permission properly
folder_dump_files=dumpsql
### GROUP OF DB TYPE QUERIES ###
# NOTICE: THE FOLLOWING GROUPS REFER TO MYSQL DATABASE, BUT YOU CAN ADD AS MANY GROUPS AS MANY DIFFERENT TYPES OF DATABASE YOU WANT TO DUMP #
# dump_mysql_query_show_tables: this parameter refers to a mysql query which results in a list of tables from a
# database without those excluded from dump, if any. DO NOT EDIT THIS QUERY
dump_mysql_query_show_tables=SHOW FULL TABLES FROM @@@database.name@@@ WHERE Table_Type = 'BASE TABLE' AND tables_in_@@@database.name@@@ NOT IN (@@@excluded.tables.name@@@)
# dump_mysql_query_checksum: this parameter refers to a mysql query producing the checksum from a table. DO NOT EDIT THIS QUERY
dump_mysql_query_checksum=CHECKSUM TABLE @@@database.name@@@.`@@@table.name@@@`
# dump_mysql_query_engine_db: this parameter refers to a mysql query which results in the engine of a database. DO NOT EDIT THIS QUERY
dump_mysql_query_engine_db=SELECT DISTINCT ENGINE FROM information_schema.TABLES WHERE TABLE_SCHEMA='@@@database.name@@@'
# dump_mysql_query_engine_table: this parameter refers to a mysql query which results in the engine of a table. DO NOT EDIT THIS QUERY
dump_mysql_query_engine_table=SELECT ENGINE FROM information_schema.TABLES WHERE TABLE_SCHEMA = '@@@database.name@@@' AND TABLE_NAME = '@@@table.name@@@'
### GROUP OF DUMP COMMAND LINE OPTIONS ###
# dump_type: this parameter refers to the database type you want to dump. ACCORDING TO THE DATABASE ONLY THE FOLLOWING VALUES ARE ALLOWED:
#
# mysql (for MySQL database)
#
# postgresql (for PostGreSQL database)
#
# If you want to dump a type of database such as those from the above list:
# - add a group of dump_<value of dump_type>_xxx parameters (the parameters to add are accordingly to the native command and options defined in the database type)
# - the value of dump_type must be one-word only and all written in lowercase, no hyphens, no underscores, no blank spaces between words
# (i.e MySQL --> dump_type=mysql; PostGreSQL --> dump_type=postgresql, etc..)
# the value of dump_type is found in the other parameters, starting in the format dump_<value of dump_type>_...; if you
# accidentally leave the name in uppercase or Camelcase (i.e.: Postgresql or PostGreSql) the whole dump procedure does not work
#
dump_type=mysql
# dump_mysql_option_command_storage_engine_myisam: this parameter refers to the native option command for one of the
# mysql storage engines table to dump. FACULTATIVE ACCORDINGLY TO THE DATABASE TYPE
dump_mysql_option_command_storage_engine_myisam=--lock-tables=TRUE
# dump_mysql_option_command_storage_engine_innodb: this parameter refers to the native option command for one of the
# mysql storage engines table to dump. FACULTATIVE ACCORDINGLY TO THE DATABASE TYPE
dump_mysql_option_command_storage_engine_innodb=--single-transaction
# dump_mysql_option_command_host: this parameter refers to the native dump command option for the host (or IP) where the mysql database to dump is installed
dump_mysql_option_command_host=-h
# dump_mysql_option_command_port: this parameter refers to the native dump command option for the port where the
# mysql database server is listening. FACULTATIVE IF THE PORT IS THE DEFAULT PORT FOR EACH DATABASE TO DUMP
dump_mysql_option_command_port=-P
# dump_mysql_option_command_user: this parameter refers to the native dump command option for the access username to the mysql database to dump
dump_mysql_option_command_user=-u
# dump_mysql_option_command_password: this parameter refers to the native dump command option for the access password to the mysql database to dump
dump_mysql_option_command_password=-p
dump_type=postgresql
# dump_postgresql_option_command_host: this parameter refers to the native dump command option for the host (or IP) where the postgresql database to dump is installed
dump_postgresql_option_command_host=-h
# dump_postgresql_option_command_port: this parameter refers to the native dump command option for the port where the
# postgresql database server is listening. FACULTATIVE IF THE PORT IS THE DEFAULT PORT FOR EACH DATABASE TO DUMP
dump_postgresql_option_command_port=-p
# dump_postgresql_option_command_user: this parameter refers to the native dump command option for the access username to the postgresql database to dump
dump_postgresql_option_command_user=-U
# dump_postgresql_option_command_password: this parameter refers to the native dump command option for the access password to the postgresql database to dump
dump_postgresql_option_command_password=-W
# dump_postgresql_option_command_table: this parameter refers to the native dump command option for the postgresql database table to dump
dump_postgresql_option_command_table=-t
|