CODEWITHSUNDEEP
mysql
Ruchi
Ruchi

Reputation: 5192

mysql restore database error in different version

i have Mysql DB dump file of MySql version 14.14 Distrib 5.1.34, for Win32 (ia32)

now i want to restore this dump file in Mysql version 14.12 Distrib 5.0.16, for Win32 (ia32)

it gives error like 

ERROR 1064 (42000) at line 278: You have an error in your SQL syntax; check the
manual that corresponds to your MySQL server version for the right syntax to use
 near 'USING BTREE,
  KEY `audit_trail_ibfk_1` (`USER_ID`) USING BTREE,
  KEY `FK_audit' at line 8

When i restore this with same version it works..

Please Suggest.

Upvotes: 0

Views: 1960

Answers (2)

Ruchi
Ruchi

Reputation: 5192

I got solution we can do same using compatible option along with mysqldump command like

mysqldump -u root --routines --compatible=mysql40 -p history < history.dump

where mysql40 is compatible with all version..

Upvotes: 2

Nishant
Nishant

Reputation: 55856

I think you have hit a MySQL bug, see the issue regarding Using BTREE when you downgrade your MySQL using mysqldump

Upvotes: 0

Related Questions