mysqldump.c 60.3 KB
Newer Older
unknown's avatar
unknown committed
1
/* Copyright (C) 2000 MySQL AB
unknown's avatar
unknown committed
2

unknown's avatar
unknown committed
3 4 5 6
   This program is free software; you can redistribute it and/or modify
   it under the terms of the GNU General Public License as published by
   the Free Software Foundation; either version 2 of the License, or
   (at your option) any later version.
unknown's avatar
unknown committed
7

unknown's avatar
unknown committed
8 9 10 11
   This program is distributed in the hope that it will be useful,
   but WITHOUT ANY WARRANTY; without even the implied warranty of
   MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE.  See the
   GNU General Public License for more details.
unknown's avatar
unknown committed
12

unknown's avatar
unknown committed
13 14 15 16 17 18 19 20
   You should have received a copy of the GNU General Public License
   along with this program; if not, write to the Free Software
   Foundation, Inc., 59 Temple Place, Suite 330, Boston, MA  02111-1307  USA */

/* mysqldump.c  - Dump a tables contents and format to an ASCII file
**
** The author's original notes follow :-
**
unknown's avatar
unknown committed
21 22 23 24 25 26 27 28 29 30 31 32
** AUTHOR: Igor Romanenko (igor@frog.kiev.ua)
** DATE:   December 3, 1994
** WARRANTY: None, expressed, impressed, implied
**	    or other
** STATUS: Public domain
** Adapted and optimized for MySQL by
** Michael Widenius, Sinisa Milivojevic, Jani Tolonen
** -w --where added 9/10/98 by Jim Faucette
** slave code by David Saez Padros <david@ols.es>
** master/autocommit code by Brian Aker <brian@tangent.org>
** SSL by
** Andrei Errapart <andreie@no.spam.ee>
33
** Tõnu Samuel  <tonu@please.do.not.remove.this.spam.ee>
unknown's avatar
unknown committed
34 35
** XML by Gary Huntress <ghuntress@mediaone.net> 10/10/01, cleaned up
** and adapted to mysqldump 05/11/01 by Jani Tolonen
36
** Added --single-transaction option 06/06/2002 by Peter Zaitsev
unknown's avatar
unknown committed
37
** 10 Jun 2003: SET NAMES and --no-set-names by Alexander Barkov
unknown's avatar
unknown committed
38
*/
unknown's avatar
unknown committed
39

unknown's avatar
unknown committed
40
#define DUMP_VERSION "10.7"
unknown's avatar
unknown committed
41

unknown's avatar
unknown committed
42
#include <my_global.h>
unknown's avatar
unknown committed
43 44 45 46
#include <my_sys.h>
#include <m_string.h>
#include <m_ctype.h>

47
#include "client_priv.h"
unknown's avatar
unknown committed
48 49 50 51 52 53 54 55 56 57 58 59 60 61 62 63 64 65 66
#include "mysql.h"
#include "mysql_version.h"
#include "mysqld_error.h"

/* Exit codes */

#define EX_USAGE 1
#define EX_MYSQLERR 2
#define EX_CONSCHECK 3
#define EX_EOM 4

/* index into 'show fields from table' */

#define SHOW_FIELDNAME  0
#define SHOW_TYPE  1
#define SHOW_NULL  2
#define SHOW_DEFAULT  4
#define SHOW_EXTRA  5

67 68 69
/* Size of buffer for dump's select query */
#define QUERY_LENGTH 1536

unknown's avatar
unknown committed
70 71
static char *add_load_option(char *ptr, const char *object,
			     const char *statement);
72 73
static ulong find_set(TYPELIB *lib, const char *x, uint length,
		      char **err_pos, uint *err_len);
unknown's avatar
unknown committed
74 75

static char *field_escape(char *to,const char *from,uint length);
76 77 78 79
static my_bool  verbose=0,tFlag=0,cFlag=0,dFlag=0,quick= 1, extended_insert= 1,
		lock_tables=1,ignore_errors=0,flush_logs=0,replace=0,
		ignore=0,opt_drop=1,opt_keywords=0,opt_lock=1,opt_compress=0,
                opt_delayed=0,create_options=1,opt_quoted=0,opt_databases=0,
80
                opt_alldbs=0,opt_create_db=0,opt_first_slave=0,opt_set_charset,
unknown's avatar
unknown committed
81 82 83
		opt_autocommit=0,opt_master_data,opt_disable_keys=1,opt_xml=0,
		opt_delete_master_logs=0, tty_password=0,
		opt_single_transaction=0, opt_comments= 0, opt_compact= 0;
84
static ulong opt_max_allowed_packet, opt_net_buffer_length;
unknown's avatar
unknown committed
85
static MYSQL mysql_connection,*sock=0;
86
static char  insert_pat[12 * 1024],*opt_password=0,*current_user=0,
unknown's avatar
unknown committed
87 88
             *current_host=0,*path=0,*fields_terminated=0,
             *lines_terminated=0, *enclosed=0, *opt_enclosed=0, *escaped=0,
unknown's avatar
unknown committed
89
             *where=0,
90
             *opt_compatible_mode_str= 0,
91
             *err_ptr= 0;
92
static char compatible_mode_normal_str[255];
93 94
static ulong opt_compatible_mode= 0;
static uint     opt_mysql_port= 0, err_len= 0;
unknown's avatar
unknown committed
95 96 97
static my_string opt_mysql_unix_port=0;
static int   first_error=0;
static DYNAMIC_STRING extended_row;
98
#include <sslopt-vars.h>
unknown's avatar
unknown committed
99
FILE  *md_result_file;
100 101 102
#ifdef HAVE_SMEM
static char *shared_memory_base_name=0;
#endif
103
static uint opt_protocol= 0;
unknown's avatar
unknown committed
104
static char *default_charset= (char*) MYSQL_UNIVERSAL_CLIENT_CHARSET;
105
static CHARSET_INFO *charset_info= &my_charset_latin1;
unknown's avatar
unknown committed
106
const char *default_dbug_option="d:t:o,/tmp/mysqldump.trace";
107 108 109 110

const char *compatible_mode_names[]=
{
  "MYSQL323", "MYSQL40", "POSTGRESQL", "ORACLE", "MSSQL", "DB2",
111 112
  "MAXDB", "NO_KEY_OPTIONS", "NO_TABLE_OPTIONS", "NO_FIELD_OPTIONS",
  "ANSI",
113 114
  NullS
};
115 116 117 118 119 120 121 122 123
#define MASK_ANSI_QUOTES \
(\
 (1<<2)  | /* POSTGRESQL */\
 (1<<3)  | /* ORACLE     */\
 (1<<4)  | /* MSSQL      */\
 (1<<5)  | /* DB2        */\
 (1<<6)  | /* MAXDB      */\
 (1<<10)   /* ANSI       */\
)
124 125 126
TYPELIB compatible_mode_typelib= {array_elements(compatible_mode_names) - 1,
				  "", compatible_mode_names};

unknown's avatar
unknown committed
127

