[I searched the bug database...please let me know if I missed an already filed or fixed bug.]
I am trying to dump a database from MySQL 4.0.24 using the client tools from 5.0. Debian server, Ubutnu 6.06 client. I use this command line (watch for wrap): mysqldump -u jkugler -p -h dbserver --add-drop-database --add-locks --all --quick --lock-tables --disable-keys --create-options --comments --complete-insert -v --databases [lots of databases listed here] > mysql4dump.sql This is then piped to the mysql command like so: mysql -h dbserver -u jkugler -p -P 3307 < mysql4dump.sql Port 3307 is running MySQL 5.0.21 The first 21 lines of the dump: -- MySQL dump 10.10 -- -- Host: dbserver Database: awra_abstracts -- ------------------------------------------------------ -- Server version 4.0.24_Debian-10sarge2-log /*!40103 SET @OLD_TIME_ZONE=@@TIME_ZONE */; /*!40103 SET TIME_ZONE='+00:00' */; /*!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 */; -- -- Current Database: `awra_abstracts` -- /*!40000 DROP DATABASE IF EXISTS `awra_abstracts`;*/ CREATE DATABASE /*!32312 IF NOT EXISTS*/ `awra_abstracts`; USE `awra_abstracts`; When I run the command to import, I get this error: ERROR 1064 (42000) at line 17: 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 '*/ CREATE DATABASE /*!32312 IF NOT EXISTS*/ `awra_abstracts`' at line 1 Running /*!40000 DROP DATABASE IF EXISTS `awra_abstracts`;*/ in the mysql command line tool also produces an error. If I take out the /*!40000 and */, that command will run fine. Is this a case of mysqldump producing invalid syntax, or MySQL 5.0.21 not accepting valid syntax? For now, i can just search/replace the DROP commands and take out the comments, but it is a bit annoying. Thanks. j -- Joshua Kugler Lead System Admin -- Senior Programmer http://www.eeinternet.com PGP Key: http://pgp.mit.edu/ ID 0xDB26D7CE PO Box 80086 -- Fairbanks, AK 99708 -- Ph: 907-456-5581 Fax: 907-456-3111 -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
