From: Dimitre Radoulov
Date: May 26 2010 10:40am
Subject: Re: source backup.sql - troubleshoot
List-Archive: http://lists.mysql.com/mysql/221709
Message-Id: <4BFCFA87.3030804@gmail.com>
MIME-Version: 1.0
Content-Type: text/plain; charset=UTF-8; format=flowed
Content-Transfer-Encoding: 7bit

On 26/05/2010 12.18, Sydney Puente wrote:

[...]
> CREATE DATABASE /*!32312 IF NOT EXISTS*/ `event` /*!40100 DEFAULT CHARACTER SET latin1 */;
>
> USE `event`;
> ....
>
> Can I have the commands being issued echo to the screen somehow, so I can identify which command is causing the problem?
> Or investigate the problem in some other way?

[...]


Not sure if this was already mentioned:


mysql --show-warnings -v -u <user> -p<pass> <db_name> < dump_file



You can use -vv  or -vvv for more verbose output.



Regards
Dimitre