Gecko [ georgetownmover.com ]

Name	Size	Permission	Date
aria_chk	6.75 MB	-rwxr-xr-x	2024-05-26 18:41
aria_dump_log	6.54 MB	-rwxr-xr-x	2024-05-26 18:41
aria_ftdump	6.55 MB	-rwxr-xr-x	2024-05-26 18:41
aria_pack	6.58 MB	-rwxr-xr-x	2024-05-26 18:41
aria_read_log	6.71 MB	-rwxr-xr-x	2024-05-26 18:41
aria_s3_copy	6.38 MB	-rwxr-xr-x	2024-05-26 18:41
galera_new_cluster	917 B	-rwxr-xr-x	2024-05-26 18:20
galera_recovery	3.3 KB	-rwxr-xr-x	2025-02-25 04:02
garb-systemd	1.2 KB	-rwxr-xr-x	2024-04-17 17:33
garbd	26.52 MB	-rwxr-xr-x	2024-04-17 17:45
innochecksum	4.59 MB	-rwxr-xr-x	2024-05-26 18:41
mariabackup	28.79 MB	-rwxr-xr-x	2024-05-26 18:41
mariadb	8.58 MB	-rwxr-xr-x	2024-05-26 18:41
mariadb-access	109.57 KB	-rwxr-xr-x	2024-05-26 18:20
mariadb-admin	7.94 MB	-rwxr-xr-x	2024-05-26 18:41
mariadb-backup	28.79 MB	-rwxr-xr-x	2024-05-26 18:41
mariadb-binlog	8.22 MB	-rwxr-xr-x	2024-05-26 18:41
mariadb-check	7.93 MB	-rwxr-xr-x	2024-05-26 18:41
mariadb-client-test	8.48 MB	-rwxr-xr-x	2024-05-26 18:41
mariadb-config	24.76 KB	-rwxr-xr-x	2024-05-26 18:20
mariadb-conv	4.61 MB	-rwxr-xr-x	2024-05-26 18:41
mariadb-convert-table-format	4.28 KB	-rwxr-xr-x	2024-05-26 18:20
mariadb-dump	8.05 MB	-rwxr-xr-x	2024-05-26 18:41
mariadb-dumpslow	8.19 KB	-rwxr-xr-x	2024-05-26 18:20
mariadb-find-rows	3.35 KB	-rwxr-xr-x	2024-05-26 18:20
mariadb-fix-extensions	1.31 KB	-rwxr-xr-x	2024-05-26 18:20
mariadb-hotcopy	34.65 KB	-rwxr-xr-x	2024-05-26 18:20
mariadb-import	7.92 MB	-rwxr-xr-x	2024-05-26 18:41
mariadb-ldb	10.25 MB	-rwxr-xr-x	2024-05-26 18:41
mariadb-plugin	4.56 MB	-rwxr-xr-x	2024-05-26 18:41
mariadb-secure-installation	13.58 KB	-rwxr-xr-x	2024-05-26 18:20
mariadb-service-convert	2.45 KB	-rwxr-xr-x	2024-05-26 18:20
mariadb-setpermission	17.7 KB	-rwxr-xr-x	2024-05-26 18:20
mariadb-show	7.92 MB	-rwxr-xr-x	2024-05-26 18:41
mariadb-slap	7.94 MB	-rwxr-xr-x	2024-05-26 18:41
mariadb-test	8.86 MB	-rwxr-xr-x	2024-05-26 18:41
mariadb-tzinfo-to-sql	4.56 MB	-rwxr-xr-x	2024-05-26 18:41
mariadb-upgrade	5 MB	-rwxr-xr-x	2024-05-26 18:41
mariadb-waitpid	4.55 MB	-rwxr-xr-x	2024-05-26 18:41
mariadb_config	24.76 KB	-rwxr-xr-x	2024-05-26 18:20
mariadbd	298.21 MB	-rwxr-xr-x	2024-05-26 18:40
mariadbd-multi	27 KB	-rwxr-xr-x	2024-05-26 18:20
mariadbd-safe	30.62 KB	-rwxr-xr-x	2024-05-26 18:20
mariadbd-safe-helper	4.52 MB	-rwxr-xr-x	2024-05-26 18:41
mbstream	4.6 MB	-rwxr-xr-x	2024-05-26 18:41
msql2mysql	1.42 KB	-rwxr-xr-x	2024-05-26 18:20
my_print_defaults	4.55 MB	-rwxr-xr-x	2024-05-26 18:41
myisam_ftdump	4.92 MB	-rwxr-xr-x	2024-05-26 18:41
myisamchk	5.04 MB	-rwxr-xr-x	2024-05-26 18:41
myisamlog	4.9 MB	-rwxr-xr-x	2024-05-26 18:41
myisampack	4.94 MB	-rwxr-xr-x	2024-05-26 18:41
myrocks_hotbackup	24.46 KB	-rwxr-xr-x	2024-05-26 18:19
mysql	8.58 MB	-rwxr-xr-x	2024-05-26 18:41
mysql_client_test	8.48 MB	-rwxr-xr-x	2024-05-26 18:41
mysql_config	4.54 KB	-rwxr-xr-x	2024-05-26 18:20
mysql_convert_table_format	4.28 KB	-rwxr-xr-x	2024-05-26 18:20
mysql_find_rows	3.35 KB	-rwxr-xr-x	2024-05-26 18:20
mysql_fix_extensions	1.31 KB	-rwxr-xr-x	2024-05-26 18:20
mysql_ldb	10.25 MB	-rwxr-xr-x	2024-05-26 18:41
mysql_plugin	4.56 MB	-rwxr-xr-x	2024-05-26 18:41
mysql_secure_installation	13.58 KB	-rwxr-xr-x	2024-05-26 18:20
mysql_setpermission	17.7 KB	-rwxr-xr-x	2024-05-26 18:20
mysql_tzinfo_to_sql	4.56 MB	-rwxr-xr-x	2024-05-26 18:41
mysql_upgrade	5 MB	-rwxr-xr-x	2024-05-26 18:41
mysql_waitpid	4.55 MB	-rwxr-xr-x	2024-05-26 18:41
mysqlaccess	109.57 KB	-rwxr-xr-x	2024-05-26 18:20
mysqladmin	7.94 MB	-rwxr-xr-x	2024-05-26 18:41
mysqlbinlog	8.22 MB	-rwxr-xr-x	2024-05-26 18:41
mysqlcheck	7.93 MB	-rwxr-xr-x	2024-05-26 18:41
mysqld	298.21 MB	-rwxr-xr-x	2024-05-26 18:40
mysqld_multi	27 KB	-rwxr-xr-x	2024-05-26 18:20
mysqld_safe	30.62 KB	-rwxr-xr-x	2024-05-26 18:20
mysqld_safe_helper	4.52 MB	-rwxr-xr-x	2024-05-26 18:41
mysqldump	8.05 MB	-rwxr-xr-x	2024-05-26 18:41
mysqldumpslow	8.19 KB	-rwxr-xr-x	2024-05-26 18:20
mysqlhotcopy	34.65 KB	-rwxr-xr-x	2024-05-26 18:20
mysqlimport	7.92 MB	-rwxr-xr-x	2024-05-26 18:41
mysqlshow	7.92 MB	-rwxr-xr-x	2024-05-26 18:41
mysqlslap	7.94 MB	-rwxr-xr-x	2024-05-26 18:41
mysqltest	8.86 MB	-rwxr-xr-x	2024-05-26 18:41
mytop	71.76 KB	-rwxr-xr-x	2024-05-26 18:20
perror	4.75 MB	-rwxr-xr-x	2024-05-26 18:41
replace	4.53 MB	-rwxr-xr-x	2024-05-26 18:41
resolve_stack_dump	4.55 MB	-rwxr-xr-x	2024-05-26 18:41
resolveip	4.55 MB	-rwxr-xr-x	2024-05-26 18:41
sst_dump	5.74 MB	-rwxr-xr-x	2024-05-26 18:41
wsrep_sst_backup	2.95 KB	-rwxr-xr-x	2024-05-26 18:20
wsrep_sst_common	59.83 KB	-rw-r--r--	2024-05-26 18:20
wsrep_sst_mariabackup	50.97 KB	-rwxr-xr-x	2024-05-26 18:20
wsrep_sst_mysqldump	7.71 KB	-rwxr-xr-x	2024-05-26 18:20
wsrep_sst_rsync	31.62 KB	-rwxr-xr-x	2024-05-26 18:20
wsrep_sst_rsync_wan	31.62 KB	-rwxr-xr-x	2024-05-26 18:20

