Code: $ cmake . .... .... -- Configuring done -- Generating done -- Build files have been written to: /usr/local/src/mydumper-0.6.1 $ make Scanning dependencies of target mydumper [ 20%] Building C object CMakeFiles/mydumper.dir/mydumper.c.o [ 40%] Building C object CMakeFiles/mydumper.dir/binlog.c.o [ 60%] Building C object CMakeFiles/mydumper.dir/server_detect.c.o [ 80%] Building C object CMakeFiles/mydumper.dir/g_unix_signal.c.o Linking C executable mydumper [ 80%] Built target mydumper Scanning dependencies of target myloader [100%] Building C object CMakeFiles/myloader.dir/myloader.c.o Linking C executable myloader [100%] Built target myloader Code: $ /usr/local/bin/mydumper -bash: /usr/local/bin/mydumper: No such file or directory $ /usr/bin/myloader -bash: /usr/bin/myloader: No such file or directory $ updatedb $ locate myloader /usr/local/src/mydumper-0.6.1/myloader /usr/local/src/mydumper-0.6.1/myloader.c /usr/local/src/mydumper-0.6.1/myloader.h /usr/local/src/mydumper-0.6.1/CMakeFiles/myloader.dir /usr/local/src/mydumper-0.6.1/CMakeFiles/myloader.dir/C.includecache /usr/local/src/mydumper-0.6.1/CMakeFiles/myloader.dir/DependInfo.cmake /usr/local/src/mydumper-0.6.1/CMakeFiles/myloader.dir/build.make /usr/local/src/mydumper-0.6.1/CMakeFiles/myloader.dir/cmake_clean.cmake /usr/local/src/mydumper-0.6.1/CMakeFiles/myloader.dir/depend.internal /usr/local/src/mydumper-0.6.1/CMakeFiles/myloader.dir/depend.make /usr/local/src/mydumper-0.6.1/CMakeFiles/myloader.dir/flags.make /usr/local/src/mydumper-0.6.1/CMakeFiles/myloader.dir/link.txt /usr/local/src/mydumper-0.6.1/CMakeFiles/myloader.dir/myloader.c.o /usr/local/src/mydumper-0.6.1/CMakeFiles/myloader.dir/progress.make /usr/local/src/mydumper-0.6.1/docs/myloader_usage.rst Where is it? Why does it seem that it's not installed?
heh. you got mydumper to install properly on CentOS 6.x ? it has a long standing bug that usually prevents source compiles
The patch also worked for me with the latest version $ wget https://mariadb.atlassian.net/secure/attachment/22219/mydumper-static-libmysql-link.patch $ patch -p0 < mydumper-static-libmysql-link.patch
just tried it and it works just like 0.5.2 # /usr/local/bin/mydumper -V mydumper 0.6.1, built against MySQL 5.5.37-MariaDB
wow indeed it now strangely works ! the mydumper docs if anyone needs them are at http://centminmod.com/mydumper.html Code: patch -p0 < mydumper-static-libmysql-link.patch patching file CMakeLists.txt patching file cmake/modules/FindMySQL.cmake Hunk #1 succeeded at 85 (offset 1 line). cmake . -- The C compiler identification is GNU -- The CXX compiler identification is GNU -- Check for working C compiler: /usr/bin/ccache -- Check for working C compiler: /usr/bin/ccache -- works -- Detecting C compiler ABI info -- Detecting C compiler ABI info - done -- Check for working CXX compiler: /usr/bin/ccache -- Check for working CXX compiler: /usr/bin/ccache -- works -- Detecting CXX compiler ABI info -- Detecting CXX compiler ABI info - done -- Using mysql-config: /usr/bin/mysql_config -- Found MySQL: /usr/include/mysql, /usr/lib64/libmysqlclient_r.a;/usr/lib64/libpthread.so;/usr/lib64/libz.so;/usr/lib64/libm.so;/usr/lib64/librt.so;/usr/lib64/libssl.so;/usr/lib64/libcrypto.so;/usr/lib64/libdl.so -- Found ZLIB: /usr/lib64/libz.so -- checking for one of the modules 'glib-2.0' -- found glib-2.0, version 2.26.1 -- checking for one of the modules 'gthread-2.0' -- found gthread-2.0, version 2.26.1 -- checking for module 'libpcre' -- found libpcre, version 7.8 -- Found PCRE: /usr/include WARNINGUnable to find Sphinx documentation generator -- ------------------------------------------------ -- MYSQL_CONFIG = /usr/bin/mysql_config -- CMAKE_INSTALL_PREFIX = /usr/local -- BUILD_DOCS = ON -- RUN_CPPCHECK = OFF -- Change a values with: cmake -D<Variable>=<Value> -- ------------------------------------------------ -- -- Configuring done -- Generating done -- Build files have been written to: /svr-setup/mydumper-0.6.1 make -j2 Linking C executable myloader Linking C executable mydumper [ 20%] [100%] Built target myloader Built target mydumper make install [ 80%] Built target mydumper [100%] Built target myloader Install the project... -- Install configuration: "" -- Installing: /usr/local/bin/mydumper -- Installing: /usr/local/bin/myloader Code: mydumper --help Usage: mydumper [OPTION...] multi-threaded MySQL dumping Help Options: -?, --help Show help options Application Options: -B, --database Database to dump -T, --tables-list Comma delimited table list to dump (does not exclude regex option) -o, --outputdir Directory to output files to -s, --statement-size Attempted size of INSERT statement in bytes, default 1000000 -r, --rows Try to split tables into chunks of this many rows. This option turns off --chunk-filesize -F, --chunk-filesize Split tables into chunks of this output file size. This value is in MB -c, --compress Compress output files -e, --build-empty-files Build dump files even if no data available from table -x, --regex Regular expression for 'db.table' matching -i, --ignore-engines Comma delimited list of storage engines to ignore -m, --no-schemas Do not dump table schemas with the data -k, --no-locks Do not execute the temporary shared read lock. WARNING: This will cause inconsistent backups --less-locking Minimize locking time on InnoDB tables. -l, --long-query-guard Set long query timer in seconds, default 60 --kill-long-queries Kill long running queries (instead of aborting) -b, --binlogs Get a snapshot of the binary logs as well as dump data -D, --daemon Enable daemon mode -I, --snapshot-interval Interval between each dump snapshot (in minutes), requires --daemon, default 60 -L, --logfile Log file name to use, by default stdout is used --tz-utc SET TIME_ZONE='+00:00' at top of dump to allow dumping of TIMESTAMP data when a server has data in different time zones or data is being moved between servers with different time zones, defaults to on use --skip-tz-utc to disable. --skip-tz-utc --use-savepoints Use savepoints to reduce metadata locking issues, needs SUPER privilege --success-on-1146 Not increment error count and Warning instead of Critical in case of table doesn't exist -h, --host The host to connect to -u, --user Username with privileges to run the dump -p, --password User password -P, --port TCP/IP port to connect to -S, --socket UNIX domain socket file to use for connection -t, --threads Number of threads to use, default 4 -C, --compress-protocol Use compression on the MySQL connection -V, --version Show the program version and exit -v, --verbose Verbosity of output, 0 = silent, 1 = errors, 2 = warnings, 3 = info, default 2 Code: mysqladmin ver mysqladmin Ver 9.0 Distrib 5.5.37-MariaDB, for Linux on x86_64 Copyright (c) 2000, 2014, Oracle, Monty Program Ab and others. Server version 5.5.37-MariaDB Protocol version 10 Connection Localhost via UNIX socket UNIX socket /var/lib/mysql/mysql.sock Uptime: 10 hours 12 min 19 sec Threads: 1 Questions: 1 Slow queries: 0 Opens: 0 Flush tables: 2 Open tables: 26 Queries per second avg: 0.000
just tried it and no go Code: Scanning dependencies of target mydumper [ 20%] Building C object CMakeFiles/mydumper.dir/mydumper.c.o [ 40%] Building C object CMakeFiles/mydumper.dir/binlog.c.o In file included from /usr/local/src/mydumper-0.6.1/binlog.c:27: /usr/include/mysql/sql_common.h:24:18: error: hash.h: No such file or directory In file included from /usr/local/src/mydumper-0.6.1/binlog.c:27: /usr/include/mysql/sql_common.h:45: error: expected specifier-qualifier-list before ‘HASH’ make[2]: *** [CMakeFiles/mydumper.dir/binlog.c.o] Error 1 make[1]: *** [CMakeFiles/mydumper.dir/all] Error 2 make: *** [all] Error 2 + make install [ 20%] Building C object CMakeFiles/mydumper.dir/binlog.c.o In file included from /usr/local/src/mydumper-0.6.1/binlog.c:27: /usr/include/mysql/sql_common.h:24:18: error: hash.h: No such file or directory In file included from /usr/local/src/mydumper-0.6.1/binlog.c:27: /usr/include/mysql/sql_common.h:45: error: expected specifier-qualifier-list before ‘HASH’ make[2]: *** [CMakeFiles/mydumper.dir/binlog.c.o] Error 1 make[1]: *** [CMakeFiles/mydumper.dir/all] Error 2 make: *** [all] Error 2
If myloader is currently not compatible with MariaDB 10, what do you intend to use when you switch to 10? any alternative (except for mysqldump)?
I'm going to try Percona's XtraBackup when I'll have the spare time. They claim really good speed and features. If you'll try this first - don't hesitate to write here
mysqldump and Percona XtraBackup http://www.percona.com/software/percona-xtrabackup the other main alternatives. Percona XtraBackup documentation http://www.percona.com/doc/percona-xtrabackup/2.2/ As of 1.2.3-eva2000.04, I already included Percona YUM repository for such http://centminmod.com/changelog.html#123eva200004
looks like mydumper folks are working on a fix for CentOS 6.3+ compile issue so soon you won't need that patch https://bugs.launchpad.net/mydumper/+bug/1157113 but I believe MariaDB 10 compatibility is still to be done.
how come it says here http://www.mysqlperformanceblog.com...s-several-performance-and-usability-features/ Code: #1267483 Build with MariaDB 10.x maybe it works without the patch?
i think that is because Percona folks test mydumper on Ubuntu/Debian OS and not CentOS which is part of the problem with mydumper compatibility with CentOS + MariaDB 10.x edit: yup Debian https://bugs.launchpad.net/mydumper/+bug/1267483
No love for CentOS By the way George, aside from the original Centminmod being made for CentOS, any reason why you chose it instead of Debian?
As to centos vs debian - more familar with CentOS @dorobo and @Zykov heads up mydumper's trunk dev version 0.6.3 seems to compile fine on CentOS 6.5 with MariaDB 10.0.14 MySQL Data Dumper in Launchpad Finally! Code: cat /etc/redhat-release CentOS release 6.5 (Final) Code: mydumper -V mydumper 0.6.3, built against MySQL 10.0.14-MariaDB myloader -V myloader 0.6.3, built against MySQL 10.0.14-MariaDB mydumper 0.6.3 trunk build Code: cmake . -- The C compiler identification is GNU -- The CXX compiler identification is GNU -- Check for working C compiler: /usr/bin/ccache -- Check for working C compiler: /usr/bin/ccache -- works -- Detecting C compiler ABI info -- Detecting C compiler ABI info - done -- Check for working CXX compiler: /usr/bin/ccache -- Check for working CXX compiler: /usr/bin/ccache -- works -- Detecting CXX compiler ABI info -- Detecting CXX compiler ABI info - done -- Using mysql-config: /usr/bin/mysql_config -- Found MySQL: /usr/include/mysql, /usr/lib64/libmysqlclient_r.so;/usr/lib64/libpthread.so;/usr/lib64/libz.so;/usr/lib64/libm.so;/usr/lib64/librt.so;/usr/lib64/libssl.so;/usr/lib64/libcrypto.so;/usr/lib64/libdl.so -- Found ZLIB: /usr/lib64/libz.so -- checking for one of the modules 'glib-2.0' -- found glib-2.0, version 2.26.1 -- checking for one of the modules 'gthread-2.0' -- found gthread-2.0, version 2.26.1 -- checking for module 'libpcre' -- found libpcre, version 7.8 -- Found PCRE: /usr/include WARNINGUnable to find Sphinx documentation generator -- ------------------------------------------------ -- MYSQL_CONFIG = /usr/bin/mysql_config -- CMAKE_INSTALL_PREFIX = /usr/local -- BUILD_DOCS = ON -- WITH_BINLOG = OFF -- RUN_CPPCHECK = OFF -- Change a values with: cmake -D<Variable>=<Value> -- ------------------------------------------------ -- -- Configuring done -- Generating done -- Build files have been written to: /usr/local/src/mydumper Code: make Scanning dependencies of target mydumper [ 25%] Building C object CMakeFiles/mydumper.dir/mydumper.c.o [ 50%] Building C object CMakeFiles/mydumper.dir/server_detect.c.o [ 75%] Building C object CMakeFiles/mydumper.dir/g_unix_signal.c.o Linking C executable mydumper [ 75%] Built target mydumper Scanning dependencies of target myloader [100%] Building C object CMakeFiles/myloader.dir/myloader.c.o Linking C executable myloader [100%] Built target myloader [root@centos65np mydumper]# make install [ 75%] Built target mydumper [100%] Built target myloader Install the project... -- Install configuration: "" -- Installing: /usr/local/bin/mydumper -- Installing: /usr/local/bin/myloader Code: ln -s /usr/local/bin/mydumper /usr/bin/mydumper ln -s /usr/local/bin/myloader /usr/bin/myloader Code: mydumper --help Usage: mydumper [OPTION...] multi-threaded MySQL dumping Help Options: -?, --help Show help options Application Options: -B, --database Database to dump -T, --tables-list Comma delimited table list to dump (does not exclude regex option) -o, --outputdir Directory to output files to -s, --statement-size Attempted size of INSERT statement in bytes, default 1000000 -r, --rows Try to split tables into chunks of this many rows. This option turns off --chunk-filesize -F, --chunk-filesize Split tables into chunks of this output file size. This value is in MB -c, --compress Compress output files -e, --build-empty-files Build dump files even if no data available from table -x, --regex Regular expression for 'db.table' matching -i, --ignore-engines Comma delimited list of storage engines to ignore -m, --no-schemas Do not dump table schemas with the data -k, --no-locks Do not execute the temporary shared read lock. WARNING: This will cause inconsistent backups --less-locking Minimize locking time on InnoDB tables. -l, --long-query-guard Set long query timer in seconds, default 60 -K, --kill-long-queries Kill long running queries (instead of aborting) -D, --daemon Enable daemon mode -I, --snapshot-interval Interval between each dump snapshot (in minutes), requires --daemon, default 60 -L, --logfile Log file name to use, by default stdout is used --tz-utc SET TIME_ZONE='+00:00' at top of dump to allow dumping of TIMESTAMP data when a server has data in different time zones or data is being moved between servers with different time zones, defaults to on use --skip-tz-utc to disable. --skip-tz-utc --use-savepoints Use savepoints to reduce metadata locking issues, needs SUPER privilege --success-on-1146 Not increment error count and Warning instead of Critical in case of table doesn't exist --lock-all-tables Use LOCK TABLE for all, instead of FTWRL -U, --updated-since Use Update_time to dump only tables updated in the last U days -h, --host The host to connect to -u, --user Username with privileges to run the dump -p, --password User password -P, --port TCP/IP port to connect to -S, --socket UNIX domain socket file to use for connection -t, --threads Number of threads to use, default 4 -C, --compress-protocol Use compression on the MySQL connection -V, --version Show the program version and exit -v, --verbose Verbosity of output, 0 = silent, 1 = errors, 2 = warnings, 3 = info, default 2 Code: myloader --help Usage: myloader [OPTION...] multi-threaded MySQL loader Help Options: -?, --help Show help options Application Options: -d, --directory Directory of the dump to import -q, --queries-per-transaction Number of queries per transaction, default 1000 -o, --overwrite-tables Drop tables if they already exist -B, --database An alternative database to restore into -e, --enable-binlog Enable binary logging of the restore data -h, --host The host to connect to -u, --user Username with privileges to run the dump -p, --password User password -P, --port TCP/IP port to connect to -S, --socket UNIX domain socket file to use for connection -t, --threads Number of threads to use, default 4 -C, --compress-protocol Use compression on the MySQL connection -V, --version Show the program version and exit -v, --verbose Verbosity of output, 0 = silent, 1 = errors, 2 = warnings, 3 = info, default 2 my mydumper documentation at Mydumper & Myloader Documentation MySQL backup benchmarks 2GB Linode 2 cpu thread quick test to backup staging server's mysql database which is 116.84MB in siz and MariaDB 5.5.40 server mysqldump vs mydumper multi-threaded mysqldump backup time = 2.24 seconds or 116.84/2.24s = 52.16MB/s backup speed mydumper backup time = 0.49 seconds or 116.84/0.49 = 238.45MB/s backup speed = 4.57x times faster Code: ------------------------------ XENFORODB Index Size = 12.46 MB ------------------------------ XENFORODB Data Size = 104.38 MB ------------------------------ Total XENFORODB dtabase size = 116.84 MB Code: mysqldump XENFORODB > mysqldump.sql real: 2.24s cpu: 44% maxmem: 25600 KB cswaits: 6124 Code: ls -lah total 55M drwxr-xr-x 2 root root 4.0K Oct 23 07:56 . drwxr-xr-x 11 root root 4.0K Oct 23 07:49 .. -rw-r--r-- 1 root root 55M Oct 23 07:56 mysqldump.sql Code: mydumper -B XENFORODB real: 0.49s cpu: 84% maxmem: 62224 KB cswaits: 1210 Spoiler: mydumper sql backup listing Code: ls -lah export-20141023-080052/ total 56M drwx------ 2 root root 20K Oct 23 08:00 . drwxr-xr-x 3 root root 4.0K Oct 23 08:00 .. -rw-r--r-- 1 root root 75 Oct 23 08:00 metadata -rw-r--r-- 1 root root 361 Oct 23 08:00 XENFORODB.cta_ft_featured_threads_dismissed-schema.sql -rw-r--r-- 1 root root 627 Oct 23 08:00 XENFORODB.cta_ft_featured_threads-schema.sql -rw-r--r-- 1 root root 11K Oct 23 08:00 XENFORODB.cta_ft_featured_threads.sql -rw-r--r-- 1 root root 497 Oct 23 08:00 XENFORODB.dp_spy-schema.sql -rw-r--r-- 1 root root 592 Oct 23 08:00 XENFORODB.dp_spy.sql -rw-r--r-- 1 root root 939 Oct 23 08:00 XENFORODB.nat_options-schema.sql -rw-r--r-- 1 root root 1.5K Oct 23 08:00 XENFORODB.nat_options.sql -rw-r--r-- 1 root root 840 Oct 23 08:00 XENFORODB.xf_addon-schema.sql -rw-r--r-- 1 root root 12K Oct 23 08:00 XENFORODB.xf_addon.sql -rw-r--r-- 1 root root 543 Oct 23 08:00 XENFORODB.xf_admin_log-schema.sql -rw-r--r-- 1 root root 23K Oct 23 08:00 XENFORODB.xf_admin_log.sql -rw-r--r-- 1 root root 676 Oct 23 08:00 XENFORODB.xf_admin_navigation-schema.sql -rw-r--r-- 1 root root 12K Oct 23 08:00 XENFORODB.xf_admin_navigation.sql -rw-r--r-- 1 root root 274 Oct 23 08:00 XENFORODB.xf_admin_permission_entry-schema.sql -rw-r--r-- 1 root root 528 Oct 23 08:00 XENFORODB.xf_admin_permission_entry.sql -rw-r--r-- 1 root root 374 Oct 23 08:00 XENFORODB.xf_admin_permission-schema.sql -rw-r--r-- 1 root root 981 Oct 23 08:00 XENFORODB.xf_admin_permission.sql -rw-r--r-- 1 root root 333 Oct 23 08:00 XENFORODB.xf_admin-schema.sql -rw-r--r-- 1 root root 298 Oct 23 08:00 XENFORODB.xf_admin_search_type-schema.sql -rw-r--r-- 1 root root 1.2K Oct 23 08:00 XENFORODB.xf_admin_search_type.sql -rw-r--r-- 1 root root 659 Oct 23 08:00 XENFORODB.xf_admin.sql -rw-r--r-- 1 root root 364 Oct 23 08:00 XENFORODB.xf_admin_template_compiled-schema.sql -rw-r--r-- 1 root root 2.3M Oct 23 08:00 XENFORODB.xf_admin_template_compiled.sql -rw-r--r-- 1 root root 300 Oct 23 08:00 XENFORODB.xf_admin_template_include-schema.sql -rw-r--r-- 1 root root 3.7K Oct 23 08:00 XENFORODB.xf_admin_template_include.sql -rw-r--r-- 1 root root 428 Oct 23 08:00 XENFORODB.xf_admin_template_modification_log-schema.sql -rw-r--r-- 1 root root 768 Oct 23 08:00 XENFORODB.xf_admin_template_modification_log.sql -rw-r--r-- 1 root root 739 Oct 23 08:00 XENFORODB.xf_admin_template_modification-schema.sql -rw-r--r-- 1 root root 33K Oct 23 08:00 XENFORODB.xf_admin_template_modification.sql -rw-r--r-- 1 root root 316 Oct 23 08:00 XENFORODB.xf_admin_template_phrase-schema.sql -rw-r--r-- 1 root root 165K Oct 23 08:00 XENFORODB.xf_admin_template_phrase.sql -rw-r--r-- 1 root root 486 Oct 23 08:00 XENFORODB.xf_admin_template-schema.sql -rw-r--r-- 1 root root 4.4M Oct 23 08:00 XENFORODB.xf_admin_template.sql -rw-r--r-- 1 root root 938 Oct 23 08:00 XENFORODB.xf_attachment_data-schema.sql -rw-r--r-- 1 root root 109K Oct 23 08:00 XENFORODB.xf_attachment_data.sql -rw-r--r-- 1 root root 758 Oct 23 08:00 XENFORODB.xf_attachment-schema.sql -rw-r--r-- 1 root root 19K Oct 23 08:00 XENFORODB.xf_attachment.sql -rw-r--r-- 1 root root 226 Oct 23 08:00 XENFORODB.xf_attachment_view-schema.sql -rw-r--r-- 1 root root 206 Oct 23 08:00 XENFORODB.xf_ban_email-schema.sql -rw-r--r-- 1 root root 960 Oct 23 08:00 XENFORODB.xf_bb_code_media_site-schema.sql -rw-r--r-- 1 root root 2.0K Oct 23 08:00 XENFORODB.xf_bb_code_media_site.sql -rw-r--r-- 1 root root 633 Oct 23 08:00 XENFORODB.xf_bb_code_parse_cache-schema.sql -rw-r--r-- 1 root root 3.6M Oct 23 08:00 XENFORODB.xf_bb_code_parse_cache.sql -rw-r--r-- 1 root root 1.2K Oct 23 08:00 XENFORODB.xf_bb_code-schema.sql -rw-r--r-- 1 root root 655 Oct 23 08:00 XENFORODB.xf_bb_code.sql -rw-r--r-- 1 root root 267 Oct 23 08:00 XENFORODB.xf_bdattachmentstore_delay-schema.sql -rw-r--r-- 1 root root 364 Oct 23 08:00 XENFORODB.xf_bdpushover_push_queue-schema.sql -rw-r--r-- 1 root root 411 Oct 23 08:00 XENFORODB.xf_calendar-schema.sql -rw-r--r-- 1 root root 175 Oct 23 08:00 XENFORODB.xf_calendar.sql -rw-r--r-- 1 root root 356 Oct 23 08:00 XENFORODB.xf_captcha_log-schema.sql -rw-r--r-- 1 root root 445 Oct 23 08:00 XENFORODB.xf_captcha_question-schema.sql -rw-r--r-- 1 root root 693 Oct 23 08:00 XENFORODB.xf_code_event_listener-schema.sql -rw-r--r-- 1 root root 56K Oct 23 08:00 XENFORODB.xf_code_event_listener.sql -rw-r--r-- 1 root root 279 Oct 23 08:00 XENFORODB.xf_code_event-schema.sql -rw-r--r-- 1 root root 31K Oct 23 08:00 XENFORODB.xf_code_event.sql -rw-r--r-- 1 root root 486 Oct 23 08:00 XENFORODB.xf_content_spam_cache-schema.sql -rw-r--r-- 1 root root 341 Oct 23 08:00 XENFORODB.xf_content_type_field-schema.sql -rw-r--r-- 1 root root 6.3K Oct 23 08:00 XENFORODB.xf_content_type_field.sql -rw-r--r-- 1 root root 290 Oct 23 08:00 XENFORODB.xf_content_type-schema.sql -rw-r--r-- 1 root root 7.0K Oct 23 08:00 XENFORODB.xf_content_type.sql -rw-r--r-- 1 root root 954 Oct 23 08:00 XENFORODB.xf_conversation_master-schema.sql -rw-r--r-- 1 root root 28K Oct 23 08:00 XENFORODB.xf_conversation_master.sql -rw-r--r-- 1 root root 699 Oct 23 08:00 XENFORODB.xf_conversation_message-schema.sql -rw-r--r-- 1 root root 273K Oct 23 08:00 XENFORODB.xf_conversation_message.sql -rw-r--r-- 1 root root 426 Oct 23 08:00 XENFORODB.xf_conversation_recipient-schema.sql -rw-r--r-- 1 root root 8.8K Oct 23 08:00 XENFORODB.xf_conversation_recipient.sql -rw-r--r-- 1 root root 846 Oct 23 08:00 XENFORODB.xf_conversation_user-schema.sql -rw-r--r-- 1 root root 14K Oct 23 08:00 XENFORODB.xf_conversation_user.sql -rw-r--r-- 1 root root 475 Oct 23 08:00 XENFORODB.xf_cron_entry-schema.sql -rw-r--r-- 1 root root 6.7K Oct 23 08:00 XENFORODB.xf_cron_entry.sql -rw-r--r-- 1 root root 239 Oct 23 08:00 XENFORODB.xf_data_registry-schema.sql -rw-r--r-- 1 root root 4.0M Oct 23 08:00 XENFORODB.xf_data_registry.sql -rw-r--r-- 1 root root 583 Oct 23 08:00 XENFORODB.xf_deferred-schema.sql -rw-r--r-- 1 root root 180 Oct 23 08:00 XENFORODB.xf_deferred.sql -rw-r--r-- 1 root root 483 Oct 23 08:00 XENFORODB.xf_deletion_log-schema.sql -rw-r--r-- 1 root root 1.7K Oct 23 08:00 XENFORODB.xf_deletion_log.sql -rw-r--r-- 1 root root 494 Oct 23 08:00 XENFORODB.xf_draft-schema.sql -rw-r--r-- 1 root root 553 Oct 23 08:00 XENFORODB.xf_edit_history-schema.sql -rw-r--r-- 1 root root 65K Oct 23 08:00 XENFORODB.xf_edit_history.sql -rw-r--r-- 1 root root 371 Oct 23 08:00 XENFORODB.xf_email_template_compiled-schema.sql -rw-r--r-- 1 root root 273K Oct 23 08:00 XENFORODB.xf_email_template_compiled.sql -rw-r--r-- 1 root root 428 Oct 23 08:00 XENFORODB.xf_email_template_modification_log-schema.sql -rw-r--r-- 1 root root 762 Oct 23 08:00 XENFORODB.xf_email_template_modification-schema.sql -rw-r--r-- 1 root root 301 Oct 23 08:00 XENFORODB.xf_email_template_phrase-schema.sql -rw-r--r-- 1 root root 13K Oct 23 08:00 XENFORODB.xf_email_template_phrase.sql -rw-r--r-- 1 root root 815 Oct 23 08:00 XENFORODB.xf_email_template-schema.sql -rw-r--r-- 1 root root 368K Oct 23 08:00 XENFORODB.xf_email_template.sql -rw-r--r-- 1 root root 616 Oct 23 08:00 XENFORODB.xf_error_log-schema.sql -rw-r--r-- 1 root root 589 Oct 23 08:00 XENFORODB.xf_es_search_failed-schema.sql -rw-r--r-- 1 root root 391 Oct 23 08:00 XENFORODB.xf_faq_category-schema.sql -rw-r--r-- 1 root root 402 Oct 23 08:00 XENFORODB.xf_faq_category.sql -rw-r--r-- 1 root root 935 Oct 23 08:00 XENFORODB.xf_faq_question-schema.sql -rw-r--r-- 1 root root 3.7K Oct 23 08:00 XENFORODB.xf_faq_question.sql -rw-r--r-- 1 root root 348 Oct 23 08:00 XENFORODB.xf_feed_log-schema.sql -rw-r--r-- 1 root root 82K Oct 23 08:00 XENFORODB.xf_feed_log.sql -rw-r--r-- 1 root root 909 Oct 23 08:00 XENFORODB.xf_feed-schema.sql -rw-r--r-- 1 root root 2.2K Oct 23 08:00 XENFORODB.xf_feed.sql -rw-r--r-- 1 root root 333 Oct 23 08:00 XENFORODB.xf_flood_check-schema.sql -rw-r--r-- 1 root root 289 Oct 23 08:00 XENFORODB.xf_forum_prefix-schema.sql -rw-r--r-- 1 root root 713 Oct 23 08:00 XENFORODB.xf_forum_prefix.sql -rw-r--r-- 1 root root 502 Oct 23 08:00 XENFORODB.xf_forum_read-schema.sql -rw-r--r-- 1 root root 881 Oct 23 08:00 XENFORODB.xf_forum_read.sql -rw-r--r-- 1 root root 1.9K Oct 23 08:00 XENFORODB.xf_forum-schema.sql -rw-r--r-- 1 root root 6.0K Oct 23 08:00 XENFORODB.xf_forum.sql -rw-r--r-- 1 root root 444 Oct 23 08:00 XENFORODB.xf_forum_watch-schema.sql -rw-r--r-- 1 root root 159 Oct 23 08:00 XENFORODB.xf_forum_watch.sql -rw-r--r-- 1 root root 1012 Oct 23 08:00 XENFORODB.xf_image_proxy-schema.sql -rw-r--r-- 1 root root 287 Oct 23 08:00 XENFORODB.xf_import_log-schema.sql -rw-r--r-- 1 root root 444 Oct 23 08:00 XENFORODB.xf_install_upgrade_login-schema.sql -rw-r--r-- 1 root root 418 Oct 23 08:00 XENFORODB.xf_ip_match-schema.sql -rw-r--r-- 1 root root 645 Oct 23 08:00 XENFORODB.xf_ip-schema.sql -rw-r--r-- 1 root root 441K Oct 23 08:00 XENFORODB.xf_ip.sql -rw-r--r-- 1 root root 495 Oct 23 08:00 XENFORODB.xf_keywordalert_keyword-schema.sql -rw-r--r-- 1 root root 338 Oct 23 08:00 XENFORODB.xf_keywordalert_queue-schema.sql -rw-r--r-- 1 root root 663 Oct 23 08:00 XENFORODB.xf_language-schema.sql -rw-r--r-- 1 root root 12K Oct 23 08:00 XENFORODB.xf_language.sql -rw-r--r-- 1 root root 724 Oct 23 08:00 XENFORODB.xf_liked_content-schema.sql -rw-r--r-- 1 root root 51K Oct 23 08:00 XENFORODB.xf_liked_content.sql -rw-r--r-- 1 root root 295 Oct 23 08:00 XENFORODB.xf_link_forum-schema.sql -rw-r--r-- 1 root root 239 Oct 23 08:00 XENFORODB.xf_link_forum.sql -rw-r--r-- 1 root root 534 Oct 23 08:00 XENFORODB.xf_link_proxy-schema.sql -rw-r--r-- 1 root root 438 Oct 23 08:00 XENFORODB.xf_login_attempt-schema.sql -rw-r--r-- 1 root root 340 Oct 23 08:00 XENFORODB.xf_mail_queue-schema.sql -rw-r--r-- 1 root root 364 Oct 23 08:00 XENFORODB.xf_moderation_queue-schema.sql -rw-r--r-- 1 root root 503 Oct 23 08:00 XENFORODB.xf_moderator_content-schema.sql -rw-r--r-- 1 root root 1.1K Oct 23 08:00 XENFORODB.xf_moderator_log-schema.sql -rw-r--r-- 1 root root 67K Oct 23 08:00 XENFORODB.xf_moderator_log.sql -rw-r--r-- 1 root root 350 Oct 23 08:00 XENFORODB.xf_moderator-schema.sql -rw-r--r-- 1 root root 2.3K Oct 23 08:00 XENFORODB.xf_moderator.sql -rw-r--r-- 1 root root 220 Oct 23 08:00 XENFORODB.xf_multiview-schema.sql -rw-r--r-- 1 root root 355 Oct 23 08:00 XENFORODB.xf_multiview.sql -rw-r--r-- 1 root root 855 Oct 23 08:00 XENFORODB.xf_news_feed-schema.sql -rw-r--r-- 1 root root 1.4K Oct 23 08:00 XENFORODB.xf_news_feed.sql -rw-r--r-- 1 root root 327 Oct 23 08:00 XENFORODB.xf_news-schema.sql -rw-r--r-- 1 root root 251 Oct 23 08:00 XENFORODB.xf_node_ignore-schema.sql -rw-r--r-- 1 root root 1.6K Oct 23 08:00 XENFORODB.xf_node-schema.sql -rw-r--r-- 1 root root 12K Oct 23 08:00 XENFORODB.xf_node.sql -rw-r--r-- 1 root root 601 Oct 23 08:00 XENFORODB.xf_node_type-schema.sql -rw-r--r-- 1 root root 849 Oct 23 08:00 XENFORODB.xf_node_type.sql -rw-r--r-- 1 root root 345 Oct 23 08:00 XENFORODB.xf_notice_dismissed-schema.sql -rw-r--r-- 1 root root 577 Oct 23 08:00 XENFORODB.xf_notice_dismissed.sql -rw-r--r-- 1 root root 694 Oct 23 08:00 XENFORODB.xf_notice-schema.sql -rw-r--r-- 1 root root 1.3K Oct 23 08:00 XENFORODB.xf_notice.sql -rw-r--r-- 1 root root 367 Oct 23 08:00 XENFORODB.xf_option_group_relation-schema.sql -rw-r--r-- 1 root root 27K Oct 23 08:00 XENFORODB.xf_option_group_relation.sql -rw-r--r-- 1 root root 381 Oct 23 08:00 XENFORODB.xf_option_group-schema.sql -rw-r--r-- 1 root root 3.2K Oct 23 08:00 XENFORODB.xf_option_group.sql -rw-r--r-- 1 root root 795 Oct 23 08:00 XENFORODB.xf_option-schema.sql -rw-r--r-- 1 root root 149K Oct 23 08:00 XENFORODB.xf_option.sql -rw-r--r-- 1 root root 667 Oct 23 08:00 XENFORODB.xf_page-schema.sql -rw-r--r-- 1 root root 537 Oct 23 08:00 XENFORODB.xf_page.sql -rw-r--r-- 1 root root 399 Oct 23 08:00 XENFORODB.xf_permission_cache_content-schema.sql -rw-r--r-- 1 root root 445K Oct 23 08:00 XENFORODB.xf_permission_cache_content.sql -rw-r--r-- 1 root root 428 Oct 23 08:00 XENFORODB.xf_permission_combination-schema.sql -rw-r--r-- 1 root root 46K Oct 23 08:00 XENFORODB.xf_permission_combination.sql -rw-r--r-- 1 root root 386 Oct 23 08:00 XENFORODB.xf_permission_combination_user_group-schema.sql -rw-r--r-- 1 root root 315 Oct 23 08:00 XENFORODB.xf_permission_combination_user_group.sql -rw-r--r-- 1 root root 852 Oct 23 08:00 XENFORODB.xf_permission_entry_content-schema.sql -rw-r--r-- 1 root root 4.2K Oct 23 08:00 XENFORODB.xf_permission_entry_content.sql -rw-r--r-- 1 root root 652 Oct 23 08:00 XENFORODB.xf_permission_entry-schema.sql -rw-r--r-- 1 root root 17K Oct 23 08:00 XENFORODB.xf_permission_entry.sql -rw-r--r-- 1 root root 276 Oct 23 08:00 XENFORODB.xf_permission_group-schema.sql -rw-r--r-- 1 root root 690 Oct 23 08:00 XENFORODB.xf_permission_group.sql -rw-r--r-- 1 root root 370 Oct 23 08:00 XENFORODB.xf_permission_interface_group-schema.sql -rw-r--r-- 1 root root 1.2K Oct 23 08:00 XENFORODB.xf_permission_interface_group.sql -rw-r--r-- 1 root root 660 Oct 23 08:00 XENFORODB.xf_permission-schema.sql -rw-r--r-- 1 root root 15K Oct 23 08:00 XENFORODB.xf_permission.sql -rw-r--r-- 1 root root 294 Oct 23 08:00 XENFORODB.xf_phrase_compiled-schema.sql -rw-r--r-- 1 root root 1.3M Oct 23 08:00 XENFORODB.xf_phrase_compiled.sql -rw-r--r-- 1 root root 459 Oct 23 08:00 XENFORODB.xf_phrase_map-schema.sql -rw-r--r-- 1 root root 760K Oct 23 08:00 XENFORODB.xf_phrase_map.sql -rw-r--r-- 1 root root 676 Oct 23 08:00 XENFORODB.xf_phrase-schema.sql -rw-r--r-- 1 root root 961K Oct 23 08:00 XENFORODB.xf_phrase.sql -rw-r--r-- 1 root root 485 Oct 23 08:00 XENFORODB.xf_poll_response-schema.sql -rw-r--r-- 1 root root 3.9K Oct 23 08:00 XENFORODB.xf_poll_response.sql -rw-r--r-- 1 root root 674 Oct 23 08:00 XENFORODB.xf_poll-schema.sql -rw-r--r-- 1 root root 5.5K Oct 23 08:00 XENFORODB.xf_poll.sql -rw-r--r-- 1 root root 435 Oct 23 08:00 XENFORODB.xf_poll_vote-schema.sql -rw-r--r-- 1 root root 1.2K Oct 23 08:00 XENFORODB.xf_poll_vote.sql -rw-r--r-- 1 root root 1.3K Oct 23 08:00 XENFORODB.xf_post-schema.sql -rw-r--r-- 1 root root 4.1M Oct 23 08:00 XENFORODB.xf_post.sql -rw-r--r-- 1 root root 664 Oct 23 08:00 XENFORODB.xf_profile_post_comment-schema.sql -rw-r--r-- 1 root root 1.2K Oct 23 08:00 XENFORODB.xf_profile_post_comment.sql -rw-r--r-- 1 root root 1.2K Oct 23 08:00 XENFORODB.xf_profile_post-schema.sql -rw-r--r-- 1 root root 1.9K Oct 23 08:00 XENFORODB.xf_profile_post.sql -rw-r--r-- 1 root root 339 Oct 23 08:00 XENFORODB.xf_registration_spam_cache-schema.sql -rw-r--r-- 1 root root 674 Oct 23 08:00 XENFORODB.xf_report_comment-schema.sql -rw-r--r-- 1 root root 252 Oct 23 08:00 XENFORODB.xf_report_comment.sql -rw-r--r-- 1 root root 1.2K Oct 23 08:00 XENFORODB.xf_report-schema.sql -rw-r--r-- 1 root root 467 Oct 23 08:00 XENFORODB.xf_report.sql -rw-r--r-- 1 root root 327 Oct 23 08:00 XENFORODB.xf_resource_category_prefix-schema.sql -rw-r--r-- 1 root root 1.8K Oct 23 08:00 XENFORODB.xf_resource_category-schema.sql -rw-r--r-- 1 root root 1.3K Oct 23 08:00 XENFORODB.xf_resource_category.sql -rw-r--r-- 1 root root 547 Oct 23 08:00 XENFORODB.xf_resource_category_watch-schema.sql -rw-r--r-- 1 root root 561 Oct 23 08:00 XENFORODB.xf_resource_download-schema.sql -rw-r--r-- 1 root root 282 Oct 23 08:00 XENFORODB.xf_resource_download.sql -rw-r--r-- 1 root root 298 Oct 23 08:00 XENFORODB.xf_resource_feature-schema.sql -rw-r--r-- 1 root root 334 Oct 23 08:00 XENFORODB.xf_resource_field_category-schema.sql -rw-r--r-- 1 root root 837 Oct 23 08:00 XENFORODB.xf_resource_field-schema.sql -rw-r--r-- 1 root root 335 Oct 23 08:00 XENFORODB.xf_resource_field_value-schema.sql -rw-r--r-- 1 root root 288 Oct 23 08:00 XENFORODB.xf_resource_prefix_group-schema.sql -rw-r--r-- 1 root root 597 Oct 23 08:00 XENFORODB.xf_resource_prefix-schema.sql -rw-r--r-- 1 root root 1.2K Oct 23 08:00 XENFORODB.xf_resource_rating-schema.sql -rw-r--r-- 1 root root 2.3K Oct 23 08:00 XENFORODB.xf_resource-schema.sql -rw-r--r-- 1 root root 617 Oct 23 08:00 XENFORODB.xf_resource.sql -rw-r--r-- 1 root root 1008 Oct 23 08:00 XENFORODB.xf_resource_update-schema.sql -rw-r--r-- 1 root root 23K Oct 23 08:00 XENFORODB.xf_resource_update.sql -rw-r--r-- 1 root root 873 Oct 23 08:00 XENFORODB.xf_resource_version-schema.sql -rw-r--r-- 1 root root 239 Oct 23 08:00 XENFORODB.xf_resource_version.sql -rw-r--r-- 1 root root 442 Oct 23 08:00 XENFORODB.xf_resource_watch-schema.sql -rw-r--r-- 1 root root 343 Oct 23 08:00 XENFORODB.xf_resource_watch.sql -rw-r--r-- 1 root root 558 Oct 23 08:00 XENFORODB.xf_rotating_ads_item-schema.sql -rw-r--r-- 1 root root 7.4K Oct 23 08:00 XENFORODB.xf_rotating_ads_item.sql -rw-r--r-- 1 root root 554 Oct 23 08:00 XENFORODB.xf_route_filter-schema.sql -rw-r--r-- 1 root root 432 Oct 23 08:00 XENFORODB.xf_route_prefix-schema.sql -rw-r--r-- 1 root root 12K Oct 23 08:00 XENFORODB.xf_route_prefix.sql -rw-r--r-- 1 root root 700 Oct 23 08:00 XENFORODB.xf_search_index-schema.sql -rw-r--r-- 1 root root 334K Oct 23 08:00 XENFORODB.xf_search_index.sql -rw-r--r-- 1 root root 848 Oct 23 08:00 XENFORODB.xf_search-schema.sql -rw-r--r-- 1 root root 609 Oct 23 08:00 XENFORODB.xf_session_activity-schema.sql -rw-r--r-- 1 root root 560 Oct 23 08:00 XENFORODB.xf_session_activity.sql -rw-r--r-- 1 root root 325 Oct 23 08:00 XENFORODB.xf_session_admin-schema.sql -rw-r--r-- 1 root root 319 Oct 23 08:00 XENFORODB.xf_session-schema.sql -rw-r--r-- 1 root root 305 Oct 23 08:00 XENFORODB.xf_smilie_category-schema.sql -rw-r--r-- 1 root root 149 Oct 23 08:00 XENFORODB.xf_smilie_category.sql -rw-r--r-- 1 root root 650 Oct 23 08:00 XENFORODB.xf_smilie-schema.sql -rw-r--r-- 1 root root 22K Oct 23 08:00 XENFORODB.xf_smilie.sql -rw-r--r-- 1 root root 734 Oct 23 08:00 XENFORODB.xf_spam_cleaner_log-schema.sql -rw-r--r-- 1 root root 392 Oct 23 08:00 XENFORODB.xf_spam_cleaner_log.sql -rw-r--r-- 1 root root 638 Oct 23 08:00 XENFORODB.xf_spam_trigger_log-schema.sql -rw-r--r-- 1 root root 265 Oct 23 08:00 XENFORODB.xf_statistics-schema.sql -rw-r--r-- 1 root root 292 Oct 23 08:00 XENFORODB.xf_statistics.sql -rw-r--r-- 1 root root 299 Oct 23 08:00 XENFORODB.xf_stats_daily-schema.sql -rw-r--r-- 1 root root 26K Oct 23 08:00 XENFORODB.xf_stats_daily.sql -rw-r--r-- 1 root root 1.1K Oct 23 08:00 XENFORODB.xf_style_property_definition-schema.sql -rw-r--r-- 1 root root 150K Oct 23 08:00 XENFORODB.xf_style_property_definition.sql -rw-r--r-- 1 root root 574 Oct 23 08:00 XENFORODB.xf_style_property_group-schema.sql -rw-r--r-- 1 root root 5.0K Oct 23 08:00 XENFORODB.xf_style_property_group.sql -rw-r--r-- 1 root root 450 Oct 23 08:00 XENFORODB.xf_style_property-schema.sql -rw-r--r-- 1 root root 217K Oct 23 08:00 XENFORODB.xf_style_property.sql -rw-r--r-- 1 root root 774 Oct 23 08:00 XENFORODB.xf_style-schema.sql -rw-r--r-- 1 root root 258K Oct 23 08:00 XENFORODB.xf_style.sql -rw-r--r-- 1 root root 550 Oct 23 08:00 XENFORODB.xf_tapatalk_users-schema.sql -rw-r--r-- 1 root root 339 Oct 23 08:00 XENFORODB.xf_tapatalk_users.sql -rw-r--r-- 1 root root 409 Oct 23 08:00 XENFORODB.xf_template_compiled-schema.sql -rw-r--r-- 1 root root 19M Oct 23 08:00 XENFORODB.xf_template_compiled.sql -rw-r--r-- 1 root root 555 Oct 23 08:00 XENFORODB.xf_template_history-schema.sql -rw-r--r-- 1 root root 1.1M Oct 23 08:00 XENFORODB.xf_template_history.sql -rw-r--r-- 1 root root 314 Oct 23 08:00 XENFORODB.xf_template_include-schema.sql -rw-r--r-- 1 root root 46K Oct 23 08:00 XENFORODB.xf_template_include.sql -rw-r--r-- 1 root root 460 Oct 23 08:00 XENFORODB.xf_template_map-schema.sql -rw-r--r-- 1 root root 189K Oct 23 08:00 XENFORODB.xf_template_map.sql -rw-r--r-- 1 root root 422 Oct 23 08:00 XENFORODB.xf_template_modification_log-schema.sql -rw-r--r-- 1 root root 5.7K Oct 23 08:00 XENFORODB.xf_template_modification_log.sql -rw-r--r-- 1 root root 733 Oct 23 08:00 XENFORODB.xf_template_modification-schema.sql -rw-r--r-- 1 root root 84K Oct 23 08:00 XENFORODB.xf_template_modification.sql -rw-r--r-- 1 root root 318 Oct 23 08:00 XENFORODB.xf_template_phrase-schema.sql -rw-r--r-- 1 root root 824K Oct 23 08:00 XENFORODB.xf_template_phrase.sql -rw-r--r-- 1 root root 772 Oct 23 08:00 XENFORODB.xf_template-schema.sql -rw-r--r-- 1 root root 7.8M Oct 23 08:00 XENFORODB.xf_template.sql -rw-r--r-- 1 root root 303 Oct 23 08:00 XENFORODB.xf_thread_prefix_group-schema.sql -rw-r--r-- 1 root root 183 Oct 23 08:00 XENFORODB.xf_thread_prefix_group.sql -rw-r--r-- 1 root root 613 Oct 23 08:00 XENFORODB.xf_thread_prefix-schema.sql -rw-r--r-- 1 root root 1.5K Oct 23 08:00 XENFORODB.xf_thread_prefix.sql -rw-r--r-- 1 root root 518 Oct 23 08:00 XENFORODB.xf_thread_read-schema.sql -rw-r--r-- 1 root root 165 Oct 23 08:00 XENFORODB.xf_thread_read.sql -rw-r--r-- 1 root root 410 Oct 23 08:00 XENFORODB.xf_thread_redirect-schema.sql -rw-r--r-- 1 root root 3.6K Oct 23 08:00 XENFORODB.xf_thread_redirect.sql -rw-r--r-- 1 root root 1.7K Oct 23 08:00 XENFORODB.xf_thread-schema.sql -rw-r--r-- 1 root root 231K Oct 23 08:00 XENFORODB.xf_thread.sql -rw-r--r-- 1 root root 331 Oct 23 08:00 XENFORODB.xf_thread_user_post-schema.sql -rw-r--r-- 1 root root 25K Oct 23 08:00 XENFORODB.xf_thread_user_post.sql -rw-r--r-- 1 root root 210 Oct 23 08:00 XENFORODB.xf_thread_view-schema.sql -rw-r--r-- 1 root root 154 Oct 23 08:00 XENFORODB.xf_thread_view.sql -rw-r--r-- 1 root root 385 Oct 23 08:00 XENFORODB.xf_thread_watch-schema.sql -rw-r--r-- 1 root root 16K Oct 23 08:00 XENFORODB.xf_thread_watch.sql -rw-r--r-- 1 root root 415 Oct 23 08:00 XENFORODB.xf_tinhte_xentag_tagged_content-schema.sql -rw-r--r-- 1 root root 38K Oct 23 08:00 XENFORODB.xf_tinhte_xentag_tagged_content.sql -rw-r--r-- 1 root root 800 Oct 23 08:00 XENFORODB.xf_tinhte_xentag_tag-schema.sql -rw-r--r-- 1 root root 208K Oct 23 08:00 XENFORODB.xf_tinhte_xentag_tag.sql -rw-r--r-- 1 root root 398 Oct 23 08:00 XENFORODB.xf_tinhte_xentag_tag_watch-schema.sql -rw-r--r-- 1 root root 318 Oct 23 08:00 XENFORODB.xf_trophy-schema.sql -rw-r--r-- 1 root root 1.1K Oct 23 08:00 XENFORODB.xf_trophy.sql -rw-r--r-- 1 root root 255 Oct 23 08:00 XENFORODB.xf_trophy_user_title-schema.sql -rw-r--r-- 1 root root 224 Oct 23 08:00 XENFORODB.xf_trophy_user_title.sql -rw-r--r-- 1 root root 414 Oct 23 08:00 XENFORODB.xf_upgrade_category-schema.sql -rw-r--r-- 1 root root 173 Oct 23 08:00 XENFORODB.xf_upgrade_category.sql -rw-r--r-- 1 root root 385 Oct 23 08:00 XENFORODB.xf_upgrade_log-schema.sql -rw-r--r-- 1 root root 240 Oct 23 08:00 XENFORODB.xf_upgrade_log.sql -rw-r--r-- 1 root root 250 Oct 23 08:00 XENFORODB.xf_user_alert_optout-schema.sql -rw-r--r-- 1 root root 211 Oct 23 08:00 XENFORODB.xf_user_alert_optout.sql -rw-r--r-- 1 root root 1.1K Oct 23 08:00 XENFORODB.xf_user_alert-schema.sql -rw-r--r-- 1 root root 318 Oct 23 08:00 XENFORODB.xf_user_authenticate-schema.sql -rw-r--r-- 1 root root 25K Oct 23 08:00 XENFORODB.xf_user_authenticate.sql -rw-r--r-- 1 root root 503 Oct 23 08:00 XENFORODB.xf_user_ban-schema.sql -rw-r--r-- 1 root root 1.3K Oct 23 08:00 XENFORODB.xf_user_ban.sql -rw-r--r-- 1 root root 526 Oct 23 08:00 XENFORODB.xf_user_change_log-schema.sql -rw-r--r-- 1 root root 661 Oct 23 08:00 XENFORODB.xf_user_change_log.sql -rw-r--r-- 1 root root 684 Oct 23 08:00 XENFORODB.xf_user_change_temp-schema.sql -rw-r--r-- 1 root root 413 Oct 23 08:00 XENFORODB.xf_user_confirmation-schema.sql -rw-r--r-- 1 root root 388 Oct 23 08:00 XENFORODB.xf_user_external_auth-schema.sql -rw-r--r-- 1 root root 9.4K Oct 23 08:00 XENFORODB.xf_user_external_auth.sql -rw-r--r-- 1 root root 1.3K Oct 23 08:00 XENFORODB.xf_user_field-schema.sql -rw-r--r-- 1 root root 1.1K Oct 23 08:00 XENFORODB.xf_user_field.sql -rw-r--r-- 1 root root 323 Oct 23 08:00 XENFORODB.xf_user_field_value-schema.sql -rw-r--r-- 1 root root 13K Oct 23 08:00 XENFORODB.xf_user_field_value.sql -rw-r--r-- 1 root root 393 Oct 23 08:00 XENFORODB.xf_user_follow-schema.sql -rw-r--r-- 1 root root 346 Oct 23 08:00 XENFORODB.xf_user_follow.sql -rw-r--r-- 1 root root 334 Oct 23 08:00 XENFORODB.xf_user_group_change-schema.sql -rw-r--r-- 1 root root 881 Oct 23 08:00 XENFORODB.xf_user_group_change.sql -rw-r--r-- 1 root root 502 Oct 23 08:00 XENFORODB.xf_user_group_promotion_log-schema.sql -rw-r--r-- 1 root root 991 Oct 23 08:00 XENFORODB.xf_user_group_promotion_log.sql -rw-r--r-- 1 root root 444 Oct 23 08:00 XENFORODB.xf_user_group_promotion-schema.sql -rw-r--r-- 1 root root 289 Oct 23 08:00 XENFORODB.xf_user_group_promotion.sql -rw-r--r-- 1 root root 381 Oct 23 08:00 XENFORODB.xf_user_group_relation-schema.sql -rw-r--r-- 1 root root 2.1K Oct 23 08:00 XENFORODB.xf_user_group_relation.sql -rw-r--r-- 1 root root 553 Oct 23 08:00 XENFORODB.xf_user_group-schema.sql -rw-r--r-- 1 root root 573 Oct 23 08:00 XENFORODB.xf_user_group.sql -rw-r--r-- 1 root root 313 Oct 23 08:00 XENFORODB.xf_user_ignored-schema.sql -rw-r--r-- 1 root root 432 Oct 23 08:00 XENFORODB.xf_user_news_feed_cache-schema.sql -rw-r--r-- 1 root root 102K Oct 23 08:00 XENFORODB.xf_user_news_feed_cache.sql -rw-r--r-- 1 root root 1.4K Oct 23 08:00 XENFORODB.xf_user_option-schema.sql -rw-r--r-- 1 root root 7.7K Oct 23 08:00 XENFORODB.xf_user_option.sql -rw-r--r-- 1 root root 809 Oct 23 08:00 XENFORODB.xf_user_privacy-schema.sql -rw-r--r-- 1 root root 9.6K Oct 23 08:00 XENFORODB.xf_user_privacy.sql -rw-r--r-- 1 root root 1.3K Oct 23 08:00 XENFORODB.xf_user_profile-schema.sql -rw-r--r-- 1 root root 35K Oct 23 08:00 XENFORODB.xf_user_profile.sql -rw-r--r-- 1 root root 2.7K Oct 23 08:00 XENFORODB.xf_user-schema.sql -rw-r--r-- 1 root root 24K Oct 23 08:00 XENFORODB.xf_user.sql -rw-r--r-- 1 root root 331 Oct 23 08:00 XENFORODB.xf_user_status-schema.sql -rw-r--r-- 1 root root 232 Oct 23 08:00 XENFORODB.xf_user_status.sql -rw-r--r-- 1 root root 350 Oct 23 08:00 XENFORODB.xf_user_trophy-schema.sql -rw-r--r-- 1 root root 2.8K Oct 23 08:00 XENFORODB.xf_user_trophy.sql -rw-r--r-- 1 root root 597 Oct 23 08:00 XENFORODB.xf_user_upgrade_active-schema.sql -rw-r--r-- 1 root root 544 Oct 23 08:00 XENFORODB.xf_user_upgrade_expired-schema.sql -rw-r--r-- 1 root root 775 Oct 23 08:00 XENFORODB.xf_user_upgrade_log-schema.sql -rw-r--r-- 1 root root 120K Oct 23 08:00 XENFORODB.xf_user_upgrade_log.sql -rw-r--r-- 1 root root 1.7K Oct 23 08:00 XENFORODB.xf_user_upgrade-schema.sql -rw-r--r-- 1 root root 2.5K Oct 23 08:00 XENFORODB.xf_user_upgrade.sql -rw-r--r-- 1 root root 490 Oct 23 08:00 XENFORODB.xf_warning_action-schema.sql -rw-r--r-- 1 root root 575 Oct 23 08:00 XENFORODB.xf_warning_action_trigger-schema.sql -rw-r--r-- 1 root root 580 Oct 23 08:00 XENFORODB.xf_warning_definition-schema.sql -rw-r--r-- 1 root root 237 Oct 23 08:00 XENFORODB.xf_warning_definition.sql -rw-r--r-- 1 root root 900 Oct 23 08:00 XENFORODB.xf_warning-schema.sql -rw-r--r-- 1 root root 266 Oct 23 08:00 XENFORODB.xf_widgetframework_widget_page-schema.sql -rw-r--r-- 1 root root 509 Oct 23 08:00 XENFORODB.xf_widget-schema.sql -rw-r--r-- 1 root root 11K Oct 23 08:00 XENFORODB.xf_widget.sql MySQL restore backup benchmarks mysql vs myloader multi-threaded restore database mysql default restore backup = 6.77 seconds myloader multi-threaded restore backup = 3.95 seconds = 1.71x times faster Code: mysql restoredb < mysqldump.sql real: 6.77s cpu: 13% maxmem: 39520 KB cswaits: 4047 Code: myloader -d /home/mydumperdata/export-20141023-080052/ -B restoredb real: 3.95s cpu: 7% maxmem: 39920 KB cswaits: 4489
Mydumper 0.9 in the house ! Code: mydumper -V mydumper 0.9.0, built against MySQL 10.0.19-MariaDB Code: myloader -V myloader 0.9.0, built against MySQL 10.0.19-MariaDB Code: mydumper --help Usage: mydumper [OPTION...] multi-threaded MySQL dumping Help Options: -?, --help Show help options Application Options: -B, --database Database to dump -T, --tables-list Comma delimited table list to dump (does not exclude regex option) -o, --outputdir Directory to output files to -s, --statement-size Attempted size of INSERT statement in bytes, default 1000000 -r, --rows Try to split tables into chunks of this many rows. This option turns off --chunk-filesize -F, --chunk-filesize Split tables into chunks of this output file size. This value is in MB -c, --compress Compress output files -e, --build-empty-files Build dump files even if no data available from table -x, --regex Regular expression for 'db.table' matching -i, --ignore-engines Comma delimited list of storage engines to ignore -m, --no-schemas Do not dump table schemas with the data -d, --no-data Do not dump table data -G, --triggers Dump triggers -E, --events Dump events -R, --routines Dump stored procedures and functions -k, --no-locks Do not execute the temporary shared read lock. WARNING: This will cause inconsistent backups --less-locking Minimize locking time on InnoDB tables. -l, --long-query-guard Set long query timer in seconds, default 60 -K, --kill-long-queries Kill long running queries (instead of aborting) -D, --daemon Enable daemon mode -I, --snapshot-interval Interval between each dump snapshot (in minutes), requires --daemon, default 60 -L, --logfile Log file name to use, by default stdout is used --tz-utc SET TIME_ZONE='+00:00' at top of dump to allow dumping of TIMESTAMP data when a server has data in different time zones or data is being moved between servers with different time zones, defaults to on use --skip-tz-utc to disable. --skip-tz-utc --use-savepoints Use savepoints to reduce metadata locking issues, needs SUPER privilege --success-on-1146 Not increment error count and Warning instead of Critical in case of table doesn't exist --lock-all-tables Use LOCK TABLE for all, instead of FTWRL -U, --updated-since Use Update_time to dump only tables updated in the last U days --trx-consistency-only Transactional consistency only -h, --host The host to connect to -u, --user Username with privileges to run the dump -p, --password User password -P, --port TCP/IP port to connect to -S, --socket UNIX domain socket file to use for connection -t, --threads Number of threads to use, default 4 -C, --compress-protocol Use compression on the MySQL connection -V, --version Show the program version and exit -v, --verbose Verbosity of output, 0 = silent, 1 = errors, 2 = warnings, 3 = info, default 2 Code: myloader --help Usage: myloader [OPTION...] multi-threaded MySQL loader Help Options: -?, --help Show help options Application Options: -d, --directory Directory of the dump to import -q, --queries-per-transaction Number of queries per transaction, default 1000 -o, --overwrite-tables Drop tables if they already exist -B, --database An alternative database to restore into -s, --source-db Database to restore -e, --enable-binlog Enable binary logging of the restore data -h, --host The host to connect to -u, --user Username with privileges to run the dump -p, --password User password -P, --port TCP/IP port to connect to -S, --socket UNIX domain socket file to use for connection -t, --threads Number of threads to use, default 4 -C, --compress-protocol Use compression on the MySQL connection -V, --version Show the program version and exit -v, --verbose Verbosity of output, 0 = silent, 1 = errors, 2 = warnings, 3 = info, default 2