[Klug-general] Restoring sql backups not all rows restoring

[Laurence Southon]

On 12/08/14 16:59, Dan Attwood wrote:
> innodb
>

Are you SQL'ing in externally, eg 'mysql dbname < dbname_dump.sql' ?

Does it make a difference if you do it from the MySQL console, eg

mysql> create database dbname;
mysql> use dbname:
mysql> source /path/to/dbname_dump.sql;

That gives output in the console as it writes, so maybe will show a problem?

LS
-- 
Laurence Southon
Tiger Computing, Bexley
www.tiger-computing.co.uk