128
static struct my_option my_long_options[] =
unknown's avatar
unknown committed
129
{
130 131 132 133 134
  {"all-databases", 'A',
   "Dump all the databases. This will be same as --databases with all databases selected.",
   (gptr*) &opt_alldbs, (gptr*) &opt_alldbs, 0, GET_BOOL, NO_ARG, 0, 0, 0, 0,
   0, 0},
  {"add-drop-table", OPT_DROP, "Add a 'drop table' before each create.",
135
   (gptr*) &opt_drop, (gptr*) &opt_drop, 0, GET_BOOL, NO_ARG, 1, 0, 0, 0, 0,
136 137
   0},
  {"add-locks", OPT_LOCKS, "Add locks around insert statements.",
138
   (gptr*) &opt_lock, (gptr*) &opt_lock, 0, GET_BOOL, NO_ARG, 1, 0, 0, 0, 0,
139 140 141 142 143
   0},
  {"allow-keywords", OPT_KEYWORDS,
   "Allow creation of column names that are keywords.", (gptr*) &opt_keywords,
   (gptr*) &opt_keywords, 0, GET_BOOL, NO_ARG, 0, 0, 0, 0, 0, 0},
  {"character-sets-dir", OPT_CHARSETS_DIR,
144
   "Directory where character sets are.", (gptr*) &charsets_dir,
145
   (gptr*) &charsets_dir, 0, GET_STR, REQUIRED_ARG, 0, 0, 0, 0, 0, 0},
146
  {"compatible", OPT_COMPATIBLE,
unknown's avatar
unknown committed
147
   "Change the dump to be compatible with a given mode. By default tables are dumped in a format optimized for MySQL. Legal modes are: ansi, mysql323, mysql40, postgresql, oracle, mssql, db2, maxdb, no_key_options, no_table_options, no_field_options. One can use several modes separated by commas. Note: Requires MySQL server version 4.1.0 or higher. This option is ignored with earlier server versions.",
148 149
   (gptr*) &opt_compatible_mode_str, (gptr*) &opt_compatible_mode_str, 0,
   GET_STR, REQUIRED_ARG, 0, 0, 0, 0, 0, 0},
unknown's avatar
unknown committed
150 151 152 153
  {"compact", OPT_COMPACT,
   "Give less verbose output (useful for debugging). Disables structure comments and header/footer constructs.  Enables options --skip-add-drop-table --no-set-names --skip-disable-keys --skip-lock-tables",
   (gptr*) &opt_compact, (gptr*) &opt_compact, 0, GET_BOOL, NO_ARG, 0, 0, 0, 0,
   0, 0},
154 155
  {"complete-insert", 'c', "Use complete insert statements.", (gptr*) &cFlag,
   (gptr*) &cFlag, 0, GET_BOOL, NO_ARG, 0, 0, 0, 0, 0, 0},
156 157 158
  {"compress", 'C', "Use compression in server/client protocol.",
   (gptr*) &opt_compress, (gptr*) &opt_compress, 0, GET_BOOL, NO_ARG, 0, 0, 0,
   0, 0, 0},
unknown's avatar
unknown committed
159 160 161 162
  {"create-options", OPT_CREATE_OPTIONS,
   "Include all MySQL specific create options.",
   (gptr*) &create_options, (gptr*) &create_options, 0, GET_BOOL, NO_ARG, 1,
   0, 0, 0, 0, 0},
163 164 165 166
  {"databases", 'B',
   "To dump several databases. Note the difference in usage; In this case no tables are given. All name arguments are regarded as databasenames. 'USE db_name;' will be included in the output.",
   (gptr*) &opt_databases, (gptr*) &opt_databases, 0, GET_BOOL, NO_ARG, 0, 0,
   0, 0, 0, 0},
unknown's avatar
unknown committed
167 168 169 170 171 172 173
#ifdef DBUG_OFF
  {"debug", '#', "This is a non-debug version. Catch this and exit",
   0,0, 0, GET_DISABLED, OPT_ARG, 0, 0, 0, 0, 0, 0},
#else
  {"debug", '#', "Output debug log", (gptr*) &default_dbug_option,
   (gptr*) &default_dbug_option, 0, GET_STR, OPT_ARG, 0, 0, 0, 0, 0, 0},
#endif
174 175 176 177 178 179
  {"default-character-set", OPT_DEFAULT_CHARSET,
   "Set the default character set.", (gptr*) &default_charset,
   (gptr*) &default_charset, 0, GET_STR, REQUIRED_ARG, 0, 0, 0, 0, 0, 0},
  {"delayed-insert", OPT_DELAYED, "Insert rows with INSERT DELAYED.",
   (gptr*) &opt_delayed, (gptr*) &opt_delayed, 0, GET_BOOL, NO_ARG, 0, 0, 0, 0,
   0, 0},
unknown's avatar
unknown committed
180
  {"delete-master-logs", OPT_DELETE_MASTER_LOGS,
unknown's avatar
unknown committed
181
   "Delete logs on master after backup. This automatically enables --first-slave.",
unknown's avatar
unknown committed
182
   0, 0, 0, GET_NO_ARG, NO_ARG, 0, 0, 0, 0, 0, 0},
183 184
  {"disable-keys", 'K',
   "'/*!40000 ALTER TABLE tb_name DISABLE KEYS */; and '/*!40000 ALTER TABLE tb_name ENABLE KEYS */; will be put in the output.", (gptr*) &opt_disable_keys,
185
   (gptr*) &opt_disable_keys, 0, GET_BOOL, NO_ARG, 1, 0, 0, 0, 0, 0},
186 187 188
  {"extended-insert", 'e',
   "Allows utilization of the new, much faster INSERT syntax.",
   (gptr*) &extended_insert, (gptr*) &extended_insert, 0, GET_BOOL, NO_ARG,
189
   1, 0, 0, 0, 0, 0},
190 191 192 193 194 195 196 197 198 199
  {"fields-terminated-by", OPT_FTB,
   "Fields in the textfile are terminated by ...", (gptr*) &fields_terminated,
   (gptr*) &fields_terminated, 0, GET_STR, REQUIRED_ARG, 0, 0, 0, 0, 0, 0},
  {"fields-enclosed-by", OPT_ENC,
   "Fields in the importfile are enclosed by ...", (gptr*) &enclosed,
   (gptr*) &enclosed, 0, GET_STR, REQUIRED_ARG, 0, 0, 0, 0 ,0, 0},
  {"fields-optionally-enclosed-by", OPT_O_ENC,
   "Fields in the i.file are opt. enclosed by ...", (gptr*) &opt_enclosed,
   (gptr*) &opt_enclosed, 0, GET_STR, REQUIRED_ARG, 0, 0, 0, 0 ,0, 0},
  {"fields-escaped-by", OPT_ESC, "Fields in the i.file are escaped by ...",
unknown's avatar
unknown committed
200
   (gptr*) &escaped, (gptr*) &escaped, 0, GET_STR, REQUIRED_ARG, 0, 0, 0, 0, 0, 0},
201 202 203
  {"first-slave", 'x', "Locks all tables across all databases.",
   (gptr*) &opt_first_slave, (gptr*) &opt_first_slave, 0, GET_BOOL, NO_ARG,
   0, 0, 0, 0, 0, 0},
unknown's avatar
unknown committed
204 205 206 207
  {"flush-logs", 'F', "Flush logs file in server before starting dump. "
    "Note that if you dump many databases at once (using the option "
    "--databases= or --all-databases), the logs will be flushed for "
    "each database dumped.",
208 209 210 211 212 213 214 215
   (gptr*) &flush_logs, (gptr*) &flush_logs, 0, GET_BOOL, NO_ARG, 0, 0, 0, 0,
   0, 0},
  {"force", 'f', "Continue even if we get an sql-error.",
   (gptr*) &ignore_errors, (gptr*) &ignore_errors, 0, GET_BOOL, NO_ARG,
   0, 0, 0, 0, 0, 0},
  {"help", '?', "Display this help message and exit.", 0, 0, 0, GET_NO_ARG,
   NO_ARG, 0, 0, 0, 0, 0, 0},
  {"host", 'h', "Connect to host.", (gptr*) &current_host,
216
   (gptr*) &current_host, 0, GET_STR_ALLOC, REQUIRED_ARG, 0, 0, 0, 0, 0, 0},
217 218 219 220
  {"lines-terminated-by", OPT_LTB, "Lines in the i.file are terminated by ...",
   (gptr*) &lines_terminated, (gptr*) &lines_terminated, 0, GET_STR,
   REQUIRED_ARG, 0, 0, 0, 0, 0, 0},
  {"lock-tables", 'l', "Lock all tables for read.", (gptr*) &lock_tables,
221
   (gptr*) &lock_tables, 0, GET_BOOL, NO_ARG, 1, 0, 0, 0, 0, 0},
222
  {"master-data", OPT_MASTER_DATA,
unknown's avatar
unknown committed
223
   "This causes the master position and filename to be appended to your output. This automatically enables --first-slave.",
224 225 226 227 228
   0, 0, 0, GET_NO_ARG, NO_ARG, 0, 0, 0, 0, 0, 0},
  {"no-autocommit", OPT_AUTOCOMMIT,
   "Wrap tables with autocommit/commit statements.",
   (gptr*) &opt_autocommit, (gptr*) &opt_autocommit, 0, GET_BOOL, NO_ARG,
   0, 0, 0, 0, 0, 0},
229 230
  {"single-transaction", OPT_TRANSACTION,
   "Dump all tables in single transaction to get consistent snapshot. Mutually exclusive with --lock-tables.",
231
   (gptr*) &opt_single_transaction, (gptr*) &opt_single_transaction, 0,
232
   GET_BOOL, NO_ARG,  0, 0, 0, 0, 0, 0},
233
  {"no-create-db", 'n',
234
   "'CREATE DATABASE /*!32312 IF NOT EXISTS*/ db_name;' will not be put in the output. The above line will be added otherwise, if --databases or --all-databases option was given.}.",
235 236 237
   (gptr*) &opt_create_db, (gptr*) &opt_create_db, 0, GET_BOOL, NO_ARG, 0, 0,
   0, 0, 0, 0},
  {"no-create-info", 't', "Don't write table creation info.",
238 239 240
   (gptr*) &tFlag, (gptr*) &tFlag, 0, GET_BOOL, NO_ARG, 0, 0, 0, 0, 0, 0},
  {"no-data", 'd', "No row information.", (gptr*) &dFlag, (gptr*) &dFlag, 0,
   GET_BOOL, NO_ARG, 0, 0, 0, 0, 0, 0},
unknown's avatar
unknown committed
241
  {"no-set-names", 'N',
unknown's avatar
unknown committed
242
   "Deprecated, use --set-charset or --skip-set-charset to enable/disable charset settings instead",
243 244
   0, 0, 0, GET_NO_ARG, NO_ARG, 0, 0, 0, 0, 0, 0},
  {"set-charset", OPT_SET_CHARSET,
unknown's avatar
unknown committed
245
   "Add 'SET NAMES default_character_set' to the output. Enabled by default; suppress with --skip-set-charset.",
246 247
   (gptr*) &opt_set_charset, (gptr*) &opt_set_charset, 0, GET_BOOL, NO_ARG, 1,
   0, 0, 0, 0, 0},
248
  {"set-variable", 'O',
unknown's avatar
unknown committed
249
   "Change the value of a variable. Please note that this option is deprecated; you can set variables directly with --variable-name=value.",
250 251
   0, 0, 0, GET_STR, REQUIRED_ARG, 0, 0, 0, 0, 0, 0},
  {"opt", OPT_OPTIMIZE,
252
   "Same as --add-drop-table, --add-locks, --create-options, --quick, --extended-insert, --lock-tables, --set-charset, and --disable-keys. Enabled by default, disable with --skip-opt.",
253 254 255 256
   0, 0, 0, GET_NO_ARG, NO_ARG, 0, 0, 0, 0, 0, 0},
  {"password", 'p',
   "Password to use when connecting to server. If password is not given it's solicited on the tty.",
   0, 0, 0, GET_STR, OPT_ARG, 0, 0, 0, 0, 0, 0},
unknown's avatar
unknown committed
257
#ifdef __WIN__
258
  {"pipe", 'W', "Use named pipes to connect to server.", 0, 0, 0, GET_NO_ARG,
259
   NO_ARG, 0, 0, 0, 0, 0, 0},
unknown's avatar
unknown committed
260
#endif
261 262 263
  {"port", 'P', "Port number to use for connection.", (gptr*) &opt_mysql_port,
   (gptr*) &opt_mysql_port, 0, GET_UINT, REQUIRED_ARG, MYSQL_PORT, 0, 0, 0, 0,
   0},
264
  {"protocol", OPT_MYSQL_PROTOCOL, "The protocol of connection (tcp,socket,pipe,memory).",
265
   0, 0, 0, GET_STR,  REQUIRED_ARG, 0, 0, 0, 0, 0, 0},
266
  {"quick", 'q', "Don't buffer query, dump directly to stdout.",
267
   (gptr*) &quick, (gptr*) &quick, 0, GET_BOOL, NO_ARG, 1, 0, 0, 0, 0, 0},
268
  {"quote-names",'Q', "Quote table and column names with backticks (`).",
269
   (gptr*) &opt_quoted, (gptr*) &opt_quoted, 0, GET_BOOL, NO_ARG, 1, 0, 0, 0,
270 271
   0, 0},
  {"result-file", 'r',
unknown's avatar
unknown committed
272
   "Direct output to a given file. This option should be used in MSDOS, because it prevents new line '\\n' from being converted to '\\r\\n' (carriage return + line feed).",
unknown's avatar
unknown committed
273
   0, 0, 0, GET_STR, REQUIRED_ARG, 0, 0, 0, 0, 0, 0},
274 275
#ifdef HAVE_SMEM
  {"shared_memory_base_name", OPT_SHARED_MEMORY_BASE_NAME,
276
   "Base name of shared memory.", (gptr*) &shared_memory_base_name, (gptr*) &shared_memory_base_name,
277 278
   0, GET_STR_ALLOC, REQUIRED_ARG, 0, 0, 0, 0, 0, 0},
#endif
279
  {"skip-opt", OPT_SKIP_OPTIMIZATION,
280
   "Disable --opt. Disables --add-drop-table, --add-locks, --create-options, --quick, --extended-insert, --lock-tables, --set-charset, and --disable-keys.",
281
   0, 0, 0, GET_NO_ARG, NO_ARG, 0, 0, 0, 0, 0, 0},
282 283 284
  {"socket", 'S', "Socket file to use for connection.",
   (gptr*) &opt_mysql_unix_port, (gptr*) &opt_mysql_unix_port, 0, GET_STR,
   REQUIRED_ARG, 0, 0, 0, 0, 0, 0},
285
#include <sslopt-longopts.h>
286 287 288 289 290
  {"tab",'T',
   "Creates tab separated textfile for each table to given path. (creates .sql and .txt files). NOTE: This only works if mysqldump is run on the same machine as the mysqld daemon.",
   (gptr*) &path, (gptr*) &path, 0, GET_STR, REQUIRED_ARG, 0, 0, 0, 0, 0, 0},
  {"tables", OPT_TABLES, "Overrides option --databases (-B).",
   0, 0, 0, GET_NO_ARG, NO_ARG, 0, 0, 0, 0, 0, 0},
unknown's avatar
unknown committed
291
#ifndef DONT_ALLOW_USER_CHANGE
292 293 294
  {"user", 'u', "User for login if not current user.",
   (gptr*) &current_user, (gptr*) &current_user, 0, GET_STR, REQUIRED_ARG,
   0, 0, 0, 0, 0, 0},
unknown's avatar
unknown committed
295
#endif
296 297 298 299 300 301 302 303
  {"verbose", 'v', "Print info about the various stages.",
   (gptr*) &verbose, (gptr*) &verbose, 0, GET_BOOL, NO_ARG, 0, 0, 0, 0, 0, 0},
  {"version",'V', "Output version information and exit.", 0, 0, 0,
   GET_NO_ARG, NO_ARG, 0, 0, 0, 0, 0, 0},
  {"where", 'w', "Dump only selected records; QUOTES mandatory!",
   (gptr*) &where, (gptr*) &where, 0, GET_STR, REQUIRED_ARG, 0, 0, 0, 0, 0, 0},
  {"xml", 'X', "Dump a database as well formed XML.", 0, 0, 0, GET_NO_ARG,
   NO_ARG, 0, 0, 0, 0, 0, 0},
304
  {"max_allowed_packet", OPT_MAX_ALLOWED_PACKET, "",
305
    (gptr*) &opt_max_allowed_packet, (gptr*) &opt_max_allowed_packet, 0,
306 307
    GET_ULONG, REQUIRED_ARG, 24*1024*1024, 4096, 
   (longlong) 2L*1024L*1024L*1024L, MALLOC_OVERHEAD, 1024, 0},
308
  {"net_buffer_length", OPT_NET_BUFFER_LENGTH, "",
309
    (gptr*) &opt_net_buffer_length, (gptr*) &opt_net_buffer_length, 0,
310
    GET_ULONG, REQUIRED_ARG, 1024*1024L-1025, 4096, 16*1024L*1024L,
unknown's avatar
merge  
unknown committed
311
    MALLOC_OVERHEAD-1024, 1024, 0},
312 313 314
  {"comments", 'i', "Write additional information.",
   (gptr*) &opt_comments, (gptr*) &opt_comments, 0, GET_BOOL, NO_ARG,
   1, 0, 0, 0, 0, 0},
315
  {0, 0, 0, 0, 0, 0, GET_NO_ARG, NO_ARG, 0, 0, 0, 0, 0, 0}
unknown's avatar
unknown committed
316 317 318 319 320
};

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

