diff options
author | monty@donna.mysql.fi <> | 2001-04-09 21:08:56 +0300 |
---|---|---|
committer | monty@donna.mysql.fi <> | 2001-04-09 21:08:56 +0300 |
commit | 7f21a7a6daff97675749db987b12a080bb4c3799 (patch) | |
tree | 8f547099445a7673d67da016f7a567772cd5552c /scripts | |
parent | 3d19a5d4bb3bc3ab55574000ee014d3d65d17b12 (diff) | |
download | mariadb-git-7f21a7a6daff97675749db987b12a080bb4c3799.tar.gz |
Fixed INSERT DELAYED with Innobase
Fix for shutdown on NT
Fixed bug when using wrong dates from blob field.
Diffstat (limited to 'scripts')
-rw-r--r-- | scripts/mysql_convert_table_format.sh | 22 |
1 files changed, 20 insertions, 2 deletions
diff --git a/scripts/mysql_convert_table_format.sh b/scripts/mysql_convert_table_format.sh index 69eede94786..6b9a75228d3 100644 --- a/scripts/mysql_convert_table_format.sh +++ b/scripts/mysql_convert_table_format.sh @@ -8,10 +8,12 @@ use Getopt::Long; $opt_help=$opt_version=$opt_verbose=$opt_force=0; $opt_user=$opt_database=$opt_password=undef; $opt_host="localhost"; +$opt_socket=""; $opt_type="MYISAM"; +$opt_port=0; $exit_status=0; -GetOptions("force","help","host=s","password=s","user=s","type=s","verbose","version") || +GetOptions("force","help","host=s","password=s","user=s","type=s","verbose","version","socket=s", "port=i") || usage(0); usage($opt_version) if ($#ARGV < 0 || $opt_help || $opt_version); $opt_database=shift(@ARGV); @@ -22,7 +24,17 @@ if (uc($opt_type) eq "HEAP") exit(1); } -$dbh = DBI->connect("DBI:mysql:$opt_database:$opt_host", +$connect_opt=""; +if ($opt_port) +{ + $connect_opt.= ";port=$opt_port"; +} +if (length($opt_socket)) +{ + $connect_opt.=";mysql_socket=$opt_socket"; +} + +$dbh = DBI->connect("DBI:mysql:$opt_database:${opt_host}$connect_opt", $opt_user, $opt_password, { PrintError => 0}) @@ -96,6 +108,12 @@ Conversion of a MySQL tables to other table types. --password='password' Password for the current user. +--port=port + TCP/IP port to connect to if host is not "localhost". + +--socket='/path/to/socket' + Socket to connect with. + --type='table-type' Converts tables to the given table type (Default: $opt_type) MySQL 3.23 supports at least the BDB, ISAM and MYISAM types. |