Answers.Body: <p>The upgrade failed the first time for some reason, and all subsequent attempts on the partially upgraded database give this message. Do you have a backup of the original database? Do you know what the original error was?</p>
  
Answers.ContentLicense: CC BY-SA 3.0
Answers.CreationDate: 2015-06-05T02:00:58.460Z
Answers.Text: Hi, I have a backup and have restored it, then when i try to upgrade again, i get the same error.
Answers.UserDisplayName: joycedesign
Answers.ContentLicense: CC BY-SA 3.0
Answers.CreationDate: 2015-06-15T19:40:57.407Z
Answers.Text: Unfortunately it sounds like it was partially upgraded in the past and left in an incomplete state. You may find this page helpful: http://wiki.civicrm.org/confluence/display/CRMDOC/Ensuring+Schema+Integrity+on+Upgrades
Answers.UserDisplayName: Laryn
Answers.ContentLicense: CC BY-SA 3.0
Answers.CreationDate: 2015-05-20T12:44:01.557Z
Answers.LastActivityDate: 2015-05-20T12:44:01.557Z
Answers.UserDisplayName: Laryn
Answers.Body: <p>You say, "Ive tried a number of times but keep getting the same error message".  It's not clear whether you're reloading the backup in between attempts.</p>
  
  <p>If you are and you're still getting this message, the next step is do delete and recreate the database before reloading the backup.  Reloading a backup will replace the values in existing tables - but will NOT delete tables created when updating to 4.6.2, which is a possible cause for your error.</p>
  
  <p>To delete and recreate the database, and assuming the database name is <code>myorg_civicrm</code>...</p>
  
  <p><code>DROP DATABASE myorg_civicrm;</code></p>
  
  <p>Then create a blank database with:</p>
  
  <p><code>CREATE DATABASE myorg_civicrm;</code></p>
  
  <p>So long as the new blank database shares the same name as the deleted database, your MySQL user will have the same permissions on the new database - so just reload your dumped tables and try again!</p>
  
Answers.ContentLicense: CC BY-SA 3.0
Answers.CreationDate: 2015-06-05T02:02:57.990Z
Answers.Text: Hi, thanks for your response. Yes, i am restoring the backup between each attempt. Is there a guide on how to re-create the database?
Answers.UserDisplayName: joycedesign
Answers.ContentLicense: CC BY-SA 3.0
Answers.CreationDate: 2015-06-05T02:06:53.773Z
Answers.Text: @joycedesign I just edited my answer with details.
Answers.UserDisplayName: Jon G - Megaphone Tech
Answers.ContentLicense: CC BY-SA 3.0
Answers.CreationDate: 2015-05-20T14:29:05.503Z
Answers.LastActivityDate: 2015-06-05T02:06:35.550Z
Answers.LastEditDate: 2015-06-05T02:06:35.550Z
Answers.UserDisplayName: Jon G - Megaphone Tech
Body: <p>When i try to run the database upgrade script i get the following message:</p>
  
  <p>Database check failed - the database looks to have been partially upgraded. You may want to reload the database with the backup and try the upgrade process again.</p>
  
  <p>Ive tried a number of times but keep getting the same error message.</p>
  
Tags: <joomla><4.6.2><upgrade>
Title: Error: Database check failed when upgrading from 4.6.0 to 4.6.2
ThreadText: # Error: Database check failed when upgrading from 4.6.0 to 4.6.2
  
  (Asked by: username_0 on 2015-05-20)
  
  When i try to run the database upgrade script i get the following message:
  
  Database check failed - the database looks to have been partially upgraded. You may want to reload the database with the backup and try the upgrade process again.
  
  Ive tried a number of times but keep getting the same error message.
  
  **Tags:** joomla, 4.6.2, upgrade
  
  
  ---
  
  ## 2 answers
  
  ### Answer by username_1 on 2015-05-20. Score: 1
  
  The upgrade failed the first time for some reason, and all subsequent attempts on the partially upgraded database give this message. Do you have a backup of the original database? Do you know what the original error was?
  
  > **Comments:**
  > **username_0**: Hi, I have a backup and have restored it, then when i try to upgrade again, i get the same error.  
  > **username_1**: Unfortunately it sounds like it was partially upgraded in the past and left in an incomplete state. You may find this page helpful: http://wiki.civicrm.org/confluence/display/CRMDOC/Ensuring+Schema+Integrity+on+Upgrades  
  
  ---
  
  ### Answer by username_2 on 2015-05-20. Score: 0
  
  You say, "Ive tried a number of times but keep getting the same error message". It's not clear whether you're reloading the backup in between attempts.
  
  If you are and you're still getting this message, the next step is do delete and recreate the database before reloading the backup. Reloading a backup will replace the values in existing tables - but will NOT delete tables created when updating to 4.6.2, which is a possible cause for your error.
  
  To delete and recreate the database, and assuming the database name is `myorg_civicrm`...
  
  `DROP DATABASE myorg_civicrm;`
  
  Then create a blank database with:
  
  `CREATE DATABASE myorg_civicrm;`
  
  So long as the new blank database shares the same name as the deleted database, your MySQL user will have the same permissions on the new database - so just reload your dumped tables and try again!
  
  > **Comments:**
  > **username_0**: Hi, thanks for your response. Yes, i am restoring the backup between each attempt. Is there a guide on how to re-create the database?  
  > **username_2**: @username_0 I just edited my answer with details.  
  
  ---
  
  