Hi,
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
and
$ 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.
Nils