MySQL Forums
Forum List  »  MyISAM

Importing database from 5.4.12 (windows) to 5.5.35 (linux), error 1214
Posted by: S.G.H. Schepens
Date: February 07, 2014 10:03AM

Hi,
I have to restore a databases (forum database) from a mysql-server 5.4.12 (windows) to a new server 5.5.35 (linux) and I get error 1214.

I try to restore the database trough ssh (only way to do this on this host,size of sql file is +/- 90MB) with the next command:
mysql -u [user] -p [databasename] < /home/database.sql

I get the following error:
ERROR 1214 (HY000) at line 4859: The used table type doesn't support FULLTEXT indexes
When I run the command:
SHOW VARIABLES
I can see that:
default_storage_engine MyISAM

What can I do to correctly import the database?

Options: ReplyQuote


Subject
Views
Written By
Posted
Importing database from 5.4.12 (windows) to 5.5.35 (linux), error 1214
3119
February 07, 2014 10:03AM


Sorry, you can't reply to this topic. It has been closed.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.