Rename

#!/usr/bin/perl
# Copyright (c) 2000, 2017, Oracle and/or its affiliates. All rights reserved.
# 
# 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; version 2 of the License.
# 
# 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.
# 
# 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., 51 Franklin St, Fifth Floor, Boston, MA  02110-1335  USA

# Convert given tables in a database to MYISAM

use DBI;
use Getopt::Long;

warn "$0: Deprecated program name. It will be removed in a future release, use 'mariadb-convert-table-format' instead\n"
  if $0 =~ m/mysql_convert_table_format$/;

$opt_help=$opt_version=$opt_verbose=$opt_force=0;
$opt_user=$opt_database=$opt_password=undef;
$opt_host="localhost";
$opt_socket="";
$opt_engine="MYISAM";
$opt_port=0;
$exit_status=0;

GetOptions(
  "e|engine|type=s"       => \$opt_engine,
  "f|force"               => \$opt_force,
  "help|?"               => \$opt_help,
  "h|host=s"              => \$opt_host,
  "p|password=s"          => \$opt_password,
  "u|user=s"              => \$opt_user,
  "v|verbose"             => \$opt_verbose,
  "V|version"             => \$opt_version,
  "S|socket=s"            => \$opt_socket, 
  "P|port=i"              => \$opt_port
) || usage(0);

