Answers.Body: <p>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:
  <code>SELECT @domainID := id FROM civicrm_domain where name = 'Default Domain Name';</code></p>
  
  <p>and any that start with <code>INSERT INTO civicrm_navigation</code>.</p>
  
  <p>Change the <code>SELECT @domainID</code> line to read:
  <code>SET @domainID = 1;</code> (assuming this isn't multi-site).</p>
  
  <p>Then run (after first backing up your database!)
  <code>DELETE FROM civicrm_navigation</code>.</p>
  
  <p>Finally, run <code>mysql -u myusername -pmypassword databasename &lt; civicrm_navigation_restore.mysql</code>.</p>
  
Answers.ContentLicense: CC BY-SA 3.0
Answers.CreationDate: 2018-02-27T20:18:47.087Z
Answers.Text: 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 ;-)
Answers.UserDisplayName: petednz - fuzion
Answers.ContentLicense: CC BY-SA 3.0
Answers.CreationDate: 2015-03-24T16:15:45.990Z
Answers.LastActivityDate: 2015-11-06T20:18:30.453Z
Answers.LastEditDate: 2015-11-06T20:18:30.453Z
Answers.UserDisplayName: Jon G - Megaphone Tech
Body: <p>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?</p>
  
Tags: <menu><admin>
Title: How to reset the menu items to defaults
ThreadText: # How to reset the menu items to defaults
  
  (Asked by: username_0 on 2015-03-24)
  
  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?
  
  **Tags:** menu, admin
  
  
  ---
  
  ## 1 answers
  
  ### Answer by username_1 on 2015-03-24. Score: 7 | Accepted answer
  
  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`.
  
  > **Comments:**
  > **username_2**: 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 ;-)  
  
  ---
  
  