[CentOS] mariadb: How to delete foreign key constraint from non-existing table?

[Tony Mountifield]

In article <f7f6e8a9-5425-78f6-f49b-988ab125b7f6 at gc-24.de>,
hwilmer <hw at gc-24.de> wrote:
> 
> Hi,
> 
> somehow phpmyadmin messed things up when I was trying to modify a table. 
>   The table disappeared, and now it's impossible to re-create it:
> 
> 
> MariaDB [time]> create table etikettend_metainfo (userID integer(6) 
> unsigned, stationsnummer integer(4) unsigned, primary key (userID));
> ERROR 1005 (HY000): Can't create table `time`.`etikettend_metainfo` 
> (errno: 150 "Foreign key constraint is incorrectly formed")
> MariaDB [time]> show tables like 'etikettend%';
> +------------------------------+
> | Tables_in_time (etikettend%) |
> +------------------------------+
> | etikettend_etikettentypen    |
> | etikettend_stationen         |
> +------------------------------+
> 2 rows in set (0.001 sec)
> 
> 
> Since the table has vanished, I'm finding myself unable to remove the 
> key constraints, and trying to disable them was also unsuccessful.
> 
> It is not necessary to recover the vanished table because it had just 
> been created and was still empty anyway.
> 
> But how do I fix this?

Have a look at the troubleshooting information at:
https://mariadb.com/kb/en/library/innodb-troubleshooting-overview/

You might also find useful information in the MySQL documentation at:
https://dev.mysql.com/doc/refman/5.5/en/innodb-troubleshooting-datadict.html

Cheers
Tony
-- 
Tony Mountifield
Work: tony at softins.co.uk - http://www.softins.co.uk
Play: tony at mountifield.org - http://tony.mountifield.org