On a site where an old admin has moved all the menu items around, is there a simple way to reset the menu items to the defaults like you'd see if you installed CiviCRM fresh?


Inside the CiviCRM root directory is a "sql" folder, and inside that is "civicrm_navigation.mysql". Copy it to "civicrm_navigation_restore.sql" and edit the copy to remove all of the SQL commands EXCEPT this one: SELECT @domainID := id FROM civicrm_domain where name = 'Default Domain Name';

and any that start with INSERT INTO civicrm_navigation.

Change the SELECT @domainID line to read: SET @domainID = 1; (assuming this isn't multi-site).

Then run (after first backing up your database!) DELETE FROM civicrm_navigation.

Finally, run mysql -u myusername -pmypassword databasename < civicrm_navigation_restore.mysql.

  • Is this still the best approach to getting old sites to have the latest arrangement. Tired of having to look in multiple places in the Admin menu for Extensions ;-)
    – petednz - fuzion
    Feb 27 '18 at 20:18

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

Not the answer you're looking for? Browse other questions tagged or ask your own question.