Skip navigation links

Recommended Servers for MySQL

The world's most popular open source database

Contact a MySQL Representative

Login | Register

• MySQL.com
• Downloads
• Developer Zone
• Partners & Solutions
• Customer Login

• DevZone
• Documentation
• Librarian
• Articles
• Forums
• Bugs
• Forge
• Planet MySQL
• Labs

 

 

 

• Get Started with MySQL
• Development with MySQL
• PHP
• Perl
• Python
• Ruby
• Java/JDBC
• C#/.NET

The world's most popular open source database

mysql/src/5.1-dbg/client/mysqladmin.cc File Reference

#include "client_priv.h"
#include <signal.h>
#include <sys/stat.h>
#include <mysql.h>
#include <sslopt-vars.h>
#include <sslopt-longopts.h>
#include <sslopt-case.h>
#include <help_start.h>
#include <help_end.h>

Include dependency graph for mysqladmin.cc:

Go to the source code of this file.

Defines
#define	ADMIN_VERSION   "8.41"
#define	MAX_MYSQL_VAR   256
#define	SHUTDOWN_DEF_TIMEOUT   3600
#define	MAX_TRUNC_LENGTH   3
Enumerations
enum	commands {   ADMIN_ERROR, ADMIN_CREATE, ADMIN_DROP, ADMIN_SHUTDOWN,   ADMIN_RELOAD, ADMIN_REFRESH, ADMIN_VER, ADMIN_PROCESSLIST,   ADMIN_STATUS, ADMIN_KILL, ADMIN_DEBUG, ADMIN_VARIABLES,   ADMIN_FLUSH_LOGS, ADMIN_FLUSH_HOSTS, ADMIN_FLUSH_TABLES, ADMIN_PASSWORD,   ADMIN_PING, ADMIN_EXTENDED_STATUS, ADMIN_FLUSH_STATUS, ADMIN_FLUSH_PRIVILEGES,   ADMIN_START_SLAVE, ADMIN_STOP_SLAVE, ADMIN_FLUSH_THREADS, ADMIN_OLD_PASSWORD }
Functions
static void	print_version (void)
static void	usage (void)
static my_bool	sql_connect (MYSQL *mysql, uint wait)
static int	execute_commands (MYSQL *mysql, int argc, char **argv)
static int	drop_db (MYSQL *mysql, const char *db)
static sig_handler	endprog (int signal_number)
static void	nice_time (ulong sec, char *buff)
static void	print_header (MYSQL_RES *result)
static void	print_top (MYSQL_RES *result)
static void	print_row (MYSQL_RES *result, MYSQL_ROW cur, uint row)
static void	print_relative_row (MYSQL_RES *result, MYSQL_ROW cur, uint row)
static void	print_relative_row_vert (MYSQL_RES *result, MYSQL_ROW cur, uint row)
static void	print_relative_header ()
static void	print_relative_line ()
static void	truncate_names ()
static my_bool	get_pidfile (MYSQL *mysql, char *pidfile)
static my_bool	wait_pidfile (char *pidfile, time_t last_modified, struct stat *pidfile_status)
static void	store_values (MYSQL_RES *result)
static my_bool	get_one_option (int optid, const struct my_option *opt __attribute__((unused)), char *argument)
int	main (int argc, char *argv[])
static sig_handler	endprog (int signal_number __attribute__((unused)))
static void	print_row (MYSQL_RES *result, MYSQL_ROW cur, uint row __attribute__((unused)))
static void	print_relative_row_vert (MYSQL_RES *result __attribute__((unused)), MYSQL_ROW cur, uint row __attribute__((unused)))
Variables
char *	host = NULL
char *	user = 0
char *	opt_password = 0
char *	default_charset = NULL
char	truncated_var_names [MAX_MYSQL_VAR][MAX_TRUNC_LENGTH]
char	ex_var_names [MAX_MYSQL_VAR][FN_REFLEN]
ulonglong	last_values [MAX_MYSQL_VAR]
static int	interval = 0
static my_bool	option_force = 0
static my_bool	interrupted = 0
static my_bool	new_line = 0
static my_bool	opt_compress = 0
static my_bool	opt_relative = 0
static my_bool	opt_verbose = 0
static my_bool	opt_vertical = 0
static my_bool	tty_password = 0
static uint	tcp_port = 0
static uint	option_wait = 0
static uint	option_silent = 0
static uint	nr_iterations
static uint	opt_count_iterations = 0
static ulong	opt_connect_timeout
static ulong	opt_shutdown_timeout
static my_string	unix_port = 0
static uint	opt_protocol = 0
static uint	ex_val_max_len [MAX_MYSQL_VAR]
static my_bool	ex_status_printed = 0
static uint	ex_var_count
static uint	max_var_length
static uint	max_val_length
static const char *	command_names []
static TYPELIB	command_typelib
static struct my_option	my_long_options []
static const char *	load_default_groups [] = { "mysqladmin","client",0 }

---

Define Documentation

#define ADMIN_VERSION   "8.41"

Definition at line 31 of file mysqladmin.cc.

Referenced by print_version().

#define MAX_MYSQL_VAR   256

Definition at line 32 of file mysqladmin.cc.

#define MAX_TRUNC_LENGTH   3

Definition at line 34 of file mysqladmin.cc.

Referenced by truncate_names().

#define SHUTDOWN_DEF_TIMEOUT   3600

Definition at line 33 of file mysqladmin.cc.

---

Enumeration Type Documentation

enum commands

Enumerator:

ADMIN_ERROR
ADMIN_CREATE
ADMIN_DROP
ADMIN_SHUTDOWN
ADMIN_RELOAD
ADMIN_REFRESH
ADMIN_VER
ADMIN_PROCESSLIST
ADMIN_STATUS
ADMIN_KILL
ADMIN_DEBUG
ADMIN_VARIABLES
ADMIN_FLUSH_LOGS
ADMIN_FLUSH_HOSTS
ADMIN_FLUSH_TABLES
ADMIN_PASSWORD
ADMIN_PING
ADMIN_EXTENDED_STATUS
ADMIN_FLUSH_STATUS
ADMIN_FLUSH_PRIVILEGES
ADMIN_START_SLAVE
ADMIN_STOP_SLAVE
ADMIN_FLUSH_THREADS
ADMIN_OLD_PASSWORD

Definition at line 95 of file mysqladmin.cc.

              {
  ADMIN_ERROR,
  ADMIN_CREATE,           ADMIN_DROP,            ADMIN_SHUTDOWN,
  ADMIN_RELOAD,           ADMIN_REFRESH,         ADMIN_VER,
  ADMIN_PROCESSLIST,      ADMIN_STATUS,          ADMIN_KILL,
  ADMIN_DEBUG,            ADMIN_VARIABLES,       ADMIN_FLUSH_LOGS,
  ADMIN_FLUSH_HOSTS,      ADMIN_FLUSH_TABLES,    ADMIN_PASSWORD,
  ADMIN_PING,             ADMIN_EXTENDED_STATUS, ADMIN_FLUSH_STATUS,
  ADMIN_FLUSH_PRIVILEGES, ADMIN_START_SLAVE,     ADMIN_STOP_SLAVE,
  ADMIN_FLUSH_THREADS,    ADMIN_OLD_PASSWORD
#ifdef LATER_HAVE_NDBCLUSTER_DB
  ,ADMIN_NDB_MGM
#endif
};

