请教mysql定时备份的问题

blackspace

UID: 232
帖子: 1
积分: 2
在线时间: 10 分钟

11^# blackspace 发表于 2008-07-23 17:54

mysqldump --opt sampdb　　　　　　

blackspace

UID: 232
帖子: 1
积分: 2
在线时间: 10 分钟

12^# blackspace 发表于 2008-07-23 17:55

不是 –skip-opt　　　　　　

blackspace

UID: 232
帖子: 1
积分: 2
在线时间: 10 分钟

13^# blackspace 发表于 2008-07-23 17:57

--skip-opt

This option has the opposite effect of --opt, which is enabled by default as of MySQL 4.1. --skip-opt can be used to obtain the pre-4.1 behavior of mysqldump.

--opt

Optimize table dumping speed and write a dump file that is optimal for reloading speed. This option turns on whichever of the following options are present in your version of mysqldump: --add-drop-table, --add-locks, --create-options, --disable-keys, --extended-insert, --lock-tables, --quick, and --set-charset. This option was disabled by default before MySQL 4.1. It is now enabled by default; use --skip-opt to disable it.　　　　　　