cuốn sách gpt4 ai đã làm

旧 mysql 版本的 mysqldump

In lại Tác giả: Walker 123 更新时间:2023-11-29 04:48:09 27 4
mua khóa gpt4 Nike

如果我使用 mysqldump 工具备份旧版本的 MySql 数据库,是否存在任何已知风险?例如,如果我在生产机器上使用 mysqldump 5.6 来备份 MySql 5.X 数据库。

câu trả lời hay nhất

有一个兼容的选项。我发现它来自 https://dev.mysql.com/doc/refman/5.5/en/mysqldump.html

--compatible=name

Produce output that is more compatible with other database systems or with older MySQL servers. The value of name can be ansi, mysql323, mysql40, postgresql, oracle, mssql, db2, maxdb, no_key_options, no_table_options, or no_field_options. To use several values, separate them by commas. These values have the same meaning as the corresponding options for setting the server SQL mode. See Section 5.1.8, “Server SQL Modes”.

This option does not guarantee compatibility with other servers. It only enables those SQL mode values that are currently available for making dump output more compatible. For example, --compatible=oracle does not map data types to Oracle types or use Oracle comment syntax.

This option requires a server version of 4.1.0 or higher. With older servers, it does nothing.

关于旧 mysql 版本的 mysqldump,我们在Stack Overflow上找到一个类似的问题: https://stackoverflow.com/questions/15578609/

27 4 0
Chứng chỉ ICP Bắc Kinh số 000000
Hợp tác quảng cáo: 1813099741@qq.com 6ren.com
Xem sitemap của VNExpress