---

Function Documentation

static int drop_db	(	MYSQL *	mysql,
		const char *	db
	)			[static]

Definition at line 1045 of file mysqladmin.cc.

References buf, FN_REFLEN, ME_BELL, my_printf_error(), MYF, mysql, mysql_error(), mysql_query(), option_force, and VOID.

Referenced by execute_commands().

{
  char name_buff[FN_REFLEN+20], buf[10];
  if (!option_force)
  {
    puts("Dropping the database is potentially a very bad thing to do.");
    puts("Any data stored in the database will be destroyed.\n");
    printf("Do you really want to drop the '%s' database [y/N] ",db);
    fflush(stdout);
    VOID(fgets(buf,sizeof(buf)-1,stdin));
    if ((*buf != 'y') && (*buf != 'Y'))
    {
      puts("\nOK, aborting database drop!");
      return -1;
    }
  }
  sprintf(name_buff,"drop database `%.*s`",FN_REFLEN,db);
  if (mysql_query(mysql,name_buff))
  {
    my_printf_error(0,"DROP DATABASE %s failed;\nerror: '%s'",MYF(ME_BELL),
                    db,mysql_error(mysql));
    return 1;
  }
  printf("Database \"%s\" dropped\n",db);
  return 0;
}

Here is the call graph for this function:

Here is the caller graph for this function:

static sig_handler endprog

(

int signal_number

__attribute__((unused))

)

[static]

Definition at line 421 of file mysqladmin.cc.

References interrupted.

{
  interrupted=1;
}

static sig_handler endprog

(

int

signal_number

)

[static]

Referenced by endprog(), and main().

Here is the caller graph for this function:

static int execute_commands	(	MYSQL *	mysql,
		int	argc,
		char **	argv
	)			[static]

Definition at line 506 of file mysqladmin.cc.

References ADMIN_CREATE, ADMIN_DEBUG, ADMIN_DROP, ADMIN_EXTENDED_STATUS, ADMIN_FLUSH_HOSTS, ADMIN_FLUSH_LOGS, ADMIN_FLUSH_PRIVILEGES, ADMIN_FLUSH_STATUS, ADMIN_FLUSH_TABLES, ADMIN_FLUSH_THREADS, ADMIN_KILL, ADMIN_OLD_PASSWORD, ADMIN_PASSWORD, ADMIN_PING, ADMIN_PROCESSLIST, ADMIN_REFRESH, ADMIN_RELOAD, ADMIN_SHUTDOWN, ADMIN_START_SLAVE, ADMIN_STATUS, ADMIN_STOP_SLAVE, ADMIN_VARIABLES, ADMIN_VER, command_typelib, CR_SERVER_GONE_ERROR, drop_db(), error, ex_status_printed, find_type(), FN_REFLEN, func, get_pidfile(), make_scrambled_password(), make_scrambled_password_323(), ME_BELL, my_printf_error(), MYF, mysql, mysql_close(), mysql_dump_debug_info(), mysql_errno(), mysql_error(), mysql_fetch_row(), mysql_free_result(), mysql_get_host_info(), mysql_get_proto_info(), mysql_get_server_info(), mysql_kill(), mysql_num_rows(), mysql_ping(), mysql_query(), mysql_refresh(), mysql_shutdown(), mysql_stat(), mysql_store_result(), ndb_mgmclient_execute(), ndb_mgmclient_handle_create(), ndb_mgmclient_handle_destroy(), new_line, nice_time(), opt_ndb_connectstring, opt_relative, opt_verbose, opt_vertical, option_silent, st_mysql::port, pos(), print_header(), print_relative_header(), print_relative_line(), print_relative_row(), print_relative_row_vert(), print_row(), print_top(), print_version(), randominit(), st_mysql::reconnect, REFRESH_GRANT, REFRESH_LOG, REFRESH_MASTER, REFRESH_READ_LOCK, REFRESH_SLAVE, REFRESH_STATUS, REFRESH_THREADS, sec, SHUTDOWN_DEFAULT, start_time, status, store_values(), str2int(), strchr(), strlen(), truncate_names(), st_mysql::unix_socket, and wait_pidfile().

Referenced by main().

