MySQL Forums
Forum List  »  Backup

Can't restore databases, Error 1214
Posted by: Nils Stec
Date: May 16, 2013 07:30AM


i have to restore some databases from an old mysql-server (5.1.46, i386) to a new server (5.5.30, amd64).

I have dumps created for each table with "mysqldump -u<user> -p<pass> --skip-opt <database> --result-file=<file>" and for all databases in one file with option "--all-databases".

On the new system I am trying to import those tables, but it does not work like excpeted...

$ mysql -u root < all.sql
$ mysql -u root <database> < database.sql
throws me an error:

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

The databases are from an old joomla-installation which has to be kept and some databases from a few web-designers, which need their dbs, so i can't easily say "use a new one...."

Hope you can help me, give a hint what to do.


Options: ReplyQuote

Written By
Can't restore databases, Error 1214
May 16, 2013 07:30AM

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.