File: parameters.txt

Recommend this page to a friend!
  Classes of Alessandro Quintiliani  >  PHP Multi MySQLDump  >  parameters.txt  >  Download  
File: parameters.txt
Role: Auxiliary data
Content type: text/plain
Description: file containing configuration parameters to execute MySQL queries and set option to MySQL dump command
Class: PHP Multi MySQLDump
Dump MySQL database tables for file download
Author: By
Last change:
Date: 4 years ago
Size: 7,078 bytes
 

Contents

Class file image Download
#
# ***************************************************************************************************
#
# 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
For more information send a message to info at phpclasses dot org.