diff options
author | Sergei Golubchik <sergii@pisem.net> | 2013-09-06 22:31:30 +0200 |
---|---|---|
committer | Sergei Golubchik <sergii@pisem.net> | 2013-09-06 22:31:30 +0200 |
commit | b838d081ad346e52787753b1799c627922c4a6c7 (patch) | |
tree | dc8f1e21e6b40d5b72668571c570c9a3214fbf32 /client | |
parent | 824db55ce53963a64fcf648b54500df22c57e9b2 (diff) | |
parent | 72c36f4415815d55ddb82b23682f3c549906c00e (diff) | |
download | mariadb-git-b838d081ad346e52787753b1799c627922c4a6c7.tar.gz |
mysql-5.5.33 merge
Diffstat (limited to 'client')
-rw-r--r-- | client/mysqlbinlog.cc | 1 | ||||
-rw-r--r-- | client/mysqldump.c | 78 |
2 files changed, 52 insertions, 27 deletions
diff --git a/client/mysqlbinlog.cc b/client/mysqlbinlog.cc index 2f586ce0840..408a7c36139 100644 --- a/client/mysqlbinlog.cc +++ b/client/mysqlbinlog.cc @@ -2546,6 +2546,7 @@ void *sql_alloc(size_t size) the server */ +#include "rpl_tblmap.cc" #undef TABLE #include "my_decimal.h" #include "decimal.c" diff --git a/client/mysqldump.c b/client/mysqldump.c index 86f2be78abe..09a0e509b70 100644 --- a/client/mysqldump.c +++ b/client/mysqldump.c @@ -87,15 +87,6 @@ /* Chars needed to store LONGLONG, excluding trailing '\0'. */ #define LONGLONG_LEN 20 -/* general_log or slow_log tables under mysql database */ -static inline my_bool general_log_or_slow_log_tables(const char *db, - const char *table) -{ - return (strcmp(db, "mysql") == 0) && - ((strcmp(table, "general_log") == 0) || - (strcmp(table, "slow_log") == 0)); -} - static void add_load_option(DYNAMIC_STRING *str, const char *option, const char *option_value); static ulong find_set(TYPELIB *lib, const char *x, uint length, @@ -2466,6 +2457,15 @@ static uint dump_routines_for_db(char *db) DBUG_RETURN(0); } +/* general_log or slow_log tables under mysql database */ +static inline my_bool general_log_or_slow_log_tables(const char *db, + const char *table) +{ + return (!my_strcasecmp(charset_info, db, "mysql")) && + (!my_strcasecmp(charset_info, table, "general_log") || + !my_strcasecmp(charset_info, table, "slow_log")); +} + /* get_table_structure -- retrievs database structure, prints out corresponding CREATE statement and fills out insert_pat if the table is the type we will @@ -4340,7 +4340,8 @@ static int dump_all_tables_in_db(char *database) char table_buff[NAME_LEN*2+3]; char hash_key[2*NAME_LEN+2]; /* "db.tablename" */ char *afterdot; - int using_mysql_db= my_strcasecmp(&my_charset_latin1, database, "mysql"); + my_bool general_log_table_exists= 0, slow_log_table_exists=0; + int using_mysql_db= !my_strcasecmp(charset_info, database, "mysql"); DBUG_ENTER("dump_all_tables_in_db"); afterdot= strmov(hash_key, database); @@ -4351,22 +4352,6 @@ static int dump_all_tables_in_db(char *database) if (opt_xml) print_xml_tag(md_result_file, "", "\n", "database", "name=", database, NullS); - if (strcmp(database, "mysql") == 0) - { - char table_type[NAME_LEN]; - char ignore_flag; - uint num_fields; - num_fields= get_table_structure((char *) "general_log", - database, table_type, &ignore_flag); - if (num_fields == 0) - verbose_msg("-- Warning: get_table_structure() failed with some internal " - "error for 'general_log' table\n"); - num_fields= get_table_structure((char *) "slow_log", - database, table_type, &ignore_flag); - if (num_fields == 0) - verbose_msg("-- Warning: get_table_structure() failed with some internal " - "error for 'slow_log' table\n"); - } if (lock_tables) { DYNAMIC_STRING query; @@ -4412,6 +4397,26 @@ static int dump_all_tables_in_db(char *database) } } } + else + { + /* + If general_log and slow_log exists in the 'mysql' database, + we should dump the table structure. But we cannot + call get_table_structure() here as 'LOCK TABLES' query got executed + above on the session and that 'LOCK TABLES' query does not contain + 'general_log' and 'slow_log' tables. (you cannot acquire lock + on log tables). Hence mark the existence of these log tables here and + after 'UNLOCK TABLES' query is executed on the session, get the table + structure from server and dump it in the file. + */ + if (using_mysql_db) + { + if (!my_strcasecmp(charset_info, table, "general_log")) + general_log_table_exists= 1; + else if (!my_strcasecmp(charset_info, table, "slow_log")) + slow_log_table_exists= 1; + } + } } if (opt_events && mysql_get_server_version(mysql) >= 50106) { @@ -4430,7 +4435,26 @@ static int dump_all_tables_in_db(char *database) } if (lock_tables) (void) mysql_query_with_error_report(mysql, 0, "UNLOCK TABLES"); - if (flush_privileges && using_mysql_db == 0) + if (using_mysql_db) + { + char table_type[NAME_LEN]; + char ignore_flag; + if (general_log_table_exists) + { + if (!get_table_structure((char *) "general_log", + database, table_type, &ignore_flag) ) + verbose_msg("-- Warning: get_table_structure() failed with some internal " + "error for 'general_log' table\n"); + } + if (slow_log_table_exists) + { + if (!get_table_structure((char *) "slow_log", + database, table_type, &ignore_flag) ) + verbose_msg("-- Warning: get_table_structure() failed with some internal " + "error for 'slow_log' table\n"); + } + } + if (flush_privileges && using_mysql_db) { fprintf(md_result_file,"\n--\n-- Flush Grant Tables \n--\n"); fprintf(md_result_file,"\n/*! FLUSH PRIVILEGES */;\n"); |