Custom Round Cube Database Name After Corruption

thesoundbully39

• January 11, 2015 16:32

Good evening, I have a server that wound up having some MySQL corruption due to a backup restoration issue (long story). In any case, some tables in the "roundcube" database were lost and the database had to be recreated as "roundcubenew". The old database cannot be removed because the issue is in ibdata1, so using the original name is not an option. Round cube is configured and functioning through webmail.servername.com, however it does require you to login twice. (Once at webmail login, once at round cube.) If I force a reinstall of round cube, will it be smart enough to replace the config file and maintain the new database name going forward? And, would this fix the double login issue? The reason why I am asking and not just "trying" right away is because it took a lot of work just to get to this point and I don't want to backtrack. Thankful for any advice. Tyler

• 

  cPanelMichael

  • January 12, 2015 17:03

  ]The old database cannot be removed because the issue is in ibdata1, so using the original name is not an option.

  
  Hello :) Are you sure this is the case? What issue do you encounter when attempting to remove the existing roundcube database? Thank you.

  0
• 

  thesoundbully39

  • January 14, 2015 04:28

  Hi Michael. Yes, I am sure. Attempting to remove the database results in a "MySQL dropped the connection" error. It is a data issue that stemmed from a modified /var/lib/mysql. The only way to fully resolve would be to dump everything, force recreate ibdata, and then rebuild.

  0
• 

  cPanelMichael

  • January 14, 2015 17:46

  I suggest converting Roundcube to SQLite if you are unable to remove or repair the original database name to avoid future problems:
  /usr/local/cpanel/scripts/convert_roundcube_mysql2sqlite
  Thank you.

  0

Please sign in to leave a comment.