{
  const char *status;
  /*
    MySQL documentation relies on the fact that mysqladmin will
    execute commands in the order specified, e.g.
    mysqladmin -u root flush-privileges password "newpassword"
    to reset a lost root password.
    If this behaviour is ever changed, Docs should be notified.
  */

  struct rand_struct rand_st;

  for (; argc > 0 ; argv++,argc--)
  {
    switch (find_type(argv[0],&command_typelib,2)) {
    case ADMIN_CREATE:
    {
      char buff[FN_REFLEN+20];
      if (argc < 2)
      {
        my_printf_error(0,"Too few arguments to create",MYF(ME_BELL));
        return 1;
      }
      sprintf(buff,"create database `%.*s`",FN_REFLEN,argv[1]);
      if (mysql_query(mysql,buff))
      {
        my_printf_error(0,"CREATE DATABASE failed; error: '%-.200s'",
                        MYF(ME_BELL), mysql_error(mysql));
        return -1;
      }
      argc--; argv++;
      break;
    }
    case ADMIN_DROP:
    {
      if (argc < 2)
      {
        my_printf_error(0,"Too few arguments to drop",MYF(ME_BELL));
        return 1;
      }
      if (drop_db(mysql,argv[1]))
        return -1;
      argc--; argv++;
      break;
    }
    case ADMIN_SHUTDOWN:
    {
      char pidfile[FN_REFLEN];
      my_bool got_pidfile= 0;
      time_t last_modified= 0;
      struct stat pidfile_status;

      /*
        Only wait for pidfile on local connections
        If pidfile doesn't exist, continue without pid file checking
      */
      if (mysql->unix_socket && (got_pidfile= !get_pidfile(mysql, pidfile)) &&
          !stat(pidfile, &pidfile_status))
        last_modified= pidfile_status.st_mtime;

      if (mysql_shutdown(mysql, SHUTDOWN_DEFAULT))
      {
        my_printf_error(0,"shutdown failed; error: '%s'",MYF(ME_BELL),
                        mysql_error(mysql));
        return -1;
      }
      mysql_close(mysql);       /* Close connection to avoid error messages */
      argc=1;                   /* force SHUTDOWN to be the last command    */
      if (got_pidfile)
      {
        if (opt_verbose)
          printf("Shutdown signal sent to server;  Waiting for pid file to disappear\n");

        /* Wait until pid file is gone */
        if (wait_pidfile(pidfile, last_modified, &pidfile_status))
          return -1;
      }
      break;
    }
    case ADMIN_FLUSH_PRIVILEGES:
    case ADMIN_RELOAD:
      if (mysql_query(mysql,"flush privileges"))
      {
        my_printf_error(0,"reload failed; error: '%s'",MYF(ME_BELL),
                        mysql_error(mysql));
        return -1;
      }
      break;
    case ADMIN_REFRESH:
      if (mysql_refresh(mysql,
                        (uint) ~(REFRESH_GRANT | REFRESH_STATUS |
                                 REFRESH_READ_LOCK | REFRESH_SLAVE |
                                 REFRESH_MASTER)))
      {
        my_printf_error(0,"refresh failed; error: '%s'",MYF(ME_BELL),
                        mysql_error(mysql));
        return -1;
      }
      break;
    case ADMIN_FLUSH_THREADS:
      if (mysql_refresh(mysql,(uint) REFRESH_THREADS))
      {
        my_printf_error(0,"refresh failed; error: '%s'",MYF(ME_BELL),
                        mysql_error(mysql));
        return -1;
      }
      break;
    case ADMIN_VER:
      new_line=1;
      print_version();
      puts("Copyright (C) 2000 MySQL AB & MySQL Finland AB & TCX DataKonsult AB");
      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");
      printf("Server version\t\t%s\n", mysql_get_server_info(mysql));
      printf("Protocol version\t%d\n", mysql_get_proto_info(mysql));
      printf("Connection\t\t%s\n",mysql_get_host_info(mysql));
      if (mysql->unix_socket)
        printf("UNIX socket\t\t%s\n", mysql->unix_socket);
      else
        printf("TCP port\t\t%d\n", mysql->port);
      status=mysql_stat(mysql);
      {
        char *pos,buff[40];
        ulong sec;
        pos= (char*) strchr(status,' ');
        *pos++=0;
        printf("%s\t\t\t",status);                      /* print label */
        if ((status=str2int(pos,10,0,LONG_MAX,(long*) &sec)))
        {
          nice_time(sec,buff);
          puts(buff);                           /* print nice time */
          while (*status == ' ') status++;      /* to next info */
        }
      }
      putc('\n',stdout);
      if (status)
        puts(status);
      break;
    case ADMIN_PROCESSLIST:
    {
      MYSQL_RES *result;
      MYSQL_ROW row;

      if (mysql_query(mysql, (opt_verbose ? "show full processlist" :
                              "show processlist")) ||
          !(result = mysql_store_result(mysql)))
      {
        my_printf_error(0,"process list failed; error: '%s'",MYF(ME_BELL),
                        mysql_error(mysql));
        return -1;
      }
      print_header(result);
      while ((row=mysql_fetch_row(result)))
        print_row(result,row,0);
      print_top(result);
      mysql_free_result(result);
      new_line=1;
      break;
    }
    case ADMIN_STATUS:
      status=mysql_stat(mysql);
      if (status)
        puts(status);
      break;
    case ADMIN_KILL:
      {
        uint error=0;
        char *pos;
        if (argc < 2)
        {
          my_printf_error(0,"Too few arguments to 'kill'",MYF(ME_BELL));
          return 1;
        }
        pos=argv[1];
        for (;;)
        {
          if (mysql_kill(mysql,(ulong) atol(pos)))
          {
            my_printf_error(0,"kill failed on %ld; error: '%s'",MYF(ME_BELL),
                            atol(pos), mysql_error(mysql));
            error=1;
          }
          if (!(pos=strchr(pos,',')))
            break;
          pos++;
        }
        argc--; argv++;
        if (error)
          return -1;
        break;
      }
    case ADMIN_DEBUG:
      if (mysql_dump_debug_info(mysql))
      {
        my_printf_error(0,"debug failed; error: '%s'",MYF(ME_BELL),
                        mysql_error(mysql));
        return -1;
      }
      break;
    case ADMIN_VARIABLES:
    {
      MYSQL_RES *res;
      MYSQL_ROW row;

      new_line=1;
      if (mysql_query(mysql,"show /*!40003 GLOBAL */ variables") ||
          !(res=mysql_store_result(mysql)))
      {
        my_printf_error(0,"unable to show variables; error: '%s'",MYF(ME_BELL),
                        mysql_error(mysql));
        return -1;
      }
      print_header(res);
      while ((row=mysql_fetch_row(res)))
        print_row(res,row,0);
      print_top(res);
      mysql_free_result(res);
      break;
    }
    case ADMIN_EXTENDED_STATUS:
    {
      MYSQL_RES *res;
      MYSQL_ROW row;
      uint rownr = 0;
      void (*func) (MYSQL_RES*, MYSQL_ROW, uint);

      new_line = 1;
      if (mysql_query(mysql, "show /*!50002 GLOBAL */ status") ||
          !(res = mysql_store_result(mysql)))
      {
        my_printf_error(0, "unable to show status; error: '%s'", MYF(ME_BELL),
                        mysql_error(mysql));
        return -1;
      }
      if (!opt_vertical)
        print_header(res);
      else
      {
        if (!ex_status_printed)
        {
          store_values(res);
          truncate_names();   /* Does some printing also */
        }
        else
        {
          print_relative_line();
          print_relative_header();
          print_relative_line();
        }
      }

      /*      void (*func) (MYSQL_RES*, MYSQL_ROW, uint); */
      if (opt_relative && !opt_vertical)
        func = print_relative_row;
      else if (opt_vertical)
        func = print_relative_row_vert;
      else
        func = print_row;

      while ((row = mysql_fetch_row(res)))
        (*func)(res, row, rownr++);
      if (opt_vertical)
      {
        if (ex_status_printed)
        {
          putchar('\n');
          print_relative_line();
        }
      }
      else
        print_top(res);

      ex_status_printed = 1; /* From now on the output will be relative */
      mysql_free_result(res);
      break;
    }
    case ADMIN_FLUSH_LOGS:
    {
      if (mysql_refresh(mysql,REFRESH_LOG))
      {
        my_printf_error(0,"refresh failed; error: '%s'",MYF(ME_BELL),
                        mysql_error(mysql));
        return -1;
      }
      break;
    }
    case ADMIN_FLUSH_HOSTS:
    {
      if (mysql_query(mysql,"flush hosts"))
      {
        my_printf_error(0,"refresh failed; error: '%s'",MYF(ME_BELL),
                        mysql_error(mysql));
        return -1;
      }
      break;
    }
    case ADMIN_FLUSH_TABLES:
    {
      if (mysql_query(mysql,"flush tables"))
      {
        my_printf_error(0,"refresh failed; error: '%s'",MYF(ME_BELL),
                        mysql_error(mysql));
        return -1;
      }
      break;
    }
    case ADMIN_FLUSH_STATUS:
    {
      if (mysql_query(mysql,"flush status"))
      {
        my_printf_error(0,"refresh failed; error: '%s'",MYF(ME_BELL),
                        mysql_error(mysql));
        return -1;
      }
      break;
    }
    case ADMIN_OLD_PASSWORD:
    case ADMIN_PASSWORD:
    {
      char buff[128],crypted_pw[64];
      time_t start_time;
      /* Do initialization the same way as we do in mysqld */
      start_time=time((time_t*) 0);
      randominit(&rand_st,(ulong) start_time,(ulong) start_time/2);

      if (argc < 2)
      {
        my_printf_error(0,"Too few arguments to change password",MYF(ME_BELL));
        return 1;
      }
      if (argv[1][0])
      {
        char *pw= argv[1];
        bool old= (find_type(argv[0], &command_typelib, 2) ==
                   ADMIN_OLD_PASSWORD);
#ifdef __WIN__
        uint pw_len= strlen(pw);
        if (pw_len > 1 && pw[0] == '\'' && pw[pw_len-1] == '\'')
          printf("Warning: single quotes were not trimmed from the password by"
                 " your command\nline client, as you might have expected.\n");
#endif
        /*
           If we don't already know to use an old-style password, see what
           the server is using
        */
        if (!old)
        {
          if (mysql_query(mysql, "SHOW VARIABLES LIKE 'old_passwords'"))
          {
            my_printf_error(0, "Could not determine old_passwords setting from server; error: '%s'",
                            MYF(ME_BELL),mysql_error(mysql));
            return -1;
          }
          else
          {
            MYSQL_RES *res= mysql_store_result(mysql);
            if (!res)
            {
              my_printf_error(0,
                              "Could not get old_passwords setting from "
                              "server; error: '%s'",
                              MYF(ME_BELL),mysql_error(mysql));
              return -1;
            }
            if (!mysql_num_rows(res))
              old= 1;
            else
            {
              MYSQL_ROW row= mysql_fetch_row(res);
              old= !strncmp(row[1], "ON", 2);
            }
            mysql_free_result(res);
          }
        }
        if (old)
          make_scrambled_password_323(crypted_pw, pw);
        else
          make_scrambled_password(crypted_pw, pw);
      }
      else
        crypted_pw[0]=0;                        /* No password */
      sprintf(buff,"set password='%s',sql_log_off=0",crypted_pw);

      if (mysql_query(mysql,"set sql_log_off=1"))
      {
        my_printf_error(0, "Can't turn off logging; error: '%s'",
                        MYF(ME_BELL),mysql_error(mysql));
        return -1;
      }
      if (mysql_query(mysql,buff))
      {
        if (mysql_errno(mysql)!=1290)
        {
          my_printf_error(0,"unable to change password; error: '%s'",
                          MYF(ME_BELL),mysql_error(mysql));
          return -1;
        }
        else
        {
          /*
            We don't try to execute 'update mysql.user set..'
            because we can't perfectly find out the host
           */
          my_printf_error(0,"\n"
                          "You cannot use 'password' command as mysqld runs\n"
                          " with grant tables disabled (was started with"
                          " --skip-grant-tables).\n"
                          "Use: \"mysqladmin flush-privileges password '*'\""
                          " instead", MYF(ME_BELL));
          return -1;
        }
      }
      argc--; argv++;
      break;
    }

    case ADMIN_START_SLAVE:
      if (mysql_query(mysql, "START SLAVE"))
      {
        my_printf_error(0, "Error starting slave: %s", MYF(ME_BELL),
                        mysql_error(mysql));
        return -1;
      }
      else
        puts("Slave started");
      break;
    case ADMIN_STOP_SLAVE:
      if (mysql_query(mysql, "STOP SLAVE"))
      {
          my_printf_error(0, "Error stopping slave: %s", MYF(ME_BELL),
                          mysql_error(mysql));
          return -1;
      }
      else
        puts("Slave stopped");
      break;

    case ADMIN_PING:
      mysql->reconnect=0;       /* We want to know of reconnects */
      if (!mysql_ping(mysql))
      {
        if (option_silent < 2)
          puts("mysqld is alive");
      }
      else
      {
        if (mysql_errno(mysql) == CR_SERVER_GONE_ERROR)
        {
          mysql->reconnect=1;
          if (!mysql_ping(mysql))
            puts("connection was down, but mysqld is now alive");
        }
        else
        {
          my_printf_error(0,"mysqld doesn't answer to ping, error: '%s'",
                          MYF(ME_BELL),mysql_error(mysql));
          return -1;
        }
      }
      mysql->reconnect=1;       /* Automatic reconnect is default */
      break;
#ifdef LATER_HAVE_NDBCLUSTER_DB
    case ADMIN_NDB_MGM:
    {
      if (argc < 2)
      {
        my_printf_error(0,"Too few arguments to ndb-mgm",MYF(ME_BELL));
        return 1;
      }
      {
        Ndb_mgmclient_handle cmd=
          ndb_mgmclient_handle_create(opt_ndb_connectstring);
        ndb_mgmclient_execute(cmd, --argc, ++argv);
        ndb_mgmclient_handle_destroy(cmd);
      }
      argc= 0;
    }
    break;
#endif
    default:
      my_printf_error(0,"Unknown command: '%-.60s'",MYF(ME_BELL),argv[0]);
      return 1;
    }
  }
  return 0;
}