static void safe_exit(int error);
321
static void write_header(FILE *sql_file, char *db_name);
unknown's avatar
unknown committed
322 323 324 325 326 327 328 329
static void print_value(FILE *file, MYSQL_RES  *result, MYSQL_ROW row,
			const char *prefix,const char *name,
			int string_value);
static int dump_selected_tables(char *db, char **table_names, int tables);
static int dump_all_tables_in_db(char *db);
static int init_dumping(char *);
static int dump_databases(char **);
static int dump_all_databases();
unknown's avatar
unknown committed
330
static char *quote_name(const char *name, char *buff, my_bool force);
331 332
static const char *check_if_ignore_table(const char *table_name);

unknown's avatar
unknown committed
333
#include <help_start.h>
unknown's avatar
unknown committed
334 335 336 337

static void print_version(void)
{
  printf("%s  Ver %s Distrib %s, for %s (%s)\n",my_progname,DUMP_VERSION,
unknown's avatar
unknown committed
338 339
         MYSQL_SERVER_VERSION,SYSTEM_TYPE,MACHINE_TYPE);
  NETWARE_SET_SCREEN_MODE(1);
unknown's avatar
unknown committed
340 341 342
} /* print_version */


343 344 345 346 347 348
static void short_usage_sub(void)
{
  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);
unknown's avatar
unknown committed
349
  NETWARE_SET_SCREEN_MODE(1);
350 351
}

unknown's avatar
unknown committed
352

unknown's avatar
unknown committed
353 354 355 356 357 358
static void usage(void)
{
  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");
359
  short_usage_sub();
unknown's avatar
unknown committed
360
  print_defaults("my",load_default_groups);
361 362
  my_print_help(my_long_options);
  my_print_variables(my_long_options);
unknown's avatar
unknown committed
363 364 365
} /* usage */


366 367 368 369 370 371
static void short_usage(void)
{
  short_usage_sub();
  printf("For more options, use %s --help\n", my_progname);
}

unknown's avatar
unknown committed
372 373
#include <help_end.h>

374

375
static void write_header(FILE *sql_file, char *db_name)
unknown's avatar
unknown committed
376
{
unknown's avatar
unknown committed
377
  if (opt_xml)
unknown's avatar
unknown committed
378
  {
379 380
    fputs("<?xml version=\"1.0\"?>\n", sql_file);
    fputs("<mysqldump>\n", sql_file);
unknown's avatar
unknown committed
381
  }
unknown's avatar
unknown committed
382
  else if (!opt_compact)
unknown's avatar
unknown committed
383
  {
unknown's avatar
unknown committed
384 385 386 387 388 389 390 391 392 393 394
    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));
    }
395
    if (opt_set_charset)
unknown's avatar
unknown committed
396 397 398 399 400
      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);
401 402 403
    if (!path)
    {
      fprintf(md_result_file,"\
404 405 406
/*!40014 SET @OLD_UNIQUE_CHECKS=@@UNIQUE_CHECKS, UNIQUE_CHECKS=0 */;\n\
/*!40014 SET @OLD_FOREIGN_KEY_CHECKS=@@FOREIGN_KEY_CHECKS, FOREIGN_KEY_CHECKS=0 */;\n\
");
407 408
    }
    fprintf(sql_file,
unknown's avatar
Merge  
unknown committed
409 410 411
	    "/*!40101 SET @OLD_SQL_MODE=@@SQL_MODE, SQL_MODE=\"%s%s%s\" */;\n",
	    path?"":"NO_AUTO_VALUE_ON_ZERO",compatible_mode_normal_str[0]==0?"":",",
	    compatible_mode_normal_str);
unknown's avatar
unknown committed
412
  }
413
} /* write_header */
unknown's avatar
unknown committed
414

415

unknown's avatar
unknown committed
416 417 418
static void write_footer(FILE *sql_file)
{
  if (opt_xml)
unknown's avatar
unknown committed
419 420
    fputs("</mysqldump>\n", sql_file);
  else if (!opt_compact)
421
  {
422 423 424 425
    fprintf(sql_file,"\n/*!40101 SET SQL_MODE=@OLD_SQL_MODE */;\n");
    if (!path)
    {
      fprintf(md_result_file,"\
426
/*!40014 SET FOREIGN_KEY_CHECKS=@OLD_FOREIGN_KEY_CHECKS */;\n\
unknown's avatar
unknown committed
427
/*!40014 SET UNIQUE_CHECKS=@OLD_UNIQUE_CHECKS */;\n");
428
    }
429
    if (opt_set_charset)
430
      fprintf(sql_file,
unknown's avatar
unknown committed
431 432 433
"/*!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");
unknown's avatar
unknown committed
434
    fputs("\n", sql_file);
435
  }
unknown's avatar
unknown committed
436
} /* write_footer */
unknown's avatar
unknown committed
437

438

unknown's avatar
unknown committed
439

440 441 442
static my_bool
get_one_option(int optid, const struct my_option *opt __attribute__((unused)),
	       char *argument)
unknown's avatar
unknown committed
443
{
unknown's avatar
unknown committed
444
  switch (optid) {
445 446 447 448
  case OPT_MASTER_DATA:
    opt_master_data=1;
    opt_first_slave=1;
    break;
unknown's avatar
unknown committed
449 450 451 452
  case OPT_DELETE_MASTER_LOGS:
    opt_delete_master_logs=1;
    opt_first_slave=1;
    break;
453 454 455 456 457 458 459 460 461 462 463 464 465 466
  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 */
    }
    else
      tty_password=1;
    break;
  case 'r':
unknown's avatar
unknown committed
467
    if (!(md_result_file = my_fopen(argument, O_WRONLY | FILE_BINARY,
468 469 470 471
				    MYF(MY_WME))))
      exit(1);
    break;
  case 'W':
unknown's avatar
unknown committed
472
#ifdef __WIN__
473
    opt_protocol = MYSQL_PROTOCOL_PIPE;
unknown's avatar
unknown committed
474
#endif
475
    break;
476 477 478
  case 'N':
    opt_set_charset= 0;
    break;
479 480 481 482
  case 'T':
    opt_disable_keys=0;
    break;
  case '#':
unknown's avatar
unknown committed
483
    DBUG_PUSH(argument ? argument : default_dbug_option);
484
    break;
485
#include <sslopt-case.h>
486 487 488
  case 'V': print_version(); exit(0);
  case 'X':
    opt_xml = 1;
489 490
    extended_insert= opt_drop= opt_lock= 
      opt_disable_keys= opt_autocommit= opt_create_db= 0;
491 492 493 494 495 496
    break;
  case 'I':
  case '?':
    usage();
    exit(0);
  case (int) OPT_OPTIMIZE:
497
    extended_insert= opt_drop= opt_lock= quick= create_options=
498
      opt_disable_keys= lock_tables= opt_set_charset= 1;
499
    if (opt_single_transaction) lock_tables=0;
500
    break;
501 502
  case (int) OPT_SKIP_OPTIMIZATION:
    extended_insert= opt_drop= opt_lock= quick= create_options=
unknown's avatar
unknown committed
503
      opt_disable_keys= lock_tables= opt_set_charset= 0;
504
    break;
unknown's avatar
unknown committed
505 506 507 508
  case (int) OPT_COMPACT:
  if (opt_compact)
  {
    opt_comments= opt_drop= opt_disable_keys= opt_lock= 0;
509
    opt_set_charset= 0;
unknown's avatar
unknown committed
510
  }
511 512 513
  case (int) OPT_TABLES:
    opt_databases=0;
    break;
514 515 516
  case (int) OPT_COMPATIBLE:
    {  
      char buff[255];
517 518 519
      char *end= compatible_mode_normal_str;
      int i;
      ulong mode;
520 521

      opt_quoted= 1;
522
      opt_set_charset= 0;
523 524 525 526 527 528 529 530 531 532
      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);
      }
533 534
#if !defined(DBUG_OFF)
      {
unknown's avatar
unknown committed
535
	uint size_for_sql_mode= 0;
536 537 538 539 540 541 542 543 544 545 546 547 548 549 550 551 552 553
	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;
554 555 556
      break;
    }
  case (int) OPT_MYSQL_PROTOCOL:
557
    {
558 559 560 561 562 563 564
      if ((opt_protocol= find_type(argument, &sql_protocol_typelib, 0))
	  == ~(ulong) 0)
      {
	fprintf(stderr, "Unknown option to protocol: %s\n", argument);
	exit(1);
      }
      break;
565
    }
unknown's avatar
unknown committed
566
  }
567 568 569 570 571 572
  return 0;
}

static int get_options(int *argc, char ***argv)
{
  int ho_error;
573 574 575 576
  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;
577 578 579 580 581

  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)))
582
    exit(ho_error);
583

584 585 586
  *mysql_params->p_max_allowed_packet= opt_max_allowed_packet;
  *mysql_params->p_net_buffer_length= opt_net_buffer_length;

unknown's avatar
unknown committed
587 588 589 590 591
  if (opt_delayed)
    opt_lock=0;				/* Can't have lock with delayed */
  if (!path && (enclosed || opt_enclosed || escaped || lines_terminated ||
		fields_terminated))
  {
592 593
    fprintf(stderr,
	    "%s: You must use option --tab with --fields-...\n", my_progname);
unknown's avatar
unknown committed
594 595
    return(1);
  }
596 597
  if (opt_single_transaction)
    lock_tables= 0;
unknown's avatar
unknown committed
598 599 600 601 602 603 604 605 606 607 608 609 610 611 612 613 614
  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 (replace && ignore)
  {
    fprintf(stderr, "%s: You can't use --ignore (-i) and --replace (-r) 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);
  }
615 616
  if (strcmp(default_charset, charset_info->csname) &&
      !(charset_info= get_charset_by_csname(default_charset, 
617
  					    MY_CS_PRIMARY, MYF(MY_WME))))
618
    exit(1);
unknown's avatar
unknown committed
619 620
  if ((*argc < 1 && !opt_alldbs) || (*argc > 0 && opt_alldbs))
  {
621
    short_usage();
unknown's avatar
unknown committed
622 623 624
    return 1;
  }
  if (tty_password)
625
    opt_password=get_tty_password(NullS);
unknown's avatar
unknown committed
626 627 628 629 630 631 632 633 634 635
  return(0);
} /* get_options */


