Hi,
I want to copy some databases to a new server and I have tried to backup
my databases with mysqldump in the old server, then copy those files to
the new server and recover them with mysqldump again. The problem is
that when doing,
>mysqldump -u root -p mydb < mydb_backup.sql
the message that
Fortunately I have solved this problem. I think it was something about
being a two field composed foreign key and updating these two fields at
the same time gave some kind of error.
I solve it by adding a temporary row in the referenced table with one of
the fields already changed and then updatin
Hello,
I am trying to update two fields of a table that are a composed foreign
key to another table. These fields cant be updated with this kind of
warning:
Warning | 1292 | Truncated incorrect DOUBLE value: 'A05'
Both tables are InnoDB and I have tried with all types of constraints,
ON UPDATE
