Gecko [ 8.222.176.185 ]

Name	Size	Permission
.mad-root	0 B	-rw-rw-rw-
adminer.php	465.43 KB	-rw-rw-rw-
api-ms-win-core-console-l1-1-0...	21.47 KB	-rw-rw-rw-
api-ms-win-core-console-l1-2-0...	21.49 KB	-rw-rw-rw-
api-ms-win-core-datetime-l1-1-...	21.49 KB	-rw-rw-rw-
api-ms-win-core-debug-l1-1-0.d...	21.47 KB	-rw-rw-rw-
api-ms-win-core-errorhandling-...	21.46 KB	-rw-rw-rw-
api-ms-win-core-fibers-l1-1-0....	21.47 KB	-rw-rw-rw-
api-ms-win-core-file-l1-1-0.dl...	25.47 KB	-rw-rw-rw-
api-ms-win-core-file-l1-2-0.dl...	21.46 KB	-rw-rw-rw-
api-ms-win-core-file-l2-1-0.dl...	21.49 KB	-rw-rw-rw-
api-ms-win-core-handle-l1-1-0....	21.46 KB	-rw-rw-rw-
api-ms-win-core-heap-l1-1-0.dl...	21.47 KB	-rw-rw-rw-
api-ms-win-core-interlocked-l1...	21.47 KB	-rw-rw-rw-
api-ms-win-core-libraryloader-...	21.46 KB	-rw-rw-rw-
api-ms-win-core-localization-l...	21.46 KB	-rw-rw-rw-
api-ms-win-core-memory-l1-1-0....	21.49 KB	-rw-rw-rw-
api-ms-win-core-namedpipe-l1-1...	21.49 KB	-rw-rw-rw-
api-ms-win-core-processenviron...	21.48 KB	-rw-rw-rw-
api-ms-win-core-processthreads...	21.47 KB	-rw-rw-rw-
api-ms-win-core-processthreads...	21.49 KB	-rw-rw-rw-
api-ms-win-core-profile-l1-1-0...	21.46 KB	-rw-rw-rw-
api-ms-win-core-rtlsupport-l1-...	21.49 KB	-rw-rw-rw-
api-ms-win-core-string-l1-1-0....	21.46 KB	-rw-rw-rw-
api-ms-win-core-synch-l1-1-0.d...	21.46 KB	-rw-rw-rw-
api-ms-win-core-synch-l1-2-0.d...	21.46 KB	-rw-rw-rw-
api-ms-win-core-sysinfo-l1-1-0...	21.49 KB	-rw-rw-rw-
api-ms-win-core-timezone-l1-1-...	21.47 KB	-rw-rw-rw-
api-ms-win-core-util-l1-1-0.dl...	21.49 KB	-rw-rw-rw-
api-ms-win-crt-conio-l1-1-0.dl...	21.49 KB	-rw-rw-rw-
api-ms-win-crt-convert-l1-1-0....	25.47 KB	-rw-rw-rw-
api-ms-win-crt-environment-l1-...	21.49 KB	-rw-rw-rw-
api-ms-win-crt-filesystem-l1-1...	21.46 KB	-rw-rw-rw-
api-ms-win-crt-heap-l1-1-0.dll	21.46 KB	-rw-rw-rw-
api-ms-win-crt-locale-l1-1-0.d...	21.48 KB	-rw-rw-rw-
api-ms-win-crt-math-l1-1-0.dll	29.49 KB	-rw-rw-rw-
api-ms-win-crt-multibyte-l1-1-...	29.49 KB	-rw-rw-rw-
api-ms-win-crt-private-l1-1-0....	73.47 KB	-rw-rw-rw-
api-ms-win-crt-process-l1-1-0....	21.47 KB	-rw-rw-rw-
api-ms-win-crt-runtime-l1-1-0....	25.46 KB	-rw-rw-rw-
api-ms-win-crt-stdio-l1-1-0.dl...	25.46 KB	-rw-rw-rw-
api-ms-win-crt-string-l1-1-0.d...	25.49 KB	-rw-rw-rw-
api-ms-win-crt-time-l1-1-0.dll	21.47 KB	-rw-rw-rw-
api-ms-win-crt-utility-l1-1-0....	21.49 KB	-rw-rw-rw-
aria_chk.exe	4.29 MB	-rwxrwxrwx
aria_dump_log.exe	3.89 MB	-rwxrwxrwx
aria_ftdump.exe	4.11 MB	-rwxrwxrwx
aria_pack.exe	4.15 MB	-rwxrwxrwx
aria_read_log.exe	4.27 MB	-rwxrwxrwx
concrt140.dll	319.9 KB	-rw-rw-rw-
innochecksum.exe	3.33 MB	-rwxrwxrwx
mariabackup.exe	15 MB	-rwxrwxrwx
mbstream.exe	3.27 MB	-rwxrwxrwx
msvcp140.dll	564.83 KB	-rw-rw-rw-
msvcp140_1.dll	34.87 KB	-rw-rw-rw-
msvcp140_2.dll	260.9 KB	-rw-rw-rw-
msvcp140_atomic_wait.dll	48.9 KB	-rw-rw-rw-
msvcp140_codecvt_ids.dll	30.9 KB	-rw-rw-rw-
my.ini	5.64 KB	-rw-rw-rw-
my_print_defaults.exe	3.26 MB	-rwxrwxrwx
myisam_ftdump.exe	3.44 MB	-rwxrwxrwx
myisamchk.exe	3.57 MB	-rwxrwxrwx
myisamlog.exe	3.45 MB	-rwxrwxrwx
myisampack.exe	3.47 MB	-rwxrwxrwx
myrocks_hotbackup	25.14 KB	-rw-rw-rw-
mysql.exe	3.61 MB	-rwxrwxrwx
mysql_config.pl	8.67 KB	-rw-rw-rw-
mysql_convert_table_format.pl	4.28 KB	-rw-rw-rw-
mysql_install_db.exe	5.32 MB	-rwxrwxrwx
mysql_ldb.exe	3.19 MB	-rwxrwxrwx
mysql_plugin.exe	3.26 MB	-rwxrwxrwx
mysql_tzinfo_to_sql.exe	3.27 MB	-rwxrwxrwx
mysql_upgrade.exe	3.36 MB	-rwxrwxrwx
mysql_upgrade_service.exe	3.25 MB	-rwxrwxrwx
mysql_upgrade_wizard.exe	2.55 MB	-rwxrwxrwx
mysqladmin.exe	3.52 MB	-rwxrwxrwx
mysqlbinlog.exe	3.65 MB	-rwxrwxrwx
mysqlcheck.exe	3.53 MB	-rwxrwxrwx
mysqld.exe	15.89 MB	-rwxrwxrwx
mysqld_multi.pl	27.96 KB	-rw-rw-rw-
mysqldump.exe	3.6 MB	-rwxrwxrwx
mysqldumpslow.pl	8.28 KB	-rw-rw-rw-
mysqlhotcopy.pl	35.28 KB	-rw-rw-rw-
mysqlimport.exe	3.5 MB	-rwxrwxrwx
mysqlshow.exe	3.5 MB	-rwxrwxrwx
mysqlslap.exe	3.52 MB	-rwxrwxrwx
perror.exe	3.38 MB	-rwxrwxrwx
pwnkit	10.99 KB	-rw-rw-rw-
replace.exe	3.24 MB	-rwxrwxrwx
sst_dump.exe	1.41 MB	-rwxrwxrwx
ucrtbase.dll	1.07 MB	-rw-rw-rw-
vcruntime140.dll	106.88 KB	-rw-rw-rw-
vcruntime140_1.dll	43.28 KB	-rw-rw-rw-