/*
** DBerror -- prints mysql error message and exits the program.
*/
static void DBerror(MYSQL *mysql, const char *when)
{
  DBUG_ENTER("DBerror");
unknown's avatar
unknown committed
636
  my_printf_error(0,"Got error: %d: %s %s", MYF(0),
unknown's avatar
unknown committed
637 638 639 640 641 642 643 644 645 646 647 648 649 650 651 652 653 654 655 656 657 658 659 660 661
		  mysql_errno(mysql), mysql_error(mysql), when);
  safe_exit(EX_MYSQLERR);
  DBUG_VOID_RETURN;
} /* DBerror */


static void safe_exit(int error)
{
  if (!first_error)
    first_error= error;
  if (ignore_errors)
    return;
  if (sock)
    mysql_close(sock);
  exit(error);
}
/* safe_exit */


/*
** dbConnect -- connects to the host and selects DB.
**        Also checks whether the tablename is a valid table name.
*/
static int dbConnect(char *host, char *user,char *passwd)
{
662
  char buff[20+FN_REFLEN];
unknown's avatar
unknown committed
663 664 665
  DBUG_ENTER("dbConnect");
  if (verbose)
  {
666
    fprintf(stderr, "-- Connecting to %s...\n", host ? host : "localhost");
unknown's avatar
unknown committed
667 668 669 670 671 672 673
  }
  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,
674
		  opt_ssl_capath, opt_ssl_cipher);
675 676 677 678 679 680
#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);
unknown's avatar
unknown committed
681
#endif
682
  mysql_options(&mysql_connection, MYSQL_SET_CHARSET_NAME, default_charset);
unknown's avatar
unknown committed
683 684 685 686 687 688 689
  if (!(sock= mysql_real_connect(&mysql_connection,host,user,passwd,
         NULL,opt_mysql_port,opt_mysql_unix_port,
         0)))
  {
    DBerror(&mysql_connection, "when trying to connect");
    return 1;
  }
690 691 692 693 694 695 696 697 698 699
  sprintf(buff, "/*!40100 SET @@SQL_MODE=\"%s\" */",
	  compatible_mode_normal_str);
  if (mysql_query(sock, buff))
  {
    fprintf(stderr, "%s: Can't set the compatible mode %s (error %s)\n",
	    my_progname, compatible_mode_normal_str, mysql_error(sock));
    mysql_close(sock);
    safe_exit(EX_MYSQLERR);
    return 1;
  }
unknown's avatar
unknown committed
700 701 702 703 704 705 706 707 708 709
  return 0;
} /* dbConnect */


/*
** dbDisconnect -- disconnects from the host.
*/
static void dbDisconnect(char *host)
{
  if (verbose)
710
    fprintf(stderr, "-- Disconnecting from %s...\n", host ? host : "localhost");
unknown's avatar
unknown committed
711 712 713 714 715 716 717 718 719 720 721 722 723
  mysql_close(sock);
} /* dbDisconnect */


static void unescape(FILE *file,char *pos,uint length)
{
  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 */
  }
unknown's avatar
unknown committed
724
  mysql_real_escape_string(&mysql_connection, tmp, pos, length);
unknown's avatar
unknown committed
725 726 727 728 729 730 731 732 733 734 735 736
  fputc('\'', file);
  fputs(tmp, file);
  fputc('\'', file);
  my_free(tmp, MYF(MY_WME));
  DBUG_VOID_RETURN;
} /* unescape */


static my_bool test_if_special_chars(const char *str)
{
#if MYSQL_VERSION_ID >= 32300
  for ( ; *str ; str++)
737
    if (!my_isvar(charset_info,*str) && *str != '$')
unknown's avatar
unknown committed
738 739 740 741 742
      return 1;
#endif
  return 0;
} /* test_if_special_chars */

unknown's avatar
unknown committed
743

unknown's avatar
unknown committed
744

unknown's avatar
unknown committed
745
static char *quote_name(const char *name, char *buff, my_bool force)
unknown's avatar
unknown committed
746
{
unknown's avatar
unknown committed
747
  char *to= buff;
748 749
  char qtype= (opt_compatible_mode & MASK_ANSI_QUOTES) ? '\"' : '`';

unknown's avatar
unknown committed
750 751
  if (!force && !opt_quoted && !test_if_special_chars(name))
    return (char*) name;
752
  *to++= qtype;
unknown's avatar
unknown committed
753 754
  while (*name)
  {
755 756
    if (*name == qtype)
      *to++= qtype;
unknown's avatar
unknown committed
757 758
    *to++= *name++;
  }
759 760
  to[0]= qtype;
  to[1]= 0;
unknown's avatar
unknown committed
761 762 763 764
  return buff;
} /* quote_name */


765 766 767 768 769 770 771 772 773 774 775 776 777 778 779 780 781

static char *quote_for_like(const char *name, char *buff)
{
  char *to= buff;
  *to++= '\'';
  while (*name)
  {
    if (*name == '\'' || *name == '_' || *name == '\\' || *name == '%')
      *to++= '\\';
    *to++= *name++;
  }
  to[0]= '\'';
  to[1]= 0;
  return buff;
}


782 783 784 785 786 787 788 789 790 791 792 793 794 795 796 797 798 799 800 801 802 803 804 805 806 807 808 809 810 811 812 813 814 815 816 817 818 819 820 821 822 823 824 825 826 827 828 829 830 831 832 833 834 835 836 837 838 839 840 841 842 843 844 845 846 847 848 849 850 851 852 853 854 855 856 857 858 859 860 861 862 863 864 865 866 867 868 869 870 871 872 873
/*
  Quote and print a string.
  
  SYNOPSIS
    print_quoted_xml()
    output	- output file
    str		- string to print
    len		- its length
    
  DESCRIPTION
    Quote '<' '>' '&' '\"' singns and print a string to the xml_file.
*/

static void print_quoted_xml(FILE *xml_file, const char *str, ulong len)
{
  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;
    }
  }
}


/*
  Print xml tag with one attribute.
  
  SYNOPSIS
    print_xml_tag1()
    xml_file	- output file
    sbeg	- line beginning
    stag_atr	- tag and attribute
    sval	- value of attribute
    send	- line ending
    
  DESCRIPTION
    Print tag with one attribute to the xml_file. Format is:
      sbeg<stag_atr="sval">send
  NOTE
    sval MUST be a NULL terminated string.
    sval string will be qouted before output.
*/

static void print_xml_tag1(FILE * xml_file, const char* sbeg,
			   const char* stag_atr, const char* sval,
			   const char* send)
{
  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);
}


/*
  Print xml tag with many attributes.

  SYNOPSIS
    print_xml_row()
    xml_file	- output file
    row_name	- xml tag name
    tableRes	- query result
    row		- result row
    
  DESCRIPTION
    Print tag with many attribute to the xml_file. Format is:
      \t\t<row_name Atr1="Val1" Atr2="Val2"... />
  NOTE
    All atributes and values will be quoted before output.
*/

static void print_xml_row(FILE *xml_file, const char *row_name,
			  MYSQL_RES *tableRes, MYSQL_ROW *row)
874 875 876 877 878 879 880 881 882
{
  uint i;
  MYSQL_FIELD *field;
  ulong *lengths= mysql_fetch_lengths(tableRes);
  
  fprintf(xml_file, "\t\t<%s", row_name);
  mysql_field_seek(tableRes, 0);
  for (i= 0; (field= mysql_fetch_field(tableRes)); i++)
  {
883
    if ((*row)[i])
884
    {
unknown's avatar
unknown committed
885
      fputc(' ', xml_file);
886
      print_quoted_xml(xml_file, field->name, field->name_length);
887 888
      fputs("=\"", xml_file);
      print_quoted_xml(xml_file, (*row)[i], lengths[i]);
unknown's avatar
unknown committed
889
      fputc('"', xml_file);
890 891 892 893 894
    }
  }
  fputs(" />\n", xml_file);
}

unknown's avatar
unknown committed
895
/*
unknown's avatar
unknown committed
896 897 898 899 900
  getStructure -- retrievs database structure, prints out corresponding
  CREATE statement and fills out insert_pat.

  RETURN
    number of fields in table, 0 if error
unknown's avatar
unknown committed
901
*/
unknown's avatar
unknown committed
902