usage($opt_version) if ($#ARGV < 0 || $opt_help || $opt_version);

$opt_database=shift(@ARGV);

if (grep { /^$opt_engine$/i } qw(HEAP MEMORY BLACKHOLE))
{
  print "Converting to '$opt_engine' would delete your data; aborting\n";
  exit(1);
}

$connect_opt="";
if ($opt_port)
{
  $connect_opt.= ";port=$opt_port";
}
if (length($opt_socket))
{
  $connect_opt.=";mariadb_socket=$opt_socket";
}

$dbh = DBI->connect("DBI:MariaDB:$opt_database:${opt_host}$connect_opt",
		    $opt_user,
		    $opt_password,
		    { PrintError => 0})
  || die "Can't connect to database $opt_database: $DBI::errstr\n";

my @tables;

push(@ARGV, "%") if(!@ARGV);

foreach $pattern (@ARGV)
{
  my ($sth,$row);
  $sth=$dbh->prepare("SHOW TABLES LIKE ?");
  $rv= $sth->execute($pattern);
  if(!int($rv))
  {
    warn "Can't get tables matching '$pattern' from $opt_database; $DBI::errstr\n"; 
    exit(1) unless $opt_force;
  }
  while (($row = $sth->fetchrow_arrayref))
  {
    push(@tables, $row->[0]);
  }
  $sth->finish;
}

print "Converting tables:\n" if ($opt_verbose);
foreach $table (@tables)
{
  my ($sth,$row);

# Check if table is already converted
  $sth=$dbh->prepare("show table status like '$table'");  
  if ($sth->execute && ($row = $sth->fetchrow_arrayref))
  {
    if (uc($row->[1]) eq uc($opt_engine))
    {
      print "$table already uses the '$opt_engine' engine;  Ignored\n";
      next;
    }
  }
  print "converting $table\n" if ($opt_verbose);
  $table=~ s/`/``/g;
  if (!$dbh->do("ALTER TABLE `$table` ENGINE=$opt_engine"))
  {
    print STDERR "Can't convert $table: Error $DBI::errstr\n";
    exit(1) if (!$opt_force);
    $exit_status=1;
  }
}

$dbh->disconnect;
exit($exit_status);

sub usage
{
  my($version)=shift;
  print "$0  version 1.1\n";
  exit(0) if ($version);

print <<EOF;

Conversion of a MariaDB tables to other storage engines

Usage: $0 database [table[ table ...]]
 If no tables has been specifed, all tables in the database will be converted.
 You can also use wildcards, ie "my%"

The following options are available:

-f, --force
  Continue even if there is some error.

-?, --help
  Shows this help

-e, --engine=ENGINE
  Converts tables to the given storage engine (Default: $opt_engine)

-h, --host=HOST
  Host name where the database server is located. (Default: $opt_host)

-p, --password=PASSWORD
  Password for the current user.

-P, --port=PORT
  TCP/IP port to connect to if host is not "localhost".

-S, --socket=SOCKET
  Socket to connect with.

-u, --user=USER
  User name to log into the SQL server.

-v, --verbose
  This is a test specific option that is only used when debugging a test.
  Print more information about what is going on.

-V, --version
  Shows the version of this program.
EOF
  exit(1);
}