Hi, I am using the cygwin version of the mysql client. When trying to read back my dump file into the database, I get this error
------------ [EMAIL PROTECTED]:/cygdrive/c/Program Files/mysql/data 23:15$ ../bin/mysql.exe -h 10.224.3.3 -u root -p testdb -e "./zztest.sql" Enter password: ERROR 1064 at line 1: 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 './zztest.sql' at line 1 ------------ The file I am trying to read back contains the first few lines :- ------------ -- MySQL dump 10.7 -- -- Host: localhost Database: test_irt -- ------------------------------------------------------ -- Server version 4.1.3b-beta-nt-log /*!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" */; -- -- Table structure for table `tasklist` -- CREATE TABLE `tasklist` ( `id` int(10) unsigned NOT NULL auto_increment, `coreid` varchar(100) NOT NULL default '', `amtext` longtext NOT NULL, `amcolor` varchar(100) NOT NULL default '', `pmtext` longtext NOT NULL, `pmcolor` varchar(100) NOT NULL default '', `date` date NOT NULL default '0000-00-00', PRIMARY KEY (`id`,`coreid`,`date`) ); -- -- Dumping data for table `tasklist` -- INSERT INTO `tasklist` VALUES (67,'user','test','','test','','2004-12-22'); ------------------- However when I log into client and issue :- mysql> source ./zztest_irt.sql; Query OK, 0 rows affected (0.00 sec) it seem to work fine. Is there a syntax error when running the command? Thanx, Ken -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
