Mysqlpump, the successor to mysqldump that makes dumping fun

Hello.
I'm Mandai, in charge of free stock images on the development team.

I'm quite late to the party, but I've tried out mysqlpump, the successor to mysqldump, so I've put together a summary of its advantages for those who haven't used it yet.
As expected of a successor, the basic options are the same, and it's designed to be user-friendly for those migrating from mysqldump, so I really want you to try it out. The fact
that it's bundled with MySQL is a big plus.

Progress display alone makes it worth switching

The database I tested this time was only about 200MB in size, so I didn't see much benefit, but mysqlpump does display the progress of the dump as it goes along

mysqlpump -uroot -p --databases xxxxx > xxxxx_20XX0X0X.sql Enter password: Dump progress: 1/6 tables, 0/352 rows Dump progress: 73/145 tables, 551291/1274767 rows Dump completed in 2073 milliseconds

 

The basic command looks like this.
At first glance, you might think it's a typo, because it's actually `mysqldump`.

I also tried dumping the same database using mysqldump, and mysqldump was slightly slower.
I couldn't help but feel a little disappointed by this, but for this amount of data, it was only about 0.2 seconds, so it's probably within the margin of error.

 

Has the option to compress the output file

Dump files are usually compressed, whether for backup or for transfer to another server for replication.
mysqlpump has an option to output compressed files, eliminating the need for tedious post-processing.

mysqlpump -uroot -p --compress-output=LZ4 --databases xxxxx > xxxxx_20XX0X0X.lz4

 

The --compress-output option lets you choose the compression format.
However, it only supports LZ4 and openssl zlib, which are not commonly seen formats.
To my embarrassment, I looked up what openssl zlib was and found out it's just a zip file.

Zip isn't much fun, so I tried compressing it using LZ4, but now I'm wondering how to unzip it

That's when I found the MySQL documentation.

The LZ4 format appears to be a standard Linux compression format, and a decompression command is available

lz4_decompress xxxxx_20XX0X0X.lz4 xxxxx_20XX0X0X.sql

 

It's exactly as it sounds. And it's long.
I was hoping for something like an unzip command.
Anyway, putting that complaint aside, you can import the extracted file simply by inputting it into the mysql command.

mysql -uroot -p < xxxxx_20XX0X0X.sql

 

When it comes to file compression, the compression ratio is a major concern, but LZ4 doesn't seem to have much of an advantage in terms of compression ratio; its strength lies in its compression speed.
That being said, the compression ratio isn't too bad either, so I'm thinking of compressing mysqlpump files in LZ4 format for a while.

 

Parallel processing is possible

The biggest difference from mysqldump is the concept of parallel processing.
However, judging from the documentation, it seems that you won't be able to use it effectively unless you understand how mysqlpump dumps.

The --default-parallelism option specifies the number of threads to launch. The default is 2

mysqlpump -uroot -p \ --default-parallelism=4 \ --databases xxxxx \ > xxxxx_20XX0X0X.sql

 

Create queues with the --parallel-schemas option and specify which queues should process which tables

mysqlpump -uroot -p \ --parallel-schemas=xxxxx \ --parallel-schemas=yyyyy \ > xxxxxyyyyy_20XX0X0X.sql

 

This allows you to process the xxxxx table and the yyyyy table in separate threads. Simple, right?
Furthermore, you can specify the number of threads to process the queue by combining this with the --default-parallelism option.

mysqlpump -uroot -p \ --default-parallelism=4 \ --parallel-schemas=xxxxx \ --parallel-schemas=yyyyy \ > xxxxxyyyyy_20XX0X0X.sql

 

In the above example, two queues will be created, each of which will be processed by four threads

Creating queues for each table is something worth remembering; if you can distribute the processing load effectively, it will likely shorten execution time.
At first, you might think that you could just dump the data while doing those calculations, but it's like processing a huge table and smaller tables in separate queues.

The --parallel-schemas option can also specify the number of threads to launch at the same time, so it is possible to bias the number of threads

mysqlpump -uroot -p \ --parallel-schemas=2:xxxxx \ --parallel-schemas=4:yyyyy \ > xxxxxyyyyy_20XX0X0X.sql

 

This command means that 2 threads will be used to dump the xxxxx table, and 4 threads will be used to dump the yyyyy table

 

I got a strange error when I tried to dump

When I first ran it, I got an incomprehensible error and got flustered, so I'm posting this as a memo