unknown's avatar
unknown committed
903 904 905 906 907 908
static uint getTableStructure(char *table, char* db)
{
  MYSQL_RES  *tableRes;
  MYSQL_ROW  row;
  my_bool    init=0;
  uint       numFields;
unknown's avatar
unknown committed
909
  char	     *strpos, *result_table, *opt_quoted_table;
unknown's avatar
unknown committed
910
  const char *delayed;
unknown's avatar
unknown committed
911 912
  char	     name_buff[NAME_LEN+3],table_buff[NAME_LEN*2+3];
  char	     table_buff2[NAME_LEN*2+3];
unknown's avatar
unknown committed
913
  FILE       *sql_file = md_result_file;
unknown's avatar
unknown committed
914 915 916 917 918
  DBUG_ENTER("getTableStructure");

  delayed= opt_delayed ? " DELAYED " : "";

  if (verbose)
919
    fprintf(stderr, "-- Retrieving table structure for table %s...\n", table);
unknown's avatar
unknown committed
920

unknown's avatar
unknown committed
921 922
  sprintf(insert_pat,"SET OPTION SQL_QUOTE_SHOW_CREATE=%d",
	  (opt_quoted || opt_keywords));
unknown's avatar
unknown committed
923
  if (!create_options)
unknown's avatar
unknown committed
924
    strmov(strend(insert_pat), "/*!40102 ,SQL_MODE=concat(@@sql_mode, _utf8 ',NO_KEY_OPTIONS,NO_TABLE_OPTIONS,NO_FIELD_OPTIONS') */");
unknown's avatar
unknown committed
925

unknown's avatar
unknown committed
926 927
  result_table=     quote_name(table, table_buff, 1);
  opt_quoted_table= quote_name(table, table_buff2, 0);
928
  if (!opt_xml && !mysql_query(sock,insert_pat))
unknown's avatar
unknown committed
929
  {
930 931
    /* using SHOW CREATE statement */
    if (!tFlag)
unknown's avatar
unknown committed
932
    {
933 934 935
      /* Make an sql-file, if path was given iow. option -T was given */
      char buff[20+FN_REFLEN];

unknown's avatar
unknown committed
936
      sprintf(buff,"show create table %s", result_table);
937
      if (mysql_query(sock, buff))
unknown's avatar
unknown committed
938
      {
unknown's avatar
unknown committed
939 940
        fprintf(stderr, "%s: Can't get CREATE TABLE for table %s (%s)\n",
		      my_progname, result_table, mysql_error(sock));
941 942
        safe_exit(EX_MYSQLERR);
        DBUG_RETURN(0);
unknown's avatar
unknown committed
943 944
      }

945 946 947
      if (path)
      {
        char filename[FN_REFLEN], tmp_path[FN_REFLEN];
948
        convert_dirname(tmp_path,path,NullS);
949
        sql_file= my_fopen(fn_format(filename, table, tmp_path, ".sql", 4),
950
				 O_WRONLY, MYF(MY_WME));
951 952
        if (!sql_file)			/* If file couldn't be opened */
        {
unknown's avatar
unknown committed
953 954
	  safe_exit(EX_MYSQLERR);
	  DBUG_RETURN(0);
955
        }
956
        write_header(sql_file, db);
957
      }
958
      if (!opt_xml && opt_comments)
unknown's avatar
unknown committed
959
        fprintf(sql_file, "\n--\n-- Table structure for table %s\n--\n\n",
unknown's avatar
unknown committed
960
		result_table);
961
      if (opt_drop)
unknown's avatar
unknown committed
962
        fprintf(sql_file, "DROP TABLE IF EXISTS %s;\n", opt_quoted_table);
963 964 965

      tableRes=mysql_store_result(sock);
      row=mysql_fetch_row(tableRes);
966
      fprintf(sql_file, "%s;\n", row[1]);
967 968
      mysql_free_result(tableRes);
    }
unknown's avatar
unknown committed
969
    sprintf(insert_pat,"show fields from %s", result_table);
970
    if (mysql_query(sock,insert_pat) || !(tableRes=mysql_store_result(sock)))
unknown's avatar
unknown committed
971
    {
unknown's avatar
unknown committed
972 973
      fprintf(stderr, "%s: Can't get info about table: %s\nerror: %s\n",
	      my_progname, result_table, mysql_error(sock));
974 975
      if (path)
	my_fclose(sql_file, MYF(MY_WME));
976 977
      safe_exit(EX_MYSQLERR);
      DBUG_RETURN(0);
unknown's avatar
unknown committed
978
    }
979

unknown's avatar
unknown committed
980
    if (cFlag)
unknown's avatar
unknown committed
981
      sprintf(insert_pat, "INSERT %sINTO %s (", delayed, opt_quoted_table);
982
    else
unknown's avatar
unknown committed
983
    {
unknown's avatar
unknown committed
984 985
      sprintf(insert_pat, "INSERT %sINTO %s VALUES ", delayed,
	      opt_quoted_table);
986 987 988 989 990 991 992 993
      if (!extended_insert)
        strcat(insert_pat,"(");
    }

    strpos=strend(insert_pat);
    while ((row=mysql_fetch_row(tableRes)))
    {
      if (init)
unknown's avatar
unknown committed
994
      {
995
        if (cFlag)
996
	  strpos=strmov(strpos,", ");
unknown's avatar
unknown committed
997
      }
998 999
      init=1;
      if (cFlag)
unknown's avatar
unknown committed
1000
        strpos=strmov(strpos,quote_name(row[SHOW_FIELDNAME], name_buff, 0));
unknown's avatar
unknown committed
1001
    }
1002 1003
    numFields = (uint) mysql_num_rows(tableRes);
    mysql_free_result(tableRes);
unknown's avatar
unknown committed
1004
  }
1005
  else
unknown's avatar
unknown committed
1006
  {
unknown's avatar
unknown committed
1007 1008 1009 1010
    if (verbose)
      fprintf(stderr,
              "%s: Warning: Can't set SQL_QUOTE_SHOW_CREATE option (%s)\n",
              my_progname, mysql_error(sock));
1011

unknown's avatar
unknown committed
1012
    sprintf(insert_pat,"show fields from %s", result_table);
1013
    if (mysql_query(sock,insert_pat) || !(tableRes=mysql_store_result(sock)))
unknown's avatar
unknown committed
1014
    {
unknown's avatar
unknown committed
1015 1016
      fprintf(stderr, "%s: Can't get info about table: %s\nerror: %s\n",
		    my_progname, result_table, mysql_error(sock));
unknown's avatar
unknown committed
1017 1018 1019 1020
      safe_exit(EX_MYSQLERR);
      DBUG_RETURN(0);
    }

1021 1022
    /* Make an sql-file, if path was given iow. option -T was given */
    if (!tFlag)
unknown's avatar
unknown committed
1023
    {
1024
      if (path)
unknown's avatar
unknown committed
1025
      {
1026
        char filename[FN_REFLEN], tmp_path[FN_REFLEN];
1027
        convert_dirname(tmp_path,path,NullS);
1028 1029 1030 1031
        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 */
        {
1032 1033
	  safe_exit(EX_MYSQLERR);
	  DBUG_RETURN(0);
1034
        }
1035
        write_header(sql_file, db);
unknown's avatar
unknown committed
1036
      }
1037
      if (!opt_xml && opt_comments)
unknown's avatar
unknown committed
1038 1039
	fprintf(sql_file, "\n--\n-- Table structure for table %s\n--\n\n",
		result_table);
1040
      if (opt_drop)
1041
        fprintf(sql_file, "DROP TABLE IF EXISTS %s;\n",result_table);
1042 1043 1044
      if (!opt_xml)
	fprintf(sql_file, "CREATE TABLE %s (\n", result_table);
      else
1045
        print_xml_tag1(sql_file, "\t", "table_structure name=", table, "\n");
1046 1047
    }
    if (cFlag)
1048
      sprintf(insert_pat, "INSERT %sINTO %s (", delayed, result_table);
1049 1050
    else
    {
1051
      sprintf(insert_pat, "INSERT %sINTO %s VALUES ", delayed, result_table);
1052 1053
      if (!extended_insert)
        strcat(insert_pat,"(");
unknown's avatar
unknown committed
1054
    }
1055 1056

    strpos=strend(insert_pat);
unknown's avatar
unknown committed
1057 1058
    while ((row=mysql_fetch_row(tableRes)))
    {
1059 1060
      ulong *lengths=mysql_fetch_lengths(tableRes);
      if (init)
unknown's avatar
unknown committed
1061
      {
1062
        if (!opt_xml && !tFlag)
1063
	  fputs(",\n",sql_file);
1064
        if (cFlag)
1065
	  strpos=strmov(strpos,", ");
1066 1067 1068
      }
      init=1;
      if (cFlag)
unknown's avatar
unknown committed
1069
        strpos=strmov(strpos,quote_name(row[SHOW_FIELDNAME], name_buff, 0));
1070 1071
      if (!tFlag)
      {
1072 1073 1074 1075 1076 1077
	if (opt_xml)
	{
	  print_xml_row(sql_file, "field", tableRes, &row);
	  continue;
	}
	
1078
        if (opt_keywords)
1079
	  fprintf(sql_file, "  %s.%s %s", result_table,
unknown's avatar
unknown committed
1080 1081
		  quote_name(row[SHOW_FIELDNAME],name_buff, 0),
		  row[SHOW_TYPE]);
1082
        else
unknown's avatar
unknown committed
1083
	  fprintf(sql_file, "  %s %s", quote_name(row[SHOW_FIELDNAME],
unknown's avatar
unknown committed
1084 1085
						  name_buff, 0),
		  row[SHOW_TYPE]);
1086 1087
        if (row[SHOW_DEFAULT])
        {
unknown's avatar
unknown committed
1088
	  fputs(" DEFAULT ", sql_file);
unknown's avatar
unknown committed
1089
	  unescape(sql_file, row[SHOW_DEFAULT], lengths[SHOW_DEFAULT]);
1090 1091
        }
        if (!row[SHOW_NULL][0])
unknown's avatar
unknown committed
1092
	  fputs(" NOT NULL", sql_file);
1093
        if (row[SHOW_EXTRA][0])
unknown's avatar
unknown committed
1094
	  fprintf(sql_file, " %s",row[SHOW_EXTRA]);
unknown's avatar
unknown committed
1095 1096
      }
    }
1097 1098 1099
    numFields = (uint) mysql_num_rows(tableRes);
    mysql_free_result(tableRes);
    if (!tFlag)
unknown's avatar
unknown committed
1100
    {
1101 1102 1103
      /* Make an sql-file, if path was given iow. option -T was given */
      char buff[20+FN_REFLEN];
      uint keynr,primary_key;
unknown's avatar
unknown committed
1104
      sprintf(buff,"show keys from %s", result_table);
unknown's avatar
unknown committed
1105 1106
      if (mysql_query(sock, buff))
      {
unknown's avatar
unknown committed
1107 1108
        fprintf(stderr, "%s: Can't get keys for table %s (%s)\n",
		my_progname, result_table, mysql_error(sock));
1109
        if (path)
unknown's avatar
unknown committed
1110
	  my_fclose(sql_file, MYF(MY_WME));
1111 1112
        safe_exit(EX_MYSQLERR);
        DBUG_RETURN(0);
unknown's avatar
unknown committed
1113
      }
1114 1115 1116 1117 1118 1119

      tableRes=mysql_store_result(sock);
      /* Find first which key is primary key */
      keynr=0;
      primary_key=INT_MAX;
      while ((row=mysql_fetch_row(tableRes)))
unknown's avatar
unknown committed
1120
      {
1121 1122
        if (atoi(row[3]) == 1)
        {
unknown's avatar
unknown committed
1123 1124 1125 1126 1127 1128 1129 1130 1131 1132
	  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;
	  }
1133
        }
unknown's avatar
unknown committed
1134
      }
1135 1136 1137 1138
      mysql_data_seek(tableRes,0);
      keynr=0;
      while ((row=mysql_fetch_row(tableRes)))
      {
1139 1140 1141 1142 1143 1144
	if (opt_xml)
	{
	  print_xml_row(sql_file, "key", tableRes, &row);
	  continue;
	}
        
1145 1146
        if (atoi(row[3]) == 1)
        {
unknown's avatar
unknown committed
1147 1148 1149 1150
	  if (keynr++)
	    putc(')', sql_file);
	  if (atoi(row[1]))       /* Test if duplicate key */
	    /* Duplicate allowed */
unknown's avatar
unknown committed
1151
	    fprintf(sql_file, ",\n  KEY %s (",quote_name(row[2],name_buff,0));
unknown's avatar
unknown committed
1152 1153 1154
	  else if (keynr == primary_key)
	    fputs(",\n  PRIMARY KEY (",sql_file); /* First UNIQUE is primary */
	  else
unknown's avatar
unknown committed
1155 1156
	    fprintf(sql_file, ",\n  UNIQUE %s (",quote_name(row[2],name_buff,
							    0));
1157 1158
        }
        else
unknown's avatar
unknown committed
1159
	  putc(',', sql_file);
unknown's avatar
unknown committed
1160
        fputs(quote_name(row[4], name_buff, 0), sql_file);
1161
        if (row[7])
unknown's avatar
unknown committed
1162
	  fprintf(sql_file, " (%s)",row[7]);      /* Sub key */
1163
      }
1164 1165 1166 1167 1168 1169
      if (!opt_xml)
      {
	if (keynr)
	  putc(')', sql_file);
	fputs("\n)",sql_file);
      }
1170 1171 1172

      /* Get MySQL specific create options */
      if (create_options)
unknown's avatar
unknown committed
1173
      {
1174 1175 1176
	char show_name_buff[FN_REFLEN];
        sprintf(buff,"show table status like %s",
		quote_for_like(table, show_name_buff));
1177 1178
        if (mysql_query(sock, buff))
        {
unknown's avatar
unknown committed
1179 1180 1181 1182
	  if (mysql_errno(sock) != ER_PARSE_ERROR)
	  {					/* If old MySQL version */
	    if (verbose)
	      fprintf(stderr,
unknown's avatar
unknown committed
1183 1184
		      "-- Warning: Couldn't get status information for table %s (%s)\n",
		      result_table,mysql_error(sock));
unknown's avatar
unknown committed
1185
	  }
1186 1187
        }
        else if (!(tableRes=mysql_store_result(sock)) ||
unknown's avatar
unknown committed
1188
		 !(row=mysql_fetch_row(tableRes)))
1189
        {
unknown's avatar
unknown committed
1190
	  fprintf(stderr,
unknown's avatar
unknown committed
1191 1192
		  "Error: Couldn't read status information for table %s (%s)\n",
		  result_table,mysql_error(sock));
1193 1194 1195
        }
        else
        {
1196 1197 1198 1199 1200 1201 1202
	  if (opt_xml)
	  {
	    print_xml_row(sql_file, "options", tableRes, &row);
	  }
	  else
	  {
	    fputs("/*!",sql_file);
unknown's avatar
unknown committed
1203
	    print_value(sql_file,tableRes,row,"engine=","Engine",0);
1204 1205 1206 1207
	    print_value(sql_file,tableRes,row,"","Create_options",0);
	    print_value(sql_file,tableRes,row,"comment=","Comment",1);
	    fputs(" */",sql_file);
	  }
1208 1209
        }
        mysql_free_result(tableRes);		/* Is always safe to free */
unknown's avatar
unknown committed
1210
      }
1211 1212 1213 1214
      if (!opt_xml)
	fputs(";\n", sql_file);
      else
	fputs("\t</table_structure>\n", sql_file);
unknown's avatar
unknown committed
1215 1216 1217 1218 1219 1220 1221 1222
    }
  }
  if (cFlag)
  {
    strpos=strmov(strpos,") VALUES ");
    if (!extended_insert)
      strpos=strmov(strpos,"(");
  }
