mysqldump.c File Reference

#include <my_global.h>
#include <my_sys.h>
#include <m_string.h>
#include <m_ctype.h>
#include <hash.h>
#include "client_priv.h"
#include "mysql.h"
#include "mysql_version.h"
#include "mysqld_error.h"
#include <sslopt-vars.h>
#include <sslopt-longopts.h>
#include <help_start.h>
#include <help_end.h>
#include <sslopt-case.h>

Go to the source code of this file.

Defines
#define	DUMP_VERSION   "10.10"
#define	EX_CONSCHECK   3
#define	EX_EOF   5
#define	EX_EOM   4
#define	EX_ILLEGAL_TABLE   6
#define	EX_MYSQLERR   2
#define	EX_USAGE   1
#define	MASK_ANSI_QUOTES
#define	MYSQL_OPT_MASTER_DATA_COMMENTED_SQL   2
#define	MYSQL_OPT_MASTER_DATA_EFFECTIVE_SQL   1
#define	QUERY_LENGTH   1536
#define	SHOW_DEFAULT   4
#define	SHOW_EXTRA   5
#define	SHOW_FIELDNAME   0
#define	SHOW_NULL   2
#define	SHOW_TYPE   1
Functions
static char *	add_load_option (char *ptr, const char *object, const char *statement)
static char *	alloc_query_str (ulong size)
static const char *	check_if_ignore_table (const char *table_name)
void	check_io (FILE *file)
static void	DB_error (MYSQL *mysql, const char *when)
static int	dbConnect (char *host, char *user, char *passwd)
static void	dbDisconnect (char *host)
static int	do_flush_tables_read_lock (MYSQL *mysql_con)
static int	do_reset_master (MYSQL *mysql_con)
static int	do_show_master_status (MYSQL *mysql_con)
static int	do_unlock_tables (MYSQL *mysql_con)
static int	dump_all_databases ()
static int	dump_all_tables_in_db (char *db)
static my_bool	dump_all_views_in_db (char *database)
static int	dump_databases (char **)
static int	dump_selected_tables (char *db, char **table_names, int tables)
static void	dump_table (uint numFields, char *table)
static char *	field_escape (char *to, const char *from, uint length)
static ulong	find_set (TYPELIB *lib, const char *x, uint length, char **err_pos, uint *err_len)
static void	free_table_ent (char *key)
static int	get_actual_table_name (const char *old_table_name, char *new_table_name, int buf_size)
static my_bool	get_one_option (int optid, const struct my_option *opt __attribute__((unused)), char *argument)
static int	get_options (int *argc, char ***argv)
byte *	get_table_key (const char *entry, uint *length, my_bool not_used __attribute__((unused)))
static uint	get_table_structure (char *table, char *db)
static my_bool	get_view_structure (char *table, char *db)
static char *	getTableName (int reset)
my_bool	include_table (byte *hash_key, uint len)
static int	init_dumping (char *)
void	init_table_rule_hash (HASH *h)
int	main (int argc, char **argv)
static int	mysql_query_with_error_report (MYSQL *mysql_con, MYSQL_RES **res, const char *query)
static char *	primary_key_fields (const char *table_name)
static void	print_quoted_xml (FILE *xml_file, const char *str, ulong len)
static void	print_value (FILE *file, MYSQL_RES *result, MYSQL_ROW row, const char *prefix, const char *name, int string_value)
static void	print_version (void)
static void	print_xml_null_tag (FILE *xml_file, const char *sbeg, const char *stag_atr, const char *sval, const char *send)
static void	print_xml_row (FILE *xml_file, const char *row_name, MYSQL_RES *tableRes, MYSQL_ROW *row)
static void	print_xml_tag1 (FILE *xml_file, const char *sbeg, const char *stag_atr, const char *sval, const char *send)
static char *	quote_for_like (const char *name, char *buff)
static char *	quote_name (const char *name, char *buff, my_bool force)
static void	safe_exit (int error)
static void	short_usage (void)
static void	short_usage_sub (void)
static int	start_transaction (MYSQL *mysql_con, my_bool consistent_read_now)
static my_bool	test_if_special_chars (const char *str)
static void	unescape (FILE *file, char *pos, uint length)
static void	usage (void)
static void	write_footer (FILE *sql_file)
static void	write_header (FILE *sql_file, char *db_name)
Variables
static CHARSET_INFO *	charset_info = &my_charset_latin1
const char *	compatible_mode_names []
static char	compatible_mode_normal_str [255]
TYPELIB	compatible_mode_typelib
static my_bool	create_options = 1
static char *	current_host = 0
static char *	current_user = 0
static char *	default_charset
const char *	default_dbug_option = "d:t:o,/tmp/mysqldump.trace"
static my_bool	dFlag = 0
static char *	enclosed = 0
static uint	err_len = 0
static char *	err_ptr = 0
static char *	escaped = 0
static my_bool	extended_insert = 1
static DYNAMIC_STRING	extended_row
static char *	fields_terminated = 0
static int	first_error = 0
static my_bool	flush_logs = 0
static my_bool	ignore_errors = 0
HASH	ignore_table
static DYNAMIC_STRING	insert_pat
static my_bool	insert_pat_inited = 0
static char *	lines_terminated = 0
static const char *	load_default_groups [] = { "mysqldump","client",0 }
static my_bool	lock_tables = 1
FILE *	md_result_file
static struct my_option	my_long_options []
static MYSQL	mysql_connection
static const char *	mysql_universal_client_charset
static my_bool	opt_alldbs = 0
static my_bool	opt_autocommit = 0
static my_bool	opt_comments = 0
static my_bool	opt_compact = 0
static ulong	opt_compatible_mode = 0
static char *	opt_compatible_mode_str = 0
static my_bool	opt_complete_insert = 0
static my_bool	opt_compress = 0
static my_bool	opt_create_db = 0
static my_bool	opt_databases = 0
static my_bool	opt_delayed = 0
static my_bool	opt_delete_master_logs = 0
static my_bool	opt_disable_keys = 1
static my_bool	opt_drop = 1
static my_bool	opt_drop_database = 0
static char *	opt_enclosed = 0
static my_bool	opt_hex_blob = 0
static my_bool	opt_ignore = 0
static my_bool	opt_keywords = 0
static my_bool	opt_lock = 1
static my_bool	opt_lock_all_tables = 0
static uint	opt_master_data
static ulong	opt_max_allowed_packet
static uint	opt_mysql_port = 0
static my_string	opt_mysql_unix_port = 0
static ulong	opt_net_buffer_length
static my_bool	opt_order_by_primary = 0
static char *	opt_password = 0
static uint	opt_protocol = 0
static my_bool	opt_quoted = 0
static my_bool	opt_set_charset = 0
static my_bool	opt_single_transaction = 0
static my_bool	opt_xml = 0
static char *	order_by = 0
static char *	path = 0
static my_bool	quick = 1
static MYSQL *	sock = 0
static my_bool	tFlag = 0
static my_bool	tty_password = 0
static my_bool	verbose = 0
my_bool	was_views = 0
static char *	where = 0

---

Define Documentation

#define DUMP_VERSION   "10.10"

Definition at line 40 of file mysqldump.c. Referenced by print_version(), and write_header().

#define EX_CONSCHECK   3

Definition at line 57 of file mysqldump.c. Referenced by dump_table().

#define EX_EOF   5

Definition at line 59 of file mysqldump.c. Referenced by check_io().

#define EX_EOM   4

Definition at line 58 of file mysqldump.c. Referenced by dump_selected_tables(), dump_table(), get_one_option(), init_dumping(), and init_table_rule_hash().

#define EX_ILLEGAL_TABLE   6

Definition at line 60 of file mysqldump.c. Referenced by dump_selected_tables().

#define EX_MYSQLERR   2

Definition at line 56 of file mysqldump.c.

#define EX_USAGE   1

Definition at line 55 of file mysqldump.c.

#define MASK_ANSI_QUOTES

Value: (\ (1<<2) | /* POSTGRESQL */\ (1<<3) | /* ORACLE */\ (1<<4) | /* MSSQL */\ (1<<5) | /* DB2 */\ (1<<6) | /* MAXDB */\ (1<<10) /* ANSI */\ ) Definition at line 134 of file mysqldump.c. Referenced by quote_name().

#define MYSQL_OPT_MASTER_DATA_COMMENTED_SQL   2

Definition at line 103 of file mysqldump.c. Referenced by do_show_master_status(), and get_options().

#define MYSQL_OPT_MASTER_DATA_EFFECTIVE_SQL   1

Definition at line 102 of file mysqldump.c. Referenced by get_one_option().

#define QUERY_LENGTH   1536

Definition at line 71 of file mysqldump.c. Referenced by dump_table().

#define SHOW_DEFAULT   4

Definition at line 67 of file mysqldump.c. Referenced by get_table_structure().

#define SHOW_EXTRA   5

Definition at line 68 of file mysqldump.c. Referenced by get_table_structure().

#define SHOW_FIELDNAME   0

Definition at line 64 of file mysqldump.c. Referenced by get_table_structure().

#define SHOW_NULL   2

Definition at line 66 of file mysqldump.c. Referenced by get_table_structure().

#define SHOW_TYPE   1

Definition at line 65 of file mysqldump.c. Referenced by get_table_structure(), and show_status_array().

---

Function Documentation

static char * add_load_option (  char *  ptr, const char *  object, const char *  statement )  [static]

Definition at line 1610 of file mysqldump.c. References field_escape(), NullS, and strxmov(). Referenced by dump_table(), and write_to_table(). { if (object) { /* Don't escape hex constants */ if (object[0] == '0' && (object[1] == 'x' || object[1] == 'X')) ptr= strxmov(ptr," ",statement," ",object,NullS); else { /* char constant; escape */ ptr= strxmov(ptr," ",statement," '",NullS); ptr= field_escape(ptr,object,(uint) strlen(object)); *ptr++= '\''; } } return ptr; } /* add_load_option */

static char* alloc_query_str (  ulong  size  )  [static]

Definition at line 1661 of file mysqldump.c. References EX_MYSQLERR, ignore_errors, my_malloc(), MY_WME, MYF, query, and safe_exit(). Referenced by dump_table(). { char *query; if (!(query= (char*) my_malloc(size, MYF(MY_WME)))) { ignore_errors= 0; /* Fatal error */ safe_exit(EX_MYSQLERR); /* Force exit */ } return query; }

static const char * check_if_ignore_table (  const char *  table_name  )  [static]

Definition at line 2726 of file mysqldump.c. References DBUG_ASSERT, ER_PARSE_ERROR, FN_REFLEN, my_snprintf(), mysql_errno(), mysql_error(), mysql_fetch_row(), mysql_free_result(), mysql_query_with_error_report(), quote_for_like(), and verbose. Referenced by dump_table(). { char buff[FN_REFLEN+80], show_name_buff[FN_REFLEN]; MYSQL_RES *res; MYSQL_ROW row; const char *result= 0; /* Check memory for quote_for_like() */ DBUG_ASSERT(2*sizeof(table_name) < sizeof(show_name_buff)); my_snprintf(buff, sizeof(buff), "show table status like %s", quote_for_like(table_name, show_name_buff)); if (mysql_query_with_error_report(sock, &res, buff)) { if (mysql_errno(sock) != ER_PARSE_ERROR) { /* If old MySQL version */ if (verbose) fprintf(stderr, "-- Warning: Couldn't get status information for table %s (%s)\n", table_name,mysql_error(sock)); return 0; /* assume table is ok */ } } if (!(row= mysql_fetch_row(res))) { fprintf(stderr, "Error: Couldn't read status information for table %s (%s)\n", table_name, mysql_error(sock)); mysql_free_result(res); return 0; /* assume table is ok */ } if (!(row[1])) result= "VIEW"; else { if (strcmp(row[1], (result= "MRG_MyISAM")) && strcmp(row[1], (result= "MRG_ISAM"))) result= 0; } mysql_free_result(res); return result; }

void check_io (  FILE *  file  )

Definition at line 418 of file mysqldump.c. References errno, EX_EOF, my_progname, and safe_exit(). Referenced by do_show_master_status(), dump_all_tables_in_db(), dump_all_views_in_db(), dump_selected_tables(), dump_table(), get_table_structure(), get_view_structure(), init_dumping(), print_quoted_xml(), print_value(), print_xml_null_tag(), print_xml_row(), print_xml_tag1(), unescape(), write_footer(), and write_header(). { if (ferror(file)) { fprintf(stderr, "%s: Got errno %d on write\n", my_progname, errno); safe_exit(EX_EOF); } }

static void DB_error (  MYSQL *  mysql, const char *  when )  [static]

Definition at line 799 of file mysqldump.c. References DBUG_ENTER, DBUG_VOID_RETURN, EX_MYSQLERR, my_printf_error(), MYF, mysql_errno(), mysql_error(), and safe_exit(). Referenced by dbConnect(), dump_all_tables_in_db(), dump_all_views_in_db(), dump_selected_tables(), dump_table(), and init_dumping(). { DBUG_ENTER("DB_error"); my_printf_error(0,"Got error: %d: %s %s", MYF(0), mysql_errno(mysql), mysql_error(mysql), when); safe_exit(EX_MYSQLERR); DBUG_VOID_RETURN; } /* DB_error */

