<?xml version="1.0" encoding="utf-8"?>
<feed xmlns="http://www.w3.org/2005/Atom">
	<title type="html"><![CDATA[Форум PHP-MyAdmin.RU &mdash; dump DB from mysql 4.0.28 to MySQL 5.1]]></title>
	<link rel="self" href="https://forum.php-myadmin.ru/extern.php?action=feed&amp;tid=828&amp;type=atom" />
	<updated>2008-06-24T13:18:33Z</updated>
	<generator>PunBB</generator>
	<id>https://forum.php-myadmin.ru/viewtopic.php?id=828</id>
		<entry>
			<title type="html"><![CDATA[Re: dump DB from mysql 4.0.28 to MySQL 5.1]]></title>
			<link rel="alternate" href="https://forum.php-myadmin.ru/viewtopic.php?pid=5402#p5402" />
			<content type="html"><![CDATA[<p><strong>freeman</strong><br />desc - это зарезервированное слово и если оно используется как имя поля, то должно быть забрано в косые кавычки.<br /></p><div class="codebox"><pre><code>`DESC` text,</code></pre></div>]]></content>
			<author>
				<name><![CDATA[Hanut]]></name>
				<uri>https://forum.php-myadmin.ru/profile.php?id=181</uri>
			</author>
			<updated>2008-06-24T13:18:33Z</updated>
			<id>https://forum.php-myadmin.ru/viewtopic.php?pid=5402#p5402</id>
		</entry>
		<entry>
			<title type="html"><![CDATA[dump DB from mysql 4.0.28 to MySQL 5.1]]></title>
			<link rel="alternate" href="https://forum.php-myadmin.ru/viewtopic.php?pid=5399#p5399" />
			<content type="html"><![CDATA[<p>Hello All!</p><p>SQL-запрос:</p><p>&nbsp; &nbsp; &nbsp; CREATE TABLE om_gallery(<br />&nbsp; &nbsp; &nbsp; id int( 12 ) NOT NULL AUTO_INCREMENT ,<br />&nbsp; &nbsp; &nbsp; identy varchar( 250 ) NOT NULL default &#039;&#039;,<br />&nbsp; &nbsp; &nbsp; name varchar( 250 ) NOT NULL default &#039;&#039;,<br />&nbsp; &nbsp; &nbsp; DESC text,<br />&nbsp; &nbsp; &nbsp; titlepages text NOT NULL ,<br />&nbsp; &nbsp; &nbsp; text mediumtext NOT NULL ,<br />&nbsp; &nbsp; &nbsp; keywords text NOT NULL ,<br />&nbsp; &nbsp; &nbsp; langchar( 2 ) NOT NULL default &#039;&#039;,<br />&nbsp; &nbsp; &nbsp; parent int( 12 ) NOT NULL default &#039;0&#039;,<br />&nbsp; &nbsp; &nbsp; prior int( 12 ) NOT NULL default &#039;0&#039;,<br />&nbsp; &nbsp; &nbsp; FIRST int( 1 ) NOT NULL default &#039;0&#039;,<br />&nbsp; &nbsp; &nbsp; url varchar( 250 ) default NULL ,<br />&nbsp; &nbsp; &nbsp; STATUS int( 1 ) NOT NULL default &#039;0&#039;,<br />&nbsp; &nbsp; &nbsp; img varchar( 200 ) default NULL ,<br />&nbsp; &nbsp; &nbsp; bottom int( 1 ) default &#039;0&#039;,<br />&nbsp; &nbsp; &nbsp; UNIQUE KEY id( id ) ,<br />&nbsp; &nbsp; &nbsp; KEY identy( identy )<br />&nbsp; &nbsp; &nbsp; ) TYPE = MYISAM ;</p><br /><br /><br /><br /><p>#1064 - You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near &#039;desc text,<br />titlepages text NOT NULL,<br />text mediumtext NOT NULL,<br />keywords te&#039; at line 5</p>]]></content>
			<author>
				<name><![CDATA[freeman]]></name>
				<uri>https://forum.php-myadmin.ru/profile.php?id=1356</uri>
			</author>
			<updated>2008-06-24T08:42:57Z</updated>
			<id>https://forum.php-myadmin.ru/viewtopic.php?pid=5399#p5399</id>
		</entry>
</feed>
