OXIESEC PANEL
- Current Dir:
/
/
usr
/
local
/
sbin
Server IP: 82.112.239.19
Upload:
Create Dir:
Name
Size
Modified
Perms
📁
..
-
10/02/2024 09:00:29 PM
rwxr-xr-x
📄
aria_chk
5.51 MB
10/29/2024 04:08:32 PM
rwxr-xr-x
📄
aria_dump_log
5.3 MB
10/29/2024 04:08:32 PM
rwxr-xr-x
📄
aria_ftdump
5.31 MB
10/29/2024 04:08:32 PM
rwxr-xr-x
📄
aria_pack
5.34 MB
10/29/2024 04:08:32 PM
rwxr-xr-x
📄
aria_read_log
5.46 MB
10/29/2024 04:08:32 PM
rwxr-xr-x
📄
galera_new_cluster
921 bytes
10/29/2024 02:56:07 PM
rwxr-xr-x
📄
galera_recovery
3.29 KB
10/29/2024 02:56:07 PM
rwxr-xr-x
📄
innochecksum
4.57 MB
10/29/2024 04:08:32 PM
rwxr-xr-x
📄
mariadb
5.07 MB
10/29/2024 04:02:47 PM
rwxr-xr-x
📄
mariadb-access
109.34 KB
10/29/2024 02:56:06 PM
rwxr-xr-x
📄
mariadb-admin
4.85 MB
10/29/2024 04:02:47 PM
rwxr-xr-x
📄
mariadb-binlog
5.13 MB
10/29/2024 04:02:47 PM
rwxr-xr-x
📄
mariadb-check
4.84 MB
10/29/2024 04:02:47 PM
rwxr-xr-x
📄
mariadb-config
15.79 KB
10/29/2024 04:05:02 PM
rwxr-xr-x
📄
mariadb-conv
4.56 MB
10/29/2024 04:02:47 PM
rwxr-xr-x
📄
mariadb-convert-table-format
4.12 KB
10/29/2024 02:56:06 PM
rwxr-xr-x
📄
mariadb-dump
4.93 MB
10/29/2024 04:02:47 PM
rwxr-xr-x
📄
mariadb-dumpslow
8.05 KB
10/29/2024 02:56:06 PM
rwxr-xr-x
📄
mariadb-embedded
24.19 MB
10/29/2024 04:02:47 PM
rwxr-xr-x
📄
mariadb-find-rows
3.21 KB
10/29/2024 02:56:06 PM
rwxr-xr-x
📄
mariadb-fix-extensions
1.22 KB
10/29/2024 02:56:06 PM
rwxr-xr-x
📄
mariadb-hotcopy
34.52 KB
10/29/2024 02:56:06 PM
rwxr-xr-x
📄
mariadb-import
4.84 MB
10/29/2024 04:02:47 PM
rwxr-xr-x
📄
mariadb-install-db
22.11 KB
10/29/2024 02:56:06 PM
rwxr-xr-x
📄
mariadb-ldb
5.29 MB
10/29/2024 04:33:49 PM
rwxr-xr-x
📄
mariadb-plugin
4.53 MB
10/29/2024 04:02:47 PM
rwxr-xr-x
📄
mariadb-secure-installation
13.49 KB
10/29/2024 02:56:06 PM
rwxr-xr-x
📄
mariadb-service-convert
2.45 KB
10/29/2024 02:32:33 PM
rwxr-xr-x
📄
mariadb-setpermission
17.56 KB
10/29/2024 02:56:06 PM
rwxr-xr-x
📄
mariadb-show
4.83 MB
10/29/2024 04:02:47 PM
rwxr-xr-x
📄
mariadb-slap
4.85 MB
10/29/2024 04:02:47 PM
rwxr-xr-x
📄
mariadb-tzinfo-to-sql
4.53 MB
10/29/2024 04:02:47 PM
rwxr-xr-x
📄
mariadb-upgrade
4.97 MB
10/29/2024 04:08:32 PM
rwxr-xr-x
📄
mariadb-waitpid
4.52 MB
10/29/2024 04:02:47 PM
rwxr-xr-x
📄
mariadb_config
15.79 KB
10/29/2024 04:05:02 PM
rwxr-xr-x
📄
mariadbd
26.23 MB
10/29/2024 04:08:32 PM
rwxr-xr-x
📄
mariadbd-multi
26.71 KB
10/29/2024 02:56:06 PM
rwxr-xr-x
📄
mariadbd-safe
30.43 KB
10/29/2024 02:56:06 PM
rwxr-xr-x
📄
mariadbd-safe-helper
4.5 MB
10/29/2024 04:08:32 PM
rwxr-xr-x
📄
msql2mysql
1.42 KB
10/29/2024 02:56:06 PM
rwxr-xr-x
📄
my_print_defaults
4.53 MB
10/29/2024 04:02:47 PM
rwxr-xr-x
📄
myisam_ftdump
4.86 MB
10/29/2024 04:08:32 PM
rwxr-xr-x
📄
myisamchk
4.98 MB
10/29/2024 04:08:32 PM
rwxr-xr-x
📄
myisamlog
4.84 MB
10/29/2024 04:08:32 PM
rwxr-xr-x
📄
myisampack
4.89 MB
10/29/2024 04:08:32 PM
rwxr-xr-x
📄
myrocks_hotbackup
24.46 KB
10/29/2024 02:55:50 PM
rwxr-xr-x
📄
mysql
5.07 MB
10/29/2024 04:02:47 PM
rwxr-xr-x
📄
mysql_config
4.57 KB
10/29/2024 02:56:06 PM
rwxr-xr-x
📄
mysql_embedded
24.19 MB
10/29/2024 04:02:47 PM
rwxr-xr-x
📄
mysql_find_rows
3.21 KB
10/29/2024 02:56:06 PM
rwxr-xr-x
📄
mysql_fix_extensions
1.22 KB
10/29/2024 02:56:06 PM
rwxr-xr-x
📄
mysql_install_db
22.11 KB
10/29/2024 02:56:06 PM
rwxr-xr-x
📄
mysql_ldb
5.29 MB
10/29/2024 04:33:49 PM
rwxr-xr-x
📄
mysql_plugin
4.53 MB
10/29/2024 04:02:47 PM
rwxr-xr-x
📄
mysql_tzinfo_to_sql
4.53 MB
10/29/2024 04:02:47 PM
rwxr-xr-x
📄
mysql_upgrade
4.97 MB
10/29/2024 04:08:32 PM
rwxr-xr-x
📄
mysql_waitpid
4.52 MB
10/29/2024 04:02:47 PM
rwxr-xr-x
📄
mysqlaccess
109.34 KB
10/29/2024 02:56:06 PM
rwxr-xr-x
📄
mysqladmin
4.85 MB
10/29/2024 04:02:47 PM
rwxr-xr-x
📄
mysqlbinlog
5.13 MB
10/29/2024 04:02:47 PM
rwxr-xr-x
📄
mysqlcheck
4.84 MB
10/29/2024 04:02:47 PM
rwxr-xr-x
📄
mysqld
26.23 MB
10/29/2024 04:08:32 PM
rwxr-xr-x
📄
mysqld_multi
26.71 KB
10/29/2024 02:56:06 PM
rwxr-xr-x
📄
mysqld_safe
30.43 KB
10/29/2024 02:56:06 PM
rwxr-xr-x
📄
mysqld_safe_helper
4.5 MB
10/29/2024 04:08:32 PM
rwxr-xr-x
📄
mysqldump
4.93 MB
10/29/2024 04:02:47 PM
rwxr-xr-x
📄
mysqlimport
4.84 MB
10/29/2024 04:02:47 PM
rwxr-xr-x
📄
mysqlshow
4.83 MB
10/29/2024 04:02:47 PM
rwxr-xr-x
📄
mysqlslap
4.85 MB
10/29/2024 04:02:47 PM
rwxr-xr-x
📄
mytop
71.95 KB
10/29/2024 02:56:06 PM
rwxr-xr-x
📄
perror
4.72 MB
10/29/2024 04:08:32 PM
rwxr-xr-x
📄
rcmysql
0 bytes
01/01/1970 12:00:00 AM
---------
📄
replace
4.5 MB
10/29/2024 04:02:47 PM
rwxr-xr-x
📄
resolve_stack_dump
4.53 MB
10/29/2024 04:08:32 PM
rwxr-xr-x
📄
resolveip
4.52 MB
10/29/2024 04:08:32 PM
rwxr-xr-x
📄
sst_dump
5.3 MB
10/29/2024 04:33:50 PM
rwxr-xr-x
📄
wsrep_sst_backup
2.39 KB
10/29/2024 02:56:07 PM
rwxr-xr-x
📄
wsrep_sst_common
65.72 KB
10/29/2024 02:56:06 PM
rw-r--r--
📄
wsrep_sst_mariabackup
48.1 KB
10/29/2024 02:56:07 PM
rwxr-xr-x
📄
wsrep_sst_mysqldump
8.03 KB
10/29/2024 02:56:07 PM
rwxr-xr-x
📄
wsrep_sst_rsync
29.69 KB
10/29/2024 02:56:07 PM
rwxr-xr-x
📄
wsrep_sst_rsync_wan
29.69 KB
10/29/2024 02:56:07 PM
rwxr-xr-x
Editing: mariadb-convert-table-format
Close
#!/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.=";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); }