<?xml version="1.0" encoding="utf-8"?>
<feed xmlns="http://www.w3.org/2005/Atom">
	<title type="html"><![CDATA[Форум PHP-MyAdmin.RU &mdash; Ошибка при экспорте бд]]></title>
	<link rel="self" href="https://forum.php-myadmin.ru/extern.php?action=feed&amp;tid=3206&amp;type=atom" />
	<updated>2014-02-10T11:54:29Z</updated>
	<generator>PunBB</generator>
	<id>https://forum.php-myadmin.ru/viewtopic.php?id=3206</id>
		<entry>
			<title type="html"><![CDATA[Re: Ошибка при экспорте бд]]></title>
			<link rel="alternate" href="https://forum.php-myadmin.ru/viewtopic.php?pid=24339#p24339" />
			<content type="html"><![CDATA[<p>Решил путем удаления строк &quot;ADD CONSTRAINT&quot;</p>]]></content>
			<author>
				<name><![CDATA[maggotik]]></name>
				<uri>https://forum.php-myadmin.ru/profile.php?id=5819</uri>
			</author>
			<updated>2014-02-10T11:54:29Z</updated>
			<id>https://forum.php-myadmin.ru/viewtopic.php?pid=24339#p24339</id>
		</entry>
		<entry>
			<title type="html"><![CDATA[Ошибка при экспорте бд]]></title>
			<link rel="alternate" href="https://forum.php-myadmin.ru/viewtopic.php?pid=24338#p24338" />
			<content type="html"><![CDATA[<p>Добрый день,подскажите как побороть!? при экспорте бд выдает :</p><p>Ошибка<br />SQL-запрос:</p><p>--<br />-- Ограничения внешнего ключа таблицы `elements`<br />--<br />ALTER TABLE&nbsp; `elements` ADD CONSTRAINT&nbsp; `fk_elements_languages` FOREIGN KEY (&nbsp; `id_lang` ) REFERENCES&nbsp; `languages` (&nbsp; `id` ) ON DELETE NO ACTION ON UPDATE NO ACTION ,<br />ADD CONSTRAINT&nbsp; `fk_elements_objects` FOREIGN KEY (&nbsp; `id_obj` ) REFERENCES&nbsp; `objects` (&nbsp; `id` ) ON DELETE NO ACTION ON UPDATE NO ACTION ,<br />ADD CONSTRAINT&nbsp; `fk_elements_templates` FOREIGN KEY (&nbsp; `id_tpl` ) REFERENCES&nbsp; `templates` (&nbsp; `id` ) ON DELETE NO ACTION ON UPDATE NO ACTION ,<br />ADD CONSTRAINT&nbsp; `fk_elements_types` FOREIGN KEY (&nbsp; `id_type` ) REFERENCES&nbsp; `element_types` (&nbsp; `id` ) ON DELETE NO ACTION ON UPDATE NO ACTION ,<br />ADD CONSTRAINT&nbsp; `fk_element_menu` FOREIGN KEY (&nbsp; `id_menu` ) REFERENCES&nbsp; `objects` (&nbsp; `id` ) ON DELETE SET NULL ON UPDATE CASCADE ,<br />ADD CONSTRAINT&nbsp; `fk_element_parent` FOREIGN KEY (&nbsp; `id_parent` ) REFERENCES&nbsp; `elements` (&nbsp; `id` ) ON DELETE NO ACTION ON UPDATE NO ACTION ;</p><br /><p>Ответ MySQL: Документация</p><p>#1452 - Cannot add or update a child row: a foreign key constraint fails (`patriciy`.&lt;result 2 when explaining filename &#039;#sql-57c_eda80&#039;&gt;, CONSTRAINT `fk_elements_templates` FOREIGN KEY (`id_tpl`) REFERENCES `templates` (`id`) ON DELETE NO ACTION ON UPDATE NO ACTION)</p>]]></content>
			<author>
				<name><![CDATA[maggotik]]></name>
				<uri>https://forum.php-myadmin.ru/profile.php?id=5819</uri>
			</author>
			<updated>2014-02-10T11:39:50Z</updated>
			<id>https://forum.php-myadmin.ru/viewtopic.php?pid=24338#p24338</id>
		</entry>
</feed>