1223
  if (sql_file != md_result_file)
1224 1225 1226
  {
    fputs("\n", sql_file);
    write_footer(sql_file);
1227
    my_fclose(sql_file, MYF(MY_WME));
1228
  }
unknown's avatar
unknown committed
1229 1230 1231 1232 1233 1234 1235 1236 1237
  DBUG_RETURN(numFields);
} /* getTableStructure */


static char *add_load_option(char *ptr,const char *object,
			     const char *statement)
{
  if (object)
  {
1238 1239 1240 1241 1242 1243 1244 1245 1246 1247
    /* 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++= '\'';
    }
unknown's avatar
unknown committed
1248 1249 1250 1251 1252 1253 1254 1255 1256 1257 1258 1259 1260 1261 1262 1263 1264 1265 1266 1267 1268 1269 1270 1271 1272 1273 1274 1275 1276 1277 1278 1279 1280 1281 1282 1283
  }
  return ptr;
} /* add_load_option */


/*
** Allow the user to specify field terminator strings like:
** "'", "\", "\\" (escaped backslash), "\t" (tab), "\n" (newline)
** This is done by doubleing ' and add a end -\ if needed to avoid
** syntax errors from the SQL parser.
*/

static char *field_escape(char *to,const char *from,uint length)
{
  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 */


1284 1285 1286 1287 1288 1289 1290 1291 1292 1293 1294 1295
static char *alloc_query_str(ulong size)
{
  char *query;

  if (!(query= (char*) my_malloc(size, MYF(MY_WME))))
  {
    ignore_errors= 0;   			/* Fatal error */
    safe_exit(EX_MYSQLERR);			/* Force exit */
  }
  return query;
}

unknown's avatar
unknown committed
1296 1297 1298 1299 1300
/*
** dumpTable saves database contents as a series of INSERT statements.
*/
static void dumpTable(uint numFields, char *table)
{
1301
  char query_buf[QUERY_LENGTH], *end, buff[256],table_buff[NAME_LEN+3];
unknown's avatar
unknown committed
1302
  char *result_table, table_buff2[NAME_LEN*2+3], *opt_quoted_table;
1303
  char *query= query_buf;
unknown's avatar
unknown committed
1304
  MYSQL_RES	*res;
unknown's avatar
unknown committed
1305 1306
  MYSQL_FIELD	*field;
  MYSQL_ROW	row;
unknown's avatar
unknown committed
1307
  ulong		rownr, row_break, total_length, init_length;
1308
  const char    *table_type;
1309
  int error= 0;
unknown's avatar
unknown committed
1310

unknown's avatar
unknown committed
1311 1312
  result_table= quote_name(table,table_buff, 1);
  opt_quoted_table= quote_name(table, table_buff2, 0);
1313 1314 1315 1316 1317 1318 1319 1320 1321 1322 1323 1324 1325

  /* 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");
unknown's avatar
unknown committed
1326 1327 1328
  if (path)
  {
    char filename[FN_REFLEN], tmp_path[FN_REFLEN];
1329
    convert_dirname(tmp_path,path,NullS);
unknown's avatar
unknown committed
1330 1331 1332 1333 1334
    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);
1335 1336
    sprintf(query, "SELECT /*!40001 SQL_NO_CACHE */ * INTO OUTFILE '%s'",
	    filename);
unknown's avatar
unknown committed
1337 1338 1339 1340 1341 1342 1343 1344 1345 1346 1347 1348 1349 1350 1351
    end= strend(query);
    if (replace)
      end= strmov(end, " REPLACE");
    if (ignore)
      end= strmov(end, " IGNORE");

    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';

unknown's avatar
unknown committed
1352
    sprintf(buff," FROM %s", result_table);
unknown's avatar
unknown committed
1353 1354
    end= strmov(end,buff);
    if (where)
1355 1356 1357 1358 1359
    {
      query= alloc_query_str((ulong) (strlen(where) + (end - query) + 10));
      end= strxmov(query, query_buf, " WHERE ", where, NullS);
    }
    if (mysql_real_query(sock, query, (uint) (end - query)))
unknown's avatar
unknown committed
1360 1361 1362 1363 1364 1365 1366
    {
      DBerror(sock, "when executing 'SELECT INTO OUTFILE'");
      return;
    }
  }
  else
  {
1367
    if (!opt_xml && opt_comments)
unknown's avatar
unknown committed
1368 1369
      fprintf(md_result_file,"\n--\n-- Dumping data for table %s\n--\n",
	      result_table);
1370
    sprintf(query, "SELECT /*!40001 SQL_NO_CACHE */ * FROM %s",
unknown's avatar
unknown committed
1371
	    result_table);
unknown's avatar
unknown committed
1372 1373
    if (where)
    {
1374
      if (!opt_xml && opt_comments)
unknown's avatar
unknown committed
1375
	fprintf(md_result_file,"-- WHERE:  %s\n",where);
1376 1377
      query= alloc_query_str((ulong) (strlen(where) + strlen(query) + 10));
      strxmov(query, query_buf, " WHERE ", where, NullS);
unknown's avatar
unknown committed
1378
    }
unknown's avatar
unknown committed
1379
    if (!opt_xml && !opt_compact)
unknown's avatar
merge  
unknown committed
1380
      fputs("\n", md_result_file);
unknown's avatar
unknown committed
1381 1382 1383
    if (mysql_query(sock, query))
    {
      DBerror(sock, "when retrieving data from server");
1384 1385
      error= EX_CONSCHECK;
      goto err;
unknown's avatar
unknown committed
1386 1387 1388 1389 1390 1391 1392 1393
    }
    if (quick)
      res=mysql_use_result(sock);
    else
      res=mysql_store_result(sock);
    if (!res)
    {
      DBerror(sock, "when retrieving data from server");
1394 1395
      error= EX_CONSCHECK;
      goto err;
unknown's avatar
unknown committed
1396 1397
    }
    if (verbose)
1398
      fprintf(stderr, "-- Retrieving rows...\n");
unknown's avatar
unknown committed
1399 1400
    if (mysql_num_fields(res) != numFields)
    {
unknown's avatar
unknown committed
1401 1402
      fprintf(stderr,"%s: Error in field count for table: %s !  Aborting.\n",
	      my_progname, result_table);
1403 1404
      error= EX_CONSCHECK;
      goto err;
unknown's avatar
unknown committed
1405 1406
    }

unknown's avatar
merge  
unknown committed
1407
    if (opt_disable_keys)
unknown's avatar
unknown committed
1408
      fprintf(md_result_file, "\n/*!40000 ALTER TABLE %s DISABLE KEYS */;\n",
unknown's avatar
unknown committed
1409
	      opt_quoted_table);
unknown's avatar
unknown committed
1410
    if (opt_lock)
unknown's avatar
unknown committed
1411
      fprintf(md_result_file,"LOCK TABLES %s WRITE;\n", opt_quoted_table);
unknown's avatar
unknown committed
1412

1413
    total_length= opt_net_buffer_length;		/* Force row break */
unknown's avatar
unknown committed
1414 1415
    row_break=0;
    rownr=0;
unknown's avatar
unknown committed
1416
    init_length=(uint) strlen(insert_pat)+4;
unknown's avatar
unknown committed
1417
    if (opt_xml)
1418
      print_xml_tag1(md_result_file, "\t", "table_data name=", table, "\n");
unknown's avatar
unknown committed
1419

unknown's avatar
unknown committed
1420 1421 1422
    if (opt_autocommit)
      fprintf(md_result_file, "set autocommit=0;\n");

unknown's avatar
unknown committed
1423 1424 1425 1426 1427
    while ((row=mysql_fetch_row(res)))
    {
      uint i;
      ulong *lengths=mysql_fetch_lengths(res);
      rownr++;
unknown's avatar
unknown committed
1428
      if (!extended_insert && !opt_xml)
unknown's avatar
unknown committed
1429
	fputs(insert_pat,md_result_file);
unknown's avatar
unknown committed
1430 1431
      mysql_field_seek(res,0);

unknown's avatar
merge  
unknown committed
1432
      if (opt_xml)
1433
        fputs("\t<row>\n", md_result_file);
unknown's avatar
merge  
unknown committed
1434

unknown's avatar
unknown committed
1435 1436 1437 1438
      for (i = 0; i < mysql_num_fields(res); i++)
      {
	if (!(field = mysql_fetch_field(res)))
	{
unknown's avatar
unknown committed
1439 1440
	  sprintf(query,"%s: Not enough fields from table %s! Aborting.\n",
		  my_progname, result_table);
unknown's avatar
unknown committed
1441
	  fputs(query,stderr);
1442 1443
	  error= EX_CONSCHECK;
	  goto err;
unknown's avatar
unknown committed
1444
	}
1445
	if (extended_insert)
unknown's avatar
unknown committed
1446 1447 1448 1449 1450 1451 1452 1453 1454 1455 1456
	{
	  ulong length = lengths[i];
	  if (i == 0)
	    dynstr_set(&extended_row,"(");
	  else
	    dynstr_append(&extended_row,",");

	  if (row[i])
	  {
	    if (length)
	    {
1457
	      if (!IS_NUM_FIELD(field))
unknown's avatar
unknown committed
1458 1459 1460 1461
	      {
		if (dynstr_realloc(&extended_row,length * 2+2))
		{
		  fputs("Aborting dump (out of memory)",stderr);
1462 1463
		  error= EX_EOM;
		  goto err;
unknown's avatar
unknown committed
1464
		}
unknown's avatar
unknown committed
1465
		dynstr_append(&extended_row,"'");
unknown's avatar
unknown committed
1466
		extended_row.length +=
unknown's avatar
unknown committed
1467 1468 1469
		  mysql_real_escape_string(&mysql_connection,
					   &extended_row.str[extended_row.length],row[i],length);
		extended_row.str[extended_row.length]='\0';
unknown's avatar
unknown committed
1470
		dynstr_append(&extended_row,"'");
unknown's avatar
unknown committed
1471 1472
	      }
	      else
1473
	      {
unknown's avatar
unknown committed
1474
		/* change any strings ("inf", "-inf", "nan") into NULL */
1475
		char *ptr = row[i];
unknown's avatar
unknown committed
1476 1477
		if (my_isalpha(charset_info, *ptr) || (*ptr == '-' &&
		    my_isalpha(charset_info, ptr[1])))
unknown's avatar
unknown committed
1478 1479 1480 1481 1482 1483
		  dynstr_append(&extended_row, "NULL");
		else
		{
		  if (field->type == FIELD_TYPE_DECIMAL)
		  {
		    /* add " signs around */
unknown's avatar
unknown committed
1484
		    dynstr_append(&extended_row, "'");
unknown's avatar
unknown committed
1485
		    dynstr_append(&extended_row, ptr);
unknown's avatar
unknown committed
1486
		    dynstr_append(&extended_row, "'");
unknown's avatar
unknown committed
1487 1488 1489 1490
		  }
		  else
		    dynstr_append(&extended_row, ptr);
		}
1491
	      }
unknown's avatar
unknown committed
1492 1493
	    }
	    else
unknown's avatar
unknown committed
1494
	      dynstr_append(&extended_row,"''");
unknown's avatar
unknown committed
1495 1496 1497 1498
	  }
	  else if (dynstr_append(&extended_row,"NULL"))
	  {
	    fputs("Aborting dump (out of memory)",stderr);
1499 1500
	    error= EX_EOM;
	    goto err;
unknown's avatar
unknown committed
1501 1502 1503 1504
	  }
	}
	else
	{
unknown's avatar
unknown committed
1505 1506
	  if (i && !opt_xml)
	    fputc(',', md_result_file);
unknown's avatar
unknown committed
1507 1508
	  if (row[i])
	  {
1509
	    if (!IS_NUM_FIELD(field))
1510
	    {
unknown's avatar
unknown committed
1511
	      if (opt_xml)
1512
	      {
1513 1514
	        print_xml_tag1(md_result_file, "\t\t", "field name=",
			      field->name, "");
1515 1516 1517
		print_quoted_xml(md_result_file, row[i], lengths[i]);
		fputs("</field>\n", md_result_file);
	      }
unknown's avatar
unknown committed
1518 1519
	      else
		unescape(md_result_file, row[i], lengths[i]);
unknown's avatar
unknown committed
1520
	    }
unknown's avatar
unknown committed
1521
	    else
1522
	    {
unknown's avatar
unknown committed
1523
	      /* change any strings ("inf", "-inf", "nan") into NULL */
1524
	      char *ptr = row[i];
unknown's avatar
unknown committed
1525
	      if (opt_xml)
1526
	      {
1527 1528
	        print_xml_tag1(md_result_file, "\t\t", "field name=",
			       field->name, "");
1529 1530 1531 1532
		fputs(!my_isalpha(charset_info, *ptr) ? ptr: "NULL",
		      md_result_file);
		fputs("</field>\n", md_result_file);
	      }
unknown's avatar
unknown committed
1533 1534 1535 1536
	      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)
unknown's avatar
unknown committed
1537 1538
	      {
		/* add " signs around */
unknown's avatar
unknown committed
1539
		fputc('\'', md_result_file);
unknown's avatar
unknown committed
1540
		fputs(ptr, md_result_file);
unknown's avatar
unknown committed
1541
		fputc('\'', md_result_file);
unknown's avatar
unknown committed
1542
	      }
unknown's avatar
unknown committed
1543
	      else
unknown's avatar
unknown committed
1544
		fputs(ptr, md_result_file);
1545
	    }
unknown's avatar
unknown committed
1546
	  }
1547 1548
	  else
            fputs("NULL", md_result_file);
unknown's avatar
unknown committed
1549 1550 1551
	}
      }

unknown's avatar
merge  
unknown committed
1552
      if (opt_xml)
1553
        fputs("\t</row>\n", md_result_file);
unknown's avatar
merge  
unknown committed
1554

1555
      if (extended_insert)
unknown's avatar
unknown committed
1556 1557 1558 1559
      {
	ulong row_length;
	dynstr_append(&extended_row,")");
        row_length = 2 + extended_row.length;
1560
        if (total_length + row_length < opt_net_buffer_length)
unknown's avatar
unknown committed
1561 1562
        {
	  total_length += row_length;
unknown's avatar
unknown committed
1563 1564
	  fputc(',',md_result_file);		/* Always row break */
	  fputs(extended_row.str,md_result_file);
unknown's avatar
unknown committed
1565 1566 1567
	}
        else
        {
1568
	  if (row_break)
unknown's avatar
unknown committed
1569
	    fputs(";\n", md_result_file);
unknown's avatar
unknown committed
1570
	  row_break=1;				/* This is first row */
unknown's avatar
unknown committed
1571

1572 1573
          fputs(insert_pat,md_result_file);
          fputs(extended_row.str,md_result_file);
unknown's avatar
unknown committed
1574 1575 1576
	  total_length = row_length+init_length;
        }
      }
unknown's avatar
unknown committed
1577
      else if (!opt_xml)
unknown's avatar
unknown committed
1578
	fputs(");\n", md_result_file);
unknown's avatar
unknown committed
1579
    }
unknown's avatar
unknown committed
1580

unknown's avatar
unknown committed
1581
    /* XML - close table tag and supress regular output */
unknown's avatar
unknown committed
1582
    if (opt_xml)
1583
	fputs("\t</table_data>\n", md_result_file);
unknown's avatar
unknown committed
1584
    else if (extended_insert && row_break)
unknown's avatar
unknown committed
1585 1586
      fputs(";\n", md_result_file);		/* If not empty table */
    fflush(md_result_file);
unknown's avatar
unknown committed
1587 1588
    if (mysql_errno(sock))
    {
unknown's avatar
unknown committed
1589
      sprintf(query,"%s: Error %d: %s when dumping table %s at row: %ld\n",
unknown's avatar
unknown committed
1590 1591 1592
	      my_progname,
	      mysql_errno(sock),
	      mysql_error(sock),
unknown's avatar
unknown committed
1593
	      result_table,
unknown's avatar
unknown committed
1594 1595
	      rownr);
      fputs(query,stderr);
1596 1597
      error= EX_CONSCHECK;
      goto err;
unknown's avatar
unknown committed
1598 1599
    }
    if (opt_lock)
unknown's avatar
unknown committed
1600
      fputs("UNLOCK TABLES;\n", md_result_file);
unknown's avatar
merge  
unknown committed
1601 1602
    if (opt_disable_keys)
      fprintf(md_result_file,"/*!40000 ALTER TABLE %s ENABLE KEYS */;\n",
unknown's avatar
unknown committed
1603
	      opt_quoted_table);
unknown's avatar
unknown committed
1604 1605
    if (opt_autocommit)
      fprintf(md_result_file, "commit;\n");
1606
    mysql_free_result(res);
1607 1608 1609 1610 1611 1612 1613 1614 1615 1616
    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;
unknown's avatar
unknown committed
1617 1618 1619 1620 1621 1622 1623 1624 1625 1626 1627 1628 1629 1630 1631
} /* dumpTable */


static char *getTableName(int reset)
{
  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]);
