MySQL Forums
Forum List  »  Newbie

MySQL 3.23.46 to MySQL 4.1.12
Posted by: Joel Eusebio
Date: July 13, 2005 10:43AM

Hi Everybody,

I am very new to MySQL. I am having problems copying a database from MySQL 4.1 to MySQL 3.23.

I did this on the 4.1 server

mysqldump databasetobecopied -u root > database.sql

I then copied database.sql to the server running MySQL 3.23 and executed:

mysql databasetobecopiedto -u root < database.sql

I keep on getting an error:

ERROR 1065 at line 6: Query was empty

line 6 on database.sql looks like this:

1 -- MySQL dump 10.9
2 --
3 -- Host: localhost Database: database
4 -- ------------------------------------------------------
5 -- Server version 4.1.12-log
6 /*!40014 SET @OLD_UNIQUE_CHECKS=@@UNIQUE_CHECKS, UNIQUE_CHECKS=0 */;
7 /*!40014 SET @OLD_FOREIGN_KEY_CHECKS=@@FOREIGN_KEY_CHECKS, FOREIGN_KEY_CHECKS=0 */;
8 /*!40101 SET @OLD_SQL_MODE=@@SQL_MODE, SQL_MODE='NO_AUTO_VALUE_ON_ZERO,MYSQL323' */;
9 /*!40111 SET @OLD_SQL_NOTES=@@SQL_NOTES, SQL_NOTES=0 */;

Any help would be greatly appreciated.

Joel

Options: ReplyQuote


Subject
Written By
Posted
MySQL 3.23.46 to MySQL 4.1.12
July 13, 2005 10:43AM


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.