I do not often use PHPMyAdmin, but have access to a few remote sites where it is available. I just logged into one to look at what it offers.
This one is version 4.3.8, but I have not seen many big changes in it since they broke the old good interface years ago.
Choose Export from the top option tabs, then choose Custom for Export Method. The simply check the desired little boxesuntil you get to the bottom. Along the way you will see options to include stored procedures, triggers and just about any other MySQL table and data option you can think of. Here is a text copy of the form options under Object creation options:
Code:
Object creation options
Add statements:
Add DROP TABLE / TRIGGER statement
Add CREATE TABLE statement
Add CREATE VIEW statement
Add CREATE PROCEDURE / FUNCTION / EVENT statement
Add CREATE TRIGGER statement
CREATE TABLE options:
IF NOT EXISTS
AUTO_INCREMENT
