Hello, I'm using mysql-max 3.23.49 binary distribution. I use mysqldump utility to dump tables from my DB.
for example: mysqldump --opt -u root -p EFDB users > users.sql users.sql file contains: ---------------------------------------------- -- MySQL dump 8.21 -- -- Host: localhost Database: EFDB --------------------------------------------------------- -- Server version 3.23.49-max-log -- -- Table structure for table 'users' -- DROP TABLE IF EXISTS users; CREATE TABLE users ( user_id int(10) unsigned NOT NULL auto_increment, name varchar(50) NOT NULL default '', login varchar(20) NOT NULL default '', password varchar(16) NOT NULL default '', email varchar(50) NOT NULL default '', org varchar(128) NOT NULL default '', country char(3) NOT NULL default '', description varchar(128) NOT NULL default '', PRIMARY KEY (user_id) ) TYPE=InnoDB; /*!40000 ALTER TABLE users DISABLE KEYS */; . . . INSERT follows................. ----------------------------------------------------- Now take a look at the line saying: /*!40000 ALTER TABLE users DISABLE KEYS */; This means that alter table query will be executed only if MySQL version is 4.00.00 or higher. When i try to use mysql utility to import this dumped file (mysql -u root -p EFDB < users.sql) I get the NO SQL QUERY ERROR. This is probably caused by misplaced semicolon ";" at the end of the line. In my case, alter table query is ignored because my MySQL version is 3.23.49. Then mysql utility tries to interpret ; as the end of "empty" SQL query. I think, this semicolon should be placed within the /* */ comments. What do you think? --------------------------------------------------------------------- Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
