Home » Performance » MySQL » Import Issue from 4.1 to 5.0
Import Issue from 4.1 to 5.0 [message #1536] Thu, 12 July 2007 20:05 Go to next message
bsdux  is currently offline bsdux
Messages: 2
Registered: December 2006
Junior Member
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=@@CHARACTER_SET_CLIENT */;
/*!40101 SET @OLD_CHARACTER_SET_RESULTS=@@CHARACTER_SET_RESULTS */;
/*!40101 SET @OLD_COLLATION_CONNECTION=@@COLLATION_CONNECTION */;
/*!40101 SET NAMES utf8 */;
/*!40014 SET @OLD_UNIQUE_CHECKS=@@UNIQUE_CHECKS, UNIQUE_CHECKS=0 */;
/*!40014 SET @OLD_FOREIGN_KEY_CHECKS=@@FOREIGN_KEY_CHECKS, FOREIGN_KEY_CHECKS=0
*/;
/*!40101 SET @OLD_SQL_MODE=@@SQL_MODE, SQL_MODE='NO_AUTO_VALUE_ON_ZERO' */;
/*!40111 SET @OLD_SQL_NOTES=@@SQL_NOTES, SQL_NOTES=0 */;
Re: Import Issue from 4.1 to 5.0 [message #1618 is a reply to message #1536 ] Thu, 16 August 2007 11:07 Go to previous message
Peter  is currently offline Peter
Messages: 405
Registered: August 2006
Senior Member
Super Guru
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.


Peter Zaitsev, MySQL Performance Expert
MySQL Performance Blog - http://www.mysqlperformanceblog.com
MySQL Consulting http://www.mysqlperformanceblog.com/mysql-consulting/
Previous Topic:MySQL database for genome expression studies
Next Topic:query condition didn't get logged in slow query log
Goto Forum:
  



Current Time: Thu Jan 8 20:04:03 EST 2009

Total time taken to generate the page: 0.00579 seconds
.:: Contact :: Home :: MySQL Support by Percona.com ::.

Powered by: FUDforum 2.7.5.
Copyright ©2001-2006 FUD Forum Bulletin Board Software

MySQL Performance | Forum authority Badge