phpmyadmin cannot Export procedure

Question

When I export MySQL database using phpMyAdmin it exports all the table data perfectly but does not exports PROCEDURES properly. What I got is:

DELIMITER $$
--
-- Procedures
--
DROP PROCEDURE IF EXISTS `sp_users_get`$$
$$

DROP PROCEDURE IF EXISTS `sp_users_save`$$
$$

There should be more code like

CREATE PROCEDURE `sp_user_get`......

till the procedure ends.

Can anyone help me to successfully export database from phpMyAdmin?

Answer 1

I recommend using adminer ( http://www.adminer.org/ ) as an alternative to phpmyadmin. Phpmyadmin has become really bloted and it's often buggy, slow, and hey; you even get smaller dumps with adminer!

The interface is austere, but once you get used to it it's fantastic. my 2c :)