Create
cancel
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for 
Search instead for 
Did you mean: 
Sign up Log in
Products
See all
Community resources
Top groups
Explore all groups
Community resources
Learn
Community resources
Events
Community resources

Confluence database can't create attachements table?

Timothy Harris
Timothy Harris June 25, 2015

A collegue of mine did a confluence upgrade that went bad. I am trying to roll back to previous version.

Steps:

  • Restore backed up HOME directory
  • Restore backed up INSTALL directory
  • Restore backed up database

 

It is going bad when trying to execute the SQL file on the database with:

ERROR 1005 (HY000) at line 1667: Can't create table 'confluence.ATTACHMENTS' (errno: 121)

Anybody have any ideas?

 

Answer
Watch
Like Be the first to like this
348 views

1 answer

1 accepted

0 votes
Answer accepted
Nic Brough -Adaptavist-
Nic Brough -Adaptavist-
Community Leader
Community Leader
Community Leaders are connectors, ambassadors, and mentors. On the online community, they serve as thought leaders, product experts, and moderators.
Become a leader
June 25, 2015

MySQL right?  Looks like your indices have gone bang.  When you "restored backed up database", did you completely drop the target first and recreate a clean empty database?

View More Comments
Timothy Harris
Timothy Harris June 29, 2015

I ended up wiping the database and recreating it then doing the import. Worked fine.

Like
Reply

Suggest an answer

Log in or Sign up to answer
Confluence
Confluence
TAGS
AUG Leaders

Atlassian Community Events

    See all events