Name

Size

Permission

Action

.mad-root

0 B

-rw-rw-rw-

adminer.php

465.43 KB

-rw-rw-rw-

api-ms-win-core-console-l1-1-0...

21.47 KB

-rw-rw-rw-

api-ms-win-core-console-l1-2-0...

21.49 KB

-rw-rw-rw-

api-ms-win-core-datetime-l1-1-...

21.49 KB

-rw-rw-rw-

api-ms-win-core-debug-l1-1-0.d...

21.47 KB

-rw-rw-rw-

api-ms-win-core-errorhandling-...

21.46 KB

-rw-rw-rw-

api-ms-win-core-fibers-l1-1-0....

21.47 KB

-rw-rw-rw-

api-ms-win-core-file-l1-1-0.dl...

25.47 KB

-rw-rw-rw-

api-ms-win-core-file-l1-2-0.dl...

21.46 KB

-rw-rw-rw-

api-ms-win-core-file-l2-1-0.dl...

21.49 KB

-rw-rw-rw-

api-ms-win-core-handle-l1-1-0....

21.46 KB

-rw-rw-rw-

api-ms-win-core-heap-l1-1-0.dl...

21.47 KB

-rw-rw-rw-

api-ms-win-core-interlocked-l1...

21.47 KB

-rw-rw-rw-

