PHP Classes

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: 7 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