Here is the call graph for this function:

Here is the caller graph for this function:

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

Definition at line 223 of file mysqladmin.cc.

References atoi(), charsets_dir, DBUG_PUSH, error, exit, find_type(), MY_ALLOW_ZERO_PTR, MY_FAE, my_free, my_strdup(), MYF, MYSQL_PROTOCOL_PIPE, OPT_AUTO_CLOSE, OPT_CHARSETS_DIR, opt_count_iterations, OPT_MYSQL_PROTOCOL, opt_password, opt_protocol, option_silent, option_wait, print_version(), sql_protocol_typelib, start(), tty_password, and usage().

{
  int error = 0;

  switch(optid) {
#ifdef __NETWARE__
  case OPT_AUTO_CLOSE:
    setscreenmode(SCR_AUTOCLOSE_ON_EXIT);
    break;
#endif
  case 'c':
    opt_count_iterations= 1;
    break;
  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 's':
    option_silent++;
    break;
  case 'W':
#ifdef __WIN__
    opt_protocol = MYSQL_PROTOCOL_PIPE;
#endif
    break;
  case '#':
    DBUG_PUSH(argument ? argument : "d:t:o,/tmp/mysqladmin.trace");
    break;
#include <sslopt-case.h>
  case 'V':
    print_version();
    exit(0);
    break;
  case 'w':
    if (argument)
    {
      if ((option_wait=atoi(argument)) <= 0)
        option_wait=1;
    }
    else
      option_wait= ~(uint)0;
    break;
  case '?':
  case 'I':                                     /* Info */
    error++;
    break;
  case OPT_CHARSETS_DIR:
#if MYSQL_VERSION_ID > 32300
    charsets_dir = argument;
#endif
    break;
  case 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;
  }
  }
  if (error)
  {
    usage();
    exit(1);
  }
  return 0;
}

Here is the call graph for this function:

static my_bool get_pidfile	(	MYSQL *	mysql,
		char *	pidfile
	)			[static]

Definition at line 1283 of file mysqladmin.cc.

References ME_BELL, my_printf_error(), MYF, mysql, mysql_error(), mysql_fetch_row(), mysql_free_result(), mysql_query(), mysql_store_result(), and strmov().

Referenced by execute_commands().

{
  MYSQL_RES* result;

  if (mysql_query(mysql, "SHOW VARIABLES LIKE 'pid_file'"))
  {
    my_printf_error(0,"query failed; error: '%s'",MYF(ME_BELL),
                    mysql_error(mysql));
  }
  result = mysql_store_result(mysql);
  if (result)
  {
    MYSQL_ROW row=mysql_fetch_row(result);
    if (row)
      strmov(pidfile, row[1]);
    mysql_free_result(result);
    return row == 0;                            /* Error if row = 0 */
  }
  return 1;                                     /* Error */
}

Here is the call graph for this function:

Here is the caller graph for this function:

int main	(	int	argc,
		char *	argv[]
	)

Definition at line 304 of file mysqladmin.cc.

References ADMIN_PING, command_typelib, CR_MAX_ERROR, CR_MIN_ERROR, default_charset, endprog(), err, error, execute_commands(), exit, find_type(), free_defaults(), get_one_option(), get_tty_password(), handle_options(), interrupted, interval, load_default_groups, load_defaults(), MY_ALLOW_ZERO_PTR, my_end(), my_free, MY_INIT, my_long_options, MYF, mysql, mysql_close(), mysql_errno(), mysql_init(), MYSQL_OPT_COMPRESS, MYSQL_OPT_CONNECT_TIMEOUT, MYSQL_OPT_PROTOCOL, MYSQL_OPT_SSL_VERIFY_SERVER_CERT, mysql_options(), MYSQL_SET_CHARSET_NAME, MYSQL_SHARED_MEMORY_BASE_NAME, mysql_ssl_set(), new_line, nr_iterations, NullS, opt_compress, opt_connect_timeout, opt_count_iterations, opt_password, opt_protocol, option_force, option_wait, sleep, sql_connect(), tty_password, usage(), user, and VOID.

{
  int error= 0, ho_error;
  MYSQL mysql;
  char **commands, **save_argv;

  MY_INIT(argv[0]);
  mysql_init(&mysql);
  load_defaults("my",load_default_groups,&argc,&argv);
  save_argv = argv;                             /* Save for free_defaults */
  if ((ho_error=handle_options(&argc, &argv, my_long_options, get_one_option)))
  {
    free_defaults(save_argv);
    exit(ho_error);
  }

  if (argc == 0)
  {
    usage();
    exit(1);
  }
  commands = argv;
  if (tty_password)
    opt_password = get_tty_password(NullS);

  VOID(signal(SIGINT,endprog));                 /* Here if abort */
  VOID(signal(SIGTERM,endprog));                /* Here if abort */

  if (opt_compress)
    mysql_options(&mysql,MYSQL_OPT_COMPRESS,NullS);
  if (opt_connect_timeout)
  {
    uint tmp=opt_connect_timeout;
    mysql_options(&mysql,MYSQL_OPT_CONNECT_TIMEOUT, (char*) &tmp);
  }
#ifdef HAVE_OPENSSL
  if (opt_use_ssl)
    mysql_ssl_set(&mysql, opt_ssl_key, opt_ssl_cert, opt_ssl_ca,
                  opt_ssl_capath, opt_ssl_cipher);
  mysql_options(&mysql,MYSQL_OPT_SSL_VERIFY_SERVER_CERT,
                (char*)&opt_ssl_verify_server_cert);
#endif
  if (opt_protocol)
    mysql_options(&mysql,MYSQL_OPT_PROTOCOL,(char*)&opt_protocol);
#ifdef HAVE_SMEM
  if (shared_memory_base_name)
    mysql_options(&mysql,MYSQL_SHARED_MEMORY_BASE_NAME,shared_memory_base_name);
#endif
  if (default_charset)
    mysql_options(&mysql, MYSQL_SET_CHARSET_NAME, default_charset);
  if (sql_connect(&mysql, option_wait))
  {
    unsigned int err= mysql_errno(&mysql);
    if (err >= CR_MIN_ERROR && err <= CR_MAX_ERROR)
      error= 1;
    else
    {
      /* Return 0 if all commands are PING */
      for (; argc > 0; argv++, argc--)
      {
        if (find_type(argv[0], &command_typelib, 2) != ADMIN_PING)
        {
          error= 1;
          break;
        }
      }
    }
  }
  else
  {
    while (!interrupted && (!opt_count_iterations || nr_iterations))
    {
      new_line = 0;
      if ((error=execute_commands(&mysql,argc,commands)))
      {
        if (error > 0)
          break;                                /* Wrong command error */
        if (!option_force)
        {
          if (option_wait && !interrupted)
          {
            mysql_close(&mysql);
            if (!sql_connect(&mysql, option_wait))
            {
              sleep(1);                         /* Don't retry too rapidly */
              continue;                         /* Retry */
            }
          }
          error=1;
          break;
        }
      }
      if (interval)
      {
        sleep(interval);
        if (new_line)
          puts("");
        if (opt_count_iterations)
          nr_iterations--;
      }
      else
        break;
    }
    mysql_close(&mysql);
  }
  my_free(opt_password,MYF(MY_ALLOW_ZERO_PTR));
  my_free(user,MYF(MY_ALLOW_ZERO_PTR));
#ifdef HAVE_SMEM
  my_free(shared_memory_base_name,MYF(MY_ALLOW_ZERO_PTR));
#endif
  free_defaults(save_argv);
  my_end(0);
  exit(error ? 1 : 0);
  return 0;
}

Here is the call graph for this function:

static void nice_time	(	ulong	sec,
		char *	buff
	)			[static]

Definition at line 1073 of file mysqladmin.cc.

References int10_to_str(), and strmov().

{
  ulong tmp;

  if (sec >= 3600L*24)
  {
    tmp=sec/(3600L*24);
    sec-=3600L*24*tmp;
    buff=int10_to_str(tmp, buff, 10);
    buff=strmov(buff,tmp > 1 ? " days " : " day ");
  }
  if (sec >= 3600L)
  {
    tmp=sec/3600L;
    sec-=3600L*tmp;
    buff=int10_to_str(tmp, buff, 10);
    buff=strmov(buff,tmp > 1 ? " hours " : " hour ");
  }
  if (sec >= 60)
  {
    tmp=sec/60;
    sec-=60*tmp;
    buff=int10_to_str(tmp, buff, 10);
    buff=strmov(buff," min ");
  }
  strmov(int10_to_str(sec, buff, 10)," sec");
}

Here is the call graph for this function:

static void print_header

(

MYSQL_RES *

result

)

[static]

Definition at line 1102 of file mysqladmin.cc.

References st_mysql_field::max_length, mysql_fetch_field(), mysql_field_seek(), st_mysql_field::name, and print_top().

