If we export the table into another DB then does its all triggers also gets exported along with it?

If we export the table into another DB then does its all triggers also gets exported along with it?

Updat开发者_如何学Pythone

In context of Randy Minder's reply

is it possible to transfer the schema table from one DB to another?

UPDATE In context of MATT's Reply

But What should I do If i have to script this export? as in this case I have to change the trigger_Schmea every time.

---

Pass --triggers to the mysqldump command if you're not getting triggers already (you should.. it's default)

---

I think not. You could try to export on table into .sql file and see what scripts are written into it.

---

Generally an "export" only deals with data. So the answer would be no. But if you script out your source database schema, and execute the script against the target database, all the triggers should come with it, assuming they were scripted as part of the schema.