Unable to fix Roundcube

[Magistar]

Hi there, I am having some trouble using roundcube.

DATABASE ERROR: CONNECTION FAILED!

Unable to connect to the database!
Please contact your server-administrator.

In the FAQ I found instrucitons: http://help.directadmin.com/item.php?id=206

Unfortunately I am stuck at dropping the table:

mysql> DROP DATABASE da_roundcube;
ERROR 2013 (HY000): Lost connection to MySQL server during query
mysql> quit
Bye
[root@vps1 custombuild]# cd /usr/local/directadmin/custombuild
[root@vps1 custombuild]# ./build roundcube
cp: `/var/www/html/roundcube/logs' and `/var/www/html/roundcubemail-1.0.2/logs' are the same file
cp: `/var/www/html/roundcube/temp' and `/var/www/html/roundcubemail-1.0.2/temp' are the same file
Warning: Using a password on the command line interface can be insecure.
Warning: Using a password on the command line interface can be insecure.
Editing roundcube configuration...
Roundcube 1.0.2 has been installed successfully.
Executing database schema update.
Updating database schema (2013011000)... [FAILED]
ERROR: Error in DDL upgrade 2013011000: [1813] Tablespace for table '`da_roundcube`.`system`' exists. Please DISCARD the tablespace before IMPORT.[root@vps1 custombuild]

Any suggestions on how to approach this issue?

ps
I updated DA August 5th.

Regards

Update:

-I tried to delete the database through phpmyadmin: same timerout error.
-I created a NEW database, I was able to drop this database without any issues at all

>>> Something is wrong with that da_roundcube. It is locked somehow.

 

[zEitEr]

Hello,

da_roundcube is usually an InnoDB based. You might have an issue with InnoDB as it is probably corrupted.

 

[Magistar]

Alright, thanks.

I got a bit further on that error message+InnoDB. Unfortunately all topics regarding removing a corrupted InnoDB are focussed on restoring the contents. In this case I simply want to remove this specific DB. Any suggestions?

 

[zEitEr]

To rebuild InnoDB tables if other solutions don't work you may stop MySQL, move mySQL data directory to another location, and restore all the tables from dumps. That's what I did recently.

Check this http://dev.mysql.com/doc/refman/5.5/en/innodb-recovery.html for more details.

 

[Magistar]

Hello. Thanks for your fast reply .

The thing that confuses me is the tables vs database.

For this database I do not care about its contents. So the tables in this database I would not have to restore. I can restore with build roundcube. However the tables in my other dabases I do not want to delete.


So: Can I delete that specific database by deleting a certain folder, or do I have te delete everything and then re-create and import ALL databses on the system?

Thank you for your patience!

 

[zEitEr]

If playing with "innodb_force_recovery" does not help to solve the issue, I don't know any other way to fix it but rather to re-create them.

http://dev.mysql.com/doc/refman/5.5/en/forcing-innodb-recovery.html

 

[Magistar]

With some help this was fixed by re-creating the databases. Problem solved.