Referenced by execute_commands(), list_dbs(), and list_tables().

{
  MYSQL_FIELD *field;

  print_top(result);
  mysql_field_seek(result,0);
  putchar('|');
  while ((field = mysql_fetch_field(result)))
  {
    printf(" %-*s|",(int) field->max_length+1,field->name);
  }
  putchar('\n');
  print_top(result);
}

Here is the call graph for this function:

Here is the caller graph for this function:

static void print_relative_header

(

)

[static]

Definition at line 1220 of file mysqladmin.cc.

References ex_val_max_len, ex_var_count, and truncated_var_names.

Referenced by execute_commands().

{
  uint i;

  putchar('|');
  for (i = 0; i < ex_var_count; i++)
    printf(" %-*s|", ex_val_max_len[i] + 1, truncated_var_names[i]);
  putchar('\n');
}

Here is the caller graph for this function:

static void print_relative_line

(

)

[static]

Definition at line 1231 of file mysqladmin.cc.

References ex_val_max_len, and ex_var_count.

Referenced by execute_commands().

{
  uint i;

  putchar('+');
  for (i = 0; i < ex_var_count; i++)
  {
    uint j;
    for (j = 0; j < ex_val_max_len[i] + 2; j++)
      putchar('-');
    putchar('+');
  }
  putchar('\n');
}

Here is the caller graph for this function:

static void print_relative_row	(	MYSQL_RES *	result,
		MYSQL_ROW	cur,
		uint	row
	)			[static]

Definition at line 1158 of file mysqladmin.cc.

References last_values, llstr(), st_mysql_field::max_length, mysql_fetch_field(), mysql_field_seek(), NULL, and strtoull.

Referenced by execute_commands().

{
  ulonglong tmp;
  char buff[22];
  MYSQL_FIELD *field;

  mysql_field_seek(result, 0);
  field = mysql_fetch_field(result);
  printf("| %-*s|", (int) field->max_length + 1, cur[0]);

  field = mysql_fetch_field(result);
  tmp = cur[1] ? strtoull(cur[1], NULL, 10) : (ulonglong) 0;
  printf(" %-*s|\n", (int) field->max_length + 1,
         llstr((tmp - last_values[row]), buff));
  last_values[row] = tmp;
}

Here is the call graph for this function:

Here is the caller graph for this function:

static void print_relative_row_vert	(	MYSQL_RES *result	__attribute__((unused)),
		MYSQL_ROW	cur,
		uint row	__attribute__((unused))
	)			[static]

Definition at line 1176 of file mysqladmin.cc.

References ex_status_printed, ex_val_max_len, last_values, llstr(), NULL, strlen(), and strtoull.

{
  uint length;
  ulonglong tmp;
  char buff[22];

  if (!row)
    putchar('|');

  tmp = cur[1] ? strtoull(cur[1], NULL, 10) : (ulonglong) 0;
  printf(" %-*s|", ex_val_max_len[row] + 1,
         llstr((tmp - last_values[row]), buff));

  /* Find the minimum row length needed to output the relative value */
  if ((length=(uint) strlen(buff) > ex_val_max_len[row]) && ex_status_printed)
    ex_val_max_len[row] = length;
  last_values[row] = tmp;
}

Here is the call graph for this function:

static void print_relative_row_vert	(	MYSQL_RES *	result,
		MYSQL_ROW	cur,
		uint	row
	)			[static]

Referenced by execute_commands().

Here is the caller graph for this function:

static void print_row	(	MYSQL_RES *	result,
		MYSQL_ROW	cur,
		uint row	__attribute__((unused))
	)			[static]

Definition at line 1140 of file mysqladmin.cc.

References st_mysql_field::max_length, mysql_fetch_field(), mysql_field_seek(), and mysql_num_fields().

{
  uint i,length;
  MYSQL_FIELD *field;

  putchar('|');
  mysql_field_seek(result,0);
  for (i=0 ; i < mysql_num_fields(result); i++)
  {
    field = mysql_fetch_field(result);
    length=field->max_length;
    printf(" %-*s|",length+1,cur[i] ? (char*) cur[i] : "");
  }
  putchar('\n');
}

Here is the call graph for this function:

static void print_row	(	MYSQL_RES *	result,
		MYSQL_ROW	cur,
		uint	row
	)			[static]

Referenced by execute_commands(), list_dbs(), and list_tables().

Here is the caller graph for this function:

static void print_top

(

MYSQL_RES *

result

)

[static]

Definition at line 1118 of file mysqladmin.cc.

References st_mysql_field::max_length, mysql_fetch_field(), mysql_field_seek(), st_mysql_field::name, and strlen().

Referenced by execute_commands(), and print_header().

{
  uint i,length;
  MYSQL_FIELD *field;

  putchar('+');
  mysql_field_seek(result,0);
  while((field = mysql_fetch_field(result)))
  {
    if ((length=(uint) strlen(field->name)) > field->max_length)
      field->max_length=length;
    else
      length=field->max_length;
    for (i=length+2 ; i--> 0 ; )
      putchar('-');
    putchar('+');
  }
  putchar('\n');
}

Here is the call graph for this function:

Here is the caller graph for this function:

static void print_version

(

void

)

[static]

Definition at line 995 of file mysqladmin.cc.

References ADMIN_VERSION, MACHINE_TYPE, my_progname, MYSQL_SERVER_VERSION, NETWARE_SET_SCREEN_MODE, and SYSTEM_TYPE.

Referenced by execute_commands(), get_one_option(), and usage().

{
  printf("%s  Ver %s Distrib %s, for %s on %s\n",my_progname,ADMIN_VERSION,
         MYSQL_SERVER_VERSION,SYSTEM_TYPE,MACHINE_TYPE);
  NETWARE_SET_SCREEN_MODE(1);
}

Here is the caller graph for this function:

static my_bool sql_connect	(	MYSQL *	mysql,
		uint	wait
	)			[static]

Definition at line 427 of file mysqladmin.cc.

References CR_CONN_HOST_ERROR, CR_CONNECTION_ERROR, CR_UNKNOWN_HOST, host, info, LOCAL_HOST, ME_BELL, my_printf_error(), MYF, mysql, mysql_errno(), mysql_error(), mysql_port, mysql_real_connect(), mysql_unix_port, NullS, opt_password, option_force, option_silent, sleep, tcp_port, unix_port, and user.