mysqlpump -uroot -p --databases xxxxx > xxxxx_20XX0X0X.sql Enter password: mysqlpump: [WARNING] (1356) View 'sys.host_summary' references invalid table(s) or column(s) or function(s) or lack of definer/invoker of view rights to use them mysqlpump: [WARNING] (1356) View 'sys.host_summary_by_file_io' references invalid table(s) or column(s) or function(s) or lack of definer/invoker of view rights to use them mysqlpump: [WARNING] (1356) View 'sys.host_summary_by_file_io_type' references invalid table(s) or column(s) or function(s) or definer/invoker of view rights lack to use them mysqlpump: [WARNING] (1356) View 'sys.host_summary_by_stages' references invalid table(s) or column(s) or function(s) or definer/invoker of view rights lack to use them mysqlpump: [WARNING] (1356) View 'sys.host_summary_by_statement_latency' references invalid table(s) or column(s) or function(s) or definer/invoker of view rights lack to use them mysqlpump: [WARNING] (1356) View 'sys.host_summary_by_statement_type' references invalid table(s) or column(s) or function(s) or definer/invoker of view rights to use them mysqlpump: [WARNING] (1356) View 'sys.innodb_buffer_stats_by_schema' references invalid table(s) or column(s) or lack function(s) or definer/invoker of view lack rights to use them mysqlpump: [WARNING] (1356) View 'sys.innodb_buffer_stats_by_table' references invalid table(s) or column(s) or function(s) or definer/invoker of view lack rights to use them mysqlpump: [WARNING] (1356) View 'sys.innodb_lock_waits' references invalid table(s) or column(s) or function(s) or definer/invoker of view lack rights to use them mysqlpump: [WARNING] (1356) View 'sys.io_by_thread_by_latency' references invalid table(s) or column(s) or function(s) or definer/invoker of view lack rights to use them mysqlpump: [WARNING] (1356) View 'sys.io_global_by_file_by_bytes' references invalid table(s) or column(s) or function(s) or definer/invoker of lack rights to use them mysqlpump: [WARNING] (1356) View 'sys.io_global_by_file_by_latency' references invalid table(s) or column(s) or function(s) or definer/invoker of lack rights to use them mysqlpump: [WARNING] (1356) View 'sys.io_global_by_wait_by_bytes' references invalid table(s) or column(s) or function(s) or definer/invoker of view lack rights to use them mysqlpump: [WARNING] (1356) View 'sys.io_global_by_wait_by_latency' references invalid table(s) or column(s) or function(s) or definer/invoker of view lack rights to use them mysqlpump: [WARNING] (1356) View 'sys.latest_file_io' invalid references table(s) or column(s) or function(s) or lack of definer/invoker of view rights to use them mysqlpump: [WARNING] (1356) View 'sys.memory_by_host_by_current_bytes' references invalid table(s) or column(s) or function(s) or definer/invoker of lack rights to use them mysqlpump: [WARNING] (1356) View 'sys.memory_by_thread_by_current_bytes' references invalid table(s) or column(s) or function(s) or definer/invoker of view rights lack to use them mysqlpump: [WARNING] (1356) View 'sys.memory_by_user_by_current_bytes' references invalid table(s) or column(s) or function(s) or definer/invoker of view rights lack to use them mysqlpump: [WARNING] (1356) View 'sys.memory_global_by_current_bytes' references invalid table(s) or column(s) or function(s) or definer/invoker of view rights lack to use them mysqlpump: [WARNING] (1356) View 'sys.memory_global_total' references invalid table(s) or column(s) or function(s) or definer/invoker of view rights lack to use them mysqlpump: [WARNING] (1356) View 'sys.processlist' references invalid table(s) or column(s) or function(s) or definer/invoker of view rights lack to use them mysqlpump: [WARNING] (1356) View 'sys.schema_index_statistics' references invalid table(s) or column(s) or function(s) or definer/invoker of view rights lack to use them mysqlpump: [WARNING] (1356) View 'sys.schema_table_lock_waits' references invalid table(s) or column(s) or function(s) or definer/invoker of view lack rights to use them mysqlpump: [WARNING] (1356) View 'sys.schema_table_statistics' references invalid table(s) or column(s) or function(s) or definer/invoker of view lack rights to use them mysqlpump: [WARNING] (1356) View 'sys.schema_table_statistics_with_buffer' references invalid table(s) or column(s) or function(s) or lack of definer/invoker of view rights to use them mysqlpump: [WARNING] (1356) View 'sys.schema_tables_with_full_table_scans' references invalid table(s) or column(s) or function(s) or lack of definer/invoker of view rights to use them mysqlpump: [WARNING] (1356) View 'sys.session' references invalid table(s) or column(s) or function(s) or definer/invoker of view rights lack to use them mysqlpump: [WARNING] (1356) View 'sys.statement_analysis' references invalid table(s) or column(s) or function(s) or definer/invoker of view rights lack to use them mysqlpump: [WARNING] (1356) View 'sys.statements_with_errors_or_warnings' references invalid table(s) or column(s) or function(s) or lack of definer/invoker of view rights to use them mysqlpump: [WARNING] (1356) View 'sys.statements_with_full_table_scans' references invalid table(s) or column(s) or function(s) or lack of definer/invoker of view rights to use them mysqlpump: [WARNING] (1356) View 'sys.statements_with_runtimes_in_95th_percentile' references invalid table(s) or column(s) or function(s) or definer/invoker of view rights to use them mysqlpump: [WARNING] (1356) View 'sys.statements_with_sorting' references invalid table(s) or column(s) or function(s) define orr/invoker lack of view rights to use them mysqlpump: [WARNING] (1356) View 'sys.statements_with_temp_tables' references invalid table(s) or column(s) or function(s) or definer/invoker of view rights to use them mysqlpump: [WARNING] (1356) View 'sys.user_summary' references invalid table(s) or column(s) or function(s) or definer/invoker of view rights to use them mysqlpump: [WARNING] (1356) View 'sys.user_summary_by_file_io' references invalid table(s) or column(s) or function(s) or lack of definer/invoker of view rights to use them mysqlpump: [WARNING] (1356) View 'sys.user_summary_by_file_io_type' references invalid table(s) or column(s) or function(s) or definer/invoker of view lack rights to use them mysqlpump: [WARNING] (1356) View 'sys.user_summary_by_stages' references invalid table(s) or column(s) or function(s) or definer/invoker of view lack rights to use them mysqlpump: [WARNING] (1356) View 'sys.user_summary_by_statement_latency' references invalid table(s) or column(s) or function(s) or definer/invoker of view lack rights to use them mysqlpump: [WARNING] (1356) View 'sys.user_summary_by_statement_type' references invalid table(s) or column(s) or function(s) or definer/invoker of view lack rights to use them mysqlpump: [WARNING] (1356) View 'sys.wait_classes_global_by_avg_latency' references invalid table(s) or column(s) or function(s) or definer/invoker of view lack rights to use them mysqlpump: [WARNING] (1356) View 'sys.wait_classes_global_by_latency' references invalid table(s) or column(s) or function(s) or definer/invoker of view lack rights to use them mysqlpump: [WARNING] (1356) View 'sys.waits_by_host_by_latency' references invalid table(s) or column(s) or function(s) or definer/invoker of view lack rights to use them mysqlpump: [WARNING] (1356) View 'sys.waits_by_user_by_latency' references invalid table(s) or column(s) or function(s) or definer/invoker of view lack rights to use them mysqlpump: [WARNING] (1356) View 'sys.waits_global_by_latency' references invalid table(s) or column(s) or function(s) or lack of definer/invoker of view rights to use them mysqlpump: [WARNING] (1356) View 'sys.x$ps_schema_table_statistics_io' references invalid table(s) or column(s) or function(s) or lack of definer/invoker of view rights to use them mysqlpump: [WARNING] (1356) View 'sys.x$schema_table_lock_waits' references invalid table(s) or column(s) or function(s) or lack of definer/invoker of view rights to use them mysqlpump: [WARNING] (1356) View 'sys.x$schema_table_statistics' references invalid table(s) or column(s) or function(s) or definer/invoker of view rights to use them mysqlpump: [WARNING] (1356) View 'sys.x$schema_table_statistics_with_buffer' references invalid table(s) or column(s) or function(s) or definer/invoker of view rights to use them mysqlpump: [ERROR] (1356) View 'sys.host_summary' references invalid table(s) or column(s) or function(s) or definer/invoker of view rights lack to use them Dump process encountered error and will not continue. mysqlpump: [ERROR] (1356) View 'sys.host_summary_by_file_io' references invalid table(s) or column(s) or function(s) or definer/invoker of view rights lack to use them Dump process encountered error and will not continue. mysqlpump: [ERROR] (1356) View 'sys.host_summary_by_file_io_type' references invalid mysqlpump: [ERROR] (1356) View 'sys.host_summary_by_stages' references invalid table(s) or column(s) or function(s) or definer/invoker of view rights to use them Dump process encountered error and will not continue. mysqlpump: [ERROR] (1356) View mysqlpump: [ERROR] (1356) View 'sys.host_summary_by_statement_type' references invalid table(s) or column(s) or function(s) define orr/invoker mysqlpump: [ERROR] (1356) View 'sys.innodb_buffer_stats_by_schema' references invalid table(s) or column(s) or function(s) or definer/invoker of lack of view rights to use them Dump process encountered error and will not continue. 'sys.innodb_buffer_stats_by_table' references invalid mysqlpump: [ERROR] (1356) View 'sys.innodb_lock_waits' references invalid table(s) or column(s) or function(s) or definer/invoker of view rights to use them Dump process encountered error and will not continue. mysqlpump: [ERROR] (1356) View 'sys.io_by_thread_by_latency' references invalid table(s) or column(s) or function(s) or definer/invoker of view lack rights to use them Dump process encountered error and will not continue. mysqlpump: [ERROR] (1356) View 'sys.io_global_by_file_by_bytes' references invalid table(s) or column(s) or function(s) or definer/invoker of lack view rights to use them Dump process mysqlpump: [ERROR] (1356) View 'sys.io_global_by_file_by_latency' references encountered invalid table(s) or column(s) or function(s) or definer/invoker of view rights lack to use them Dump process encountered error and will not continue. mysqlpump: [ERROR] (1356) View 'sys.io_global_by_wait_by_bytes' references invalid table(s) or column(s) or function(s) or definer/invoker of view lack rights to use them Dump process encountered error and will not continue. mysqlpump: [ERROR] (1356) View 'sys.io_global_by_wait_by_latency' references invalid table(s) or column(s) or function(s) or definer/invoker of view rights to use them Dump process encountered error and will not continue. mysqlpump: [ERROR] (1356) View mysqlpump: [ERROR] (1356) View 'sys.memory_by_host_by_current_bytes' references invalid table(s) or column(s) or function(s) or lack of definer/invoker of view rights to use them Dump process encountered error and will not continue. mysqlpump: [ERROR] (1356) View 'sys.memory_by_thread_by_current_bytes' references invalid table(s) or column(s) or function(s) or definer/invoker of view rights lack to use them Dump process encountered error and will not continue. 'sys.memory_by_user_by_current_bytes' references invalid table(s) or mysqlpump: [ERROR] (1356) View 'sys.memory_global_by_current_bytes' references invalid table(s) or column(s) or function(s) or definer/invoker of view rights to use them Dump process encountered error and will not continue. mysqlpump: [ERROR] (1356) View 'sys.memory_global_total' references invalid table(s) or column(s) or function(s) or lack of definer/invoker of view rights to use them Dump process encountered error and will not continue. mysqlpump: [ERROR] (1356) View 'sys.processlist' references invalid table(s) or column(s) or function(s) or lack lack of view rights to use them Dump process encountered error and will not continue. mysqlpump: [ERROR] (1356) View 'sys.schema_index_statistics' references invalid table(s) or column(s) or function(s) or lack of definer/invoker of view rights to use them Dump process encountered error and will not continue. mysqlpump: [ERROR] (1356) View 'sys.schema_table_lock_waits' references invalid table(s) or column(s) or function(s) or mysqlpump: [ERROR] (1356) View 'sys.schema_table_statistics' references invalid table(s) or column(s) or function(s) or definer/invoker of view lack rights to use them Dump process encountered error and will not continue. mysqlpump: [ERROR] (1356) View 'sys.schema_table_statistics_with_buffer' references invalid table(s) or mysqlpump: [ERROR] (1356) View 'sys.schema_tables_with_full_table_scans' references invalid table(s) or column(s) or function(s) or definer/invoker of view rights to use them Dump process encountered error and will not continue. mysqlpump: [ERROR] (1356) View 'sys.session' references invalid table(s) or column(s) or function(s) or definer/invoker of view lack rights to use them Dump process encountered error and will not continue. lack rights to use them Dump process encountered error and will not continue. mysqlpump: [ERROR] (1356) View 'sys.statements_with_errors_or_warnings' references invalid table(s) or column(s) or function(s) or lack of definer/invoker of view rights to use them Dump process encountered error and will not continue. mysqlpump: [ERROR] (1356) View 'sys.statements_with_full_table_scans' references invalid table(s) or column(s) or function(s) mysqlpump: [ERROR] (1356) View 'sys.statements_with_runtimes_in_95th_percentile' references invalid table(s) or column(s) or function(s) or definer/invoker of view rights to use them Dump process encountered error and will not continue. mysqlpump: [ERROR] (1356) View 'sys.statements_with_sorting' mysqlpump: [ERROR] (1356) View 'sys.statements_with_temp_tables' references invalid table(s) or column(s) or function(s) or definer/invoker of view rights to use them Dump process encountered error and will not continue. mysqlpump: [ERROR] (1356) View 'sys.user_summary' references invalid table(s) or column(s) or function(s) or definer/invoker of view lack rights to use them Dump process encountered error and will not continue. function(s) or definer/invoker of view lack rights to use them Dump process encountered error and will not continue. mysqlpump: [ERROR] (1356) View 'sys.user_summary_by_file_io_type' references invalid table(s) or column(s) or function(s) or definer/invoker of view rights lack to use them Dump process encountered error and will not continue. mysqlpump: [ERROR] (1356) View 'sys.user_summary_by_stages' references invalid mysqlpump: [ERROR] (1356) View 'sys.user_summary_by_statement_latency' references invalid table(s) or column(s) or function(s) or definer/invoker of view rights to use them Dump process encountered error and will not continue. mysqlpump: [ERROR] (1356) View 'sys.user_summary_by_statement_type' references invalid table(s) or column(s) or function(s) or definer/invoker of view rights lack to use them Dump process encountered error and will not continue. mysqlpump: [ERROR] (1356) View 'sys.wait_classes_global_by_avg_latency' references invalid table(s) or column(s) or function(s) or mysqlpump: [ERROR] (1356) View 'sys.wait_classes_global_by_latency' references invalid table(s) or column(s) or function(s) or definer/invoker of view lack rights to use them Dump process encountered error and will not continue. View 'sys.waits_by_host_by_latency' references invalid table(s) or mysqlpump: [ERROR] (1356) View 'sys.waits_by_user_by_latency' references invalid table(s) or column(s) or function(s) or definer/invoker of view rights to use them Dump process encountered error and will not continue. mysqlpump: [ERROR] (1356) View 'sys.waits_global_by_latency' references invalid table(s) or column(s) or function(s) or definer/invoker of view lack rights to use them Dump process encountered error and will not continue. mysqlpump: [ERROR] (1356) View 'sys.x$ps_schema_table_statistics_io' references invalid table(s) or column(s) or function(s) or definer/invoker of view lack rights to use them Dump process encountered error mysqlpump: [ERROR] (1356) View 'sys.x$schema_table_lock_waits' references invalid table(s) or column(s) or function(s) or definer/invoker of view lack rights to use them Dump process encountered error and will not continue. mysqlpump: [ERROR] (1356) View 'sys.x$schema_table_statistics' references invalid mysqlpump: [ERROR] (1356) View 'sys.x$schema_table_statistics_with_buffer' references invalid table(s) or column(s) or function(s) or definer/invoker of view rights to use them Dump process encountered error and will not continue. mysqlpump: [WARNING] (1356) View 'sys.host_summary' references invalid table(s) or column(s) or function(s) or lack of definer/invoker of view rights to use them mysqlpump: [WARNING] (1356) View 'sys.host_summary_by_file_io' references invalid table(s) or column(s) or function(s) or lack of definer/invoker of view rights to use them mysqlpump: [WARNING] (1356) View 'sys.host_summary_by_file_io_type' references invalid table(s) or column(s) or function(s) or lack of definer/invoker of view rights to use them mysqlpump: [WARNING] (1356) View 'sys.host_summary_by_stages' references invalid table(s) or column(s) or function(s) or lack of definer/invoker of view rights to use them mysqlpump: [WARNING] (1356) View 'sys.host_summary_by_statement_latency' references invalid table(s) or column(s) or function(s) or definer/invoker of v iew lack rights to use them mysqlpump: [WARNING] (1356) View 'sys.host_summary_by_statement_type' references invalid table(s) or column(s) or function(s) or definer/invoker of view rights to use them mysqlpump: [WARNING] (1356) View 'sys.innodb_buffer_stats_by_schema' references invalid table(s) or column(s) or function(s) or definer/invoker of lack rights to use them mysqlpump: [WARNING] (1356) View 'sys.innodb_buffer_stats_by_table' references invalid table(s) or column(s) or function(s) or definer/invoker of view lack rights to use them mysqlpump: [WARNING] (1356) View 'sys.innodb_lock_waits' references invalid table(s) or column(s) or function(s) or definer/invoker lack of view rights to use them mysqlpump: [WARNING] (1356) View 'sys.io_by_thread_by_latency' references invalid table(s) or column(s) or function(s) or definer/invoker lack of view rights to use them mysqlpump: [WARNING] (1356) View 'sys.io_global_by_file_by_bytes' references invalid table(s) or column(s) or function(s) or definer/invoker of view rights lack to use them mysqlpump: [WARNING] (1356) View 'sys.io_global_by_file_by_latency' references invalid table(s) or column(s) or function(s) or definer/invoker of view rights lack to use them mysqlpump: [WARNING] (1356) View 'sys.io_global_by_wait_by_bytes' references invalid table(s) or column(s) or function(s) or definer/invoker of view rights to use them mysqlpump: [WARNING] (1356) View 'sys.io_global_by_wait_by_latency' references invalid table(s) or column(s) or function(s) or definer/invoker of view rights to use them mysqlpump: [WARNING] (1356) View 'sys.latest_file_io' references invalid table(s) or column(s) or function(s) or definer/invoker of view lack rights to use them mysqlpump: [WARNING] (1356) View 'sys.memory_by_host_by_current_bytes' references invalid table(s) or column(s) or function(s) or definer/invoker of view rights to use them mysqlpump: [WARNING] (1356) View 'sys.memory_by_thread_by_current_bytes' references invalid table(s) or column(s) or function(s) or definer/invoker of view rights to use them mysqlpump: [WARNING] (1356) View 'sys.memory_by_user_by_current_bytes' references invalid table(s) or column(s) or function(s) or definer/invoker of lack rights to use them mysqlpump: [WARNING] (1356) View 'sys.memory_global_by_current_bytes' references invalid table(s) or column(s) or function(s) or definer/invoker of lack rights to use them mysqlpump: [WARNING] (1356) View 'sys.memory_global_total' references invalid table(s) or column(s) or function(s) or definer/invoker of lack rights to use them mysqlpump: [WARNING] (1356) View 'sys.processlist' references invalid table(s) or column(s) or function(s) or definer/invoker of lack rights to use them mysqlpump: [WARNING] (1356) View 'sys.schema_index_statistics' references invalid table(s) or column(s) or function(s) or definer/invoker of view rights lack to use them mysqlpump: [WARNING] (1356) View 'sys.schema_table_lock_waits' references invalid table(s) or column(s) or function(s) or definer/invoker of view rights lack to use them mysqlpump: [WARNING] (1356) View 'sys.schema_table_statistics' references invalid table(s) or column(s) or function(s) or definer/invoker of lack view rights to use them mysqlpump: [WARNING] (1356) View 'sys.schema_table_statistics_with_buffer' references invalid table(s) or column(s) or function(s) or definer/invoker of view rights to use them mysqlpump: [WARNING] (1356) View 'sys.schema_tables_with_full_table_scans' references invalid table(s) or column(s) or function(s) or definer/invoker of lack rights to use them mysqlpump: [WARNING] (1356) View 'sys.session' references invalid table(s) or column(s) or function(s) or definer/invoker of view lack rights to use them mysqlpump: [WARNING] (1356) View 'sys.statement_analysis' references invalid table(s) or column(s) or function(s) or definer/invoker lack of view rights to use them mysqlpump: [WARNING] (1356) View 'sys.statements_with_errors_or_warnings' references invalid table(s) or column(s) or function(s) or definer/invoker of view rights to use them mysqlpump: [WARNING] (1356) View 'sys.statements_with_full_table_scans' references invalid table(s) or column(s) or function(s) or definer/invoker lack of view rights to use them mysqlpump: [WARNING] (1356) View 'sys.statements_with_runtimes_in_95th_percentile' references invalid table(s) or column(s) or function(s) or definer/invoker lack of view rights to use them mysqlpump: [WARNING] (1356) View 'sys.statements_with_sorting' invalid references table(s) or column(s) or function(s) or definer/invoker of lack view rights to use them mysqlpump: [WARNING] (1356) View 'sys.statements_with_temp_tables' references invalid table(s) or column(s) or function(s) or definer/invoker of lack view rights to use them mysqlpump: [WARNING] (1356) View 'sys.user_summary' references invalid table(s) or column(s) or function(s) or definer/invoker of view lack rights to use them mysqlpump: [WARNING] (1356) View 'sys.user_summary_by_file_io' references invalid table(s) or column(s) or function(s) or definer/invoker of view lack rights to use them mysqlpump: [WARNING] (1356) View 'sys.user_summary_by_file_io_type' references invalid table(s) or column(s) or function(s) or definer/invoker of view lack rights to use them mysqlpump: [WARNING] (1356) View 'sys.user_summary_by_stages' references invalid table(s) or column(s) or function(s) or definer/invoker of view lack rights to use them mysqlpump: [WARNING] (1356) View 'sys.user_summary_by_statement_latency' references invalid table(s) or column(s) or function(s) or definer/invoker of view rights lack to use them mysqlpump: [WARNING] (1356) View 'sys.user_summary_by_statement_type' references invalid table(s) or column(s) or function(s) or definer/invoker of view rights lack to use them mysqlpump: [WARNING] (1356) View 'sys.wait_classes_global_by_avg_latency' references invalid table(s) or column(s) or function(s) or definer/invoker of view rights lack to use them mysqlpump: [WARNING] (1356) View 'sys.wait_classes_global_by_latency' references invalid table(s) or column(s) or function(s) or definer/invoker of view rights lack to use them mysqlpump: [WARNING] (1356) View 'sys.waits_by_host_by_latency' references invalid table(s) or column(s) or function(s) or lack of definer/invoker of view rights to use them mysqlpump: [WARNING] (1356) View 'sys.waits_by_user_by_latency' references invalid table(s) or column(s) or function(s) or definer/invoker of view rights to use them mysqlpump: [WARNING] (1356) View 'sys.waits_global_by_latency' references invalid table(s) or column(s) or function(s) or definer/invoker of lack rights to use them mysqlpump: [WARNING] (1356) View 'sys.x$ps_schema_table_statistics_io' references invalid table(s) or column(s) or function(s) or definer/invoker of view lack rights to use them mysqlpump: [WARNING] (1356) View 'sys.x$schema_table_lock_waits' references invalid table(s) or column(s) or function(s) or definer/invoker of view lack rights to use them mysqlpump: [WARNING] (1356) View 'sys.x$schema_table_statistics' references invalid table(s) or column(s) or function(s) or definer/invoker of lack rights to use them mysqlpump: [WARNING] (1356) View 'sys.x$schema_table_statistics_with_buffer' references invalid table(s) or column(s) or function(s) or definer/invoker of lack rights to use them

 