unknown's avatar
unknown committed
1632

unknown's avatar
unknown committed
1633 1634 1635 1636 1637 1638 1639 1640 1641 1642 1643 1644 1645 1646 1647 1648 1649 1650 1651 1652 1653 1654 1655 1656 1657 1658 1659 1660 1661 1662 1663 1664 1665 1666 1667 1668 1669 1670
  if (reset)
    mysql_data_seek(res,0);      /* We want to read again */
  else
  {
    mysql_free_result(res);
    res = NULL;
  }
  return(NULL);
} /* getTableName */


static int dump_all_databases()
{
  MYSQL_ROW row;
  MYSQL_RES *tableres;
  int result=0;

  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_tables_in_db(row[0]))
      result=1;
  }
  return result;
}
/* dump_all_databases */


static int dump_databases(char **db_names)
{
  int result=0;
  for ( ; *db_names ; db_names++)
1671
  {
unknown's avatar
unknown committed
1672 1673 1674 1675 1676 1677 1678 1679 1680 1681 1682 1683 1684 1685
    if (dump_all_tables_in_db(*db_names))
      result=1;
  }
  return result;
} /* dump_databases */


static int init_dumping(char *database)
{
  if (mysql_select_db(sock, database))
  {
    DBerror(sock, "when selecting the database");
    return 1;			/* If --force */
  }
unknown's avatar
unknown committed
1686
  if (!path && !opt_xml)
unknown's avatar
unknown committed
1687 1688 1689
  {
    if (opt_databases || opt_alldbs)
    {
unknown's avatar
unknown committed
1690 1691 1692
      /*
	length of table name * 2 (if name contain quotas), 2 quotas and 0
      */
unknown's avatar
unknown committed
1693 1694
      char quoted_database_buf[64*2+3];
      char *qdatabase= quote_name(database,quoted_database_buf,opt_quoted);
1695
      if (opt_comments)
unknown's avatar
unknown committed
1696
	fprintf(md_result_file,"\n--\n-- Current Database: %s\n--\n", qdatabase);
unknown's avatar
unknown committed
1697
      if (!opt_create_db)
1698
      {
unknown's avatar
unknown committed
1699
        char qbuf[256];
1700 1701
        MYSQL_ROW row;
        MYSQL_RES *dbinfo;
1702

unknown's avatar
unknown committed
1703
        sprintf(qbuf,"SHOW CREATE DATABASE WITH IF NOT EXISTS %s",
unknown's avatar
unknown committed
1704
		qdatabase);
1705

1706 1707 1708
        if (mysql_query(sock, qbuf) || !(dbinfo = mysql_store_result(sock)))
        {
          /* Old server version, dump generic CREATE DATABASE */
1709
	  fprintf(md_result_file,
unknown's avatar
unknown committed
1710 1711
		  "\nCREATE DATABASE /*!32312 IF NOT EXISTS*/ %s;\n",
		  qdatabase);
1712 1713 1714 1715 1716 1717 1718 1719 1720 1721
	}
	else
        {
	  row = mysql_fetch_row(dbinfo);
	  if (row[1])
	  {
	    fprintf(md_result_file,"\n%s;\n",row[1]);
          }
	}
      }
unknown's avatar
unknown committed
1722
      fprintf(md_result_file,"\nUSE %s;\n", qdatabase);
unknown's avatar
unknown committed
1723 1724
    }
  }
unknown's avatar
unknown committed
1725 1726
  if (extended_insert && init_dynamic_string(&extended_row, "", 1024, 1024))
    exit(EX_EOM);
unknown's avatar
unknown committed
1727 1728 1729 1730
  return 0;
} /* init_dumping */


unknown's avatar
unknown committed
1731