{
  my_bool info=0;

  for (;;)
  {
    if (mysql_real_connect(mysql,host,user,opt_password,NullS,tcp_port,
                           unix_port, 0))
    {
      mysql->reconnect= 1;
      if (info)
      {
        fputs("\n",stderr);
        (void) fflush(stderr);
      }
      return 0;
    }

    if (!wait)
    {
      if (!option_silent)
      {
        if (!host)
          host= (char*) LOCAL_HOST;
        my_printf_error(0,"connect to server at '%s' failed\nerror: '%s'",
                        MYF(ME_BELL), host, mysql_error(mysql));
        if (mysql_errno(mysql) == CR_CONNECTION_ERROR)
        {
          fprintf(stderr,
                  "Check that mysqld is running and that the socket: '%s' exists!\n",
                  unix_port ? unix_port : mysql_unix_port);
        }
        else if (mysql_errno(mysql) == CR_CONN_HOST_ERROR ||
                 mysql_errno(mysql) == CR_UNKNOWN_HOST)
        {
          fprintf(stderr,"Check that mysqld is running on %s",host);
          fprintf(stderr," and that the port is %d.\n",
                  tcp_port ? tcp_port: mysql_port);
          fprintf(stderr,"You can check this by doing 'telnet %s %d'\n",
                  host, tcp_port ? tcp_port: mysql_port);
        }
      }
      return 1;
    }
    if (wait != (uint) ~0)
      wait--;                           /* One less retry */
    if ((mysql_errno(mysql) != CR_CONN_HOST_ERROR) &&
        (mysql_errno(mysql) != CR_CONNECTION_ERROR))
    {
      fprintf(stderr,"Got error: %s\n", mysql_error(mysql));
      if (!option_force)
        return 1;
    }
    else if (!option_silent)
    {
      if (!info)
      {
        info=1;
        fputs("Waiting for MySQL server to answer",stderr);
        (void) fflush(stderr);
      }
      else
      {
        putc('.',stderr);
        (void) fflush(stderr);
      }
    }
    sleep(5);
  }
}

Here is the call graph for this function:

static void store_values

(

MYSQL_RES *

result

)

[static]

Definition at line 1198 of file mysqladmin.cc.

References ex_val_max_len, ex_var_count, ex_var_names, last_values, st_mysql_field::max_length, max_val_length, max_var_length, mysql_fetch_field(), mysql_fetch_row(), NULL, strmov(), and strtoull.

Referenced by execute_commands().

{
  uint i;
  MYSQL_ROW row;
  MYSQL_FIELD *field;

  field = mysql_fetch_field(result);
  max_var_length = field->max_length;
  field = mysql_fetch_field(result);
  max_val_length = field->max_length;

  for (i = 0; (row = mysql_fetch_row(result)); i++)
  {
    strmov(ex_var_names[i], row[0]);
    last_values[i]=strtoull(row[1],NULL,10);
    ex_val_max_len[i]=2;                /* Default print width for values */
  }
  ex_var_count = i;
  return;
}

Here is the call graph for this function:

Here is the caller graph for this function:

static void truncate_names

(

)

[static]

Definition at line 1247 of file mysqladmin.cc.

References ex_var_count, ex_var_names, int10_to_str(), last_values, llstr(), MAX_TRUNC_LENGTH, max_val_length, max_var_length, NAME_LEN, strfill(), and truncated_var_names.

Referenced by execute_commands().

{
  uint i;
  char *ptr,top_line[MAX_TRUNC_LENGTH+4+NAME_LEN+22+1],buff[22];

  ptr=top_line;
  *ptr++='+';
  ptr=strfill(ptr,max_var_length+2,'-');
  *ptr++='+';
  ptr=strfill(ptr,MAX_TRUNC_LENGTH+2,'-');
  *ptr++='+';
  ptr=strfill(ptr,max_val_length+2,'-');
  *ptr++='+';
  *ptr=0;
  puts(top_line);

  for (i = 0 ; i < ex_var_count; i++)
  {
    uint sfx=1,j;
    printf("| %-*s|", max_var_length + 1, ex_var_names[i]);
    ptr = ex_var_names[i];
    /* Make sure no two same truncated names will become */
    for (j = 0; j < i; j++)
      if (*truncated_var_names[j] == *ptr)
        sfx++;

    truncated_var_names[i][0]= *ptr;            /* Copy first var char */
    int10_to_str(sfx, truncated_var_names[i]+1,10);
    printf(" %-*s|", MAX_TRUNC_LENGTH + 1, truncated_var_names[i]);
    printf(" %-*s|\n", max_val_length + 1, llstr(last_values[i],buff));
  }
  puts(top_line);
  return;
}

Here is the call graph for this function:

Here is the caller graph for this function:

static void usage

(

void

)

[static]

Definition at line 1003 of file mysqladmin.cc.

References load_default_groups, my_long_options, my_print_help(), my_print_variables(), my_progname, print_defaults(), and print_version().

{
  print_version();
  puts("Copyright (C) 2000 MySQL AB & MySQL Finland AB & TCX DataKonsult AB");
  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("Administration program for the mysqld daemon.");
  printf("Usage: %s [OPTIONS] command command....\n", my_progname);
  my_print_help(my_long_options);
  my_print_variables(my_long_options);
  print_defaults("my",load_default_groups);
  puts("\nWhere command is a one or more of: (Commands may be shortened)\n\
  create databasename   Create a new database\n\
  debug                 Instruct server to write debug information to log\n\
  drop databasename     Delete a database and all its tables\n\
  extended-status       Gives an extended status message from the server\n\
  flush-hosts           Flush all cached hosts\n\
  flush-logs            Flush all logs\n\
  flush-status          Clear status variables\n\
  flush-tables          Flush all tables\n\
  flush-threads         Flush the thread cache\n\
  flush-privileges      Reload grant tables (same as reload)\n\
  kill id,id,...        Kill mysql threads");
#if MYSQL_VERSION_ID >= 32200
  puts("\
  password new-password Change old password to new-password, MySQL 4.1 hashing.\n\
  old-password new-password Change old password to new-password in old format.\n");
#endif
  puts("\
  ping                  Check if mysqld is alive\n\
  processlist           Show list of active threads in server\n\
  reload                Reload grant tables\n\
  refresh               Flush all tables and close and open logfiles\n\
  shutdown              Take server down\n\
  status                Gives a short status message from the server\n\
  start-slave           Start slave\n\
  stop-slave            Stop slave\n\
  variables             Prints variables available\n\
  version               Get version info from server");
}

Here is the call graph for this function:

static my_bool wait_pidfile	(	char *	pidfile,
		time_t	last_modified,
		struct stat *	pidfile_status
	)			[static]

Definition at line 1308 of file mysqladmin.cc.

References count, DBUG_ENTER, DBUG_PRINT, DBUG_RETURN, error, FN_REFLEN, interrupted, my_close(), my_open(), MYF, opt_shutdown_timeout, opt_verbose, sleep, and system_filename().

Referenced by execute_commands().

{
  char buff[FN_REFLEN];
  int error= 1;
  uint count= 0;
  DBUG_ENTER("wait_pidfile");

  system_filename(buff, pidfile);
  do
  {
    int fd;
    if ((fd= my_open(buff, O_RDONLY, MYF(0))) < 0)
    {
      error= 0;
      break;
    }
    (void) my_close(fd,MYF(0));
    if (last_modified && !stat(pidfile, pidfile_status))
    {
      if (last_modified != pidfile_status->st_mtime)
      {
        /* File changed;  Let's assume that mysqld did restart */
        if (opt_verbose)
          printf("pid file '%s' changed while waiting for it to disappear!\nmysqld did probably restart\n",
                 buff);
        error= 0;
        break;
      }
    }
    if (count++ == opt_shutdown_timeout)
      break;
    sleep(1);
  } while (!interrupted);

  if (error)
  {
    DBUG_PRINT("warning",("Pid file didn't disappear"));
    fprintf(stderr,
            "Warning;  Aborted waiting on pid file: '%s' after %d seconds\n",
            buff, count-1);
  }
  DBUG_RETURN(error);
}