api-ms-win-core-libraryloader-...

21.46 KB

-rw-rw-rw-

api-ms-win-core-localization-l...

21.46 KB

-rw-rw-rw-

api-ms-win-core-memory-l1-1-0....

21.49 KB

-rw-rw-rw-

api-ms-win-core-namedpipe-l1-1...

21.49 KB

-rw-rw-rw-

api-ms-win-core-processenviron...

21.48 KB

-rw-rw-rw-

api-ms-win-core-processthreads...

21.47 KB

-rw-rw-rw-

api-ms-win-core-processthreads...

21.49 KB

-rw-rw-rw-

api-ms-win-core-profile-l1-1-0...

21.46 KB

-rw-rw-rw-

api-ms-win-core-rtlsupport-l1-...

21.49 KB

-rw-rw-rw-

api-ms-win-core-string-l1-1-0....

21.46 KB

-rw-rw-rw-

api-ms-win-core-synch-l1-1-0.d...

21.46 KB

-rw-rw-rw-

api-ms-win-core-synch-l1-2-0.d...

21.46 KB

-rw-rw-rw-

api-ms-win-core-sysinfo-l1-1-0...

21.49 KB

-rw-rw-rw-

api-ms-win-core-timezone-l1-1-...

21.47 KB

-rw-rw-rw-

api-ms-win-core-util-l1-1-0.dl...

21.49 KB

-rw-rw-rw-

api-ms-win-crt-conio-l1-1-0.dl...

21.49 KB

-rw-rw-rw-

api-ms-win-crt-convert-l1-1-0....

25.47 KB

-rw-rw-rw-

api-ms-win-crt-environment-l1-...

21.49 KB

-rw-rw-rw-

api-ms-win-crt-filesystem-l1-1...

21.46 KB

-rw-rw-rw-

api-ms-win-crt-heap-l1-1-0.dll

21.46 KB

-rw-rw-rw-

api-ms-win-crt-locale-l1-1-0.d...

21.48 KB

-rw-rw-rw-

api-ms-win-crt-math-l1-1-0.dll

29.49 KB

-rw-rw-rw-

api-ms-win-crt-multibyte-l1-1-...

29.49 KB

-rw-rw-rw-

api-ms-win-crt-private-l1-1-0....

73.47 KB

-rw-rw-rw-

api-ms-win-crt-process-l1-1-0....

21.47 KB

-rw-rw-rw-

api-ms-win-crt-runtime-l1-1-0....

25.46 KB

-rw-rw-rw-

api-ms-win-crt-stdio-l1-1-0.dl...

25.46 KB

-rw-rw-rw-

api-ms-win-crt-string-l1-1-0.d...

25.49 KB

-rw-rw-rw-

