关于使用myshell备份数据一些注意事项（2）

2024年 5月 23日数据运维向阳逐梦

接下来，我们使用myshell备份数据库中表。在做这个实验时，我还是碰到一些小问题。

util.dump_tables([“test”],”t”,”datadump1″);

Traceback (most recent call last):

File “”, line 1, in

TypeError: Util.dump_tables: Argument #1 is expected to be a string

从报错信息看，每一个参数应是字符串。我们改一下参数util.dump_tables(“test”,”t”,”datadump1″);

Traceback (most recent call last):

File “”, line 1, in

TypeError: Util.dump_tables: Argument #2 is expected to be an array

从报错信息看，又提示第二个参数就是数组。我们改一下参数util.dump_tables(“test”,[“t”],”datadump1″);

Acquiring global read lock

Global read lock acquired

Initializing – done

1 tables and 0 views will be dumped.

Gathering information – done

All transactions have been started

Locking instance for backup

Global read lock has been released

Writing global DDL files

Running data dump using 4 threads.

NOTE: Progress information uses estimated values and may not be accurate.

Writing schema metadata – done

Writing DDL – done

Writing table metadata – done

Starting data dump

120% (6 rows / ~5 rows), 0.00 rows/s, 0.00 B/s uncompressed, 0.00 B/s compressed

Dump duration: 00:00:00s

Total duration: 00:00:00s

Schemas dumped: 1

Tables dumped: 1

Uncompressed data size: 23 bytes

Compressed data size: 41 bytes

Compression ratio: 0.6

Rows written: 6

Bytes written: 41 bytes

Average uncompressed throughput: 23.00 B/s

Average compressed throughput: 41.00 B/s

这次成功备份表数据了。

作者：向阳逐梦

链接：https://www.mryunwei.com/608250.html

文章版权归作者所有，未经允许请勿转载。