I don't know what I did wrong, but it seems to be a MySQL table compatibility issue. It's not my fault

The solution is simple: just upgrade the system tables

I used this blog as a reference.
It's only a one-line blog, but it gave me courage.
[FIXED] mysqlpump: [WARNING] (1356) – Biesma.net

As the name suggests, it simply says `mysql_upgrade`, but in reality, I suspect it won't work unless you're the root user.
So, I tried running it as follows.

mysql_upgrade -uroot -p

 

After output similar to what you'd see when repairing a table (I forgot to capture it), it finished successfully.
Just to be safe, I backed up all the data with mysqldump before running it. I think I
've achieved my goal at this point...

I began to wonder what on earth I was doing, but after that mysqlpump started working fine

 

summary

This time, I introduced mysqlpump, the successor tool to the mysqldump command.
I think it's quite user-friendly even with just the progress display and compression options.

And on top of that, there's parallel processing.
I'd like to dump an even larger database, but I can't seem to find a suitable target.

Finally, I've shared the problem that conveniently occurred this time.
I think we've resolved it nicely, but since it involves table repair, don't forget to back up your data just in case.

It is included in MySQL 5.7.8 and later versions, so please give it a try

lastly

I have launched "SEKARAKU Lab," a service site for the system development company I belong to.
Beyond offers a one-stop service for everything from server design and construction to operation, so please feel free to contact us if you have any problems with server-side development.
SEKARAKU Lab:[https://sekarakulab.beyondjapan.com/](https://sekarakulab.beyondjapan.com/)

That's all