Question

When I was using mysqldump without --tab option I could dump routines (by --routines option) and triggers (by --triggers that enabled by default), but when trying to use --tab to get its benefit of speed I couldn t dump neither routines nor triggers even when specifying the two options (--routines and --triggers) but instead I found the SQL for triggers and stored procedures creation in the terminal I m using to execute the command.

How can I dump routines and triggers using the --tab option in mysqldump ?

增编

Abdel-Mawla

Answer 1

您可以采取的一种做法是,把你的单薄膜打成一片,先把桌子放在桌面上,然后通过单独传闻(无表格)将例行公事丢弃。

Answer 2

我看到,每个表文档中都有<代码>-----tab和---triggers的触发器。

But for the routines, I can confirm that these are thrown out to stdout. The same applies for --events All I could think of is:

mysqldump --tab= /path/to/output/dbName  --triggers --routines --events dbName > /path/to/output/dbName/_events.and.routines.sql

因为当例行公事被扔到out中时,“ the”可以将其归档。

因此,现在编号为/path/to/output/dbName I,将有一个称为——events.and.routines.sql的附加档案,其中载有例行活动和事件。

我不知道一下一下,我的进口商是否也会自动在这些出口例行活动中占据。

友情链接