mirror of
https://github.com/MariaDB/server.git
synced 2025-10-31 10:56:12 +01:00
9e25d6f0cc
With that, it is possible to restore the full "instance" from a backup made with mariadb-dump --dir The patch implements executing DDL (tables, views, triggers) using statements that are stored in .sql file, created by mariadb-dump --dir . Care is taken of creating triggers correctly after the data is loaded, disabling foreign keys and unique key checks etc. The files are loaded in descending order by datafile size - to ensure better work distribution when running with --parallel option. In addition to --dir option, following options are implemented for partial restore include-only options: --database - import one or several databases --table - import one or several tables exclude options: --ignore-database -. ignore one or several databases when importing --ignore-table - to ignore one or several tables when importing All options above are only valid together with --dir option, and can be specified multiple times.
118 lines
3 KiB
C
118 lines
3 KiB
C
/*
|
|
Copyright (c) 2001, 2012, Oracle and/or its affiliates.
|
|
Copyright (c) 2009, 2024, MariaDB
|
|
|
|
This program 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; version 2 of the License.
|
|
|
|
This program 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 this program; if not, write to the Free Software
|
|
Foundation, Inc., 51 Franklin St, Fifth Floor, Boston, MA 02110-1335 USA
|
|
*/
|
|
|
|
/* Common defines for all clients */
|
|
|
|
#include <my_global.h>
|
|
#include <my_sys.h>
|
|
#include <m_string.h>
|
|
#include <mysql.h>
|
|
#include <errmsg.h>
|
|
#include <my_getopt.h>
|
|
#include <mysql_version.h>
|
|
|
|
#ifndef WEXITSTATUS
|
|
# ifdef _WIN32
|
|
# define WEXITSTATUS(stat_val) (stat_val)
|
|
# else
|
|
# define WEXITSTATUS(stat_val) ((unsigned)(stat_val) >> 8)
|
|
# endif
|
|
#endif
|
|
|
|
enum options_client
|
|
{
|
|
OPT_CHARSETS_DIR=256, OPT_DEFAULT_CHARSET,
|
|
OPT_PAGER, OPT_TEE,
|
|
OPT_OPTIMIZE,
|
|
OPT_TABLES,
|
|
OPT_MASTER_DATA,
|
|
OPT_SSL_KEY, OPT_SSL_CERT, OPT_SSL_CA, OPT_SSL_CAPATH,
|
|
OPT_TLS_VERSION,
|
|
OPT_SSL_CIPHER, OPT_LOCAL_INFILE,
|
|
OPT_COMPACT,
|
|
OPT_MYSQL_PROTOCOL,
|
|
OPT_SKIP_OPTIMIZATION,
|
|
OPT_COMPATIBLE, OPT_DELIMITER,
|
|
OPT_SERVER_ARG,
|
|
OPT_START_DATETIME, OPT_STOP_DATETIME,
|
|
OPT_IGNORE_DATABASE,
|
|
OPT_IGNORE_TABLE,
|
|
OPT_MYSQLDUMP_SLAVE_DATA,
|
|
OPT_SLAP_CSV,
|
|
OPT_BASE64_OUTPUT_MODE,
|
|
OPT_FIX_TABLE_NAMES, OPT_FIX_DB_NAMES,
|
|
OPT_WRITE_BINLOG,
|
|
OPT_PLUGIN_DIR,
|
|
OPT_DEFAULT_AUTH,
|
|
OPT_REWRITE_DB,
|
|
OPT_SSL_CRL, OPT_SSL_CRLPATH,
|
|
OPT_IGNORE_DATA,
|
|
OPT_PRINT_ROW_COUNT, OPT_PRINT_ROW_EVENT_POSITIONS,
|
|
OPT_CHECK_IF_UPGRADE_NEEDED,
|
|
OPT_COMPATIBILTY_CLEARTEXT_PLUGIN,
|
|
OPT_STOP_POSITION,
|
|
OPT_SERVER_ID,
|
|
OPT_IGNORE_DOMAIN_IDS,
|
|
OPT_DO_DOMAIN_IDS,
|
|
OPT_IGNORE_SERVER_IDS,
|
|
OPT_DO_SERVER_IDS,
|
|
OPT_SSL_FP, OPT_SSL_FPLIST,
|
|
OPT_UPDATE_HISTORY,
|
|
OPT_DATABASE,
|
|
OPT_MAX_CLIENT_OPTION /* should be always the last */
|
|
};
|
|
|
|
/**
|
|
First mysql version supporting the information schema.
|
|
*/
|
|
#define FIRST_INFORMATION_SCHEMA_VERSION 50003
|
|
|
|
/**
|
|
Name of the information schema database.
|
|
*/
|
|
#define INFORMATION_SCHEMA_DB_NAME "information_schema"
|
|
|
|
/**
|
|
First mysql version supporting the performance schema.
|
|
*/
|
|
#define FIRST_PERFORMANCE_SCHEMA_VERSION 50503
|
|
|
|
/**
|
|
Name of the performance schema database.
|
|
*/
|
|
#define PERFORMANCE_SCHEMA_DB_NAME "performance_schema"
|
|
|
|
/**
|
|
First mariadb version supporting the sys schema.
|
|
*/
|
|
#define FIRST_SYS_SCHEMA_VERSION 100600
|
|
|
|
/**
|
|
Name of the sys schema database.
|
|
*/
|
|
#define SYS_SCHEMA_DB_NAME "sys"
|
|
|
|
/**
|
|
The --socket CLI option has different meanings
|
|
across different operating systems.
|
|
*/
|
|
#ifndef _WIN32
|
|
#define SOCKET_PROTOCOL_TO_FORCE MYSQL_PROTOCOL_SOCKET
|
|
#else
|
|
#define SOCKET_PROTOCOL_TO_FORCE MYSQL_PROTOCOL_PIPE
|
|
#endif
|