unknown's avatar
unknown committed
1732 1733 1734 1735
static int dump_all_tables_in_db(char *database)
{
  char *table;
  uint numrows;
unknown's avatar
unknown committed
1736
  char table_buff[NAME_LEN*2+3];
unknown's avatar
unknown committed
1737 1738 1739

  if (init_dumping(database))
    return 1;
unknown's avatar
unknown committed
1740
  if (opt_xml)
1741
    print_xml_tag1(md_result_file, "", "database name=", database, "\n");
unknown's avatar
unknown committed
1742 1743 1744 1745 1746 1747
  if (lock_tables)
  {
    DYNAMIC_STRING query;
    init_dynamic_string(&query, "LOCK TABLES ", 256, 1024);
    for (numrows=0 ; (table = getTableName(1)) ; numrows++)
    {
unknown's avatar
unknown committed
1748
      dynstr_append(&query, quote_name(table, table_buff, 1));
unknown's avatar
unknown committed
1749 1750 1751
      dynstr_append(&query, " READ /*!32311 LOCAL */,");
    }
    if (numrows && mysql_real_query(sock, query.str, query.length-1))
unknown's avatar
unknown committed
1752
      DBerror(sock, "when using LOCK TABLES");
unknown's avatar
unknown committed
1753 1754 1755 1756 1757 1758
            /* We shall continue here, if --force was given */
    dynstr_free(&query);
  }
  if (flush_logs)
  {
    if (mysql_refresh(sock, REFRESH_LOG))
unknown's avatar
unknown committed
1759
      DBerror(sock, "when doing refresh");
unknown's avatar
unknown committed
1760 1761 1762 1763 1764 1765 1766 1767
           /* We shall continue here, if --force was given */
  }
  while ((table = getTableName(0)))
  {
    numrows = getTableStructure(table, database);
    if (!dFlag && numrows > 0)
      dumpTable(numrows,table);
  }
unknown's avatar
unknown committed
1768
  if (opt_xml)
1769
    fputs("</database>\n", md_result_file);
unknown's avatar
unknown committed
1770
  if (lock_tables)
1771
    mysql_query(sock,"UNLOCK TABLES");
unknown's avatar
unknown committed
1772 1773 1774 1775 1776 1777 1778 1779
  return 0;
} /* dump_all_tables_in_db */



static int dump_selected_tables(char *db, char **table_names, int tables)
{
  uint numrows;
unknown's avatar
unknown committed
1780
  char table_buff[NAME_LEN*+3];
unknown's avatar
unknown committed
1781 1782 1783 1784 1785 1786 1787 1788 1789 1790 1791

  if (init_dumping(db))
    return 1;
  if (lock_tables)
  {
    DYNAMIC_STRING query;
    int i;

    init_dynamic_string(&query, "LOCK TABLES ", 256, 1024);
    for (i=0 ; i < tables ; i++)
    {
unknown's avatar
unknown committed
1792
      dynstr_append(&query, quote_name(table_names[i], table_buff, 1));
unknown's avatar
unknown committed
1793 1794 1795
      dynstr_append(&query, " READ /*!32311 LOCAL */,");
    }
    if (mysql_real_query(sock, query.str, query.length-1))
unknown's avatar
unknown committed
1796
      DBerror(sock, "when doing LOCK TABLES");
unknown's avatar
unknown committed
1797 1798 1799 1800 1801 1802
       /* We shall countinue here, if --force was given */
    dynstr_free(&query);
  }
  if (flush_logs)
  {
    if (mysql_refresh(sock, REFRESH_LOG))
unknown's avatar
unknown committed
1803
      DBerror(sock, "when doing refresh");
unknown's avatar
unknown committed
1804 1805
     /* We shall countinue here, if --force was given */
  }
unknown's avatar
unknown committed
1806
  if (opt_xml)
1807
    print_xml_tag1(md_result_file, "", "database name=", db, "\n");
unknown's avatar
unknown committed
1808 1809 1810 1811 1812 1813
  for (; tables > 0 ; tables-- , table_names++)
  {
    numrows = getTableStructure(*table_names, db);
    if (!dFlag && numrows > 0)
      dumpTable(numrows, *table_names);
  }
unknown's avatar
unknown committed
1814
  if (opt_xml)
1815
    fputs("</database>\n", md_result_file);
unknown's avatar
unknown committed
1816
  if (lock_tables)
unknown's avatar
unknown committed
1817
    mysql_query(sock,"UNLOCK TABLES");
unknown's avatar
unknown committed
1818 1819 1820 1821
  return 0;
} /* dump_selected_tables */


1822 1823 1824 1825 1826 1827 1828 1829 1830

static ulong find_set(TYPELIB *lib, const char *x, uint length,
		      char **err_pos, uint *err_len)
{
  const char *end= x + length;
  ulong found= 0;
  uint find;
  char buff[255];

1831
  *err_pos= 0;                  /* No error yet */
1832
  while (end > x && my_isspace(charset_info, end[-1]))
1833 1834 1835 1836 1837 1838 1839 1840 1841 1842 1843 1844 1845 1846 1847 1848 1849 1850 1851 1852 1853 1854 1855 1856 1857 1858 1859 1860 1861 1862 1863
    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;
}


unknown's avatar
unknown committed
1864 1865 1866 1867 1868 1869 1870 1871 1872 1873 1874 1875 1876 1877 1878 1879 1880
/* Print a value with a prefix on file */
static void print_value(FILE *file, MYSQL_RES  *result, MYSQL_ROW row,
			const char *prefix, const char *name,
			int string_value)
{
  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)
unknown's avatar
unknown committed
1881
	  unescape(file,row[0],(uint) strlen(row[0]));
unknown's avatar
unknown committed
1882 1883 1884 1885 1886 1887 1888 1889 1890 1891
	else
	  fputs(row[0], file);
	return;
      }
    }
  }
  return;					/* This shouldn't happen */
} /* print_value */


1892 1893 1894 1895 1896 1897 1898 1899 1900 1901 1902 1903 1904 1905 1906 1907 1908 1909 1910 1911 1912 1913 1914 1915 1916 1917 1918 1919 1920 1921 1922 1923 1924 1925 1926 1927 1928 1929 1930 1931 1932 1933 1934 1935 1936 1937 1938 1939 1940 1941 1942 1943 1944 1945 1946
/*
  Check if we the table is one of the table types that should be ignored:
  MRG_ISAM, MRG_MYISAM

  SYNOPSIS
    check_if_ignore_table()
    table_name			Table name to check

  GLOBAL VARIABLES
    sock			MySQL socket
    verbose			Write warning messages

  RETURN
    0	Table should be backuped
    #	Type of table (that should be skipped)
*/

static const char *check_if_ignore_table(const char *table_name)
{
  char buff[FN_REFLEN+80], show_name_buff[FN_REFLEN];
  MYSQL_RES *res;
  MYSQL_ROW row;
  const char *result= 0;

  sprintf(buff,"show table status like %s",
	  quote_for_like(table_name, show_name_buff));
  if (mysql_query(sock, 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 (!(res= mysql_store_result(sock)) ||
      !(row= mysql_fetch_row(res)))
  {
    fprintf(stderr,
	    "Error: Couldn't read status information for table %s (%s)\n",
	    table_name, mysql_error(sock));
    if (res)
      mysql_free_result(res);
    return 0;					/* assume table is ok */
  }
  if (strcmp(row[1], (result= "MRG_MyISAM")) &&
      strcmp(row[1], (result= "MRG_ISAM")))
    result= 0;
  mysql_free_result(res);  
  return result;
}


unknown's avatar
unknown committed
1947 1948
int main(int argc, char **argv)
{
unknown's avatar
unknown committed
1949 1950
  MYSQL_ROW row;
  MYSQL_RES *master;
1951
  compatible_mode_normal_str[0]= 0;
unknown's avatar
unknown committed
1952

unknown's avatar
unknown committed
1953 1954 1955 1956 1957 1958
  MY_INIT(argv[0]);
  if (get_options(&argc, &argv))
  {
    my_end(0);
    exit(EX_USAGE);
  }
1959
  if (dbConnect(current_host, current_user, opt_password))
unknown's avatar
unknown committed
1960 1961
    exit(EX_MYSQLERR);
  if (!path)
1962 1963 1964 1965 1966 1967 1968 1969 1970 1971 1972 1973 1974
    write_header(md_result_file, *argv);

  if (opt_first_slave)
  {
    lock_tables=0;				/* No other locks needed */
    if (mysql_query(sock, "FLUSH TABLES WITH READ LOCK"))
    {
      my_printf_error(0, "Error: Couldn't execute 'FLUSH TABLES WITH READ LOCK': %s",
                      MYF(0), mysql_error(sock));
      my_end(0);
      return(first_error);
    }
  }
1975
  else if (opt_single_transaction)
1976 1977 1978
  {
    /* There is no sense to start transaction if all tables are locked */ 
    if (mysql_query(sock, "BEGIN"))
1979
    {
1980
      my_printf_error(0, "Error: Couldn't execute 'BEGIN': %s",
1981
                        MYF(0), mysql_error(sock));
1982 1983 1984 1985
      my_end(0);
      return(first_error);
    }    
  }
unknown's avatar
unknown committed
1986 1987 1988
  if (opt_alldbs)
    dump_all_databases();
  else if (argc > 1 && !opt_databases)
1989 1990
  {
    /* Only one database and selected table(s) */
unknown's avatar
unknown committed
1991
    dump_selected_tables(*argv, (argv + 1), (argc - 1));
1992
  }
unknown's avatar
unknown committed
1993
  else
1994 1995
  {
    /* One or more databases, all tables */
unknown's avatar
unknown committed
1996
    dump_databases(argv);
1997
  }
unknown's avatar
unknown committed
1998 1999 2000

  if (opt_first_slave)
  {
2001 2002 2003 2004 2005
    if (opt_delete_master_logs && mysql_query(sock, "FLUSH MASTER"))
    {
      my_printf_error(0, "Error: Couldn't execute 'FLUSH MASTER': %s",
		      MYF(0), mysql_error(sock));
    }
unknown's avatar
unknown committed
2006 2007 2008 2009 2010 2011
    if (opt_master_data)
    {
      if (mysql_query(sock, "SHOW MASTER STATUS") ||
	  !(master = mysql_store_result(sock)))
	my_printf_error(0, "Error: Couldn't execute 'SHOW MASTER STATUS': %s",
			MYF(0), mysql_error(sock));
2012
      else
unknown's avatar
unknown committed
2013 2014
      {
	row = mysql_fetch_row(master);
unknown's avatar
unknown committed
2015
	if (row && row[0] && row[1])
2016
	{
2017 2018 2019
	  if (opt_comments)
	    fprintf(md_result_file,
		    "\n--\n-- Position to start replication from\n--\n\n");
unknown's avatar
unknown committed
2020
	  fprintf(md_result_file,
unknown's avatar
unknown committed
2021 2022
		  "CHANGE MASTER TO MASTER_LOG_FILE='%s', \
MASTER_LOG_POS=%s ;\n",row[0],row[1]); 
unknown's avatar
unknown committed
2023 2024 2025 2026
	}
	mysql_free_result(master);
      }
    }
unknown's avatar
unknown committed
2027 2028 2029 2030
    if (mysql_query(sock, "UNLOCK TABLES"))
      my_printf_error(0, "Error: Couldn't execute 'UNLOCK TABLES': %s",
		      MYF(0), mysql_error(sock));
  }
2031
  else if (opt_single_transaction) /* Just to make it beautiful enough */
2032 2033 2034
#ifdef HAVE_SMEM
  my_free(shared_memory_base_name,MYF(MY_ALLOW_ZERO_PTR));
#endif
2035
  {
2036
    /*
2037 2038
      In case we were locking all tables, we did not start transaction
      so there is no need to commit it.
2039 2040
    */

2041 2042 2043 2044
    /* This should just free locks as we did not change anything */
    if (mysql_query(sock, "COMMIT"))
    {
      my_printf_error(0, "Error: Couldn't execute 'COMMIT': %s",
2045 2046
	      MYF(0), mysql_error(sock));
    }
2047
  }
unknown's avatar
unknown committed
2048
  dbDisconnect(current_host);
2049 2050
  if (!path)
    write_footer(md_result_file);
unknown's avatar
unknown committed
2051 2052
  if (md_result_file != stdout)
    my_fclose(md_result_file, MYF(0));
2053
  my_free(opt_password, MYF(MY_ALLOW_ZERO_PTR));
2054
  if (extended_insert)
unknown's avatar
unknown committed
2055 2056 2057 2058
    dynstr_free(&extended_row);
  my_end(0);
  return(first_error);
} /* main */