Una solucion a error 1452

Solo disponible en BuenasTareas
  • Páginas : 3 (552 palabras )
  • Descarga(s) : 0
  • Publicado : 7 de noviembre de 2011
Leer documento completo
Vista previa del texto
Una solucion a ERROR 1452 (23000): Cannot add or update a child row: a foreign key constraint fails (temp file operation failed)
[pic]
Enviado por Juan Francisco ... el Dom, 28/03/2010 - 22:52.• Foro general

Ubunto 9.10
MySQL 5.1.37-1ubuntu5.1

Al insertar datos en una tabla InnoDB me aparecio:

ERROR 1452 (23000): Cannot add or update a child row: a foreign key constraint fails (tempfile operation failed)

Asi que en una terminal edite:
sudo gedit /etc/mysql/my.cnf

y en la seccion:

#
# * InnoDB
#
# InnoDB is enabled by default with a 10MB datafile in /var/lib/mysql/.# Read the manual for more InnoDB related options. There are many!
#*** INNODB Specific options ***

agregue:

# Use this option if you have a MySQL server with InnoDB support enabled

# butyou do not plan to use it. This will save memory and disk space

# and speed up some things.

#skip-innodb

# Additional memory pool that is used by InnoDB to store metadata

# information.If InnoDB requires more memory for this purpose it will

# start to allocate it from the OS. As this is fast enough on most

# recent operating systems, you normally do not need to change this# value. SHOW INNODB STATUS will display the current amount used.

innodb_additional_mem_pool_size=2M

# If set to 1, InnoDB will flush (fsync) the transaction logs to the

# disk at eachcommit, which offers full ACID behavior. If you are

# willing to compromise this safety, and you are running small

# transactions, you may set this to 0 or 2 to reduce disk I/O to the

# logs. Value0 means that the log is only written to the log file and

# the log file flushed to disk approximately once per second. Value 2

# means the log is written to the log file at each commit, but thelog

# file is only flushed to disk approximately once per second.

innodb_flush_log_at_trx_commit=1

# The size of the buffer InnoDB uses for buffering log data. As soon as

# it is...
tracking img