Routines not being backed up

  • bob

    bob - 2011-12-08

    Using 3.0Beta on Ubuntu server 10.04 LTS.

    have uncommented   CONFIG_mysql_dump_full_schema='yes'.

    Database is backed up, as expected, however routines and views are absent.

    Any suggestions?

  • bob

    bob - 2011-12-08

    Eventually I found the routines in the full schema files.  Is ther a better soloution than digging them out of the full schema to restore a db?

  • Anonymous - 2012-10-02

    The easiest workaround to this would be to add a section in /etc/my.cnf file that  would make mysqldump to use the -routines options by defaults.

    My section looks like this :


    Tested it on CentOS 6.3


Log in to post a comment.

Get latest updates about Open Source Projects, Conferences and News.

Sign up for the SourceForge newsletter:

No, thanks