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

2024年 5月 23日 44.8k 0

接下来,我们使用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

这次成功备份表数据了。

相关文章

Oracle如何使用授予和撤销权限的语法和示例
Awesome Project: 探索 MatrixOrigin 云原生分布式数据库
下载丨66页PDF,云和恩墨技术通讯(2024年7月刊)
社区版oceanbase安装
Oracle 导出CSV工具-sqluldr2
ETL数据集成丨快速将MySQL数据迁移至Doris数据库

发布评论