api-ms-win-crt-time-l1-1-0.dll

21.47 KB

-rw-rw-rw-

api-ms-win-crt-utility-l1-1-0....

21.49 KB

-rw-rw-rw-

aria_chk.exe

4.29 MB

-rwxrwxrwx

aria_dump_log.exe

3.89 MB

-rwxrwxrwx

aria_ftdump.exe

4.11 MB

-rwxrwxrwx

aria_pack.exe

4.15 MB

-rwxrwxrwx

aria_read_log.exe

4.27 MB

-rwxrwxrwx

concrt140.dll

319.9 KB

-rw-rw-rw-

innochecksum.exe

3.33 MB

-rwxrwxrwx

mariabackup.exe

15 MB

-rwxrwxrwx

mbstream.exe

3.27 MB

-rwxrwxrwx

msvcp140.dll

564.83 KB

-rw-rw-rw-

msvcp140_1.dll

34.87 KB

-rw-rw-rw-

msvcp140_2.dll

260.9 KB

-rw-rw-rw-

msvcp140_atomic_wait.dll

48.9 KB

-rw-rw-rw-

msvcp140_codecvt_ids.dll

30.9 KB

-rw-rw-rw-

my.ini

5.64 KB

-rw-rw-rw-

my_print_defaults.exe

3.26 MB

-rwxrwxrwx

myisam_ftdump.exe

3.44 MB

-rwxrwxrwx

myisamchk.exe

3.57 MB

-rwxrwxrwx

myisamlog.exe

3.45 MB

-rwxrwxrwx

myisampack.exe

3.47 MB

-rwxrwxrwx

myrocks_hotbackup

25.14 KB

-rw-rw-rw-

mysql.exe

3.61 MB

-rwxrwxrwx

mysql_config.pl

8.67 KB

-rw-rw-rw-

mysql_convert_table_format.pl

4.28 KB

-rw-rw-rw-

mysql_install_db.exe

5.32 MB

-rwxrwxrwx

mysql_ldb.exe

3.19 MB

-rwxrwxrwx

mysql_plugin.exe

3.26 MB

-rwxrwxrwx

mysql_tzinfo_to_sql.exe

3.27 MB

-rwxrwxrwx

mysql_upgrade.exe

3.36 MB

-rwxrwxrwx

mysql_upgrade_service.exe

3.25 MB

-rwxrwxrwx

mysql_upgrade_wizard.exe

2.55 MB

-rwxrwxrwx

mysqladmin.exe

3.52 MB

-rwxrwxrwx

mysqlbinlog.exe

3.65 MB

-rwxrwxrwx

mysqlcheck.exe

3.53 MB

-rwxrwxrwx

mysqld.exe

15.89 MB

-rwxrwxrwx

mysqld_multi.pl

27.96 KB

-rw-rw-rw-

mysqldump.exe

3.6 MB

-rwxrwxrwx

mysqldumpslow.pl

8.28 KB

-rw-rw-rw-

mysqlhotcopy.pl

35.28 KB

-rw-rw-rw-

mysqlimport.exe

3.5 MB

-rwxrwxrwx

mysqlshow.exe

3.5 MB

-rwxrwxrwx

mysqlslap.exe

3.52 MB

-rwxrwxrwx

perror.exe

3.38 MB

-rwxrwxrwx

pwnkit

10.99 KB

-rw-rw-rw-

replace.exe

3.24 MB

-rwxrwxrwx

sst_dump.exe

1.41 MB

-rwxrwxrwx

ucrtbase.dll

1.07 MB

-rw-rw-rw-

vcruntime140.dll

106.88 KB

-rw-rw-rw-

vcruntime140_1.dll

43.28 KB

-rw-rw-rw-

Code Editor : mysql_convert_table_format.pl

#!/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;

$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.=";mysql_socket=$opt_socket";
}

$dbh = DBI->connect("DBI:mysql:$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);
}

${this.title}

Code Editor : mysql_convert_table_format.pl