Here is the call graph for this function:

Here is the caller graph for this function:

---

Variable Documentation

const char* command_names[] [static]

Initial value:

 {
  "create",               "drop",                "shutdown",
  "reload",               "refresh",             "version",
  "processlist",          "status",              "kill",
  "debug",                "variables",           "flush-logs",
  "flush-hosts",          "flush-tables",        "password",
  "ping",                 "extended-status",     "flush-status",
  "flush-privileges",     "start-slave",         "stop-slave",
  "flush-threads","old-password",



  NullS
}

Definition at line 109 of file mysqladmin.cc.

TYPELIB command_typelib [static]

Initial value:

{ array_elements(command_names)-1,"commands", command_names, NULL}

Definition at line 124 of file mysqladmin.cc.

Referenced by execute_commands(), get_query_type(), and main().

char * default_charset = NULL

Definition at line 37 of file mysqladmin.cc.

my_bool ex_status_printed = 0 [static]

Definition at line 66 of file mysqladmin.cc.

Referenced by execute_commands(), and print_relative_row_vert().

uint ex_val_max_len[MAX_MYSQL_VAR] [static]

Definition at line 65 of file mysqladmin.cc.

Referenced by print_relative_header(), print_relative_line(), print_relative_row_vert(), and store_values().

uint ex_var_count [static]

Definition at line 67 of file mysqladmin.cc.

Referenced by print_relative_header(), print_relative_line(), store_values(), and truncate_names().

char ex_var_names[MAX_MYSQL_VAR][FN_REFLEN]

Definition at line 39 of file mysqladmin.cc.

Referenced by store_values(), and truncate_names().

char* host = NULL

Definition at line 36 of file mysqladmin.cc.

Referenced by acl_load(), change_security_context(), check_acl_user(), check_grant_routine(), check_node_vs_replicas(), checkTCPConstraints(), cleanup(), compare_hostname(), CommandInterpreter::connect(), fill_schema_column_privileges(), fill_schema_processlist(), fill_schema_schema_privileges(), fill_schema_table_privileges(), fill_schema_user_privileges(), handle_grant_struct(), handle_grant_table(), main(), mysql_revoke_all(), mysql_show_grants(), run_task(), safe_connect(), show_routine_grants(), sql_connect(), and update_hostname().

my_bool interrupted = 0 [static]

Definition at line 42 of file mysqladmin.cc.

Referenced by endprog(), main(), net_real_write(), and wait_pidfile().

int interval = 0 [static]

Definition at line 41 of file mysqladmin.cc.

Referenced by calculate_interval_lengths(), date_add_interval(), Item_date_add_interval::get_date(), get_interval_id(), get_interval_value(), get_next_time(), main(), make_field(), mysql_prepare_table(), and unhex_type2().

ulonglong last_values[MAX_MYSQL_VAR]

Definition at line 40 of file mysqladmin.cc.

Referenced by print_relative_row(), print_relative_row_vert(), store_values(), and truncate_names().

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

Definition at line 220 of file mysqladmin.cc.

uint max_val_length [static]

Definition at line 67 of file mysqladmin.cc.

Referenced by store_values(), and truncate_names().

uint max_var_length [static]

Definition at line 67 of file mysqladmin.cc.

Referenced by store_values(), and truncate_names().

struct my_option my_long_options[] [static]

Definition at line 127 of file mysqladmin.cc.

my_bool new_line = 0 [static]

Definition at line 42 of file mysqladmin.cc.

Referenced by execute_commands(), and main().

uint nr_iterations [static]

Definition at line 45 of file mysqladmin.cc.

Referenced by main().

my_bool opt_compress = 0 [static]

Definition at line 43 of file mysqladmin.cc.

ulong opt_connect_timeout [static]

Definition at line 47 of file mysqladmin.cc.

uint opt_count_iterations = 0 [static]

Definition at line 46 of file mysqladmin.cc.

Referenced by get_one_option(), and main().

char * opt_password = 0

Definition at line 36 of file mysqladmin.cc.

uint opt_protocol = 0 [static]

Definition at line 57 of file mysqladmin.cc.

my_bool opt_relative = 0 [static]

Definition at line 43 of file mysqladmin.cc.

Referenced by execute_commands().

ulong opt_shutdown_timeout [static]

Definition at line 47 of file mysqladmin.cc.

Referenced by wait_pidfile().

my_bool opt_verbose = 0 [static]

Definition at line 43 of file mysqladmin.cc.

my_bool opt_vertical = 0 [static]

Definition at line 43 of file mysqladmin.cc.

Referenced by execute_commands().

my_bool option_force = 0 [static]

Definition at line 42 of file mysqladmin.cc.

Referenced by drop_db(), main(), and sql_connect().

uint option_silent = 0 [static]

Definition at line 45 of file mysqladmin.cc.

Referenced by execute_commands(), get_one_option(), and sql_connect().

uint option_wait = 0 [static]

Definition at line 45 of file mysqladmin.cc.

Referenced by get_one_option(), and main().

uint tcp_port = 0 [static]

Definition at line 45 of file mysqladmin.cc.

Referenced by sql_connect().

char truncated_var_names[MAX_MYSQL_VAR][MAX_TRUNC_LENGTH]

Definition at line 38 of file mysqladmin.cc.

Referenced by print_relative_header(), and truncate_names().

my_bool tty_password = 0 [static]

Definition at line 44 of file mysqladmin.cc.

my_string unix_port = 0 [static]

Definition at line 48 of file mysqladmin.cc.

Referenced by sql_connect().

char * user = 0

Definition at line 36 of file mysqladmin.cc.

---

• Products
• MySQL Enterprise
• MySQL Cluster
• MySQL Embedded (OEM/ISV)
• MySQL Data Warehouse
• MySQL Backup & Recovery
• MySQL Workbench
• MySQL Connectors
• Online Shop

• Downloads
• MySQL Community Server
• MySQL Enterprise
• MySQL Proxy
• MySQL Cluster
• MySQL Workbench
• GUI Tools
• Connectors
• Archives
• Snapshots
• Mirrors

• Developer Zone
• Documentation
• Librarian
• Developer Articles
• Forums
• Bugs
• Forge
• Planet MySQL
• Labs
• MySQL Meetups
• Guilds
• Lists

• About
• About MySQL
• Contact Us
• Legal
• Privacy Policy
• Job Opportunities
• Site Map

© 1995-2008 MySQL AB, 2008- Sun Microsystems, Inc.