CODEWITHSUNDEEP
mysqlmysql-error-1214
worldsayshi
worldsayshi

Reputation: 1991

1214 error when restoring from dump to empty database

So I'm trying to recreate my developer copy of a database. I do drop database somedb and create database somedb, so it's all empty. I exit mysql and pipe the dump file into mysql like so:

mysql -u root -pfoopassw somedb < newdumpfile.sql

Almost immediately I get the following error and the process is aborted:

ERROR 1214 (HY000) at line 99: The used table type doesn't support FULLTEXT indexes

Since I don't have a pre-existing table that can have a fulltext incompatible type, does it mean that my dump file is corrupt?

I try to alter the table type (alter table sometable ENGINE = MyISAM;) of the two tables that have been created, giving me this error:

ERROR 1217 (23000): Cannot delete or update a parent row: a foreign key constraint fails

Upvotes: 0

Views: 1358

Answers (1)

worldsayshi
worldsayshi

Reputation: 1991

I've learned that the problem is that I'm using an outdated mysql for the dump file, version 5.5 while I should be using 5.6. I will try to upgrade.

Upvotes: 1

Related Questions