Re: source backup.sql - troubleshoot

[Dimitre Radoulov]

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