Displaying 2 results from an estimated 2 matches for "datadict".
Did you mean:
datadirect
2019 Apr 24
2
mariadb: How to delete foreign key constraint from non-existing table?
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
2019 Apr 24
0
mariadb: How to delete foreign key constraint from non-existing table?
...mpty 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