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

A:

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

Riho 2010-05-03 11:52:01

A:

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.

Randy Minder 2010-05-03 11:52:04

+1 See updated Question

OM The Eternity 2010-05-03 12:07:33

+2 A:

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

Matt 2010-05-03 12:12:30

When I Click Export o table structure in phpmyadmin, I can see the mysqldump, where i found the --Triggers "table_name", but when I copied the whole part and pasted in other DB I cannot find the triggers copied.. What could be the reason

OM The Eternity 2010-05-03 12:21:35

@OM The Eternity - I haven't used phpMyAdmin in years. To my knowledge it does not use `mysqldump`. In either case I suggest running the `mysqldump` command directly.

Matt 2010-05-03 12:27:55

No Issues, I found It, I just have to change the name of trigger_schema inside the mysqldump of phpmyadmin

OM The Eternity 2010-05-03 12:51:41

See Updated Question

OM The Eternity 2010-05-03 12:56:35

ansaurus

tags:

views:

answers:

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

related questions