summaryrefslogtreecommitdiff
path: root/scripts
diff options
context:
space:
mode:
authormonty@donna.mysql.fi <>2001-04-09 21:08:56 +0300
committermonty@donna.mysql.fi <>2001-04-09 21:08:56 +0300
commit7f21a7a6daff97675749db987b12a080bb4c3799 (patch)
tree8f547099445a7673d67da016f7a567772cd5552c /scripts
parent3d19a5d4bb3bc3ab55574000ee014d3d65d17b12 (diff)
downloadmariadb-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.sh22
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.