static int dbConnect (  char *  host, char *  user, char *  passwd )  [static]

Definition at line 856 of file mysqldump.c. References compatible_mode_normal_str, DB_error(), DBUG_ENTER, default_charset, EX_MYSQLERR, FN_REFLEN, my_snprintf(), mysql_close(), mysql_get_server_version(), mysql_init(), MYSQL_OPT_COMPRESS, MYSQL_OPT_PROTOCOL, mysql_options(), mysql_query_with_error_report(), mysql_real_connect(), MYSQL_SET_CHARSET_NAME, MYSQL_SHARED_MEMORY_BASE_NAME, mysql_ssl_set(), NULL, NullS, opt_compress, opt_mysql_port, opt_mysql_unix_port, opt_protocol, opt_set_charset, st_mysql::reconnect, safe_exit(), shared_memory_base_name, and verbose. { char buff[20+FN_REFLEN]; DBUG_ENTER("dbConnect"); if (verbose) { fprintf(stderr, "-- Connecting to %s...\n", host ? host : "localhost"); } mysql_init(&mysql_connection); if (opt_compress) mysql_options(&mysql_connection,MYSQL_OPT_COMPRESS,NullS); #ifdef HAVE_OPENSSL if (opt_use_ssl) mysql_ssl_set(&mysql_connection, opt_ssl_key, opt_ssl_cert, opt_ssl_ca, opt_ssl_capath, opt_ssl_cipher); #endif if (opt_protocol) mysql_options(&mysql_connection,MYSQL_OPT_PROTOCOL,(char*)&opt_protocol); #ifdef HAVE_SMEM if (shared_memory_base_name) mysql_options(&mysql_connection,MYSQL_SHARED_MEMORY_BASE_NAME,shared_memory_base_name); #endif mysql_options(&mysql_connection, MYSQL_SET_CHARSET_NAME, default_charset); if (!(sock= mysql_real_connect(&mysql_connection,host,user,passwd, NULL,opt_mysql_port,opt_mysql_unix_port, 0))) { DB_error(&mysql_connection, "when trying to connect"); return 1; } /* Don't dump SET NAMES with a pre-4.1 server (bug#7997). */ if (mysql_get_server_version(&mysql_connection) < 40100) opt_set_charset= 0; /* As we're going to set SQL_MODE, it would be lost on reconnect, so we cannot reconnect. */ sock->reconnect= 0; my_snprintf(buff, sizeof(buff), "/*!40100 SET @@SQL_MODE='%s' */", compatible_mode_normal_str); if (mysql_query_with_error_report(sock, 0, buff)) { mysql_close(sock); safe_exit(EX_MYSQLERR); return 1; } return 0; } /* dbConnect */

static void dbDisconnect (  char *  host  )  [static]

Definition at line 911 of file mysqldump.c. References mysql_close(), and verbose. { if (verbose) fprintf(stderr, "-- Disconnecting from %s...\n", host ? host : "localhost"); mysql_close(sock); } /* dbDisconnect */

static int do_flush_tables_read_lock (  MYSQL *  mysql_con  )  [static]

Definition at line 2588 of file mysqldump.c. References mysql_query_with_error_report(). Referenced by main(). { /* We do first a FLUSH TABLES. If a long update is running, the FLUSH TABLES will wait but will not stall the whole mysqld, and when the long update is done the FLUSH TABLES WITH READ LOCK will start and succeed quickly. So, FLUSH TABLES is to lower the probability of a stage where both mysqldump and most client connections are stalled. Of course, if a second long update starts between the two FLUSHes, we have that bad stall. */ return ( mysql_query_with_error_report(mysql_con, 0, "FLUSH TABLES") || mysql_query_with_error_report(mysql_con, 0, "FLUSH TABLES WITH READ LOCK") ); }

static int do_reset_master (  MYSQL *  mysql_con  )  [static]

Definition at line 2611 of file mysqldump.c. References mysql_query_with_error_report(). Referenced by main(). { return mysql_query_with_error_report(mysql_con, 0, "RESET MASTER"); }

static int do_show_master_status (  MYSQL *  mysql_con  )  [static]

Definition at line 2547 of file mysqldump.c. References check_io(), ignore_errors, md_result_file, my_printf_error(), MYF, mysql_error(), mysql_fetch_row(), mysql_free_result(), MYSQL_OPT_MASTER_DATA_COMMENTED_SQL, mysql_query_with_error_report(), opt_comments, and opt_master_data. Referenced by main(). { MYSQL_ROW row; MYSQL_RES *master; const char *comment_prefix= (opt_master_data == MYSQL_OPT_MASTER_DATA_COMMENTED_SQL) ? "-- " : ""; if (mysql_query_with_error_report(mysql_con, &master, "SHOW MASTER STATUS")) { my_printf_error(0, "Error: Couldn't execute 'SHOW MASTER STATUS': %s", MYF(0), mysql_error(mysql_con)); return 1; } else { row = mysql_fetch_row(master); if (row && row[0] && row[1]) { /* SHOW MASTER STATUS reports file and position */ if (opt_comments) fprintf(md_result_file, "\n--\n-- Position to start replication or point-in-time " "recovery from\n--\n\n"); fprintf(md_result_file, "%sCHANGE MASTER TO MASTER_LOG_FILE='%s', MASTER_LOG_POS=%s;\n", comment_prefix, row[0], row[1]); check_io(md_result_file); } else if (!ignore_errors) { /* SHOW MASTER STATUS reports nothing and --force is not enabled */ my_printf_error(0, "Error: Binlogging on server not active", MYF(0), mysql_error(mysql_con)); mysql_free_result(master); return 1; } mysql_free_result(master); } return 0; }

static int do_unlock_tables (  MYSQL *  mysql_con  )  [static]

Definition at line 2605 of file mysqldump.c. References mysql_query_with_error_report(). Referenced by main(). { return mysql_query_with_error_report(mysql_con, 0, "UNLOCK TABLES"); }

static int dump_all_databases (   )  [static]

Definition at line 2152 of file mysqldump.c. References dump_all_tables_in_db(), dump_all_views_in_db(), my_printf_error(), MYF, mysql_error(), mysql_fetch_row(), mysql_query(), mysql_query_with_error_report(), mysql_store_result(), and was_views. Referenced by main(). { MYSQL_ROW row; MYSQL_RES *tableres; int result=0; if (mysql_query_with_error_report(sock, &tableres, "SHOW DATABASES")) return 1; while ((row = mysql_fetch_row(tableres))) { if (dump_all_tables_in_db(row[0])) result=1; } if (was_views) { if (mysql_query(sock, "SHOW DATABASES") || !(tableres = mysql_store_result(sock))) { my_printf_error(0, "Error: Couldn't execute 'SHOW DATABASES': %s", MYF(0), mysql_error(sock)); return 1; } while ((row = mysql_fetch_row(tableres))) { if (dump_all_views_in_db(row[0])) result=1; } } return result; }

static int dump_all_tables_in_db (  char *  db  )  [static]

Definition at line 2284 of file mysqldump.c. References check_io(), DB_error(), dump_table(), dynstr_append(), dynstr_free(), flush_logs, get_table_structure(), getTableName(), hash_key(), include_table(), init_dumping(), init_dynamic_string(), st_dynamic_string::length, lock_tables, md_result_file, MY_ALLOW_ZERO_PTR, my_free, MYF, mysql_query_with_error_report(), mysql_real_query(), mysql_refresh(), NAME_LEN, opt_xml, order_by, print_xml_tag1(), query, quote_name(), REFRESH_LOG, st_dynamic_string::str, and strmov(). Referenced by dump_all_databases(), and dump_databases(). { char *table; uint numrows; char table_buff[NAME_LEN*2+3]; char hash_key[2*NAME_LEN+2]; /* "db.tablename" */ char *afterdot; afterdot= strmov(hash_key, database); *afterdot++= '.'; if (init_dumping(database)) return 1; if (opt_xml) print_xml_tag1(md_result_file, "", "database name=", database, "\n"); if (lock_tables) { DYNAMIC_STRING query; init_dynamic_string(&query, "LOCK TABLES ", 256, 1024); for (numrows= 0 ; (table= getTableName(1)) ; numrows++) { dynstr_append(&query, quote_name(table, table_buff, 1)); dynstr_append(&query, " READ /*!32311 LOCAL */,"); } if (numrows && mysql_real_query(sock, query.str, query.length-1)) DB_error(sock, "when using LOCK TABLES"); /* We shall continue here, if --force was given */ dynstr_free(&query); } if (flush_logs) { if (mysql_refresh(sock, REFRESH_LOG)) DB_error(sock, "when doing refresh"); /* We shall continue here, if --force was given */ } while ((table= getTableName(0))) { char *end= strmov(afterdot, table); if (include_table(hash_key, end - hash_key)) { numrows = get_table_structure(table, database); dump_table(numrows,table); my_free(order_by, MYF(MY_ALLOW_ZERO_PTR)); order_by= 0; } } if (opt_xml) { fputs("</database>\n", md_result_file); check_io(md_result_file); } if (lock_tables) mysql_query_with_error_report(sock, 0, "UNLOCK TABLES"); return 0; } /* dump_all_tables_in_db */

static my_bool dump_all_views_in_db (  char *  database  )  [static]

Definition at line 2354 of file mysqldump.c. References check_io(), DB_error(), dynstr_append(), dynstr_free(), flush_logs, get_view_structure(), getTableName(), init_dumping(), init_dynamic_string(), st_dynamic_string::length, lock_tables, md_result_file, mysql_query(), mysql_real_query(), mysql_refresh(), NAME_LEN, opt_xml, print_xml_tag1(), query, quote_name(), REFRESH_LOG, and st_dynamic_string::str. Referenced by dump_all_databases(), and dump_databases(). { char *table; uint numrows; char table_buff[NAME_LEN*2+3]; if (init_dumping(database)) return 1; if (opt_xml) print_xml_tag1(md_result_file, "", "database name=", database, "\n"); if (lock_tables) { DYNAMIC_STRING query; init_dynamic_string(&query, "LOCK TABLES ", 256, 1024); for (numrows= 0 ; (table= getTableName(1)); numrows++) { dynstr_append(&query, quote_name(table, table_buff, 1)); dynstr_append(&query, " READ /*!32311 LOCAL */,"); } if (numrows && mysql_real_query(sock, query.str, query.length-1)) DB_error(sock, "when using LOCK TABLES"); /* We shall continue here, if --force was given */ dynstr_free(&query); } if (flush_logs) { if (mysql_refresh(sock, REFRESH_LOG)) DB_error(sock, "when doing refresh"); /* We shall continue here, if --force was given */ } while ((table= getTableName(0))) get_view_structure(table, database); if (opt_xml) { fputs("</database>\n", md_result_file); check_io(md_result_file); } if (lock_tables) mysql_query(sock,"UNLOCK TABLES"); return 0; } /* dump_all_tables_in_db */

static int dump_databases (  char **   )  [static]

Definition at line 2185 of file mysqldump.c. References db, dump_all_tables_in_db(), dump_all_views_in_db(), and was_views. Referenced by main(). { int result=0; char **db; for (db= db_names ; *db ; db++) { if (dump_all_tables_in_db(*db)) result=1; } if (!result && was_views) { for (db= db_names ; *db ; db++) { if (dump_all_views_in_db(*db)) result=1; } } return result; } /* dump_databases */

static int dump_selected_tables (  char *  db, char **  table_names, int  tables )  [static]

Definition at line 2449 of file mysqldump.c. References check_io(), DB_error(), DBUG_ENTER, DBUG_PRINT, DBUG_RETURN, dump_table(), dynstr_append(), dynstr_free(), EX_EOM, EX_ILLEGAL_TABLE, exit, flush_logs, free_table_ent(), get_actual_table_name(), get_table_key(), get_table_structure(), get_view_structure(), hash_element(), hash_free(), hash_init, init_dumping(), init_dynamic_string(), st_dynamic_string::length, lock_tables, md_result_file, MY_ALLOW_ZERO_PTR, my_free, my_hash_insert(), my_printf_error(), my_strdup(), MYF, mysql_query_with_error_report(), mysql_real_query(), mysql_refresh(), NAME_LEN, opt_xml, order_by, print_xml_tag1(), quote_name(), REFRESH_LOG, safe_exit(), st_dynamic_string::str, and was_views. Referenced by main(). { uint numrows, i; char table_buff[NAME_LEN*+3]; char new_table_name[NAME_LEN]; DYNAMIC_STRING lock_tables_query; HASH dump_tables; char *table_name; DBUG_ENTER("dump_selected_tables"); if (init_dumping(db)) return 1; /* Init hash table for storing the actual name of tables to dump */ if (hash_init(&dump_tables, charset_info, 16, 0, 0, (hash_get_key) get_table_key, (hash_free_key) free_table_ent, 0)) exit(EX_EOM); init_dynamic_string(&lock_tables_query, "LOCK TABLES ", 256, 1024); for (; tables > 0 ; tables-- , table_names++) { /* the table name passed on commandline may be wrong case */ if (!get_actual_table_name(*table_names, new_table_name, sizeof(new_table_name))) { /* Add found table name to lock_tables_query */ if (lock_tables) { dynstr_append(&lock_tables_query, quote_name(new_table_name, table_buff, 1)); dynstr_append(&lock_tables_query, " READ /*!32311 LOCAL */,"); } /* Add found table name to dump_tables list */ if (my_hash_insert(&dump_tables, (byte*)my_strdup(new_table_name, MYF(0)))) exit(EX_EOM); } else { my_printf_error(0,"Couldn't find table: \"%s\"\n", MYF(0), *table_names); safe_exit(EX_ILLEGAL_TABLE); /* We shall countinue here, if --force was given */ } } if (lock_tables) { if (mysql_real_query(sock, lock_tables_query.str, lock_tables_query.length-1)) DB_error(sock, "when doing LOCK TABLES"); /* We shall countinue here, if --force was given */ } dynstr_free(&lock_tables_query); if (flush_logs) { if (mysql_refresh(sock, REFRESH_LOG)) DB_error(sock, "when doing refresh"); /* We shall countinue here, if --force was given */ } if (opt_xml) print_xml_tag1(md_result_file, "", "database name=", db, "\n"); /* Dump each selected table */ for (i= 0; i < dump_tables.records; i++) { table_name= hash_element(&dump_tables, i); DBUG_PRINT("info",("Dumping table %s", table_name)); numrows= get_table_structure(table_name, db); dump_table(numrows, table_name); } /* Dump each selected view */ if (was_views) { for(i=0; i < dump_tables.records; i++) { table_name= hash_element(&dump_tables, i); get_view_structure(table_name, db); } } hash_free(&dump_tables); my_free(order_by, MYF(MY_ALLOW_ZERO_PTR)); order_by= 0; if (opt_xml) { fputs("</database>\n", md_result_file); check_io(md_result_file); } if (lock_tables) mysql_query_with_error_report(sock, 0, "UNLOCK TABLES"); DBUG_RETURN(0); } /* dump_selected_tables */

static void dump_table (  uint  numFields, char *  table )  [static]

Definition at line 1678 of file mysqldump.c. References add_load_option(), alloc_query_str(), st_mysql_field::charsetnr, check_if_ignore_table(), check_io(), convert_dirname(), DB_error(), dFlag, dynstr_append(), dynstr_realloc(), dynstr_set(), enclosed, err, error, escaped, EX_CONSCHECK, EX_EOM, extended_insert, FIELD_TYPE_DECIMAL, fields_terminated, filename, fn_format(), FN_REFLEN, IS_NUM_FIELD, field::length, st_dynamic_string::length, lengths, lines_terminated, md_result_file, MY_ALLOW_ZERO_PTR, my_delete(), my_free, my_isalpha, my_load_path(), my_progname, my_snprintf(), MYF, mysql_errno(), mysql_error(), mysql_fetch_field(), mysql_fetch_lengths(), mysql_fetch_row(), mysql_field_seek(), mysql_free_result(), mysql_hex_string(), mysql_num_fields(), mysql_query_with_error_report(), mysql_real_escape_string(), mysql_real_query(), mysql_store_result(), MYSQL_TYPE_BLOB, MYSQL_TYPE_LONG_BLOB, MYSQL_TYPE_MEDIUM_BLOB, MYSQL_TYPE_STRING, MYSQL_TYPE_TINY_BLOB, MYSQL_TYPE_VAR_STRING, MYSQL_TYPE_VARCHAR, mysql_use_result(), st_mysql_field::name, NAME_LEN, NULL, NullS, opt_autocommit, opt_comments, opt_compact, opt_disable_keys, opt_enclosed, opt_hex_blob, opt_lock, opt_net_buffer_length, opt_xml, order_by, path, print_quoted_xml(), print_xml_null_tag(), print_xml_tag1(), query, QUERY_LENGTH, quick, quote_name(), safe_exit(), st_dynamic_string::str, strend(), strmov(), strxmov(), to_unix_path(), st_mysql_field::type, unescape(), verbose, and where. Referenced by dump_all_tables_in_db(), and dump_selected_tables(). { char query_buf[QUERY_LENGTH], *end, buff[256],table_buff[NAME_LEN+3]; char *result_table, table_buff2[NAME_LEN*2+3], *opt_quoted_table; char *query= query_buf; MYSQL_RES *res; MYSQL_FIELD *field; MYSQL_ROW row; ulong rownr, row_break, total_length, init_length; const char *table_type; int error= 0; /* Check --no-data flag */ if (dFlag) { if (verbose) fprintf(stderr, "-- Skipping dump data for table '%s', --no-data was used\n", table); return; } /* Check that there are any fields in the table */ if (numFields == 0) { if (verbose) fprintf(stderr, "-- Skipping dump data for table '%s', it has no fields\n", table); return; } result_table= quote_name(table,table_buff, 1); opt_quoted_table= quote_name(table, table_buff2, 0); /* Check table type */ if ((table_type= check_if_ignore_table(table))) { if (verbose) fprintf(stderr, "-- Skipping data for table '%s' because it's of type %s\n", table, table_type); return; } if (verbose) fprintf(stderr, "-- Sending SELECT query...\n"); if (path) { char filename[FN_REFLEN], tmp_path[FN_REFLEN]; convert_dirname(tmp_path,path,NullS); my_load_path(tmp_path, tmp_path, NULL); fn_format(filename, table, tmp_path, ".txt", 4); my_delete(filename, MYF(0)); /* 'INTO OUTFILE' doesn't work, if filename wasn't deleted */ to_unix_path(filename); my_snprintf(query, QUERY_LENGTH, "SELECT /*!40001 SQL_NO_CACHE */ * INTO OUTFILE '%s'", filename); end= strend(query); if (fields_terminated || enclosed || opt_enclosed || escaped) end= strmov(end, " FIELDS"); end= add_load_option(end, fields_terminated, " TERMINATED BY"); end= add_load_option(end, enclosed, " ENCLOSED BY"); end= add_load_option(end, opt_enclosed, " OPTIONALLY ENCLOSED BY"); end= add_load_option(end, escaped, " ESCAPED BY"); end= add_load_option(end, lines_terminated, " LINES TERMINATED BY"); *end= '\0'; my_snprintf(buff, sizeof(buff), " FROM %s", result_table); end= strmov(end,buff); if (where || order_by) { query = alloc_query_str((ulong) ((end - query) + 1 + (where ? strlen(where) + 7 : 0) + (order_by ? strlen(order_by) + 10 : 0))); end = strmov(query, query_buf); if (where) end = strxmov(end, " WHERE ", where, NullS); if (order_by) end = strxmov(end, " ORDER BY ", order_by, NullS); } if (mysql_real_query(sock, query, (uint) (end - query))) { DB_error(sock, "when executing 'SELECT INTO OUTFILE'"); return; } } else { if (!opt_xml && opt_comments) { fprintf(md_result_file,"\n--\n-- Dumping data for table %s\n--\n", result_table); check_io(md_result_file); } my_snprintf(query, QUERY_LENGTH, "SELECT /*!40001 SQL_NO_CACHE */ * FROM %s", result_table); if (where || order_by) { query = alloc_query_str((ulong) (strlen(query) + 1 + (where ? strlen(where) + 7 : 0) + (order_by ? strlen(order_by) + 10 : 0))); end = strmov(query, query_buf); if (where) { if (!opt_xml && opt_comments) { fprintf(md_result_file, "-- WHERE: %s\n", where); check_io(md_result_file); } end = strxmov(end, " WHERE ", where, NullS); } if (order_by) { if (!opt_xml && opt_comments) { fprintf(md_result_file, "-- ORDER BY: %s\n", order_by); check_io(md_result_file); } end = strxmov(end, " ORDER BY ", order_by, NullS); } } if (!opt_xml && !opt_compact) { fputs("\n", md_result_file); check_io(md_result_file); } if (mysql_query_with_error_report(sock, 0, query)) DB_error(sock, "when retrieving data from server"); if (quick) res=mysql_use_result(sock); else res=mysql_store_result(sock); if (!res) DB_error(sock, "when retrieving data from server"); if (verbose) fprintf(stderr, "-- Retrieving rows...\n"); if (mysql_num_fields(res) != numFields) { fprintf(stderr,"%s: Error in field count for table: %s ! Aborting.\n", my_progname, result_table); error= EX_CONSCHECK; goto err; } if (opt_disable_keys) { fprintf(md_result_file, "\n/*!40000 ALTER TABLE %s DISABLE KEYS */;\n", opt_quoted_table); check_io(md_result_file); } if (opt_lock) { fprintf(md_result_file,"LOCK TABLES %s WRITE;\n", opt_quoted_table); check_io(md_result_file); } total_length= opt_net_buffer_length; /* Force row break */ row_break=0; rownr=0; init_length=(uint) insert_pat.length+4; if (opt_xml) print_xml_tag1(md_result_file, "\t", "table_data name=", table, "\n"); if (opt_autocommit) { fprintf(md_result_file, "set autocommit=0;\n"); check_io(md_result_file); } while ((row=mysql_fetch_row(res))) { uint i; ulong *lengths=mysql_fetch_lengths(res); rownr++; if (!extended_insert && !opt_xml) { fputs(insert_pat.str,md_result_file); check_io(md_result_file); } mysql_field_seek(res,0); if (opt_xml) { fputs("\t<row>\n", md_result_file); check_io(md_result_file); } for (i = 0; i < mysql_num_fields(res); i++) { int is_blob; if (!(field = mysql_fetch_field(res))) { my_snprintf(query, QUERY_LENGTH, "%s: Not enough fields from table %s! Aborting.\n", my_progname, result_table); fputs(query,stderr); error= EX_CONSCHECK; goto err; } /* 63 is my_charset_bin. If charsetnr is not 63, we have not a BLOB but a TEXT column. we'll dump in hex only BLOB columns. */ is_blob= (opt_hex_blob && field->charsetnr == 63 && (field->type == MYSQL_TYPE_STRING || field->type == MYSQL_TYPE_VAR_STRING || field->type == MYSQL_TYPE_VARCHAR || field->type == MYSQL_TYPE_BLOB || field->type == MYSQL_TYPE_LONG_BLOB || field->type == MYSQL_TYPE_MEDIUM_BLOB || field->type == MYSQL_TYPE_TINY_BLOB)) ? 1 : 0; if (extended_insert) { ulong length = lengths[i]; if (i == 0) dynstr_set(&extended_row,"("); else dynstr_append(&extended_row,","); if (row[i]) { if (length) { if (!IS_NUM_FIELD(field)) { /* "length * 2 + 2" is OK for both HEX and non-HEX modes: - In HEX mode we need exactly 2 bytes per character plus 2 bytes for '0x' prefix. - In non-HEX mode we need up to 2 bytes per character, plus 2 bytes for leading and trailing '\'' characters. */ if (dynstr_realloc(&extended_row,length * 2+2)) { fputs("Aborting dump (out of memory)",stderr); error= EX_EOM; goto err; } if (opt_hex_blob && is_blob) { dynstr_append(&extended_row, "0x"); extended_row.length+= mysql_hex_string(extended_row.str + extended_row.length, row[i], length); extended_row.str[extended_row.length]= '\0'; } else { dynstr_append(&extended_row,"'"); extended_row.length += mysql_real_escape_string(&mysql_connection, &extended_row.str[extended_row.length], row[i],length); extended_row.str[extended_row.length]='\0'; dynstr_append(&extended_row,"'"); } } else { /* change any strings ("inf", "-inf", "nan") into NULL */ char *ptr = row[i]; if (my_isalpha(charset_info, *ptr) || (*ptr == '-' && my_isalpha(charset_info, ptr[1]))) dynstr_append(&extended_row, "NULL"); else { if (field->type == FIELD_TYPE_DECIMAL) { /* add " signs around */ dynstr_append(&extended_row, "'"); dynstr_append(&extended_row, ptr); dynstr_append(&extended_row, "'"); } else dynstr_append(&extended_row, ptr); } } } else dynstr_append(&extended_row,"''"); } else if (dynstr_append(&extended_row,"NULL")) { fputs("Aborting dump (out of memory)",stderr); error= EX_EOM; goto err; } } else { if (i && !opt_xml) { fputc(',', md_result_file); check_io(md_result_file); } if (row[i]) { if (!IS_NUM_FIELD(field)) { if (opt_xml) { print_xml_tag1(md_result_file, "\t\t", "field name=", field->name, ""); print_quoted_xml(md_result_file, row[i], lengths[i]); fputs("</field>\n", md_result_file); } else if (opt_hex_blob && is_blob) { /* sakaik got the idea to to provide blob's in hex notation. */ char *ptr= row[i], *end= ptr+ lengths[i]; fputs("0x", md_result_file); for (; ptr < end ; ptr++) fprintf(md_result_file, "%02X", *((uchar *)ptr)); } else unescape(md_result_file, row[i], lengths[i]); } else { /* change any strings ("inf", "-inf", "nan") into NULL */ char *ptr = row[i]; if (opt_xml) { print_xml_tag1(md_result_file, "\t\t", "field name=", field->name, ""); fputs(!my_isalpha(charset_info, *ptr) ? ptr: "NULL", md_result_file); fputs("</field>\n", md_result_file); } else if (my_isalpha(charset_info, *ptr) || (*ptr == '-' && my_isalpha(charset_info, ptr[1]))) fputs("NULL", md_result_file); else if (field->type == FIELD_TYPE_DECIMAL) { /* add " signs around */ fputc('\'', md_result_file); fputs(ptr, md_result_file); fputc('\'', md_result_file); } else fputs(ptr, md_result_file); } } else { /* The field value is NULL */ if (!opt_xml) fputs("NULL", md_result_file); else print_xml_null_tag(md_result_file, "\t\t", "field name=", field->name, "\n"); } check_io(md_result_file); } } if (opt_xml) { fputs("\t</row>\n", md_result_file); check_io(md_result_file); } if (extended_insert) { ulong row_length; dynstr_append(&extended_row,")"); row_length = 2 + extended_row.length; if (total_length + row_length < opt_net_buffer_length) { total_length += row_length; fputc(',',md_result_file); /* Always row break */ fputs(extended_row.str,md_result_file); } else { if (row_break) fputs(";\n", md_result_file); row_break=1; /* This is first row */ fputs(insert_pat.str,md_result_file); fputs(extended_row.str,md_result_file); total_length = row_length+init_length; } check_io(md_result_file); } else if (!opt_xml) { fputs(");\n", md_result_file); check_io(md_result_file); } } /* XML - close table tag and supress regular output */ if (opt_xml) fputs("\t</table_data>\n", md_result_file); else if (extended_insert && row_break) fputs(";\n", md_result_file); /* If not empty table */ fflush(md_result_file); check_io(md_result_file); if (mysql_errno(sock)) { my_snprintf(query, QUERY_LENGTH, "%s: Error %d: %s when dumping table %s at row: %ld\n", my_progname, mysql_errno(sock), mysql_error(sock), result_table, rownr); fputs(query,stderr); error= EX_CONSCHECK; goto err; } if (opt_lock) { fputs("UNLOCK TABLES;\n", md_result_file); check_io(md_result_file); } if (opt_disable_keys) { fprintf(md_result_file,"/*!40000 ALTER TABLE %s ENABLE KEYS */;\n", opt_quoted_table); check_io(md_result_file); } if (opt_autocommit) { fprintf(md_result_file, "commit;\n"); check_io(md_result_file); } mysql_free_result(res); if (query != query_buf) my_free(query, MYF(MY_ALLOW_ZERO_PTR)); } return; err: if (query != query_buf) my_free(query, MYF(MY_ALLOW_ZERO_PTR)); safe_exit(error); return; } /* dump_table */

static char * field_escape (  char *  to, const char *  from, uint  length )  [static]

Definition at line 1637 of file mysqldump.c. Referenced by add_load_option(). { const char *end; uint end_backslashes=0; for (end= from+length; from != end; from++) { *to++= *from; if (*from == '\\') end_backslashes^=1; /* find odd number of backslashes */ else { if (*from == '\'' && !end_backslashes) *to++= *from; /* We want a duplicate of "'" for MySQL */ end_backslashes=0; } } /* Add missing backslashes if user has specified odd number of backs.*/ if (end_backslashes) *to++= '\\'; return to; } /* field_escape */

static ulong find_set (  TYPELIB *  lib, const char *  x, uint  length, char **  err_pos, uint *  err_len )  [static]

Definition at line 2639 of file mysqldump.c. References find(), find_type(), min, my_isspace, pos(), start, and strmake(). Referenced by sys_var::check_set(), get_one_option(), init_replace(), mysql_prepare_table(), and Field_set::store(). { const char *end= x + length; ulong found= 0; uint find; char buff[255]; *err_pos= 0; /* No error yet */ while (end > x && my_isspace(charset_info, end[-1])) end--; *err_len= 0; if (x != end) { const char *start= x; for (;;) { const char *pos= start; uint var_len; for (; pos != end && *pos != ','; pos++) ; var_len= (uint) (pos - start); strmake(buff, start, min(sizeof(buff), var_len)); find= find_type(buff, lib, var_len); if (!find) { *err_pos= (char*) start; *err_len= var_len; } else found|= ((longlong) 1 << (find - 1)); if (pos == end) break; start= pos + 1; } } return found; }

static void free_table_ent (  char *  key  )  [static]

Definition at line 542 of file mysqldump.c. References my_free, and MYF. Referenced by dump_selected_tables(), and init_table_rule_hash(). { my_free((gptr) key, MYF(0)); }

static int get_actual_table_name (  const char *  old_table_name, char *  new_table_name, int  buf_size )  [static]

Definition at line 2407 of file mysqldump.c. References DBUG_ASSERT, DBUG_ENTER, EX_MYSQLERR, FN_REFLEN, my_snprintf(), mysql_fetch_row(), mysql_free_result(), mysql_num_rows(), mysql_query_with_error_report(), mysql_store_result(), NAME_LEN, query, quote_for_like(), retval, safe_exit(), and strmake(). Referenced by dump_selected_tables(). { int retval; MYSQL_RES *table_res; MYSQL_ROW row; char query[50 + 2*NAME_LEN]; char show_name_buff[FN_REFLEN]; DBUG_ENTER("get_actual_table_name"); /* Check memory for quote_for_like() */ DBUG_ASSERT(2*sizeof(old_table_name) < sizeof(show_name_buff)); my_snprintf(query, sizeof(query), "SHOW TABLES LIKE %s", quote_for_like(old_table_name, show_name_buff)); if (mysql_query_with_error_report(sock, 0, query)) { safe_exit(EX_MYSQLERR); } retval = 1; if ((table_res= mysql_store_result(sock))) { my_ulonglong num_rows= mysql_num_rows(table_res); if (num_rows > 0) { /* Return first row TODO: Return all matching rows */ row= mysql_fetch_row(table_res); strmake(new_table_name, row[0], buf_size-1); retval= 0; } mysql_free_result(table_res); } return retval; }

static my_bool get_one_option (  int  optid, const struct my_option *opt   __attribute__((unused)), char *  argument )  [static]

Definition at line 566 of file mysqldump.c. References compatible_mode_names, compatible_mode_normal_str, create_options, DBUG_ASSERT, DBUG_PUSH, default_charset, default_dbug_option, err_len, err_ptr, EX_EOM, exit, extended_insert, FILE_BINARY, find_set(), find_type(), hash_inited, init_table_rule_hash(), lock_tables, md_result_file, min, MY_ALLOW_ZERO_PTR, MY_FAE, my_fopen(), my_free, my_hash_insert(), my_strdup(), MY_WME, MYF, MYSQL_DEFAULT_CHARSET_NAME, MYSQL_OPT_MASTER_DATA_EFFECTIVE_SQL, MYSQL_PROTOCOL_PIPE, mysql_universal_client_charset, opt_autocommit, opt_comments, opt_compact, OPT_COMPACT, OPT_COMPATIBLE, opt_compatible_mode, opt_compatible_mode_str, opt_create_db, opt_databases, opt_delayed, OPT_DELAYED, opt_disable_keys, opt_drop, OPT_IGNORE_TABLE, opt_lock, opt_master_data, OPT_MASTER_DATA, OPT_MYSQL_PROTOCOL, OPT_OPTIMIZE, opt_password, opt_protocol, opt_quoted, opt_set_charset, OPT_SKIP_OPTIMIZATION, OPT_TABLES, opt_xml, print_version(), quick, sql_protocol_typelib, start, strchr(), strmake(), strmov(), tty_password, and usage. { switch (optid) { case 'p': if (argument) { char *start=argument; my_free(opt_password,MYF(MY_ALLOW_ZERO_PTR)); opt_password=my_strdup(argument,MYF(MY_FAE)); while (*argument) *argument++= 'x'; /* Destroy argument */ if (*start) start[1]=0; /* Cut length of argument */ tty_password= 0; } else tty_password=1; break; case 'r': if (!(md_result_file = my_fopen(argument, O_WRONLY | FILE_BINARY, MYF(MY_WME)))) exit(1); break; case 'W': #ifdef __WIN__ opt_protocol = MYSQL_PROTOCOL_PIPE; #endif break; case 'N': opt_set_charset= 0; break; case 'T': opt_disable_keys=0; break; case '#': DBUG_PUSH(argument ? argument : default_dbug_option); break; #include <sslopt-case.h> case 'V': print_version(); exit(0); case 'X': opt_xml = 1; extended_insert= opt_drop= opt_lock= opt_disable_keys= opt_autocommit= opt_create_db= 0; break; case 'I': case '?': usage(); exit(0); case (int) OPT_MASTER_DATA: if (!argument) /* work like in old versions */ opt_master_data= MYSQL_OPT_MASTER_DATA_EFFECTIVE_SQL; break; case (int) OPT_OPTIMIZE: extended_insert= opt_drop= opt_lock= quick= create_options= opt_disable_keys= lock_tables= opt_set_charset= 1; break; case (int) OPT_SKIP_OPTIMIZATION: extended_insert= opt_drop= opt_lock= quick= create_options= opt_disable_keys= lock_tables= opt_set_charset= 0; break; case (int) OPT_COMPACT: if (opt_compact) { opt_comments= opt_drop= opt_disable_keys= opt_lock= 0; opt_set_charset= 0; } case (int) OPT_TABLES: opt_databases=0; break; case (int) OPT_IGNORE_TABLE: { if (!strchr(argument, '.')) { fprintf(stderr, "Illegal use of option --ignore-table=<database>.<table>\n"); exit(1); } if (!hash_inited(&ignore_table)) init_table_rule_hash(&ignore_table); if (my_hash_insert(&ignore_table, (byte*)my_strdup(argument, MYF(0)))) exit(EX_EOM); break; } case (int) OPT_COMPATIBLE: { char buff[255]; char *end= compatible_mode_normal_str; int i; ulong mode; opt_quoted= 1; opt_set_charset= 0; opt_compatible_mode_str= argument; opt_compatible_mode= find_set(&compatible_mode_typelib, argument, strlen(argument), &err_ptr, &err_len); if (err_len) { strmake(buff, err_ptr, min(sizeof(buff), err_len)); fprintf(stderr, "Invalid mode to --compatible: %s\n", buff); exit(1); } #if !defined(DBUG_OFF) { uint size_for_sql_mode= 0; const char **ptr; for (ptr= compatible_mode_names; *ptr; ptr++) size_for_sql_mode+= strlen(*ptr); size_for_sql_mode+= sizeof(compatible_mode_names)-1; DBUG_ASSERT(sizeof(compatible_mode_normal_str)>=size_for_sql_mode); } #endif mode= opt_compatible_mode; for (i= 0, mode= opt_compatible_mode; mode; mode>>= 1, i++) { if (mode & 1) { end= strmov(end, compatible_mode_names[i]); end= strmov(end, ","); } } if (end!=compatible_mode_normal_str) end[-1]= 0; /* Set charset to the default compiled value if it hasn't been reset yet by --default-character-set=xxx. */ if (default_charset == mysql_universal_client_charset) default_charset= (char*) MYSQL_DEFAULT_CHARSET_NAME; break; } case (int) OPT_MYSQL_PROTOCOL: { if ((opt_protocol= find_type(argument, &sql_protocol_typelib,0)) <= 0) { fprintf(stderr, "Unknown option to protocol: %s\n", argument); exit(1); } break; } #ifndef REMOVE_THIS_CODE_WHEN_FIX_BUG_7815 case (int) OPT_DELAYED: /* Because of http://bugs.mysql.com/bug.php?id=7815, we disable --delayed-insert; when the bug gets fixed by checking the storage engine (using the table definition cache) before printing INSERT DELAYED, we can correct the option's description and re-enable it again (scheduled for later 5.0 or 5.1 versions). It's ok to do the if() below as get_one_option is called after opt_delayed is set. */ if (opt_delayed) { fprintf(stderr, "Warning: ignoring --delayed-insert (as explained " "in the output of 'mysqldump --help').\n"); opt_delayed= 0; } break; #endif } return 0; }

static int get_options (  int *  argc, char ***  argv )  [static]

Definition at line 729 of file mysqldump.c. References charset_info_st::csname, default_charset, enclosed, escaped, exit, fields_terminated, get_charset_by_csname(), get_one_option(), get_tty_password(), handle_options(), lines_terminated, load_default_groups, load_defaults(), lock_tables, md_result_file, MY_CS_PRIMARY, my_progname, MY_WME, MYF, mysql_get_parameters(), MYSQL_OPT_MASTER_DATA_COMMENTED_SQL, NullS, opt_alldbs, opt_databases, opt_delayed, opt_delete_master_logs, opt_enclosed, opt_lock, opt_lock_all_tables, opt_master_data, opt_max_allowed_packet, opt_net_buffer_length, opt_password, opt_single_transaction, st_mysql_parameters::p_max_allowed_packet, st_mysql_parameters::p_net_buffer_length, path, short_usage(), and tty_password. { int ho_error; MYSQL_PARAMETERS *mysql_params= mysql_get_parameters(); opt_max_allowed_packet= *mysql_params->p_max_allowed_packet; opt_net_buffer_length= *mysql_params->p_net_buffer_length; md_result_file= stdout; load_defaults("my",load_default_groups,argc,argv); if ((ho_error=handle_options(argc, argv, my_long_options, get_one_option))) exit(ho_error); *mysql_params->p_max_allowed_packet= opt_max_allowed_packet; *mysql_params->p_net_buffer_length= opt_net_buffer_length; if (opt_delayed) opt_lock=0; /* Can't have lock with delayed */ if (!path && (enclosed || opt_enclosed || escaped || lines_terminated || fields_terminated)) { fprintf(stderr, "%s: You must use option --tab with --fields-...\n", my_progname); return(1); } /* Ensure consistency of the set of binlog & locking options */ if (opt_delete_master_logs && !opt_master_data) opt_master_data= MYSQL_OPT_MASTER_DATA_COMMENTED_SQL; if (opt_single_transaction && opt_lock_all_tables) { fprintf(stderr, "%s: You can't use --single-transaction and " "--lock-all-tables at the same time.\n", my_progname); return(1); } if (opt_master_data) opt_lock_all_tables= !opt_single_transaction; if (opt_single_transaction || opt_lock_all_tables) lock_tables= 0; if (enclosed && opt_enclosed) { fprintf(stderr, "%s: You can't use ..enclosed.. and ..optionally-enclosed.. at the same time.\n", my_progname); return(1); } if ((opt_databases || opt_alldbs) && path) { fprintf(stderr, "%s: --databases or --all-databases can't be used with --tab.\n", my_progname); return(1); } if (strcmp(default_charset, charset_info->csname) && !(charset_info= get_charset_by_csname(default_charset, MY_CS_PRIMARY, MYF(MY_WME)))) exit(1); if ((*argc < 1 && !opt_alldbs) || (*argc > 0 && opt_alldbs)) { short_usage(); return 1; } if (tty_password) opt_password=get_tty_password(NullS); return(0); } /* get_options */

byte* get_table_key (  const char *  entry, uint *  length, my_bool not_used   __attribute__((unused)) )

Definition at line 549 of file mysqldump.c. Referenced by dump_selected_tables(), and init_table_rule_hash(). { *length= strlen(entry); return (byte*) entry; }

static uint get_table_structure (  char *  table, char *  db )  [static]

Definition at line 1175 of file mysqldump.c. References atoi(), check_io(), convert_dirname(), create_options, DBUG_ENTER, DBUG_PRINT, DBUG_RETURN, dynstr_append(), dynstr_append_mem(), dynstr_set(), ER_PARSE_ERROR, ER_WRONG_OBJECT, EX_MYSQLERR, extended_insert, filename, fn_format(), FN_REFLEN, init, init_dynamic_string(), insert_pat_inited, len, lengths, md_result_file, my_fclose(), my_fopen(), my_progname, my_snprintf(), MY_WME, MYF, mysql_data_seek(), mysql_errno(), mysql_error(), mysql_fetch_field_direct(), mysql_fetch_lengths(), mysql_fetch_row(), mysql_free_result(), mysql_num_rows(), mysql_query_with_error_report(), mysql_store_result(), st_mysql_field::name, NAME_LEN, NullS, opt_comments, opt_complete_insert, opt_delayed, opt_drop, opt_ignore, opt_keywords, opt_order_by_primary, opt_quoted, opt_xml, order_by, path, primary_key_fields(), print_xml_row(), print_xml_tag1(), quote_for_like(), quote_name(), safe_exit(), SHOW_DEFAULT, SHOW_EXTRA, SHOW_FIELDNAME, SHOW_NULL, SHOW_TYPE, sql_file, strmov(), tFlag, unescape(), verbose, was_views, write_footer(), and write_header(). Referenced by dump_all_tables_in_db(), and dump_selected_tables(). { MYSQL_RES *tableRes; MYSQL_ROW row; my_bool init=0; uint numFields; char *result_table, *opt_quoted_table; const char *insert_option; char name_buff[NAME_LEN+3],table_buff[NAME_LEN*2+3]; char table_buff2[NAME_LEN*2+3]; char query_buff[512]; FILE *sql_file = md_result_file; int len; DBUG_ENTER("get_table_structure"); DBUG_PRINT("enter", ("db: %s, table: %s", db, table)); if (!insert_pat_inited) { insert_pat_inited= init_dynamic_string(&insert_pat, "", 1024, 1024); } else dynstr_set(&insert_pat, ""); insert_option= ((opt_delayed && opt_ignore) ? " DELAYED IGNORE " : opt_delayed ? " DELAYED " : opt_ignore ? " IGNORE " : ""); if (verbose) fprintf(stderr, "-- Retrieving table structure for table %s...\n", table); len= my_snprintf(query_buff, sizeof(query_buff), "SET OPTION SQL_QUOTE_SHOW_CREATE=%d", (opt_quoted || opt_keywords)); if (!create_options) strmov(query_buff+len, "/*!40102 ,SQL_MODE=concat(@@sql_mode, _utf8 ',NO_KEY_OPTIONS,NO_TABLE_OPTIONS,NO_FIELD_OPTIONS') */"); result_table= quote_name(table, table_buff, 1); opt_quoted_table= quote_name(table, table_buff2, 0); if (opt_order_by_primary) order_by = primary_key_fields(opt_quoted_table); if (!opt_xml && !mysql_query_with_error_report(sock, 0, query_buff)) { /* using SHOW CREATE statement */ if (!tFlag) { /* Make an sql-file, if path was given iow. option -T was given */ char buff[20+FN_REFLEN]; MYSQL_FIELD *field; my_snprintf(buff, sizeof(buff), "show create table %s", result_table); if (mysql_query_with_error_report(sock, 0, buff)) { safe_exit(EX_MYSQLERR); DBUG_RETURN(0); } if (path) { char filename[FN_REFLEN], tmp_path[FN_REFLEN]; convert_dirname(tmp_path,path,NullS); sql_file= my_fopen(fn_format(filename, table, tmp_path, ".sql", 4), O_WRONLY, MYF(MY_WME)); if (!sql_file) /* If file couldn't be opened */ { safe_exit(EX_MYSQLERR); DBUG_RETURN(0); } write_header(sql_file, db); } if (!opt_xml && opt_comments) { fprintf(sql_file, "\n--\n-- Table structure for table %s\n--\n\n", result_table); check_io(sql_file); } if (opt_drop) { fprintf(sql_file, "DROP TABLE IF EXISTS %s;\n", opt_quoted_table); check_io(sql_file); } tableRes= mysql_store_result(sock); field= mysql_fetch_field_direct(tableRes, 0); if (strcmp(field->name, "View") == 0) { if (verbose) fprintf(stderr, "-- It's a view, create dummy table for view\n"); mysql_free_result(tableRes); /* Create a dummy table for the view. ie. a table which has the same columns as the view should have. This table is dropped just before the view is created. The table is used to handle the case where a view references another view, which hasn't yet been created(during the load of the dump). BUG#10927 */ /* Create temp table by selecting from the view */ my_snprintf(query_buff, sizeof(query_buff), "CREATE TEMPORARY TABLE %s SELECT * FROM %s WHERE 0", result_table, result_table); if (mysql_query_with_error_report(sock, 0, query_buff)) { safe_exit(EX_MYSQLERR); DBUG_RETURN(0); } /* Get CREATE statement for the temp table */ my_snprintf(query_buff, sizeof(query_buff), "SHOW CREATE TABLE %s", result_table); if (mysql_query_with_error_report(sock, 0, query_buff)) { safe_exit(EX_MYSQLERR); DBUG_RETURN(0); } tableRes= mysql_store_result(sock); row= mysql_fetch_row(tableRes); if (opt_drop) fprintf(sql_file, "DROP VIEW IF EXISTS %s;\n",opt_quoted_table); /* Print CREATE statement but remove TEMPORARY */ fprintf(sql_file, "CREATE %s;\n", row[1]+17); check_io(sql_file); mysql_free_result(tableRes); /* Drop the temp table */ my_snprintf(buff, sizeof(buff), "DROP TEMPORARY TABLE %s", result_table); if (mysql_query_with_error_report(sock, 0, buff)) { safe_exit(EX_MYSQLERR); DBUG_RETURN(0); } was_views= 1; DBUG_RETURN(0); } row= mysql_fetch_row(tableRes); fprintf(sql_file, "%s;\n", row[1]); check_io(sql_file); mysql_free_result(tableRes); } my_snprintf(query_buff, sizeof(query_buff), "show fields from %s", result_table); if (mysql_query_with_error_report(sock, &tableRes, query_buff)) { if (path) my_fclose(sql_file, MYF(MY_WME)); safe_exit(EX_MYSQLERR); DBUG_RETURN(0); } dynstr_append_mem(&insert_pat, "INSERT ", 7); dynstr_append(&insert_pat, insert_option); dynstr_append_mem(&insert_pat, "INTO ", 5); dynstr_append(&insert_pat, opt_quoted_table); if (opt_complete_insert) { dynstr_append_mem(&insert_pat, " (", 2); } else { dynstr_append_mem(&insert_pat, " VALUES ", 8); if (!extended_insert) dynstr_append_mem(&insert_pat, "(", 1); } while ((row=mysql_fetch_row(tableRes))) { if (init) { if (opt_complete_insert) dynstr_append_mem(&insert_pat, ", ", 2); } init=1; if (opt_complete_insert) dynstr_append(&insert_pat, quote_name(row[SHOW_FIELDNAME], name_buff, 0)); } numFields = (uint) mysql_num_rows(tableRes); mysql_free_result(tableRes); } else { if (verbose) fprintf(stderr, "%s: Warning: Can't set SQL_QUOTE_SHOW_CREATE option (%s)\n", my_progname, mysql_error(sock)); my_snprintf(query_buff, sizeof(query_buff), "show fields from %s", result_table); if (mysql_query_with_error_report(sock, &tableRes, query_buff)) { safe_exit(EX_MYSQLERR); DBUG_RETURN(0); } /* Make an sql-file, if path was given iow. option -T was given */ if (!tFlag) { if (path) { char filename[FN_REFLEN], tmp_path[FN_REFLEN]; convert_dirname(tmp_path,path,NullS); sql_file= my_fopen(fn_format(filename, table, tmp_path, ".sql", 4), O_WRONLY, MYF(MY_WME)); if (!sql_file) /* If file couldn't be opened */ { safe_exit(EX_MYSQLERR); DBUG_RETURN(0); } write_header(sql_file, db); } if (!opt_xml && opt_comments) fprintf(sql_file, "\n--\n-- Table structure for table %s\n--\n\n", result_table); if (opt_drop) fprintf(sql_file, "DROP TABLE IF EXISTS %s;\n",result_table); if (!opt_xml) fprintf(sql_file, "CREATE TABLE %s (\n", result_table); else print_xml_tag1(sql_file, "\t", "table_structure name=", table, "\n"); check_io(sql_file); } dynstr_append_mem(&insert_pat, "INSERT ", 7); dynstr_append(&insert_pat, insert_option); dynstr_append_mem(&insert_pat, "INTO ", 5); dynstr_append(&insert_pat, result_table); if (opt_complete_insert) { dynstr_append_mem(&insert_pat, " (", 2); } else { dynstr_append_mem(&insert_pat, " VALUES ", 8); if (!extended_insert) dynstr_append_mem(&insert_pat, "(", 1); } while ((row=mysql_fetch_row(tableRes))) { ulong *lengths=mysql_fetch_lengths(tableRes); if (init) { if (!opt_xml && !tFlag) { fputs(",\n",sql_file); check_io(sql_file); } if (opt_complete_insert) dynstr_append_mem(&insert_pat, ", ", 2); } init=1; if (opt_complete_insert) dynstr_append(&insert_pat, quote_name(row[SHOW_FIELDNAME], name_buff, 0)); if (!tFlag) { if (opt_xml) { print_xml_row(sql_file, "field", tableRes, &row); continue; } if (opt_keywords) fprintf(sql_file, " %s.%s %s", result_table, quote_name(row[SHOW_FIELDNAME],name_buff, 0), row[SHOW_TYPE]); else fprintf(sql_file, " %s %s", quote_name(row[SHOW_FIELDNAME], name_buff, 0), row[SHOW_TYPE]); if (row[SHOW_DEFAULT]) { fputs(" DEFAULT ", sql_file); unescape(sql_file, row[SHOW_DEFAULT], lengths[SHOW_DEFAULT]); } if (!row[SHOW_NULL][0]) fputs(" NOT NULL", sql_file); if (row[SHOW_EXTRA][0]) fprintf(sql_file, " %s",row[SHOW_EXTRA]); check_io(sql_file); } } numFields = (uint) mysql_num_rows(tableRes); mysql_free_result(tableRes); if (!tFlag) { /* Make an sql-file, if path was given iow. option -T was given */ char buff[20+FN_REFLEN]; uint keynr,primary_key; my_snprintf(buff, sizeof(buff), "show keys from %s", result_table); if (mysql_query_with_error_report(sock, &tableRes, buff)) { if (mysql_errno(sock) == ER_WRONG_OBJECT) { /* it is VIEW */ fputs("\t\t<options Comment=\"view\" />\n", sql_file); goto continue_xml; } fprintf(stderr, "%s: Can't get keys for table %s (%s)\n", my_progname, result_table, mysql_error(sock)); if (path) my_fclose(sql_file, MYF(MY_WME)); safe_exit(EX_MYSQLERR); DBUG_RETURN(0); } /* Find first which key is primary key */ keynr=0; primary_key=INT_MAX; while ((row=mysql_fetch_row(tableRes))) { if (atoi(row[3]) == 1) { keynr++; #ifdef FORCE_PRIMARY_KEY if (atoi(row[1]) == 0 && primary_key == INT_MAX) primary_key=keynr; #endif if (!strcmp(row[2],"PRIMARY")) { primary_key=keynr; break; } } } mysql_data_seek(tableRes,0); keynr=0; while ((row=mysql_fetch_row(tableRes))) { if (opt_xml) { print_xml_row(sql_file, "key", tableRes, &row); continue; } if (atoi(row[3]) == 1) { if (keynr++) putc(')', sql_file); if (atoi(row[1])) /* Test if duplicate key */ /* Duplicate allowed */ fprintf(sql_file, ",\n KEY %s (",quote_name(row[2],name_buff,0)); else if (keynr == primary_key) fputs(",\n PRIMARY KEY (",sql_file); /* First UNIQUE is primary */ else fprintf(sql_file, ",\n UNIQUE %s (",quote_name(row[2],name_buff, 0)); } else putc(',', sql_file); fputs(quote_name(row[4], name_buff, 0), sql_file); if (row[7]) fprintf(sql_file, " (%s)",row[7]); /* Sub key */ check_io(sql_file); } if (!opt_xml) { if (keynr) putc(')', sql_file); fputs("\n)",sql_file); check_io(sql_file); } /* Get MySQL specific create options */ if (create_options) { char show_name_buff[NAME_LEN*2+2+24]; /* Check memory for quote_for_like() */ my_snprintf(buff, sizeof(buff), "show table status like %s", quote_for_like(table, show_name_buff)); if (mysql_query_with_error_report(sock, &tableRes, buff)) { if (mysql_errno(sock) != ER_PARSE_ERROR) { /* If old MySQL version */ if (verbose) fprintf(stderr, "-- Warning: Couldn't get status information for table %s (%s)\n", result_table,mysql_error(sock)); } } else if (!(row=mysql_fetch_row(tableRes))) { fprintf(stderr, "Error: Couldn't read status information for table %s (%s)\n", result_table,mysql_error(sock)); } else { if (opt_xml) { print_xml_row(sql_file, "options", tableRes, &row); } else { fputs("",sql_file); check_io(sql_file); } } mysql_free_result(tableRes); /* Is always safe to free */ } continue_xml: if (!opt_xml) fputs(";\n", sql_file); else fputs("\t</table_structure>\n", sql_file); check_io(sql_file); } } if (opt_complete_insert) { dynstr_append_mem(&insert_pat, ") VALUES ", 9); if (!extended_insert) dynstr_append_mem(&insert_pat, "(", 1); } if (sql_file != md_result_file) { fputs("\n", sql_file); write_footer(sql_file); my_fclose(sql_file, MYF(MY_WME)); } DBUG_RETURN(numFields); } /* get_table_structure */

static my_bool get_view_structure (  char *  table, char *  db )  [static]

Definition at line 2857 of file mysqldump.c. References check_io(), convert_dirname(), DBUG_ENTER, DBUG_RETURN, EX_MYSQLERR, filename, fn_format(), FN_REFLEN, md_result_file, my_fclose(), my_fopen(), my_progname, MY_WME, MYF, mysql_error(), mysql_fetch_field_direct(), mysql_fetch_row(), mysql_free_result(), mysql_query(), mysql_store_result(), st_mysql_field::name, NAME_LEN, NullS, opt_comments, opt_drop, opt_keywords, opt_quoted, opt_xml, path, quote_name(), safe_exit(), sql_file, tFlag, verbose, write_footer(), and write_header(). Referenced by dump_all_views_in_db(), and dump_selected_tables(). { MYSQL_RES *table_res; MYSQL_ROW row; MYSQL_FIELD *field; char *result_table, *opt_quoted_table; char table_buff[NAME_LEN*2+3]; char table_buff2[NAME_LEN*2+3]; char buff[20+FN_REFLEN]; FILE *sql_file = md_result_file; DBUG_ENTER("get_view_structure"); if (tFlag) DBUG_RETURN(0); if (verbose) fprintf(stderr, "-- Retrieving view structure for table %s...\n", table); #ifdef NOT_REALLY_USED_YET sprintf(insert_pat,"SET OPTION SQL_QUOTE_SHOW_CREATE=%d", (opt_quoted || opt_keywords)); #endif result_table= quote_name(table, table_buff, 1); opt_quoted_table= quote_name(table, table_buff2, 0); sprintf(buff,"show create table %s", result_table); if (mysql_query(sock, buff)) { fprintf(stderr, "%s: Can't get CREATE TABLE for view %s (%s)\n", my_progname, result_table, mysql_error(sock)); safe_exit(EX_MYSQLERR); DBUG_RETURN(0); } if (path) { char filename[FN_REFLEN], tmp_path[FN_REFLEN]; convert_dirname(tmp_path,path,NullS); sql_file= my_fopen(fn_format(filename, table, tmp_path, ".sql", 4), O_WRONLY, MYF(MY_WME)); if (!sql_file) /* If file couldn't be opened */ { safe_exit(EX_MYSQLERR); DBUG_RETURN(1); } write_header(sql_file, db); } table_res= mysql_store_result(sock); field= mysql_fetch_field_direct(table_res, 0); if (strcmp(field->name, "View") != 0) { if (verbose) fprintf(stderr, "-- It's base table, skipped\n"); DBUG_RETURN(0); } if (!opt_xml && opt_comments) { fprintf(sql_file, "\n--\n-- View structure for view %s\n--\n\n", result_table); check_io(sql_file); } if (opt_drop) { fprintf(sql_file, "DROP TABLE IF EXISTS %s;\n", opt_quoted_table); fprintf(sql_file, "DROP VIEW IF EXISTS %s;\n", opt_quoted_table); check_io(sql_file); } row= mysql_fetch_row(table_res); fprintf(sql_file, "%s;\n", row[1]); check_io(sql_file); mysql_free_result(table_res); if (sql_file != md_result_file) { fputs("\n", sql_file); write_footer(sql_file); my_fclose(sql_file, MYF(MY_WME)); } DBUG_RETURN(0); }

static char* getTableName (  int  reset  )  [static]

Definition at line 2128 of file mysqldump.c. References mysql_data_seek(), mysql_fetch_row(), mysql_free_result(), mysql_list_tables(), NULL, and NullS. Referenced by dump_all_tables_in_db(), dump_all_views_in_db(), and main(). { static MYSQL_RES *res = NULL; MYSQL_ROW row; if (!res) { if (!(res = mysql_list_tables(sock,NullS))) return(NULL); } if ((row = mysql_fetch_row(res))) return((char*) row[0]); if (reset) mysql_data_seek(res,0); /* We want to read again */ else { mysql_free_result(res); res = NULL; } return(NULL); } /* getTableName */

my_bool include_table (  byte *  hash_key, uint  len )

Definition at line 2275 of file mysqldump.c. References FALSE, hash_search(), and TRUE. Referenced by dump_all_tables_in_db(). { if (hash_search(&ignore_table, (byte*) hash_key, len)) return FALSE; return TRUE; }

static int init_dumping (  char *   )  [static]

Definition at line 2206 of file mysqldump.c. References check_io(), DB_error(), EX_EOM, exit, extended_insert, init_dynamic_string(), md_result_file, my_charset_latin1, my_snprintf(), my_strcasecmp, mysql_fetch_row(), mysql_get_server_version(), mysql_query(), mysql_select_db(), mysql_store_result(), opt_alldbs, opt_comments, opt_create_db, opt_databases, opt_drop_database, opt_quoted, opt_xml, path, and quote_name(). Referenced by dump_all_tables_in_db(), dump_all_views_in_db(), and dump_selected_tables(). { if (mysql_get_server_version(sock) >= 50003 && !my_strcasecmp(&my_charset_latin1, database, "information_schema")) return 1; if (mysql_select_db(sock, database)) { DB_error(sock, "when selecting the database"); return 1; /* If --force */ } if (!path && !opt_xml) { if (opt_databases || opt_alldbs) { /* length of table name * 2 (if name contains quotes), 2 quotes and 0 */ char quoted_database_buf[64*2+3]; char *qdatabase= quote_name(database,quoted_database_buf,opt_quoted); if (opt_comments) { fprintf(md_result_file,"\n--\n-- Current Database: %s\n--\n", qdatabase); check_io(md_result_file); } if (!opt_create_db) { char qbuf[256]; MYSQL_ROW row; MYSQL_RES *dbinfo; my_snprintf(qbuf, sizeof(qbuf), "SHOW CREATE DATABASE IF NOT EXISTS %s", qdatabase); if (mysql_query(sock, qbuf) || !(dbinfo = mysql_store_result(sock))) { /* Old server version, dump generic CREATE DATABASE */ if (opt_drop_database) fprintf(md_result_file, "\n/*!40000 DROP DATABASE IF EXISTS %s;*/\n", qdatabase); fprintf(md_result_file, "\nCREATE DATABASE /*!32312 IF NOT EXISTS*/ %s;\n", qdatabase); } else { if (opt_drop_database) fprintf(md_result_file, "\n/*!40000 DROP DATABASE IF EXISTS %s*/;\n", qdatabase); row = mysql_fetch_row(dbinfo); if (row[1]) { fprintf(md_result_file,"\n%s;\n",row[1]); } } } fprintf(md_result_file,"\nUSE %s;\n", qdatabase); check_io(md_result_file); } } if (extended_insert && init_dynamic_string(&extended_row, "", 1024, 1024)) exit(EX_EOM); return 0; } /* init_dumping */

void init_table_rule_hash (  HASH *  h  )

Definition at line 557 of file mysqldump.c. References EX_EOM, exit, free_table_ent(), get_table_key(), and hash_init. Referenced by get_one_option(). { if (hash_init(h, charset_info, 16, 0, 0, (hash_get_key) get_table_key, (hash_free_key) free_table_ent, 0)) exit(EX_EOM); }

int main (  int  argc, char **  argv )

Definition at line 2942 of file mysqldump.c. References bzero, compatible_mode_normal_str, current_host, current_user, dbConnect(), dbDisconnect(), default_charset, do_flush_tables_read_lock(), do_reset_master(), do_show_master_status(), do_unlock_tables(), dump_all_databases(), dump_databases(), dump_selected_tables(), dynstr_free(), err, EX_MYSQLERR, EX_USAGE, exit, extended_insert, first_error, flush_logs, get_options(), hash_free(), hash_inited, insert_pat_inited, md_result_file, MY_ALLOW_ZERO_PTR, my_end(), my_fclose(), my_free, MY_INIT, MYF, mysql_refresh(), mysql_universal_client_charset, opt_alldbs, opt_databases, opt_delete_master_logs, opt_lock_all_tables, opt_master_data, opt_password, opt_single_transaction, path, REFRESH_LOG, shared_memory_base_name, start_transaction(), test, write_footer(), and write_header(). { compatible_mode_normal_str[0]= 0; default_charset= (char *)mysql_universal_client_charset; bzero((char*) &ignore_table, sizeof(ignore_table)); MY_INIT("mysqldump"); if (get_options(&argc, &argv)) { my_end(0); exit(EX_USAGE); } if (dbConnect(current_host, current_user, opt_password)) exit(EX_MYSQLERR); if (!path) write_header(md_result_file, *argv); if ((opt_lock_all_tables || opt_master_data) && do_flush_tables_read_lock(sock)) goto err; if (opt_single_transaction && start_transaction(sock, test(opt_master_data))) goto err; if (opt_delete_master_logs && do_reset_master(sock)) goto err; if (opt_lock_all_tables || opt_master_data) { if (flush_logs && mysql_refresh(sock, REFRESH_LOG)) goto err; flush_logs= 0; /* not anymore; that would not be sensible */ } if (opt_master_data && do_show_master_status(sock)) goto err; if (opt_single_transaction && do_unlock_tables(sock)) /* unlock but no commit! */ goto err; if (opt_alldbs) dump_all_databases(); else if (argc > 1 && !opt_databases) { /* Only one database and selected table(s) */ dump_selected_tables(*argv, (argv + 1), (argc - 1)); } else { /* One or more databases, all tables */ dump_databases(argv); } #ifdef HAVE_SMEM my_free(shared_memory_base_name,MYF(MY_ALLOW_ZERO_PTR)); #endif /* No reason to explicitely COMMIT the transaction, neither to explicitely UNLOCK TABLES: these will be automatically be done by the server when we disconnect now. Saves some code here, some network trips, adds nothing to server. */ err: dbDisconnect(current_host); if (!path) write_footer(md_result_file); if (md_result_file != stdout) my_fclose(md_result_file, MYF(0)); my_free(opt_password, MYF(MY_ALLOW_ZERO_PTR)); if (hash_inited(&ignore_table)) hash_free(&ignore_table); if (extended_insert) dynstr_free(&extended_row); if (insert_pat_inited) dynstr_free(&insert_pat); my_end(0); return(first_error); } /* main */

static int mysql_query_with_error_report (  MYSQL *  mysql_con, MYSQL_RES **  res, const char *  query )  [static]

Definition at line 825 of file mysqldump.c. References my_printf_error(), my_progname, MYF, mysql_errno(), mysql_error(), mysql_query(), and mysql_store_result(). Referenced by check_if_ignore_table(), dbConnect(), do_flush_tables_read_lock(), do_reset_master(), do_show_master_status(), do_unlock_tables(), dump_all_databases(), dump_all_tables_in_db(), dump_selected_tables(), dump_table(), get_actual_table_name(), get_table_structure(), and start_transaction(). { if (mysql_query(mysql_con, query) || (res && !((*res)= mysql_store_result(mysql_con)))) { my_printf_error(0, "%s: Couldn't execute '%s': %s (%d)", MYF(0), my_progname, query, mysql_error(mysql_con), mysql_errno(mysql_con)); return 1; } return 0; }

static char * primary_key_fields (  const char *  table_name  )  [static]

Definition at line 2785 of file mysqldump.c. References atoi(), cleanup(), my_malloc(), my_snprintf(), MY_WME, MYF, mysql_data_seek(), mysql_error(), mysql_fetch_row(), mysql_free_result(), mysql_query(), mysql_store_result(), NULL, NullS, strmov(), and strxmov(). Referenced by get_table_structure(). { MYSQL_RES *res = NULL; MYSQL_ROW row; /* SHOW KEYS FROM + table name * 2 (escaped) + 2 quotes + \0 */ char show_keys_buff[15 + 64 * 2 + 3]; uint result_length = 0; char *result = 0; my_snprintf(show_keys_buff, sizeof(show_keys_buff), "SHOW KEYS FROM %s", table_name); if (mysql_query(sock, show_keys_buff) || !(res = mysql_store_result(sock))) { fprintf(stderr, "Warning: Couldn't read keys from table %s;" " records are NOT sorted (%s)\n", table_name, mysql_error(sock)); /* Don't exit, because it's better to print out unsorted records */ goto cleanup; } /* * Figure out the length of the ORDER BY clause result. * Note that SHOW KEYS is ordered: a PRIMARY key is always the first * row, and UNIQUE keys come before others. So we only need to check * the first key, not all keys. */ if ((row = mysql_fetch_row(res)) && atoi(row[1]) == 0) { /* Key is unique */ do result_length += strlen(row[4]) + 1; /* + 1 for ',' or \0 */ while ((row = mysql_fetch_row(res)) && atoi(row[3]) > 1); } /* Build the ORDER BY clause result */ if (result_length) { char *end; /* result (terminating \0 is already in result_length) */ result = my_malloc(result_length + 10, MYF(MY_WME)); if (!result) { fprintf(stderr, "Error: Not enough memory to store ORDER BY clause\n"); goto cleanup; } mysql_data_seek(res, 0); row = mysql_fetch_row(res); end = strmov(result, row[4]); while ((row = mysql_fetch_row(res)) && atoi(row[3]) > 1) end = strxmov(end, ",", row[4], NullS); } cleanup: if (res) mysql_free_result(res); return result; }

static void print_quoted_xml (  FILE *  xml_file, const char *  str, ulong  len )  [static]

Definition at line 1027 of file mysqldump.c. References check_io(). Referenced by dump_table(), print_xml_null_tag(), print_xml_row(), and print_xml_tag1(). { const char *end; for (end= str + len; str != end; str++) { switch (*str) { case '<': fputs("&lt;", xml_file); break; case '>': fputs("&gt;", xml_file); break; case '&': fputs("&amp;", xml_file); break; case '\"': fputs("&quot;", xml_file); break; default: fputc(*str, xml_file); break; } } check_io(xml_file); }

static void print_value (  FILE *  file, MYSQL_RES *  result, MYSQL_ROW  row, const char *  prefix, const char *  name, int  string_value )  [static]

Definition at line 2681 of file mysqldump.c. References check_io(), mysql_fetch_field(), mysql_field_seek(), st_mysql_field::name, and unescape(). { MYSQL_FIELD *field; mysql_field_seek(result, 0); for ( ; (field = mysql_fetch_field(result)) ; row++) { if (!strcmp(field->name,name)) { if (row[0] && row[0][0] && strcmp(row[0],"0")) /* Skip default */ { fputc(' ',file); fputs(prefix, file); if (string_value) unescape(file,row[0],(uint) strlen(row[0])); else fputs(row[0], file); check_io(file); return; } } } return; /* This shouldn't happen */ } /* print_value */

static void print_version (  void   )  [static]

Definition at line 427 of file mysqldump.c. References DUMP_VERSION, MACHINE_TYPE, my_progname, NETWARE_SET_SCREEN_MODE, and SYSTEM_TYPE. { printf("%s Ver %s Distrib %s, for %s (%s)\n",my_progname,DUMP_VERSION, MYSQL_SERVER_VERSION,SYSTEM_TYPE,MACHINE_TYPE); NETWARE_SET_SCREEN_MODE(1); } /* print_version */

static void print_xml_null_tag (  FILE *  xml_file, const char *  sbeg, const char *  stag_atr, const char *  sval, const char *  send )  [static]

Definition at line 1108 of file mysqldump.c. References check_io(), and print_quoted_xml(). Referenced by dump_table(). { fputs(sbeg, xml_file); fputs("<", xml_file); fputs(stag_atr, xml_file); fputs("\"", xml_file); print_quoted_xml(xml_file, sval, strlen(sval)); fputs("\" xsi:nil=\"true\" />", xml_file); fputs(send, xml_file); check_io(xml_file); }

static void print_xml_row (  FILE *  xml_file, const char *  row_name, MYSQL_RES *  tableRes, MYSQL_ROW *  row )  [static]

Definition at line 1140 of file mysqldump.c. References check_io(), lengths, mysql_fetch_field(), mysql_fetch_lengths(), mysql_field_seek(), st_mysql_field::name, st_mysql_field::name_length, and print_quoted_xml(). Referenced by get_table_structure(). { uint i; MYSQL_FIELD *field; ulong *lengths= mysql_fetch_lengths(tableRes); fprintf(xml_file, "\t\t<%s", row_name); check_io(xml_file); mysql_field_seek(tableRes, 0); for (i= 0; (field= mysql_fetch_field(tableRes)); i++) { if ((*row)[i]) { fputc(' ', xml_file); print_quoted_xml(xml_file, field->name, field->name_length); fputs("=\"", xml_file); print_quoted_xml(xml_file, (*row)[i], lengths[i]); fputc('"', xml_file); check_io(xml_file); } } fputs(" />\n", xml_file); check_io(xml_file); }

static void print_xml_tag1 (  FILE *  xml_file, const char *  sbeg, const char *  stag_atr, const char *  sval, const char *  send )  [static]

Definition at line 1074 of file mysqldump.c. References check_io(), and print_quoted_xml(). Referenced by dump_all_tables_in_db(), dump_all_views_in_db(), dump_selected_tables(), dump_table(), and get_table_structure(). { fputs(sbeg, xml_file); fputs("<", xml_file); fputs(stag_atr, xml_file); fputs("\"", xml_file); print_quoted_xml(xml_file, sval, strlen(sval)); fputs("\">", xml_file); fputs(send, xml_file); check_io(xml_file); }

static char* quote_for_like (  const char *  name, char *  buff )  [static]

Definition at line 992 of file mysqldump.c. Referenced by check_if_ignore_table(), get_actual_table_name(), and get_table_structure(). { char *to= buff; *to++= '\''; while (*name) { if (*name == '\\') { *to++='\\'; *to++='\\'; *to++='\\'; } else if (*name == '\'' || *name == '_' || *name == '%') *to++= '\\'; *to++= *name++; } to[0]= '\''; to[1]= 0; return buff; }

static char * quote_name (  const char *  name, char *  buff, my_bool  force )  [static]

Definition at line 950 of file mysqldump.c. References MASK_ANSI_QUOTES, opt_compatible_mode, opt_quoted, and test_if_special_chars(). Referenced by dump_all_tables_in_db(), dump_all_views_in_db(), dump_selected_tables(), dump_table(), get_table_structure(), get_view_structure(), and init_dumping(). { char *to= buff; char qtype= (opt_compatible_mode & MASK_ANSI_QUOTES) ? '\"' : '`'; if (!force && !opt_quoted && !test_if_special_chars(name)) return (char*) name; *to++= qtype; while (*name) { if (*name == qtype) *to++= qtype; *to++= *name++; } to[0]= qtype; to[1]= 0; return buff; } /* quote_name */

static void safe_exit (  int  error  )  [static]

Definition at line 840 of file mysqldump.c. References exit, first_error, ignore_errors, and mysql_close(). { if (!first_error) first_error= error; if (ignore_errors) return; if (sock) mysql_close(sock); exit(error); }

static void short_usage (  void   )  [static]

Definition at line 458 of file mysqldump.c. References my_progname, and short_usage_sub(). Referenced by get_options(). { short_usage_sub(); printf("For more options, use %s --help\n", my_progname); }

static void short_usage_sub (  void   )  [static]

Definition at line 435 of file mysqldump.c. References my_progname, and NETWARE_SET_SCREEN_MODE. Referenced by short_usage(), and usage(). { printf("Usage: %s [OPTIONS] database [tables]\n", my_progname); printf("OR %s [OPTIONS] --databases [OPTIONS] DB1 [DB2 DB3...]\n", my_progname); printf("OR %s [OPTIONS] --all-databases [OPTIONS]\n", my_progname); NETWARE_SET_SCREEN_MODE(1); }

static int start_transaction (  MYSQL *  mysql_con, my_bool  consistent_read_now )  [static]

Definition at line 2617 of file mysqldump.c. References mysql_query_with_error_report(). Referenced by main(). { /* We use BEGIN for old servers. --single-transaction --master-data will fail on old servers, but that's ok as it was already silently broken (it didn't do a consistent read, so better tell people frankly, with the error). We want the first consistent read to be used for all tables to dump so we need the REPEATABLE READ level (not anything lower, for example READ COMMITTED would give one new consistent read per dumped table). */ return (mysql_query_with_error_report(mysql_con, 0, "SET SESSION TRANSACTION ISOLATION " "LEVEL REPEATABLE READ") || mysql_query_with_error_report(mysql_con, 0, consistent_read_now ? "START TRANSACTION " "WITH CONSISTENT SNAPSHOT" : "BEGIN")); }

static my_bool test_if_special_chars (  const char *  str  )  [static]

Definition at line 938 of file mysqldump.c. References my_isvar. Referenced by quote_name(). { #if MYSQL_VERSION_ID >= 32300 for ( ; *str ; str++) if (!my_isvar(charset_info,*str) && *str != '$') return 1; #endif return 0; } /* test_if_special_chars */

static void unescape (  FILE *  file, char *  pos, uint  length )  [static]

Definition at line 919 of file mysqldump.c. References check_io(), DBUG_ENTER, DBUG_VOID_RETURN, EX_MYSQLERR, ignore_errors, my_free, my_malloc(), MY_WME, MYF, mysql_real_escape_string(), and safe_exit(). Referenced by dump_table(), get_table_structure(), and print_value(). { char *tmp; DBUG_ENTER("unescape"); if (!(tmp=(char*) my_malloc(length*2+1, MYF(MY_WME)))) { ignore_errors=0; /* Fatal error */ safe_exit(EX_MYSQLERR); /* Force exit */ } mysql_real_escape_string(&mysql_connection, tmp, pos, length); fputc('\'', file); fputs(tmp, file); fputc('\'', file); check_io(file); my_free(tmp, MYF(MY_WME)); DBUG_VOID_RETURN; } /* unescape */

static void usage (  void   )  [static]

Definition at line 445 of file mysqldump.c. References load_default_groups, my_print_help(), my_print_variables(), print_defaults(), print_version(), and short_usage_sub(). { print_version(); puts("By Igor Romanenko, Monty, Jani & Sinisa"); puts("This software comes with ABSOLUTELY NO WARRANTY. This is free software,\nand you are welcome to modify and redistribute it under the GPL license\n"); puts("Dumping definition and data mysql database or table"); short_usage_sub(); print_defaults("my",load_default_groups); my_print_help(my_long_options); my_print_variables(my_long_options); } /* usage */

static void write_footer (  FILE *  sql_file  )  [static]

Definition at line 514 of file mysqldump.c. References check_io(), md_result_file, opt_compact, opt_set_charset, opt_xml, and path. Referenced by get_table_structure(), get_view_structure(), and main(). { if (opt_xml) { fputs("</mysqldump>\n", sql_file); check_io(sql_file); } else if (!opt_compact) { fprintf(sql_file,"\n/*!40101 SET SQL_MODE=@OLD_SQL_MODE */;\n"); if (!path) { fprintf(md_result_file,"\;\n\;\n"); } if (opt_set_charset) fprintf(sql_file, "/*!40101 SET CHARACTER_SET_CLIENT=@OLD_CHARACTER_SET_CLIENT */;\n" "/*!40101 SET CHARACTER_SET_RESULTS=@OLD_CHARACTER_SET_RESULTS */;\n" "/*!40101 SET COLLATION_CONNECTION=@OLD_COLLATION_CONNECTION */;\n"); fprintf(sql_file, "/*!40111 SET SQL_NOTES=@OLD_SQL_NOTES */;\n"); fputs("\n", sql_file); check_io(sql_file); } } /* write_footer */

static void write_header (  FILE *  sql_file, char *  db_name )  [static]

Definition at line 467 of file mysqldump.c. References check_io(), compatible_mode_normal_str, current_host, default_charset, DUMP_VERSION, md_result_file, mysql_get_server_info(), opt_comments, opt_compact, opt_set_charset, opt_xml, and path. Referenced by compress(), get_table_structure(), get_view_structure(), log_group_write_buf(), and main(). { if (opt_xml) { fputs("<?xml version=\"1.0\"?>\n", sql_file); fputs("<mysqldump ", sql_file); fputs("xmlns:xsi=\"http://www.w3.org/2001/XMLSchema-instance\"", sql_file); fputs(">\n", sql_file); check_io(sql_file); } else if (!opt_compact) { if (opt_comments) { fprintf(sql_file, "-- MySQL dump %s\n--\n", DUMP_VERSION); fprintf(sql_file, "-- Host: %s Database: %s\n", current_host ? current_host : "localhost", db_name ? db_name : ""); fputs("-- ------------------------------------------------------\n", sql_file); fprintf(sql_file, "-- Server version\t%s\n", mysql_get_server_info(&mysql_connection)); } if (opt_set_charset) fprintf(sql_file, "\n/*!40101 SET @OLD_CHARACTER_SET_CLIENT=@@CHARACTER_SET_CLIENT */;" "\n/*!40101 SET @OLD_CHARACTER_SET_RESULTS=@@CHARACTER_SET_RESULTS */;" "\n/*!40101 SET @OLD_COLLATION_CONNECTION=@@COLLATION_CONNECTION */;" "\n/*!40101 SET NAMES %s */;\n",default_charset); if (!path) { fprintf(md_result_file,"\;\n\;\n\ "); } fprintf(sql_file, "/*!40101 SET @OLD_SQL_MODE=@@SQL_MODE, SQL_MODE='%s%s%s' */;\n" "/*!40111 SET @OLD_SQL_NOTES=@@SQL_NOTES, SQL_NOTES=0 */;\n", path?"":"NO_AUTO_VALUE_ON_ZERO",compatible_mode_normal_str[0]==0?"":",", compatible_mode_normal_str); check_io(sql_file); } } /* write_header */

---

Variable Documentation

CHARSET_INFO* charset_info = &my_charset_latin1 [static]

Definition at line 122 of file mysqldump.c.

const char* compatible_mode_names[]

Initial value: { "MYSQL323", "MYSQL40", "POSTGRESQL", "ORACLE", "MSSQL", "DB2", "MAXDB", "NO_KEY_OPTIONS", "NO_TABLE_OPTIONS", "NO_FIELD_OPTIONS", "ANSI", NullS } Definition at line 127 of file mysqldump.c. Referenced by get_one_option().

char compatible_mode_normal_str[255] [static]

Definition at line 100 of file mysqldump.c. Referenced by dbConnect(), get_one_option(), main(), and write_header().

TYPELIB compatible_mode_typelib

Initial value: {array_elements(compatible_mode_names) - 1, "", compatible_mode_names, NULL} Definition at line 143 of file mysqldump.c.

my_bool create_options = 1 [static]

Definition at line 82 of file mysqldump.c. Referenced by get_one_option(), get_table_structure(), mysql_create_db(), and mysqld_show_create_db().

char * current_host = 0 [static]

Definition at line 95 of file mysqldump.c.

char * current_user = 0 [static]

Definition at line 94 of file mysqldump.c.

char* default_charset [static]

Definition at line 121 of file mysqldump.c.

const char* default_dbug_option = "d:t:o,/tmp/mysqldump.trace"

Definition at line 123 of file mysqldump.c.

my_bool dFlag = 0 [static]

Definition at line 79 of file mysqldump.c. Referenced by dump_table().

char * enclosed = 0 [static]

Definition at line 96 of file mysqldump.c. Referenced by dump_table(), get_options(), mysql_load(), and write_to_table().

uint err_len = 0 [static]

Definition at line 104 of file mysqldump.c. Referenced by get_one_option().

char * err_ptr = 0 [static]

Definition at line 99 of file mysqldump.c. Referenced by get_one_option().

char * escaped = 0 [static]

Definition at line 96 of file mysqldump.c. Referenced by do_eval(), dump_table(), get_options(), my_wildcmp_unicode(), mysql_load(), parse_quoted_escaped_string(), tokenize_args(), and write_to_table().

my_bool extended_insert = 1 [static]

Definition at line 79 of file mysqldump.c. Referenced by dump_table(), get_one_option(), get_table_structure(), init_dumping(), and main().

DYNAMIC_STRING extended_row [static]

Definition at line 107 of file mysqldump.c.

char * fields_terminated = 0 [static]

Definition at line 95 of file mysqldump.c. Referenced by dump_table(), get_options(), and write_to_table().

int first_error = 0 [static]

Definition at line 106 of file mysqldump.c.

my_bool flush_logs = 0 [static]

Definition at line 80 of file mysqldump.c. Referenced by dump_all_tables_in_db(), dump_all_views_in_db(), dump_selected_tables(), and main().

my_bool ignore_errors = 0 [static]

Definition at line 80 of file mysqldump.c.

HASH ignore_table

Definition at line 146 of file mysqldump.c.

DYNAMIC_STRING insert_pat [static]

Definition at line 93 of file mysqldump.c.

my_bool insert_pat_inited = 0 [static]

Definition at line 92 of file mysqldump.c. Referenced by get_table_structure(), and main().

char * lines_terminated = 0 [static]

Definition at line 96 of file mysqldump.c. Referenced by dump_table(), get_options(), and write_to_table().

const char* load_default_groups[] = { "mysqldump","client",0 } [static]

Definition at line 432 of file mysqldump.c.

my_bool lock_tables = 1 [static]

Definition at line 80 of file mysqldump.c. Referenced by dump_all_tables_in_db(), dump_all_views_in_db(), dump_selected_tables(), get_one_option(), get_options(), main(), mysql_multi_update_prepare(), mysql_test_update(), mysql_update(), open_and_lock_tables(), and simple_open_n_lock_tables().

FILE* md_result_file

Definition at line 109 of file mysqldump.c. Referenced by do_show_master_status(), dump_all_tables_in_db(), dump_all_views_in_db(), dump_selected_tables(), dump_table(), get_one_option(), get_options(), get_table_structure(), get_view_structure(), init_dumping(), main(), write_footer(), and write_header().

struct my_option my_long_options[] [static]

Definition at line 148 of file mysqldump.c.

MYSQL mysql_connection [static]

Definition at line 91 of file mysqldump.c.

const char* mysql_universal_client_charset [static]

Initial value: MYSQL_UNIVERSAL_CLIENT_CHARSET Definition at line 119 of file mysqldump.c. Referenced by get_one_option(), and main().

my_bool opt_alldbs = 0 [static]

Definition at line 83 of file mysqldump.c.

my_bool opt_autocommit = 0 [static]

Definition at line 85 of file mysqldump.c. Referenced by dump_table(), and get_one_option().

my_bool opt_comments = 0 [static]

Definition at line 87 of file mysqldump.c. Referenced by do_show_master_status(), dump_table(), get_one_option(), get_table_structure(), get_view_structure(), init_dumping(), and write_header().

my_bool opt_compact = 0 [static]

Definition at line 87 of file mysqldump.c. Referenced by dump_table(), get_one_option(), write_footer(), and write_header().

ulong opt_compatible_mode = 0 [static]

Definition at line 101 of file mysqldump.c. Referenced by get_one_option(), and quote_name().

char * opt_compatible_mode_str = 0 [static]

Definition at line 98 of file mysqldump.c. Referenced by get_one_option().

my_bool opt_complete_insert = 0 [static]

Definition at line 89 of file mysqldump.c. Referenced by get_table_structure().

my_bool opt_compress = 0 [static]

Definition at line 81 of file mysqldump.c.

my_bool opt_create_db = 0 [static]

Definition at line 83 of file mysqldump.c. Referenced by get_one_option(), and init_dumping().

my_bool opt_databases = 0 [static]

Definition at line 82 of file mysqldump.c.

my_bool opt_delayed = 0 [static]

Definition at line 82 of file mysqldump.c. Referenced by get_one_option(), get_options(), and get_table_structure().

my_bool opt_delete_master_logs = 0 [static]

Definition at line 86 of file mysqldump.c. Referenced by get_options(), and main().

my_bool opt_disable_keys = 1 [static]

Definition at line 85 of file mysqldump.c. Referenced by dump_table(), and get_one_option().

my_bool opt_drop = 1 [static]

Definition at line 81 of file mysqldump.c. Referenced by get_one_option(), get_table_structure(), and get_view_structure().

my_bool opt_drop_database = 0 [static]

Definition at line 89 of file mysqldump.c. Referenced by init_dumping().

char * opt_enclosed = 0 [static]

Definition at line 96 of file mysqldump.c. Referenced by dump_table(), get_options(), and write_to_table().

my_bool opt_hex_blob = 0 [static]

Definition at line 88 of file mysqldump.c. Referenced by dump_table().

my_bool opt_ignore = 0 [static]

Definition at line 88 of file mysqldump.c. Referenced by get_table_structure().

my_bool opt_keywords = 0 [static]

Definition at line 81 of file mysqldump.c. Referenced by get_table_structure(), and get_view_structure().

my_bool opt_lock = 1 [static]

Definition at line 81 of file mysqldump.c. Referenced by dump_table(), get_one_option(), and get_options().

my_bool opt_lock_all_tables = 0 [static]

Definition at line 83 of file mysqldump.c. Referenced by get_options(), and main().

uint opt_master_data [static]

Definition at line 104 of file mysqldump.c. Referenced by do_show_master_status(), get_one_option(), get_options(), and main().

ulong opt_max_allowed_packet [static]

Definition at line 90 of file mysqldump.c.

uint opt_mysql_port = 0 [static]

Definition at line 104 of file mysqldump.c.

my_string opt_mysql_unix_port = 0 [static]

Definition at line 105 of file mysqldump.c.

ulong opt_net_buffer_length [static]

Definition at line 90 of file mysqldump.c.

my_bool opt_order_by_primary = 0 [static]

Definition at line 88 of file mysqldump.c. Referenced by get_table_structure().

char* opt_password = 0 [static]

Definition at line 94 of file mysqldump.c.

uint opt_protocol = 0 [static]

Definition at line 113 of file mysqldump.c.

my_bool opt_quoted = 0 [static]

Definition at line 82 of file mysqldump.c. Referenced by get_one_option(), get_table_structure(), get_view_structure(), init_dumping(), and quote_name().

my_bool opt_set_charset = 0 [static]

Definition at line 84 of file mysqldump.c. Referenced by dbConnect(), get_one_option(), write_footer(), and write_header().

my_bool opt_single_transaction = 0 [static]

Definition at line 87 of file mysqldump.c. Referenced by get_options(), and main().

my_bool opt_xml = 0 [static]

Definition at line 85 of file mysqldump.c.

char * order_by = 0 [static]

Definition at line 97 of file mysqldump.c. Referenced by dump_all_tables_in_db(), dump_selected_tables(), dump_table(), get_table_structure(), opt_search_plan(), and NdbIndexScanOperation::readTuples().

char * path = 0 [static]

Definition at line 95 of file mysqldump.c. Referenced by __db_e_remfile(), __db_ndbm_open(), Table_triggers_list::check_n_load(), close_temporary(), create_tmp_table(), Table_triggers_list::drop_trigger(), dump_table(), el_source(), NdbBackup::execRestore(), Show_instance_log_files::execute(), fil_create_directory_for_tablename(), fil_create_new_single_table_tablespace(), fil_delete_tablespace(), fil_rename_tablespace(), fill_schema_shemata(), find_file_in_path(), fixBackupDataDir(), fixFileSystemPath(), get_all_tables(), get_and_validate_path(), get_options(), get_table_structure(), get_view_structure(), NdbBackup::getBackupDataDirForNode(), ha_create_table_from_engine(), init_dumping(), main(), map_file(), mysql_alter_db(), mysql_change_db(), mysql_create_db(), mysql_create_table(), mysql_drop_view(), mysql_register_view(), mysql_rm_db(), mysql_rm_table_part2(), mysql_truncate(), mysqld_show_create_db(), NdbConfig_AllocHomePath(), NdbConfig_get_path(), open_table(), open_unireg_entry(), os_file_opendir(), quick_rm_table(), removef(), rm_dir_w_symlink(), sp_change_db(), sql_create_definition_file(), srv_parse_data_file_paths_and_sizes(), srv_parse_log_group_home_dirs(), start_process(), Item_load_file::val_str(), write_footer(), and write_header().

my_bool quick = 1 [static]

Definition at line 79 of file mysqldump.c.

MYSQL * sock = 0 [static]

Definition at line 91 of file mysqldump.c.

my_bool tFlag = 0 [static]

Definition at line 79 of file mysqldump.c. Referenced by get_table_structure(), and get_view_structure().

my_bool tty_password = 0 [static]

Definition at line 86 of file mysqldump.c.

my_bool verbose = 0 [static]

Definition at line 79 of file mysqldump.c.

my_bool was_views = 0

Definition at line 125 of file mysqldump.c. Referenced by dump_all_databases(), dump_databases(), dump_selected_tables(), and get_table_structure().

char * where = 0 [static]

Definition at line 97 of file mysqldump.c. Referenced by dump_table(), JOIN::optimize(), and rl_display_search().

---