# Import Issue from 4.1 to 5.0

**URL:** <https://forums.percona.com/t/import-issue-from-4-1-to-5-0/384>\
**Category:** Other MySQL® Questions\
**Created:** [July 12, 2007, 6:35pm UTC](https://forums.percona.com/t/import-issue-from-4-1-to-5-0/384 "2007-07-12T18:35:03Z")\
**Posts on this page:** 2\
**Page:** 1

<div class="post-metadata">

**Author:** ![bsdux](https://avatars.discourse-cdn.com/v4/letter/b/ed655f/32.png) [@bsdux](https://forums.percona.com/u/bsdux)\
**Post date:** [July 12, 2007, 6:35pm UTC](https://forums.percona.com/t/import-issue-from-4-1-to-5-0/384/1 "2007-07-12T18:35:03Z")

</div>

Hello, everyone.

I exported data from 4.1 and imported it to another 4.1. Everything was ok.

Then I tried to import the same 4.1 data into a 5.0 engine.  
I got these messages. No data was imported into the 5.0 engine at all.

What can I do to correct this issue?  
Thanks a lot .

/\*!40101 SET @OLD\_CHARACTER\_SET\_CLIENT=&#64;&#64;CHARACTER\_SET\_CLIENT _/;  
/_!40101 SET @OLD\_CHARACTER\_SET\_RESULTS=&#64;&#64;CHARACTER\_SET\_RESULTS _/;  
/_!40101 SET @OLD\_COLLATION\_CONNECTION=&#64;&#64;COLLATION\_CONNECTION _/;  
/_!40101 SET NAMES utf8 _/;  
/_!40014 SET @OLD\_UNIQUE\_CHECKS=&#64;&#64;UNIQUE\_CHECKS, UNIQUE\_CHECKS=0 _/;  
/_!40014 SET @OLD\_FOREIGN\_KEY\_CHECKS=&#64;&#64;FOREIGN\_KEY\_CHECKS, FOREIGN\_KEY\_CHECKS=0  
_/;  
/_!40101 SET @OLD\_SQL\_MODE=&#64;&#64;SQL\_MODE, SQL\_MODE=‘NO\_AUTO\_VALUE\_ON\_ZERO’ _/;  
/_!40111 SET @OLD\_SQL\_NOTES=&#64;&#64;SQL\_NOTES, SQL\_NOTES=0 \*/;

---

<div class="post-metadata">

**Author:** ![Peter](https://sea1.discourse-cdn.com/flex019/user_avatar/forums.percona.com/peter/32/2_2.png) [@Peter](https://forums.percona.com/u/Peter)\
**Post date:** [August 16, 2007, 9:37am UTC](https://forums.percona.com/t/import-issue-from-4-1-to-5-0/384/2 "2007-08-16T09:37:12Z")

</div>

How do you import ?

Which exactly messages do you get

What you’ve provided is part of the dump file (normal one) it is not error message.