MySQL 3.23.46 to MySQL 4.1.12
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
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.