Sql Dump For Just Stored Procedures?

[Simeon]

6.05 Community

In order to generate a SQL dump including my Stored Procedures, I have to select ALL tables (which activates the 5.x options).

Could the dialog be 'tweaked' to allow the dumping of JUST the stored procedures, or a subset of the tables, and the SPs? (at the moment, I have to manually delete all the tables from the dump file)

[peterlaursen]

Yes, we have similar requests. I think we will implement in the 6.1 tree.

[peterlaursen]

Actually there is a little bit silly consequence of what we are doing now!

If you have a database without a single table, but lot of ROUTINES, you cannot export anything at all. The program forces you to 'select at least one table'.

[Simeon]

peterlaursen wrote on Aug 16 2007, 08:50 PM:

Actually there is a little bit silly consequence of what we are doing now!

If you have a database without a single table, but lot of ROUTINES, you cannot export anything at all. The program forces you to 'select at least one table'.

While you're there… would it be possible to add a further check box to turn off the “DEFINER” part of the statement? I develop locally (where I have permissions to do anything) and then deploy onto a third party hosted server (where I have the bare minimum permissions) and currently I 'find and replace' the DEFINER sections to remove them.

Not a biggie, but it would be nice to have.

[peterlaursen]

An option to turn of DEFINER is a good idea when you are working with hosts when the same users do not exist!!

[Author]

Posts