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?
In article f7f6e8a9-5425-78f6-f49b-988ab125b7f6@gc-24.de, hwilmer hw@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
On 4/24/19 7:04 PM, Tony Mountifield wrote:
In article f7f6e8a9-5425-78f6-f49b-988ab125b7f6@gc-24.de, hwilmer hw@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
Thanks! None of all this mentions vanished tables still having constraints on them or how to drop contraints referring to tables that do not exist.
-
hwilmer -
tony＠softins.co.uk