Can you run this from inside the monitor and see if any messages are sent to the consol? \. latest_distribution.sql
-----Original Message----- From: Mike Morton To: [EMAIL PROTECTED] Sent: 8/26/04 12:05 PM Subject: Mysql command line queries not working.... I know the subject is not totally descriptive of the problem, but: mysql -h ******** -u *** -p*** mikerocks < latest_distribution.sql Is producing no results. I mean none, totally, no errors, nothing. The host, user and pass are all correct (of course removed here for security ;) ) and have the correct permissions. The latest_distribution.sql is simply a mysqldump of a database... And I have narrowed down the problem to the comments that the dump puts in there: # phpMyAdmin SQL Dump # version 2.5.6 # http://www.phpmyadmin.net Etc... Every comment in there aborts the rest of the file... Again, not with any errors, it just simply stops. Mysql on originating server: Ver 11.18 Distrib 3.23.54, for pc-linux (i686) Mysql on destination server: Ver 12.20 Distrib 4.0.13, for pc-linux (i686) Additional info: The mysqldump was created on the originating server. There is nothing strange in the mysqldump. The latest_distribution.sql works if imported as an sql query via PhpMyAdmin. I need to do this command line (part of an automated setup), so the questions are: 1. Is this a bug or some sort of setting that is messed up or something? 2. Can the mysqldump file be created without comments, as removing them every time there is a new dump will be tedious to say the least... 3. Am I a total idiot and have missed something dead simple? TIA! -- Cheers Mike Morton **************************************************** * * Tel: 905-465-1263 * Email: [EMAIL PROTECTED] * **************************************************** "Indeed, it would not be an exaggeration to describe the history of the computer industry for the past decade as a massive effort to keep up with Apple." - Byte Magazine Given infinite time, 100 monkeys could type out the complete works of Shakespeare. Win 98 source code? Eight monkeys, five minutes. -- NullGrey -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED] -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
